X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=taxes%2Ftax_calc.inc;h=397c5f501f3d7eae3c0eef49de6fd847d9240663;hb=4a66afcbed7fb883d00c1a6a807497ccfd181378;hp=1f00b8a095d93cf4fe765ddecd69de62d6917650;hpb=da8311619dd73feae101d246a1957b972e00cbd2;p=fa-stable.git diff --git a/taxes/tax_calc.inc b/taxes/tax_calc.inc index 1f00b8a0..397c5f50 100644 --- a/taxes/tax_calc.inc +++ b/taxes/tax_calc.inc @@ -1,5 +1,14 @@ . +***********************************************************************/ 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"); @@ -7,8 +16,8 @@ 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) +/* +function get_tax_value_for_item($stock_id, $price, $tax_group) { // if price is zero, then can't be taxed if ($price == 0) @@ -28,18 +37,23 @@ include_once($path_to_root . "/taxes/db/item_tax_types_db.inc"); } 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_group_array=null) +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; @@ -59,16 +73,49 @@ 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)), 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) @@ -116,26 +163,41 @@ 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 + //$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]; + } } } } @@ -143,13 +205,25 @@ 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) + 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'] += 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; + } + } } } } @@ -158,6 +232,68 @@ function get_tax_for_items($items, $prices, $shipping_cost, $tax_group) 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; +} ?> \ No newline at end of file