public function getSearchedProductIds($searchTerm){
//$searchTerm = "UKF8001";
$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$searchCriteriaBuilder = $objectManager->create('Magento\Framework\Api\Search\SearchCriteriaFactory');
$filterBuilder = $objectManager->create('Magento\Framework\Api\FilterBuilder');
$filterGroupBuilder = $objectManager->create('Magento\Framework\Api\Search\FilterGroupBuilder');
$searchInterface = $objectManager->create('Magento\Framework\Api\Search\SearchInterface');
$sortOrder = $objectManager->create('Magento\Framework\Api\SortOrder');
$search_criteria = $searchCriteriaBuilder->create();
$search_criteria->setRequestName("quick_search_container");
$filter = $filterBuilder->setField('search_term')
->setValue($searchTerm)
->setConditionType("like")
->create();
$filterGroup = $filterGroupBuilder->addFilter($filter)->create();
$searchDirection = "desc";
$page =1;
//$searchDirection = ($searchDir == "desc") ? SortOrder::SORT_DESC : SortOrder::SORT_ASC;
$sortOrder->setField('name');
$sortOrder->setDirection($searchDirection);
$search_criteria->setFilterGroups([$filterGroup])
->setCurrentPage($page);
$search_criteria->setSortOrders([$sortOrder]);
$resultx = $searchInterface->search($search_criteria);
$totalSearchResults = $resultx->getTotalCount();
$products = $resultx->getItems();
$result = [];
foreach ($products as $product) {
$result[] = $product->getId();
}
return $result;
}
<?php /* * * TO Execute Multiple Raw Query In Magento 2 * * */ $objectManager = \Magento\Framework\App\ObjectManager::getInstance(); $resource = $objectManager->get('Magento\Framework\App\ResourceConnection'); $conn = $resource->getConnection('write'); $sqlScript = file($sqlFile); $query = ''; foreach ($sqlScript as $line) { $startWith = substr(trim($line), 0 ,2); $endWith = substr(trim($line), -1 ,1); if (empty($line) || $startWith == '--' || $startWith == '/*' || $startWith == '//') continue; $query = $query . $line; if ($endWith == ';') { $conn->query($query); $query= ''; } } echo '<div class="success-response sql-import-response">SQL file imported successfully</div>';
Comments
Post a Comment