X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=purchasing%2Fmanage%2Fsuppliers.php;h=9b657ffdb7375485379e5b3775d996ca05b8373b;hb=8430384235d77fb7f8d8ca894e5efedd04d6bc0b;hp=ecf97311fe0ae6663196eb96eedc7149ec79b72f;hpb=0a81fcfd59871fdf30e1dddcc8af6d223e815f8b;p=fa-stable.git diff --git a/purchasing/manage/suppliers.php b/purchasing/manage/suppliers.php index ecf97311..9b657ffd 100644 --- a/purchasing/manage/suppliers.php +++ b/purchasing/manage/suppliers.php @@ -58,7 +58,9 @@ if (isset($_POST['submit'])) fax=".db_escape($_POST['fax']) . ", gst_no=".db_escape($_POST['gst_no']) . ", email=".db_escape($_POST['email']) . ", + website=".db_escape($_POST['website']) . ", contact=".db_escape($_POST['contact']) . ", + supp_account_no=".db_escape($_POST['supp_account_no']) . ", bank_account=".db_escape($_POST['bank_account']) . ", credit_limit=".db_escape($_POST['credit_limit']) . ", dimension_id=".db_escape($_POST['dimension_id']) . ", @@ -68,6 +70,7 @@ if (isset($_POST['submit'])) payable_account=".db_escape($_POST['payable_account']) . ", purchase_account=".db_escape($_POST['purchase_account']) . ", payment_discount_account=".db_escape($_POST['payment_discount_account']) . ", + notes=".db_escape($_POST['notes']) . ", tax_group_id=".db_escape($_POST['tax_group_id']) . " WHERE supplier_id = '" . $_POST['supplier_id'] . "'"; db_query($sql,"The supplier could not be updated"); @@ -76,9 +79,9 @@ if (isset($_POST['submit'])) else { - $sql = "INSERT INTO ".TB_PREF."suppliers (supp_name, address, supp_address, phone, fax, gst_no, email, - contact, bank_account, credit_limit, dimension_id, dimension2_id, curr_code, - payment_terms, payable_account, purchase_account, payment_discount_account, tax_group_id) + $sql = "INSERT INTO ".TB_PREF."suppliers (supp_name, address, supp_address, phone, 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) VALUES (".db_escape($_POST['supp_name']). ", " .db_escape($_POST['address']) . ", " .db_escape($_POST['supp_address']) . ", " @@ -86,7 +89,9 @@ if (isset($_POST['submit'])) .db_escape($_POST['fax']). ", " .db_escape($_POST['gst_no']). ", " .db_escape($_POST['email']). ", " + .db_escape($_POST['website']). ", " .db_escape($_POST['contact']). ", " + .db_escape($_POST['supp_account_no']). ", " .db_escape($_POST['bank_account']). ", " .db_escape($_POST['credit_limit']). ", " .db_escape($_POST['dimension_id']). ", " @@ -96,6 +101,7 @@ if (isset($_POST['submit'])) .db_escape($_POST['payable_account']). ", " .db_escape($_POST['purchase_account']). ", " .db_escape($_POST['payment_discount_account']). ", " + .db_escape($_POST['notes']). ", " .db_escape($_POST['tax_group_id']). ")"; db_query($sql,"The supplier could not be added"); @@ -166,11 +172,9 @@ else hidden('supplier_id', get_post('supplier_id')); } -br(); -start_table("$table_style2 width=65%", 5); -echo "