本文整理匯總了PHP中Varien_Db_Select::reset方法的典型用法代碼示例。如果您正苦於以下問題：PHP Varien_Db_Select::reset方法的具體用法？PHP Varien_Db_Select::reset怎麽用？PHP Varien_Db_Select::reset使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Varien_Db_Select的用法示例。
在下文中一共展示了Varien_Db_Select::reset方法的2個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: exists
/**
* Add EXISTS clause
*
* @param Varien_Db_Select $select
* @param string $joinCondition
* @param bool $isExists
* @return Varien_Db_Select
*/
public function exists($select, $joinCondition, $isExists = true)
{
if ($isExists) {
$exists = 'EXISTS (%s)';
} else {
$exists = 'NOT EXISTS (%s)';
}
$select->reset(self::COLUMNS)->columns(array(new Zend_Db_Expr('1')))->where($joinCondition);
$exists = sprintf($exists, $select->assemble());
$this->where($exists);
return $this;
}示例2: _prepareHaving
/**
* Prepare and returns having array
*
* @param Varien_Db_Select $select
* @param bool $autoReset
* @return array
* @throws Zend_Db_Exception
*/
protected function _prepareHaving(Varien_Db_Select $select, $autoReset = false)
{
$selectHavings = $select->getPart(Zend_Db_Select::HAVING);
if (!$selectHavings) {
return array();
}
$havings = array();
$columns = $select->getPart(Zend_Db_Select::COLUMNS);
foreach ($columns as $columnEntry) {
$correlationName = (string) $columnEntry[1];
$column = $columnEntry[2];
foreach ($selectHavings as $having) {
/**
* Looking for column expression in the having clause
*/
if (strpos($having, $correlationName) !== false) {
if (is_string($column)) {
/**
* Replace column expression to column alias in having clause
*/
$havings[] = str_replace($correlationName, $column, $having);
} else {
throw new Zend_Db_Exception(sprintf("Can't prepare expression without column alias: '%s'", $correlationName));
}
}
}
}
if ($autoReset) {
$select->reset(Zend_Db_Select::HAVING);
}
return $havings;
}