Mage_Tax_Model_Mysql4_Setup Class Reference

Inheritance diagram for Mage_Tax_Model_Mysql4_Setup:

List of all members.

Public Member Functions
	convertOldTaxData ()
Protected Member Functions
	_loadTableData ($table)
	_loadOldRates ($oldRateTypes)

---

Detailed Description

Tax Setup Model

Author:

Magento Core Team <core@magentocommerce.com>

Definition at line 32 of file Setup.php.

---

Member Function Documentation

_loadOldRates

(

$

oldRateTypes

)

[protected]

Definition at line 114 of file Setup.php.

    {

        $table = $this->getTable('tax_rate');
        $select = $this->_conn->select();
        $select->from(array('main_table'=>$table));
        foreach ($oldRateTypes as $type){
            $id = $type['type_id'];
            $select->joinLeft(
                        array("data_{$id}"=>$this->getTable('tax_rate_data')),
                        "data_{$id}.rate_type_id = {$id} AND data_{$id}.tax_rate_id = main_table.tax_rate_id",
                        array("data_{$id}"=>'rate_value')
                        );
        }
        return $this->_conn->fetchAll($select);
    }

_loadTableData

(

$

table

)

[protected]

Definition at line 106 of file Setup.php.

    {
        $table = $this->getTable($table);
        $select = $this->_conn->select();
        $select->from($table);
        return $this->_conn->fetchAll($select);
    }

convertOldTaxData

(

)

Definition at line 34 of file Setup.php.

    {
        $oldRules = $this->_loadTableData('tax_rule');

        $oldRateTypes = $this->_loadTableData('tax_rate_type');

        $rateById = array();
        foreach ($oldRateTypes as $type) {
            $rateById[$type['type_id']] = $type['type_name'];
        }

        $oldRates = $this->_loadOldRates($oldRateTypes);

        $oldToNewRateIds = array();

        foreach ($oldRates as $rate) {
            foreach ($oldRateTypes as $type) {
                if (isset($rate["data_{$type['type_id']}"])) {
                    $rateValue = $rate["data_{$type['type_id']}"];
                } else {
                    continue;
                }

                $region = Mage::getModel('directory/region')->load($rate['tax_region_id']);
                $regionName = $region->getCode() ? $region->getCode() : '*';
                $code = "{$rate['tax_country_id']}-{$regionName}-{$rate['tax_postcode']}-{$type['type_name']}";

                if ($rateValue > 0) {
                    $insertData = array(
                                        'tax_country_id'=>$rate['tax_country_id'],
                                        'tax_region_id'=>$rate['tax_region_id'],
                                        'tax_postcode'=>$rate['tax_postcode'],
                                        'code'=>$code,
                                        'rate'=>$rateValue,
                                        );

                    $newRateModel = Mage::getModel('tax/calculation_rate');

                    $newRateModel->setData($insertData)->save();
                    $oldToNewRateIds[$rate['tax_rate_id']] = $newRateModel->getId();
                    $ratesByType[$type['type_id']][] = $newRateModel->getId();
                }
            }
        }

        foreach ($oldRules as $rule) {
            if (!isset($ratesByType[$rule['tax_rate_type_id']]) || !count($ratesByType[$rule['tax_rate_type_id']])){
                continue;
            }

            $customerTaxClasses = array($rule['tax_customer_class_id']);
            $productTaxClasses = array($rule['tax_product_class_id']);

            $ctc = Mage::getModel('tax/class')->load($rule['tax_customer_class_id']);
            $ptc = Mage::getModel('tax/class')->load($rule['tax_product_class_id']);
            $type = $rateById[$rule['tax_rate_type_id']];

            $rates = $ratesByType[$rule['tax_rate_type_id']];
            $code = "{$ctc->getClassName()}-{$ptc->getClassName()}-{$type}";

            $ruleData = array(
                            'tax_rate'=>$rates,
                            'tax_product_class'=>$productTaxClasses,
                            'tax_customer_class'=>$customerTaxClasses,
                            'code'=>$code,
                            'priority'=>1,
                            'position'=>1
                            );
            Mage::getModel('tax/calculation_rule')->setData($ruleData)->save();
        }
    }

---

The documentation for this class was generated from the following file:

• app/code/core/Mage/Tax/Model/Mysql4/Setup.php