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_CatalogSearch
 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:  * Advanced Catalog Search resource model
 30:  *
 31:  * @category    Mage
 32:  * @package     Mage_CatalogSearch
 33:  * @author      Magento Core Team <core@magentocommerce.com>
 34:  */
 35: class Mage_CatalogSearch_Model_Resource_Advanced extends Mage_Core_Model_Resource_Db_Abstract
 36: {
 37:     /**
 38:      * Initialize connection and define catalog product table as main table
 39:      *
 40:      */
 41:     protected function _construct()
 42:     {
 43:         $this->_init('catalog/product', 'entity_id');
 44:     }
 45: 
 46:     /**
 47:      * Prepare response object and dispatch prepare price event
 48:      * Return response object
 49:      *
 50:      * @param Varien_Db_Select $select
 51:      * @return Varien_Object
 52:      */
 53:     protected function _dispatchPreparePriceEvent($select)
 54:     {
 55:         // prepare response object for event
 56:         $response = new Varien_Object();
 57:         $response->setAdditionalCalculations(array());
 58: 
 59:         // prepare event arguments
 60:         $eventArgs = array(
 61:             'select'          => $select,
 62:             'table'           => 'price_index',
 63:             'store_id'        => Mage::app()->getStore()->getId(),
 64:             'response_object' => $response
 65:         );
 66: 
 67:         Mage::dispatchEvent('catalog_prepare_price_select', $eventArgs);
 68: 
 69:         return $response;
 70:     }
 71: 
 72:     /**
 73:      * Prepare search condition for attribute
 74:      *
 75:      * @param Mage_Catalog_Model_Resource_Eav_Attribute $attribute
 76:      * @param string|array $value
 77:      * @param Mage_CatalogSearch_Model_Resource_Advanced_Collection $collection
 78:      * @return mixed
 79:      */
 80:     public function prepareCondition($attribute, $value, $collection)
 81:     {
 82:         $condition = false;
 83: 
 84:         if (is_array($value)) {
 85:             if (!empty($value['from']) || !empty($value['to'])) { // range
 86:                 $condition = $value;
 87:             } else if ($attribute->getBackendType() == 'varchar') { // multiselect
 88:                 $condition = array('in_set' => $value);
 89:             } else if (!isset($value['from']) && !isset($value['to'])) { // select
 90:                 $condition = array('in' => $value);
 91:             }
 92:         } else {
 93:             if (strlen($value) > 0) {
 94:                 if (in_array($attribute->getBackendType(), array('varchar', 'text', 'static'))) {
 95:                     $condition = array('like' => '%' . $value . '%'); // text search
 96:                 } else {
 97:                     $condition = $value;
 98:                 }
 99:             }
100:         }
101: 
102:         return $condition;
103:     }
104: 
105:     /**
106:      * Add filter by attribute rated price
107:      *
108:      * @param Mage_CatalogSearch_Model_Resource_Advanced_Collection $collection
109:      * @param Mage_Catalog_Model_Resource_Eav_Attribute $attribute
110:      * @param string|array $value
111:      * @param int $rate
112:      * @return bool
113:      */
114:     public function addRatedPriceFilter($collection, $attribute, $value, $rate = 1)
115:     {
116:         $adapter = $this->_getReadAdapter();
117: 
118:         $conditions = array();
119:         if (strlen($value['from']) > 0) {
120:             $conditions[] = $adapter->quoteInto(
121:                 'price_index.min_price %s * %s >= ?', $value['from'], Zend_Db::FLOAT_TYPE);
122:         }
123:         if (strlen($value['to']) > 0) {
124:             $conditions[] = $adapter->quoteInto(
125:                 'price_index.min_price %s * %s <= ?', $value['to'], Zend_Db::FLOAT_TYPE);
126:         }
127: 
128:         if (!$conditions) {
129:             return false;
130:         }
131: 
132:         $collection->addPriceData();
133:         $select     = $collection->getSelect();
134:         $response   = $this->_dispatchPreparePriceEvent($select);
135:         $additional = join('', $response->getAdditionalCalculations());
136: 
137:         foreach ($conditions as $condition) {
138:             $select->where(sprintf($condition, $additional, $rate));
139:         }
140: 
141:         return true;
142:     }
143: 
144:     /**
145:      * Add filter by indexable attribute
146:      *
147:      * @param Mage_CatalogSearch_Model_Resource_Advanced_Collection $collection
148:      * @param Mage_Catalog_Model_Resource_Eav_Attribute $attribute
149:      * @param string|array $value
150:      * @return bool
151:      */
152:     public function addIndexableAttributeModifiedFilter($collection, $attribute, $value)
153:     {
154:         if ($attribute->getIndexType() == 'decimal') {
155:             $table = $this->getTable('catalog/product_index_eav_decimal');
156:         } else {
157:             $table = $this->getTable('catalog/product_index_eav');
158:         }
159: 
160:         $tableAlias = 'a_' . $attribute->getAttributeId();
161:         $storeId    = Mage::app()->getStore()->getId();
162:         $select     = $collection->getSelect();
163: 
164:         if (is_array($value)) {
165:             if (isset($value['from']) && isset($value['to'])) {
166:                 if (empty($value['from']) && empty($value['to'])) {
167:                     return false;
168:                 }
169:             }
170:         }
171: 
172:         $select->distinct(true);
173:         $select->join(
174:             array($tableAlias => $table),
175:             "e.entity_id={$tableAlias}.entity_id "
176:                 . " AND {$tableAlias}.attribute_id={$attribute->getAttributeId()}"
177:                 . " AND {$tableAlias}.store_id={$storeId}",
178:             array()
179:         );
180: 
181:         if (is_array($value) && (isset($value['from']) || isset($value['to']))) {
182:             if (isset($value['from']) && !empty($value['from'])) {
183:                 $select->where("{$tableAlias}.value >= ?", $value['from']);
184:             }
185:             if (isset($value['to']) && !empty($value['to'])) {
186:                 $select->where("{$tableAlias}.value <= ?", $value['to']);
187:             }
188:             return true;
189:         }
190: 
191:         $select->where("{$tableAlias}.value IN(?)", $value);
192: 
193:         return true;
194:     }
195: }
196: