Copyright notes at top op every source file

[fa-stable.git] / taxes / db / tax_groups_db.inc

diff --git a/taxes/db/tax_groups_db.inc b/taxes/db/tax_groups_db.inc
index 415d041915fe7db2c3b9d57fe31ba0da47eef841..7823bcb93729cf58c6885621d9e79bf95fc31e25 100644 (file)
--- a/taxes/db/tax_groups_db.inc
+++ b/taxes/db/tax_groups_db.inc
@@ -1,29 +1,48 @@
 <?php
+/**********************************************************************
+    Copyright (C) FrontAccounting, LLC.
+       Released under the terms of the GNU Affero General Public License,
+       AGPL, 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/agpl-3.0.html>.
+***********************************************************************/
+function clear_shipping_tax_group() {
+         $sql = "UPDATE ".TB_PREF."tax_groups SET tax_shipping=0 WHERE 1";
+         db_query($sql, "could not update tax_shipping fields");         
+}
 
-function add_tax_group($name, $tax_shipping, $taxes, $rates, $included)
+function add_tax_group($name, $tax_shipping, $taxes, $rates)
 {
        begin_transaction();
+
+       if($tax_shipping)       // only one tax group for shipping
+         clear_shipping_tax_group();
                
-       $sql = "INSERT INTO ".TB_PREF."tax_groups (name, tax_shipping) VALUES ('$name', $tax_shipping)";                
+       $sql = "INSERT INTO ".TB_PREF."tax_groups (name, tax_shipping) VALUES (".db_escape($name).", $tax_shipping)";
        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);       
        
        commit_transaction();   
 }
 
-function update_tax_group($id, $name, $tax_shipping, $taxes, $rates, $included)
+function update_tax_group($id, $name, $tax_shipping, $taxes, $rates)
 {
        begin_transaction();    
-               
-       $sql = "UPDATE ".TB_PREF."tax_groups SET name='$name',tax_shipping=$tax_shipping WHERE id=$id";
+
+       if($tax_shipping)       // only one tax group for shipping
+         clear_shipping_tax_group();
        
+    $sql = "UPDATE ".TB_PREF."tax_groups SET name=".db_escape($name).",tax_shipping=$tax_shipping WHERE id=$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);       
        
        commit_transaction();                   
 }
@@ -57,12 +76,12 @@ function delete_tax_group($id)
        commit_transaction();
 }
 
-function add_tax_group_items($id, $items, $rates, $included)
+function add_tax_group_items($id, $items, $rates)
 {
        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)
+                       VALUES ($id,  " . $items[$i] . ", " . $rates[$i] .")";
                db_query($sql, "could not add item tax group item");                                    
        }               
 }
@@ -99,7 +118,6 @@ function get_tax_group_items_as_array($id)
                $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;
        }
        
@@ -112,9 +130,9 @@ function get_shipping_tax_group_items()
        $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, ".TB_PREF."tax_groups
-               WHERE tax_groups.tax_shipping=1
-               AND tax_groups.id=tax_group_id
-                       AND ".TB_PREF."tax_types.id=tax_type_id";
+               WHERE " .TB_PREF."tax_groups.tax_shipping=1
+               AND " .TB_PREF."tax_groups.id=tax_group_id
+               AND ".TB_PREF."tax_types.id=tax_type_id";
        return db_query($sql, "could not get shipping tax group items");
 }
 
@@ -133,7 +151,6 @@ function get_shipping_tax_as_array()
                $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;
        }