X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=admin%2Fdb%2Fcompany_db.inc;h=817b5d19b0c0eec69fc4a2b638a6624202f22ce2;hb=b17df731b4bb055c2fdd568bc4be9e5caa0ee07b;hp=ea99d8722c12e454a01d9b2a48c3816e889054a5;hpb=9d9b1c4d24f7bc0ab4a0706be6e6b2e761c78faf;p=fa-stable.git

diff --git a/admin/db/company_db.inc b/admin/db/company_db.inc
index ea99d872..817b5d19 100644
--- a/admin/db/company_db.inc
+++ b/admin/db/company_db.inc
@@ -1,8 +1,17 @@
 <?php
-
-
-function update_company_gl_setup($debtors_act, $pyt_discount_act, $creditors_act, 
+/**********************************************************************
+    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 update_company_gl_setup($debtors_act, $pyt_discount_act, $creditors_act,
 		$freight_act,
+		$exchange_diff_act,
 		$default_sales_act,
 		$default_sales_discount_act,
 		$default_prompt_payment_act,
@@ -23,6 +32,7 @@ function update_company_gl_setup($debtors_act, $pyt_discount_act, $creditors_act
 		debtors_act=".db_escape($debtors_act).", pyt_discount_act=".db_escape($pyt_discount_act).",
 		creditors_act=".db_escape($creditors_act).",
 		freight_act=".db_escape($freight_act).",
+		exchange_diff_act=".db_escape($exchange_diff_act).",
 		default_sales_act=".db_escape($default_sales_act).",
 		default_sales_discount_act=".db_escape($default_sales_discount_act).",
 		default_prompt_payment_act=".db_escape($default_prompt_payment_act).",
@@ -78,9 +88,10 @@ function update_company_setup($coy_name, $coy_no, $gst_no, $tax_prd, $tax_last,
 	db_query($sql, "The company setup could not be updated ");
 }
 
-function get_company_prefs()
+function get_company_prefs($tbpref = TB_PREF)
 {
-	$sql = "SELECT * FROM ".TB_PREF."company WHERE coy_code=1";
+	$sql = "SELECT * FROM ".$tbpref."company WHERE coy_code=1";
+	
 	$result = db_query($sql, "The company preferences could not be retrieved");
 
 	if (db_num_rows($result) == 0)
@@ -89,9 +100,9 @@ function get_company_prefs()
 	return db_fetch($result);
 }
 
-function get_company_pref($pref_name)
+function get_company_pref($pref_name, $tbpref = TB_PREF)
 {
-	$prefs = get_company_prefs();
+	$prefs = get_company_prefs($tbpref);
 	return $prefs[$pref_name];
 }
 
@@ -156,7 +167,7 @@ function delete_fiscalyear($id)
 function get_base_sales_type()
 {
 	$sql = "SELECT base_sales FROM ".TB_PREF."company WHERE coy_code=1";
-	
+
 	$result = db_query($sql, "could not get base sales type");
 	$myrow = db_fetch($result);
 	return $myrow[0];