.
***********************************************************************/
$page_security = 10;
$path_to_root="..";
include_once($path_to_root . "/includes/session.inc");
include_once($path_to_root . "/includes/date_functions.inc");
include_once($path_to_root . "/includes/manufacturing.inc");
include_once($path_to_root . "/includes/data_checks.inc");
include_once($path_to_root . "/manufacturing/includes/manufacturing_db.inc");
include_once($path_to_root . "/manufacturing/includes/manufacturing_ui.inc");
$js = "";
if ($use_date_picker)
$js .= get_js_date_picker();
page(_("Work Order Entry"), false, false, "", $js);
check_db_has_manufacturable_items(_("There are no manufacturable items defined in the system."));
check_db_has_locations(("There are no inventory locations defined in the system."));
//---------------------------------------------------------------------------------------
if (isset($_GET['trans_no']))
{
$selected_id = $_GET['trans_no'];
}
elseif(isset($_POST['selected_id']))
{
$selected_id = $_POST['selected_id'];
}
//---------------------------------------------------------------------------------------
if (isset($_GET['AddedID']))
{
$id = $_GET['AddedID'];
display_notification_centered(_("The work order been added."));
safe_exit();
}
//---------------------------------------------------------------------------------------
if (isset($_GET['UpdatedID']))
{
$id = $_GET['UpdatedID'];
display_notification_centered(_("The work order been updated."));
safe_exit();
}
//---------------------------------------------------------------------------------------
if (isset($_GET['DeletedID']))
{
$id = $_GET['DeletedID'];
display_notification_centered(_("Work order has been deleted."));
safe_exit();
}
//---------------------------------------------------------------------------------------
if (isset($_GET['ClosedID']))
{
$id = $_GET['ClosedID'];
display_notification_centered(_("This work order has been closed. There can be no more issues against it.") . " #$id");
safe_exit();
}
//---------------------------------------------------------------------------------------
function safe_exit()
{
global $path_to_root;
hyperlink_no_params("", _("Enter a new work order"));
hyperlink_no_params("search_work_orders.php", _("Select an existing work order"));
echo "
";
end_form();
end_page();
exit;
}
//-------------------------------------------------------------------------------------
if (!isset($_POST['date_']))
{
$_POST['date_'] = new_doc_date();
if (!is_date_in_fiscalyear($_POST['date_']))
$_POST['date_'] = end_fiscalyear();
}
function can_process()
{
global $selected_id;
if (!isset($selected_id))
{
if (!references::is_valid($_POST['wo_ref']))
{
display_error(_("You must enter a reference."));
set_focus('wo_ref');
return false;
}
if (!is_new_reference($_POST['wo_ref'], systypes::work_order()))
{
display_error(_("The entered reference is already in use."));
set_focus('wo_ref');
return false;
}
}
if (!check_num('quantity', 0))
{
display_error( _("The quantity entered is invalid or less than zero."));
set_focus('quantity');
return false;
}
if (!is_date($_POST['date_']))
{
display_error( _("The date entered is in an invalid format."));
set_focus('date_');
return false;
}
elseif (!is_date_in_fiscalyear($_POST['date_']))
{
display_error(_("The entered date is not in fiscal year."));
set_focus('date_');
return false;
}
// only check bom and quantites if quick assembly
if (!($_POST['type'] == wo_types::advanced()))
{
if (!has_bom($_POST['stock_id']))
{
display_error(_("The selected item to manufacture does not have a bom."));
set_focus('stock_id');
return false;
}
if ($_POST['Costs'] == "")
$_POST['Costs'] = price_format(0);
if (!check_num('Costs', 0))
{
display_error( _("The cost entered is invalid or less than zero."));
set_focus('Costs');
return false;
}
if (!sys_prefs::allow_negative_stock())
{
if ($_POST['type'] == wo_types::assemble())
{
// check bom if assembling
$result = get_bom($_POST['stock_id']);
while ($bom_item = db_fetch($result))
{
if (has_stock_holding($bom_item["ResourceType"]))
{
$quantity = $bom_item["quantity"] * input_num('quantity');
$qoh = get_qoh_on_date($bom_item["component"], $bom_item["loc_code"], $_POST['date_']);
if (-$quantity + $qoh < 0)
{
display_error(_("The work order cannot be processed because there is an insufficient quantity for component:") .
" " . $bom_item["component"] . " - " . $bom_item["description"] . ". " . _("Location:") . " " . $bom_item["location_name"]);
set_focus('quantity');
return false;
}
}
}
}
elseif ($_POST['type'] == wo_types::unassemble())
{
// if unassembling, check item to unassemble
$qoh = get_qoh_on_date($_POST['stock_id'], $_POST['StockLocation'], $_POST['date_']);
if (-input_num('quantity') + $qoh < 0)
{
display_error(_("The selected item cannot be unassembled because there is insufficient stock."));
return false;
}
}
}
}
else
{
if (!is_date($_POST['RequDate']))
{
set_focus('RequDate');
display_error( _("The date entered is in an invalid format."));
return false;
}
//elseif (!is_date_in_fiscalyear($_POST['RequDate']))
//{
// display_error(_("The entered date is not in fiscal year."));
// return false;
//}
if (isset($selected_id))
{
$myrow = get_work_order($selected_id, true);
if ($_POST['units_issued'] > input_num('quantity'))
{
set_focus('quantity');
display_error(_("The quantity cannot be changed to be less than the quantity already manufactured for this order."));
return false;
}
}
}
return true;
}
//-------------------------------------------------------------------------------------
if (isset($_POST['ADD_ITEM']) && can_process())
{
$id = add_work_order($_POST['wo_ref'], $_POST['StockLocation'], input_num('quantity'),
$_POST['stock_id'], $_POST['type'], $_POST['date_'],
$_POST['RequDate'], input_num('Costs'), $_POST['memo_']);
new_doc_date($_POST['date_']);
meta_forward($_SERVER['PHP_SELF'], "AddedID=$id");
}
//-------------------------------------------------------------------------------------
if (isset($_POST['UPDATE_ITEM']) && can_process())
{
update_work_order($selected_id, $_POST['StockLocation'], input_num('quantity'),
$_POST['stock_id'], $_POST['date_'], $_POST['RequDate'], $_POST['memo_']);
new_doc_date($_POST['date_']);
meta_forward($_SERVER['PHP_SELF'], "UpdatedID=$selected_id");
}
//--------------------------------------------------------------------------------------
if (isset($_POST['delete']))
{
//the link to delete a selected record was clicked instead of the submit button
$cancel_delete = false;
// can't delete it there are productions or issues
if (work_order_has_productions($selected_id) ||
work_order_has_issues($selected_id) ||
work_order_has_payments($selected_id))
{
display_error(_("This work order cannot be deleted because it has already been processed."));
$cancel_delete = true;
}
if ($cancel_delete == false)
{ //ie not cancelled the delete as a result of above tests
// delete the actual work order
delete_work_order($selected_id);
meta_forward($_SERVER['PHP_SELF'], "DeletedID=$selected_id");
}
}
//-------------------------------------------------------------------------------------
if (isset($_POST['close']))
{
// update the closed flag in the work order
close_work_order($selected_id);
meta_forward($_SERVER['PHP_SELF'], "ClosedID=$selected_id");
}
//-------------------------------------------------------------------------------------
if (get_post('_type_update'))
{
$Ajax->activate('_page_body');
}
//-------------------------------------------------------------------------------------
start_form();
start_table($table_style2);
$existing_comments = "";
$dec = 0;
if (isset($selected_id))
{
$myrow = get_work_order($selected_id);
if (strlen($myrow[0]) == 0)
{
echo _("The order number sent is not valid.");
safe_exit();
}
// if it's a closed work order can't edit it
if ($myrow["closed"] == 1)
{
echo "