/** * Re-writes the index entries for all products that are search result of given criteria * * @param \Aimeos\MW\Criteria\Iface $search Search criteria * @param array $domains List of domains to be * @param integer $size Size of a chunk of products to handle at a time */ protected function writeIndex(\Aimeos\MW\Criteria\Iface $search, array $domains, $size) { $manager = \Aimeos\MShop\Factory::createManager($this->getContext(), 'product'); $submanagers = $this->getSubManagers(); $start = 0; do { $search->setSlice($start, $size); $products = $manager->searchItems($search, $domains); $prodIds = array_keys($products); try { $this->begin(); $this->deleteItems($prodIds); foreach ($submanagers as $submanager) { $submanager->rebuildIndex($products); } $this->saveSubProducts($products); $this->commit(); } catch (\Exception $e) { $this->rollback(); throw $e; } $this->clearCache($prodIds); $count = count($products); $start += $count; } while ($count == $search->getSliceSize()); }
/** * Search for currency items matching the given criteria. * * @param \Aimeos\MW\Criteria\Iface $search Search object * @param array $ref List of domains to fetch list items and referenced items for * @param integer &$total Number of items that are available in total * @return array List of items implementing \Aimeos\MShop\Locale\Item\Currency\Iface */ public function searchItems(\Aimeos\MW\Criteria\Iface $search, array $ref = array(), &$total = null) { $context = $this->getContext(); $config = $context->getConfig(); $dbm = $context->getDatabaseManager(); $dbname = $this->getResourceName(); $conn = $dbm->acquire($dbname); $items = array(); try { $attributes = $this->getSearchAttributes(); $types = $this->getSearchTypes($attributes); $translations = $this->getSearchTranslations($attributes); $find = array(':cond', ':order', ':start', ':size'); $replace = array($search->getConditionString($types, $translations), $search->getSortationString($types, $translations), $search->getSliceStart(), $search->getSliceSize()); /** mshop/locale/manager/currency/standard/search * Retrieves the records matched by the given criteria in the database * * Fetches the records matched by the given criteria from the attribute * database. The records must be from one of the sites that are * configured via the context item. If the current site is part of * a tree of sites, the SELECT statement can retrieve all records * from the current site and the complete sub-tree of sites. * * As the records can normally be limited by criteria from sub-managers, * their tables must be joined in the SQL context. This is done by * using the "internaldeps" property from the definition of the ID * column of the sub-managers. These internal dependencies specify * the JOIN between the tables and the used columns for joining. The * ":joins" placeholder is then replaced by the JOIN strings from * the sub-managers. * * To limit the records matched, conditions can be added to the given * criteria object. It can contain comparisons like column names that * must match specific values which can be combined by AND, OR or NOT * operators. The resulting string of SQL conditions replaces the * ":cond" placeholder before the statement is sent to the database * server. * * If the records that are retrieved should be ordered by one or more * columns, the generated string of column / sort direction pairs * replaces the ":order" placeholder. In case no ordering is required, * the complete ORDER BY part including the "\/*-orderby*\/...\/*orderby-*\/" * markers is removed to speed up retrieving the records. Columns of * sub-managers can also be used for ordering the result set but then * no index can be used. * * The number of returned records can be limited and can start at any * number between the begining and the end of the result set. For that * the ":size" and ":start" placeholders are replaced by the * corresponding values from the criteria object. The default values * are 0 for the start and 100 for the size value. * * The SQL statement should conform to the ANSI standard to be * compatible with most relational database systems. This also * includes using double quotes for table and column names. * * @param string SQL statement for searching items * @since 2014.03 * @category Developer * @see mshop/locale/manager/currency/standard/insert * @see mshop/locale/manager/currency/standard/update * @see mshop/locale/manager/currency/standard/delete * @see mshop/locale/manager/currency/standard/count */ $path = 'mshop/locale/manager/currency/standard/search'; $sql = $this->getSqlConfig($path); $results = $this->getSearchResults($conn, str_replace($find, $replace, $sql)); try { while (($row = $results->fetch()) !== false) { $items[$row['locale.currency.id']] = $this->createItemBase($row); } } catch (\Exception $e) { $results->finish(); throw $e; } if ($total !== null) { /** mshop/locale/manager/currency/standard/count * Counts the number of records matched by the given criteria in the database * * Counts all records matched by the given criteria from the attribute * database. The records must be from one of the sites that are * configured via the context item. If the current site is part of * a tree of sites, the statement can count all records from the * current site and the complete sub-tree of sites. * * As the records can normally be limited by criteria from sub-managers, * their tables must be joined in the SQL context. This is done by * using the "internaldeps" property from the definition of the ID * column of the sub-managers. These internal dependencies specify * the JOIN between the tables and the used columns for joining. The * ":joins" placeholder is then replaced by the JOIN strings from * the sub-managers. * * To limit the records matched, conditions can be added to the given * criteria object. It can contain comparisons like column names that * must match specific values which can be combined by AND, OR or NOT * operators. The resulting string of SQL conditions replaces the * ":cond" placeholder before the statement is sent to the database * server. * * Both, the strings for ":joins" and for ":cond" are the same as for * the "search" SQL statement. * * Contrary to the "search" statement, it doesn't return any records * but instead the number of records that have been found. As counting * thousands of records can be a long running task, the maximum number * of counted records is limited for performance reasons. * * The SQL statement should conform to the ANSI standard to be * compatible with most relational database systems. This also * includes using double quotes for table and column names. * * @param string SQL statement for counting items * @since 2014.03 * @category Developer * @see mshop/locale/manager/currency/standard/insert * @see mshop/locale/manager/currency/standard/update * @see mshop/locale/manager/currency/standard/delete * @see mshop/locale/manager/currency/standard/search */ $path = 'mshop/locale/manager/currency/standard/count'; $sql = $this->getSqlConfig($path); $results = $this->getSearchResults($conn, str_replace($find, $replace, $sql)); $row = $results->fetch(); $results->finish(); if ($row === false) { throw new \Aimeos\MShop\Locale\Exception('No total results value found'); } $total = $row['count']; } $dbm->release($conn, $dbname); } catch (\Exception $e) { $dbm->release($conn, $dbname); throw $e; } return $items; }
/** * Searches for site items matching the given criteria. * * @param \Aimeos\MW\Criteria\Iface $search Search criteria object * @param string[] $ref List of domains to fetch list items and referenced items for * @param integer|null &$total Number of items that are available in total * @return array List of site items implementing \Aimeos\MShop\Locale\Item\Site\Iface */ public function searchItems(\Aimeos\MW\Criteria\Iface $search, array $ref = array(), &$total = null) { $items = array(); $context = $this->getContext(); $dbm = $context->getDatabaseManager(); $dbname = $this->getResourceName(); $conn = $dbm->acquire($dbname); try { $attributes = $this->getSearchAttributes(); $types = $this->getSearchTypes($attributes); $translations = $this->getSearchTranslations($attributes); $columns = $search->getColumnString($search->getSortations(), $translations); $find = array(':cond', ':order', ':columns', ':start', ':size'); $replace = array($search->getConditionString($types, $translations), $search->getSortationString($types, $translations), $columns ? ', ' . $columns : '', $search->getSliceStart(), $search->getSliceSize()); /** mshop/locale/manager/site/standard/search/mysql * Retrieves the records matched by the given criteria in the database * * @see mshop/locale/manager/site/standard/search/ansi */ /** mshop/locale/manager/site/standard/search/ansi * Retrieves the records matched by the given criteria in the database * * Fetches the records matched by the given criteria from the attribute * database. The records must be from one of the sites that are * configured via the context item. If the current site is part of * a tree of sites, the SELECT statement can retrieve all records * from the current site and the complete sub-tree of sites. * * As the records can normally be limited by criteria from sub-managers, * their tables must be joined in the SQL context. This is done by * using the "internaldeps" property from the definition of the ID * column of the sub-managers. These internal dependencies specify * the JOIN between the tables and the used columns for joining. The * ":joins" placeholder is then replaced by the JOIN strings from * the sub-managers. * * To limit the records matched, conditions can be added to the given * criteria object. It can contain comparisons like column names that * must match specific values which can be combined by AND, OR or NOT * operators. The resulting string of SQL conditions replaces the * ":cond" placeholder before the statement is sent to the database * server. * * If the records that are retrieved should be ordered by one or more * columns, the generated string of column / sort direction pairs * replaces the ":order" placeholder. In case no ordering is required, * the complete ORDER BY part including the "\/*-orderby*\/...\/*orderby-*\/" * markers is removed to speed up retrieving the records. Columns of * sub-managers can also be used for ordering the result set but then * no index can be used. * * The number of returned records can be limited and can start at any * number between the begining and the end of the result set. For that * the ":size" and ":start" placeholders are replaced by the * corresponding values from the criteria object. The default values * are 0 for the start and 100 for the size value. * * The SQL statement should conform to the ANSI standard to be * compatible with most relational database systems. This also * includes using double quotes for table and column names. * * @param string SQL statement for searching items * @since 2014.03 * @category Developer * @see mshop/locale/manager/site/standard/insert/ansi * @see mshop/locale/manager/site/standard/update/ansi * @see mshop/locale/manager/site/standard/delete/ansi * @see mshop/locale/manager/site/standard/count/ansi * @see mshop/locale/manager/site/standard/newid/ansi */ $path = 'mshop/locale/manager/site/standard/search'; $sql = $this->getSqlConfig($path); $results = $this->getSearchResults($conn, str_replace($find, $replace, $sql)); try { while (($row = $results->fetch()) !== false) { $config = $row['locale.site.config']; if (($row['locale.site.config'] = json_decode($row['locale.site.config'], true)) === null) { $msg = sprintf('Invalid JSON as result of search for ID "%2$s" in "%1$s": %3$s', 'mshop_locale.config', $row['locale.site.id'], $config); $this->getContext()->getLogger()->log($msg, \Aimeos\MW\Logger\Base::WARN); } $items[$row['locale.site.id']] = $this->createItemBase($row); } } catch (\Exception $e) { $results->finish(); throw $e; } if ($total !== null) { $total = $this->getTotal($conn, $find, $replace); } $dbm->release($conn, $dbname); } catch (\Exception $e) { $dbm->release($conn, $dbname); throw $e; } return $items; }