public function tax_calculation()
{
$items = Mage::getModel('tax/calculation')->getCollection()->getItems();
foreach ($items as $item) {
$item->delete();
}
$this->conn->query('ALTER TABLE `tax_calculation` AUTO_INCREMENT=1');
//mage::D($this->objects['tax_calculation']); die;
foreach ($this->objects['tax_calculation'] as $item) {
$item['tax_calculation_rule_id'] = Mage::getModel('tax/calculation_rule')->getCollection()->addFieldToFilter('code', $item['tax_calculation_rule_id'])->getFirstItem()->getTaxCalculationRuleId();
$item['tax_calculation_rate_id'] = Mage::getModel('tax/calculation_rate')->getCollection()->addFieldToFilter('code', $item['tax_calculation_rate_id'])->getFirstItem()->getTaxCalculationRateId();
$item['customer_tax_class_id'] = Mage::getModel('tax/class')->getCollection()->addFieldToFilter('class_type', 'CUSTOMER')->addFieldToFilter('class_name', $item['customer_tax_class_id'])->getFirstItem()->getClassId();
$item['product_tax_class_id'] = Mage::getModel('tax/class')->getCollection()->addFieldToFilter('class_type', 'PRODUCT')->addFieldToFilter('class_name', $item['product_tax_class_id'])->getFirstItem()->getClassId();
//mage::d($item); die;
$model = new Mage_Tax_Model_Calculation();
foreach ($item as $key => $value) {
$model->setData($key, $value);
}
try {
$model->save();
} catch (Exception $e) {
mage::d($e->getMessage());
//die;
}
}
}
/**
* Get information about tax rates applied to request
*
* @param Varien_Object $request
* @return array
*/
public function getAppliedRates($request)
{
if ($this->_getDataHelper()->isServiceEnabled($this->_getStore($request))) {
return array();
}
return parent::getAppliedRates($request);
}
/**
* Round price based on tax rounding settings
*
* @param float $price
* @param string $rate
* @param bool $direction
* @param string $type
* @return float
*/
protected function _round($price, $rate, $direction, $type = 'regular')
{
if (!$price) {
return $this->_calculator->round($price);
}
$deltas = $this->_address->getRoundingDeltas();
$key = $type . $direction;
$rate = (string) $rate;
$delta = isset($deltas[$key][$rate]) ? $deltas[$key][$rate] : 0;
return $this->_calculator->round($price + $delta);
}
/**
* Round price based on previous rounding operation delta
*
* @param float $price
* @param string $rate
* @param bool $direction price including or excluding tax
* @param string $type
* @return float
*/
protected function _deltaRound($price, $rate, $direction, $type = 'regular')
{
if ($price) {
$rate = (string) $rate;
$type = $type . $direction;
$delta = isset($this->_roundingDeltas[$type][$rate]) ? $this->_roundingDeltas[$type][$rate] : 0;
$price += $delta;
$this->_roundingDeltas[$type][$rate] = $price - $this->_calculator->round($price);
$price = $this->_calculator->round($price);
}
return $price;
}
/**
* Round price based on previous rounding operation delta
*
* @param float $price
* @param string $rate
* @param bool $direction price including or excluding tax
* @param string $type
* @return float
*/
protected function _deltaRound($price, $rate, $direction, $type = 'regular')
{
if ($price) {
$rate = (string) $rate;
$type = $type . $direction;
// initialize the delta to a small number to avoid non-deterministic behavior with rounding of 0.5
$delta = isset($this->_roundingDeltas[$type][$rate]) ? $this->_roundingDeltas[$type][$rate] : 1.0E-6;
$price += $delta;
$this->_roundingDeltas[$type][$rate] = $price - $this->_calculator->round($price);
$price = $this->_calculator->round($price);
}
return $price;
}
public function getRateRequest($shippingAddress = null, $billingAddress = null, $customerTaxClass = null, $store = null)
{
$request = parent::getRateRequest($shippingAddress, $billingAddress, $customerTaxClass, $store);
$countryCode = Mage::getSingleton('geoip/country')->getCountry();
if ($countryCode) {
if (is_null($shippingAddress) && is_null($billingAddress) || $shippingAddress === false && $billingAddress === false) {
$request->setCountryId($countryCode);
$request->setRegionId(0);
$request->setPostcode('*');
} elseif (!$shippingAddress->getCountryId() && !$billingAddress->getCountryId()) {
$request->setCountryId($countryCode);
$request->setRegionId(0);
$request->setPostcode('*');
}
}
return $request;
}
/**
* Calculates tax amounts for the row item using $this->_calculator
*
* @param Mage_Sales_Model_Quote_Item $item
* @return $this
*/
protected function _calcTaxAmounts(&$item)
{
//@nelkaake -a 16/11/10: Calculator only works in magento 1.4 and up.
if (!Mage::helper('rewards/version')->isMageVersionAtLeast('1.4.2')) {
return $this;
}
// @nelkaake -a 16/11/10: Tax calculation methods
$tax = $this->_calculator->calcTaxAmount($item->getRowTotal(), $item->getTaxPercent(), false);
$baseTax = $this->_calculator->calcTaxAmount($item->getBaseRowTotal(), $item->getTaxPercent(), false);
$item->setTaxAmount($tax);
$item->setBaseTaxAmount($baseTax);
$item->setTaxableAmount($item->getRowTotal());
$item->setBaseTaxableAmount($item->getBaseRowTotal());
//@nelkaake -a 26/01/11: We don't set this so that we can later use the row total including tax to find out
// how much of the order was discounted due to catalog redemption rules.
$item->setRowTotalInclTax($item->getRowTotal() + $tax);
$item->setBaseRowTotalInclTax($item->getBaseRowTotal() + $baseTax);
return $this;
}
/**
* Get request for fetching address tax rate
*
* @deprecated after 1.4.0.0
* @param Mage_Sales_Model_Quote_Address $address
* @return Varien_Object
*/
protected function _getAddressTaxRequest($address)
{
$addressTaxRequest = $this->_calculator->getRateRequest($address, $address->getQuote()->getBillingAddress(), $address->getQuote()->getCustomerTaxClassId(), $address->getQuote()->getStore());
return $addressTaxRequest;
}
/**
* Recollect item price and row total using after taxes subtract.
* Declare item price including tax attributes
*
* @deprecated after 1.4.1
*
* @param Mage_Sales_Model_Quote_Address $address
* @param Mage_Sales_Model_Quote_Item_Abstract $item
*
* @return Mage_Tax_Model_Sales_Total_Quote_Subtotal
*/
protected function _recollectItem($address, Mage_Sales_Model_Quote_Item_Abstract $item)
{
$store = $address->getQuote()->getStore();
$request = $this->_getStoreTaxRequest($address);
$request->setProductClassId($item->getProduct()->getTaxClassId());
$rate = $this->_calculator->getRate($request);
$qty = $item->getTotalQty();
$price = $taxPrice = $item->getCalculationPriceOriginal();
$basePrice = $baseTaxPrice = $item->getBaseCalculationPriceOriginal();
$subtotal = $taxSubtotal = $item->getRowTotal();
$baseSubtotal = $baseTaxSubtotal = $item->getBaseRowTotal();
if ($this->_config->discountTax($store)) {
$item->setDiscountCalculationPrice($price);
$item->setBaseDiscountCalculationPrice($basePrice);
}
/**
* Use original price for tax calculation
*/
if ($item->hasCustomPrice() && !$this->_helper->applyTaxOnCustomPrice($store)) {
$taxPrice = $item->getOriginalPrice();
$baseTaxPrice = $item->getBaseOriginalPrice();
$taxSubtotal = $taxPrice * $qty;
$baseTaxSubtotal = $baseTaxPrice * $qty;
}
if ($this->_areTaxRequestsSimilar) {
$item->setRowTotalInclTax($subtotal);
$item->setBaseRowTotalInclTax($baseSubtotal);
$item->setPriceInclTax($price);
$item->setBasePriceInclTax($basePrice);
$item->setTaxCalcPrice($taxPrice);
$item->setBaseTaxCalcPrice($baseTaxPrice);
$item->setTaxCalcRowTotal($taxSubtotal);
$item->setBaseTaxCalcRowTotal($baseTaxSubtotal);
}
$this->_subtotalInclTax += $subtotal;
$this->_baseSubtotalInclTax += $baseSubtotal;
if ($this->_config->getAlgorithm($store) == Mage_Tax_Model_Calculation::CALC_UNIT_BASE) {
$taxAmount = $this->_calculator->calcTaxAmount($taxPrice, $rate, true);
$baseTaxAmount = $this->_calculator->calcTaxAmount($baseTaxPrice, $rate, true);
$unitPrice = $this->_calculator->round($price - $taxAmount);
$baseUnitPrice = $this->_calculator->round($basePrice - $baseTaxAmount);
$subtotal = $this->_calculator->round($unitPrice * $qty);
$baseSubtotal = $this->_calculator->round($baseUnitPrice * $qty);
} else {
$taxAmount = $this->_calculator->calcTaxAmount($taxSubtotal, $rate, true, false);
$baseTaxAmount = $this->_calculator->calcTaxAmount($baseTaxSubtotal, $rate, true, false);
$unitPrice = ($subtotal - $taxAmount) / $qty;
$baseUnitPrice = ($baseSubtotal - $baseTaxAmount) / $qty;
$subtotal = $this->_calculator->round($subtotal - $taxAmount);
$baseSubtotal = $this->_calculator->round($baseSubtotal - $baseTaxAmount);
}
if ($item->hasCustomPrice()) {
$item->setCustomPrice($unitPrice);
$item->setBaseCustomPrice($baseUnitPrice);
}
$item->setPrice($baseUnitPrice);
$item->setOriginalPrice($unitPrice);
$item->setBasePrice($baseUnitPrice);
$item->setRowTotal($subtotal);
$item->setBaseRowTotal($baseSubtotal);
return $this;
}
/**
* Calculate tax for amount
*
* @param float $price
* @param float $taxRate
* @return float
*/
protected function _calcTaxAmount($price)
{
return $this->_taxCalculationModel->calcTaxAmount($price, $this->_rate);
}
/**
* Aggregate row totals per tax rate in array
*
* @param Mage_Sales_Model_Quote_Item_Abstract $item
* @param float $rate
* @param array $taxGroups
* @return Mage_Tax_Model_Sales_Total_Quote
*/
protected function _aggregateTaxPerRate($item, $rate, &$taxGroups)
{
$store = $item->getStore();
$inclTax = $this->_usePriceIncludeTax($store);
if ($inclTax) {
$subtotal = $item->getTaxCalcRowTotal();
$baseSubtotal = $item->getBaseTaxCalcRowTotal();
} else {
if ($item->hasCustomPrice() && $this->_helper->applyTaxOnCustomPrice($store)) {
$subtotal = $item->getRowTotal();
$baseSubtotal = $item->getBaseRowTotal();
} else {
$subtotal = $item->getTotalQty() * $item->getOriginalPrice();
$baseSubtotal = $item->getTotalQty() * $item->getBaseOriginalPrice();
}
}
$discountAmount = $item->getDiscountAmount();
$baseDiscountAmount = $item->getBaseDiscountAmount();
$qty = $item->getTotalQty();
$rateKey = (string) $rate;
/**
* Add extra amounts which can be taxable too
*/
$calcTotal = $subtotal + $item->getExtraRowTaxableAmount();
$baseCalcTotal = $baseSubtotal + $item->getBaseExtraRowTaxableAmount();
$item->setTaxPercent($rate);
if (!isset($taxGroups[$rateKey]['totals'])) {
$taxGroups[$rateKey]['totals'] = array();
}
if (!isset($taxGroups[$rateKey]['totals'])) {
$taxGroups[$rateKey]['base_totals'] = array();
}
$calculationSequence = $this->_helper->getCalculationSequence($store);
switch ($calculationSequence) {
case Mage_Tax_Model_Calculation::CALC_TAX_BEFORE_DISCOUNT_ON_EXCL:
$rowTax = $this->_calculator->calcTaxAmount($calcTotal, $rate, $inclTax, false);
$baseRowTax = $this->_calculator->calcTaxAmount($baseCalcTotal, $rate, $inclTax, false);
break;
case Mage_Tax_Model_Calculation::CALC_TAX_BEFORE_DISCOUNT_ON_INCL:
$rowTax = $this->_calculator->calcTaxAmount($calcTotal, $rate, $inclTax, false);
$baseRowTax = $this->_calculator->calcTaxAmount($baseCalcTotal, $rate, $inclTax, false);
$discountPrice = $inclTax ? $subtotal / $qty : ($subtotal + $rowTax) / $qty;
$baseDiscountPrice = $inclTax ? $baseSubtotal / $qty : ($baseSubtotal + $baseRowTax) / $qty;
$item->setDiscountCalculationPrice($discountPrice);
$item->setBaseDiscountCalculationPrice($baseDiscountPrice);
break;
case Mage_Tax_Model_Calculation::CALC_TAX_AFTER_DISCOUNT_ON_EXCL:
case Mage_Tax_Model_Calculation::CALC_TAX_AFTER_DISCOUNT_ON_INCL:
$calcTotal = $calcTotal - $discountAmount;
$baseCalcTotal = $baseCalcTotal - $baseDiscountAmount;
$rowTax = $this->_calculator->calcTaxAmount($calcTotal, $rate, $inclTax, false);
$baseRowTax = $this->_calculator->calcTaxAmount($baseCalcTotal, $rate, $inclTax, false);
break;
}
/**
* "Delta" rounding
*/
$delta = isset($this->_roundingDeltas[$rateKey]) ? $this->_roundingDeltas[$rateKey] : 0;
$baseDelta = isset($this->_baseRoundingDeltas[$rateKey]) ? $this->_baseRoundingDeltas[$rateKey] : 0;
$rowTax += $delta;
$baseRowTax += $baseDelta;
$this->_roundingDeltas[$rateKey] = $rowTax - $this->_calculator->round($rowTax);
$this->_baseRoundingDeltas[$rateKey] = $baseRowTax - $this->_calculator->round($baseRowTax);
$rowTax = $this->_calculator->round($rowTax);
$baseRowTax = $this->_calculator->round($baseRowTax);
/**
* Renew item amounts in case if we are working with price include tax
*/
if ($inclTax) {
$unitTax = $this->_calculator->round($rowTax / $qty);
$baseUnitTax = $this->_calculator->round($baseRowTax / $qty);
if ($item->hasCustomPrice()) {
$item->setCustomPrice($item->getPriceInclTax() - $unitTax);
$item->setBaseCustomPrice($item->getBasePriceInclTax() - $baseUnitTax);
} else {
$item->setOriginalPrice($item->getPriceInclTax() - $unitTax);
$item->setPrice($item->getBasePriceInclTax() - $baseUnitTax);
$item->setBasePrice($item->getBasePriceInclTax() - $baseUnitTax);
}
$item->setRowTotal($item->getRowTotalInclTax() - $rowTax);
$item->setBaseRowTotal($item->getBaseRowTotalInclTax() - $baseRowTax);
}
$item->setTaxAmount($rowTax);
$item->setBaseTaxAmount($baseRowTax);
$taxGroups[$rateKey]['totals'][] = $calcTotal;
$taxGroups[$rateKey]['base_totals'][] = $baseCalcTotal;
return $this;
}