/** * Apply custom filtering * * @return void */ protected function _renderFiltersBefore() { if (!$this->getLoadDefault()) { $this->getSelect()->where('main_table.website_id > ?', 0); } parent::_renderFiltersBefore(); }
/** * Join store relation table if there is store filter * * @return void */ protected function _renderFiltersBefore() { if ($this->getFilter('store')) { $this->getSelect()->join(['store_table' => $this->getTable('cms_page_store')], 'main_table.page_id = store_table.page_id', [])->group('main_table.page_id'); } parent::_renderFiltersBefore(); }
protected function _renderFiltersBefore() { parent::_renderFiltersBefore(); }
/** * Join store relation table if there is store filter * * @return void */ protected function _renderFiltersBefore() { if ($this->getFilter('store')) { $this->getSelect()->join(array('store_table' => $this->getTable('cms_block_store')), 'main_table.block_id = store_table.block_id', array())->group('main_table.block_id'); } return parent::_renderFiltersBefore(); }
/** * Join store relation table if there is store filter * * @param string $tableName * @param string $columnName * @return void */ protected function joinStoreRelationTable($tableName, $columnName) { if ($this->getFilter('store')) { $this->getSelect()->join(['store_table' => $this->getTable($tableName)], 'main_table.' . $columnName . ' = store_table.' . $columnName, [])->group('main_table.' . $columnName); } parent::_renderFiltersBefore(); }