00001 <?php 00002 /** 00003 * Magento 00004 * 00005 * NOTICE OF LICENSE 00006 * 00007 * This source file is subject to the Open Software License (OSL 3.0) 00008 * that is bundled with this package in the file LICENSE.txt. 00009 * It is also available through the world-wide-web at this URL: 00010 * http://opensource.org/licenses/osl-3.0.php 00011 * If you did not receive a copy of the license and are unable to 00012 * obtain it through the world-wide-web, please send an email 00013 * to license@magentocommerce.com so we can send you a copy immediately. 00014 * 00015 * DISCLAIMER 00016 * 00017 * Do not edit or add to this file if you wish to upgrade Magento to newer 00018 * versions in the future. If you wish to customize Magento for your 00019 * needs please refer to http://www.magentocommerce.com for more information. 00020 * 00021 * @category Mage 00022 * @package Mage_Reports 00023 * @copyright Copyright (c) 2008 Irubin Consulting Inc. DBA Varien (http://www.varien.com) 00024 * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) 00025 */ 00026 00027 /** 00028 * Customers by totals Report collection 00029 * 00030 * @category Mage 00031 * @package Mage_Reports 00032 * @author Magento Core Team <core@magentocommerce.com> 00033 */ 00034 00035 class Mage_Reports_Model_Mysql4_Customer_Totals_Collection extends Mage_Reports_Model_Mysql4_Order_Collection 00036 { 00037 protected function _joinFields($from = '', $to = '') 00038 { 00039 $this->joinCustomerName() 00040 ->groupByCustomer() 00041 ->addOrdersCount() 00042 ->addAttributeToFilter('created_at', array('from' => $from, 'to' => $to, 'datetime' => true)); 00043 return $this; 00044 } 00045 00046 public function setDateRange($from, $to) 00047 { 00048 $this->_reset() 00049 ->_joinFields($from, $to); 00050 return $this; 00051 } 00052 00053 public function setStoreIds($storeIds) 00054 { 00055 $vals = array_values($storeIds); 00056 if (count($storeIds) >= 1 && $vals[0] != '') { 00057 $this->addAttributeToFilter('store_id', array('in' => (array)$storeIds)); 00058 $this->addSumAvgTotals(1) 00059 ->orderByTotalAmount(); 00060 } else { 00061 $this->addSumAvgTotals() 00062 ->orderByTotalAmount(); 00063 } 00064 00065 return $this; 00066 } 00067 }