extends \Aimeos\MShop\Locale\Manager\Base

implements \Aimeos\MShop\Locale\Manager\Iface

{

private $searchConfig = array(

'locale.id' => array(

'code' => 'locale.id',

'internalcode' => 'mloc."id"',

'label' => 'Locale ID',

'type' => 'integer',

'internaltype' => \Aimeos\MW\DB\Statement\Base::PARAM_INT,

'public' => false,

),

'locale.siteid' => array(

'code' => 'locale.siteid',

'internalcode' => 'mloc."siteid"',

'label' => 'Locale site',

'type' => 'integer',

'internaltype' => \Aimeos\MW\DB\Statement\Base::PARAM_INT,

'public' => false,

),

'locale.languageid' => array(

'code' => 'locale.languageid',

'internalcode' => 'mloc."langid"',

'label' => 'Locale language ID',

'type' => 'string',

'internaltype' => \Aimeos\MW\DB\Statement\Base::PARAM_STR,

),

'locale.currencyid' => array(

'code' => 'locale.currencyid',

'internalcode' => 'mloc."currencyid"',

'label' => 'Locale currency ID',

'type' => 'string',

'internaltype' => \Aimeos\MW\DB\Statement\Base::PARAM_STR,

),

'locale.position' => array(

'code' => 'locale.position',

'internalcode' => 'mloc."pos"',

'label' => 'Locale position',

'type' => 'integer',

'internaltype' => \Aimeos\MW\DB\Statement\Base::PARAM_INT,

),

'locale.status' => array(

'code' => 'locale.status',

'internalcode' => 'mloc."status"',

'label' => 'Locale status',

'type' => 'integer',

'internaltype' => \Aimeos\MW\DB\Statement\Base::PARAM_INT,

),

'locale.ctime'=> array(

'code'=>'locale.ctime',

'internalcode'=>'mloc."ctime"',

'label'=>'Locale create date/time',

'type'=> 'datetime',

'internaltype'=> \Aimeos\MW\DB\Statement\Base::PARAM_STR

),

'locale.mtime'=> array(

'code'=>'locale.mtime',

'internalcode'=>'mloc."mtime"',

'label'=>'Locale modification date/time',

'type'=> 'datetime',

'internaltype'=> \Aimeos\MW\DB\Statement\Base::PARAM_STR

),

'locale.editor'=> array(

'code'=>'locale.editor',

'internalcode'=>'mloc."editor"',

'label'=>'Locale editor',

'type'=> 'string',

'internaltype'=> \Aimeos\MW\DB\Statement\Base::PARAM_STR

),

);

/**

* Initializes the object.

*

* @param \Aimeos\MShop\Context\Item\Iface $context Context object

*/

public function __construct( \Aimeos\MShop\Context\Item\Iface $context )

{

parent::__construct( $context );

$this->setResourceName( 'db-locale' );

}

/**

* Returns the locale item for the given site code, language code and currency code.

*

* @param string $site Site code

* @param string $lang Language code (optional)

* @param string $currency Currency code (optional)

* @param boolean $active Flag to get only active items (optional)

* @param integer|null $level Constant from abstract class which site ID levels should be available (optional),

* based on config or value for SITE_PATH if null

* @return \Aimeos\MShop\Locale\Item\Iface Locale item for the given parameters

* @throws \Aimeos\MShop\Locale\Exception If no locale item is found

*/

public function bootstrap( $site, $lang = '', $currency = '', $active = true, $level = null )

{

$siteManager = $this->getSubManager( 'site' );

$siteSearch = $siteManager->createSearch();

$siteSearch->setConditions( $siteSearch->compare( '==', 'locale.site.code', $site ) );

$siteItems = $siteManager->searchItems( $siteSearch );

if( ( $siteItem = reset( $siteItems ) ) === false ) {

throw new \Aimeos\MShop\Locale\Exception( sprintf( 'Site for code "%1$s" not found', $site ) );

}

$siteIds = array( $siteItem->getId() );

return $this->bootstrapBase( $site, $lang, $currency, $active, $siteItem, $siteIds, $siteIds );

}

/**

* Creates a new locale item object.

*

* @return \Aimeos\MShop\Locale\Item\Iface

*/

public function createItem()

{

try {

return $this->createItemBase( array( 'locale.siteid' => $this->getContext()->getLocale()->getSiteId() ) );

} catch( \Exception $e ) {

return $this->createItemBase();

}

}

/**

* Creates a search object and sets base criteria.

*

* @param boolean $default

* @return \Aimeos\MW\Criteria\Iface

*/

public function createSearch( $default = false )

{

if( $default === true ) {

return $this->createSearchBase( 'locale' );

}

return parent::createSearch();

}

/**

* Returns the item specified by its ID.

*

* @param integer $id Unique ID of the locale item

* @param array $ref List of domains to fetch list items and referenced items for

* @return \Aimeos\MShop\Locale\Item\Iface Returns the locale item of the given id

* @throws \Aimeos\MShop\Exception If item couldn't be found

*/

public function getItem( $id, array $ref = array() )

{

return $this->getItemBase( 'locale.id', $id, $ref );

}

/**

* Searches for all items matching the given critera.

*

* @param \Aimeos\MW\Criteria\Iface $search Criteria object with conditions, sortations, etc.

* @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\Common\Item\Iface

*/

public function searchItems( \Aimeos\MW\Criteria\Iface $search, array $ref = array(), &$total = null )

{

$locale = $this->getContext()->getLocale();

$siteIds = $locale->getSitePath();

$siteIds[] = $locale->getSiteId();

$items = array();

$search = clone $search;

$expr = array(

$search->compare( '==', 'locale.siteid', $siteIds ),

$search->getConditions(),

);

$search->setConditions( $search->combine( '&&', $expr ) );

foreach( $this->search( $search, $ref, $total ) as $row ) {

$items[$row['locale.id']] = $this->createItemBase( $row );

}

return $items;

}

/**

* Removes multiple items specified by ids in the array.

*

* @param array $ids List of IDs

*/

public function deleteItems( array $ids )

{

/** mshop/locale/manager/standard/delete

* Deletes the items matched by the given IDs from the database

*

* Removes the records specified by the given IDs from the locale database.

* The records must be from the site that is configured via the

* context item.

*

* The ":cond" placeholder is replaced by the name of the ID column and

* the given ID or list of IDs while the site ID is bound to the question

* mark.

*

* 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 deleting items

* @since 2014.03

* @category Developer

* @see mshop/locale/manager/standard/insert

* @see mshop/locale/manager/standard/update

* @see mshop/locale/manager/standard/newid

* @see mshop/locale/manager/standard/search

* @see mshop/locale/manager/standard/count

*/

$path = 'mshop/locale/manager/standard/delete';

$this->deleteItemsBase( $ids, $path );

}

/**

* Adds or updates an item object.

*

* @param \Aimeos\MShop\Common\Item\Iface $item Item object whose data should be saved

* @param boolean $fetch True if the new ID should be returned in the item

*/

public function saveItem( \Aimeos\MShop\Common\Item\Iface $item, $fetch = true )

{

$iface = '\\Aimeos\\MShop\\Locale\\Item\\Iface';

if( !( $item instanceof $iface ) ) {

throw new \Aimeos\MShop\Locale\Exception( sprintf( 'Object is not of required type "%1$s"', $iface ) );

}

if( !$item->isModified() ) { return; }

$context = $this->getContext();

$dbm = $context->getDatabaseManager();

$dbname = $this->getResourceName();

$conn = $dbm->acquire( $dbname );

try

{

$id = $item->getId();

$date = date( 'Y-m-d H:i:s' );

if( $id === null )

{

/** mshop/locale/manager/standard/insert

* Inserts a new locale record into the database table

*

* Items with no ID yet (i.e. the ID is NULL) will be created in

* the database and the newly created ID retrieved afterwards

* using the "newid" SQL statement.

*

* The SQL statement must be a string suitable for being used as

* prepared statement. It must include question marks for binding

* the values from the locale item to the statement before they are

* sent to the database server. The number of question marks must

* be the same as the number of columns listed in the INSERT

* statement. The order of the columns must correspond to the

* order in the saveItems() method, so the correct values are

* bound to the columns.

*

* 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 inserting records

* @since 2014.03

* @category Developer

* @see mshop/locale/manager/standard/update

* @see mshop/locale/manager/standard/newid

* @see mshop/locale/manager/standard/delete

* @see mshop/locale/manager/standard/search

* @see mshop/locale/manager/standard/count

*/

$path = 'mshop/locale/manager/standard/insert';

}

else

{

/** mshop/locale/manager/standard/update

* Updates an existing locale record in the database

*

* Items which already have an ID (i.e. the ID is not NULL) will

* be updated in the database.

*

* The SQL statement must be a string suitable for being used as

* prepared statement. It must include question marks for binding

* the values from the locale item to the statement before they are

* sent to the database server. The order of the columns must

* correspond to the order in the saveItems() method, so the

* correct values are bound to the columns.

*

* 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 updating records

* @since 2014.03

* @category Developer

* @see mshop/locale/manager/standard/insert

* @see mshop/locale/manager/standard/newid

* @see mshop/locale/manager/standard/delete

* @see mshop/locale/manager/standard/search

* @see mshop/locale/manager/standard/count

*/

$path = 'mshop/locale/manager/standard/update';

}

$stmt = $this->getCachedStatement( $conn, $path );

$stmt->bind( 1, $item->getSiteId(), \Aimeos\MW\DB\Statement\Base::PARAM_INT );

$stmt->bind( 2, $item->getLanguageId() );

$stmt->bind( 3, $item->getCurrencyId() );

$stmt->bind( 4, $item->getPosition(), \Aimeos\MW\DB\Statement\Base::PARAM_INT );

$stmt->bind( 5, $item->getStatus(), \Aimeos\MW\DB\Statement\Base::PARAM_INT );

$stmt->bind( 6, $date ); // mtime

$stmt->bind( 7, $context->getEditor() );

if( $id !== null ) {

$stmt->bind( 8, $id, \Aimeos\MW\DB\Statement\Base::PARAM_INT );

$item->setId( $id ); //so item is no longer modified

} else {

$stmt->bind( 8, $date ); // ctime

}

$stmt->execute()->finish();

if( $id === null && $fetch === true )

{

/** mshop/locale/manager/standard/newid

* Retrieves the ID generated by the database when inserting a new record

*

* As soon as a new record is inserted into the database table,

* the database server generates a new and unique identifier for

* that record. This ID can be used for retrieving, updating and

* deleting that specific record from the table again.

*

* For MySQL:

* SELECT LAST_INSERT_ID()

* For PostgreSQL:

* SELECT currval('seq_mloc_id')

* For SQL Server:

* SELECT SCOPE_IDENTITY()

* For Oracle:

* SELECT "seq_mloc_id".CURRVAL FROM DUAL

*

* There's no way to retrive the new ID by a SQL statements that

* fits for most database servers as they implement their own

* specific way.

*

* @param string SQL statement for retrieving the last inserted record ID

* @since 2014.03

* @category Developer

* @see mshop/locale/manager/standard/insert

* @see mshop/locale/manager/standard/update

* @see mshop/locale/manager/standard/delete

* @see mshop/locale/manager/standard/search

* @see mshop/locale/manager/standard/count

*/

$path = 'mshop/locale/manager/standard/newid';

$item->setId( $this->newId( $conn, $path ) );

}

$dbm->release( $conn, $dbname );

}

catch( \Exception $e )

{

$dbm->release( $conn, $dbname );

throw $e;

}

}

/**

* Returns a new manager for locale extensions

*

* @param string $manager Name of the sub manager type in lower case

* @param string|null $name Name of the implementation, will be from configuration (or Default) if null

* @return \Aimeos\MShop\Common\Manager\Iface Manager for different extensions, e.g site, language, currency.

*/

public function getSubManager( $manager, $name = null )

{

return $this->getSubManagerBase( 'locale', $manager, $name );

}

/**

* Returns the available manager types

*

* @param boolean $withsub Return also the resource type of sub-managers if true

* @return array Type of the manager and submanagers, subtypes are separated by slashes

*/

public function getResourceType( $withsub = true )

{

$path = 'mshop/locale/manager/submanagers';

return $this->getResourceTypeBase( 'locale', $path, array( 'currency', 'language', 'site' ), $withsub );

}

/**

* Returns the attributes that can be used for searching.

*

* @param boolean $withsub Return also attributes of sub-managers if true

* @return array List of attribute items implementing \Aimeos\MW\Criteria\Attribute\Iface

*/

public function getSearchAttributes( $withsub = true )

{

/** mshop/locale/manager/submanagers

* List of manager names that can be instantiated by the locale manager

*

* Managers provide a generic interface to the underlying storage.

* Each manager has or can have sub-managers caring about particular

* aspects. Each of these sub-managers can be instantiated by its

* parent manager using the getSubManager() method.

*

* The search keys from sub-managers can be normally used in the

* manager as well. It allows you to search for items of the manager

* using the search keys of the sub-managers to further limit the

* retrieved list of items.

*

* @param array List of sub-manager names

* @since 2014.03

* @category Developer

*/

$path = 'mshop/locale/manager/submanagers';

$default = array( 'language', 'currency', 'site' );

return $this->getSearchAttributesBase( $this->searchConfig, $path, $default, $withsub );

}

/**

* Returns the locale item for the given site code, language code and currency code.

*

* If the locale item is inherited from a parent site, the site ID of this locale item

* is changed to the site ID of the actual site. This ensures that items assigned to

* the same site as the site item are still used.

*

* @param string $site Site code

* @param string $lang Language code

* @param string $currency Currency code

* @param boolean $active Flag to get only active items

* @param \Aimeos\MShop\Locale\Item\Site\Iface Site item

* @param array $sitePath List of site IDs up to the root site

* @param array $siteSubTree List of site IDs below and including the current site

* @return \Aimeos\MShop\Locale\Item\Iface Locale item for the given parameters

* @throws \Aimeos\MShop\Locale\Exception If no locale item is found

*/

protected function bootstrapBase( $site, $lang, $currency, $active,

\Aimeos\MShop\Locale\Item\Site\Iface $siteItem, array $sitePath, array $siteSubTree )

{

$siteId = $siteItem->getId();

$result = $this->bootstrapMatch( $siteId, $lang, $currency, $active, $siteItem, $sitePath, $siteSubTree );

if( $result !== false ) {

return $result;

}

$result = $this->bootstrapClosest( $siteId, $lang, $active, $siteItem, $sitePath, $siteSubTree );

if( $result !== false ) {

return $result;

}

throw new \Aimeos\MShop\Locale\Exception( sprintf( 'Locale item for site "%1$s" not found', $site ) );

}

/**

* Returns the matching locale item for the given site code, language code and currency code.

*

* If the locale item is inherited from a parent site, the site ID of this locale item

* is changed to the site ID of the actual site. This ensures that items assigned to

* the same site as the site item are still used.

*

* @param string $siteId Site ID

* @param string $lang Language code

* @param string $currency Currency code

* @param boolean $active Flag to get only active items

* @param \Aimeos\MShop\Locale\Item\Site\Iface Site item

* @param array $sitePath List of site IDs up to the root site

* @param array $siteSubTree List of site IDs below and including the current site

* @return \Aimeos\MShop\Locale\Item\Iface|boolean Locale item for the given parameters or false if no item was found

*/

private function bootstrapMatch( $siteId, $lang, $currency, $active,

\Aimeos\MShop\Locale\Item\Site\Iface $siteItem, array $sitePath, array $siteSubTree )

{

// Try to find exact match

$search = $this->createSearch( $active );

$expr = array( $search->compare( '==', 'locale.siteid', $sitePath ) );

if( !empty( $lang ) ) {

$expr[] = $search->compare( '==', 'locale.languageid', $lang );

}

if( !empty( $currency ) ) {

$expr[] = $search->compare( '==', 'locale.currencyid', $currency );

}

$expr[] = $search->getConditions();

if( $active === true )

{

$expr[] = $search->compare( '>', 'locale.currency.status', 0 );

$expr[] = $search->compare( '>', 'locale.language.status', 0 );

$expr[] = $search->compare( '>', 'locale.site.status', 0 );

}

$search->setConditions( $search->combine( '&&', $expr ) );

$result = $this->search( $search );

// Try to find first item where site matches

foreach( $result as $row )

{

if( $row['locale.siteid'] == $siteId ) {

return $this->createItemBase( $row, $siteItem, $sitePath, $siteSubTree );

}

}

if( ( $row = reset( $result ) ) !== false )

{

$row['locale.siteid'] = $siteId;

return $this->createItemBase( $row, $siteItem, $sitePath, $siteSubTree );

}

return false;

}

/**

* Returns the locale item for the given site code, language code and currency code.

*

* If the locale item is inherited from a parent site, the site ID of this locale item

* is changed to the site ID of the actual site. This ensures that items assigned to

* the same site as the site item are still used.

*

* @param string $siteId Site ID

* @param string $lang Language code

* @param boolean $active Flag to get only active items

* @param \Aimeos\MShop\Locale\Item\Site\Iface Site item

* @param array $sitePath List of site IDs up to the root site

* @param array $siteSubTree List of site IDs below and including the current site

* @return \Aimeos\MShop\Locale\Item\Iface|boolean Locale item for the given parameters or false if no item was found

*/

private function bootstrapClosest( $siteId, $lang, $active,

\Aimeos\MShop\Locale\Item\Site\Iface $siteItem, array $sitePath, array $siteSubTree )

{

// Try to find the best matching locale

$search = $this->createSearch( $active );

$expr = array(

$search->compare( '==', 'locale.siteid', $sitePath ),

$search->getConditions()

);

if( $active === true )

{

$expr[] = $search->compare( '>', 'locale.currency.status', 0 );

$expr[] = $search->compare( '>', 'locale.language.status', 0 );

$expr[] = $search->compare( '>', 'locale.site.status', 0 );

}

$search->setConditions( $search->combine( '&&', $expr ) );

$search->setSortations( array( $search->sort( '+', 'locale.position' ) ) );

$result = $this->search( $search );

// Try to find first item where site and language matches

foreach( $result as $row )

{

if( $row['locale.siteid'] == $siteId && $row['locale.languageid'] == $lang ) {

return $this->createItemBase( $row, $siteItem, $sitePath, $siteSubTree );

}

}

// Try to find first item where language matches

foreach( $result as $row )

{

if( $row['locale.languageid'] == $lang )

{

$row['locale.siteid'] = $siteId;

return $this->createItemBase( $row, $siteItem, $sitePath, $siteSubTree );

}

}

// Try to find first item where site matches

foreach( $result as $row )

{

if( $row['locale.siteid'] == $siteId ) {

return $this->createItemBase( $row, $siteItem, $sitePath, $siteSubTree );

}

}

// Return first item (no other match found)

if( ( $row = reset( $result ) ) !== false )

{

$row['locale.siteid'] = $siteId;

return $this->createItemBase( $row, $siteItem, $sitePath, $siteSubTree );

}

return false;

}

/**

* Instances a new locale item object.

*

* @param array $values Parameter to initialise the item

* @param \Aimeos\MShop\Locale\Item\Site\Iface $site Site item

* @param array $sitePath List of site IDs up to the root site

* @param array $siteSubTree List of site IDs below and including the current site

* @return \Aimeos\MShop\Locale\Item\Standard Locale item

*/

protected function createItemBase( array $values = array( ), \Aimeos\MShop\Locale\Item\Site\Iface $site = null,

array $sitePath = array(), array $siteSubTree = array() )

{

return new \Aimeos\MShop\Locale\Item\Standard( $values, $site, $sitePath, $siteSubTree );

}

/**

* Returns the search results for the given SQL statement.

*

* @param \Aimeos\MW\DB\Connection\Iface $conn Database connection

* @param $sql SQL statement

* @return \Aimeos\MW\DB\Result\Iface Search result object

*/

protected function getSearchResults( \Aimeos\MW\DB\Connection\Iface $conn, $sql )

{

$stmt = $conn->create( $sql );

$this->getContext()->getLogger()->log( __METHOD__ . ': SQL statement: ' . $stmt, \Aimeos\MW\Logger\Base::DEBUG );

return $stmt->execute();

}

/**

* Searches for all items matching the given critera.

*

* @param \Aimeos\MW\Criteria\Iface $search Criteria object with conditions, sortations, etc.

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

$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/standard/search

* 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

* @see mshop/locale/manager/standard/update

* @see mshop/locale/manager/standard/newid

* @see mshop/locale/manager/standard/delete

* @see mshop/locale/manager/standard/count

*/

$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

* 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

* @see mshop/locale/manager/standard/update

* @see mshop/locale/manager/standard/newid

* @see mshop/locale/manager/standard/delete

* @see mshop/locale/manager/standard/search

*/

$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;

}