/** * Builds the DataObject of filtered products * * @return DataList * * @author Sebastian Diel <sdiel@Ï€ixeltricks.de> * @since 23.09.2014 */ public function buildSearchResultProducts() { $searchResultProducts = $this->searchResultProducts; $productsPerPage = $this->getProductsPerPageSetting(); $SQL_start = $this->getSqlOffset(); $searchQuery = $this->getSearchQuery(); $searchTerms = explode(' ', $searchQuery); $filter = ''; $useExtensionResults = $this->extend('updateSearchResult', $searchResultProducts, $searchQuery, $SQL_start); if (empty($useExtensionResults)) { $this->listFilters['original'] = sprintf(' "SilvercartProduct"."SilvercartProductGroupID" IS NOT NULL AND "SilvercartProduct"."SilvercartProductGroupID" > 0 AND "SPGPL"."ID" > 0 AND "SilvercartProduct"."isActive" = 1 AND ( ( "SilvercartProductLanguage"."Title" LIKE \'%s%%\' OR "SilvercartProductLanguage"."ShortDescription" LIKE \'%s%%\' OR "SilvercartProductLanguage"."LongDescription" LIKE \'%s%%\' OR "SilvercartProductLanguage"."Title" LIKE \'%%%s%%\' OR "SilvercartProductLanguage"."ShortDescription" LIKE \'%%%s%%\' OR "SilvercartProductLanguage"."LongDescription" LIKE \'%%%s%%\' ) OR "SilvercartProductLanguage"."MetaKeywords" LIKE \'%%%s%%\' OR "SilvercartProduct"."ProductNumberShop" LIKE \'%%%s%%\' OR "SilvercartProduct"."EANCode" LIKE \'%%%s%%\' OR STRCMP( SOUNDEX("SilvercartProductLanguage"."Title"), SOUNDEX(\'%s\') ) = 0 ) ', $searchQuery, $searchQuery, $searchQuery, $searchQuery, $searchQuery, $searchQuery, $searchQuery, $searchQuery, $searchQuery, $searchQuery); if (count(self::$registeredFilterPlugins) > 0) { foreach (self::$registeredFilterPlugins as $registeredPlugin) { $pluginFilters = $registeredPlugin->filter(); if (is_array($pluginFilters)) { $this->listFilters = array_merge($this->listFilters, $pluginFilters); } } } $this->extend('updateListFilters', $this->listFilters, $searchTerms); foreach ($this->listFilters as $listFilter) { if (empty($filter)) { $filter = $listFilter; } else { if (strpos(trim($listFilter), 'AND') !== 0 && strpos(trim($listFilter), 'OR') !== 0) { $listFilter = 'AND ' . $listFilter; } $filter = '(' . $filter . ') ' . $listFilter; } } if (SilvercartProduct::defaultSort() == 'relevance') { $sort = ''; } else { $sort = SilvercartProduct::defaultSort(); } $searchResultProductsRaw = SilvercartProduct::getProducts($filter, $sort, array(array('table' => 'SilvercartProductGroupPage_Live', 'on' => '"SPGPL"."ID" = "SilvercartProduct"."SilvercartProductGroupID"', 'alias' => 'SPGPL'))); $searchResultProducts = new PaginatedList($searchResultProductsRaw, $this->getRequest()); $searchResultProducts->setPageStart($SQL_start); $searchResultProducts->setPageLength($productsPerPage); } $this->searchResultProducts = $searchResultProducts; $this->totalNumberOfProducts = $searchResultProducts->count(); $searchQueryObject = SilvercartSearchQuery::get_by_query(Convert::raw2sql($searchQuery)); if ($searchQueryObject->Hits != $this->totalNumberOfProducts) { $searchQueryObject->Hits = $this->totalNumberOfProducts; $searchQueryObject->write(); } return $this->searchResultProducts; }
/** * Action to execute a search query * * @param SS_HTTPRequest $request Request to check for product data * @param bool $doRedirect Redirect after setting search settings? * * @return void * * @author Sebastian Diel <*****@*****.**> * @since 30.06.2014 */ public function doSearch(SS_HTTPRequest $request, $doRedirect = true) { $postVars = $request->postVars(); if (!array_key_exists('locale', $postVars) || empty($postVars['locale'])) { $postVars['locale'] = Translatable::default_locale(); } Translatable::set_current_locale($postVars['locale']); i18n::set_locale($postVars['locale']); $quickSearchQuery = trim($postVars['quickSearchQuery']); $searchContext = 'SilvercartProduct'; $searchResultsPage = SilvercartTools::PageByIdentifierCode("SilvercartSearchResultsPage"); $searchQuery = SilvercartSearchQuery::get_by_query(trim(Convert::raw2sql($quickSearchQuery))); $searchQuery->Count++; $searchQuery->write(); SilvercartProduct::setDefaultSort('relevance'); Session::set("searchQuery", $quickSearchQuery); Session::set('searchContext', $searchContext); Session::save(); if ($doRedirect) { $this->owner->redirect($searchResultsPage->RelativeLink()); } }