inventory/manage/item_categories.php

   1 <?php
   2
   3 $page_security = 11;
   4 $path_to_root="../..";
   5 include($path_to_root . "/includes/session.inc");
   6
   7 page(_("Item Categories"));
   8
   9 include_once($path_to_root . "/includes/ui.inc");
  10
  11 include_once($path_to_root . "/inventory/includes/inventory_db.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['description']) == 0)
  23         {
  24                 $input_error = 1;
  25                 display_error(_("The item category description cannot be empty."));
  26                 set_focus('description');
  27         }
  28
  29         if ($input_error !=1)
  30         {
  31         if ($selected_id != -1)
  32         {
  33                     update_item_category($selected_id, $_POST['description']);
  34                         display_notification(_('Selected item category has been updated'));
  35         }
  36         else
  37         {
  38                     add_item_category($_POST['description']);
  39                         display_notification(_('New item category has been added'));
  40         }
  41                 $Mode = 'RESET';
  42         }
  43 }
  44
  45 //----------------------------------------------------------------------------------
  46
  47 if ($Mode == 'Delete')
  48 {
  49
  50         // PREVENT DELETES IF DEPENDENT RECORDS IN 'stock_master'
  51         $sql= "SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE category_id='$selected_id'";
  52         $result = db_query($sql, "could not query stock master");
  53         $myrow = db_fetch_row($result);
  54         if ($myrow[0] > 0)
  55         {
  56                 display_error(_("Cannot delete this item category because items have been created using this item category."));
  57         }
  58         else
  59         {
  60                 delete_item_category($selected_id);
  61                 display_notification(_('Selected item category has been deleted'));
  62         }
  63         $Mode = 'RESET';
  64 }
  65
  66 if ($Mode == 'RESET')
  67 {
  68         $selected_id = -1;
  69         unset($_POST);
  70 }
  71 //----------------------------------------------------------------------------------
  72
  73 $sql = "SELECT * FROM ".TB_PREF."stock_category";
  74 $result = db_query($sql, "could not get stock categories");
  75
  76 start_form();
  77 start_table("$table_style width=30%");
  78 $th = array(_("Name"), "", "");
  79 table_header($th);
  80 $k = 0; //row colour counter
  81
  82 while ($myrow = db_fetch($result))
  83 {
  84
  85         alt_table_row_color($k);
  86
  87         label_cell($myrow["description"]);
  88         edit_button_cell("Edit".$myrow[0], _("Edit"));
  89         edit_button_cell("Delete".$myrow[0], _("Delete"));
  90         end_row();
  91 }
  92
  93 end_table();
  94 end_form();
  95 echo '<br>';
  96 //----------------------------------------------------------------------------------
  97
  98 start_form();
  99
 100 start_table("class='tablestyle_noborder'");
 101
 102 if ($selected_id != -1)
 103 {
 104         if ($Mode == 'Edit') {
 105                 //editing an existing item category
 106                 $myrow = get_item_category($selected_id);
 107
 108                 $_POST['category_id'] = $myrow["category_id"];
 109                 $_POST['description']  = $myrow["description"];
 110         }
 111         hidden('selected_id', $selected_id);
 112         hidden('category_id');
 113 }
 114
 115 text_row(_("Category Name:"), 'description', null, 30, 30);
 116
 117 end_table(1);
 118
 119 submit_add_or_update_center($selected_id == -1, '', true);
 120
 121 end_form();
 122
 123 end_page();
 124
 125 ?>