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