1: <?php
  2: /**
  3:  * Magento
  4:  *
  5:  * NOTICE OF LICENSE
  6:  *
  7:  * This source file is subject to the Open Software License (OSL 3.0)
  8:  * that is bundled with this package in the file LICENSE.txt.
  9:  * It is also available through the world-wide-web at this URL:
 10:  * http://opensource.org/licenses/osl-3.0.php
 11:  * If you did not receive a copy of the license and are unable to
 12:  * obtain it through the world-wide-web, please send an email
 13:  * to license@magentocommerce.com so we can send you a copy immediately.
 14:  *
 15:  * DISCLAIMER
 16:  *
 17:  * Do not edit or add to this file if you wish to upgrade Magento to newer
 18:  * versions in the future. If you wish to customize Magento for your
 19:  * needs please refer to http://www.magentocommerce.com for more information.
 20:  *
 21:  * @category    Mage
 22:  * @package     Mage_Catalog
 23:  * @copyright   Copyright (c) 2012 Magento Inc. (http://www.magentocommerce.com)
 24:  * @license     http://opensource.org/licenses/osl-3.0.php  Open Software License (OSL 3.0)
 25:  */
 26: 
 27: 
 28: /**
 29:  * Catalog Config Resource Model
 30:  *
 31:  * @category    Mage
 32:  * @package     Mage_Catalog
 33:  * @author      Magento Core Team <core@magentocommerce.com>
 34:  */
 35: class Mage_Catalog_Model_Resource_Config extends Mage_Core_Model_Resource_Db_Abstract
 36: {
 37:     /**
 38:      * catalog_product entity type id
 39:      *
 40:      * @var int
 41:      */
 42:     protected $_entityTypeId;
 43: 
 44:     /**
 45:      * Store id
 46:      *
 47:      * @var int
 48:      */
 49:     protected $_storeId          = null;
 50: 
 51:     /**
 52:      * Initialize connection
 53:      *
 54:      */
 55:     protected function _construct()
 56:     {
 57:         $this->_init('eav/attribute', 'attribute_id');
 58:     }
 59: 
 60:     /**
 61:      * Set store id
 62:      *
 63:      * @param integer $storeId
 64:      * @return Mage_Catalog_Model_Resource_Config
 65:      */
 66:     public function setStoreId($storeId)
 67:     {
 68:         $this->_storeId = (int)$storeId;
 69:         return $this;
 70:     }
 71: 
 72:     /**
 73:      * Return store id.
 74:      * If is not set return current app store
 75:      *
 76:      * @return integer
 77:      */
 78:     public function getStoreId()
 79:     {
 80:         if ($this->_storeId === null) {
 81:             return Mage::app()->getStore()->getId();
 82:         }
 83:         return $this->_storeId;
 84:     }
 85: 
 86:     /**
 87:      * Retrieve catalog_product entity type id
 88:      *
 89:      * @return int
 90:      */
 91:     public function getEntityTypeId()
 92:     {
 93:         if ($this->_entityTypeId === null) {
 94:             $this->_entityTypeId = Mage::getSingleton('eav/config')->getEntityType(Mage_Catalog_Model_Product::ENTITY)->getId();
 95:         }
 96:         return $this->_entityTypeId;
 97:     }
 98: 
 99:     /**
100:      * Retrieve Product Attributes Used in Catalog Product listing
101:      *
102:      * @return array
103:      */
104:     public function getAttributesUsedInListing()
105:     {
106:         $adapter = $this->_getReadAdapter();
107:         $storeLabelExpr = $adapter->getCheckSql('al.value IS NOT NULL', 'al.value', 'main_table.frontend_label');
108: 
109:         $select  = $adapter->select()
110:             ->from(array('main_table' => $this->getTable('eav/attribute')))
111:             ->join(
112:                 array('additional_table' => $this->getTable('catalog/eav_attribute')),
113:                 'main_table.attribute_id = additional_table.attribute_id'
114:             )
115:             ->joinLeft(
116:                 array('al' => $this->getTable('eav/attribute_label')),
117:                 'al.attribute_id = main_table.attribute_id AND al.store_id = ' . (int)$this->getStoreId(),
118:                 array('store_label' => $storeLabelExpr)
119:             )
120:             ->where('main_table.entity_type_id = ?', (int)$this->getEntityTypeId())
121:             ->where('additional_table.used_in_product_listing = ?', 1);
122: 
123:         return $adapter->fetchAll($select);
124:     }
125: 
126:     /**
127:      * Retrieve Used Product Attributes for Catalog Product Listing Sort By
128:      *
129:      * @return array
130:      */
131:     public function getAttributesUsedForSortBy()
132:     {
133:         $adapter = $this->_getReadAdapter();
134:         $storeLabelExpr = $adapter->getCheckSql('al.value IS NULL', 'main_table.frontend_label','al.value');
135:         $select = $adapter->select()
136:             ->from(array('main_table' => $this->getTable('eav/attribute')))
137:             ->join(
138:                 array('additional_table' => $this->getTable('catalog/eav_attribute')),
139:                 'main_table.attribute_id = additional_table.attribute_id',
140:                 array()
141:             )
142:             ->joinLeft(
143:                 array('al' => $this->getTable('eav/attribute_label')),
144:                 'al.attribute_id = main_table.attribute_id AND al.store_id = ' . (int)$this->getStoreId(),
145:                 array('store_label' => $storeLabelExpr)
146:             )
147:             ->where('main_table.entity_type_id = ?', (int)$this->getEntityTypeId())
148:             ->where('additional_table.used_for_sort_by = ?', 1);
149: 
150:         return $adapter->fetchAll($select);
151:     }
152: }
153: