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 if (isset($_GET['selected_id']))
  14 {
  15         $selected_id = $_GET['selected_id'];
  16 }
  17 elseif(isset($_POST['selected_id']))
  18 {
  19         $selected_id = $_POST['selected_id'];
  20 }
  21
  22 //-----------------------------------------------------------------------------------
  23
  24 if (isset($_POST['ADD_ITEM']) || isset($_POST['UPDATE_ITEM']))
  25 {
  26
  27         //initialise no input errors assumed initially before we test
  28         $input_error = 0;
  29
  30         if (strlen($_POST['name']) == 0)
  31         {
  32                 $input_error = 1;
  33                 display_error(_("The inventory movement type name cannot be empty."));
  34         }
  35
  36         if ($input_error != 1)
  37         {
  38
  39         if (isset($selected_id))
  40         {
  41
  42                 update_movement_type($selected_id, $_POST['name']);
  43
  44         }
  45         else
  46         {
  47
  48                 add_movement_type($_POST['name']);
  49         }
  50
  51                 meta_forward($_SERVER['PHP_SELF']);
  52         }
  53 }
  54
  55 //-----------------------------------------------------------------------------------
  56
  57 function can_delete($selected_id)
  58 {
  59         $sql= "SELECT COUNT(*) FROM ".TB_PREF."stock_moves
  60                 WHERE type=" . systypes::inventory_adjustment(). " AND person_id=$selected_id";
  61         $result = db_query($sql, "could not query stock moves");
  62         $myrow = db_fetch_row($result);
  63         if ($myrow[0] > 0)
  64         {
  65                 display_error(_("Cannot delete this inventory movement type because item transactions have been created referring to it."));
  66                 return false;
  67         }
  68
  69         return true;
  70 }
  71
  72
  73 //-----------------------------------------------------------------------------------
  74
  75 if (isset($_GET['delete']))
  76 {
  77
  78         if (can_delete($selected_id))
  79         {
  80                 delete_movement_type($selected_id);
  81                 meta_forward($_SERVER['PHP_SELF']);
  82         }
  83 }
  84
  85 //-----------------------------------------------------------------------------------
  86
  87 $result = get_all_movement_type();
  88
  89 start_table("$table_style width=30%");
  90
  91 $th = array(_("Description"), "", "");
  92 table_header($th);
  93 $k = 0;
  94 while ($myrow = db_fetch($result))
  95 {
  96
  97         alt_table_row_color($k);
  98
  99         label_cell($myrow["name"]);
 100         edit_link_cell("selected_id=" . $myrow["id"]);
 101         delete_link_cell("selected_id=" . $myrow["id"]. "&delete=1");
 102         end_row();
 103 }
 104
 105 end_table();
 106
 107 //-----------------------------------------------------------------------------------
 108
 109 hyperlink_no_params($_SERVER['PHP_SELF'], _("New Inventory Movement Type"));
 110
 111 start_form();
 112
 113 start_table();
 114
 115 if (isset($selected_id))
 116 {
 117         //editing an existing status code
 118
 119         $myrow = get_movement_type($selected_id);
 120
 121         $_POST['name']  = $myrow["name"];
 122
 123         hidden('selected_id', $selected_id);
 124 }
 125
 126 text_row(_("Description:"), 'name', null, 50, 50);
 127
 128 end_table(1);
 129
 130 submit_add_or_update_center(!isset($selected_id));
 131
 132 end_form();
 133
 134 //------------------------------------------------------------------------------------
 135
 136 end_page();
 137
 138 ?>