*/ class Mage_Adminhtml_Block_Report_Sales_Refunded_Grid extends Mage_Adminhtml_Block_Report_Grid_Abstract { protected $_columnGroupBy = 'period'; public function __construct() { parent::__construct(); $this->setCountTotals(true); } public function getResourceCollectionName() { return ($this->getFilterData()->getData('report_type') == 'created_at_refunded') ? 'sales/report_refunded_collection_refunded' : 'sales/report_refunded_collection_order'; } protected function _prepareColumns() { $this->addColumn('period', array( 'header' => Mage::helper('sales')->__('Period'), 'index' => 'period', 'width' => 100, 'sortable' => false, 'period_type' => $this->getPeriodType(), 'renderer' => 'adminhtml/report_sales_grid_column_renderer_date', 'totals_label' => Mage::helper('sales')->__('Total'), 'html_decorators' => array('nobr'), )); $this->addColumn('orders_count', array( 'header' => Mage::helper('sales')->__('Number of Refunded Orders'), 'index' => 'orders_count', 'type' => 'number', 'total' => 'sum', 'sortable' => false )); if ($this->getFilterData()->getStoreIds()) { $this->setStoreIds(explode(',', $this->getFilterData()->getStoreIds())); } $currencyCode = $this->getCurrentCurrencyCode(); $rate = $this->getRate($currencyCode); $this->addColumn('refunded', array( 'header' => Mage::helper('sales')->__('Total Refunded'), 'type' => 'currency', 'currency_code' => $currencyCode, 'index' => 'refunded', 'total' => 'sum', 'sortable' => false, 'rate' => $rate, )); $this->addColumn('online_refunded', array( 'header' => Mage::helper('sales')->__('Online Refunded'), 'type' => 'currency', 'currency_code' => $currencyCode, 'index' => 'online_refunded', 'total' => 'sum', 'sortable' => false, 'rate' => $rate, )); $this->addColumn('offline_refunded', array( 'header' => Mage::helper('sales')->__('Offline Refunded'), 'type' => 'currency', 'currency_code' => $currencyCode, 'index' => 'offline_refunded', 'total' => 'sum', 'sortable' => false, 'rate' => $rate, )); $this->addExportType('*/*/exportRefundedCsv', Mage::helper('adminhtml')->__('CSV')); $this->addExportType('*/*/exportRefundedExcel', Mage::helper('adminhtml')->__('Excel XML')); return parent::_prepareColumns(); } }