X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;ds=sidebyside;f=taxes%2Ftax_calc.inc;h=3ef685aef1cda24d34d4ea9c5f58d34c3cd0edb1;hb=e01ce098c8862750e2f4f66f255191e83a4ce1d6;hp=aa8f9de81c456367cfb0c5f8aa699cfe11c68997;hpb=4e436722cb991b7273c08bdc1dc53b5390772972;p=fa-stable.git diff --git a/taxes/tax_calc.inc b/taxes/tax_calc.inc index aa8f9de8..3ef685ae 100644 --- a/taxes/tax_calc.inc +++ b/taxes/tax_calc.inc @@ -1,13 +1,13 @@ . + See the License here . ***********************************************************************/ include_once($path_to_root . "/taxes/db/tax_groups_db.inc"); include_once($path_to_root . "/taxes/db/tax_types_db.inc"); @@ -15,36 +15,9 @@ include_once($path_to_root . "/taxes/db/item_tax_types_db.inc"); //--------------------------------------------------------------------------------- -// returns the tax cost for a given item -/* -function get_tax_value_for_item($stock_id, $price, $tax_group) -{ - // if price is zero, then can't be taxed - if ($price == 0) - return 0; - - $ret_tax_array = get_tax_group_items_as_array($tax_group); - - $tax_array = get_taxes_for_item($stock_id, $ret_tax_array); - if ($tax_array == null) - return 0; - - $tax_multiplier = 0; - - // loop for all items - foreach ($tax_array as $taxitem) { - $tax_multiplier += $taxitem["rate"]; - } - - return $price * ($tax_multiplier / 100); -} -*/ -//--------------------------------------------------------------------------------- - // returns the price of a given item minus any included taxes // for item $stock_id with line price $price, // with applicable tax rates $tax_group_array or group id $tax_group -// function get_tax_free_price_for_item($stock_id, $price, $tax_group, $tax_included, $tax_group_array=null) { @@ -60,23 +33,25 @@ function get_tax_free_price_for_item($stock_id, $price, $tax_group, $tax_include else $ret_tax_array = get_tax_group_items_as_array($tax_group); - //print_r($ret_tax_array); - $tax_array = get_taxes_for_item($stock_id, $ret_tax_array); + // if no exemptions or taxgroup is empty, then no included/excluded taxes if ($tax_array == null) return $price; - - $tax_multiplier = 0; - - // loop for all items + // to avoid rounding errors we have to just subtract taxes from tax_included price. + $tax_multiplier = 0; foreach ($tax_array as $taxitem) { - $tax_multiplier += $taxitem["rate"]; + $tax_multiplier += $taxitem["rate"]; } - - return round($price / (1 + ($tax_multiplier / 100)), user_price_dec()); + + $tax = 0; + foreach ($tax_array as $taxitem) + { + $tax += round($price*$taxitem['rate']/(100+$tax_multiplier), user_price_dec()); + } + return $price-$tax; } // // Full price (incl. VAT) for item $stock_id with line price $price, @@ -103,7 +78,7 @@ function get_full_price_for_item($stock_id, $price, $tax_group, $tax_included, $ if ($tax_array == null) return $price; - $tax_multiplier = 0; + $tax_multiplier = 0; // loop for all items @@ -142,7 +117,7 @@ function get_taxes_for_item($stock_id, $tax_group_items_array) foreach ($tax_group_items_array as $tax_group_item) { - $skip = false; + $skip = false; // if it's in the exemptions, skip foreach ($item_tax_type_exemptions as $exemption) @@ -166,134 +141,100 @@ function get_taxes_for_item($stock_id, $tax_group_items_array) //----------------------------------------------------------------------------------- // return an array of (tax_type_id, tax_type_name, sales_gl_code, purchasing_gl_code, rate, included_in_price, Value) -function get_tax_for_items($items, $prices, $shipping_cost, $tax_group, $tax_included=null, $tax_items_array=null) +function get_tax_for_items($items, $prices, $shipping_cost, $tax_group, $tax_included=null, $tax_items_array=null, $tax_algorithm = null) { + if (!$tax_algorithm) + $tax_algorithm = get_company_pref('tax_algorithm'); // first create and set an array with all the tax types of the tax group if($tax_items_array!=null) - $ret_tax_array = $tax_items_array; + $ret_tax_array = $tax_items_array; else - $ret_tax_array = get_tax_group_items_as_array($tax_group); + $ret_tax_array = get_tax_group_items_as_array($tax_group); + + $dec = user_price_dec(); + $fully_exempt = true; foreach($ret_tax_array as $k=>$t) + { + if ($t['rate'] !== null) + $fully_exempt = false; $ret_tax_array[$k]['Net'] = 0; - + } + + $ret_tax_array['exempt'] = array('Value'=>0, 'Net'=>0, 'rate' => null, 'tax_type_id' => '', 'sales_gl_code' => ''); + $dec = user_price_dec(); // loop for all items for ($i = 0; $i < count($items); $i++) { $item_taxes = get_taxes_for_item($items[$i], $ret_tax_array); - - if ($item_taxes != null) + if ($item_taxes == null || $fully_exempt) + { + $ret_tax_array['exempt']['Value'] += round2(0, $dec); + $ret_tax_array['exempt']['Net'] += $prices[$i]; + } + else { + $tax_multiplier = 0; + foreach ($item_taxes as $taxitem) + { + $tax_multiplier += $taxitem['rate']; + } foreach ($item_taxes as $item_tax) { - $index = $item_tax['tax_type_id']; - if($tax_included==1) {// 2008-11-26 Joe Hunt Taxes are stored without roundings - //$ret_tax_array[$index]['Value'] += round($prices[$i] * $item_tax['rate'] - // / ($item_tax['rate'] + 100), user_price_dec()); - $ret_tax_array[$index]['Value'] += ($prices[$i] * $item_tax['rate'] / ($item_tax['rate'] + 100)); - $ret_tax_array[$index]['Net'] += ($prices[$i] * 100 / ($item_tax['rate'] + 100)); - } else { - //$ret_tax_array[$index]['Value'] += - // round($prices[$i] * $item_tax['rate'] / 100, user_price_dec()); - $ret_tax_array[$index]['Value'] += ($prices[$i] * $item_tax['rate'] / 100); - $ret_tax_array[$index]['Net'] += $prices[$i]; + if ($item_tax['rate'] !== null) { + $index = $item_tax['tax_type_id']; + if ($tax_included == 1) { + $ret_tax_array[$index]['Value'] += round2($prices[$i]*$item_tax['rate']/(100+$tax_multiplier), $dec); + $ret_tax_array[$index]['Net'] += round2($prices[$i]*100/(100+$tax_multiplier), $dec); + } else { + $ret_tax_array[$index]['Value'] += round2($prices[$i] * $item_tax['rate'] / 100, $dec); + $ret_tax_array[$index]['Net'] += $prices[$i]; + } } } } } - // add the shipping taxes, only if non-zero, and only if tax group taxes shipping if ($shipping_cost != 0) { - $item_taxes = get_shipping_tax_as_array(); + $item_taxes = get_shipping_tax_as_array($tax_group); if ($item_taxes != null) { + if ($tax_included == 1) + { + $tax_rate = 0; + foreach ($item_taxes as $item_tax) + { + $index = $item_tax['tax_type_id']; + if(isset($ret_tax_array[$index])) { + $tax_rate += $item_tax['rate']; + } + } + $shipping_net = round2($shipping_cost*100/(100+$tax_rate), $dec); + } foreach ($item_taxes as $item_tax) { $index = $item_tax['tax_type_id']; - if(isset($ret_tax_array[$index])) { - if($tax_included==1) {// 2008-11-26 Joe Hunt Taxes are stored without roundings - //$ret_tax_array[$index]['Value'] += round($shipping_cost * $item_tax['rate'] - // / ($item_tax['rate'] + 100), user_price_dec()); - $ret_tax_array[$index]['Value'] += ($shipping_cost * $item_tax['rate'] / ($item_tax['rate'] + 100)); - $ret_tax_array[$index]['Net'] += ($shipping_cost * 100 / ($item_tax['rate'] + 100)); - } else { - //$ret_tax_array[$index]['Value'] += - // round($shipping_cost * $item_tax['rate'] / 100, user_price_dec()); - $ret_tax_array[$index]['Value'] += ($shipping_cost * $item_tax['rate'] / 100); - $ret_tax_array[$index]['Net'] += $shipping_cost; - } + if ($item_tax['rate'] !== null && $ret_tax_array[$index]['rate'] !== null) { + if($tax_included==1) { + $ret_tax_array[$index]['Value'] += round2($shipping_cost*$item_tax['rate']/(100+$tax_rate), $dec); + $ret_tax_array[$index]['Net'] += $shipping_net; + } else { + $ret_tax_array[$index]['Value'] += round2($shipping_cost * $item_tax['rate'] / 100, $dec); + $ret_tax_array[$index]['Net'] += $shipping_cost; + } } } } } - - //print_r($ret_tax_array); - return $ret_tax_array; -} -// -// Get all taxes for given tax_type_id. This can be used when -// no tax group exemptions are active (local sales). -// To be used in quick entries. -// -function get_taxes_for_item_tax($tax_type_id) -{ - $item_tax_type = get_item_tax_type($tax_type_id); - - // if the item is exempt from all taxes then return 0 - if ($item_tax_type["exempt"]) - return null; - - // get the exemptions for this item tax type - $item_tax_type_exemptions_db = get_item_tax_type_exemptions($tax_type_id); - - // read them all into an array to minimize db querying - $item_tax_type_exemptions = array(); - while ($item_tax_type_exemp = db_fetch($item_tax_type_exemptions_db)) - { - $item_tax_type_exemptions[] = $item_tax_type_exemp["tax_type_id"]; - } - - $ret_tax_array = array(); - - $tax_rates = get_all_tax_types_simple(); - // if any of the taxes are in the exemptions, then skip - while($tax_rate = db_fetch($tax_rates)) - { - - $skip = false; - - // if it's in the exemptions, skip - foreach ($item_tax_type_exemptions as $exemption) - { - if (($tax_rate['id'] == $exemption)) - { - $skip = true; - break; - } - } - - if (!$skip) - { - $index = $tax_rate['id']; - $ret_tax_array[$index] = $tax_rate; + if ($tax_algorithm == TCA_TOTALS ) { + // update taxes with + foreach($ret_tax_array as $index => $item_tax) { + $ret_tax_array[$index]['Value'] = round2($item_tax['Net'] * $item_tax['rate'] / 100, $dec); } } - - return $ret_tax_array; -} -function is_tax_account($account_code) -{ - $sql= "SELECT id FROM ".TB_PREF."tax_types WHERE - sales_gl_code='$account_code' OR purchasing_gl_code='$account_code'"; - $result = db_query($sql, "checking account is tax account"); - if (db_num_rows($result) > 0) { - $acct = db_fetch($result); - return $acct['id']; - } else - return false; + return $ret_tax_array; } -?> \ No newline at end of file