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