5 include($path_to_root . "/includes/session.inc");
7 page(_("Sales Persons"));
9 include($path_to_root . "/includes/ui.inc");
11 if (isset($_GET['selected_id']))
13 $selected_id = strtoupper($_GET['selected_id']);
15 elseif (isset($_POST['selected_id']))
17 $selected_id = strtoupper($_POST['selected_id']);
20 //------------------------------------------------------------------------------------------------
22 if (isset($_POST['ADD_ITEM']) || isset($_POST['UPDATE_ITEM']))
25 //initialise no input errors assumed initially before we test
28 if (strlen($_POST['salesman_name']) == 0)
31 display_error(_("The sales person name cannot be empty."));
34 if ($input_error != 1)
36 if (isset($selected_id))
38 /*selected_id 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*/
40 $sql = "UPDATE ".TB_PREF."salesman SET salesman_name='" . $_POST['salesman_name'] . "',
41 salesman_phone='" . $_POST['salesman_phone'] . "',
42 salesman_fax='" . $_POST['salesman_fax'] . "'
43 salesman_email='" . $_POST['salesman_email'] . "'
44 WHERE salesman_code = '$selected_id'";
48 /*Selected group is null cos no item selected on first time round so must be adding a record must be submitting new entries in the new Sales-person form */
49 $sql = "INSERT INTO ".TB_PREF."salesman (salesman_name, salesman_phone, salesman_fax, salesman_email)
50 VALUES ('" . $_POST['salesman_name'] . "', '" . $_POST['salesman_phone'] . "', '" . $_POST['salesman_fax'] . "', '" . $_POST['salesman_email'] . "')";
53 //run the sql from either of the above possibilites
54 db_query($sql,"The insert or update of the salesperson failed");
56 meta_forward($_SERVER['PHP_SELF']);
59 if (isset($_GET['delete']))
61 //the link to delete a selected record was clicked instead of the submit button
63 // PREVENT DELETES IF DEPENDENT RECORDS IN 'debtors_master'
65 $sql= "SELECT COUNT(*) FROM ".TB_PREF."cust_branch WHERE salesman='$selected_id'";
66 $result = db_query($sql,"check failed");
67 $myrow = db_fetch_row($result);
70 display_error("Cannot delete this sales-person because branches are set up referring to this sales-person - first alter the branches concerned.");
74 $sql="DELETE FROM ".TB_PREF."salesman WHERE salesman_code='$selected_id'";
75 db_query($sql,"The sales-person could not be deleted");
77 meta_forward($_SERVER['PHP_SELF']);
81 //------------------------------------------------------------------------------------------------
83 $sql = "SELECT * FROM ".TB_PREF."salesman";
84 $result = db_query($sql,"could not get sales persons");
86 start_table("$table_style width=40%");
87 $th = array(_("Name"), _("Phone"), _("Fax"), _("Email"), "", "");
92 while ($myrow = db_fetch($result))
95 alt_table_row_color($k);
97 label_cell($myrow["salesman_name"]);
98 label_cell($myrow["salesman_phone"]);
99 label_cell($myrow["salesman_fax"]);
100 label_cell($myrow["salesman_email"]);
101 edit_link_cell(SID . "selected_id=" . $myrow["salesman_code"]);
102 delete_link_cell(SID . "selected_id=" . $myrow["salesman_code"]. "&delete=1");
105 } //END WHILE LIST LOOP
109 //------------------------------------------------------------------------------------------------
111 hyperlink_no_params($_SERVER['PHP_SELF'], _("New Sales Person"));
113 //------------------------------------------------------------------------------------------------
117 if (isset($selected_id))
119 //editing an existing Sales-person
120 $sql = "SELECT * FROM ".TB_PREF."salesman WHERE salesman_code='$selected_id'";
122 $result = db_query($sql,"could not get sales person");
123 $myrow = db_fetch($result);
125 $_POST['salesman_name'] = $myrow["salesman_name"];
126 $_POST['salesman_phone'] = $myrow["salesman_phone"];
127 $_POST['salesman_fax'] = $myrow["salesman_fax"];
128 $_POST['salesman_email'] = $myrow["salesman_email"];
130 hidden('selected_id', $selected_id);
133 start_table("$table_style2 width=40%");
135 text_row_ex(_("Sales person name:"), 'salesman_name', 30);
136 text_row_ex(_("Telephone number:"), 'salesman_phone', 20);
137 text_row_ex(_("Fax number:"), 'salesman_fax', 20);
138 text_row_ex(_("Email:"), 'salesman_email', 40);
142 submit_add_or_update_center(!isset($selected_id));