Magento – How to create custom field in Sales > order > create new order Grid

gridmagento-1.9

I am working on Magento, I want to create new custom field with filter in Sales > Order > Create new order > Add product grid.

Let me know please how can i do it.

Thanks.

Best Answer

You will need to override a class Mage_Adminhtml_Block_Sales_Order_Create_Search_Grid.

Go to your config.xml and add this

<global>
    <blocks>
        ......................          
        <adminhtml>
            <rewrite>
                <sales_order_create_search_grid>Mage_Adminhtml_Block_Sales_Order_Create_Search_Grid</sales_order_create_search_grid>
            </rewrite>
        </adminhtml>
    </blocks>
.............
</global>

Now create a file Namespace/ModuleName/Block/Adminhtml/Sales/Order/Create/Search/Grid.php and have this code:

<?php
class Namespace_ModuleName_Block_Adminhtml_Sales_Order_Create_Search_Grid extends 
    Mage_Adminhtml_Block_Sales_Order_Create_Search_Grid
{

/**
 * Prepare collection to be displayed in the grid
 *
 * @return Mage_Adminhtml_Block_Sales_Order_Create_Search_Grid
 */
protected function _prepareCollection()
{
    $attributes = Mage::getSingleton('catalog/config')->getProductAttributes();
    /* @var $collection Mage_Catalog_Model_Resource_Product_Collection */
    $collection = Mage::getModel('catalog/product')->getCollection();
    $collection
        ->setStore($this->getStore())
        ->addAttributeToSelect($attributes)
        ->addAttributeToSelect('sku')
        ->addStoreFilter()
        ->addAttributeToFilter('type_id', array_keys(
            Mage::getConfig()->getNode('adminhtml/sales/order/create/available_product_types')->asArray()
        ))
        ->addAttributeToSelect('gift_message_available')
        //our new field.
        ->addAttributeToSelect('type_id');

    Mage::getSingleton('catalog/product_status')->addSaleableFilterToCollection($collection);

    $this->setCollection($collection);
    return parent::_prepareCollection();
}


protected function _prepareColumns()
    {
        parent::_prepareColumns();
        $this->addColumn('type',
          array(
            'header'=> Mage::helper('sales')->__('Type'),
            'width' => '60px',
            'index' => 'type_id',
            'type'  => 'options',
            'options' => Mage::getSingleton('catalog/product_type')->getOptionArray(),
      ));
        return parent::_prepareColumns();
    }

}

This will add a product type in grid.

Hope this helps. Good luck.

Rewrite class then add columns to show Coupon:

<?php
/**
* Sales Order Class
*
* @author Amit Bera
*/
class Amit_CustomOrderGrid_Block_Adminhtml_Sales_Order_Grid extends Mage_Adminhtml_Block_Sales_Order_Grid
{

   protected function _prepareColumns()
    {

      $this->addColumn('coupon_code', array(
          'header'    => Mage::helper('sales')->__('Color Name'),
          'align'     =>'left',
          'width'     => '50px',
          'index'     => 'coupon_code',
    'filter_index' => 'order.coupon_code'
    ));


        parent::_prepareColumns();
        return Mage_Adminhtml_Block_Widget_Grid::_prepareColumns();

    }
    protected function _prepareCollection()
    {
        $collection = Mage::getResourceModel($this->_getCollectionClass());
    $collection->getSelect()->joinLeft(array('order' => Mage::getModel('core/resource')->getTableName('sales/order')),
        'order.entity_id=main_table.entity_id',array('coupon_code' => 'coupon_code'))
        $this->setCollection($collection);
       // return parent::_prepareCollection();
       return Mage_Adminhtml_Block_Widget_Grid::_prepareCollection();
    }
}
?>

Magento 2 – Customize Admin Sales Order Grid Collection

You could use a plugin on Magento/Framework/View/Element/UiComponent/DataProvider/Reporting and its search() method.

Just create di.xml in your custom module Vendor/Module/etc/adminhtml/di.xml

<?xml version="1.0"?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:ObjectManager/etc/config.xsd">
    <type name="Magento\Framework\View\Element\UiComponent\DataProvider\Reporting">
        <plugin name="sales_grid_collection" type="Vendor\Module\Model\Plugin\Sales\Order\Grid"/>
    </type>
</config>

and plugin

namespace Vendor\Module\Model\Plugin\Sales\Order;

class Grid {

    public static $table = 'sales_order_grid';


    /**
     *
     */
    public function afterSearch($intercepter, $collection) {

        if ($collection->getMainTable() === $collection->getConnection()->getTableName(self::$table)) {      

            // retrieve where clause
            $where = $collection->getSelect()->getPart(\Magento\Framework\DB\Select::WHERE);

            // ...
            // works with $where
            // ...

            // set the new where clause    
            $collection->getSelect()->setPart(\Magento\Framework\DB\Select::WHERE, $where);                

        }

        return $collection;

    }

}

Best Answer

Related Solutions

Magento – magento Add Coupon code at sales order grid

Rewrite class then add columns to show Coupon:

Magento 2 – Customize Admin Sales Order Grid Collection

Related Topic