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(); }
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(); }