PHP Mage_Core_Model_Mysql4_Collection_Abstract::getSelectCountSqlの例

コード例 #1

ファイル: Collection.php プロジェクト: buttasg/cowgirlk

 /**
  * Minimize usual count select
  *
  * @return Varien_Db_Select
  */
 public function getSelectCountSql()
 {
     /* @var $countSelect Varien_Db_Select */
     $countSelect = parent::getSelectCountSql();
     $countSelect->resetJoinLeft();
     return $countSelect;
 }

コード例 #2

ファイル: Collection.php プロジェクト: xiaoguizhidao/devfashion

 public function getSelectCountSql()
 {
     $countSelect = parent::getSelectCountSql();
     if ($this->_allowDisableGrouping) {
         $countSelect->reset(Zend_Db_Select::COLUMNS);
         $countSelect->reset(Zend_Db_Select::GROUP);
         $countSelect->columns('COUNT(DISTINCT ' . $this->getCountAttribute() . ')');
     }
     return $countSelect;
 }

コード例 #3

ファイル: Collection.php プロジェクト: AmineCherrai/rostanvo

 /**
  * Minimize usual count select
  *
  * @return Varien_Db_Select
  */
 public function getSelectCountSql()
 {
     /* @var $countSelect Varien_Db_Select */
     $countSelect = parent::getSelectCountSql();
     $countSelect->resetJoinLeft();
     $countSelect->reset(Zend_Db_Select::GROUP);
     $sql = (string) $countSelect;
     $sql = str_replace('COUNT(*)', 'COUNT(distinct customer_email)', $sql);
     return $sql;
 }

コード例 #4

ファイル: Collection.php プロジェクト: cabrerabywaters/magentoSunshine

 public function getSelectCountSql()
 {
     if ($this->_customGroupSql) {
         $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);
         $countSelect->reset(Zend_Db_Select::GROUP);
         $countSelect->columns('COUNT(DISTINCT referer, landing_page, store_id)');
         return $countSelect;
     }
     return parent::getSelectCountSql();
 }

コード例 #5

ファイル: Collection.php プロジェクト: xiaoguizhidao/magento

 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);
         $countSelect->reset(Zend_Db_Select::GROUP);
         $countSelect->columns('COUNT(DISTINCT main_table.customer_id)');
         return $countSelect;
     }
     return parent::getSelectCountSql();
 }

コード例 #6

ファイル: Collection.php プロジェクト: shebin512/Magento_Zoff

 public function getSelectCountSql()
 {
     $controller_name = Mage::app()->getRequest()->getControllerName();
     if ($controller_name == 'sales_order' || $controller_name == 'sales_archive') {
         $this->_renderFilters();
         $unionSelect = clone $this->getSelect();
         $unionSelect->reset(Zend_Db_Select::ORDER);
         $unionSelect->reset(Zend_Db_Select::LIMIT_COUNT);
         $unionSelect->reset(Zend_Db_Select::LIMIT_OFFSET);
         $countSelect = clone $this->getSelect();
         $countSelect->reset();
         $countSelect->from(array('a' => $unionSelect), 'COUNT(*)');
     } else {
         $countSelect = parent::getSelectCountSql();
     }
     return $countSelect;
 }

コード例 #7

ファイル: Collection.php プロジェクト: santhosh400/ecart

 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();
 }

コード例 #8

ファイル: Collection.php プロジェクト: purpleweb/magento-popup

 /**
  * Get SQL for get record count.
  * Extra GROUP BY strip added.
  *
  * @return Varien_Db_Select
  */
 public function getSelectCountSql()
 {
     $countSelect = parent::getSelectCountSql();
     $countSelect->reset(Zend_Db_Select::GROUP);
     return $countSelect;
 }

コード例 #9

ファイル: Collection.php プロジェクト: jpbender/mage_virtual

 /**
  * Minimize usual count select
  *
  * @return Varien_Db_Select
  */
 public function getSelectCountSql()
 {
     return parent::getSelectCountSql()->resetJoinLeft();
 }

コード例 #10

ファイル: Collection.php プロジェクト: jpbender/mage_virtual

 /**
  * Get SQL for get record count.
  * Reset left join, group and having parts
  *
  * @return Varien_Db_Select
  */
 public function getSelectCountSql()
 {
     $countSelect = parent::getSelectCountSql();
     if ($this->_customerCountAdded) {
         $countSelect->reset(Zend_Db_Select::GROUP);
         $countSelect->reset(Zend_Db_Select::HAVING);
         $countSelect->resetJoinLeft();
     }
     return $countSelect;
 }

コード例 #11

ファイル: Collection.php プロジェクト: xiaoguizhidao/cupboardglasspipes.ecomitize.com

 public function getSelectCountSql()
 {
     $sql = parent::getSelectCountSql();
     $this->_renderEditFilter($sql);
     return $sql;
 }

コード例 #12

ファイル: Collection.php プロジェクト: hueyl77/fourwindsgear

 public function getSelectCountSql()
 {
     if (!$this->_isGrouped) {
         return parent::getSelectCountSql();
     }
     $this->_renderFilters();
     $countSelect = clone $this->getSelect();
     return $countSelect->reset()->from($this->getSelect(), array())->columns('COUNT(*)');
 }