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_CatalogIndex
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: * Price indexer resource model
30: *
31: * @category Mage
32: * @package Mage_CatalogIndex
33: * @author Magento Core Team <core@magentocommerce.com>
34: */
35: class Mage_CatalogIndex_Model_Resource_Indexer_Minimalprice extends Mage_CatalogIndex_Model_Resource_Indexer_Abstract
36: {
37: /**
38: * Enter description here ...
39: *
40: */
41: protected function _construct()
42: {
43: $this->_init('catalogindex/minimal_price', 'index_id');
44:
45: $this->_entityIdFieldName = 'entity_id';
46: $this->_storeIdFieldName = 'store_id';
47: }
48:
49: /**
50: * Enter description here ...
51: *
52: * @param unknown_type $conditions
53: * @return unknown
54: */
55: public function getMinimalValue($conditions)
56: {
57: $select = $this->_getReadAdapter()->select();
58: $select->from($this->getTable('catalogindex/price'), 'MIN(value)');
59: foreach ($conditions as $field=>$value) {
60: $condition = "{$field} = ?";
61: if (is_array($value))
62: $condition = "{$field} in (?)";
63:
64: $select->where($condition, $value);
65: }
66:
67: return $this->_getReadAdapter()->fetchOne($select);
68: }
69:
70: /**
71: * Enter description here ...
72: *
73: * @param unknown_type $productId
74: * @param unknown_type $storeId
75: * @param unknown_type $attributeId
76: */
77: public function cleanup($productId, $storeId = null, $attributeId = null)
78: {
79: $conditions[] = $this->_getWriteAdapter()->quoteInto("{$this->_entityIdFieldName} = ?", $productId);
80:
81: if (!is_null($storeId))
82: $conditions[] = $this->_getWriteAdapter()->quoteInto("{$this->_storeIdFieldName} = ?", $storeId);
83:
84: $conditions = implode (' AND ', $conditions);
85: $this->_getWriteAdapter()->delete($this->getMainTable(), $conditions);
86: }
87: }
88: