本文整理汇总了PHP中Mage_Core_Model_Mysql4_Collection_Abstract::getSelectCountSql方法的典型用法代码示例。如果您正苦于以下问题：PHP Mage_Core_Model_Mysql4_Collection_Abstract::getSelectCountSql方法的具体用法？PHP Mage_Core_Model_Mysql4_Collection_Abstract::getSelectCountSql怎么用？PHP Mage_Core_Model_Mysql4_Collection_Abstract::getSelectCountSql使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Mage_Core_Model_Mysql4_Collection_Abstract的用法示例。
在下文中一共展示了Mage_Core_Model_Mysql4_Collection_Abstract::getSelectCountSql方法的12个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: getSelectCountSql
/**
* Minimize usual count select
*
* @return Varien_Db_Select
*/
public function getSelectCountSql()
{
/* @var $countSelect Varien_Db_Select */
$countSelect = parent::getSelectCountSql();
$countSelect->resetJoinLeft();
return $countSelect;
}示例2: getSelectCountSql
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: getSelectCountSql
/**
* 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: getSelectCountSql
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: getSelectCountSql
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: getSelectCountSql
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: getSelectCountSql
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: getSelectCountSql
/**
* 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: getSelectCountSql
/**
* Minimize usual count select
*
* @return Varien_Db_Select
*/
public function getSelectCountSql()
{
return parent::getSelectCountSql()->resetJoinLeft();
}示例10: getSelectCountSql
/**
* 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: getSelectCountSql
public function getSelectCountSql()
{
$sql = parent::getSelectCountSql();
$this->_renderEditFilter($sql);
return $sql;
}示例12: getSelectCountSql
public function getSelectCountSql()
{
if (!$this->_isGrouped) {
return parent::getSelectCountSql();
}
$this->_renderFilters();
$countSelect = clone $this->getSelect();
return $countSelect->reset()->from($this->getSelect(), array())->columns('COUNT(*)');
}