X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=taxes%2Ftax_calc.inc;h=db98540842b321e134efa61fca56db60725c3a7c;hb=d1b959c4b73664327c2e17d5bb3fb515aabfa449;hp=9d1ba576097fba04bc6ccac1e86fdf24a4c4b6e1;hpb=c09be0dad6b05131e240349a375af7a4b7bf3444;p=fa-stable.git

diff --git a/taxes/tax_calc.inc b/taxes/tax_calc.inc
index 9d1ba576..db985408 100644
--- a/taxes/tax_calc.inc
+++ b/taxes/tax_calc.inc
@@ -1,37 +1,20 @@
 <?php
-
+/**********************************************************************
+    Copyright (C) FrontAccounting, LLC.
+	Released under the terms of the GNU General Public License, GPL, 
+	as published by the Free Software Foundation, either version 3 
+	of the License, or (at your option) any later version.
+    This program is distributed in the hope that it will be useful,
+    but WITHOUT ANY WARRANTY; without even the implied warranty of
+    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  
+    See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
+***********************************************************************/
 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
@@ -67,7 +50,7 @@ function get_tax_free_price_for_item($stock_id, $price, $tax_group, $tax_include
 			$tax_multiplier += $taxitem["rate"];
 	}
 	
-	return round($price / (1 + ($tax_multiplier / 100)),  user_price_dec());
+	return round($price / (1 + ($tax_multiplier / 100)),  2*user_price_dec());
 }
 //
 //	Full price (incl. VAT) for item $stock_id with line price $price,
@@ -103,7 +86,7 @@ function get_full_price_for_item($stock_id, $price, $tax_group, $tax_included, $
 			$tax_multiplier += $taxitem["rate"];
 	}
 	
-	return round($price * (1 + ($tax_multiplier / 100)),  user_price_dec());
+	return round($price * (1 + ($tax_multiplier / 100)),  2*user_price_dec());
 }
 
 //---------------------------------------------------------------------------------
@@ -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,12 +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)
-				  $ret_tax_array[$index]['Value'] += round($prices[$i] * $item_tax['rate'] 
-					/ ($item_tax['rate'] + 100),  user_price_dec());
-				else
-				  $ret_tax_array[$index]['Value'] += 
-					round($prices[$i] * $item_tax['rate'] / 100,  user_price_dec());
+				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];
+				}
 			}
 		}
 	}
@@ -195,12 +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)
-					$ret_tax_array[$index]['Value'] += round($shipping_cost * $item_tax['rate'] 
-					  / ($item_tax['rate'] + 100),  user_price_dec());
-				  else
-					$ret_tax_array[$index]['Value'] += 
-					  round($shipping_cost * $item_tax['rate'] / 100,  user_price_dec());
+				  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;
+				 }
 				}
 			}
 		}
@@ -211,5 +207,16 @@ function get_tax_for_items($items, $prices, $shipping_cost, $tax_group, $tax_inc
 	return $ret_tax_array;
 }
 
+function is_tax_account($account_code)
+{
+	$sql= "SELECT id FROM ".TB_PREF."tax_types WHERE 
+		sales_gl_code=".db_escape($account_code)." OR purchasing_gl_code=".db_escape($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;
+}
 
 ?>
\ No newline at end of file