<?php
-
-function add_tax_group($name, $tax_shipping, $taxes, $rates, $included)
+/**********************************************************************
+ 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>.
+***********************************************************************/
+function add_tax_group($name, $taxes, $rates, $tax_shippings)
{
begin_transaction();
-
- $sql = "INSERT INTO ".TB_PREF."tax_groups (name, tax_shipping) VALUES ('$name', $tax_shipping)";
+
+ $sql = "INSERT INTO ".TB_PREF."tax_groups (name) VALUES (".db_escape($name).")";
db_query($sql, "could not add tax group");
$id = db_insert_id();
- add_tax_group_items($id, $taxes, $rates, $included);
+ add_tax_group_items($id, $taxes, $rates, $tax_shippings);
commit_transaction();
}
-function update_tax_group($id, $name, $tax_shipping, $taxes, $rates, $included)
+function update_tax_group($id, $name, $taxes, $rates, $tax_shippings)
{
begin_transaction();
-
- $sql = "UPDATE ".TB_PREF."tax_groups SET name='$name',tax_shipping=$tax_shipping WHERE id=$id";
-
+
+ $sql = "UPDATE ".TB_PREF."tax_groups SET name=".db_escape($name)." WHERE id=".db_escape($id);
db_query($sql, "could not update tax group");
delete_tax_group_items($id);
- add_tax_group_items($id, $taxes, $rates, $included);
+ add_tax_group_items($id, $taxes, $rates, $tax_shippings);
commit_transaction();
}
-function get_all_tax_groups()
+function get_all_tax_groups($all=false)
{
$sql = "SELECT * FROM ".TB_PREF."tax_groups";
+ if (!$all) $sql .= " WHERE !inactive";
return db_query($sql, "could not get all tax group");
}
function get_tax_group($type_id)
{
- $sql = "SELECT * FROM ".TB_PREF."tax_groups WHERE id=$type_id";
+ $sql = "SELECT * FROM ".TB_PREF."tax_groups WHERE id=".db_escape($type_id);
$result = db_query($sql, "could not get tax group");
{
begin_transaction();
- $sql = "DELETE FROM ".TB_PREF."tax_groups WHERE id=$id";
+ $sql = "DELETE FROM ".TB_PREF."tax_groups WHERE id=".db_escape($id);
db_query($sql, "could not delete tax group");
commit_transaction();
}
-function add_tax_group_items($id, $items, $rates, $included)
+function add_tax_group_items($id, $items, $rates, $tax_shippings)
{
for ($i=0; $i < count($items); $i++)
{
- $sql = "INSERT INTO ".TB_PREF."tax_group_items (tax_group_id, tax_type_id, rate, included_in_price)
- VALUES ($id, " . $items[$i] . ", " . $rates[$i] . ", " . $included[$i] .")";
+ $sql = "INSERT INTO ".TB_PREF."tax_group_items (tax_group_id, tax_type_id, rate, tax_shipping)
+ VALUES (".db_escape($id).", ".db_escape($items[$i]).", " . $rates[$i] .", " . $tax_shippings[$i] .")";
db_query($sql, "could not add item tax group item");
}
}
function delete_tax_group_items($id)
{
- $sql = "DELETE FROM ".TB_PREF."tax_group_items WHERE tax_group_id=$id";
+ $sql = "DELETE FROM ".TB_PREF."tax_group_items WHERE tax_group_id=".db_escape($id);
db_query($sql, "could not delete item tax group items");
}
-function get_tax_group_items($id)
+//
+// Return all tax types with rate value updated according to tax group selected
+// Call the function without arg to find shipment group taxes.
+//
+function get_tax_group_rates($group_id=null, $tax_shipping=false)
{
- $sql = "SELECT ".TB_PREF."tax_group_items.*, ".TB_PREF."tax_types.name AS tax_type_name,
- ".TB_PREF."tax_types.sales_gl_code, ".TB_PREF."tax_types.purchasing_gl_code
- FROM ".TB_PREF."tax_group_items, ".TB_PREF."tax_types
- WHERE tax_group_id=$id
- AND ".TB_PREF."tax_types.id=tax_type_id";
-
- return db_query($sql, "could not get item tax type group items");
+ global $suppress_tax_rates;
+
+ $sql =
+ "SELECT t.id as tax_type_id,"
+ .(isset($suppress_tax_rates) && $suppress_tax_rates == 1
+ ? "t.name as tax_type_name,"
+ : "CONCAT(t.name, ' (', t.rate, '%)') as tax_type_name,")
+ ."t.sales_gl_code,
+ t.purchasing_gl_code,
+ IF(g.tax_type_id, t.rate, NULL) as rate,
+ g.tax_shipping
+ FROM ".TB_PREF."tax_types t
+ LEFT JOIN ".TB_PREF."tax_group_items g ON t.id=g.tax_type_id
+ AND g.tax_group_id=". ($group_id ? db_escape($group_id) : "(SELECT MIN(id) FROM ".TB_PREF."tax_groups)")
+ . " WHERE !t.inactive";
+ if ($tax_shipping)
+ $sql .= " AND g.tax_shipping=1";
+
+ return db_query($sql, "cannot get tax types as array");
}
function get_tax_group_items_as_array($id)
{
$ret_tax_array = array();
- $tax_group_items = get_tax_group_items($id);
+ $tax_group_items = get_tax_group_rates($id);
while ($tax_group_item = db_fetch($tax_group_items))
{
- $index = $tax_group_item['tax_type_id'];
- $ret_tax_array[$index]['tax_type_id'] = $tax_group_item['tax_type_id'];
- $ret_tax_array[$index]['tax_type_name'] = $tax_group_item['tax_type_name'];
- $ret_tax_array[$index]['sales_gl_code'] = $tax_group_item['sales_gl_code'];
- $ret_tax_array[$index]['purchasing_gl_code'] = $tax_group_item['purchasing_gl_code'];
- $ret_tax_array[$index]['rate'] = $tax_group_item['rate'];
- $ret_tax_array[$index]['included_in_price'] = $tax_group_item['included_in_price'];
- $ret_tax_array[$index]['Value'] = 0;
+ $tax_group_item['Value'] = 0;
+ $ret_tax_array[$tax_group_item['tax_type_id']] = $tax_group_item;
+
}
return $ret_tax_array;
}
+function get_shipping_tax_as_array($id)
+{
+ $ret_tax_array = array();
+
+ $tax_group_items = get_tax_group_rates($id, true);
+
+ while ($tax_group_item = db_fetch($tax_group_items))
+ {
+ $tax_group_item['Value'] = 0;
+ $ret_tax_array[$tax_group_item['tax_type_id']] = $tax_group_item;
+ }
+
+ return $ret_tax_array;
+}
?>
\ No newline at end of file
projects / fa-stable.git / blobdiff