add_styles_page(); $db = new db_safeguard(); $res = $db->select_query("work_orders", "*", "record_id='" . $_GET['record_id'] . "'"); $work_order_data = $res->fetch_assoc(); $type_res = $db->select_query("work_order_types", "*", "record_id = {$work_order_data['work_order_type_id']}"); $type = $type_res->fetch_assoc(); $work_order_res = $db->select_query("work_order_timeline", "*", "work_order_id = {$_GET['record_id']} ORDER BY record_id DESC LIMIT 1"); $work_order = $work_order_res->fetch_assoc(); $status = new select(); $status->name("status"); $status->id("status"); $status->add_option("", ""); $status->add_option("reopen", "RE OPEN WORK ORDER"); $status->add_option("close", "CLOSE WORK ORDER"); $status->required(); ?>

REVIEW WORK ORDER

select_html_from_db("projects", "record_id", "name", "date_time_finished = '--'", "project_id", "project_id", "select", "", "", "required"); ?> select_from_db_add_current_selected_column('work_orders', 'project_id', "record_id = {$_GET['record_id']}", "project_id"); ?> select_html_from_db("work_order_types", "record_id", "name", "", "work_order_type_id", "work_order_type_id", "select", "", "", "required"); ?> select_from_db_add_current_selected_column('work_orders', 'work_order_type_id', "record_id = {$_GET['record_id']}", "work_order_type_id"); ?> input_html_from_db('work_orders', 'name', " record_id = {$_GET['record_id']}", "", "name", "name", "inputs", "", "", "required"); ?> input_html_from_db('work_orders', 'record_id', " record_id = {$_GET['record_id']}", "", "record_id", "record_id", "inputs", "", "", "hidden"); ?> input_html("", $_SESSION['user_id'], "user_id", "user_id", "inputs", "", "", 'text', "hidden"); ?> select_html_from_db("users", "record_id", "username", "", "user_id_assigned", "user_id_assigned"); ?>

REVIEW USER

select_html_from_db("users", "record_id", "username", "", "user_id_review", "user_id_review"); ?> select_from_db_add_current_selected_column('work_orders', 'user_id_review', "record_id = {$_GET['record_id']}", "user_id_review"); ?> date_input_html_from_db('work_orders', 'deadline_date_time', " record_id = {$_GET['record_id']}", "deadline_date_time", "deadline_date_time"); ?> date_input_html_from_db('work_orders', 'action_date_time', " record_id = {$_GET['record_id']}", "action_date_time", "action_date_time"); ?> select_from_db_add_current_selected_column('work_orders', 'user_id_assigned', "record_id = {$_GET['record_id']}", "user_id_assigned"); ?> date_input_html("date_time_created", "date_time_created", "inputs", "", date('Y-m-d H:i', strtotime("+2 Hours")), "", "readonly"); ?>

RESOURCES

query("work_order_resources", "SELECT * FROM work_order_resources WHERE work_order_id = {$_GET['record_id']}"); $index_res = 1; $call = new call(); while ($resources = $resources_res->fetch_assoc()) { ?>

Resources:





TO DO

query("work_orders_instructions", "SELECT * FROM work_orders_instructions WHERE work_order_id = {$_GET['record_id']}"); $index = 1; $call = new call(); while ($instruction = $instructions_res->fetch_assoc()) { ?>




COMMENTS & LOGS

query("work_order_logs", "SELECT * FROM work_order_logs WHERE work_order_id = {$_GET['record_id']}"); $index = 1; $call = new call(); while ($log = $log_res->fetch_assoc()) { ?>




STATUS"; $status->add(); echo $html->submit_btn("submit", "UPDATE", ""); ?>