/**
* 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());
}
}
