X-Git-Url: https://delta.frontaccounting.com/gitweb/?p=fa-stable.git;a=blobdiff_plain;f=taxes%2Ftax_calc.inc;h=3ef685aef1cda24d34d4ea9c5f58d34c3cd0edb1;hp=6f6e9b7b153d4e5669b0900fc42d49921d154358;hb=e01ce098c8862750e2f4f66f255191e83a4ce1d6;hpb=a4f5314521187b67feb7742ed1b6c51aa199a6b0

diff --git a/taxes/tax_calc.inc b/taxes/tax_calc.inc
index 6f6e9b7b..3ef685ae 100644
--- a/taxes/tax_calc.inc
+++ b/taxes/tax_calc.inc
@@ -18,7 +18,6 @@ include_once($path_to_root . "/taxes/db/item_tax_types_db.inc");
 // 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)
 {
@@ -34,22 +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,
@@ -76,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
 
@@ -115,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) 
@@ -139,43 +141,63 @@ 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
-				  $nprice = get_tax_free_price_for_item($items[$i], $prices[$i], $tax_group, $tax_included);
-				  $ret_tax_array[$index]['Value'] += $prices[$i]-$nprice;
-				  $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];
+				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)
@@ -188,27 +210,31 @@ function get_tax_for_items($items, $prices, $shipping_cost, $tax_group, $tax_inc
 						$tax_rate += $item_tax['rate'];
 					}
 				}
-				$shipping_net = round2($shipping_cost / (1 + ($tax_rate / 100)), user_price_dec());
-			}	
+				$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'] += ($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;
-				 }
+				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);
+
+	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;
 }
 
-?>
\ No newline at end of file