if (!($rs = $db->execute($q))) {
force_page('core', 'error&error_msg=MySQL Error: ' . $db->ErrorMsg() . '&menu=1&type=database');
exit;
}
$tech = $rs->GetMenu2('assign_val', $login, $login_id);
$smarty->assign('tech', $tech);
if (!($single_work_order = display_single_open_workorder($db, $VAR['wo_id']))) {
force_page('core', "error&menu=1&error_msg=The Work Order you requested was not found&type=error");
exit;
}
$smarty->assign('single_workorder_array', $single_work_order);
$smarty->assign('work_order_notes', display_workorder_notes($db, $VAR['wo_id']));
$smarty->assign('order', display_parts($db, $VAR['wo_id']));
$smarty->assign('work_order_status', display_workorder_status($db, $VAR['wo_id']));
$smarty->assign('work_order_sched', get_work_order_schedule($db, $VAR['wo_id']));
$smarty->assign('resolution', display_resolution($db, $VAR['wo_id']));
if (isset($VAR['submit'])) {
$sql = "DELETE FROM " . PRFX . "TABLE_WORK_ORDER WHERE WORK_ORDER_ID=" . $db->qstr($wo_id);
if (!($result = $db->Execute($sql))) {
force_page('core', 'error&error_msg=MySQL Error: ' . $db->ErrorMsg() . '&menu=1&type=database');
exit;
}
//Write comment to log
$month = date("M");
$day = date("d");
$year = date("Y");
$time = date("H") . ":" . date("i") . ":" . date("s");
//get environment variables
$hostname = gethostbyaddr($_SERVER['REMOTE_ADDR']);
// Create entry
$data = "Workorder " . $wo_id . " has been deleted ," . $login . "," . $hostname . "," . $month . "-" . $day . "-" . $year . "," . $time . ",\n";
if (!($single_work_order = display_single_open_workorder($db, $VAR['wo_id']))) {
force_page('core', "error&menu=1&error_msg=The Work Order you Requested was not found&type=error");
exit;
} else {
/* get company Information */
$q = "SELECT * FROM " . PRFX . "TABLE_COMPANY";
$rs = $db->execute($q);
$company = $rs->GetArray();
/* Work order notes */
$work_order_notes = display_workorder_notes($db, $VAR['wo_id']);
/* work order Status */
$work_order_status = display_workorder_status($db, $VAR['wo_id']);
/* work order schedule */
$work_order_sched = get_work_order_schedule($db, $VAR['wo_id']);
/* work order resolution */
$work_order_res = display_resolution($db, $VAR['wo_id']);
}
/* get printing options */
$q = "SELECT HTML_PRINT, PDF_PRINT FROM " . PRFX . "SETUP";
$rs = $db->execute($q);
$html_print = $rs->fields['HTML_PRINT'];
$pdf_print = $rs->fields['PDF_PRINT'];
if ($html_print == 1) {
/* htm print page */
$smarty->assign('company', $company);
$smarty->assign('single_workorder_array', $single_work_order);
$smarty->assign('work_order_notes', $work_order_notes);
$smarty->assign('work_order_status', $work_order_status);
$smarty->assign('work_order_sched', $work_order_sched);
$smarty->assign('work_order_res', $work_order_res);
$smarty->display('workorder/print.tpl');
