protected function _prepareColumns()
 {
     $this->addColumn('entity_id', array('header' => Mage::helper('reports')->__('ID'), 'width' => '50px', 'align' => 'right', 'index' => 'entity_id'));
     $this->addColumn('firstname', array('header' => Mage::helper('reports')->__('First Name'), 'index' => 'firstname'));
     $this->addColumn('lastname', array('header' => Mage::helper('reports')->__('Last Name'), 'index' => 'lastname'));
     $this->addColumn('items', array('header' => Mage::helper('reports')->__('Items in Cart'), 'width' => '70px', 'sortable' => false, 'align' => 'right', 'index' => 'items'));
     $currencyCode = $this->getCurrentCurrencyCode();
     $this->addColumn('total', array('header' => Mage::helper('reports')->__('Total'), 'width' => '70px', 'sortable' => false, 'type' => 'currency', 'align' => 'right', 'currency_code' => $currencyCode, 'index' => 'total', 'renderer' => 'adminhtml/report_grid_column_renderer_currency', 'rate' => $this->getRate($currencyCode)));
     $this->setFilterVisibility(false);
     $this->addExportType('*/*/exportCustomerCsv', Mage::helper('reports')->__('CSV'));
     $this->addExportType('*/*/exportCustomerExcel', Mage::helper('reports')->__('Excel XML'));
     return parent::_prepareColumns();
 }
 protected function _prepareColumns()
 {
     $this->addColumn('entity_id', array('header' => Mage::helper('reports')->__('ID'), 'width' => '50px', 'align' => 'right', 'index' => 'entity_id'));
     $this->addColumn('name', array('header' => Mage::helper('reports')->__('Product Name'), 'index' => 'name'));
     $currencyCode = $this->getCurrentCurrencyCode();
     $this->addColumn('price', array('header' => Mage::helper('reports')->__('Price'), 'width' => '80px', 'type' => 'currency', 'currency_code' => $currencyCode, 'index' => 'price', 'renderer' => 'adminhtml/report_grid_column_renderer_currency', 'rate' => $this->getRate($currencyCode)));
     $this->addColumn('carts', array('header' => Mage::helper('reports')->__('Carts'), 'width' => '80px', 'align' => 'right', 'index' => 'carts'));
     $this->addColumn('orders', array('header' => Mage::helper('reports')->__('Orders'), 'width' => '80px', 'align' => 'right', 'index' => 'orders'));
     $this->setFilterVisibility(false);
     $this->addExportType('*/*/exportProductCsv', Mage::helper('reports')->__('CSV'));
     $this->addExportType('*/*/exportProductExcel', Mage::helper('reports')->__('Excel XML'));
     return parent::_prepareColumns();
 }
Exemple #3
0
 protected function _prepareColumns()
 {
     $this->addColumn('customer_name', array('header' => Mage::helper('reports')->__('Customer Name'), 'index' => 'customer_name', 'sortable' => false));
     $this->addColumn('email', array('header' => Mage::helper('reports')->__('Email'), 'index' => 'email', 'sortable' => false));
     $this->addColumn('items_count', array('header' => Mage::helper('reports')->__('Number of Items'), 'width' => '80px', 'align' => 'right', 'index' => 'items_count', 'sortable' => false, 'type' => 'number'));
     $this->addColumn('items_qty', array('header' => Mage::helper('reports')->__('Quantity of Items'), 'width' => '80px', 'align' => 'right', 'index' => 'items_qty', 'sortable' => false, 'type' => 'number'));
     if ($this->getRequest()->getParam('website')) {
         $storeIds = Mage::app()->getWebsite($this->getRequest()->getParam('website'))->getStoreIds();
     } else {
         if ($this->getRequest()->getParam('group')) {
             $storeIds = Mage::app()->getGroup($this->getRequest()->getParam('group'))->getStoreIds();
         } else {
             if ($this->getRequest()->getParam('store')) {
                 $storeIds = array((int) $this->getRequest()->getParam('store'));
             } else {
                 $storeIds = array();
             }
         }
     }
     $this->setStoreIds($storeIds);
     $currencyCode = $this->getCurrentCurrencyCode();
     $this->addColumn('subtotal', array('header' => Mage::helper('reports')->__('Subtotal'), 'width' => '80px', 'type' => 'currency', 'currency_code' => $currencyCode, 'index' => 'subtotal', 'sortable' => false, 'renderer' => 'adminhtml/report_grid_column_renderer_currency', 'rate' => $this->getRate($currencyCode)));
     $this->addColumn('coupon_code', array('header' => Mage::helper('reports')->__('Applied Coupon'), 'width' => '80px', 'index' => 'coupon_code', 'sortable' => false));
     $this->addColumn('created_at', array('header' => Mage::helper('reports')->__('Created At'), 'width' => '170px', 'type' => 'datetime', 'index' => 'created_at', 'filter_index' => 'main_table.created_at', 'sortable' => false));
     $this->addColumn('updated_at', array('header' => Mage::helper('reports')->__('Updated At'), 'width' => '170px', 'type' => 'datetime', 'index' => 'updated_at', 'filter_index' => 'main_table.updated_at', 'sortable' => false));
     $this->addColumn('remote_ip', array('header' => Mage::helper('reports')->__('IP Address'), 'width' => '80px', 'index' => 'remote_ip', 'sortable' => false));
     $this->addExportType('*/*/exportAbandonedCsv', Mage::helper('reports')->__('CSV'));
     $this->addExportType('*/*/exportAbandonedExcel', Mage::helper('reports')->__('Excel XML'));
     return parent::_prepareColumns();
 }