本文整理汇总了PHP中Mage_Core_Model_Resource_Db_Collection_Abstract::getSelectCountSql方法的典型用法代码示例。如果您正苦于以下问题:PHP Mage_Core_Model_Resource_Db_Collection_Abstract::getSelectCountSql方法的具体用法?PHP Mage_Core_Model_Resource_Db_Collection_Abstract::getSelectCountSql怎么用?PHP Mage_Core_Model_Resource_Db_Collection_Abstract::getSelectCountSql使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Mage_Core_Model_Resource_Db_Collection_Abstract
的用法示例。
在下文中一共展示了Mage_Core_Model_Resource_Db_Collection_Abstract::getSelectCountSql方法的6个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: getSelectCountSql
/**
* Get sql for get record count
*
* @return string
*/
public function getSelectCountSql()
{
$select = parent::getSelectCountSql();
$select->reset(Zend_Db_Select::COLUMNS);
$select->reset(Zend_Db_Select::GROUP);
$select->reset(Zend_Db_Select::HAVING);
$select->columns('COUNT(DISTINCT main_table.news_id)');
return $select;
}
示例2: getSelectCountSql
/**
* Account for group and having clauses, if any
*
* @return Varien_Db_Select
*/
public function getSelectCountSql()
{
if (!$this->_interferWithCountSql) {
return parent::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);
//$countSelect->columns('COUNT(*)');
return $countSelect;
}
示例3: 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;
}
示例4: getSelectCountSql
/**
* Returns select count sql
*
* @return string
*/
public function getSelectCountSql()
{
$select = parent::getSelectCountSql();
$countSelect = clone $this->getSelect();
$countSelect->reset(Zend_Db_Select::HAVING);
return $select;
}
示例5: getSelectCountSql
/**
* Minimize usual count select
*
* @return Varien_Db_Select
*/
public function getSelectCountSql()
{
return parent::getSelectCountSql()->resetJoinLeft();
}
示例6: getSelectCountSql
/**
* Get SQL for get record count
* Modified because model uses GROUP BY
*
* @return Varien_Db_Select
*/
public function getSelectCountSql()
{
return parent::getSelectCountSql()->reset(Zend_Db_Select::GROUP);
}