inventory/manage/movement_types.php

   1 <?php
   2
   3 $page_security = 3;
   4 $path_to_root="../..";
   5 include($path_to_root . "/includes/session.inc");
   6
   7 page(_("Inventory Movement Types"));
   8
   9 include_once($path_to_root . "/inventory/includes/inventory_db.inc");
  10
  11 include_once($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 inventory movement type name cannot be empty."));
  26                 set_focus('name');
  27         }
  28
  29         if ($input_error != 1)
  30         {
  31         if ($selected_id != -1)
  32         {
  33                 update_movement_type($selected_id, $_POST['name']);
  34                         display_notification(_('Selected movement type has been updated'));
  35         }
  36         else
  37         {
  38                 add_movement_type($_POST['name']);
  39                         display_notification(_('New movement type has been added'));
  40         }
  41
  42                 $Mode = 'RESET';
  43         }
  44 }
  45
  46 //-----------------------------------------------------------------------------------
  47
  48 function can_delete($selected_id)
  49 {
  50         $sql= "SELECT COUNT(*) FROM ".TB_PREF."stock_moves
  51                 WHERE type=" . systypes::inventory_adjustment(). " AND person_id=$selected_id";
  52         $result = db_query($sql, "could not query stock moves");
  53         $myrow = db_fetch_row($result);
  54         if ($myrow[0] > 0)
  55         {
  56                 display_error(_("Cannot delete this inventory movement type because item transactions have been created referring to it."));
  57                 return false;
  58         }
  59
  60         return true;
  61 }
  62
  63
  64 //-----------------------------------------------------------------------------------
  65
  66 if ($Mode == 'Delete')
  67 {
  68         if (can_delete($selected_id))
  69         {
  70                 delete_movement_type($selected_id);
  71                 display_notification(_('Selected movement type has been deleted'));
  72         }
  73         $Mode = 'RESET';
  74 }
  75
  76 if ($Mode == 'RESET')
  77 {
  78         $selected_id = -1;
  79         unset($_POST);
  80 }
  81 //-----------------------------------------------------------------------------------
  82
  83 $result = get_all_movement_type();
  84
  85 start_form();
  86 start_table("$table_style width=30%");
  87
  88 $th = array(_("Description"), "", "");
  89 table_header($th);
  90 $k = 0;
  91 while ($myrow = db_fetch($result))
  92 {
  93
  94         alt_table_row_color($k);
  95
  96         label_cell($myrow["name"]);
  97         edit_button_cell("Edit".$myrow['id'], _("Edit"));
  98         edit_button_cell("Delete".$myrow['id'], _("Delete"));
  99         end_row();
 100 }
 101
 102 end_table();
 103 end_form();
 104 echo '<br>';
 105
 106 //-----------------------------------------------------------------------------------
 107
 108 start_form();
 109
 110 start_table();
 111
 112 if ($selected_id != -1)
 113 {
 114         if ($Mode == 'Edit') {
 115                 //editing an existing status code
 116
 117                 $myrow = get_movement_type($selected_id);
 118
 119                 $_POST['name']  = $myrow["name"];
 120         }
 121         hidden('selected_id', $selected_id);
 122 }
 123
 124 text_row(_("Description:"), 'name', null, 50, 50);
 125
 126 end_table(1);
 127
 128 submit_add_or_update_center($selected_id == -1, '', true);
 129
 130 end_form();
 131
 132 //------------------------------------------------------------------------------------
 133
 134 end_page();
 135
 136 ?>