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_GoogleBase 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 * GoogleBase Item Types collection 00029 * 00030 * @category Mage 00031 * @package Mage_GoogleBase 00032 * @author Magento Core Team <core@magentocommerce.com> 00033 */ 00034 class Mage_GoogleBase_Model_Mysql4_Type_Collection extends Mage_Core_Model_Mysql4_Collection_Abstract 00035 { 00036 00037 protected function _construct() 00038 { 00039 $this->_init('googlebase/type'); 00040 } 00041 00042 protected function _initSelect() 00043 { 00044 parent::_initSelect(); 00045 $this->_joinAttributeSet(); 00046 return $this; 00047 } 00048 00049 /** 00050 * Add total count of Items for each type 00051 * 00052 * @return Mage_GoogleBase_Model_Mysql4_Type_Collection 00053 */ 00054 public function addItemsCount() 00055 { 00056 $this->getSelect() 00057 ->joinLeft( 00058 array('items'=>$this->getTable('googlebase/items')), 00059 'main_table.type_id=items.type_id', 00060 array('items_total' => 'COUNT(items.item_id)')) 00061 ->group('main_table.type_id'); 00062 return $this; 00063 } 00064 00065 /** 00066 * Add country ISO filter to collection 00067 * 00068 * @param string $iso Two-letter country ISO code 00069 * @return Mage_GoogleBase_Model_Mysql4_Type_Collection 00070 */ 00071 public function addCountryFilter($iso) 00072 { 00073 $this->getSelect()->where('target_country=?', $iso); 00074 return $this; 00075 } 00076 00077 /** 00078 * Join Attribute Set data 00079 * 00080 * @return Mage_GoogleBase_Model_Mysql4_Type_Collection 00081 */ 00082 protected function _joinAttributeSet() 00083 { 00084 $this->getSelect() 00085 ->join( 00086 array('set'=>$this->getTable('eav/attribute_set')), 00087 'main_table.attribute_set_id=set.attribute_set_id', 00088 array('attribute_set_name' => 'set.attribute_set_name')); 00089 return $this; 00090 } 00091 }