protected function _getItemStatistics($from, $to) { $collection = Mage::getModel('sales/order')->getCollection(); if (Mage::helper('advancedreports')->checkVersion('1.4.1.0')) { $orderTable = $this->getTable('sales_flat_order'); } else { $orderTable = $this->getTable('sales_order'); } $collection->getSelect()->reset(); $collection->getSelect()->from(array('e' => $orderTable), array()); # set State filter $this->_setOrderStateFilter($collection); $this->_addItems($collection); $collection->getSelect()->group('e.entity_id'); #set data filter $collection->getSelect()->where("e.created_at >= ?", $from)->where("e.created_at <= ?", $to); # check Store Filter if ($this->getRequest()->getParam('store')) { $storeIds = array($this->getParam('store')); } else { if ($this->getRequest()->getParam('website')) { $storeIds = Mage::app()->getWebsite($this->getRequest()->getParam('website'))->getStoreIds(); } else { if ($this->getRequest()->getParam('group')) { $storeIds = Mage::app()->getGroup($this->getRequest()->getParam('group'))->getStoreIds(); } } } if (isset($storeIds)) { $this->_setStoreFilter($collection, $storeIds); } // echo $collection->getSelect()->__toString()."<hr />"; $items = new Varien_Object(array('items_count' => 0)); if (count($collection)) { foreach ($collection as $item) { $items->setItemsCount($items->getItemsCount() + $item->getItemsCount()); } } return $items; }
protected function _getItemStatistics($from, $to) { $filterField = $this->_helper()->confOrderDateFilter(); /** @var AW_Advancedreports_Model_Mysql4_Collection_Standard_Sales $collection */ $collection = Mage::getResourceModel('advancedreports/collection_standard_sales'); $collection->reInitSelect()->addItems()->setState()->setDateFilter($from, $to); $storeIds = $this->getStoreIds(); if (count($storeIds)) { $collection->setStoreFilter($storeIds); } $items = new Varien_Object(array('items_count' => 0)); if (count($collection)) { foreach ($collection as $item) { $items->setItemsCount($items->getItemsCount() + $item->getItemsCount()); } } return $items; }