/** * Callback function that filters collection by field "Used" from grid * * @param Mage_Core_Model_Resource_Db_Collection_Abstract $collection * @param Mage_Adminhtml_Block_Widget_Grid_Column $column */ public function addIsUsedFilterCallback($collection, $column) { $filterValue = $column->getFilter()->getCondition(); $fieldExpression = $this->getConnection()->getCheckSql('main_table.times_used > 0', 1, 0); $resultCondition = $this->_getConditionSql($fieldExpression, array('eq' => $filterValue)); $collection->getSelect()->where($resultCondition); }
/** * Callback function that filters collection by field "Used" from grid * * @param Mage_Core_Model_Resource_Db_Collection_Abstract $collection * @param Mage_Adminhtml_Block_Widget_Grid_Column $column */ public function addIsUsedFilterCallback($collection, $column) { $filterValue = $column->getFilter()->getCondition(); $expression = $this->getConnection()->getCheckSql('main_table.times_used > 0', 1, 0); $conditionSql = $this->_getConditionSql($expression, $filterValue); $collection->getSelect()->where($conditionSql); }
public function testGetAllIdsWithBind() { $this->_model->getSelect()->where('code = :code'); $this->_model->addBindParam('code', 'admin'); $this->assertEquals(array('0'), $this->_model->getAllIds()); }
protected function prepareCollection(Mage_Core_Model_Resource_Db_Collection_Abstract $collection) { $collection->getSelect()->limit(); $collection->setPageSize(0); $collection->load(); }