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: * Orders collection
29: *
30: * @category Mage
31: * @package Mage_Sales
32: * @author Magento Core Team <core@magentocommerce.com>
33: */
34:
35: class Mage_Sales_Model_Entity_Order_Collection extends Mage_Eav_Model_Entity_Collection_Abstract
36: {
37: protected function _construct()
38: {
39: $this->_init('sales/order');
40: }
41:
42: public function addItemCountExpr()
43: {
44: $orderTable = $this->getEntity()->getEntityTable();
45: $orderItemEntityTypeId = Mage::getResourceSingleton('sales/order_item')->getTypeId();
46: $this->getSelect()->join(
47: array('items'=>$orderTable),
48: 'items.parent_id=e.entity_id and items.entity_type_id='.$orderItemEntityTypeId,
49: array('items_count'=>new Zend_Db_Expr('COUNT(items.entity_id)'))
50: )
51: ->group('e.entity_id');
52: return $this;
53: }
54: }
55: