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_Tag 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 * Popular tags collection model 00029 * 00030 * @category Mage 00031 * @package Mage_Tag 00032 * @author Magento Core Team <core@magentocommerce.com> 00033 */ 00034 00035 class Mage_Tag_Model_Mysql4_Popular_Collection extends Mage_Core_Model_Mysql4_Collection_Abstract 00036 { 00037 00038 protected function _construct() 00039 { 00040 $this->_init('tag/tag'); 00041 } 00042 00043 public function joinFields($storeId = 0) 00044 { 00045 $this->getSelect() 00046 ->reset() 00047 ->from(array('main_table' => $this->getTable('tag/summary'))) 00048 ->join( 00049 array('tag' => $this->getTable('tag/tag')), 00050 'tag.tag_id = main_table.tag_id AND tag.status = '.Mage_Tag_Model_Tag::STATUS_APPROVED) 00051 ->where('main_table.store_id = ?', $storeId) 00052 ->order('popularity desc'); 00053 00054 return $this; 00055 } 00056 00057 public function load($printQuery = false, $logQuery = false) 00058 { 00059 if ($this->isLoaded()) { 00060 return $this; 00061 } 00062 parent::load($printQuery, $logQuery); 00063 return $this; 00064 } 00065 00066 public function limit($limit) 00067 { 00068 $this->getSelect()->limit($limit); 00069 return $this; 00070 } 00071 }