. ***********************************************************************/ $page_security = 3; $path_to_root="../.."; include($path_to_root . "/includes/session.inc"); page(_("Customer Branches")); include($path_to_root . "/includes/ui.inc"); //----------------------------------------------------------------------------------------------- check_db_has_customers(_("There are no customers defined in the system. Please define a customer to add customer branches.")); check_db_has_sales_people(_("There are no sales people defined in the system. At least one sales person is required before proceeding.")); check_db_has_sales_areas(_("There are no sales areas defined in the system. At least one sales area is required before proceeding.")); check_db_has_shippers(_("There are no shipping companies defined in the system. At least one shipping company is required before proceeding.")); 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'])) { $_POST['customer_id'] = strtoupper($_GET['debtor_no']); } $_POST['branch_code'] = $selected_id; if (isset($_GET['SelectedBranch'])) { $_POST['branch_code'] = strtoupper($_GET['SelectedBranch']); $selected_id = $_GET['SelectedBranch']; } $id = find_submit('Select'); if ($id != -1) { context_return(array('customer_id' => $_POST['customer_id'], 'branch_id' => $id)); // return to sales document } //----------------------------------------------------------------------------------------------- if ($Mode=='ADD_ITEM' || $Mode=='UPDATE_ITEM') { //initialise no input errors assumed initially before we test $input_error = 0; //first off validate inputs sensible 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 ($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 = " . 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, 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"); display_notification($note); $Mode = 'RESET'; } } elseif ($Mode == 'Delete') { //the link to delete a selected record was clicked instead of the submit button // PREVENT DELETES IF DEPENDENT RECORDS IN 'debtor_trans' $sql= "SELECT COUNT(*) FROM ".TB_PREF."debtor_trans WHERE branch_code=".db_escape($_POST['branch_code'])." AND debtor_no = ".db_escape($_POST['customer_id']); $result = db_query($sql,"could not query debtortrans"); $myrow = db_fetch_row($result); if ($myrow[0] > 0) { display_error(_("Cannot delete this branch because customer transactions have been created to this branch.")); } else { $sql= "SELECT COUNT(*) FROM ".TB_PREF."sales_orders WHERE branch_code=".db_escape($_POST['branch_code'])." AND debtor_no = ".db_escape($_POST['customer_id']); $result = db_query($sql,"could not query sales orders"); $myrow = db_fetch_row($result); if ($myrow[0] > 0) { display_error(_("Cannot delete this branch because sales orders exist for it. Purge old sales orders first.")); } else { $sql="DELETE FROM ".TB_PREF."cust_branch WHERE branch_code=".db_escape($_POST['branch_code'])." AND debtor_no=".db_escape($_POST['customer_id']); db_query($sql,"could not delete branch"); 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 "