X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=taxes%2Ftax_calc.inc;h=1209d62133eca1f355f073e7f2a464b95b999aaa;hb=95303d7b5280820af76ddbd8908b120813f1e763;hp=a9bf26e624ba5d6913c48596b26950ab329e0914;hpb=67a69c5b76586ce31f2a2451f1ade92ffd31a0c7;p=fa-stable.git diff --git a/taxes/tax_calc.inc b/taxes/tax_calc.inc index a9bf26e6..1209d621 100644 --- a/taxes/tax_calc.inc +++ b/taxes/tax_calc.inc @@ -1,37 +1,20 @@ . +***********************************************************************/ include_once($path_to_root . "/taxes/db/tax_groups_db.inc"); include_once($path_to_root . "/taxes/db/tax_types_db.inc"); 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 @@ -164,7 +147,10 @@ function get_tax_for_items($items, $prices, $shipping_cost, $tax_group, $tax_inc $ret_tax_array = $tax_items_array; else $ret_tax_array = get_tax_group_items_as_array($tax_group); - + + foreach($ret_tax_array as $k=>$t) + $ret_tax_array[$k]['Net'] = 0; + // loop for all items for ($i = 0; $i < count($items); $i++) { @@ -175,14 +161,17 @@ function get_tax_for_items($items, $prices, $shipping_cost, $tax_group, $tax_inc 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 + 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)); - else + $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]; + } } } } @@ -197,14 +186,17 @@ function get_tax_for_items($items, $prices, $shipping_cost, $tax_group, $tax_inc { $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 + 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)); - else + $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; + } } } } @@ -214,57 +206,6 @@ function get_tax_for_items($items, $prices, $shipping_cost, $tax_group, $tax_inc 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; - } - } - - return $ret_tax_array; -} function is_tax_account($account_code) {