protected function _prepareColumns()
{
$this->addColumn('name', array('header' => Mage::helper('productreports')->__('Product Name'), 'width' => '250px', 'index' => 'name', 'sortable' => false));
$this->addColumn('category', array('header' => Mage::helper('productreports')->__('Category'), 'width' => '250px', 'index' => 'sku', 'renderer' => 'FCM_Productreports_Block_Adminhtml_Report_Renderer_Department', 'sortable' => false));
$this->addColumn('subcategory', array('header' => Mage::helper('productreports')->__('Sub Category'), 'width' => '250px', 'index' => 'sku', 'renderer' => 'FCM_Productreports_Block_Adminhtml_Report_Renderer_Category', 'sortable' => false));
$this->addColumn('configsku', array('header' => Mage::helper('productreports')->__('Config SKU'), 'width' => '250px', 'index' => 'sku', 'renderer' => 'FCM_Productreports_Block_Adminhtml_Report_Renderer_Configurable', 'sortable' => false));
$this->addColumn('sku', array('header' => Mage::helper('productreports')->__('Simple SKU'), 'width' => '250px', 'index' => 'sku', 'renderer' => 'FCM_Productreports_Block_Adminhtml_Report_Renderer_Simple', 'sortable' => false));
$this->addColumn('ean', array('header' => Mage::helper('productreports')->__('EAN'), 'index' => 'ean', 'sortable' => false));
$this->addColumn('color', array('header' => Mage::helper('productreports')->__('Color'), 'width' => '250px', 'index' => 'color', 'type' => 'options', 'options' => Mage::helper('productreports')->getAttributeOptions('color'), 'sortable' => false));
$this->addColumn('size', array('header' => Mage::helper('productreports')->__('Size'), 'width' => '250px', 'index' => 'size', 'sortable' => false));
$this->addColumn('gender', array('header' => Mage::helper('productreports')->__('Gender'), 'width' => '250px', 'index' => 'gender', 'type' => 'options', 'options' => array('319' => 'Women', '320' => 'Men'), 'sortable' => false));
$currencyCode = $this->getCurrentCurrencyCode();
$this->addColumn('price', array('header' => Mage::helper('productreports')->__('Price'), 'width' => '150px', 'align' => 'right', 'index' => 'price', 'currency_code' => $currencyCode, 'type' => 'currency', 'total' => 'sum', 'sortable' => false));
$this->addColumn('special_price', array('header' => Mage::helper('productreports')->__('Special Price'), 'width' => '150px', 'align' => 'right', 'index' => 'special_price', 'currency_code' => $currencyCode, 'type' => 'currency', 'total' => 'sum', 'sortable' => false));
$this->addColumn('qty', array('header' => Mage::helper('productreports')->__('Avaiable Stock'), 'index' => 'qty', 'width' => '150px', 'type' => 'number', 'sortable' => false));
$this->addExportType('*/*/exportStockCsv', Mage::helper('productreports')->__('CSV'));
$this->addExportType('*/*/exportStockXml', Mage::helper('productreports')->__('Excel XML'));
return parent::_prepareColumns();
}
protected function _prepareColumns()
{
$requestData = Mage::helper('adminhtml')->prepareFilterString($this->getRequest()->getParam('filter'));
$this->addColumn('category', array('header' => Mage::helper('productreports')->__('Category'), 'width' => '250px', 'index' => 'sku', 'renderer' => 'FCM_Productreports_Block_Adminhtml_Report_Renderer_Department', 'sortable' => false));
$this->addColumn('subcategory', array('header' => Mage::helper('productreports')->__('Sub Category'), 'width' => '250px', 'index' => 'sku', 'renderer' => 'FCM_Productreports_Block_Adminhtml_Report_Renderer_Category', 'sortable' => false));
//if($requestData['product_type'] == 'configurable' || $requestData['product_type'] == ''){
$this->addColumn('configsku', array('header' => Mage::helper('productreports')->__('Config SKU'), 'width' => '250px', 'index' => 'sku', 'renderer' => 'FCM_Productreports_Block_Adminhtml_Report_Renderer_Configurable', 'sortable' => false));
//}
//if($requestData['product_type'] == 'simple' || $requestData['product_type'] == ''){
$this->addColumn('sku', array('header' => Mage::helper('productreports')->__('Simple SKU'), 'width' => '250px', 'index' => 'sku', 'renderer' => 'FCM_Productreports_Block_Adminhtml_Report_Renderer_Simple', 'sortable' => false));
//}
$this->addColumn('ean', array('header' => Mage::helper('productreports')->__('EAN'), 'index' => 'ean', 'type' => 'text', 'sortable' => false));
$this->addColumn('color', array('header' => Mage::helper('productreports')->__('Color'), 'width' => '250px', 'index' => 'color', 'type' => 'options', 'options' => Mage::helper('productreports')->getAttributeOptions('color'), 'sortable' => false));
$this->addColumn('name', array('header' => Mage::helper('productreports')->__('Product Name'), 'index' => 'name', 'type' => 'text', 'sortable' => false));
$this->addColumn('prod_content', array('header' => Mage::helper('productreports')->__('Content'), 'index' => 'entity_id', 'type' => 'text', 'width' => '70px', 'renderer' => 'FCM_Productreports_Block_Adminhtml_Report_Workflow_Renderer_Content', 'sortable' => false));
$this->addColumn('prod_images', array('header' => Mage::helper('productreports')->__('Images'), 'index' => 'entity_id', 'type' => 'text', 'renderer' => 'FCM_Productreports_Block_Adminhtml_Report_Workflow_Renderer_Images', 'sortable' => false));
$this->addColumn('stockstatus', array('header' => Mage::helper('productreports')->__('Stock'), 'index' => 'stockstatus', 'sortable' => false));
$this->addColumn('frontendvisibitity', array('header' => Mage::helper('productreports')->__('Visible'), 'index' => 'frontendvisibitity', 'sortable' => false));
$this->addExportType('*/*/exportWorkflowCsv', Mage::helper('productreports')->__('CSV'));
$this->addExportType('*/*/exportWorkflowXml', Mage::helper('productreports')->__('Excel XML'));
return parent::_prepareColumns();
}
protected function _prepareColumns()
{
$this->addColumn('name', array('header' => Mage::helper('productreports')->__('Product Name'), 'width' => '250px', 'index' => 'name', 'sortable' => false));
$this->addColumn('category', array('header' => Mage::helper('productreports')->__('Category'), 'width' => '250px', 'index' => 'sku', 'renderer' => 'FCM_Productreports_Block_Adminhtml_Report_Renderer_Department', 'sortable' => false));
$this->addColumn('subcategory', array('header' => Mage::helper('productreports')->__('Sub Category'), 'width' => '250px', 'index' => 'sku', 'renderer' => 'FCM_Productreports_Block_Adminhtml_Report_Renderer_Category', 'sortable' => false));
$this->addColumn('configsku', array('header' => Mage::helper('productreports')->__('Config SKU'), 'width' => '250px', 'index' => 'sku', 'renderer' => 'FCM_Productreports_Block_Adminhtml_Report_Renderer_Configurable', 'sortable' => false));
$this->addColumn('sku', array('header' => Mage::helper('productreports')->__('Simple SKU'), 'width' => '250px', 'index' => 'sku', 'renderer' => 'FCM_Productreports_Block_Adminhtml_Report_Renderer_Simple', 'sortable' => false));
$this->addColumn('ean', array('header' => Mage::helper('productreports')->__('EAN'), 'index' => 'ean', 'sortable' => false));
$currencyCode = $this->getCurrentCurrencyCode();
$this->addColumn('price', array('header' => Mage::helper('productreports')->__('Price'), 'width' => '150px', 'align' => 'right', 'index' => 'price', 'currency_code' => $currencyCode, 'type' => 'currency', 'total' => 'sum', 'sortable' => false));
/* $this->addColumn('special_price', array(
'header' =>Mage::helper('productreports')->__('Special Price'),
'width' =>'150px',
'align' =>'right',
'index' =>'special_price',
'currency_code' => $currencyCode,
'type' => 'currency',
'total' => 'sum',
'sortable' => false,
));
*/
$this->addColumn('qty', array('header' => Mage::helper('productreports')->__('Qty'), 'index' => 'qty', 'width' => '150px', 'type' => 'number', 'sortable' => false));
$this->addColumn('discount', array('header' => Mage::helper('productreports')->__('Discount'), 'index' => 'discount', 'width' => '150px', 'sortable' => false, 'type' => 'options', 'options' => $this->getDiscountValue()));
/* $this->addColumn('special_from_date', array(
'header' => Mage::helper('productreports')->__('Special Price From Date'),
'index' => 'special_from_date',
'width' => 150,
'sortable' => false,
'type' => 'date',
));
$this->addColumn('special_to_date', array(
'header' => Mage::helper('productreports')->__('Special Price To Date'),
'index' => 'special_to_date',
'width' => 150,
'sortable' => false,
'type' => 'date',
));
*/
$this->addExportType('*/*/exportStockpriceCsv', Mage::helper('productreports')->__('CSV'));
$this->addExportType('*/*/exportStockpriceXml', Mage::helper('productreports')->__('Excel XML'));
return parent::_prepareColumns();
}
protected function _prepareColumns()
{
//$currencyCode = $this->getCurrentCurrencyCode();
$this->addColumn('created_at', array('header' => Mage::helper('productreports')->__('Order Date'), 'index' => 'created_at', 'sortable' => false, 'renderer' => 'FCM_Productreports_Block_Adminhtml_Report_Renderer_Date', 'type' => 'text'));
$this->addColumn('order_time', array('header' => Mage::helper('productreports')->__('Order Time'), 'index' => 'created_at', 'sortable' => false, 'renderer' => 'FCM_Productreports_Block_Adminhtml_Report_Renderer_Time', 'type' => 'text'));
$this->addColumn('order_increment_id', array('header' => Mage::helper('productreports')->__('Order Number'), 'index' => 'order_increment_id', 'sortable' => false, 'type' => 'text'));
$this->addColumn('customer_id', array('header' => Mage::helper('productreports')->__('Customer ID'), 'index' => 'customer_id', 'sortable' => false));
$this->addColumn('source', array('header' => Mage::helper('productreports')->__('Source'), 'index' => 'source', 'sortable' => false));
$this->addColumn('campaign', array('header' => Mage::helper('productreports')->__('Campaign'), 'index' => 'campaign', 'sortable' => false));
$this->addColumn('customer_email', array('header' => Mage::helper('productreports')->__('Customer Email'), 'index' => 'customer_email', 'sortable' => false));
$this->addColumn('payment_method', array('header' => Mage::helper('productreports')->__('Payment Method'), 'index' => 'payment_gateway', 'sortable' => false, 'renderer' => 'FCM_Productreports_Block_Adminhtml_Report_Renderer_Pmethod'));
$this->addColumn('payment_gateway', array('header' => Mage::helper('productreports')->__('Payment Gateway'), 'index' => 'payment_gateway', 'sortable' => false));
$this->addColumn('dc_status', array('header' => Mage::helper('productreports')->__('DC Status'), 'index' => 'dc_status', 'sortable' => false, 'renderer' => 'FCM_Productreports_Block_Adminhtml_Report_Renderer_Dcstatus'));
$this->addColumn('latest_status', array('header' => Mage::helper('productreports')->__('Latest Status'), 'index' => 'latest_status', 'sortable' => false, 'renderer' => 'FCM_Productreports_Block_Adminhtml_Report_Renderer_Lstatus'));
$this->addColumn('sku', array('header' => Mage::helper('productreports')->__('Item No'), 'index' => 'sku', 'sortable' => false));
$this->addColumn('ean', array('header' => Mage::helper('productreports')->__('EAN'), 'index' => 'sku', 'sortable' => false, 'renderer' => 'FCM_Productreports_Block_Adminhtml_Report_Renderer_Ean'));
$this->addColumn('qty', array('header' => Mage::helper('productreports')->__('Qty'), 'index' => 'qty', 'sortable' => false, 'type' => 'number'));
$this->addColumn('product_mrp', array('header' => Mage::helper('productreports')->__('Item MRP'), 'index' => 'item_id', 'sortable' => false, 'renderer' => 'FCM_Productreports_Block_Adminhtml_Report_Renderer_Mrp'));
$this->addColumn('original_price', array('header' => Mage::helper('productreports')->__('Special Price'), 'index' => 'item_id', 'sortable' => false, 'renderer' => 'FCM_Productreports_Block_Adminhtml_Report_Renderer_Price'));
$this->addColumn('discount_percent', array('header' => Mage::helper('productreports')->__('Discount %'), 'index' => 'item_id', 'sortable' => false, 'renderer' => 'FCM_Productreports_Block_Adminhtml_Report_Renderer_Dpercent'));
$this->addColumn('discount_amount', array('header' => Mage::helper('productreports')->__('Discount Value'), 'index' => 'item_id', 'sortable' => false, 'renderer' => 'FCM_Productreports_Block_Adminhtml_Report_Renderer_Damount'));
$this->addColumn('tax_percent', array('header' => Mage::helper('productreports')->__('Tax %'), 'index' => 'item_id', 'sortable' => false, 'renderer' => 'FCM_Productreports_Block_Adminhtml_Report_Renderer_Tpercent'));
$this->addColumn('tax_amount', array('header' => Mage::helper('productreports')->__('Tax Value'), 'index' => 'item_id', 'sortable' => false, 'renderer' => 'FCM_Productreports_Block_Adminhtml_Report_Renderer_Tamount'));
$this->addColumn('coupon_code', array('header' => Mage::helper('productreports')->__('Coupon Code'), 'index' => 'coupon_code', 'sortable' => false));
$this->addColumn('coupon_rule_name', array('header' => Mage::helper('productreports')->__('Shopping Cart Price Rule'), 'sortable' => false, 'index' => 'coupon_rule_name'));
$this->addColumn('coupon_percent', array('header' => Mage::helper('productreports')->__('Coupon %'), 'index' => 'item_id', 'sortable' => false, 'renderer' => 'FCM_Productreports_Block_Adminhtml_Report_Renderer_Cpercent'));
$this->addColumn('customer_balance_amount', array('header' => Mage::helper('productreports')->__('Store Credit'), 'index' => 'customer_balance_amount', 'sortable' => false, 'type' => 'currency'));
$this->addColumn('coupon_amount', array('header' => Mage::helper('productreports')->__('Coupon Money'), 'index' => 'item_id', 'sortable' => false, 'renderer' => 'FCM_Productreports_Block_Adminhtml_Report_Renderer_Camount'));
$this->addColumn('row_total', array('header' => Mage::helper('productreports')->__('Amount to Customer'), 'index' => 'item_id', 'sortable' => false, 'renderer' => 'FCM_Productreports_Block_Adminhtml_Report_Renderer_Rtotal'));
$this->addColumn('grand_total', array('header' => Mage::helper('productreports')->__('Order Value'), 'index' => 'grand_total', 'sortable' => false, 'type' => 'currency'));
$this->addColumn('shipment_date', array('header' => Mage::helper('productreports')->__('Shipment Date'), 'index' => 'shipment_date', 'sortable' => false));
$this->addColumn('courier', array('header' => Mage::helper('productreports')->__('Courier'), 'index' => 'courier', 'sortable' => false));
$this->addColumn('awb_no', array('header' => Mage::helper('productreports')->__('AWB No.'), 'index' => 'awb_no', 'sortable' => false));
$this->addColumn('gvcode', array('header' => Mage::helper('productreports')->__('GV Code'), 'index' => 'order_increment_id', 'sortable' => false, 'renderer' => 'FCM_Productreports_Block_Adminhtml_Report_Renderer_Giftcard'));
$this->addColumn('gv_value', array('header' => Mage::helper('productreports')->__('GV Value.'), 'index' => 'order_increment_id', 'sortable' => false, 'renderer' => 'FCM_Productreports_Block_Adminhtml_Report_Renderer_Giftcardvalue'));
$this->addExportType('*/*/exportWorkflowCsv', Mage::helper('productreports')->__('CSV'));
$this->addExportType('*/*/exportWorkflowXml', Mage::helper('productreports')->__('Excel XML'));
return parent::_prepareColumns();
}
