本文整理汇总了PHP中Mage_Core_Model_Mysql4_Collection_Abstract::setOrder方法的典型用法代码示例。如果您正苦于以下问题:PHP Mage_Core_Model_Mysql4_Collection_Abstract::setOrder方法的具体用法?PHP Mage_Core_Model_Mysql4_Collection_Abstract::setOrder怎么用?PHP Mage_Core_Model_Mysql4_Collection_Abstract::setOrder使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Mage_Core_Model_Mysql4_Collection_Abstract
的用法示例。
在下文中一共展示了Mage_Core_Model_Mysql4_Collection_Abstract::setOrder方法的3个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: setCollection
/**
* Set collection to pager
*
* @param Varien_Data_Collection $collection
* @return Mage_Catalog_Block_Product_List_Toolbar
*/
public function setCollection($collection)
{
$this->_collection = $collection;
$this->_collection->setCurPage($this->getCurrentPage());
// we need to set pagination only if passed value integer and more that 0
$limit = (int) $this->getLimit();
if ($limit) {
$this->_collection->setPageSize($limit);
}
if ($this->getCurrentOrder() && $this->getRequest()->getParam('order')) {
if ($this->getCurrentOrder() == 'new' && Mage::registry('current_category')) {
$this->_collection->setOrder('entity_id', 'desc');
} else {
if ($this->getCurrentOrder() == 'popular' && Mage::registry('current_category')) {
$this->getCollection()->getSelect()->joinLeft(array('sfoi' => $collection->getResource()->getTable('sales/order_item')), 'e.entity_id = sfoi.product_id', array('qty_ordered' => 'SUM(sfoi.qty_ordered)'))->group('e.entity_id')->order('qty_ordered ' . $this->getCurrentDirection());
} else {
if ($this->getCurrentOrder() == 'price' && Mage::registry('current_category')) {
$this->_collection->setOrder($this->getCurrentOrder(), $this->getCurrentDirection());
} else {
$this->_collection->setOrder('position', 'asc');
}
}
}
} else {
if (Mage::registry('current_category')) {
$this->_collection->setOrder('position', 'asc');
}
}
return $this;
}
示例2: setCollection
/**
* Set collection to pager
*
* @param Varien_Data_Collection $collection
* @return Mage_Catalog_Block_Product_List_Toolbar
*/
public function setCollection($collection)
{
$this->_collection = $collection;
$this->_collection->setCurPage($this->getCurrentPage());
// we need to set pagination only if passed value integer and more that 0
$limit = (int) $this->getLimit();
if ($limit) {
$this->_collection->setPageSize($limit);
}
if ($this->getCurrentOrder()) {
$this->_collection->setOrder(array($this->getCurrentOrder(), 'entity_id'), $this->getCurrentDirection());
//Ashwani Bhasin 1-29-2012 added entity id
}
return $this;
}
示例3: setCollection
/**
* Set collection to pager
*
* @param Varien_Data_Collection $collection
* @return Mage_Catalog_Block_Product_List_Toolbar
*/
public function setCollection($collection)
{
$this->_collection = $collection;
$this->_collection->setCurPage($this->getCurrentPage());
// we need to set pagination only if passed value integer and more that 0
$limit = (int) $this->getLimit();
if ($limit) {
$this->_collection->setPageSize($limit);
}
//appstockus changed
if ($this->getCurrentOrder()) {
$this->_collection->setOrder($this->getCurrentOrder(), $this->getCurrentDirection())->setOrder('price', 'desc');
}
// if($this->getCurrentOrder() == 'discount'){
// $this->getCollection()->getSelect()->joinLeft('catalog_product_index_price as cpd','e.entity_id = cpd.entity_id','SUM(cpd.price - cpd.final_price) AS discount')->group('e.entity_id')->order('<strong class="StrictlyAutoTagBold">discount</strong> desc');
// } else if ($this->getCurrentOrder()) {
// $this->_collection->setOrder($this->getCurrentOrder(), $this->getCurrentDirection())->setOrder('price', 'desc');
// }
return $this;
}