/**
* Retrieve count totals
*
* @param Mage_Adminhtml_Block_Report_Grid $grid
* @param string $from
* @param string $to
* @return Varien_Object
*/
public function countTotals($grid, $from, $to)
{
$columns = array();
foreach ($grid->getColumns() as $col) {
$columns[$col->getIndex()] = array("total" => $col->getTotal(), "value" => 0);
}
$count = 0;
$report = $grid->getCollection()->getReportFull($from, $to);
foreach ($report as $item) {
if ($grid->getSubReportSize() && $count >= $grid->getSubReportSize()) {
continue;
}
$data = $item->getData();
foreach ($columns as $field => $a) {
if ($field !== '') {
$columns[$field]['value'] = $columns[$field]['value'] + (isset($data[$field]) ? $data[$field] : 0);
}
}
$count++;
}
$data = array();
foreach ($columns as $field => $a) {
if ($a['total'] == 'avg') {
if ($field !== '') {
if ($count != 0) {
$data[$field] = $a['value'] / $count;
} else {
$data[$field] = 0;
}
}
} else {
if ($a['total'] == 'sum') {
if ($field !== '') {
$data[$field] = $a['value'];
}
} else {
if (strpos($a['total'], '/') !== FALSE) {
if ($field !== '') {
$data[$field] = 0;
}
}
}
}
}
$totals = new Varien_Object();
$totals->setData($data);
return $totals;
}
protected function _prepareColumns()
{
$this->addColumn('qty_ordered', array('header' => Mage::helper('reports')->__('Quantity Ordered'), 'align' => 'right', 'sortable' => false, 'type' => 'number', 'index' => 'ordered_qty'));
$this->addExportType('*/*/export-csv', Mage::helper('supplierfrontendproductuploader')->__('CSV'));
$this->addExportType('*/*/export-xml', Mage::helper('supplierfrontendproductuploader')->__('XML'));
return parent::_prepareColumns();
}
protected function _prepareColumns()
{
$this->addColumn('accounts', array('header' => Mage::helper('reports')->__('Number of New Accounts'), 'index' => 'accounts', 'total' => 'sum', 'type' => 'number'));
$this->addExportType('*/*/exportAccountsCsv', Mage::helper('reports')->__('CSV'));
$this->addExportType('*/*/exportAccountsExcel', Mage::helper('reports')->__('Excel XML'));
return parent::_prepareColumns();
}
protected function _prepareColumns()
{
$this->addColumn('promo_code', array('header' => Mage::helper('reports')->__('Promo Code'), 'type' => 'text', 'index' => 'promo_code', 'sortable' => true));
/*if (!Mage::app()->isSingleStoreMode()) {
$this->addColumn('store_id', array(
'header' => Mage::helper('sales')->__('Purchased From (Store)'),
'index' => 'store_id',
'type' => 'store',
'store_view'=> true,
'display_deleted' => true,
));
}*/
$this->addColumn('ckc_key_code_name', array('header' => Mage::helper('reports')->__('Description'), 'type' => 'text', 'index' => 'ckc_key_code_name', 'sortable' => false));
$this->addColumn('total_orders', array('header' => Mage::helper('reports')->__('Resp'), 'type' => 'text', 'index' => 'total_orders', 'sortable' => false));
$this->addColumn('gross_total', array('header' => Mage::helper('reports')->__('Grs Ord$'), 'type' => 'text', 'index' => 'gross_total', 'sortable' => false));
$this->addColumn('shipping_amount', array('header' => Mage::helper('reports')->__('S&H$'), 'type' => 'text', 'index' => 'shipping_amount', 'sortable' => false));
$this->addColumn('tax_amount', array('header' => Mage::helper('reports')->__('Sls Tax$'), 'type' => 'text', 'index' => 'tax_amount', 'sortable' => false));
$this->addColumn('grs_sls', array('header' => Mage::helper('reports')->__('Grs Sls$'), 'type' => 'text', 'index' => 'grs_sls', 'sortable' => false));
$this->addColumn('total_refunded', array('header' => Mage::helper('reports')->__('Retn$'), 'type' => 'text', 'index' => 'total_refunded', 'sortable' => false));
$this->addColumn('return_percent', array('header' => Mage::helper('reports')->__('Ret%'), 'type' => 'text', 'index' => 'return_percent', 'sortable' => false));
$this->addColumn('adjustment_positive', array('header' => Mage::helper('reports')->__('Adj$'), 'type' => 'text', 'index' => 'adjustment_positive', 'sortable' => false));
$this->addColumn('adjustment_percent', array('header' => Mage::helper('reports')->__('Adj%'), 'type' => 'text', 'index' => 'adjustment_percent', 'sortable' => false));
/*$this->addColumn('write_off', array(
'header' =>Mage::helper('reports')->__('W/O$'),
'type' => 'text',
'index' => 'write_off',
'sortable' => false
)
);*/
$this->addColumn('base_total_paid', array('header' => Mage::helper('reports')->__('Pay$'), 'type' => 'text', 'index' => 'base_total_paid', 'sortable' => false));
$this->addColumn('base_total_percent', array('header' => Mage::helper('reports')->__('Pay%'), 'type' => 'text', 'index' => 'base_total_percent', 'sortable' => false));
$this->addColumn('created_at', array('header' => Mage::helper('sales')->__('Created Date'), 'index' => 'created_at', 'type' => 'datetime', 'width' => '100px'));
$this->addExportType('*/*/exportPanelreportCsv', Mage::helper('reports')->__('CSV'));
return parent::_prepareColumns();
}
/**
* Prepare Grid columns
*
* @return Mage_Adminhtml_Block_Report_Product_Sold_Grid
*/
protected function _prepareColumns()
{
$this->addColumn('name', array('header' => Mage::helper('reports')->__('Product Name'), 'index' => 'name'));
$this->addColumn('ordered_qty', array('header' => Mage::helper('reports')->__('Quantity Ordered'), 'width' => '120px', 'align' => 'right', 'index' => 'ordered_qty', 'total' => 'sum', 'type' => 'number'));
$this->addExportType('*/*/exportSoldCsv', Mage::helper('reports')->__('CSV'));
$this->addExportType('*/*/exportSoldExcel', Mage::helper('reports')->__('Excel'));
return parent::_prepareColumns();
}
protected function _prepareColumns()
{
$this->addColumn('tax_rate', array('header' => Mage::helper('reports')->__('Tax Rate'), 'index' => 'tax_rate'));
$this->addColumn('orders', array('header' => Mage::helper('reports')->__('Number of Orders'), 'index' => 'orders', 'total' => 'sum'));
$this->addColumn('tax', array('header' => Mage::helper('reports')->__('Tax Amount'), 'type' => 'currency', 'currency_code' => (string) Mage::app()->getStore((int) $this->getParam('store'))->getBaseCurrencyCode(), 'index' => 'tax', 'total' => 'sum', 'renderer' => 'adminhtml/report_grid_column_renderer_currency'));
$this->addExportType('*/*/exportTaxCsv', Mage::helper('reports')->__('CSV'));
$this->addExportType('*/*/exportTaxExcel', Mage::helper('reports')->__('Excel'));
return parent::_prepareColumns();
}
protected function _prepareColumns()
{
$this->addColumn('name', array('header' => AO::helper('reports')->__('Product Name'), 'index' => 'name'));
$this->addColumn('price', array('header' => AO::helper('reports')->__('Price'), 'width' => '120px', 'type' => 'currency', 'currency_code' => $this->getCurrentCurrencyCode(), 'index' => 'price'));
$this->addColumn('ordered_qty', array('header' => AO::helper('reports')->__('Quantity Ordered'), 'width' => '120px', 'align' => 'right', 'index' => 'ordered_qty', 'total' => 'sum', 'type' => 'number'));
$this->addExportType('*/*/exportOrderedCsv', AO::helper('reports')->__('CSV'));
$this->addExportType('*/*/exportOrderedExcel', AO::helper('reports')->__('Excel'));
return parent::_prepareColumns();
}
protected function _prepareColumns()
{
$this->addColumn('name', array('header' => Mage::helper('reports')->__('Product Name'), 'index' => 'name'));
$this->addColumn('price', array('header' => Mage::helper('reports')->__('Price'), 'width' => '120px', 'type' => 'currency', 'currency_code' => (string) Mage::app()->getStore((int) $this->getParam('store'))->getBaseCurrencyCode(), 'index' => 'price', 'renderer' => 'adminhtml/report_grid_column_renderer_currency'));
$this->addColumn('ordered_qty', array('header' => Mage::helper('reports')->__('Quantity Ordered'), 'width' => '120px', 'align' => 'right', 'index' => 'ordered_qty', 'total' => 'sum'));
$this->addExportType('*/*/exportOrderedCsv', Mage::helper('reports')->__('CSV'));
$this->addExportType('*/*/exportOrderedExcel', Mage::helper('reports')->__('Excel'));
return parent::_prepareColumns();
}
protected function _prepareColumns()
{
$this->addColumn('shipping_description', array('header' => Mage::helper('reports')->__('Carrier/Method'), 'index' => 'shipping_description'));
$this->addColumn('orders', array('header' => Mage::helper('reports')->__('Number of Orders'), 'index' => 'orders', 'total' => 'sum', 'type' => 'number'));
$this->addColumn('total', array('header' => Mage::helper('reports')->__('Total Shipping'), 'type' => 'currency', 'currency_code' => $this->getCurrentCurrencyCode(), 'index' => 'total', 'total' => 'sum', 'renderer' => 'adminhtml/report_grid_column_renderer_currency'));
$this->addExportType('*/*/exportShippingCsv', Mage::helper('reports')->__('CSV'));
$this->addExportType('*/*/exportShippingExcel', Mage::helper('reports')->__('Excel'));
return parent::_prepareColumns();
}
protected function _prepareColumns()
{
$this->addColumn('name', array('header' => Mage::helper('reports')->__('Product Name'), 'index' => 'name', 'total' => Mage::helper('reports')->__('Subtotal')));
$this->addColumn('price', array('header' => Mage::helper('reports')->__('Price'), 'width' => '120px', 'type' => 'currency', 'currency_code' => $this->getCurrentCurrencyCode(), 'index' => 'price'));
$this->addColumn('views', array('header' => Mage::helper('reports')->__('Number of Views'), 'width' => '120px', 'align' => 'right', 'index' => 'views', 'total' => 'sum'));
$this->addExportType('*/*/exportViewedCsv', Mage::helper('reports')->__('CSV'));
$this->addExportType('*/*/exportViewedExcel', Mage::helper('reports')->__('Excel XML'));
return parent::_prepareColumns();
}
/**
* Prepare report grid columns
*
* @return Enterprise_Invitation_Block_Adminhtml_Report_Invitation_Order_Grid
*/
protected function _prepareColumns()
{
$this->addColumn('sent', array('header' => Mage::helper('enterprise_invitation')->__('Invitations Sent'), 'type' => 'number', 'index' => 'sent', 'width' => '200'));
$this->addColumn('accepted', array('header' => Mage::helper('enterprise_invitation')->__('Invitations Accepted'), 'type' => 'number', 'index' => 'accepted', 'width' => '200'));
$this->addColumn('purchased', array('header' => Mage::helper('enterprise_invitation')->__('Accepted and Purchased'), 'type' => 'number', 'index' => 'purchased', 'width' => '220'));
$this->addColumn('purchased_rate', array('header' => Mage::helper('enterprise_invitation')->__('Conversion Rate'), 'index' => 'purchased_rate', 'renderer' => 'enterprise_invitation/adminhtml_grid_column_renderer_percent', 'type' => 'string', 'width' => '100'));
$this->addExportType('*/*/exportOrderCsv', Mage::helper('enterprise_invitation')->__('CSV'));
$this->addExportType('*/*/exportOrderExcel', Mage::helper('enterprise_invitation')->__('Excel XML'));
return parent::_prepareColumns();
}
protected function _prepareColumns()
{
$this->addColumn('code', array('header' => AO::helper('reports')->__('Tax'), 'index' => 'code', 'type' => 'string'));
$this->addColumn('percent', array('header' => AO::helper('reports')->__('Rate'), 'index' => 'percent', 'type' => 'number', 'renderer' => 'adminhtml/report_grid_column_renderer_blanknumber', 'width' => '100'));
$this->addColumn('orders', array('header' => AO::helper('reports')->__('Number of Orders'), 'index' => 'orders', 'total' => 'sum', 'type' => 'number', 'width' => '100'));
$this->addColumn('tax', array('header' => AO::helper('reports')->__('Tax Amount'), 'type' => 'currency', 'currency_code' => $this->getCurrentCurrencyCode(), 'index' => 'tax', 'total' => 'sum', 'renderer' => 'adminhtml/report_grid_column_renderer_currency'));
$this->addExportType('*/*/exportTaxCsv', AO::helper('reports')->__('CSV'));
$this->addExportType('*/*/exportTaxExcel', AO::helper('reports')->__('Excel'));
return parent::_prepareColumns();
}
/**
* Prepare Grid columns
*
* @return Mage_Adminhtml_Block_Report_Product_Sold_Grid
*/
protected function _prepareColumns()
{
$this->addColumn('total_rewarded_sum', array('header' => Mage::helper('rewardpoints')->__('Total Rewarded'), 'align' => 'left', 'index' => 'total_rewarded_sum', 'width' => '250px', 'type' => 'text'));
$this->addColumn('total_redeemed_sum', array('header' => Mage::helper('rewardpoints')->__('Total Redeemed'), 'align' => 'left', 'index' => 'total_redeemed_sum', 'width' => '250px', 'type' => 'text'));
$this->addColumn('order_id_count', array('header' => Mage::helper('rewardpoints')->__('Number of Orders'), 'width' => '150px', 'align' => 'left', 'index' => 'order_id_count'));
$this->addColumn('sign_up_count', array('header' => Mage::helper('rewardpoints')->__('Number of Sign Ups'), 'width' => '150px', 'align' => 'left', 'index' => 'sign_up_count'));
$this->addColumn('customer_id_count', array('header' => Mage::helper('rewardpoints')->__('Number of Customers'), 'width' => '150px', 'align' => 'left', 'index' => 'customer_id_count'));
$this->addExportType('*/*/exportOverviewCsv', Mage::helper('reports')->__('CSV'));
$this->addExportType('*/*/exportOverviewExcel', Mage::helper('reports')->__('Excel XML'));
return parent::_prepareColumns();
}
/**
* Prepare Grid columns
*
* @return Mage_Adminhtml_Block_Report_Product_Sold_Grid
*/
protected function _prepareColumns()
{
$this->addColumn('total_redeemed_sum', array('header' => Mage::helper('rewardpoints')->__('Total Redeemed'), 'align' => 'left', 'index' => 'total_redeemed_sum', 'width' => '250px', 'type' => 'text'));
$this->addColumn('order_id_count', array('header' => Mage::helper('rewardpoints')->__('Number of Orders'), 'width' => '150px', 'align' => 'left', 'index' => 'order_id_count'));
$this->addColumn('avg_redeemed_per_order', array('header' => Mage::helper('rewardpoints')->__('Avg Redeemed per Order'), 'width' => '150px', 'align' => 'left', 'index' => 'avg_redeemed_per_order'));
$this->addColumn('total_sales_sum', array('header' => Mage::helper('rewardpoints')->__('Total Sales'), 'width' => '150px', 'align' => 'left', 'index' => 'total_sales_sum'));
$this->addColumn('total_point_discount_sum', array('header' => Mage::helper('rewardpoints')->__('Total Discount'), 'width' => '150px', 'align' => 'left', 'index' => 'total_point_discount_sum'));
$this->addExportType('*/*/exportRedeemedCsv', Mage::helper('reports')->__('CSV'));
$this->addExportType('*/*/exportRedeemedExcel', Mage::helper('reports')->__('Excel XML'));
return parent::_prepareColumns();
}
/**
* Prepare report grid columns
*
* @return Enterprise_Invitation_Block_Adminhtml_Report_Invitation_General_Grid
*/
protected function _prepareColumns()
{
$this->addColumn('sent', array('header' => Mage::helper('enterprise_invitation')->__('Sent'), 'type' => 'number', 'index' => 'sent'));
$this->addColumn('accepted', array('header' => Mage::helper('enterprise_invitation')->__('Accepted'), 'type' => 'number', 'index' => 'accepted', 'width' => ''));
$this->addColumn('canceled', array('header' => Mage::helper('enterprise_invitation')->__('Discarded'), 'type' => 'number', 'index' => 'canceled', 'width' => ''));
$this->addColumn('accepted_rate', array('header' => Mage::helper('enterprise_invitation')->__('Acceptance Rate'), 'index' => 'accepted_rate', 'renderer' => 'enterprise_invitation/adminhtml_grid_column_renderer_percent', 'type' => 'string', 'width' => '170'));
$this->addColumn('canceled_rate', array('header' => Mage::helper('enterprise_invitation')->__('Discard Rate'), 'index' => 'canceled_rate', 'type' => 'number', 'renderer' => 'enterprise_invitation/adminhtml_grid_column_renderer_percent', 'width' => '170'));
$this->addExportType('*/*/exportCsv', Mage::helper('enterprise_invitation')->__('CSV'));
$this->addExportType('*/*/exportExcel', Mage::helper('enterprise_invitation')->__('Excel XML'));
return parent::_prepareColumns();
}
protected function _prepareColumns()
{
$this->addColumn('name', array('header' => $this->__('Customer Name'), 'sortable' => false, 'index' => 'name'));
$this->addColumn('orders_count', array('header' => $this->__('Number of Orders'), 'width' => '100px', 'sortable' => false, 'index' => 'orders_count', 'total' => 'sum', 'type' => 'number'));
$baseCurrencyCode = $this->getCurrentCurrencyCode();
$this->addColumn('orders_avg_amount', array('header' => $this->__('Average Order Amount'), 'width' => '200px', 'align' => 'right', 'sortable' => false, 'type' => 'currency', 'currency_code' => $baseCurrencyCode, 'index' => 'orders_avg_amount', 'total' => 'orders_sum_amount/orders_count', 'renderer' => 'adminhtml/report_grid_column_renderer_currency'));
$this->addColumn('orders_sum_amount', array('header' => $this->__('Total Order Amount'), 'width' => '200px', 'align' => 'right', 'sortable' => false, 'type' => 'currency', 'currency_code' => $baseCurrencyCode, 'index' => 'orders_sum_amount', 'total' => 'sum', 'renderer' => 'adminhtml/report_grid_column_renderer_currency'));
$this->addExportType('*/*/exportOrdersCsv', Mage::helper('reports')->__('CSV'));
$this->addExportType('*/*/exportOrdersExcel', Mage::helper('reports')->__('Excel XML'));
return parent::_prepareColumns();
}
protected function _prepareColumns()
{
$this->addColumn('orders', array('header' => Mage::helper('reports')->__('Number of Refunded Orders'), 'index' => 'orders', 'total' => 'sum', 'type' => 'number'));
$currency_code = $this->getCurrentCurrencyCode();
$this->addColumn('refunded', array('header' => Mage::helper('reports')->__('Total Refunded'), 'type' => 'currency', 'currency_code' => $currency_code, 'index' => 'refunded', 'total' => 'sum', 'renderer' => 'adminhtml/report_grid_column_renderer_currency'));
$this->addColumn('online_refunded', array('header' => Mage::helper('reports')->__('Online Refunded'), 'type' => 'currency', 'currency_code' => $currency_code, 'index' => 'online_refunded', 'total' => 'sum', 'renderer' => 'adminhtml/report_grid_column_renderer_currency'));
$this->addColumn('offline_refunded', array('header' => Mage::helper('reports')->__('Offline Refunded'), 'type' => 'currency', 'currency_code' => $currency_code, 'index' => 'offline_refunded', 'total' => 'sum', 'renderer' => 'adminhtml/report_grid_column_renderer_currency'));
$this->addExportType('*/*/exportRefundedCsv', Mage::helper('reports')->__('CSV'));
$this->addExportType('*/*/exportRefundedExcel', Mage::helper('reports')->__('Excel'));
return parent::_prepareColumns();
}
protected function _prepareColumns()
{
$this->addColumn('orders', array('header' => Mage::helper('reports')->__('Number of Orders'), 'index' => 'orders', 'total' => 'sum'));
$currency_code = (string) Mage::app()->getStore((int) $this->getParam('store'))->getBaseCurrencyCode();
$this->addColumn('invoiced', array('header' => Mage::helper('reports')->__('Total invoiced'), 'type' => 'currency', 'currency_code' => $currency_code, 'index' => 'invoiced', 'total' => 'sum', 'renderer' => 'adminhtml/report_grid_column_renderer_currency'));
$this->addColumn('invoiced_captured', array('header' => Mage::helper('reports')->__('Total invoiced captured'), 'type' => 'currency', 'currency_code' => $currency_code, 'index' => 'invoiced_captured', 'total' => 'sum', 'renderer' => 'adminhtml/report_grid_column_renderer_currency'));
$this->addColumn('invoiced_not_captured', array('header' => Mage::helper('reports')->__('Total invoiced not captured'), 'type' => 'currency', 'currency_code' => $currency_code, 'index' => 'invoiced_not_captured', 'total' => 'sum', 'renderer' => 'adminhtml/report_grid_column_renderer_currency'));
$this->addExportType('*/*/exportInvoicedCsv', Mage::helper('reports')->__('CSV'));
$this->addExportType('*/*/exportInvoicedExcel', Mage::helper('reports')->__('Excel'));
return parent::_prepareColumns();
}
protected function _prepareColumns()
{
$this->addColumn('template_code', array('header' => Mage::helper('followupemail')->__('Email Template'), 'index' => 'template_code'));
$this->addColumn('sent', array('header' => Mage::helper('followupemail')->__('Sent'), 'width' => '150px', 'align' => 'left', 'index' => 'sent'));
$this->addColumn('unread', array('header' => Mage::helper('followupemail')->__('UnRead'), 'width' => '150px', 'align' => 'left', 'index' => 'unread'));
$this->addColumn('readtotal', array('header' => Mage::helper('followupemail')->__('Read'), 'width' => '150px', 'align' => 'left', 'index' => 'readtotal'));
$this->addColumn('clicked', array('header' => Mage::helper('followupemail')->__('Clicked'), 'width' => '150px', 'align' => 'left', 'index' => 'clicked'));
$this->addColumn('purchased', array('header' => Mage::helper('followupemail')->__('Purchased'), 'width' => '150px', 'align' => 'left', 'index' => 'purchased'));
$this->addExportType('*/*/exportEmailsCsv', Mage::helper('reports')->__('CSV'));
$this->addExportType('*/*/exportEmailsExcel', Mage::helper('reports')->__('Excel XML'));
return parent::_prepareColumns();
}
public function __construct()
{
parent::__construct();
$this->setId($this->_gridId);
$this->setDefaultSort($this->_defaultSort);
$this->setDefaultDir($this->_defaultSortDir);
$this->setTemplate('widget/grid.phtml');
$this->setFilterVisibility(false);
$this->setPagerVisibility(false);
$this->setCountTotals(true);
$this->prepareFilters();
}
protected function _prepareColumns()
{
$this->addColumn('coupon_code', array('header' => $this->__('Coupon Code'), 'sortable' => false, 'index' => 'coupon_code'));
$this->addColumn('uses', array('header' => $this->__('Number of Use'), 'sortable' => false, 'index' => 'uses', 'total' => 'sum', 'type' => 'number'));
$currency_code = $this->getCurrentCurrencyCode();
$this->addColumn('subtotal', array('header' => $this->__('Subtotal Amount'), 'sortable' => false, 'type' => 'currency', 'currency_code' => $currency_code, 'index' => 'subtotal', 'total' => 'sum', 'renderer' => 'adminhtml/report_grid_column_renderer_currency'));
$this->addColumn('discount', array('header' => $this->__('Discount Amount'), 'sortable' => false, 'type' => 'currency', 'currency_code' => $currency_code, 'index' => 'discount', 'total' => 'sum', 'renderer' => 'adminhtml/report_grid_column_renderer_currency'));
$this->addColumn('total', array('header' => $this->__('Total Amount'), 'sortable' => false, 'type' => 'currency', 'currency_code' => $currency_code, 'index' => 'total', 'total' => 'sum', 'renderer' => 'adminhtml/report_grid_column_renderer_currency'));
$this->addExportType('*/*/exportCouponsCsv', AO::helper('reports')->__('CSV'));
$this->addExportType('*/*/exportCouponsExcel', AO::helper('reports')->__('Excel'));
return parent::_prepareColumns();
}
/**
* Prepare report grid columns
*
* @return Enterprise_Invitation_Block_Adminhtml_Report_Invitation_Customer_Grid
*/
protected function _prepareColumns()
{
$this->addColumn('id', array('header' => Mage::helper('enterprise_invitation')->__('ID'), 'index' => 'entity_id'));
$this->addColumn('name', array('header' => Mage::helper('enterprise_invitation')->__('Name'), 'index' => 'name'));
$this->addColumn('email', array('header' => Mage::helper('enterprise_invitation')->__('Email'), 'index' => 'email'));
$this->addColumn('group', array('header' => Mage::helper('enterprise_invitation')->__('Group'), 'index' => 'group_name'));
$this->addColumn('sent', array('header' => Mage::helper('enterprise_invitation')->__('Invitations Sent'), 'type' => 'number', 'index' => 'sent'));
$this->addColumn('accepted', array('header' => Mage::helper('enterprise_invitation')->__('Invitations Accepted'), 'type' => 'number', 'index' => 'accepted'));
$this->addExportType('*/*/exportCustomerCsv', Mage::helper('enterprise_invitation')->__('CSV'));
$this->addExportType('*/*/exportCustomerExcel', Mage::helper('enterprise_invitation')->__('Excel XML'));
return parent::_prepareColumns();
}
protected function _prepareColumns()
{
$this->addColumn('orders', array('header' => Mage::helper('reports')->__('Number of Orders'), 'index' => 'orders', 'total' => 'sum', 'type' => 'number'));
$this->addColumn('orders_invoiced', array('header' => Mage::helper('reports')->__('Number of Ivoiced Orders'), 'index' => 'orders_invoiced', 'total' => 'sum', 'type' => 'number'));
$currency_code = $this->getCurrentCurrencyCode();
$this->addColumn('invoiced', array('header' => Mage::helper('reports')->__('Total Invoiced'), 'type' => 'currency', 'currency_code' => $currency_code, 'index' => 'invoiced', 'total' => 'sum', 'renderer' => 'adminhtml/report_grid_column_renderer_currency'));
$this->addColumn('invoiced_captured', array('header' => Mage::helper('reports')->__('Total Invoiced Captured'), 'type' => 'currency', 'currency_code' => $currency_code, 'index' => 'invoiced_captured', 'total' => 'sum', 'renderer' => 'adminhtml/report_grid_column_renderer_currency'));
$this->addColumn('invoiced_not_captured', array('header' => Mage::helper('reports')->__('Total Invoiced not Captured'), 'type' => 'currency', 'currency_code' => $currency_code, 'index' => 'invoiced_not_captured', 'total' => 'sum', 'renderer' => 'adminhtml/report_grid_column_renderer_currency'));
$this->addExportType('*/*/exportInvoicedCsv', Mage::helper('reports')->__('CSV'));
$this->addExportType('*/*/exportInvoicedExcel', Mage::helper('reports')->__('Excel'));
return parent::_prepareColumns();
}
/**
* Prepare Grid columns
*
* @return Mage_Adminhtml_Block_Report_Product_Sold_Grid
*/
protected function _prepareColumns()
{
$this->addColumn('customer_invited', array('header' => Mage::helper('affiliate')->__('Affiliate Account'), 'align' => 'left', 'index' => 'customer_invited', 'width' => '250px', 'type' => 'text', 'renderer' => 'affiliate/adminhtml_renderer_emailreport'));
$this->addColumn('customer_id_count', array('header' => Mage::helper('affiliate')->__('# of customers referred'), 'width' => '150px', 'align' => 'left', 'index' => 'customer_id_count'));
$this->addColumn('order_id_count', array('header' => Mage::helper('affiliate')->__('# of orders'), 'width' => '150px', 'align' => 'left', 'index' => 'order_id_count'));
$this->addColumn('product_id_count', array('header' => Mage::helper('affiliate')->__('# of Sales Items'), 'align' => 'left', 'index' => 'product_id_count', 'width' => '250px'));
$this->addColumn('total_amount_sum', array('header' => Mage::helper('affiliate')->__('Sales Total'), 'index' => 'total_amount_sum', 'width' => '150px', 'type' => 'price', 'currency_code' => Mage::app()->getBaseCurrencyCode()));
$this->addColumn('history_commission_sum', array('header' => Mage::helper('affiliate')->__('Commission Total'), 'index' => 'history_commission_sum', 'width' => '150px', 'type' => 'price', 'currency_code' => Mage::app()->getBaseCurrencyCode()));
$this->addColumn('history_discount_sum', array('header' => Mage::helper('affiliate')->__('Customer Discount Total'), 'align' => 'center', 'width' => '150px', 'index' => 'history_discount_sum', 'type' => 'price', 'currency_code' => Mage::app()->getBaseCurrencyCode()));
$this->addExportType('*/*/exportSalesCsv', Mage::helper('reports')->__('CSV'));
$this->addExportType('*/*/exportSalesExcel', Mage::helper('reports')->__('Excel XML'));
return parent::_prepareColumns();
}
protected function _prepareColumns()
{
$this->addColumn('name', array('header' => Mage::helper('payperrentals')->__('Product'), 'index' => 'order_items_name', 'sortable' => false, 'align' => 'left', 'width' => '400px'));
$this->addColumn('sku', array('header' => Mage::helper('payperrentals')->__('SKU'), 'index' => 'sku', 'width' => '400px', 'sortable' => false));
$this->addColumn('stock_inventory', array('header' => Mage::helper('payperrentals')->__('Total Inventory'), 'index' => 'stock_inventory', 'sortable' => false, 'align' => 'right', 'width' => '100px', 'type' => 'number'));
$this->addColumn('total_inventory_cost', array('header' => Mage::helper('payperrentals')->__('Total Inventory Cost'), 'index' => 'total_inventory_cost', 'sortable' => false, 'align' => 'right', 'width' => '100px', 'total' => 'sum', 'filter' => 'adminhtml/widget_grid_column_filter_range', 'type' => 'currency', 'currency_code' => Mage::app()->getStore()->getCurrentCurrencyCode()));
$this->addColumn('monthly_revenue', array('header' => Mage::helper('payperrentals')->__('Monthly Revenue'), 'index' => 'monthly_revenue', 'sortable' => false, 'align' => 'right', 'width' => '100px', 'total' => 'sum', 'filter' => 'adminhtml/widget_grid_column_filter_range', 'type' => 'currency', 'currency_code' => Mage::app()->getStore()->getCurrentCurrencyCode()));
$this->addColumn('gross_profit', array('header' => Mage::helper('payperrentals')->__('Gross Profit / Loss'), 'index' => 'gross_profit', 'sortable' => false, 'align' => 'right', 'width' => '100px', 'total' => 'sum', 'filter' => 'adminhtml/widget_grid_column_filter_range', 'type' => 'currency', 'currency_code' => Mage::app()->getStore()->getCurrentCurrencyCode()));
$this->addExportType('*/*/exportRoiCsv', Mage::helper('adminhtml')->__('CSV'));
$this->addExportType('*/*/exportRoiExcel', Mage::helper('adminhtml')->__('Excel XML'));
parent::_prepareColumns();
return $this;
}
protected function _prepareColumns()
{
$this->addColumn('name', array('header' => Mage::helper('payperrentals')->__('Product'), 'index' => 'order_items_name', 'sortable' => false, 'align' => 'left', 'width' => '400px'));
$this->addColumn('sku', array('header' => Mage::helper('payperrentals')->__('SKU'), 'index' => 'sku', 'width' => '400px', 'sortable' => false));
$this->addColumn('stock_inventory', array('header' => Mage::helper('payperrentals')->__('Total Inventory'), 'index' => 'stock_inventory', 'sortable' => true, 'align' => 'right', 'width' => '100px', 'type' => 'number'));
$this->addColumn('booked_inventory', array('header' => Mage::helper('payperrentals')->__('Booked Inventory'), 'index' => 'booked_inventory', 'sortable' => true, 'align' => 'right', 'width' => '100px', 'type' => 'number'));
$this->addColumn('total_sent_qty', array('header' => Mage::helper('payperrentals')->__('Total Sent Inventory'), 'index' => 'total_sent_qty', 'sortable' => true, 'align' => 'right', 'width' => '100px', 'type' => 'number'));
$this->addColumn('total_returned_qty', array('header' => Mage::helper('payperrentals')->__('Total Returned Inventory'), 'index' => 'total_returned_qty', 'sortable' => true, 'align' => 'right', 'width' => '100px', 'type' => 'number'));
$this->addColumn('current_stock', array('header' => Mage::helper('payperrentals')->__('Current Inventory'), 'index' => 'current_stock', 'sortable' => true, 'align' => 'right', 'width' => '100px', 'type' => 'number'));
$this->addExportType('*/*/exportStockCsv', Mage::helper('payperrentals')->__('CSV'));
$this->addExportType('*/*/exportStockExcel', Mage::helper('payperrentals')->__('Excel XML'));
parent::_prepareColumns();
return $this;
}
protected function _prepareColumns()
{
$this->addColumn('name', array('header' => Mage::helper('payperrentals')->__('Product'), 'index' => 'order_items_name', 'sortable' => false, 'align' => 'left', 'width' => '400px'));
$this->addColumn('sku', array('header' => Mage::helper('payperrentals')->__('SKU'), 'index' => 'sku', 'width' => '400px', 'sortable' => false));
$this->addColumn('time_diff', array('header' => Mage::helper('payperrentals')->__('Amount of Time Rented'), 'index' => 'time_diff', 'sortable' => false, 'align' => 'left', 'width' => '300px', 'filter' => false, 'renderer' => 'payperrentals/adminhtml_report_grid_period'));
$this->addColumn('ordered_qty', array('header' => Mage::helper('payperrentals')->__('Times Rented'), 'index' => 'ordered_qty', 'sortable' => false, 'align' => 'right', 'width' => '100px', 'type' => 'number'));
$this->addColumn('stock_inventory', array('header' => Mage::helper('payperrentals')->__('Total Inventory'), 'index' => 'stock_inventory', 'sortable' => false, 'align' => 'right', 'width' => '100px', 'type' => 'number'));
$this->addColumn('today_booked', array('header' => Mage::helper('payperrentals')->__('Booked Inventory'), 'index' => 'today_booked', 'sortable' => false, 'align' => 'right', 'width' => '100px', 'type' => 'number'));
$this->addColumn('current_stock', array('header' => Mage::helper('payperrentals')->__('Current Inventory'), 'index' => 'current_stock', 'sortable' => false, 'align' => 'right', 'width' => '100px', 'type' => 'number'));
$this->addColumn('revenue', array('header' => Mage::helper('payperrentals')->__('Revenue'), 'index' => 'revenue', 'sortable' => false, 'align' => 'right', 'width' => '100px', 'total' => 'sum', 'type' => 'price', 'filter' => 'adminhtml/widget_grid_column_filter_range', 'currency_code' => Mage::app()->getStore()->getCurrentCurrencyCode()));
$this->addExportType('*/*/exportRentedCsv', Mage::helper('adminhtml')->__('CSV'));
$this->addExportType('*/*/exportRentedExcel', Mage::helper('adminhtml')->__('Excel XML'));
parent::_prepareColumns();
return $this;
}
/**
* Prepare Grid columns
*
* @return Mage_Adminhtml_Block_Report_Product_Sold_Grid
*/
protected function _prepareColumns()
{
$this->addColumn('sku', array('header' => Mage::helper('reports')->__('Product SKU'), 'index' => 'order_items_sku'));
$this->addColumn('name', array('header' => Mage::helper('reports')->__('Product Name'), 'index' => 'order_items_name'));
$this->addColumn('ordered_qty', array('header' => Mage::helper('reports')->__('Quantity Ordered'), 'width' => '100px', 'align' => 'right', 'header_css_class' => 'a-right', 'index' => 'ordered_qty', 'total' => 'sum', 'type' => 'number'));
$this->addColumn('invoiced_qty', array('header' => Mage::helper('reports')->__('Quantity Invoiced'), 'width' => '100px', 'header_css_class' => 'a-right', 'align' => 'right', 'index' => 'invoiced_qty', 'total' => 'sum', 'type' => 'number'));
$this->addColumn('refunded_qty', array('header' => Mage::helper('reports')->__('Quantity Refunded'), 'width' => '100px', 'header_css_class' => 'a-right', 'align' => 'right', 'index' => 'refunded_qty', 'total' => 'sum', 'type' => 'number'));
$this->addColumn('shipped_qty', array('header' => Mage::helper('reports')->__('Quantity Shipped'), 'width' => '100px', 'header_css_class' => 'a-right', 'align' => 'right', 'index' => 'shipped_qty', 'total' => 'sum', 'type' => 'number'));
$this->addColumn('base_price', array('header' => Mage::helper('reports')->__('Product Base Price'), 'width' => '100px', 'header_css_class' => 'a-right', 'index' => 'base_price', 'align' => 'right', 'type' => 'number'));
$this->addColumn('uniquepurchase', array('header' => Mage::helper('reports')->__('Unique Product Purchased'), 'width' => '150px', 'header_css_class' => 'a-right', 'index' => 'uniquepurchase', 'align' => 'right', 'type' => 'number'));
$this->addColumn('base_price_total', array('header' => Mage::helper('reports')->__('Total'), 'width' => '60px', 'header_css_class' => 'a-right', 'index' => 'base_price_total', 'align' => 'right', 'total' => 'sum', 'type' => 'number'));
$this->addExportType('*/*/exportProductCsv', Mage::helper('advancedreports')->__('CSV'));
$this->addExportType('*/*/exportProductExcel', Mage::helper('advancedreports')->__('Excel XML'));
return parent::_prepareColumns();
}
protected function _prepareColumns()
{
$this->addColumn('orders', array('header' => Mage::helper('reports')->__('Number of Orders'), 'index' => 'orders', 'total' => 'sum'));
$this->addColumn('items', array('header' => Mage::helper('reports')->__('Items Ordered'), 'index' => 'items', 'total' => 'sum'));
$currency_code = (string) Mage::app()->getStore((int) $this->getParam('store'))->getBaseCurrencyCode();
$this->addColumn('subtotal', array('header' => Mage::helper('reports')->__('Subtotal'), 'type' => 'currency', 'currency_code' => $currency_code, 'index' => 'subtotal', 'total' => 'sum', 'renderer' => 'adminhtml/report_grid_column_renderer_currency'));
$this->addColumn('tax', array('header' => Mage::helper('reports')->__('Tax'), 'type' => 'currency', 'currency_code' => $currency_code, 'index' => 'tax', 'total' => 'sum', 'renderer' => 'adminhtml/report_grid_column_renderer_currency'));
$this->addColumn('shipping', array('header' => Mage::helper('reports')->__('Shipping'), 'type' => 'currency', 'currency_code' => $currency_code, 'index' => 'shipping', 'total' => 'sum', 'renderer' => 'adminhtml/report_grid_column_renderer_currency'));
$this->addColumn('discount', array('header' => Mage::helper('reports')->__('Discounts'), 'type' => 'currency', 'currency_code' => $currency_code, 'index' => 'discount', 'total' => 'sum', 'renderer' => 'adminhtml/report_grid_column_renderer_currency'));
$this->addColumn('total', array('header' => Mage::helper('reports')->__('Total'), 'type' => 'currency', 'currency_code' => $currency_code, 'index' => 'total', 'total' => 'sum', 'renderer' => 'adminhtml/report_grid_column_renderer_currency'));
$this->addColumn('invoiced', array('header' => Mage::helper('reports')->__('Invoiced'), 'type' => 'currency', 'currency_code' => $currency_code, 'index' => 'invoiced', 'total' => 'sum', 'renderer' => 'adminhtml/report_grid_column_renderer_currency'));
$this->addColumn('refunded', array('header' => Mage::helper('reports')->__('Refunded'), 'type' => 'currency', 'currency_code' => $currency_code, 'index' => 'refunded', 'total' => 'sum', 'renderer' => 'adminhtml/report_grid_column_renderer_currency'));
$this->addExportType('*/*/exportSalesCsv', Mage::helper('reports')->__('CSV'));
$this->addExportType('*/*/exportSalesExcel', Mage::helper('reports')->__('Excel'));
return parent::_prepareColumns();
}
protected function _prepareColumns()
{
$this->addColumn('name', array('header' => Mage::helper('reports')->__('Product Name'), 'index' => 'name'));
$baseCurrencyCode = $this->getCurrentCurrencyCode();
$this->addColumn('price', array('header' => Mage::helper('reports')->__('Price'), 'width' => '120px', 'type' => 'currency', 'currency_code' => $baseCurrencyCode, 'index' => 'price', 'rate' => $this->getRate($baseCurrencyCode)));
/* Added by Murugesh */
/* $this->addColumn('sku', array(
'header' =>Mage::helper('reports')->__('Product Sku'),
'sortable' =>false,
'index' =>'sku'
)); */
/* End */
$this->addColumn('ordered_qty', array('header' => Mage::helper('reports')->__('Quantity Ordered'), 'width' => '120px', 'align' => 'right', 'index' => 'ordered_qty', 'total' => 'sum', 'type' => 'number'));
$this->addExportType('*/*/exportOrderedCsv', Mage::helper('reports')->__('CSV'));
$this->addExportType('*/*/exportOrderedExcel', Mage::helper('reports')->__('Excel XML'));
return parent::_prepareColumns();
}
