Magento 1.9 – Set Default Filter Value for Column Grid

adminbackendgridmagento-1.9sales-order

I want to have a default value in a column on sales grid, the value will be the actual day.

$this->addColumn('created_at', array(
        'header' => Mage::helper('sales')->__('Purchased On'),
        'index' => 'created_at',
        'type' => 'datetime',
        'width' => '100px',
        'filter_index' => 'main_table.created_at',

        'value'=>array(
            'from'=>date('Y-m-d', time())
        )
    ));

But its not working and I don't know why.

How can I do that?

Best Answer

try below code

$this->addColumn('created_at', array(
    'header' => Mage::helper('sales')->__('Purchased On'),
    'index' => 'created_at',
    'type' => 'datetime',
    'width' => '100px',
    'filter_index' => 'main_table.created_at',

    'value'=>array(
        'from'=>date('Y-m-d')
    )
));

Related Solutions

Magento Grid Filtering – Exclude Certain Field Values by Default

Try this.
Lose the filter_condition_callback on the column. You need to focus on the _prepareCollection method.

protected function _prepareCollection() {
    $collection = ....;
    ....
    $canShowArchive = false;
    //check if there is a filter.
    $filter = $this->getParam($this->getVarNameFilter(), null);
    //if there is a filter, check if the filter contains the status
    if (!is_null($filter))  {
         //decode the filter
         $filter = $this->helper('adminhtml')->prepareFilterString($filter);
         if (isset($filter['status'])) {
              //if there is a filter by status you may need to show the archive items 
              $canShowArchive = true;
         }
    }
    //if $canShowArchive is false, just filter the collection by status not equal to 'archive'
    if (!$canShowArchive) {
        $collection->addFieldToFilter('status', array('neq'=>4));
    }
    $this->setCollection($collection);
    return parent::_prepareCollection();
}

The code above is not tested but it seams like the way to go.

Magento 1.9 – Fix Date Time Picker and Time Zone Issues

I have just run into this issue. By placing a test magento order, and confirming the datetime placed for the created_at value of that order, I have managed to establish the following:

The date from the form field (thus date picker attached to that field) is not being converted to/from UTC when loading / saving on the db.

The display in the grid is correctly converting from UTC to the sites locale timezone.

Example: I place my order at 08:22 am (AWST) - the entry saved in created at was 00:22 (-8h UTC from AWST) When that order is viewed in the grid, it is correctly shown as 08:22 AM again (AWST)

Now, If I place a date time in the date-picker (or just manually type it into the form field) (so again using 08:22 AM), the value stored into the DB is exactly that 08:22 - where it should have been 00:22 - so, it is not converted to UTC upon save.

If I do convert it to UTC before save:

$data['date_time'] = Mage::getModel('core/date')->gmtDate("Y-m-d H:i:s", $data['date_time']);

it is correctly save to UTC in db, and the grid view then correctly displays 08:22 AM (correctly converted from UTC to AWST) However, if I view that in the form edit, it simply displays the value AS IS from the db - so as 00:22 - so no conversion was done from UTC to AWST (which is part of the issue)

To make this work for me, I had to:

Create a new form element:

$form->addType('datetimezone', 'Enjo_Events_Lib_Data_Form_Element_Datetime');

created the element as such:

$dateFormatIso = Mage::app()->getLocale()->getDateTimeFormat(Mage_Core_Model_Locale::FORMAT_TYPE_SHORT);
        $form->addField('date_time', 'datetimezone', array(
            'name'   => 'date_time',
            'label'  => Mage::helper('enjo_events')->__('Date and Time'),
            'title'  => Mage::helper('enjo_events')->__('Date and Time'),
            'image'  => $this->getSkinUrl('images/grid-cal.gif'),
            'input_format' => Varien_Date::DATETIME_INTERNAL_FORMAT,
            'format' => $dateFormatIso,
            'time' => true,
            'class'     => 'required-entry',
            'required'  => true,
            'width'     => "150",
            'locale'    => Mage::getStoreConfig('general/locale/code', 0),
            'convert_date_format' => "d/m/Y h:m a"
        ));

and the new form element code:

class Enjo_Events_Lib_Data_Form_Element_Datetime extends Varien_Data_Form_Element_Datetime
{

    /**
     * Get date value as string.
     * Format can be specified, or it will be taken from $this->getFormat()
     *
     * @param string $format (compatible with Zend_Date)
     * @return string
     */
    public function getValue($format = null)
    {
        if (empty($this->_value)) {
            return '';
        }
        if (null === $format) {
            $format = $this->getFormat();
        }
        return Mage::getModel('core/date')->date($this->getConvertDateFormat(),  $this->_value);
    }
}

and on the controller action, convert the date to UTC before saved.

$data = $this->getRequest()->getParams(); $data = $this->_filterDateTime($data, array('date_time')); $data['date_time'] = Mage::getModel('core/date')->gmtDate("Y-m-d H:i:s", $data['date_time']); $event->addData($data)->save();

which resulted in the correct data: UTC in DB, my store lcoale/zone in edits / views of said data.

I am not 100% sure where the failing is, so I class this as a workaround.

Best Answer

Related Solutions

Magento Grid Filtering – Exclude Certain Field Values by Default

Magento 1.9 – Fix Date Time Picker and Time Zone Issues

Related Topic