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:  * Products Most Viewed 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_Product_Viewed_Collection extends Mage_Reports_Model_Resource_Product_Collection
 36: {
 37:     /**
 38:      * List of store ids for the current collection will be filtered by
 39:      *
 40:      * @var array
 41:      */
 42:     protected $_storeIds = array();
 43: 
 44:     /**
 45:      * Join fields
 46:      *
 47:      * @param string $from
 48:      * @param string $to
 49:      * @return Mage_Reports_Model_Resource_Product_Viewed_Collection
 50:      */
 51:     protected function _joinFields($from = '', $to = '')
 52:     {
 53:         $this->addAttributeToSelect('*')
 54:             ->addViewsCount($from, $to);
 55:         return $this;
 56:     }
 57: 
 58:     /**
 59:      * Set date range
 60:      *
 61:      * @param string $from
 62:      * @param string $to
 63:      * @return Mage_Reports_Model_Resource_Product_Viewed_Collection
 64:      */
 65:     public function setDateRange($from, $to)
 66:     {
 67:         $this->_reset()
 68:             ->_joinFields($from, $to);
 69:         return $this;
 70:     }
 71: 
 72:     /**
 73:      * Set store ids
 74:      *
 75:      * @param array $storeIds
 76:      * @return Mage_Reports_Model_Resource_Product_Viewed_Collection
 77:      */
 78:     public function setStoreIds($storeIds)
 79:     {
 80:         $storeId = array_pop($storeIds);
 81:         $this->setStoreId($storeId);
 82:         $this->addStoreFilter($storeId);
 83:         $this->addStoreIds($storeId);
 84:         return $this;
 85:     }
 86: 
 87:     /**
 88:      * Add store ids to filter 'report_event' data by store
 89:      *
 90:      * @param array|int $storeIds
 91:      * @return Mage_Reports_Model_Resource_Product_Viewed_Collection
 92:      */
 93:     public function addStoreIds($storeIds)
 94:     {
 95:         if (is_array($storeIds)) {
 96:             $this->_storeIds = array_merge($this->_storeIds, $storeIds);
 97:         } else {
 98:             $this->_storeIds[] = $storeIds;
 99:         }
100:         return $this;
101:     }
102: 
103:     /**
104:      * Apply store filter
105:      *
106:      * @return Mage_Reports_Model_Resource_Product_Viewed_Collection
107:      */
108:     protected function _applyStoreIds()
109:     {
110:         $this->getSelect()->where('store_id IN(?)', $this->_storeIds);
111:         return $this;
112:     }
113: 
114:     /**
115:      * Apply filters
116:      *
117:      * @return Mage_Catalog_Model_Resource_Product_Collection
118:      */
119:     protected function _beforeLoad()
120:     {
121:         $this->_applyStoreIds();
122:         return parent::_beforeLoad();
123:     }
124: }
125: