<?php

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
//

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 == 0)
		return 0;

	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 $price;
	
	$tax_multiplier = 0;	

	// loop for all items

	foreach ($tax_array as $taxitem) 
	{
			$tax_multiplier += $taxitem["rate"];
	}
	
	return round($price / (1 + ($tax_multiplier / 100)),  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;
	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

	foreach ($tax_array as $taxitem) 
	{
			$tax_multiplier += $taxitem["rate"];
	}
	
	return round($price * (1 + ($tax_multiplier / 100)),  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)
{
	$item_tax_type = get_item_tax_type_for_item($stock_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($item_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();
	
	// if any of the taxes of the tax group are in the exemptions, then skip
	foreach ($tax_group_items_array as $tax_group_item) 
	{ 
		
		$skip = false;			
		
		// if it's in the exemptions, skip
		foreach ($item_tax_type_exemptions as $exemption) 
		{
			if (($tax_group_item['tax_type_id'] == $exemption)) 
			{
    			$skip = true;
    			break;
			}
		}
		
		if (!$skip) 
		{
			$index = $tax_group_item['tax_type_id'];
			$ret_tax_array[$index] = $tax_group_item;
		}
	}
	
	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, $tax_included=null, $tax_items_array=null)
{
	// 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;
	else
	  $ret_tax_array = get_tax_group_items_as_array($tax_group);
	
	// 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'];
				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]['Value'] += 
				  //	round($prices[$i] * $item_tax['rate'] / 100,  user_price_dec());
				  $ret_tax_array[$index]['Value'] += ($prices[$i] * $item_tax['rate'] / 100);
			}
		}
	}
	
	// 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();
		if ($item_taxes != null) 
		{
			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));
				  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);
				}
			}
		}
	}
	
	//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;
		}
	}
	
	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;
}

?>