X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;ds=sidebyside;f=manufacturing%2Fsearch_work_orders.php;h=11ebd0c7ca65a988e6ab7e6954b4874a5d76f661;hb=d984052f31e45bfdec6a308dfe189e515f30fd35;hp=386ff583c13ef1e58167b101d27e8a3cd3ff08b0;hpb=d67d5295b9342c011697ce4df325197e29898588;p=fa-stable.git diff --git a/manufacturing/search_work_orders.php b/manufacturing/search_work_orders.php index 386ff583..11ebd0c7 100644 --- a/manufacturing/search_work_orders.php +++ b/manufacturing/search_work_orders.php @@ -9,17 +9,41 @@ include_once($path_to_root . "/manufacturing/includes/manufacturing_ui.inc"); $js = ""; if ($use_popup_windows) $js .= get_js_open_window(800, 500); -if (isset($_GET['outstanding_only'])) +if (isset($_GET['outstanding_only']) && ($_GET['outstanding_only'] == true)) { +// curently outstanding simply means not closed $outstanding_only = 1; page(_("Search Outstanding Work Orders"), false, false, "", $js); -} -else +} +else { $outstanding_only = 0; page(_("Search Work Orders"), false, false, "", $js); } +//----------------------------------------------------------------------------------- +// Ajax updates +// +if (get_post('SearchOrders')) +{ + $Ajax->activate('orders_tbl'); +} elseif (get_post('_OrderNumber_changed')) +{ + $disable = get_post('OrderNumber') !== ''; + + $Ajax->addDisable(true, 'StockLocation', $disable); + $Ajax->addDisable(true, 'OverdueOnly', $disable); + $Ajax->addDisable(true, 'OpenOnly', $disable); + $Ajax->addDisable(true, 'SelectedStockItem', $disable); + if ($disable) { +// $Ajax->addFocus(true, 'OrderNumber'); + set_focus('OrderNumber'); + } else +// $Ajax->addFocus(true, 'StockLocation'); + set_focus('StockLocation'); + + $Ajax->activate('orders_tbl'); +} //-------------------------------------------------------------------------------------- @@ -32,17 +56,18 @@ start_form(false, false, $_SERVER['PHP_SELF'] ."?outstanding_only=" . $outstandi start_table("class='tablestyle_noborder'"); start_row(); -ref_cells(_("Reference:"), 'OrderNumber'); +ref_cells(_("Reference:"), 'OrderNumber', '',null, '', true); locations_list_cells(_("at Location:"), 'StockLocation', null, true); check_cells( _("Only Overdue:"), 'OverdueOnly', null); -check_cells( _("Only Open:"), 'OpenOnly', null); +if ($outstanding_only==0) + check_cells( _("Only Open:"), 'OpenOnly', null); stock_manufactured_items_list_cells(_("for item:"), 'SelectedStockItem', null, true); -submit_cells('SearchOrders', _("Search")); +submit_cells('SearchOrders', _("Search"),'',_('Select documents'), true); end_row(); end_table(); @@ -53,27 +78,27 @@ $sql = "SELECT ".TB_PREF."workorders.*, ".TB_PREF."stock_master.description,".TB WHERE ".TB_PREF."stock_master.stock_id=".TB_PREF."workorders.stock_id AND ".TB_PREF."locations.loc_code=".TB_PREF."workorders.loc_code "; -if (check_value('OpenOnly')) +if (check_value('OpenOnly') || $outstanding_only != 0) { $sql .= " AND ".TB_PREF."workorders.closed=0 "; } -if (isset($_POST['StockLocation']) && $_POST['StockLocation'] != $all_items) +if (isset($_POST['StockLocation']) && $_POST['StockLocation'] != $all_items) { $sql .= "AND ".TB_PREF."workorders.loc_code='" . $_POST['StockLocation'] . "' "; } -if (isset($_POST['OrderNumber']) && $_POST['OrderNumber'] != "") +if (isset($_POST['OrderNumber']) && $_POST['OrderNumber'] != "") { $sql .= "AND ".TB_PREF."workorders.wo_ref LIKE '%". $_POST['OrderNumber'] . "%'"; } -if (isset($_POST['SelectedStockItem']) && $_POST['SelectedStockItem'] != $all_items) +if (isset($_POST['SelectedStockItem']) && $_POST['SelectedStockItem'] != $all_items) { $sql .= "AND ".TB_PREF."workorders.stock_id='". $_POST['SelectedStockItem'] . "'"; } -if (check_value('OverdueOnly')) +if (check_value('OverdueOnly')) { $Today = date2sql(Today()); @@ -83,65 +108,68 @@ $sql .= " ORDER BY ".TB_PREF."workorders.required_by"; $result = db_query($sql,"No orders were returned"); +div_start('orders_tbl'); start_table("$table_style width=80%"); $th = array(_("#"), _("Reference"), _("Type"), _("Location"), _("Item"), - _("Required"), _("Manufactured"), _("Date"), _("Required By"), _("Closed"), ""); + _("Required"), _("Manufactured"), _("Date"), _("Required By"), + '', '', '', '', ''); table_header($th); $j = 1; $k = 0; -while ($myrow = db_fetch($result)) +while ($myrow = db_fetch($result)) { // check if it's an overdue work order - if (!$myrow["closed"] && date_diff(Today(), sql2date($myrow["required_by"]), "d") > 0) + if (!$myrow["closed"] && date_diff(Today(), sql2date($myrow["required_by"]), "d") > 0) { start_row("class='overduebg'"); } else alt_table_row_color($k); - $modify_page = $path_to_root . "/manufacturing/work_order_entry.php?" . SID . "trans_no=" . $myrow["id"]; - $release_page = $path_to_root . "/manufacturing/work_order_release.php?" . SID . "trans_no=" . $myrow["id"]; - if ($myrow["closed"] == 0) - { - $issue = $path_to_root . "/manufacturing/work_order_issue.php?" . SID . "trans_no=" .$myrow["id"]; - $add_finished = $path_to_root . "/manufacturing/work_order_add_finished.php?" . SID . "trans_no=" .$myrow["id"]; - $costs = $path_to_root . "/gl/gl_payment.php?NewPayment=1&PayType=" . payment_person_types::WorkOrder(). "&PayPerson=" .$myrow["id"]; - $can_issue = $myrow["released"]; - $issue_link = $can_issue?("" . _("Issue") . " -