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