X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=manufacturing%2Fmanage%2Fwork_centres.php;h=852c417c6f9c50447e81cb22031e0fb04d17f016;hb=66cfb670d9261ad0364a91822dc0766de1620799;hp=865fecd818e7dcfeb94da58583b5ec2ba6f2beec;hpb=da8311619dd73feae101d246a1957b972e00cbd2;p=fa-stable.git diff --git a/manufacturing/manage/work_centres.php b/manufacturing/manage/work_centres.php index 865fecd8..852c417c 100644 --- a/manufacturing/manage/work_centres.php +++ b/manufacturing/manage/work_centres.php @@ -1,27 +1,28 @@ . +***********************************************************************/ +$page_security = 'SA_WORKCENTRES'; +$path_to_root = "../.."; include($path_to_root . "/includes/session.inc"); -page(_("Work Centres")); +page(_($help_context = "Work Centres")); include($path_to_root . "/manufacturing/includes/manufacturing_db.inc"); include($path_to_root . "/includes/ui.inc"); -if (isset($_GET['selected_id'])) -{ - $selected_id = $_GET['selected_id']; -} -elseif(isset($_POST['selected_id'])) -{ - $selected_id = $_POST['selected_id']; -} - +simple_page_mode(true); //----------------------------------------------------------------------------------- -if (isset($_POST['ADD_ITEM']) || isset($_POST['UPDATE_ITEM'])) +if ($Mode=='ADD_ITEM' || $Mode=='UPDATE_ITEM') { //initialise no input errors assumed initially before we test @@ -31,23 +32,23 @@ if (isset($_POST['ADD_ITEM']) || isset($_POST['UPDATE_ITEM'])) { $input_error = 1; display_error(_("The work centre name cannot be empty.")); + set_focus('name'); } if ($input_error != 1) { - if (isset($selected_id)) + if ($selected_id != -1) { - update_work_centre($selected_id, $_POST['name'], $_POST['description']); - + display_notification(_('Selected work center has been updated')); } else { - add_work_centre($_POST['name'], $_POST['description']); + display_notification(_('New work center has been added')); } - meta_forward($_SERVER['PHP_SELF']); + $Mode = 'RESET'; } } @@ -55,19 +56,13 @@ if (isset($_POST['ADD_ITEM']) || isset($_POST['UPDATE_ITEM'])) function can_delete($selected_id) { - $sql= "SELECT COUNT(*) FROM ".TB_PREF."bom WHERE workcentre_added='$selected_id'"; - $result = db_query($sql, "check can delete work centre"); - $myrow = db_fetch_row($result); - if ($myrow[0] > 0) + if (key_in_foreign_table($selected_id, 'bom', 'workcentre_added')) { display_error(_("Cannot delete this work centre because BOMs have been created referring to it.")); return false; } - - $sql= "SELECT COUNT(*) FROM ".TB_PREF."wo_requirements WHERE workcentre='$selected_id'"; - $result = db_query($sql, "check can delete work centre"); - $myrow = db_fetch_row($result); - if ($myrow[0] > 0) + + if (key_in_foreign_table($selected_id, 'wo_requirements', 'workcentre')) { display_error(_("Cannot delete this work centre because work order requirements have been created referring to it.")); return false; @@ -79,22 +74,32 @@ function can_delete($selected_id) //----------------------------------------------------------------------------------- -if (isset($_GET['delete'])) +if ($Mode == 'Delete') { if (can_delete($selected_id)) { delete_work_centre($selected_id); - meta_forward($_SERVER['PHP_SELF']); + display_notification(_('Selected work center has been deleted')); } + $Mode = 'RESET'; } +if ($Mode == 'RESET') +{ + $selected_id = -1; + $sav = get_post('show_inactive'); + unset($_POST); + $_POST['show_inactive'] = $sav; +} //----------------------------------------------------------------------------------- -$result = get_all_work_centres(); +$result = get_all_work_centres(check_value('show_inactive')); -start_table("$table_style width=50%"); +start_form(); +start_table(TABLESTYLE, "width='50%'"); $th = array(_("Name"), _("description"), "", ""); +inactive_control_column($th); table_header($th); $k = 0; @@ -105,30 +110,27 @@ while ($myrow = db_fetch($result)) label_cell($myrow["name"]); label_cell($myrow["description"]); - edit_link_cell("selected_id=" . $myrow["id"]); - delete_link_cell("selected_id=" . $myrow["id"]. "&delete=1"); + inactive_control_cell($myrow["id"], $myrow["inactive"], 'workcentres', 'id'); + edit_button_cell("Edit".$myrow['id'], _("Edit")); + delete_button_cell("Delete".$myrow['id'], _("Delete")); end_row(); } -end_table(); - +inactive_control_row($th); +end_table(1); //----------------------------------------------------------------------------------- -hyperlink_no_params($_SERVER['PHP_SELF'], _("New Work Centre")); - -start_form(); - -start_table($table_style2); +start_table(TABLESTYLE2); -if (isset($selected_id)) +if ($selected_id != -1) { - //editing an existing status code - - $myrow = get_work_centre($selected_id); - - $_POST['name'] = $myrow["name"]; - $_POST['description'] = $myrow["description"]; - + if ($Mode == 'Edit') { + //editing an existing status code + $myrow = get_work_centre($selected_id); + + $_POST['name'] = $myrow["name"]; + $_POST['description'] = $myrow["description"]; + } hidden('selected_id', $selected_id); } @@ -137,7 +139,7 @@ text_row_ex(_("Description:"), 'description', 50); end_table(1); -submit_add_or_update_center(!isset($selected_id)); +submit_add_or_update_center($selected_id == -1, '', 'both'); end_form(); @@ -145,4 +147,3 @@ end_form(); end_page(); -?>