X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sales%2Fmanage%2Fcustomer_branches.php;h=3dced4dbe5b3ae5bf577542e6e7614b053b3b963;hb=2e181b13aa722a43e78b897404912d6b13a0a937;hp=51c0aa6fa536a3047f3e55ddd1ef216f3f078a7c;hpb=da8311619dd73feae101d246a1957b972e00cbd2;p=fa-stable.git diff --git a/sales/manage/customer_branches.php b/sales/manage/customer_branches.php index 51c0aa6f..3dced4db 100644 --- a/sales/manage/customer_branches.php +++ b/sales/manage/customer_branches.php @@ -1,5 +1,14 @@ . +***********************************************************************/ $page_security = 3; $path_to_root="../.."; include($path_to_root . "/includes/session.inc"); @@ -7,7 +16,6 @@ include($path_to_root . "/includes/session.inc"); page(_("Customer Branches")); include($path_to_root . "/includes/ui.inc"); -include($path_to_root . "/includes/data_checks.inc"); //----------------------------------------------------------------------------------------------- @@ -21,28 +29,31 @@ check_db_has_shippers(_("There are no shipping companies defined in the system. check_db_has_tax_groups(_("There are no tax groups defined in the system. At least one tax group is required before proceeding.")); +simple_page_mode(true); //----------------------------------------------------------------------------------------------- -if (isset($_GET['debtor_no'])) +if (isset($_GET['debtor_no'])) { $_POST['customer_id'] = strtoupper($_GET['debtor_no']); - $_POST['New'] = "1"; } +$_POST['branch_code'] = $selected_id; if (isset($_GET['SelectedBranch'])) { $_POST['branch_code'] = strtoupper($_GET['SelectedBranch']); - unset($_POST['New']); + $selected_id = $_GET['SelectedBranch']; } -if (!isset($_GET['SelectedBranch']) && !isset($_POST['AddUpdate'])) +$id = find_submit('Select'); +if ($id != -1) { - $_POST['New'] = "1"; + context_return(array('customer_id' => $_POST['customer_id'], + 'branch_id' => $id)); // return to sales document } //----------------------------------------------------------------------------------------------- -if (isset($_POST['ADD_ITEM']) || isset($_POST['UPDATE_ITEM'])) +if ($Mode=='ADD_ITEM' || $Mode=='UPDATE_ITEM') { //initialise no input errors assumed initially before we test @@ -50,68 +61,76 @@ if (isset($_POST['ADD_ITEM']) || isset($_POST['UPDATE_ITEM'])) //first off validate inputs sensible - if (strlen($_POST['br_name']) == 0) + if (strlen($_POST['br_name']) == 0) { $input_error = 1; display_error(_("The Branch name cannot be empty.")); + set_focus('br_name'); } - if ($input_error != 1) + if ($input_error != 1) { - //if (!isset($_POST['New'])) - if (isset($_POST['UPDATE_ITEM'])) + if ($selected_id != -1) { /*SelectedBranch could also exist if submit had not been clicked this code would not run in this case cos submit is false of course see the delete code below*/ - $sql = "UPDATE ".TB_PREF."cust_branch SET br_name = '" . $_POST['br_name'] . "', - br_address = '" . $_POST['br_address'] . "', - phone='" . $_POST['phone'] . "', - fax='" . $_POST['fax'] . "', - contact_name='" . $_POST['contact_name'] . "', - salesman= '" . $_POST['salesman'] . "', - area='" . $_POST['area'] . "', - email='" . $_POST['email'] . "', - tax_group_id=" . $_POST['tax_group_id'] . ", - sales_account=" . $_POST['sales_account'] . ", - sales_discount_account=" . $_POST['sales_discount_account'] . ", - receivables_account=" . $_POST['receivables_account'] . ", - payment_discount_account=" . $_POST['payment_discount_account'] . ", - default_location='" . $_POST['default_location'] . "', - br_post_address = '" . $_POST['br_post_address'] . "', - disable_trans=" . $_POST['disable_trans'] . ", - default_ship_via=" . $_POST['default_ship_via'] . " - WHERE branch_code = '" . $_POST['branch_code'] . "' - AND debtor_no='" . $_POST['customer_id']. "'"; - - } + $sql = "UPDATE ".TB_PREF."cust_branch SET br_name = " . db_escape($_POST['br_name']) . ", + br_address = ".db_escape($_POST['br_address']). ", + phone=".db_escape($_POST['phone']). ", + fax=".db_escape($_POST['fax']).", + contact_name=".db_escape($_POST['contact_name']) . ", + salesman= ".db_escape($_POST['salesman']) . ", + area=".db_escape($_POST['area']) . ", + email=".db_escape($_POST['email']) . ", + tax_group_id=".db_escape($_POST['tax_group_id']). ", + sales_account=".db_escape($_POST['sales_account']) . ", + sales_discount_account=".db_escape($_POST['sales_discount_account']) . ", + receivables_account=".db_escape($_POST['receivables_account']) . ", + payment_discount_account=".db_escape($_POST['payment_discount_account']) . ", + default_location=".db_escape($_POST['default_location']) . ", + br_post_address =".db_escape($_POST['br_post_address']) . ", + disable_trans=".db_escape($_POST['disable_trans']) . ", + group_no=".db_escape($_POST['group_no']) . ", + default_ship_via=".db_escape($_POST['default_ship_via']) . " + WHERE branch_code =".db_escape($_POST['branch_code']) . " + AND debtor_no=".db_escape($_POST['customer_id']); + + $note =_('Selected customer branch has been updated'); + } else { /*Selected branch is null cos no item selected on first time round so must be adding a record must be submitting new entries in the new Customer Branches form */ $sql = "INSERT INTO ".TB_PREF."cust_branch (debtor_no, br_name, br_address, salesman, phone, fax, contact_name, area, email, tax_group_id, sales_account, receivables_account, payment_discount_account, sales_discount_account, default_location, - br_post_address, disable_trans, default_ship_via) - VALUES ('" . $_POST['customer_id']. "', '" . $_POST['br_name'] . "', '" . - $_POST['br_address'] . "', '" . $_POST['salesman'] . "', '" . - $_POST['phone'] . "', '" . $_POST['fax'] . "','" . - $_POST['contact_name'] . "', '" . $_POST['area'] . "','" . - $_POST['email'] . "', " . $_POST['tax_group_id'] . ", " . - $_POST['sales_account'] . ", " . - $_POST['receivables_account'] . ", " . - $_POST['payment_discount_account'] . ", " . - $_POST['sales_discount_account'] . ", '" . - $_POST['default_location'] . "', '" . $_POST['br_post_address'] . "'," . $_POST['disable_trans'] . ", " . $_POST['default_ship_via'] . ")"; + br_post_address, disable_trans, group_no, default_ship_via) + VALUES (".db_escape($_POST['customer_id']). ",".db_escape($_POST['br_name']) . ", " + .db_escape($_POST['br_address']) . ", ".db_escape($_POST['salesman']) . ", " + .db_escape($_POST['phone']) . ", ".db_escape($_POST['fax']) . "," + .db_escape($_POST['contact_name']) . ", ".db_escape($_POST['area']) . "," + .db_escape($_POST['email']) . ", ".db_escape($_POST['tax_group_id']) . ", " + .db_escape($_POST['sales_account']) . ", " + .db_escape($_POST['receivables_account']) . ", " + .db_escape($_POST['payment_discount_account']) . ", " + .db_escape($_POST['sales_discount_account']) . ", " + .db_escape($_POST['default_location']) . ", " + .db_escape($_POST['br_post_address']) . "," + .db_escape($_POST['disable_trans']) . ", " + .db_escape($_POST['group_no']) . ", " + .db_escape($_POST['default_ship_via']) . ")"; + + $note = _('New customer branch has been added'); } //run the sql from either of the above possibilites db_query($sql,"The branch record could not be inserted or updated"); - - meta_forward($_SERVER['PHP_SELF'], "debtor_no=" . $_POST['customer_id']); + display_notification($note); + $Mode = 'RESET'; } -} -elseif (isset($_GET['delete'])) +} +elseif ($Mode == 'Delete') { //the link to delete a selected record was clicked instead of the submit button @@ -120,30 +139,39 @@ elseif (isset($_GET['delete'])) $sql= "SELECT COUNT(*) FROM ".TB_PREF."debtor_trans WHERE branch_code='" . $_POST['branch_code']. "' AND debtor_no = '" . $_POST['customer_id']. "'"; $result = db_query($sql,"could not query debtortrans"); $myrow = db_fetch_row($result); - if ($myrow[0] > 0) + if ($myrow[0] > 0) { display_error(_("Cannot delete this branch because customer transactions have been created to this branch.")); - } - else + } + else { $sql= "SELECT COUNT(*) FROM ".TB_PREF."sales_orders WHERE branch_code='" . $_POST['branch_code']. "' AND debtor_no = '" . $_POST['customer_id']. "'"; $result = db_query($sql,"could not query sales orders"); $myrow = db_fetch_row($result); - if ($myrow[0] > 0) + if ($myrow[0] > 0) { display_error(_("Cannot delete this branch because sales orders exist for it. Purge old sales orders first.")); - } - else + } + else { $sql="DELETE FROM ".TB_PREF."cust_branch WHERE branch_code='" . $_POST['branch_code']. "' AND debtor_no='" . $_POST['customer_id']. "'"; db_query($sql,"could not delete branch"); - meta_forward($_SERVER['PHP_SELF'], "debtor_no=" . $_POST['customer_id']); + display_notification(_('Selected customer branch has been deleted')); } } //end ifs to test if the branch can be deleted + $Mode = 'RESET'; } +if ($Mode == 'RESET' || get_post('_customer_id_update')) +{ + $selected_id = -1; + $cust_id = $_POST['customer_id']; + unset($_POST); + $_POST['customer_id'] = $cust_id; + $Ajax->activate('_page_body'); +} start_form(); echo "