5 include($path_to_root . "/includes/session.inc");
7 page(_("Work Centres"));
9 include($path_to_root . "/manufacturing/includes/manufacturing_db.inc");
11 include($path_to_root . "/includes/ui.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['name']) == 0)
25 display_error(_("The work centre name cannot be empty."));
29 if ($input_error != 1)
32 if ($selected_id != -1)
34 update_work_centre($selected_id, $_POST['name'], $_POST['description']);
35 display_notification(_('Selected work center has been updated'));
39 add_work_centre($_POST['name'], $_POST['description']);
40 display_notification(_('New work center has been added'));
46 //-----------------------------------------------------------------------------------
48 function can_delete($selected_id)
50 $sql= "SELECT COUNT(*) FROM ".TB_PREF."bom WHERE workcentre_added='$selected_id'";
51 $result = db_query($sql, "check can delete work centre");
52 $myrow = db_fetch_row($result);
55 display_error(_("Cannot delete this work centre because BOMs have been created referring to it."));
59 $sql= "SELECT COUNT(*) FROM ".TB_PREF."wo_requirements WHERE workcentre='$selected_id'";
60 $result = db_query($sql, "check can delete work centre");
61 $myrow = db_fetch_row($result);
64 display_error(_("Cannot delete this work centre because work order requirements have been created referring to it."));
72 //-----------------------------------------------------------------------------------
74 if ($Mode == 'Delete')
77 if (can_delete($selected_id))
79 delete_work_centre($selected_id);
80 display_notification(_('Selected work center has been deleted'));
90 //-----------------------------------------------------------------------------------
92 $result = get_all_work_centres();
95 start_table("$table_style width=50%");
96 $th = array(_("Name"), _("description"), "", "");
100 while ($myrow = db_fetch($result))
103 alt_table_row_color($k);
105 label_cell($myrow["name"]);
106 label_cell($myrow["description"]);
107 edit_button_cell("Edit".$myrow['id'], _("Edit"));
108 edit_button_cell("Delete".$myrow['id'], _("Delete"));
115 //-----------------------------------------------------------------------------------
119 start_table($table_style2);
121 if ($selected_id != -1)
123 if ($Mode == 'Edit') {
124 //editing an existing status code
125 $myrow = get_work_centre($selected_id);
127 $_POST['name'] = $myrow["name"];
128 $_POST['description'] = $myrow["description"];
130 hidden('selected_id', $selected_id);
133 text_row_ex(_("Name:"), 'name', 40);
134 text_row_ex(_("Description:"), 'description', 50);
138 submit_add_or_update_center($selected_id == -1, '', true);
142 //------------------------------------------------------------------------------------