/**
* @param Column $column
* @return $this
*/
protected function _addColumnFilterToCollection($column)
{
// Set custom filter for in category flag
if ($column->getId() == 'in_category') {
$productIds = $this->_getSelectedProducts();
if (empty($productIds)) {
$productIds = 0;
}
if ($column->getFilter()->getValue()) {
$this->getCollection()->addFieldToFilter('entity_id', ['in' => $productIds]);
} elseif (!empty($productIds)) {
$this->getCollection()->addFieldToFilter('entity_id', ['nin' => $productIds]);
}
} else {
parent::_addColumnFilterToCollection($column);
}
return $this;
}
/**
* @param Column $column
* @return $this
*/
protected function _addColumnFilterToCollection($column)
{
if ($column->getId() == 'in_role_users') {
$inRoleIds = $this->getUsers();
if (empty($inRoleIds)) {
$inRoleIds = 0;
}
if ($column->getFilter()->getValue()) {
$this->getCollection()->addFieldToFilter('user_id', ['in' => $inRoleIds]);
} else {
if ($inRoleIds) {
$this->getCollection()->addFieldToFilter('user_id', ['nin' => $inRoleIds]);
}
}
} else {
parent::_addColumnFilterToCollection($column);
}
return $this;
}
protected function _addColumnFilterToCollection($column)
{
if ($column->getId() == 'in_lists_gridtabs') {
$inlistsIds = $this->getAlists();
if (empty($inlistsIds)) {
$inlistsIds = 0;
}
if ($column->getFilter()->getValue()) {
$this->getCollection()->addFieldToFilter('id', ['in' => $inlistsIds]);
} else {
if ($inlistsIds) {
$this->getCollection()->addFieldToFilter('id', ['nin' => $inlistsIds]);
}
}
} else {
parent::_addColumnFilterToCollection($column);
}
return $this;
}
/**
* @param Column $column
* @return $this
*/
protected function _addColumnFilterToCollection($column)
{
if ($column->getId() == 'assigned_user_role') {
$userRoles = $this->getSelectedRoles();
if (empty($userRoles)) {
$userRoles = 0;
}
if ($column->getFilter()->getValue()) {
$this->getCollection()->addFieldToFilter('role_id', ['in' => $userRoles]);
} else {
if ($userRoles) {
$this->getCollection()->addFieldToFilter('role_id', ['nin' => $userRoles]);
}
}
} else {
parent::_addColumnFilterToCollection($column);
}
return $this;
}
/**
* add Column Filter To Collection
*/
protected function _addColumnFilterToCollection($column)
{
if ($column->getId() == 'in_banner') {
$bannerIds = $this->getSelectedSliderBanners();
if (empty($bannerIds)) {
$bannerIds = 0;
}
if ($column->getFilter()->getValue()) {
$this->getCollection()->addFieldToFilter('banner_id', array('in' => $bannerIds));
} else {
if ($bannerIds) {
$this->getCollection()->addFieldToFilter('banner_id', array('nin' => $bannerIds));
}
}
} else {
parent::_addColumnFilterToCollection($column);
}
return $this;
}
/**
* @param \Magento\Backend\Block\Widget\Grid\Column $column
* @return $this
*/
protected function _addColumnFilterToCollection($column)
{
if ($this->getCollection()) {
if ($column->getId() == 'websites') {
$this->getCollection()->joinField('websites', 'catalog_product_website', 'website_id', 'product_id=entity_id', null, 'left');
}
}
return parent::_addColumnFilterToCollection($column);
}
/**
* Add filter
*
* @param object $column
* @return $this
*/
protected function _addColumnFilterToCollection($column)
{
// Set custom filter for in product flag
if ($column->getId() == 'in_questions') {
$questionIds = $this->_getSelectedQuestions();
if (empty($questionIds)) {
$questionIds = 0;
}
if ($column->getFilter()->getValue()) {
$this->getCollection()->addFieldToFilter('question_id', ['in' => $questionIds]);
} else {
if ($questionIds) {
$this->getCollection()->addFieldToFilter('question_id', ['nin' => $questionIds]);
}
}
} else {
parent::_addColumnFilterToCollection($column);
}
return $this;
}
/**
* @param Column $column
* @return $this
*/
protected function _addColumnFilterToCollection($column)
{
// Set custom filter for in product flag
if ($column->getId() == 'in_products') {
$selected = $this->_getSelectedProducts();
if (empty($selected)) {
$selected = '';
}
if ($column->getFilter()->getValue()) {
$this->getCollection()->addFieldToFilter('sku', array('in' => $selected));
} else {
$this->getCollection()->addFieldToFilter('sku', array('nin' => $selected));
}
} else {
parent::_addColumnFilterToCollection($column);
}
return $this;
}
/**
* Filter checked/unchecked rows in grid
*
* @param Column $column
* @return $this
*/
protected function _addColumnFilterToCollection($column)
{
if ($column->getId() == 'in_products') {
$selected = $this->getSelectedProducts();
if ($column->getFilter()->getValue()) {
$this->getCollection()->addFieldToFilter('entity_id', ['in' => $selected]);
} else {
$this->getCollection()->addFieldToFilter('entity_id', ['nin' => $selected]);
}
} else {
parent::_addColumnFilterToCollection($column);
}
return $this;
}
/**
* @param \Magento\Backend\Block\Widget\Grid\Column $column
* @return $this
*/
protected function _addColumnFilterToCollection($column)
{
if ($column->getId() == 'in_articles') {
$articleIds = $this->_getSelectedArticles();
if (empty($articleIds)) {
$articleIds = 0;
}
if ($column->getFilter()->getValue()) {
$this->getCollection()->addFieldToFilter('article_id', ['in' => $articleIds]);
} else {
if ($articleIds) {
$this->getCollection()->addFieldToFilter('article_id', ['nin' => $articleIds]);
}
}
} else {
parent::_addColumnFilterToCollection($column);
}
return $this;
}
/**
* @param \Magento\Backend\Block\Widget\Grid\Column $column
* @return $this
*/
protected function _addColumnFilterToCollection($column)
{
if ($column->getId() == 'in_posts') {
$postIds = $this->_getSelectedPosts();
if (empty($postIds)) {
$postIds = 0;
}
if ($column->getFilter()->getValue()) {
$this->getCollection()->addFieldToFilter('main_table.post_id', ['in' => $postIds]);
} else {
if ($postIds) {
$this->getCollection()->addFieldToFilter('main_table.post_id', ['nin' => $postIds]);
}
}
} else {
parent::_addColumnFilterToCollection($column);
}
return $this;
}
/**
* Add store filter
*
* @param \Magento\Backend\Block\Widget\Grid\Column $column
* @return $this
*/
protected function _addColumnFilterToCollection($column)
{
parent::_addColumnFilterToCollection($column);
return $this;
}
