Adding order item to orders grid in Magento

<?php /** * Magento * * NOTICE OF LICENSE * * This source file is subject to the Open Software License (OSL 3.0) * that is bundled with this package in the file LICENSE.txt. * It is also available through the world-wide-web at this URL: * http://opensource.org/licenses/osl-3.0.php * If you did not receive a copy of the license and are unable to * obtain it through the world-wide-web, please send an email * to license@magentocommerce.com so we can send you a copy immediately. * * DISCLAIMER * * Do not edit or add to this file if you wish to upgrade Magento to newer * versions in the future. If you wish to customize Magento for your * needs please refer to http://www.magentocommerce.com for more information. * * @category Mage * @package Mage_Adminhtml * @copyright Copyright (c) 2012 Magento Inc. (http://www.magentocommerce.com) * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) */ /** * Adminhtml sales orders grid * * @category Mage * @package Mage_Adminhtml * @author Magento Core Team <core@magentocommerce.com><br /> */<br /> class Mage_Adminhtml_Block_Sales_Order_Grid extends Mage_Adminhtml_Block_Widget_Grid<br /> {</p> <p> public function __construct()<br /> {<br /> parent::__construct();<br /> $this->setId(‘sales_order_grid’);<br /> $this->setUseAjax(true);<br /> $this->setDefaultSort(‘created_at’);<br /> $this->setDefaultDir(‘DESC’);<br /> $this->setSaveParametersInSession(true);<br /> }</p> <p> /**<br /> * Retrieve collection class<br /> *<br /> * @return string<br /> */<br /> protected function _getCollectionClass()<br /> {<br /> return ‘sales/order_grid_collection’;<br /> }</p> <p>protected function _prepareCollection()<br /> {<br /> $userArray = Mage::getSingleton(‘admin/session’)->getData();<br /> $user = Mage::getSingleton(‘admin/session’);<br /> $userId = $user->getUser()->getUserId();</p> <p>$connection = Mage::getSingleton(‘core/resource’)->getConnection(‘core_read’);<br /> $sql = “Select * from sales_flat_order_grid as sss, junaidbhura_jbmarketplace_products as vitem, sales_flat_order_item as item WHERE vitem.product_id = item.product_id and sss.entity_id = item.order_id and vitem.user_id = $userId”;<br /> $rows = $connection->fetchAll($sql); //fetchRow($sql), fetchOne($sql),…<br /> //Zend_Debug::dump($rows);<br /> $pk = 0;<br /> foreach($rows as $value){<br /> $pkorder[] = $rows[$pk][‘order_id’];<br /> $pk++;<br /> }</p> <p>//print_r( $pkorder);</p> <p>//print_r($userId);<br /> //die;</p> <p> $collection = Mage::getResourceModel($this->_getCollectionClass());<br /> if($userId == 1 ){ }else{<br /> $collection->addFieldToFilter(‘entity_id’, array(‘in’ => array( $pkorder )));<br /> }<br /> $this->setCollection($collection);<br /> return parent::_prepareCollection();<br /> }</p> <p> protected function _prepareColumns()<br /> {</p> <p> $this->addColumn(‘real_order_id’, array(<br /> ‘header’=> Mage::helper(‘sales’)->__(‘Order #’),<br /> ‘width’ => ’80px’,<br /> ‘type’ => ‘text’,<br /> ‘index’ => ‘increment_id’,<br /> ));</p> <p> if (!Mage::app()->isSingleStoreMode()) {<br /> $this->addColumn(‘store_id’, array(<br /> ‘header’ => Mage::helper(‘sales’)->__(‘Purchased From (Store)’),<br /> ‘index’ => ‘store_id’,<br /> ‘type’ => ‘store’,<br /> ‘store_view’=> true,<br /> ‘display_deleted’ => true,<br /> ));<br /> }</p> <p> $this->addColumn(‘created_at’, array(<br /> ‘header’ => Mage::helper(‘sales’)->__(‘Purchased On’),<br /> ‘index’ => ‘created_at’,<br /> ‘type’ => ‘datetime’,<br /> ‘width’ => ‘100px’,<br /> ));</p> <p> $this->addColumn(‘billing_name’, array(<br /> ‘header’ => Mage::helper(‘sales’)->__(‘Bill to Name’),<br /> ‘index’ => ‘billing_name’,<br /> ));</p> <p> $this->addColumn(‘shipping_name’, array(<br /> ‘header’ => Mage::helper(‘sales’)->__(‘Ship to Name’),<br /> ‘index’ => ‘shipping_name’,<br /> ));</p> <p> $this->addColumn(‘base_grand_total’, array(<br /> ‘header’ => Mage::helper(‘sales’)->__(‘G.T. (Base)’),<br /> ‘index’ => ‘base_grand_total’,<br /> ‘type’ => ‘currency’,<br /> ‘currency’ => ‘base_currency_code’,<br /> ));</p> <p> $this->addColumn(‘grand_total’, array(<br /> ‘header’ => Mage::helper(‘sales’)->__(‘G.T. (Purchased)’),<br /> ‘index’ => ‘grand_total’,<br /> ‘type’ => ‘currency’,<br /> ‘currency’ => ‘order_currency_code’,<br /> ));</p> <p> $this->addColumn(‘status’, array(<br /> ‘header’ => Mage::helper(‘sales’)->__(‘Status’),<br /> ‘index’ => ‘status’,<br /> ‘type’ => ‘options’,<br /> ‘width’ => ’70px’,<br /> ‘options’ => Mage::getSingleton(‘sales/order_config’)->getStatuses(),<br /> ));</p> <p> if (Mage::getSingleton(‘admin/session’)->isAllowed(‘sales/order/actions/view’)) {<br /> $this->addColumn(‘action’,<br /> array(<br /> ‘header’ => Mage::helper(‘sales’)->__(‘Action’),<br /> ‘width’ => ’50px’,<br /> ‘type’ => ‘action’,<br /> ‘getter’ => ‘getId’,<br /> ‘actions’ => array(<br /> array(<br /> ‘caption’ => Mage::helper(‘sales’)->__(‘View’),<br /> ‘url’ => array(‘base’=>’*/sales_order/view’),<br /> ‘field’ => ‘order_id’<br /> )<br /> ),<br /> ‘filter’ => false,<br /> ‘sortable’ => false,<br /> ‘index’ => ‘stores’,<br /> ‘is_system’ => true,<br /> ));<br /> }<br /> $this->addRssList(‘rss/order/new’, Mage::helper(‘sales’)->__(‘New Order RSS’));</p> <p> $this->addExportType(‘*/*/exportCsv’, Mage::helper(‘sales’)->__(‘CSV’));<br /> $this->addExportType(‘*/*/exportExcel’, Mage::helper(‘sales’)->__(‘Excel XML’));</p> <p> return parent::_prepareColumns();<br /> }</p> <p> protected function _prepareMassaction()<br /> {<br /> $this->setMassactionIdField(‘entity_id’);<br /> $this->getMassactionBlock()->setFormFieldName(‘order_ids’);<br /> $this->getMassactionBlock()->setUseSelectAll(false);</p> <p> if (Mage::getSingleton(‘admin/session’)->isAllowed(‘sales/order/actions/cancel’)) {<br /> $this->getMassactionBlock()->addItem(‘cancel_order’, array(<br /> ‘label’=> Mage::helper(‘sales’)->__(‘Cancel’),<br /> ‘url’ => $this->getUrl(‘*/sales_order/massCancel’),<br /> ));<br /> }</p> <p> if (Mage::getSingleton(‘admin/session’)->isAllowed(‘sales/order/actions/hold’)) {<br /> $this->getMassactionBlock()->addItem(‘hold_order’, array(<br /> ‘label’=> Mage::helper(‘sales’)->__(‘Hold’),<br /> ‘url’ => $this->getUrl(‘*/sales_order/massHold’),<br /> ));<br /> }</p> <p> if (Mage::getSingleton(‘admin/session’)->isAllowed(‘sales/order/actions/unhold’)) {<br /> $this->getMassactionBlock()->addItem(‘unhold_order’, array(<br /> ‘label’=> Mage::helper(‘sales’)->__(‘Unhold’),<br /> ‘url’ => $this->getUrl(‘*/sales_order/massUnhold’),<br /> ));<br /> }</p> <p> $this->getMassactionBlock()->addItem(‘pdfinvoices_order’, array(<br /> ‘label’=> Mage::helper(‘sales’)->__(‘Print Invoices’),<br /> ‘url’ => $this->getUrl(‘*/sales_order/pdfinvoices’),<br /> ));</p> <p> $this->getMassactionBlock()->addItem(‘pdfshipments_order’, array(<br /> ‘label’=> Mage::helper(‘sales’)->__(‘Print Packingslips’),<br /> ‘url’ => $this->getUrl(‘*/sales_order/pdfshipments’),<br /> ));</p> <p> $this->getMassactionBlock()->addItem(‘pdfcreditmemos_order’, array(<br /> ‘label’=> Mage::helper(‘sales’)->__(‘Print Credit Memos’),<br /> ‘url’ => $this->getUrl(‘*/sales_order/pdfcreditmemos’),<br /> ));</p> <p> $this->getMassactionBlock()->addItem(‘pdfdocs_order’, array(<br /> ‘label’=> Mage::helper(‘sales’)->__(‘Print All’),<br /> ‘url’ => $this->getUrl(‘*/sales_order/pdfdocs’),<br /> ));</p> <p> $this->getMassactionBlock()->addItem(‘print_shipping_label’, array(<br /> ‘label’=> Mage::helper(‘sales’)->__(‘Print Shipping Labels’),<br /> ‘url’ => $this->getUrl(‘*/sales_order_shipment/massPrintShippingLabel’),<br /> ));</p> <p> return $this;<br /> }</p> <p> public function getRowUrl($row)<br /> {<br /> if (Mage::getSingleton(‘admin/session’)->isAllowed(‘sales/order/actions/view’)) {<br /> return $this->getUrl(‘*/sales_order/view’, array(‘order_id’ => $row->getId()));<br /> }<br /> return false;<br /> }</p> <p> public function getGridUrl()<br /> {<br /> return $this->getUrl(‘*/*/grid’, array(‘_current’=>true));<br /> }</p> <p>}</p> <p>