X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=taxes%2Ftax_calc.inc;h=3f54bd226aa65ee6871e86e30598f11f57d9ec37;hb=66a62190f99d83f958bb98195b5756b8b307e378;hp=1f00b8a095d93cf4fe765ddecd69de62d6917650;hpb=da8311619dd73feae101d246a1957b972e00cbd2;p=fa-stable.git diff --git a/taxes/tax_calc.inc b/taxes/tax_calc.inc index 1f00b8a0..3f54bd22 100644 --- a/taxes/tax_calc.inc +++ b/taxes/tax_calc.inc @@ -1,45 +1,69 @@ . +***********************************************************************/ 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 +// 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_value_for_item($stock_id, $price, $tax_group) +function get_tax_free_price_for_item($stock_id, $price, $tax_group, $tax_included, $tax_group_array=null) { - // if price is zero, then can't be taxed + // 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); - + + if ($tax_included==0) return $price; + + // if array already read, then make a copy and use that + if ($tax_group_array) + $ret_tax_array = $tax_group_array; + 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 0; + return $price; $tax_multiplier = 0; // loop for all items - foreach ($tax_array as $taxitem) { - $tax_multiplier += $taxitem["rate"]; + + 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 - -function get_tax_free_price_for_item($stock_id, $price, $tax_group, $tax_group_array=null) + return round($price / (1 + ($tax_multiplier / 100)), 2*user_price_dec()); +} +// +// Full price (incl. VAT) for item $stock_id with line price $price, +// with tax rates $tax_group_array or applicable group $tax_group +// +function get_full_price_for_item($stock_id, $price, $tax_group, $tax_included, $tax_group_array=null) { // if price is zero, then can't be taxed ! if ($price == 0) return 0; + if ($tax_included==1) return $price; + // if array already read, then make a copy and use that if ($tax_group_array) $ret_tax_array = $tax_group_array; @@ -59,16 +83,13 @@ function get_tax_free_price_for_item($stock_id, $price, $tax_group, $tax_group_a foreach ($tax_array as $taxitem) { - if ($taxitem["included_in_price"]) $tax_multiplier += $taxitem["rate"]; } - return $price / (1 + ($tax_multiplier / 100)); + return round($price * (1 + ($tax_multiplier / 100)), 2*user_price_dec()); } //--------------------------------------------------------------------------------- - - // return an array of (tax_type_id, tax_type_name, sales_gl_code, purchasing_gl_code, rate) function get_taxes_for_item($stock_id, $tax_group_items_array) @@ -116,26 +137,38 @@ function get_taxes_for_item($stock_id, $tax_group_items_array) return $ret_tax_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) +function get_tax_for_items($items, $prices, $shipping_cost, $tax_group, $tax_included=null, $tax_items_array=null) { // first create and set an array with all the tax types of the tax group - $ret_tax_array = get_tax_group_items_as_array($tax_group); - + if($tax_items_array!=null) + $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++) { $item_taxes = get_taxes_for_item($items[$i], $ret_tax_array); + if ($item_taxes != null) { foreach ($item_taxes as $item_tax) { $index = $item_tax['tax_type_id']; - $ret_tax_array[$index]['Value'] += $prices[$i] * $item_tax['rate'] / 100; + if($tax_included==1) {// 2008-11-26 Joe Hunt Taxes are stored without roundings + $nprice = get_tax_free_price_for_item($items[$i], $prices[$i], $tax_group, $tax_included); + $ret_tax_array[$index]['Value'] += ($nprice * $item_tax['rate'] / 100); + $ret_tax_array[$index]['Net'] += $nprice; + } else { + $ret_tax_array[$index]['Value'] += ($prices[$i] * $item_tax['rate'] / 100); + $ret_tax_array[$index]['Net'] += $prices[$i]; + } } } } @@ -143,13 +176,33 @@ function get_tax_for_items($items, $prices, $shipping_cost, $tax_group) // add the shipping taxes, only if non-zero, and only if tax group taxes shipping if ($shipping_cost != 0) { - $tax_group = get_tax_group($tax_group); - if ($tax_group['tax_shipping']) + $item_taxes = get_shipping_tax_as_array(); + if ($item_taxes != null) { - foreach ($ret_tax_array as $item_tax) + 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 / (1 + ($tax_rate / 100)), user_price_dec()); + } + foreach ($item_taxes as $item_tax) { $index = $item_tax['tax_type_id']; - $ret_tax_array[$index]['Value'] += $shipping_cost * $item_tax['rate'] / 100; + 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'] += ($shipping_net * $item_tax['rate'] / 100); + $ret_tax_array[$index]['Net'] += $shipping_net; + } else { + $ret_tax_array[$index]['Value'] += ($shipping_cost * $item_tax['rate'] / 100); + $ret_tax_array[$index]['Net'] += $shipping_cost; + } + } } } } @@ -159,5 +212,4 @@ function get_tax_for_items($items, $prices, $shipping_cost, $tax_group) return $ret_tax_array; } - ?> \ No newline at end of file