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:  * New Accounts Report collection
30:  *
31:  * @category    Mage
32:  * @package     Mage_Reports
33:  * @author      Magento Core Team <core@magentocommerce.com>
34:  */
35: class Mage_Reports_Model_Resource_Accounts_Collection extends Mage_Reports_Model_Resource_Customer_Collection
36: {
37: 
38:     /**
39:      * Join created_at and accounts fields
40:      *
41:      * @param string $from
42:      * @param string $to
43:      * @return Mage_Reports_Model_Resource_Accounts_Collection
44:      */
45:     protected function _joinFields($from = '', $to = '')
46:     {
47: 
48:         $this->getSelect()->reset(Zend_Db_Select::COLUMNS);
49:         $this->addAttributeToFilter('created_at', array('from' => $from, 'to' => $to, 'datetime' => true))
50:              ->addExpressionAttributeToSelect('accounts', 'COUNT({{entity_id}})', array('entity_id'));
51: 
52:         $this->getSelect()->having("{$this->_joinFields['accounts']['field']} > ?", 0);
53: 
54:         return $this;
55:     }
56: 
57:     /**
58:      * Set date range
59:      *
60:      * @param string $from
61:      * @param string $to
62:      * @return Mage_Reports_Model_Resource_Accounts_Collection
63:      */
64:     public function setDateRange($from, $to)
65:     {
66:         $this->_reset()
67:              ->_joinFields($from, $to);
68:         return $this;
69:     }
70: 
71:     /**
72:      * Set store ids to final result
73:      *
74:      * @param array $storeIds
75:      * @return Mage_Reports_Model_Resource_Accounts_Collection
76:      */
77:     public function setStoreIds($storeIds)
78:     {
79:         if ($storeIds) {
80:             $this->addAttributeToFilter('store_id', array('in' => (array)$storeIds));
81:         }
82:         return $this;
83:     }
84: }
85: