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_Shipping 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 * Shipping table rates collection 00029 * 00030 * @category Mage 00031 * @package Mage_Shipping 00032 * @author Magento Core Team <core@magentocommerce.com> 00033 */ 00034 class Mage_Shipping_Model_Mysql4_Carrier_Tablerate_Collection extends Varien_Data_Collection_Db 00035 { 00036 protected $_shipTable; 00037 protected $_countryTable; 00038 protected $_regionTable; 00039 00040 public function __construct() 00041 { 00042 parent::__construct(Mage::getSingleton('core/resource')->getConnection('shipping_read')); 00043 $this->_shipTable = Mage::getSingleton('core/resource')->getTableName('shipping/tablerate'); 00044 $this->_countryTable = Mage::getSingleton('core/resource')->getTableName('directory/country'); 00045 $this->_regionTable = Mage::getSingleton('core/resource')->getTableName('directory/country_region'); 00046 $this->_select->from(array("s" => $this->_shipTable)) 00047 ->joinLeft(array("c" => $this->_countryTable), 'c.country_id = s.dest_country_id', 'iso3_code AS dest_country') 00048 ->joinLeft(array("r" => $this->_regionTable), 'r.region_id = s.dest_region_id', 'code AS dest_region') 00049 ->order(array("dest_country", "dest_region", "dest_zip")); 00050 $this->_setIdFieldName('pk'); 00051 return $this; 00052 } 00053 00054 public function setWebsiteFilter($websiteId) 00055 { 00056 $this->_select->where("website_id = ?", $websiteId); 00057 00058 return $this; 00059 } 00060 00061 public function setConditionFilter($conditionName) 00062 { 00063 $this->_select->where("condition_name = ?", $conditionName); 00064 00065 return $this; 00066 } 00067 00068 public function setCountryFilter($countryId) 00069 { 00070 $this->_select->where("dest_country_id = ?", $countryId); 00071 00072 return $this; 00073 } 00074 }