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_Reports
 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: /**
 29:  * Reports invoiced collection
 30:  *
 31:  * @category    Mage
 32:  * @package     Mage_Reports
 33:  * @author      Magento Core Team <core@magentocommerce.com>
 34:  */
 35: class Mage_Reports_Model_Resource_Invoiced_Collection extends Mage_Sales_Model_Entity_Order_Collection
 36: {
 37:     /**
 38:      * Set date range
 39:      *
 40:      * @param string $from
 41:      * @param string $to
 42:      * @return Mage_Reports_Model_Resource_Invoiced_Collection
 43:      */
 44:     public function setDateRange($from, $to)
 45:     {
 46:         $orderInvoicedExpr = $this->getConnection()->getCheckSql('{{base_total_invoiced}} > 0', 1, 0);
 47:         $this->_reset()
 48:             ->addAttributeToSelect('*')
 49:             ->addAttributeToFilter('created_at', array('from' => $from, 'to' => $to))
 50:             ->addExpressionAttributeToSelect('orders',
 51:                 'COUNT({{base_total_invoiced}})',
 52:                 array('base_total_invoiced'))
 53:             ->addExpressionAttributeToSelect('orders_invoiced',
 54:                 "SUM({$orderInvoicedExpr})",
 55:                 array('base_total_invoiced'))
 56:             ->addAttributeToFilter('state', array('neq' => Mage_Sales_Model_Order::STATE_CANCELED))
 57:             ->getSelect()
 58:                 ->group('entity_id')
 59:                 ->having('orders > ?', 0);
 60:         /*
 61:          * Allow Analytic Functions Usage
 62:          */
 63:         $this->_useAnalyticFunction = true;
 64: 
 65:         return $this;
 66:     }
 67: 
 68:     /**
 69:      * Set store filter collection
 70:      *
 71:      * @param array $storeIds
 72:      * @return Mage_Reports_Model_Resource_Invoiced_Collection
 73:      */
 74:     public function setStoreIds($storeIds)
 75:     {
 76:         if ($storeIds) {
 77:             $this->addAttributeToFilter('store_id', array('in' => (array)$storeIds))
 78:             ->addExpressionAttributeToSelect(
 79:                 'invoiced',
 80:                 'SUM({{base_total_invoiced}})',
 81:                 array('base_total_invoiced'))
 82:             ->addExpressionAttributeToSelect(
 83:                 'invoiced_captured',
 84:                 'SUM({{base_total_paid}})',
 85:                 array('base_total_paid'))
 86:             ->addExpressionAttributeToSelect(
 87:                 'invoiced_not_captured',
 88:                 'SUM({{base_total_invoiced}}-{{base_total_paid}})',
 89:                 array('base_total_invoiced', 'base_total_paid'));
 90:         } else {
 91:             $this->addExpressionAttributeToSelect(
 92:                 'invoiced',
 93:                 'SUM({{base_total_invoiced}}*{{base_to_global_rate}})',
 94:                 array('base_total_invoiced', 'base_to_global_rate'))
 95:             ->addExpressionAttributeToSelect(
 96:                 'invoiced_captured',
 97:                 'SUM({{base_total_paid}}*{{base_to_global_rate}})',
 98:                 array('base_total_paid', 'base_to_global_rate'))
 99:             ->addExpressionAttributeToSelect(
100:                 'invoiced_not_captured',
101:                 'SUM(({{base_total_invoiced}}-{{base_total_paid}})*{{base_to_global_rate}})',
102:                 array('base_total_invoiced', 'base_to_global_rate', 'base_total_paid'));
103:         }
104: 
105:         return $this;
106:     }
107: 
108:     /**
109:      * Get select count sql
110:      *
111:      * @return string
112:      */
113:     public function getSelectCountSql()
114:     {
115:         $countSelect = clone $this->getSelect();
116:         $countSelect->reset(Zend_Db_Select::ORDER);
117:         $countSelect->reset(Zend_Db_Select::LIMIT_COUNT);
118:         $countSelect->reset(Zend_Db_Select::LIMIT_OFFSET);
119:         $countSelect->reset(Zend_Db_Select::COLUMNS);
120:         $countSelect->reset(Zend_Db_Select::GROUP);
121:         $countSelect->reset(Zend_Db_Select::HAVING);
122:         $countSelect->columns("COUNT(*)");
123: 
124:         return $countSelect;
125:     }
126: }
127: