|
private addIsVisibleInStoreFilter ( Zend_Db_Select $select, integer $storeId ) : |
||
| $select | Zend_Db_Select | Product select to be filtered. |
| $storeId | integer | Store Id |
| return | Self Reference | |
private function addIsVisibleInStoreFilter($select, $storeId)
{
$rootCategoryId = $this->getRootCategoryId($storeId);
$indexTable = $this->getTable('catalog_category_product_index');
$visibilityJoinCond = $this->getConnection()->quoteInto('visibility.product_id = e.entity_id AND visibility.store_id = ?', $storeId);
$select->useStraightJoin(true)->join(['visibility' => $indexTable], $visibilityJoinCond, ['visibility'])->where('visibility.category_id = ?', (int) $rootCategoryId);
return $this;
}