/**
* prepare columns for this grid
*
* @return Magestore_Inventory_Block_Adminhtml_Inventory_Grid
*/
protected function _prepareColumns()
{
$requestData = $this->getRequestData();
$this->_addFirstColumn();
$this->addColumn('total_qty', array('header' => Mage::helper('inventoryreports')->__('Purchased Qty'), 'align' => 'right', 'index' => 'total_qty', 'type' => 'number', 'width' => '100px', 'filter_condition_callback' => array($this, '_filterNumberCallback')));
/*
if($this->isPOSKUReport()) {
$this->addColumn('child_product_qty', array(
'header' => Mage::helper('inventoryreports')->__('Purchased Qty<br/>per child products'),
'align' => 'right',
'index' => 'child_product_qty',
'width' => '120px',
'sortable' => false,
'filter' => false,
'renderer' => 'inventoryreports/adminhtml_reportcontent_purchaseorder_renderer_childproductqty'
));
}
*/
$this->addColumn('total_order', array('header' => Mage::helper('inventoryreports')->__('Total Order'), 'align' => 'right', 'index' => 'total_order', 'type' => 'number', 'width' => '100px', 'filter_condition_callback' => array($this, '_filterNumberCallback')));
$this->addColumn('total_value', array('header' => Mage::helper('inventoryreports')->__('Total Value'), 'align' => 'right', 'index' => 'total_value', 'type' => 'currency', 'currency_code' => Mage::app()->getStore()->getBaseCurrency()->getCode(), 'width' => '100px', 'filter_condition_callback' => array($this, '_filterNumberCallback')));
$this->addColumn('sales_ratio', array('header' => Mage::helper('inventoryreports')->__('#Ratio'), 'align' => 'right', 'index' => 'sales_ratio', 'filter' => false, 'sortable' => false, 'width' => '50px', 'renderer' => 'inventoryreports/adminhtml_reportcontent_purchaseorder_renderer_salesratio'));
$this->_addWarehouseCoulmn('inventoryreports/adminhtml_reportcontent_purchaseorder_renderer_warehouse');
$this->addColumn('action', array('header' => Mage::helper('inventoryreports')->__('Action'), 'width' => '120px', 'align' => 'center', 'type' => 'action', 'filter' => false, 'sortable' => false, 'index' => 'stores', 'is_system' => true, 'renderer' => 'inventoryreports/adminhtml_reportcontent_purchaseorder_renderer_action'));
$this->addCSVExport();
return parent::_prepareColumns();
}
protected function _prepareColumns()
{
$this->addColumn('product_id', array('header' => Mage::helper('inventoryreports')->__('Product ID'), 'sortable' => true, 'index' => 'product_id', 'type' => 'number'));
$this->addColumn('product_name', array('header' => Mage::helper('inventoryreports')->__('Name'), 'sortable' => true, 'index' => 'product_name'));
$this->addColumn('product_sku', array('header' => Mage::helper('inventoryreports')->__('SKU'), 'sortable' => true, 'index' => 'product_sku'));
$this->addColumn('transactionproductqty', array('header' => Mage::helper('inventoryreports')->__('Total Qty'), 'sortable' => true, 'index' => 'transactionproductqty', 'type' => 'number', 'filter_condition_callback' => array($this, '_filterNumberCallback')));
return parent::_prepareColumns();
}
protected function _prepareColumns()
{
$this->addColumn('type', array('header' => Mage::helper('inventoryreports')->__('Type'), 'sortable' => true, 'index' => 'type', 'type' => 'options', 'options' => Mage::helper('inventoryreports')->getMovementType()));
$this->addColumn('numberoftransaction', array('header' => Mage::helper('inventoryreports')->__('Total Transaction'), 'align' => 'right', 'index' => 'numberoftransaction', 'type' => 'number', 'width' => '50px', 'filter_condition_callback' => array($this, '_filterNumberCallback')));
$this->addColumn('numbertransactionproduct', array('header' => Mage::helper('inventoryreports')->__('Total SKU'), 'align' => 'right', 'index' => 'numbertransactionproduct', 'type' => 'number', 'width' => '50px', 'filter_condition_callback' => array($this, '_filterNumberCallback')));
$this->addColumn('transactionproductqty', array('header' => Mage::helper('inventoryreports')->__('Total Qty'), 'align' => 'right', 'index' => 'transactionproductqty', 'type' => 'number', 'width' => '50px', 'filter_condition_callback' => array($this, '_filterNumberCallback')));
$this->addColumn('action', array('header' => Mage::helper('inventoryreports')->__('Action'), 'width' => '120px', 'align' => 'center', 'type' => 'action', 'filter' => false, 'sortable' => false, 'index' => 'stores', 'is_system' => true, 'renderer' => 'inventoryreports/adminhtml_reportcontent_reportbymovement_renderer_action'));
return parent::_prepareColumns();
}
protected function _prepareColumns()
{
$this->addColumn('telephone', array('header' => Mage::helper('inventoryreports')->__('Telephone'), 'sortable' => true, 'index' => 'telephone', 'filter_condition_callback' => array($this, '_filterTelephoneCallback')));
$this->addColumn('customer_email', array('header' => Mage::helper('inventoryreports')->__('Email'), 'sortable' => true, 'index' => 'customer_email'));
$this->addColumn('customer_firstname', array('header' => Mage::helper('inventoryreports')->__('First Name'), 'sortable' => true, 'index' => 'customer_firstname'));
$this->addColumn('customer_lastname', array('header' => Mage::helper('inventoryreports')->__('Last Name'), 'sortable' => true, 'index' => 'customer_lastname'));
$this->addColumn('numberoforder', array('header' => Mage::helper('inventoryreports')->__('Total Orders'), 'sortable' => true, 'align' => 'right', 'index' => 'numberoforder', 'type' => 'number', 'filter_condition_callback' => array($this, '_filterCallback')));
$this->addColumn('sum_base_grand_total', array('header' => Mage::helper('inventoryreports')->__('Grand Total'), 'align' => 'right', 'index' => 'sum_base_grand_total', 'type' => 'currency', 'currency' => 'base_currency_code', 'filter_condition_callback' => array($this, '_filterCallback')));
$this->addColumn('action', array('header' => Mage::helper('inventoryreports')->__('Action'), 'width' => '120px', 'align' => 'center', 'type' => 'action', 'filter' => false, 'sortable' => false, 'index' => 'stores', 'is_system' => true, 'renderer' => 'inventoryreports/adminhtml_reportcontent_reportbycustomer_renderer_action'));
$this->addCSVExport();
return parent::_prepareColumns();
}
/**
* prepare columns for this grid
*
* @return Magestore_Inventory_Block_Adminhtml_Inventory_Grid
*/
protected function _prepareColumns()
{
$this->addColumn('sku', array('header' => Mage::helper('inventoryreports')->__('SKU'), 'align' => 'left', 'index' => 'sku', 'width' => '100px', 'renderer' => 'inventoryreports/adminhtml_reportcontent_reportbystockonhand_renderer_supersku'));
$this->addColumn('total_remain', array('header' => Mage::helper('inventoryreports')->__('On-hand Qty'), 'align' => 'right', 'index' => 'total_remain', 'type' => 'number', 'width' => '50px', 'filter_condition_callback' => array($this, '_filterNumberCallback')));
/*
$this->addColumn('child_product_qty', array(
'header' => Mage::helper('inventoryreports')->__('On-hand Qty<br/>per child products'),
'align' => 'right',
'index' => 'child_product_qty',
'width' => '150px',
'sortable' => false,
'filter' => false,
'renderer' => 'inventoryreports/adminhtml_reportcontent_reportbystockonhand_renderer_childproductqty'
));
*/
$this->addColumn('sales_ratio', array('header' => Mage::helper('inventoryreports')->__('#Ratio'), 'align' => 'right', 'index' => 'sales_ratio', 'filter' => false, 'sortable' => false, 'width' => '100px', 'renderer' => 'inventoryreports/adminhtml_reportcontent_reportbystockonhand_renderer_qtyremainingratio'));
$this->_addWarehouseCoulmn('inventoryreports/adminhtml_reportcontent_reportbystockonhand_renderer_warehouse');
$this->addColumn('action', array('header' => Mage::helper('inventoryreports')->__('Action'), 'width' => '50px', 'align' => 'center', 'type' => 'action', 'filter' => false, 'sortable' => false, 'index' => 'stores', 'is_system' => true, 'renderer' => 'inventoryreports/adminhtml_reportcontent_reportbystockonhand_renderer_action'));
$this->addCSVExport();
return parent::_prepareColumns();
}
/**
* Add columns to grid
*
*/
protected function _prepareColumns()
{
$this->_addFirstColumn();
$this->addColumn('sum_qty_ordered', array('header' => Mage::helper('inventoryreports')->__('Ordered Qty'), 'align' => 'right', 'index' => 'sum_qty_ordered', 'type' => 'number', 'width' => '50px', 'filter_condition_callback' => array($this, '_filterNumberCallback')));
/*
if($this->isSalesSKUReport()){
$this->addColumn('child_product_qty', array(
'header' => Mage::helper('inventoryreports')->__('Sold Qty<br/>per child products'),
'align' => 'right',
'index' => 'child_product_qty',
'width' => '50px',
'sortable' => false,
'filter' => false,
'renderer' => 'inventoryreports/adminhtml_reportcontent_reportbyorder_renderer_childproductqty'
));
}
*/
$this->addColumn('count_entity_id', array('header' => Mage::helper('inventoryreports')->__('Total Order'), 'align' => 'right', 'index' => 'count_entity_id', 'type' => 'number', 'width' => '50px', 'filter_condition_callback' => array($this, '_filterNumberCallback')));
$this->addColumn('sum_base_grand_total', array('header' => Mage::helper('inventoryreports')->__('Grand Total'), 'align' => 'right', 'index' => 'sum_base_grand_total', 'type' => 'currency', 'currency' => 'base_currency_code', 'filter_condition_callback' => array($this, '_filterNumberCallback')));
if ($this->isSalesbyHourReport()) {
$this->_addColumnsPerHour();
}
if ($this->isSalesbyDayReport()) {
$this->_addColumnsPerDay();
}
$this->addColumn('sales_ratio', array('header' => Mage::helper('inventoryreports')->__('#Ratio'), 'align' => 'right', 'index' => 'sales_ratio', 'filter' => false, 'sortable' => false, 'width' => '50px', 'renderer' => 'inventoryreports/adminhtml_reportcontent_reportbyorder_renderer_salesratio'));
$this->addColumn('action', array('header' => Mage::helper('sales')->__('Action'), 'width' => '50px', 'align' => 'center', 'type' => 'action', 'filter' => false, 'sortable' => false, 'index' => 'stores', 'is_system' => true, 'renderer' => 'inventoryreports/adminhtml_reportcontent_reportbyorder_renderer_action'));
$this->addCSVExport();
return parent::_prepareColumns();
}
