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."));
33 $pr1 = check_num('provision', 0,100);
34 if (!$pr1 || !check_num('provision2', 0, 100)) {
36 display_error( _("Salesman provision cannot be less than 0 or more than 100%."));
37 set_focus(!$pr1 ? 'provision' : 'provision2');
39 if (!check_num('break_pt', 0)) {
41 display_error( _("Salesman provision breakpoint must be numeric and not less than 0."));
42 set_focus('break_pt');
44 if ($input_error != 1)
46 if (isset($selected_id))
48 /*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*/
50 $sql = "UPDATE ".TB_PREF."salesman SET salesman_name=".db_escape($_POST['salesman_name']) . ",
51 salesman_phone=".db_escape($_POST['salesman_phone']) . ",
52 salesman_fax=".db_escape($_POST['salesman_fax']) . ",
53 salesman_email=".db_escape($_POST['salesman_email']) . ",
54 provision=".input_num('provision').",
55 break_pt=".input_num('break_pt').",
56 provision2=".input_num('provision2')."
57 WHERE salesman_code = '$selected_id'";
61 /*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 */
62 $sql = "INSERT INTO ".TB_PREF."salesman (salesman_name, salesman_phone, salesman_fax, salesman_email,
63 provision, break_pt, provision2)
64 VALUES (".db_escape($_POST['salesman_name']) . ", "
65 .db_escape($_POST['salesman_phone']) . ", "
66 .db_escape($_POST['salesman_fax']) . ", "
67 .db_escape($_POST['salesman_email']) . ", ".
68 input_num('provision').", ".input_num('break_pt').", "
69 .input_num('provision2').")";
72 //run the sql from either of the above possibilites
73 db_query($sql,"The insert or update of the salesperson failed");
75 meta_forward($_SERVER['PHP_SELF']);
78 if (isset($_GET['delete']))
80 //the link to delete a selected record was clicked instead of the submit button
82 // PREVENT DELETES IF DEPENDENT RECORDS IN 'debtors_master'
84 $sql= "SELECT COUNT(*) FROM ".TB_PREF."cust_branch WHERE salesman='$selected_id'";
85 $result = db_query($sql,"check failed");
86 $myrow = db_fetch_row($result);
89 display_error("Cannot delete this sales-person because branches are set up referring to this sales-person - first alter the branches concerned.");
93 $sql="DELETE FROM ".TB_PREF."salesman WHERE salesman_code='$selected_id'";
94 db_query($sql,"The sales-person could not be deleted");
96 meta_forward($_SERVER['PHP_SELF']);
100 //------------------------------------------------------------------------------------------------
102 $sql = "SELECT * FROM ".TB_PREF."salesman";
103 $result = db_query($sql,"could not get sales persons");
105 start_table("$table_style width=60%");
106 $th = array(_("Name"), _("Phone"), _("Fax"), _("Email"), _("Provision"), _("Break Pt."), _("Provision")." 2", "", "");
111 while ($myrow = db_fetch($result))
114 alt_table_row_color($k);
116 label_cell($myrow["salesman_name"]);
117 label_cell($myrow["salesman_phone"]);
118 label_cell($myrow["salesman_fax"]);
119 label_cell($myrow["salesman_email"]);
120 label_cell(percent_format($myrow["provision"])." %", "nowrap align=right");
121 amount_cell($myrow["break_pt"]);
122 label_cell(percent_format($myrow["provision2"])." %", "nowrap align=right");
123 edit_link_cell(SID . "selected_id=" . $myrow["salesman_code"]);
124 delete_link_cell(SID . "selected_id=" . $myrow["salesman_code"]. "&delete=1");
127 } //END WHILE LIST LOOP
131 //------------------------------------------------------------------------------------------------
133 hyperlink_no_params($_SERVER['PHP_SELF'], _("New Sales Person"));
135 //------------------------------------------------------------------------------------------------
139 if (isset($selected_id))
141 //editing an existing Sales-person
142 $sql = "SELECT * FROM ".TB_PREF."salesman WHERE salesman_code='$selected_id'";
144 $result = db_query($sql,"could not get sales person");
145 $myrow = db_fetch($result);
147 $_POST['salesman_name'] = $myrow["salesman_name"];
148 $_POST['salesman_phone'] = $myrow["salesman_phone"];
149 $_POST['salesman_fax'] = $myrow["salesman_fax"];
150 $_POST['salesman_email'] = $myrow["salesman_email"];
151 $_POST['provision'] = percent_format($myrow["provision"]);
152 $_POST['break_pt'] = price_format($myrow["break_pt"]);
153 $_POST['provision2'] = percent_format($myrow["provision2"]);
155 hidden('selected_id', $selected_id);
158 start_table("$table_style2 width=60%");
160 text_row_ex(_("Sales person name:"), 'salesman_name', 30);
161 text_row_ex(_("Telephone number:"), 'salesman_phone', 20);
162 text_row_ex(_("Fax number:"), 'salesman_fax', 20);
163 text_row_ex(_("Email:"), 'salesman_email', 40);
164 percent_row(_("Provision").':', 'provision');
165 amount_row(_("Break Pt.:"), 'break_pt');
166 percent_row(_("Provision")." 2:", 'provision2');
169 submit_add_or_update_center(!isset($selected_id));