See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
***********************************************************************/
-function add_supplier($supp_name, $supp_ref, $address, $supp_address, $phone, $phone2, $fax, $gst_no, $email,
- $website, $contact, $supp_account_no, $bank_account, $credit_limit, $dimension_id, $dimension2_id,
+function add_supplier($supp_name, $supp_ref, $address, $supp_address, $gst_no,
+ $website, $supp_account_no, $bank_account, $credit_limit, $dimension_id, $dimension2_id,
$curr_code, $payment_terms, $payable_account, $purchase_account, $payment_discount_account,
- $notes, $tax_group_id, $rep_lang)
+ $notes, $tax_group_id)
{
- $sql = "INSERT INTO ".TB_PREF."suppliers (supp_name, supp_ref, address, supp_address, phone, phone2, fax, gst_no, email, website,
- contact, supp_account_no, bank_account, credit_limit, dimension_id, dimension2_id, curr_code,
- payment_terms, payable_account, purchase_account, payment_discount_account, notes, tax_group_id, rep_lang)
+ $sql = "INSERT INTO ".TB_PREF."suppliers (supp_name, supp_ref, address, supp_address, gst_no, website,
+ supp_account_no, bank_account, credit_limit, dimension_id, dimension2_id, curr_code,
+ payment_terms, payable_account, purchase_account, payment_discount_account, notes, tax_group_id)
VALUES (".db_escape($_POST['supp_name']). ", "
.db_escape($supp_ref). ", "
.db_escape($address) . ", "
.db_escape($supp_address) . ", "
- .db_escape($phone). ", "
- .db_escape($phone2). ", "
- .db_escape($fax). ", "
.db_escape($gst_no). ", "
- .db_escape($email). ", "
.db_escape($website). ", "
- .db_escape($contact). ", "
.db_escape($supp_account_no). ", "
.db_escape($bank_account). ", "
.$credit_limit. ", "
.db_escape($purchase_account). ", "
.db_escape($payment_discount_account). ", "
.db_escape($notes). ", "
- .db_escape($tax_group_id). ", "
- .db_escape($rep_lang ? $rep_lang : null, true). ")";
+ .db_escape($tax_group_id). ")";
db_query($sql,"The supplier could not be added");
}
-function update_supplier($supplier_id, $supp_name, $supp_ref, $address, $supp_address, $phone, $phone2, $fax, $gst_no,
- $email, $website, $contact, $supp_account_no, $bank_account, $credit_limit, $dimension_id, $dimension2_id,
+function update_supplier($supplier_id, $supp_name, $supp_ref, $address, $supp_address, $gst_no,
+ $website, $supp_account_no, $bank_account, $credit_limit, $dimension_id, $dimension2_id,
$curr_code, $payment_terms, $payable_account, $purchase_account, $payment_discount_account,
- $notes, $tax_group_id, $rep_lang)
+ $notes, $tax_group_id)
{
$sql = "UPDATE ".TB_PREF."suppliers SET supp_name=".db_escape($supp_name) . ",
supp_ref=".db_escape($supp_ref) . ",
address=".db_escape($address) . ",
supp_address=".db_escape($supp_address) . ",
- phone=".db_escape($phone) . ",
- phone2=".db_escape($phone2) . ",
- fax=".db_escape($fax) . ",
gst_no=".db_escape($gst_no) . ",
- email=".db_escape($email) . ",
website=".db_escape($website) . ",
- contact=".db_escape($contact) . ",
supp_account_no=".db_escape($supp_account_no) . ",
bank_account=".db_escape($bank_account) . ",
credit_limit=".$credit_limit . ",
purchase_account=".db_escape($purchase_account) . ",
payment_discount_account=".db_escape($payment_discount_account) . ",
notes=".db_escape($notes) . ",
- tax_group_id=".db_escape($tax_group_id) . ",
- rep_lang=".db_escape($rep_lang ? $rep_lang : null, true) . " WHERE supplier_id = ".db_escape($supplier_id);
+ tax_group_id=".db_escape($tax_group_id)
+ ." WHERE supplier_id = ".db_escape($supplier_id);
db_query($sql,"The supplier could not be updated");
}
return db_fetch($result);
}
+function get_supplier_contacts($supplier_id, $action=null)
+{
+ $results = array();
+ $res = get_crm_persons('supplier', $action, $supplier_id);
+ while($contact = db_fetch($res))
+ $results[] = $contact;
+
+ return $results;
+}
?>
\ No newline at end of file