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 Reviews 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_Collection extends Mage_Review_Model_Resource_Review_Collection
36: {
37: /**
38: * Resource initialization
39: *
40: */
41: protected function _construct()
42: {
43: $this->_init('review/review');
44: }
45:
46: /**
47: * add product filter
48: *
49: * @param unknown_type $productId
50: * @return Mage_Reports_Model_Resource_Review_Collection
51: */
52: public function addProductFilter($productId)
53: {
54: $this->addFieldToFilter('entity_pk_value', array('eq' => (int)$productId));
55:
56: return $this;
57: }
58:
59: /**
60: * Reset select
61: *
62: * @return Mage_Reports_Model_Resource_Review_Collection
63: */
64: public function resetSelect()
65: {
66: parent::resetSelect();
67: $this->_joinFields();
68: return $this;
69: }
70:
71: /**
72: * Get select count sql
73: *
74: * @return string
75: */
76: public function getSelectCountSql()
77: {
78: $countSelect = clone $this->_select;
79: $countSelect->reset(Zend_Db_Select::ORDER);
80: $countSelect->reset(Zend_Db_Select::LIMIT_COUNT);
81: $countSelect->reset(Zend_Db_Select::LIMIT_OFFSET);
82: $countSelect->reset(Zend_Db_Select::COLUMNS);
83: $countSelect->columns("COUNT(main_table.review_id)");
84:
85: return $countSelect;
86: }
87:
88: /**
89: * Set order
90: *
91: * @param string $attribute
92: * @param string $dir
93: * @return Mage_Reports_Model_Resource_Review_Collection
94: */
95: public function setOrder($attribute, $dir = self::SORT_ORDER_DESC)
96: {
97: if (in_array($attribute, array('nickname', 'title', 'detail', 'created_at'))) {
98: $this->_select->order($attribute . ' ' . $dir);
99: } else {
100: parent::setOrder($attribute, $dir);
101: }
102:
103: return $this;
104: }
105: }
106: