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 if (isset($_GET['selected_id']))
  12 {
  13         $selected_id = strtoupper($_GET['selected_id']);
  14 }
  15 elseif (isset($_POST['selected_id']))
  16 {
  17         $selected_id = strtoupper($_POST['selected_id']);
  18 }
  19
  20 //------------------------------------------------------------------------------------------------
  21
  22 if (isset($_POST['ADD_ITEM']) || isset($_POST['UPDATE_ITEM']))
  23 {
  24
  25         //initialise no input errors assumed initially before we test
  26         $input_error = 0;
  27
  28         if (strlen($_POST['salesman_name']) == 0)
  29         {
  30                 $input_error = 1;
  31                 display_error(_("The sales person name cannot be empty."));
  32         }
  33
  34         if ($input_error != 1)
  35         {
  36         if (isset($selected_id))
  37         {
  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*/
  39
  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=".input_num('provision').",
  45                         break_pt=".input_num('break_pt').",
  46                         provision2=".input_num('provision2')."
  47                         WHERE salesman_code = '$selected_id'";
  48         }
  49         else
  50         {
  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                         input_num('provision').", ".input_num('break_pt').", ".input_num('provision2').")";
  56         }
  57
  58         //run the sql from either of the above possibilites
  59         db_query($sql,"The insert or update of the salesperson failed");
  60
  61                 meta_forward($_SERVER['PHP_SELF']);
  62         }
  63 }
  64 if (isset($_GET['delete']))
  65 {
  66         //the link to delete a selected record was clicked instead of the submit button
  67
  68         // PREVENT DELETES IF DEPENDENT RECORDS IN 'debtors_master'
  69
  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);
  73         if ($myrow[0] > 0)
  74         {
  75                 display_error("Cannot delete this sales-person because branches are set up referring to this sales-person - first alter the branches concerned.");
  76         }
  77         else
  78         {
  79                 $sql="DELETE FROM ".TB_PREF."salesman WHERE salesman_code='$selected_id'";
  80                 db_query($sql,"The sales-person could not be deleted");
  81
  82                 meta_forward($_SERVER['PHP_SELF']);
  83         }
  84 }
  85
  86 //------------------------------------------------------------------------------------------------
  87
  88 $sql = "SELECT * FROM ".TB_PREF."salesman";
  89 $result = db_query($sql,"could not get sales persons");
  90
  91 start_table("$table_style width=60%");
  92 $th = array(_("Name"), _("Phone"), _("Fax"), _("Email"), _("Provision"), _("Break Pt."), _("Provision")." 2", "", "");
  93 table_header($th);
  94
  95 $k = 0;
  96
  97 while ($myrow = db_fetch($result))
  98 {
  99
 100         alt_table_row_color($k);
 101
 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         label_cell(percent_format($myrow["provision"])." %", "nowrap align=right");
 107         amount_cell($myrow["break_pt"]);
 108         label_cell(percent_format($myrow["provision2"])." %", "nowrap align=right");
 109         edit_link_cell(SID . "selected_id=" . $myrow["salesman_code"]);
 110         delete_link_cell(SID . "selected_id=" . $myrow["salesman_code"]. "&delete=1");
 111         end_row();
 112
 113 } //END WHILE LIST LOOP
 114
 115 end_table();
 116
 117 //------------------------------------------------------------------------------------------------
 118
 119 hyperlink_no_params($_SERVER['PHP_SELF'], _("New Sales Person"));
 120
 121 //------------------------------------------------------------------------------------------------
 122
 123 start_form();
 124
 125 if (isset($selected_id))
 126 {
 127         //editing an existing Sales-person
 128         $sql = "SELECT *  FROM ".TB_PREF."salesman WHERE salesman_code='$selected_id'";
 129
 130         $result = db_query($sql,"could not get sales person");
 131         $myrow = db_fetch($result);
 132
 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'] = percent_format($myrow["provision"]);
 138         $_POST['break_pt'] = price_format($myrow["break_pt"]);
 139         $_POST['provision2'] = percent_format($myrow["provision2"]);
 140
 141         hidden('selected_id', $selected_id);
 142 }
 143
 144 start_table("$table_style2 width=60%");
 145
 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');
 153 end_table(1);
 154
 155 submit_add_or_update_center(!isset($selected_id));
 156
 157 end_form();
 158
 159 end_page();
 160
 161 ?>