PHP Mage_Core_Model_Resource_Db_Collection_Abstract::getSelect Exemples

Exemple #1

Fichier : Collection.php Projet : lightyoruichi/Magento-Pre-Patched-Files

 /**
  * 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);
 }

Exemple #2

Fichier : Collection.php Projet : natxetee/magento2

 /**
  * 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);
 }

Exemple #3

 public function testGetAllIdsWithBind()
 {
     $this->_model->getSelect()->where('code = :code');
     $this->_model->addBindParam('code', 'admin');
     $this->assertEquals(array('0'), $this->_model->getAllIds());
 }

Exemple #4

Fichier : Collection.php Projet : kirchbergerknorr/payone-magento

 protected function prepareCollection(Mage_Core_Model_Resource_Db_Collection_Abstract $collection)
 {
     $collection->getSelect()->limit();
     $collection->setPageSize(0);
     $collection->load();
 }