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
  69         if (can_delete($selected_id))
  70         {
  71                 delete_movement_type($selected_id);
  72                 display_notification(_('Selected movement type has been deleted'));
  73                 $Mode = 'RESET';
  74         }
  75 }
  76
  77 if ($Mode == 'RESET')
  78 {
  79         $selected_id = -1;
  80         unset($_POST);
  81 }
  82 //-----------------------------------------------------------------------------------
  83
  84 $result = get_all_movement_type();
  85
  86 start_form();
  87 start_table("$table_style width=30%");
  88
  89 $th = array(_("Description"), "", "");
  90 table_header($th);
  91 $k = 0;
  92 while ($myrow = db_fetch($result))
  93 {
  94
  95         alt_table_row_color($k);
  96
  97         label_cell($myrow["name"]);
  98         edit_button_cell("Edit".$myrow['id'], _("Edit"));
  99         edit_button_cell("Delete".$myrow['id'], _("Delete"));
 100         end_row();
 101 }
 102
 103 end_table();
 104 end_form();
 105 echo '<br>';
 106
 107 //-----------------------------------------------------------------------------------
 108
 109 start_form();
 110
 111 start_table();
 112
 113 if ($selected_id != -1)
 114 {
 115         if ($Mode == 'Edit') {
 116                 //editing an existing status code
 117
 118                 $myrow = get_movement_type($selected_id);
 119
 120                 $_POST['name']  = $myrow["name"];
 121         }
 122         hidden('selected_id', $selected_id);
 123 }
 124
 125 text_row(_("Description:"), 'name', null, 50, 50);
 126
 127 end_table(1);
 128
 129 submit_add_or_update_center($selected_id == -1, '', true);
 130
 131 end_form();
 132
 133 //------------------------------------------------------------------------------------
 134
 135 end_page();
 136
 137 ?>