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 provision=".$_POST['provision'].",
45 break_pt=".$_POST['break_pt'].",
46 provision2=".$_POST['provision2']."
47 WHERE salesman_code = '$selected_id'";
51 /*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 */
52 $sql = "INSERT INTO ".TB_PREF."salesman (salesman_name, salesman_phone, salesman_fax, salesman_email,
53 provision, break_pt, provision2)
54 VALUES ('" . $_POST['salesman_name'] . "', '" . $_POST['salesman_phone'] . "', '" . $_POST['salesman_fax'] . "', '" . $_POST['salesman_email'] . "', ".
55 $_POST['provision'].", ".$_POST['break_pt'].", ".$_POST['provision2'].")";
58 //run the sql from either of the above possibilites
59 db_query($sql,"The insert or update of the salesperson failed");
61 meta_forward($_SERVER['PHP_SELF']);
64 if (isset($_GET['delete']))
66 //the link to delete a selected record was clicked instead of the submit button
68 // PREVENT DELETES IF DEPENDENT RECORDS IN 'debtors_master'
70 $sql= "SELECT COUNT(*) FROM ".TB_PREF."cust_branch WHERE salesman='$selected_id'";
71 $result = db_query($sql,"check failed");
72 $myrow = db_fetch_row($result);
75 display_error("Cannot delete this sales-person because branches are set up referring to this sales-person - first alter the branches concerned.");
79 $sql="DELETE FROM ".TB_PREF."salesman WHERE salesman_code='$selected_id'";
80 db_query($sql,"The sales-person could not be deleted");
82 meta_forward($_SERVER['PHP_SELF']);
86 //------------------------------------------------------------------------------------------------
88 $sql = "SELECT * FROM ".TB_PREF."salesman";
89 $result = db_query($sql,"could not get sales persons");
91 start_table("$table_style width=60%");
92 $th = array(_("Name"), _("Phone"), _("Fax"), _("Email"), _("Provision"), _("Break Pt."), _("Provision")." 2", "", "");
97 while ($myrow = db_fetch($result))
100 alt_table_row_color($k);
102 label_cell($myrow["salesman_name"]);
103 label_cell($myrow["salesman_phone"]);
104 label_cell($myrow["salesman_fax"]);
105 label_cell($myrow["salesman_email"]);
106 percent_cell($myrow["provision"]);
107 amount_cell($myrow["break_pt"]);
108 percent_cell($myrow["provision2"]);
109 edit_link_cell(SID . "selected_id=" . $myrow["salesman_code"]);
110 delete_link_cell(SID . "selected_id=" . $myrow["salesman_code"]. "&delete=1");
113 } //END WHILE LIST LOOP
117 //------------------------------------------------------------------------------------------------
119 hyperlink_no_params($_SERVER['PHP_SELF'], _("New Sales Person"));
121 //------------------------------------------------------------------------------------------------
125 if (isset($selected_id))
127 //editing an existing Sales-person
128 $sql = "SELECT * FROM ".TB_PREF."salesman WHERE salesman_code='$selected_id'";
130 $result = db_query($sql,"could not get sales person");
131 $myrow = db_fetch($result);
133 $_POST['salesman_name'] = $myrow["salesman_name"];
134 $_POST['salesman_phone'] = $myrow["salesman_phone"];
135 $_POST['salesman_fax'] = $myrow["salesman_fax"];
136 $_POST['salesman_email'] = $myrow["salesman_email"];
137 $_POST['provision'] = $myrow["provision"];
138 $_POST['break_pt'] = $myrow["break_pt"];
139 $_POST['provision2'] = $myrow["provision2"];
141 hidden('selected_id', $selected_id);
144 start_table("$table_style2 width=60%");
146 text_row_ex(_("Sales person name:"), 'salesman_name', 30);
147 text_row_ex(_("Telephone number:"), 'salesman_phone', 20);
148 text_row_ex(_("Fax number:"), 'salesman_fax', 20);
149 text_row_ex(_("Email:"), 'salesman_email', 40);
150 percent_row(_("Provision"), 'provision');
151 amount_row(_("Break Pt.:"), 'break_pt');
152 percent_row(_("Provision")." 2", 'provision2');
155 submit_add_or_update_center(!isset($selected_id));