/app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price/Configurable.php

<?php


/**


 * Magento


 *


 * NOTICE OF LICENSE


 *


 * This source file is subject to the Open Software License (OSL 3.0)


 * that is bundled with this package in the file LICENSE.txt.


 * It is also available through the world-wide-web at this URL:


 * http://opensource.org/licenses/osl-3.0.php


 * If you did not receive a copy of the license and are unable to


 * obtain it through the world-wide-web, please send an email


 * to license@magentocommerce.com so we can send you a copy immediately.


 *


 * DISCLAIMER


 *


 * Do not edit or add to this file if you wish to upgrade Magento to newer


 * versions in the future. If you wish to customize Magento for your


 * needs please refer to http://www.magentocommerce.com for more information.


 *


 * @category    Mage


 * @package     Mage_Catalog


 * @copyright   Copyright (c) 2011 Magento Inc. (http://www.magentocommerce.com)


 * @license     http://opensource.org/licenses/osl-3.0.php  Open Software License (OSL 3.0)


 */








/**


 * Configurable Products Price Indexer Resource model


 *


 * @category    Mage


 * @package     Mage_Catalog


 * @author      Magento Core Team <core@magentocommerce.com>


 */


class Mage_Catalog_Model_Resource_Product_Indexer_Price_Configurable


    extends Mage_Catalog_Model_Resource_Product_Indexer_Price_Default


{


    /**


     * Reindex temporary (price result data) for all products


     *


     * @return Mage_Catalog_Model_Resource_Product_Indexer_Price_Configurable


     */


    public function reindexAll()


    {


        $this->useIdxTable(true);


        $this->beginTransaction();


        try {


            $this->_prepareFinalPriceData();


            $this->_applyCustomOption();


            $this->_applyConfigurableOption();


            $this->_movePriceDataToIndexTable();


            $this->commit();


        } catch (Exception $e) {


            $this->rollBack();


            throw $e;


        }


        return $this;


    }





    /**


     * Reindex temporary (price result data) for defined product(s)


     *


     * @param int|array $entityIds


     * @return Mage_Catalog_Model_Resource_Product_Indexer_Price_Configurable


     */


    public function reindexEntity($entityIds)


    {


        $this->_prepareFinalPriceData($entityIds);


        $this->_applyCustomOption();


        $this->_applyConfigurableOption();


        $this->_movePriceDataToIndexTable();





        return $this;


    }





    /**


     * Retrieve table name for custom option temporary aggregation data


     *


     * @return string


     */


    protected function _getConfigurableOptionAggregateTable()


    {


        if ($this->useIdxTable()) {


            return $this->getTable('catalog/product_price_indexer_cfg_option_aggregate_idx');


        }


        return $this->getTable('catalog/product_price_indexer_cfg_option_aggregate_tmp');


    }





    /**


     * Retrieve table name for custom option prices data


     *


     * @return string


     */


    protected function _getConfigurableOptionPriceTable()


    {


        if ($this->useIdxTable()) {


            return $this->getTable('catalog/product_price_indexer_cfg_option_idx');


        }


        return $this->getTable('catalog/product_price_indexer_cfg_option_tmp');


    }





    /**


     * Prepare table structure for custom option temporary aggregation data


     *


     * @return Mage_Catalog_Model_Resource_Product_Indexer_Price_Configurable


     */


    protected function _prepareConfigurableOptionAggregateTable()


    {


        $this->_getWriteAdapter()->delete($this->_getConfigurableOptionAggregateTable());


        return $this;


    }





    /**


     * Prepare table structure for custom option prices data


     *


     * @return Mage_Catalog_Model_Resource_Product_Indexer_Price_Configurable


     */


    protected function _prepareConfigurableOptionPriceTable()


    {


        $this->_getWriteAdapter()->delete($this->_getConfigurableOptionPriceTable());


        return $this;


    }





    /**


     * Calculate minimal and maximal prices for configurable product options


     * and apply it to final price


     *


     * @return Mage_Catalog_Model_Resource_Product_Indexer_Price_Configurable


     */


    protected function _applyConfigurableOption()


    {


        $write      = $this->_getWriteAdapter();


        $coaTable   = $this->_getConfigurableOptionAggregateTable();


        $copTable   = $this->_getConfigurableOptionPriceTable();





        $this->_prepareConfigurableOptionAggregateTable();


        $this->_prepareConfigurableOptionPriceTable();





        $select = $write->select()


            ->from(array('i' => $this->_getDefaultFinalPriceTable()), array())


            ->join(


                array('l' => $this->getTable('catalog/product_super_link')),


                'l.parent_id = i.entity_id',


                array('parent_id', 'product_id'))


            ->columns(array('customer_group_id', 'website_id'), 'i')


            ->join(


                array('a' => $this->getTable('catalog/product_super_attribute')),


                'l.parent_id = a.product_id',


                array())


            ->join(


                array('cp' => $this->getValueTable('catalog/product', 'int')),


                'l.product_id = cp.entity_id AND cp.attribute_id = a.attribute_id AND cp.store_id = 0',


                array())


            ->joinLeft(


                array('apd' => $this->getTable('catalog/product_super_attribute_pricing')),


                'a.product_super_attribute_id = apd.product_super_attribute_id'


                    . ' AND apd.website_id = 0 AND cp.value = apd.value_index',


                array())


            ->joinLeft(


                array('apw' => $this->getTable('catalog/product_super_attribute_pricing')),


                'a.product_super_attribute_id = apw.product_super_attribute_id'


                    . ' AND apw.website_id = i.website_id AND cp.value = apw.value_index',


                array())


            ->join(


                array('le' => $this->getTable('catalog/product')),


                'le.entity_id = l.product_id',


                array())





            ->where('le.required_options=0')


            ->group(array('l.parent_id', 'i.customer_group_id', 'i.website_id', 'l.product_id'));





        $priceExpression = $write->getCheckSql('apw.value_id IS NOT NULL', 'apw.pricing_value', 'apd.pricing_value');


        $percenExpr = $write->getCheckSql('apw.value_id IS NOT NULL', 'apw.is_percent', 'apd.is_percent');


        $roundExpr = "ROUND(i.price * ({$priceExpression} / 100), 4)";


        $roundPriceExpr = $write->getCheckSql("{$percenExpr} = 1", $roundExpr, $priceExpression);


        $priceColumn = $write->getCheckSql("{$priceExpression} IS NULL", '0', $roundPriceExpr);


        $priceColumn = new Zend_Db_Expr("SUM({$priceColumn})");





        $tierPrice = $priceExpression;


        $tierRoundPriceExp = $write->getCheckSql("{$percenExpr} = 1", $roundExpr, $tierPrice);


        $tierPriceExp = $write->getCheckSql("{$tierPrice} IS NULL", '0', $tierRoundPriceExp);


        $tierPriceColumn = $write->getCheckSql("MIN(i.tier_price) IS NOT NULL", "SUM({$tierPriceExp})", 'NULL');





        $select->columns(array(


            'price'      => $priceColumn,


            'tier_price' => $tierPriceColumn


        ));





        $query = $select->insertFromSelect($coaTable);


        $write->query($query);





        $select = $write->select()


            ->from(


                array($coaTable),


                array('parent_id', 'customer_group_id', 'website_id', 'MIN(price)', 'MAX(price)', 'MIN(tier_price)'))


            ->group(array('parent_id', 'customer_group_id', 'website_id'));





        $query = $select->insertFromSelect($copTable);


        $write->query($query);





        $table  = array('i' => $this->_getDefaultFinalPriceTable());


        $select = $write->select()


            ->join(


                array('io' => $copTable),


                'i.entity_id = io.entity_id AND i.customer_group_id = io.customer_group_id'


                    .' AND i.website_id = io.website_id',


                array());


        $select->columns(array(


            'min_price'  => new Zend_Db_Expr('i.min_price + io.min_price'),


            'max_price'  => new Zend_Db_Expr('i.max_price + io.max_price'),


            'tier_price' => $write->getCheckSql('i.tier_price IS NOT NULL', 'i.tier_price + io.tier_price', 'NULL'),


        ));





        $query = $select->crossUpdateFromSelect($table);


        $write->query($query);





        $write->delete($coaTable);


        $write->delete($copTable);





        return $this;


    }


}