protected function _prepareCollection()
{
$requestData = $this->getRequestData();
$collection = Mage::helper('inventoryreports/purchaseorder')->getCollection($requestData);
$this->setCollection($collection);
return parent::_prepareCollection();
}
protected function _prepareCollection()
{
$collection = Mage::helper('inventoryreports/customer')->getCustomerReportCollection($this->_requestData);
$this->setCollection($collection);
$this->_setDefaultSort('sum_base_grand_total', 'DESC');
$this->_sortCollection($collection);
return parent::_prepareCollection();
}
/**
* Prepare data collection
*
*/
protected function _prepareCollection()
{
$requestData = $this->getRequestData();
$collection = Mage::helper('inventoryreports/stockonhand')->getStockRemainingCollection($requestData);
$collection->setIsGroupCountSql(true);
$this->setCollection($collection);
return parent::_prepareCollection();
}
protected function _prepareCollection()
{
$filter = Mage::helper('adminhtml')->prepareFilterString($this->getRequest()->getParam('top_filter'));
$transactionIdsArray = explode(',', $filter['movementids']);
$collection = Mage::getResourceModel('inventorywarehouse/transaction_product_collection');
$collection->addFieldToFilter('main_table.warehouse_transaction_id', array('in' => $transactionIdsArray));
$collection->getSelect()->columns(array('transactionproductqty' => 'IFNULL(SUM(main_table.qty),0)'))->group('main_table.product_id');
$this->setCollection($collection);
return parent::_prepareCollection();
}
/**
*
* @return collection
*/
protected function _prepareCollection()
{
$data = Mage::helper('inventoryreports/order')->getOrderReportCollection($this->getRequestData());
if (is_array($data)) {
$collection = $data['collection'];
$this->_filter = $data['filter'];
} else {
$collection = $data;
}
// Sort grid data
$this->_sortCollection($collection);
$this->setCollection($collection);
return parent::_prepareCollection();
}
protected function _prepareCollection()
{
$collection = Mage::helper('inventoryreports/stockmovement')->getMovementReportCollection($this->getRequestData());
$this->setCollection($collection);
return parent::_prepareCollection();
}
