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:  * Report Customers Review collection
 30:  *
 31:  * @category    Mage
 32:  * @package     Mage_Reports
 33:  * @author      Magento Core Team <core@magentocommerce.com>
 34:  */
 35: class Mage_Reports_Model_Resource_Review_Customer_Collection extends Mage_Review_Model_Resource_Review_Collection
 36: {
 37:     /**
 38:      * Join customers
 39:      *
 40:      * @return Mage_Reports_Model_Resource_Review_Customer_Collection
 41:      */
 42:     public function joinCustomers()
 43:     {
 44:         /**
 45:          * Allow to use analytic function to result select
 46:          */
 47:         $this->_useAnalyticFunction = true;
 48: 
 49:         /** @var $adapter Varien_Db_Adapter_Interface */
 50:         $adapter            = $this->getConnection();
 51:         /** @var $customer Mage_Customer_Model_Resource_Customer */
 52:         $customer           = Mage::getResourceSingleton('customer/customer');
 53:         /** @var $firstnameAttr Mage_Eav_Model_Entity_Attribute */
 54:         $firstnameAttr      = $customer->getAttribute('firstname');
 55:         /** @var $lastnameAttr Mage_Eav_Model_Entity_Attribute */
 56:         $lastnameAttr       = $customer->getAttribute('lastname');
 57: 
 58:         $firstnameCondition = array('table_customer_firstname.entity_id = detail.customer_id');
 59: 
 60:         if ($firstnameAttr->getBackend()->isStatic()) {
 61:             $firstnameField = 'firstname';
 62:         } else {
 63:             $firstnameField = 'value';
 64:             $firstnameCondition[] = $adapter->quoteInto('table_customer_firstname.attribute_id = ?',
 65:                 (int)$firstnameAttr->getAttributeId());
 66:         }
 67: 
 68:         $this->getSelect()->joinInner(
 69:             array('table_customer_firstname' => $firstnameAttr->getBackend()->getTable()),
 70:             implode(' AND ', $firstnameCondition),
 71:             array());
 72: 
 73: 
 74:         $lastnameCondition  = array('table_customer_lastname.entity_id = detail.customer_id');
 75:         if ($lastnameAttr->getBackend()->isStatic()) {
 76:             $lastnameField = 'lastname';
 77:         } else {
 78:             $lastnameField = 'value';
 79:             $lastnameCondition[] = $adapter->quoteInto('table_customer_lastname.attribute_id = ?',
 80:                 (int)$lastnameAttr->getAttributeId());
 81:         }
 82: 
 83:         //Prepare fullname field result
 84:         $customerFullname = $adapter->getConcatSql(array(
 85:             "table_customer_firstname.{$firstnameField}",
 86:             "table_customer_lastname.{$lastnameField}"
 87:         ), ' ');
 88:         $this->getSelect()->reset(Zend_Db_Select::COLUMNS)
 89:             ->joinInner(
 90:                 array('table_customer_lastname' => $lastnameAttr->getBackend()->getTable()),
 91:                 implode(' AND ', $lastnameCondition),
 92:                 array())
 93:             ->columns(array(
 94:                 'customer_id' => 'detail.customer_id',
 95:                 'customer_name' => $customerFullname,
 96:                 'review_cnt'    => 'COUNT(main_table.review_id)'))
 97:             ->group('detail.customer_id');
 98: 
 99:         return $this;
100:     }
101: 
102:     /**
103:      * Get select count sql
104:      *
105:      * @return string
106:      */
107:     public function getSelectCountSql()
108:     {
109:         $countSelect = clone $this->_select;
110:         $countSelect->reset(Zend_Db_Select::ORDER);
111:         $countSelect->reset(Zend_Db_Select::GROUP);
112:         $countSelect->reset(Zend_Db_Select::HAVING);
113:         $countSelect->reset(Zend_Db_Select::LIMIT_COUNT);
114:         $countSelect->reset(Zend_Db_Select::LIMIT_OFFSET);
115:         $countSelect->reset(Zend_Db_Select::COLUMNS);
116: 
117:         $countSelect->columns(new Zend_Db_Expr('COUNT(DISTINCT detail.customer_id)'));
118: 
119:         return  $countSelect;
120:     }
121: }
122: