00001 <?php 00002 /** 00003 * Magento 00004 * 00005 * NOTICE OF LICENSE 00006 * 00007 * This source file is subject to the Open Software License (OSL 3.0) 00008 * that is bundled with this package in the file LICENSE.txt. 00009 * It is also available through the world-wide-web at this URL: 00010 * http://opensource.org/licenses/osl-3.0.php 00011 * If you did not receive a copy of the license and are unable to 00012 * obtain it through the world-wide-web, please send an email 00013 * to license@magentocommerce.com so we can send you a copy immediately. 00014 * 00015 * DISCLAIMER 00016 * 00017 * Do not edit or add to this file if you wish to upgrade Magento to newer 00018 * versions in the future. If you wish to customize Magento for your 00019 * needs please refer to http://www.magentocommerce.com for more information. 00020 * 00021 * @category Mage 00022 * @package Mage_Rating 00023 * @copyright Copyright (c) 2008 Irubin Consulting Inc. DBA Varien (http://www.varien.com) 00024 * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) 00025 */ 00026 00027 /** 00028 * Rating option collection 00029 * 00030 * @category Mage 00031 * @package Mage_Rating 00032 * @author Magento Core Team <core@magentocommerce.com> 00033 */ 00034 class Mage_Rating_Model_Mysql4_Rating_Option_Collection extends Varien_Data_Collection_Db 00035 { 00036 protected $_ratingOptionTable; 00037 protected $_ratingVoteTable; 00038 00039 public function __construct() 00040 { 00041 parent::__construct(Mage::getSingleton('core/resource')->getConnection('rating_read')); 00042 $this->_ratingOptionTable = Mage::getSingleton('core/resource')->getTableName('rating/rating_option'); 00043 $this->_ratingVoteTable = Mage::getSingleton('core/resource')->getTableName('rating/rating_vote'); 00044 00045 $this->_select->from($this->_ratingOptionTable); 00046 00047 $this->setItemObjectClass(Mage::getConfig()->getModelClassName('rating/rating_option')); 00048 } 00049 00050 /** 00051 * add rating filter 00052 * 00053 * @param int|array $rating 00054 * @return Varien_Data_Collection_Db 00055 */ 00056 public function addRatingFilter($rating) 00057 { 00058 if (is_numeric($rating)) { 00059 $this->addFilter('rating_id', $rating); 00060 } 00061 elseif (is_array($rating)) { 00062 $this->addFilter('rating_id', $this->_getConditionSql('rating_id', array('in'=>$rating)), 'string'); 00063 } 00064 return $this; 00065 } 00066 00067 /** 00068 * set order by position field 00069 * 00070 * @param string $dir 00071 * @return Varien_Data_Collection_Db 00072 */ 00073 public function setPositionOrder($dir='ASC') 00074 { 00075 $this->setOrder($this->_ratingOptionTable.'.position', $dir); 00076 return $this; 00077 } 00078 }