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_Customer
 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:  * Customers collection
 30:  *
 31:  * @category    Mage
 32:  * @package     Mage_Customer
 33:  * @author      Magento Core Team <core@magentocommerce.com>
 34:  */
 35: class Mage_Customer_Model_Resource_Customer_Collection extends Mage_Eav_Model_Entity_Collection_Abstract
 36: {
 37:     /**
 38:      * Resource initialization
 39:      */
 40:     protected function _construct()
 41:     {
 42:         $this->_init('customer/customer');
 43:     }
 44: 
 45:     /**
 46:      * Group result by customer email
 47:      *
 48:      * @return Mage_Customer_Model_Resource_Customer_Collection
 49:      */
 50:     public function groupByEmail()
 51:     {
 52:         $this->getSelect()
 53:             ->from(
 54:                 array('email' => $this->getEntity()->getEntityTable()),
 55:                 array('email_count' => new Zend_Db_Expr('COUNT(email.entity_id)'))
 56:             )
 57:             ->where('email.entity_id = e.entity_id')
 58:             ->group('email.email');
 59: 
 60:         return $this;
 61:     }
 62: 
 63:     /**
 64:      * Add Name to select
 65:      *
 66:      * @return Mage_Customer_Model_Resource_Customer_Collection
 67:      */
 68:     public function addNameToSelect()
 69:     {
 70:         $fields = array();
 71:         $customerAccount = Mage::getConfig()->getFieldset('customer_account');
 72:         foreach ($customerAccount as $code => $node) {
 73:             if ($node->is('name')) {
 74:                 $fields[$code] = $code;
 75:             }
 76:         }
 77: 
 78:         $adapter = $this->getConnection();
 79:         $concatenate = array();
 80:         if (isset($fields['prefix'])) {
 81:             $concatenate[] = $adapter->getCheckSql(
 82:                 '{{prefix}} IS NOT NULL AND {{prefix}} != \'\'',
 83:                 $adapter->getConcatSql(array('LTRIM(RTRIM({{prefix}}))', '\' \'')),
 84:                 '\'\'');
 85:         }
 86:         $concatenate[] = 'LTRIM(RTRIM({{firstname}}))';
 87:         $concatenate[] = '\' \'';
 88:         if (isset($fields['middlename'])) {
 89:             $concatenate[] = $adapter->getCheckSql(
 90:                 '{{middlename}} IS NOT NULL AND {{middlename}} != \'\'',
 91:                 $adapter->getConcatSql(array('LTRIM(RTRIM({{middlename}}))', '\' \'')),
 92:                 '\'\'');
 93:         }
 94:         $concatenate[] = 'LTRIM(RTRIM({{lastname}}))';
 95:         if (isset($fields['suffix'])) {
 96:             $concatenate[] = $adapter
 97:                     ->getCheckSql('{{suffix}} IS NOT NULL AND {{suffix}} != \'\'',
 98:                 $adapter->getConcatSql(array('\' \'', 'LTRIM(RTRIM({{suffix}}))')),
 99:                 '\'\'');
100:         }
101: 
102:         $nameExpr = $adapter->getConcatSql($concatenate);
103: 
104:         $this->addExpressionAttributeToSelect('name', $nameExpr, $fields);
105: 
106:         return $this;
107:     }
108: 
109:     /**
110:      * Get SQL for get record count
111:      *
112:      * @return Varien_Db_Select
113:      */
114:     public function getSelectCountSql()
115:     {
116:         $select = parent::getSelectCountSql();
117:         $select->resetJoinLeft();
118: 
119:         return $select;
120:     }
121: 
122:     /**
123:      * Reset left join
124:      *
125:      * @param int $limit
126:      * @param int $offset
127:      * @return Mage_Eav_Model_Entity_Collection_Abstract
128:      */
129:     protected function _getAllIdsSelect($limit = null, $offset = null)
130:     {
131:         $idsSelect = parent::_getAllIdsSelect($limit, $offset);
132:         $idsSelect->resetJoinLeft();
133:         return $idsSelect;
134:     }
135: }
136: