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