/** * Filter number of customers column * * @param Mage_Adminhtml_Block_Widget_Grid_Column $column * @return Enterprise_CustomerSegment_Block_Adminhtml_Report_Customer_Segment_Grid */ protected function _addColumnFilterToCollection($column) { if ($column->getId() == 'customer_count') { if ($column->getFilter()->getValue() !== null) { $this->getCollection()->addCustomerCountFilter($column->getFilter()->getValue()); } } else { parent::_addColumnFilterToCollection($column); } return $this; }
/** * Add custom column filter to collection * * @param Mage_Adminhtml_Block_Widget_Grid_Column $column * @return Mage_Api2_Block_Adminhtml_Permissions_User_Edit_Tab_Roles */ protected function _addColumnFilterToCollection($column) { if ($column->getId() == 'assigned_user_role') { $userRoles = $this->_getSelectedRoles(); if ($column->getFilter()->getValue()) { $this->getCollection()->addFieldToFilter('entity_id', array('in' => $userRoles)); } elseif (!empty($userRoles)) { $this->getCollection()->addFieldToFilter('entity_id', array('nin' => $userRoles)); } else { $this->getCollection(); } } else { parent::_addColumnFilterToCollection($column); } return $this; }
/** * Add filter * * @param Mage_Adminhtml_Block_Widget_Grid_Column $column * @return Mage_Adminhtml_Block_Widget_Grid */ protected function _addColumnFilterToCollection($column) { if ($this->getCollection()) { switch ($column->getId()) { case 'tax_rates': $this->getCollection()->joinCalculationData('rate'); break; case 'customer_tax_classes': $this->getCollection()->joinCalculationData('ctc'); break; case 'product_tax_classes': $this->getCollection()->joinCalculationData('ptc'); break; } } return parent::_addColumnFilterToCollection($column); }
/** * Filter checked/unchecked rows in grid * * @param Mage_Adminhtml_Block_Widget_Grid_Column $column * @return Mage_Adminhtml_Block_Catalog_Product_Widget_Chooser */ protected function _addColumnFilterToCollection($column) { if ($column->getId() == 'in_products') { $selected = $this->getSelectedProducts(); if ($column->getFilter()->getValue()) { $this->getCollection()->addFieldToFilter('entity_id', array('in' => $selected)); } else { $this->getCollection()->addFieldToFilter('entity_id', array('nin' => $selected)); } } else { parent::_addColumnFilterToCollection($column); } return $this; }
/** * Setting column filters to collection * * @param Mage_Adminhtml_Block_Widget_Grid_Column $column * @return Enterprise_Rma_Block_Adminhtml_Rma_New_Tab_Items_Order_Grid */ protected function _addColumnFilterToCollection($column) { // Set custom filter for selected products flag if ($column->getId() == 'select') { $productIds = $this->_getSelectedProducts(); if (empty($productIds)) { $productIds = 0; } if ($column->getFilter()->getValue()) { $this->getCollection()->addFieldToFilter('item_id', array('in' => $productIds)); } else { if ($productIds) { $this->getCollection()->addFieldToFilter('item_id', array('nin' => $productIds)); } } } else { parent::_addColumnFilterToCollection($column); } return $this; }
/** * @param Mage_Adminhtml_Block_Widget_Grid_Column $column * @return Mage_Api2_Block_Adminhtml_Roles_Tab_Users */ protected function _addColumnFilterToCollection($column) { if ($column->getId() == 'filter_in_role_users') { $inRoleIds = $this->getUsers(); if (empty($inRoleIds)) { $inRoleIds = 0; } if ($column->getFilter()->getValue()) { $this->getCollection()->addFieldToFilter('user_id', array('in' => $inRoleIds)); } else { if ($inRoleIds) { $this->getCollection()->addFieldToFilter('user_id', array('nin' => $inRoleIds)); } } } else { parent::_addColumnFilterToCollection($column); } return $this; }
/** * Sets sorting order by some column * * @param Mage_Adminhtml_Block_Widget_Grid_Column $column * @return Mage_Adminhtml_Block_Customer_Edit_Tab_Wishlist */ protected function _setCollectionOrder($column) { $collection = $this->getCollection(); if ($collection) { switch ($column->getId()) { case 'product_name': $collection->setOrderByProductName($column->getDir()); break; default: parent::_setCollectionOrder($column); break; } } return $this; }
/** * Add column filter to collection * * @param Mage_Adminhtml_Block_Widget_Grid_Column $column * @return Mage_Adminhtml_Block_Customer_Edit_Tab_Wishlist */ protected function _addColumnFilterToCollection($column) { if ($column->getId() == 'store') { $this->getCollection()->addFieldToFilter('item_store_id', $column->getFilter()->getCondition()); return $this; } if ($this->getCollection() && $column->getFilter()->getValue()) { $this->getCollection()->addFieldToFilter($column->getIndex(), $column->getFilter()->getCondition()); } return $this; }
/** * Add a grid column from block origin * * @param Mage_Adminhtml_Block_Widget_Grid_Column $column Column object * @param int $order Column order * @return this */ protected function _addColumnFromBlock(Mage_Adminhtml_Block_Widget_Grid_Column $column, $order) { $this->addColumn($column->getId(), array('id' => $column->getId(), 'index' => $column->getIndex(), 'width' => $column->getWidth(), 'align' => array_key_exists($column->getAlign(), $this->getColumnAlignments()) ? $column->getAlign() : self::GRID_COLUMN_ALIGNMENT_LEFT, 'header' => $column->getHeader(), 'order' => $order, 'origin' => self::GRID_COLUMN_ORIGIN_GRID, 'is_visible' => 1, 'filter_only' => 0, 'is_system' => $column->getIsSystem() ? 1 : 0, 'missing' => 0, 'store_id' => null, 'renderer_type' => null, 'renderer_params' => null, 'allow_edit' => 1, 'custom_params' => null)); return $this; }