sales/manage/sales_people.php

   1 <?php
   2
   3 $page_security = 3;
   4 $path_to_root="../..";
   5 include($path_to_root . "/includes/session.inc");
   6
   7 page(_("Sales Persons"));
   8
   9 include($path_to_root . "/includes/ui.inc");
  10
  11 simple_page_mode(true);
  12 //------------------------------------------------------------------------------------------------
  13
  14 if ($Mode=='ADD_ITEM' || $Mode=='UPDATE_ITEM')
  15 {
  16
  17         //initialise no input errors assumed initially before we test
  18         $input_error = 0;
  19
  20         if (strlen($_POST['salesman_name']) == 0)
  21         {
  22                 $input_error = 1;
  23                 display_error(_("The sales person name cannot be empty."));
  24                 set_focus('salesman_name');
  25         }
  26         $pr1 = check_num('provision', 0,100);
  27         if (!$pr1 || !check_num('provision2', 0, 100)) {
  28                 $input_error = 1;
  29                 display_error( _("Salesman provision cannot be less than 0 or more than 100%."));
  30                 set_focus(!$pr1 ? 'provision' : 'provision2');
  31         }
  32         if (!check_num('break_pt', 0)) {
  33                 $input_error = 1;
  34                 display_error( _("Salesman provision breakpoint must be numeric and not less than 0."));
  35                 set_focus('break_pt');
  36         }
  37         if ($input_error != 1)
  38         {
  39         if ($selected_id != -1)
  40         {
  41                 /*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*/
  42
  43                 $sql = "UPDATE ".TB_PREF."salesman SET salesman_name=".db_escape($_POST['salesman_name']) . ",
  44                         salesman_phone=".db_escape($_POST['salesman_phone']) . ",
  45                         salesman_fax=".db_escape($_POST['salesman_fax']) . ",
  46                         salesman_email=".db_escape($_POST['salesman_email']) . ",
  47                         provision=".input_num('provision').",
  48                         break_pt=".input_num('break_pt').",
  49                         provision2=".input_num('provision2')."
  50                         WHERE salesman_code = '$selected_id'";
  51         }
  52         else
  53         {
  54                 /*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 */
  55                 $sql = "INSERT INTO ".TB_PREF."salesman (salesman_name, salesman_phone, salesman_fax, salesman_email,
  56                         provision, break_pt, provision2)
  57                         VALUES (".db_escape($_POST['salesman_name']) . ", "
  58                                   .db_escape($_POST['salesman_phone']) . ", "
  59                                   .db_escape($_POST['salesman_fax']) . ", "
  60                                   .db_escape($_POST['salesman_email']) . ", ".
  61                         input_num('provision').", ".input_num('break_pt').", "
  62                                 .input_num('provision2').")";
  63         }
  64
  65         //run the sql from either of the above possibilites
  66         db_query($sql,"The insert or update of the sales person failed");
  67         if ($selected_id != -1)
  68                         display_notification(_('Selected sales person data have been updated'));
  69                 else
  70                         display_notification(_('New sales person data have been added'));
  71                 $Mode = 'RESET';
  72         }
  73 }
  74 if ($Mode == 'Delete')
  75 {
  76         //the link to delete a selected record was clicked instead of the submit button
  77
  78         // PREVENT DELETES IF DEPENDENT RECORDS IN 'debtors_master'
  79
  80         $sql= "SELECT COUNT(*) FROM ".TB_PREF."cust_branch WHERE salesman='$selected_id'";
  81         $result = db_query($sql,"check failed");
  82         $myrow = db_fetch_row($result);
  83         if ($myrow[0] > 0)
  84         {
  85                 display_error("Cannot delete this sales-person because branches are set up referring to this sales-person - first alter the branches concerned.");
  86         }
  87         else
  88         {
  89                 $sql="DELETE FROM ".TB_PREF."salesman WHERE salesman_code='$selected_id'";
  90                 db_query($sql,"The sales-person could not be deleted");
  91                 display_notification(_('Selected sales person data have been deleted'));
  92         }
  93         $Mode = 'RESET';
  94 }
  95
  96 if ($Mode == 'RESET')
  97 {
  98         $selected_id = -1;
  99         unset($_POST);
 100 }
 101 //------------------------------------------------------------------------------------------------
 102
 103 $sql = "SELECT * FROM ".TB_PREF."salesman";
 104 $result = db_query($sql,"could not get sales persons");
 105
 106 start_form();
 107 start_table("$table_style width=60%");
 108 $th = array(_("Name"), _("Phone"), _("Fax"), _("Email"), _("Provision"), _("Break Pt."), _("Provision")." 2", "", "");
 109 table_header($th);
 110
 111 $k = 0;
 112
 113 while ($myrow = db_fetch($result))
 114 {
 115
 116         alt_table_row_color($k);
 117
 118     label_cell($myrow["salesman_name"]);
 119         label_cell($myrow["salesman_phone"]);
 120         label_cell($myrow["salesman_fax"]);
 121         label_cell($myrow["salesman_email"]);
 122         label_cell(percent_format($myrow["provision"])." %", "nowrap align=right");
 123         amount_cell($myrow["break_pt"]);
 124         label_cell(percent_format($myrow["provision2"])." %", "nowrap align=right");
 125         edit_button_cell("Edit".$myrow["salesman_code"], _("Edit"));
 126         edit_button_cell("Delete".$myrow["salesman_code"], _("Delete"));
 127         end_row();
 128
 129 } //END WHILE LIST LOOP
 130
 131 end_table();
 132 end_form();
 133 echo '<br>';
 134
 135 //------------------------------------------------------------------------------------------------
 136
 137 start_form();
 138
 139 if ($selected_id != -1)
 140 {
 141         if ($Mode == 'Edit') {
 142                 //editing an existing Sales-person
 143                 $sql = "SELECT *  FROM ".TB_PREF."salesman WHERE salesman_code='$selected_id'";
 144
 145                 $result = db_query($sql,"could not get sales person");
 146                 $myrow = db_fetch($result);
 147
 148                 $_POST['salesman_name'] = $myrow["salesman_name"];
 149                 $_POST['salesman_phone'] = $myrow["salesman_phone"];
 150                 $_POST['salesman_fax'] = $myrow["salesman_fax"];
 151                 $_POST['salesman_email'] = $myrow["salesman_email"];
 152                 $_POST['provision'] = percent_format($myrow["provision"]);
 153                 $_POST['break_pt'] = price_format($myrow["break_pt"]);
 154                 $_POST['provision2'] = percent_format($myrow["provision2"]);
 155         }
 156         hidden('selected_id', $selected_id);
 157 } elseif ($Mode != 'ADD_ITEM') {
 158                 $_POST['provision'] = percent_format(0);
 159                 $_POST['break_pt'] = price_format(0);
 160                 $_POST['provision2'] = percent_format(0);
 161 }
 162
 163 start_table("$table_style2 width=60%");
 164
 165 text_row_ex(_("Sales person name:"), 'salesman_name', 30);
 166 text_row_ex(_("Telephone number:"), 'salesman_phone', 20);
 167 text_row_ex(_("Fax number:"), 'salesman_fax', 20);
 168 text_row_ex(_("Email:"), 'salesman_email', 40);
 169 percent_row(_("Provision").':', 'provision');
 170 amount_row(_("Break Pt.:"), 'break_pt');
 171 percent_row(_("Provision")." 2:", 'provision2');
 172 end_table(1);
 173
 174 submit_add_or_update_center($selected_id == -1, '', true);
 175
 176 end_form();
 177
 178 end_page();
 179
 180 ?>