1: <?php
  2: /**
  3:  * Magento
  4:  *
  5:  * NOTICE OF LICENSE
  6:  *
  7:  * This source file is subject to the Open Software License (OSL 3.0)
  8:  * that is bundled with this package in the file LICENSE.txt.
  9:  * It is also available through the world-wide-web at this URL:
 10:  * http://opensource.org/licenses/osl-3.0.php
 11:  * If you did not receive a copy of the license and are unable to
 12:  * obtain it through the world-wide-web, please send an email
 13:  * to license@magentocommerce.com so we can send you a copy immediately.
 14:  *
 15:  * DISCLAIMER
 16:  *
 17:  * Do not edit or add to this file if you wish to upgrade Magento to newer
 18:  * versions in the future. If you wish to customize Magento for your
 19:  * needs please refer to http://www.magentocommerce.com for more information.
 20:  *
 21:  * @category    Mage
 22:  * @package     Mage_Sales
 23:  * @copyright   Copyright (c) 2012 Magento Inc. (http://www.magentocommerce.com)
 24:  * @license     http://opensource.org/licenses/osl-3.0.php  Open Software License (OSL 3.0)
 25:  */
 26: 
 27: 
 28: class Mage_Sales_Model_Entity_Sale_Collection extends Varien_Object implements IteratorAggregate
 29: {
 30: 
 31:     /**
 32:      * Read connection
 33:      *
 34:      * @var Zend_Db_Adapter_Abstract
 35:      */
 36:     protected $_read;
 37: 
 38:     protected $_items = array();
 39: 
 40:     protected $_totals = array('lifetime' => 0, 'num_orders' => 0);
 41: 
 42:     /**
 43:      * Entity attribute
 44:      *
 45:      * @var Mage_Eav_Model_Entity_Abstract
 46:      */
 47:     protected $_entity;
 48: 
 49:     /**
 50:      * Collection's Zend_Db_Select object
 51:      *
 52:      * @var Zend_Db_Select
 53:      */
 54:     protected $_select;
 55: 
 56:     /**
 57:      * Enter description here...
 58:      *
 59:      * @var Mage_Customer_Model_Customer
 60:      */
 61:     protected $_customer;
 62: 
 63:     public function __construct()
 64:     {
 65:         $this->_entity = Mage::getModel('sales_entity/order');
 66:         $this->_read = $this->_entity->getReadConnection();
 67:     }
 68: 
 69:     public function setCustomerFilter(Mage_Customer_Model_Customer $customer)
 70:     {
 71:         $this->_customer = $customer;
 72:         return $this;
 73:     }
 74: 
 75:     public function load($printQuery = false, $logQuery = false)
 76:     {
 77:         $this->_select = $this->_read->select();
 78:         $entityTable= $this->getEntity()->getEntityTable();
 79:         $paidTable  = $this->getAttribute('grand_total')->getBackend()->getTable();
 80:         $idField    = $this->getEntity()->getIdFieldName();
 81:         $this->getSelect()
 82:             ->from(array('sales' => $entityTable),
 83:                 array(
 84:                     'store_id',
 85:                     'lifetime'  => 'sum(sales.base_grand_total)',
 86:                     'avgsale'   => 'avg(sales.base_grand_total)',
 87:                     'num_orders'=> 'count(sales.base_grand_total)'
 88:                 )
 89:             )
 90:             ->where('sales.entity_type_id=?', $this->getEntity()->getTypeId())
 91:             ->group('sales.store_id')
 92:         ;
 93:         if ($this->_customer instanceof Mage_Customer_Model_Customer) {
 94:             $this->getSelect()
 95:                 ->where('sales.customer_id=?', $this->_customer->getId());
 96:         }
 97: 
 98:         $this->printLogQuery($printQuery, $logQuery);
 99:         try {
100:             $values = $this->_read->fetchAll($this->getSelect()->__toString());
101:         } catch (Exception $e) {
102:             $this->printLogQuery(true, true, $this->getSelect()->__toString());
103:             throw $e;
104:         }
105:         $stores = Mage::getResourceModel('core/store_collection')->setWithoutDefaultFilter()->load()->toOptionHash();
106:         if (! empty($values)) {
107:             foreach ($values as $v) {
108:                 $obj = new Varien_Object($v);
109:                 $storeName = isset($stores[$obj->getStoreId()]) ? $stores[$obj->getStoreId()] : null;
110: 
111:                 $this->_items[ $v['store_id'] ] = $obj;
112:                 $this->_items[ $v['store_id'] ]->setStoreName($storeName);
113:                 $this->_items[ $v['store_id'] ]->setAvgNormalized($obj->getAvgsale() * $obj->getNumOrders());
114:                 foreach ($this->_totals as $key => $value) {
115:                     $this->_totals[$key] += $obj->getData($key);
116:                 }
117:             }
118:             if ($this->_totals['num_orders']) {
119:                 $this->_totals['avgsale'] = $this->_totals['lifetime'] / $this->_totals['num_orders'];
120:             }
121:         }
122: 
123:         return $this;
124:     }
125: 
126:     /**
127:      * Print and/or log query
128:      *
129:      * @param boolean $printQuery
130:      * @param boolean $logQuery
131:      * @return  Mage_Sales_Model_Entity_Order_Attribute_Collection_Paid
132:      */
133:     public function printLogQuery($printQuery = false, $logQuery = false, $sql = null) {
134:         if ($printQuery) {
135:             echo is_null($sql) ? $this->getSelect()->__toString() : $sql;
136:         }
137: 
138:         if ($logQuery){
139:             Mage::log(is_null($sql) ? $this->getSelect()->__toString() : $sql);
140:         }
141:         return $this;
142:     }
143: 
144:     /**
145:      * Get zend db select instance
146:      *
147:      * @return Zend_Db_Select
148:      */
149:     public function getSelect()
150:     {
151:         return $this->_select;
152:     }
153: 
154:     /**
155:      * Enter description here...
156:      *
157:      * @return Mage_Eav_Model_Entity_Attribute_Abstract
158:      */
159:     public function getAttribute($attr)
160:     {
161:         return $this->_entity->getAttribute($attr);
162:     }
163: 
164:     /**
165:      * Enter description here...
166:      *
167:      * @return Mage_Eav_Model_Entity_Abstract
168:      */
169:     public function getEntity()
170:     {
171:         return $this->_entity;
172:     }
173: 
174:     /**
175:      * Enter description here...
176:      *
177:      * @return ArrayIterator
178:      */
179:     public function getIterator()
180:     {
181:         return new ArrayIterator($this->_items);
182:     }
183: 
184:     /**
185:      * Enter description here...
186:      *
187:      * @return array
188:      */
189:     public function getItems()
190:     {
191:         return $this->_items;
192:     }
193: 
194:     /**
195:      * Enter description here...
196:      *
197:      * @return Varien_Object
198:      */
199:     public function getTotals()
200:     {
201:         return new Varien_Object($this->_totals);
202:     }
203: 
204: }
205: