manufacturing/manage/work_centres.php

   1 <?php
   2
   3 $page_security = 3;
   4 $path_to_root="../..";
   5 include($path_to_root . "/includes/session.inc");
   6
   7 page(_("Work Centres"));
   8
   9 include($path_to_root . "/manufacturing/includes/manufacturing_db.inc");
  10
  11 include($path_to_root . "/includes/ui.inc");
  12
  13 simple_page_mode(true);
  14 //-----------------------------------------------------------------------------------
  15
  16 if ($Mode=='ADD_ITEM' || $Mode=='UPDATE_ITEM')
  17 {
  18
  19         //initialise no input errors assumed initially before we test
  20         $input_error = 0;
  21
  22         if (strlen($_POST['name']) == 0)
  23         {
  24                 $input_error = 1;
  25                 display_error(_("The work centre name cannot be empty."));
  26                 set_focus('name');
  27         }
  28
  29         if ($input_error != 1)
  30         {
  31
  32         if ($selected_id != -1)
  33         {
  34                 update_work_centre($selected_id, $_POST['name'], $_POST['description']);
  35                         display_notification(_('Selected work center has been updated'));
  36         }
  37         else
  38         {
  39                 add_work_centre($_POST['name'], $_POST['description']);
  40                         display_notification(_('New work center has been added'));
  41         }
  42                 $Mode = 'RESET';
  43         }
  44 }
  45
  46 //-----------------------------------------------------------------------------------
  47
  48 function can_delete($selected_id)
  49 {
  50         $sql= "SELECT COUNT(*) FROM ".TB_PREF."bom WHERE workcentre_added='$selected_id'";
  51         $result = db_query($sql, "check can delete work centre");
  52         $myrow = db_fetch_row($result);
  53         if ($myrow[0] > 0)
  54         {
  55                 display_error(_("Cannot delete this work centre because BOMs have been created referring to it."));
  56                 return false;
  57         }
  58
  59         $sql= "SELECT COUNT(*) FROM ".TB_PREF."wo_requirements WHERE workcentre='$selected_id'";
  60         $result = db_query($sql, "check can delete work centre");
  61         $myrow = db_fetch_row($result);
  62         if ($myrow[0] > 0)
  63         {
  64                 display_error(_("Cannot delete this work centre because work order requirements have been created referring to it."));
  65                 return false;
  66         }
  67
  68         return true;
  69 }
  70
  71
  72 //-----------------------------------------------------------------------------------
  73
  74 if ($Mode == 'Delete')
  75 {
  76
  77         if (can_delete($selected_id))
  78         {
  79                 delete_work_centre($selected_id);
  80                 display_notification(_('Selected work center has been deleted'));
  81         }
  82         $Mode = 'RESET';
  83 }
  84
  85 if ($Mode == 'RESET')
  86 {
  87         $selected_id = -1;
  88         unset($_POST);
  89 }
  90 //-----------------------------------------------------------------------------------
  91
  92 $result = get_all_work_centres();
  93
  94 start_form();
  95 start_table("$table_style width=50%");
  96 $th = array(_("Name"), _("description"), "", "");
  97 table_header($th);
  98
  99 $k = 0;
 100 while ($myrow = db_fetch($result))
 101 {
 102
 103         alt_table_row_color($k);
 104
 105         label_cell($myrow["name"]);
 106         label_cell($myrow["description"]);
 107         edit_button_cell("Edit".$myrow['id'], _("Edit"));
 108         edit_button_cell("Delete".$myrow['id'], _("Delete"));
 109         end_row();
 110 }
 111
 112 end_table();
 113 end_form();
 114 echo '<br>';
 115 //-----------------------------------------------------------------------------------
 116
 117 start_form();
 118
 119 start_table($table_style2);
 120
 121 if ($selected_id != -1)
 122 {
 123         if ($Mode == 'Edit') {
 124                 //editing an existing status code
 125                 $myrow = get_work_centre($selected_id);
 126
 127                 $_POST['name']  = $myrow["name"];
 128                 $_POST['description']  = $myrow["description"];
 129         }
 130         hidden('selected_id', $selected_id);
 131 }
 132
 133 text_row_ex(_("Name:"), 'name', 40);
 134 text_row_ex(_("Description:"), 'description', 50);
 135
 136 end_table(1);
 137
 138 submit_add_or_update_center($selected_id == -1, '', true);
 139
 140 end_form();
 141
 142 //------------------------------------------------------------------------------------
 143
 144 end_page();
 145
 146 ?>