使用 group() 在 magento 中破坏 getSelectCountSql [英] using group() breaks getSelectCountSql in magento

问题描述

当我使用时

$collection->getSelect()->group('entity_id')

或

$collection->groupByAttribute('entity_id')

它打破了 getSelectCountSql，我得到了 1 条记录和 1 页.Magento 确实

It breaks getSelectCountSql and I'm getting 1 record and 1 page. Magento does

$countSelect->columns('COUNT(DISTINCT e.entity_id)');

有办法解决吗?

我遇到了它，同时覆盖了 Mage_Adminhtml_Block_Catalog_Product_Grid 的 _prepareCollection

I run into it,While overriding _prepareCollection of Mage_Adminhtml_Block_Catalog_Product_Grid

谢谢

推荐答案

我更新了 lib/Varien/Data/Collection/Db.php 文件以允许这样做，因为我必须让它工作.你必须跟踪这个升级，但它的工作原理.

I updated the lib/Varien/Data/Collection/Db.php file to allow this as I had to have it work. You'll have to keep track of this for upgrades but it works.

public function getSelectCountSql()
{   
    $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);

    // Count doesn't work with group by columns keep the group by 
    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;
}

这篇关于使用 group() 在 magento 中破坏 getSelectCountSql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！