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_Catalog 00023 * @copyright Copyright (c) 2009 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 /** 00029 * Catalog Config Resource Model 00030 * 00031 * @category Mage 00032 * @package Mage_Catalog 00033 * @author Magento Core Team <core@magentocommerce.com> 00034 */ 00035 class Mage_Catalog_Model_Resource_Eav_Mysql4_Config extends Mage_Core_Model_Mysql4_Abstract 00036 { 00037 /** 00038 * catalog_product entity type id 00039 * 00040 * @var int 00041 */ 00042 protected $_entityTypeId; 00043 00044 /** 00045 * Initialize connection 00046 * 00047 */ 00048 protected function _construct() { 00049 $this->_init('eav/attribute', 'attribute_id'); 00050 } 00051 00052 /** 00053 * Retrieve catalog_product entity type id 00054 * 00055 * @return int 00056 */ 00057 public function getEntityTypeId() 00058 { 00059 if (is_null($this->_entityTypeId)) { 00060 $select = $this->_getReadAdapter()->select() 00061 ->from($this->getTable('eav/entity_type'), 'entity_type_id') 00062 ->where('entity_type_code=?', 'catalog_product'); 00063 $this->_entityTypeId = $this->_getReadAdapter()->fetchOne($select); 00064 } 00065 return $this->_entityTypeId; 00066 } 00067 00068 /** 00069 * Retrieve Product Attributes Used in Catalog Product listing 00070 * 00071 * @return array 00072 */ 00073 public function getAttributesUsedInListing() { 00074 $select = $this->_getReadAdapter()->select() 00075 ->from($this->getTable('eav/attribute')) 00076 ->where('entity_type_id=?', $this->getEntityTypeId()) 00077 ->where('used_in_product_listing=?', 1); 00078 return $this->_getReadAdapter()->fetchAll($select); 00079 } 00080 00081 /** 00082 * Retrieve Used Product Attributes for Catalog Product Listing Sort By 00083 * 00084 * @return array 00085 */ 00086 public function getAttributesUsedForSortBy() { 00087 $select = $this->_getReadAdapter()->select() 00088 ->from($this->getTable('eav/attribute')) 00089 ->where('entity_type_id=?', $this->getEntityTypeId()) 00090 ->where('used_for_sort_by=?', 1); 00091 return $this->_getReadAdapter()->fetchAll($select); 00092 } 00093 }