/**
* Provides additional parameters for the cache key.
*
* @return mixed boolean false|string
*
* @author Sascha Koehler <*****@*****.**>,
* Sebastian Diel <*****@*****.**>
* @since 30.08.2013
*/
public function getCacheKeyExtension()
{
$controller = Controller::curr();
if ($controller && $controller instanceof SilvercartProductGroupPage_Controller) {
$product = singleton('SilvercartProduct');
$extension = $controller->ID . '_' . SilvercartProduct::defaultSort() . '_' . $controller->getProductsPerPageSetting() . '_' . $product->getDefaultSort() . '_' . $this->getTotalNumberOfProducts();
return md5($extension);
}
return false;
}
/**
* 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;
}
/**
* Returns the cache key parts for this product group
*
* @return string
*
* @author Sebastian Diel <*****@*****.**>
* @since 15.11.2014
*/
public function CacheKeyParts()
{
if (is_null($this->cacheKeyParts)) {
$product = singleton('SilvercartProduct');
$products = $this->getProducts();
$productMapIDs = '';
$productMapLastEdited = '';
$groupIDs = '';
if ($products instanceof SS_List && $products->count() > 0) {
$productMap = $this->getProducts()->map('ID', 'LastEditedForCache')->toArray();
if (!is_array($productMap)) {
$productMap = array();
}
$productMapIDs = implode('_', array_keys($productMap));
sort($productMap);
$productMapLastEdited = array_pop($productMap);
if (Member::currentUserID() > 0) {
$groupIDs = implode('-', SilvercartCustomer::currentUser()->getGroupIDs());
}
}
$cacheKeyParts = array(i18n::get_locale(), $this->LastEdited, $productMapIDs, $productMapLastEdited, $groupIDs, $this->getProductsPerPageSetting(), $this->getSqlOffset(), SilvercartProduct::defaultSort(), SilvercartGroupViewHandler::getActiveGroupView(), $product->getDefaultSort());
$this->extend('updateCacheKeyParts', $cacheKeyParts);
$this->cacheKeyParts = $cacheKeyParts;
}
return $this->cacheKeyParts;
}
