Multiply contacts spport added.

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

diff --git a/sales/includes/db/cust_trans_db.inc b/sales/includes/db/cust_trans_db.inc
index c9fccf11522d61421f37cfa8943edcf13f52119e..770c73edaac9eb758ce5d856db93b03738f60fd7 100644 (file)
--- a/sales/includes/db/cust_trans_db.inc
+++ b/sales/includes/db/cust_trans_db.inc
@@ -150,7 +150,7 @@ function get_customer_trans($trans_id, $trans_type)
        $sql = "SELECT trans.*,"
                ."ov_amount+ov_gst+ov_freight+ov_freight_tax+ov_discount AS Total,"
                ."cust.name AS DebtorName, cust.address, "
-               ."cust.email AS email2, cust.curr_code, "
+               ."cust.curr_code, "
                ."cust.tax_id ";
 
        if ($trans_type == ST_CUSTPAYMENT) {
@@ -170,8 +170,6 @@ function get_customer_trans($trans_id, $trans_type)
                .TB_PREF."tax_groups.id AS tax_group_id ";
        }
 
-       $sql .= ", IF(ISNULL(branch.rep_lang),cust.rep_lang,branch.rep_lang) AS rep_lang";
-
        $sql .= " FROM ".TB_PREF."debtor_trans trans, ".TB_PREF."debtors_master cust";
 
        if ($trans_type == ST_CUSTPAYMENT) {
@@ -220,7 +218,6 @@ function get_customer_trans($trans_id, $trans_type)
        }
 
        $row = db_fetch($result);
-       $row['email'] = $row['email2'];
        return $row;
 }