/** * Returns a sorted list of required criteria keys. * * @param \Aimeos\MW\Criteria\Iface $criteria Search criteria object * @param string[] $required List of prefixes of required search conditions * @return string[] Sorted list of criteria keys */ protected function getCriteriaKeyList(\Aimeos\MW\Criteria\Iface $criteria, array $required) { $keys = array_merge($required, $this->getCriteriaKeys($required, $criteria->getConditions())); foreach ($criteria->getSortations() as $sortation) { $keys = array_merge($keys, $this->getCriteriaKeys($required, $sortation)); } $keys = array_unique(array_merge($required, $keys)); sort($keys); return $keys; }
/** * Initializes the criteria object with sortations based on the given parameter. * * @param \Aimeos\MW\Criteria\Iface $criteria Criteria object * @param \stdClass $params Object that may contain the properties "condition", "sort", "dir", "start" and "limit" */ private function initCriteriaSortations(\Aimeos\MW\Criteria\Iface $criteria, \stdClass $params) { if (isset($params->sort) && isset($params->dir)) { $sortation = array(); switch ($params->dir) { case 'ASC': $sortation[] = $criteria->sort('+', $params->sort); break; case 'DESC': $sortation[] = $criteria->sort('-', $params->sort); break; default: throw new \Aimeos\Controller\ExtJS\Exception(sprintf('Invalid sort direction "%1$s"', $params->sort)); } $criteria->setSortations($sortation); } if ($this->sort !== null) { $sort = $criteria->getSortations(); $sort[] = $criteria->sort('+', $this->sort); $criteria->setSortations($sort); } }
/** * Searches for all items matching the given critera. * * @param \Aimeos\MW\Criteria\Iface $search Criteria object with conditions, sortations, etc. * @param string[] $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\Common\Item\Iface */ protected function search(\Aimeos\MW\Criteria\Iface $search, array $ref = array(), &$total = null) { $context = $this->getContext(); $dbm = $context->getDatabaseManager(); $dbname = $this->getResourceName(); $conn = $dbm->acquire($dbname); $items = array(); 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/standard/search/mysql * Retrieves the records matched by the given criteria in the database * * @see mshop/locale/manager/standard/search/ansi */ /** mshop/locale/manager/standard/search/ansi * Retrieves the records matched by the given criteria in the database * * Fetches the records matched by the given criteria from the locale * 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. * * 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/standard/insert/ansi * @see mshop/locale/manager/standard/update/ansi * @see mshop/locale/manager/standard/newid/ansi * @see mshop/locale/manager/standard/delete/ansi * @see mshop/locale/manager/standard/count/ansi */ $path = 'mshop/locale/manager/standard/search'; $sql = $this->getSqlConfig($path); $results = $this->getSearchResults($conn, str_replace($find, $replace, $sql)); try { while (($row = $results->fetch()) !== false) { $items[$row['locale.id']] = $row; } } catch (\Exception $e) { $results->finish(); throw $e; } if ($total !== null) { /** mshop/locale/manager/standard/count/mysql * Counts the number of records matched by the given criteria in the database * * @see mshop/locale/manager/standard/count/ansi */ /** mshop/locale/manager/standard/count/ansi * Counts the number of records matched by the given criteria in the database * * Counts all records matched by the given criteria from the locale * 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. * * 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/standard/insert/ansi * @see mshop/locale/manager/standard/update/ansi * @see mshop/locale/manager/standard/newid/ansi * @see mshop/locale/manager/standard/delete/ansi * @see mshop/locale/manager/standard/search/ansi */ $path = 'mshop/locale/manager/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(sprintf('Total results value not 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; }