5 include($path_to_root . "/includes/session.inc");
7 page(_("Item Categories"));
9 include_once($path_to_root . "/includes/ui.inc");
11 include_once($path_to_root . "/inventory/includes/inventory_db.inc");
13 simple_page_mode(true);
14 //----------------------------------------------------------------------------------
16 if ($Mode=='ADD_ITEM' || $Mode=='UPDATE_ITEM')
19 //initialise no input errors assumed initially before we test
22 if (strlen($_POST['description']) == 0)
25 display_error(_("The item category description cannot be empty."));
26 set_focus('description');
31 if ($selected_id != -1)
33 update_item_category($selected_id, $_POST['description']);
34 display_notification(_('Selected item category has been updated'));
38 add_item_category($_POST['description']);
39 display_notification(_('New item category has been added'));
45 //----------------------------------------------------------------------------------
47 if ($Mode == 'Delete')
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);
56 display_error(_("Cannot delete this item category because items have been created using this item category."));
60 delete_item_category($selected_id);
61 display_notification(_('Selected item category has been deleted'));
71 //----------------------------------------------------------------------------------
73 $sql = "SELECT * FROM ".TB_PREF."stock_category";
74 $result = db_query($sql, "could not get stock categories");
77 start_table("$table_style width=30%");
78 $th = array(_("Name"), "", "");
80 $k = 0; //row colour counter
82 while ($myrow = db_fetch($result))
85 alt_table_row_color($k);
87 label_cell($myrow["description"]);
88 edit_button_cell("Edit".$myrow[0], _("Edit"));
89 edit_button_cell("Delete".$myrow[0], _("Delete"));
96 //----------------------------------------------------------------------------------
100 start_table("class='tablestyle_noborder'");
102 if ($selected_id != -1)
104 if ($Mode == 'Edit') {
105 //editing an existing item category
106 $myrow = get_item_category($selected_id);
108 $_POST['category_id'] = $myrow["category_id"];
109 $_POST['description'] = $myrow["description"];
111 hidden('selected_id', $selected_id);
112 hidden('category_id');
115 text_row(_("Category Name:"), 'description', null, 30, 30);
119 submit_add_or_update_center($selected_id == -1, '', true);