| public getSearchableCategories ( integer $storeId, string $categoryIds = null, integer $fromId, integer $limit = 100 ) : array | ||
| $storeId | integer | Store id. |
| $categoryIds | string | Product ids filter. |
| $fromId | integer | Load product with id greater than. |
| $limit | integer | Number of product to get loaded. |
| Результат | array | |
public function getSearchableCategories($storeId, $categoryIds = null, $fromId = 0, $limit = 100)
{
$select = $this->getConnection()->select()->from(['e' => $this->getTable('catalog_category_entity')]);
$this->addIsVisibleInStoreFilter($select, $storeId);
if ($categoryIds !== null) {
$select->where('e.entity_id IN (?)', $categoryIds);
}
$select->where('e.entity_id > ?', $fromId)->limit($limit)->order('e.entity_id');
return $this->connection->fetchAll($select);
}