/* Lets Grab Technicians Names */ $q = "SELECT EMPLOYEE_LOGIN, EMPLOYEE_ID FROM " . PRFX . "TABLE_EMPLOYEE WHERE EMPLOYEE_STATUS=1"; 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']);
return $work_order_notes; } ############################# # Display Work Order Status # ############################# function display_workorder_status($db, $wo_id) { $sql = "SELECT " . PRFX . "TABLE_WORK_ORDER_STATUS.*, " . PRFX . "TABLE_EMPLOYEE.EMPLOYEE_DISPLAY_NAME \n\t\t\t\tFROM " . PRFX . "TABLE_WORK_ORDER_STATUS, " . PRFX . "TABLE_EMPLOYEE \n\t\t\t\tWHERE " . PRFX . "TABLE_WORK_ORDER_STATUS.WORK_ORDER_ID=" . $db->qstr($wo_id) . " \n\t\t\t\tAND " . PRFX . "TABLE_EMPLOYEE.EMPLOYEE_ID = " . PRFX . "TABLE_WORK_ORDER_STATUS.WORK_ORDER_STATUS_ENTER_BY ORDER BY " . PRFX . "TABLE_WORK_ORDER_STATUS.WORK_ORDER_STATUS_ID"; if (!($result = $db->Execute($sql))) { force_page('core', 'error&error_msg=MySQL Error: ' . $db->ErrorMsg() . '&menu=1&type=database'); exit; } $work_order_status = $result->GetArray(); return $work_order_status; } $smarty->assign('wo_stat', display_workorder_status($db, $wo_id)); ######################################### # Display Customer Contact Information # ######################################### function display_customer_info($db, $customer_id) { $sql = "SELECT * FROM " . PRFX . "TABLE_CUSTOMER WHERE CUSTOMER_ID=" . $db->qstr($customer_id); if (!($result = $db->Execute($sql))) { force_page('core', 'error&error_msg=MySQL Error: ' . $db->ErrorMsg() . '&menu=1&type=database'); exit; } $customer_array = $result->GetArray(); return $customer_array; } ############################################################# # Display all open Work orders to #
<?php require_once "include.php"; 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);