Magento – How to reset a specific order by column

product-collectionselectsortsorting

I have a product collection that use a addAttributeToSort.

Now there exists a sort filter in the frontend to sort products e.g. for price or date.

When I click that filter in the frontend I have to reset my first order by.
But now the problem is I can only reset the order after the frontend runs his new order.

So my question is there a possibility to reset only specific order by columns or can I only reset all order at once?

Best Answer

The available sorting methods are

addOrder(), setOrder(), unshiftOrder(), addAttributeToSort() and getSelect()->order()

Only setOrder($field, $dir) is available regardless of collection type and system settings. I suggest you get used to using setOrder().

If you need to enforce an order, but an order is already set on the collection, use unshiftOrder($field, $dir) for flat table collections.

For EAV collections you need to do

$col->getSelect()->reset(Zend_Db_Select::ORDER); And then use $col->setOrder($field, $dir);

Resource: http://tweetorials.tumblr.com/post/11137227678/magento-collection-ordering-or-sorting

Related Solutions

Magento – Fetch Product Collection Based on Special Price End Date

$now = Mage::getSingleton('core/date')->gmtDate();
$this->_collection->addAttributeToFilter('special_to_date', array('or'=> array(
    0 => array('date' => true, 'from' => $now),
    1 => array('is' => new Zend_Db_Expr('null')))
 ), 'left')

The code above should allow only products that don't have an end date for the special price or if the end date is in the future.

[EDIT]
To add a filter for special_from_date you can add this after the code above

$this->_collection->addAttributeToFilter('special_from_date', array('or'=> array(
    0 => array('date' => true, 'to' => $now),
    1 => array('is' => new Zend_Db_Expr('null')))
), 'left')

Magento – Sort Products by Date in Admin

setDefaultSort() of grid class of a module is set grid order field in magento.

As you want the change currenr grid sort order of product then you need go Mage_Adminhtml_Block_Catalog_Product_Grid.Here you see magento already set 'entity_id' as default sort order.

You need change this.

So rewrite class the class Mage_Adminhtml_Block_Catalog_Product_Grid and do whatever you want.

config.xml:

<global>
..... 
    <blocks>
        <adminhtml>
            <rewrite>
            <catalog_product_grid>YourNameSpace_YourModuleName_Block_Adminhtml_Catalog_Product_Grid</catalog_product_grid>
            </rewrite>
        </adminhtml>
....
    </blocks>
  </global>

Class is:

<?php
class YourNameSpace_YourModuleName_Block_Adminhtml_Catalog_Product_Grid extends Mage_Adminhtml_Block_Catalog_Product_Grid
{
 public function __construct()
    {
        parent::__construct();
        $this->setDefaultSort('created_at');
    }
}

Edit:

As per as your coment you want to add created date on product grid then you can the the below code:

class YourNameSpace_YourModuleName_Block_Adminhtml_Catalog_Product_Grid extends Mage_Adminhtml_Block_Catalog_Product_Grid
{

    protected function _prepareCollection(){
        $collection= parent::getCollection();
        $this->setCollection($collection);
        parent::_prepareCollection();
         $this->getCollection()->addAttributeToSelect('created_at');
       return Mage_Adminhtml_Block_Widget_Grid::_prepareCollection();

        }
           protected function _prepareColumns()
    {
        parent::_prepareColumns();
        $this->addColumn('created_at',
            array(
                'header'=> Mage::helper('catalog')->__('Created At'),
                'width' => '50px',
                'type'  => 'date',
                'index' => 'created_at',
        ));
        return parent::_prepareColumns();
    }
}

Best Answer

Related Solutions

Magento – Fetch Product Collection Based on Special Price End Date

Magento – Sort Products by Date in Admin

Edit:

Related Topic