Example #1
0
 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;
 }
Example #2
0
 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;
 }