/** * Get SQL for get record count * * @return Varien_Db_Select */ public function getSelectCountSql() { $countSelect = parent::getSelectCountSql(); //@nelkaake -a 15/12/10: Reset the group selection. ( for categories grouping) $countSelect->reset(Zend_Db_Select::GROUP); return $countSelect; }
/** * Covers bug in Magento function * @return Varien_Db_Select */ public function getSelectCountSql() { $catalogProductFlatHelper = Mage::helper('catalog/product_flat'); if ($catalogProductFlatHelper && $catalogProductFlatHelper->isEnabled()) { return parent::getSelectCountSql(); } $this->_renderFilters(); $countSelect = clone $this->getSelect(); return $countSelect->reset()->from($this->getSelect(), array())->columns('COUNT(*)'); }
public function getSelectCountSql() { if ($this->_isGroupSql) { $this->_renderFilters(); $countSelect = clone $this->getSelect(); $countSelect->reset(Zend_Db_Select::ORDER); $countSelect->reset(Zend_Db_Select::LIMIT_COUNT); $countSelect->reset(Zend_Db_Select::LIMIT_OFFSET); $countSelect->reset(Zend_Db_Select::COLUMNS); if (count($this->getSelect()->getPart(Zend_Db_Select::GROUP)) > 0) { $countSelect->reset(Zend_Db_Select::GROUP); $countSelect->distinct(true); $group = $this->getSelect()->getPart(Zend_Db_Select::GROUP); $countSelect->columns("COUNT(DISTINCT " . implode(", ", $group) . ")"); } else { $countSelect->columns('COUNT(*)'); } return $countSelect; } return parent::getSelectCountSql(); }
public function getSelectCountSql() { $select = parent::getSelectCountSql(); $select->reset(Zend_Db_Select::GROUP); return $select; }