Merged changes from stable branch up to 2.3.23.

[fa-stable.git] / sales / includes / db / customers_db.inc

diff --git a/sales/includes/db/customers_db.inc b/sales/includes/db/customers_db.inc
index 71dfb9bd1877274770e34df6f6411e3028bd5bbd..2be25faca6c29c35e20c2f41406a3ac02b7590d5 100644 (file)
--- a/sales/includes/db/customers_db.inc
+++ b/sales/includes/db/customers_db.inc
@@ -24,7 +24,6 @@ function add_customer($CustName, $cust_ref, $address, $tax_id, $curr_code,
                " . db_escape($credit_status) . ", ".db_escape($payment_terms) . ", " . $discount . ", 
                " . $pymt_discount . ", " . $credit_limit 
                 .", ".db_escape($sales_type).", ".db_escape($notes) . ")";
-
        db_query($sql,"The customer could not be added");
 }
 
@@ -187,4 +186,15 @@ function get_customer_by_ref($reference)
        return db_fetch($result);
 }
 
-?>
\ No newline at end of file
+//----------------------------------------------------------------------------------
+
+function get_customer_currency($customer_id)
+{
+    $sql = "SELECT curr_code FROM ".TB_PREF."debtors_master WHERE debtor_no = ".db_escape($customer_id);
+
+       $result = db_query($sql, "Retreive currency of customer $customer_id");
+
+       $myrow=db_fetch_row($result);
+       return $myrow[0];
+}
+