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(); // get project details $project_res = $db->select_query("projects", "*", "record_id = {$work_order_data['project_id']}"); $project = $project_res->fetch_assoc(); $html->open_new_window("open_system_link", "https://{$project['system_links']}", "SYSTEM"); $html->open_new_window("go_to_database", "/app/databases/db.php?record_id={$project['database_id']}", "DB VIEWER"); ?>

Actions

submit_btn("submit", "STOP", "mark_as_not_inprogress();stop();"); } elseif ($work_order['status'] == 'stop') { echo $html->submit_btn("submit", "START", "mark_as_inprogress();start();"); echo $html->submit_btn("submit", "SEND FOR REVIEW", 'mark_for_review();send_for_review();'); } elseif ($work_order['status'] == 'complete') { } else { echo $html->submit_btn("submit", "START", "mark_as_inprogress();start()"); } } ?>
input_html("NAME", $work_order_data['name'], "", "", "inputs", "", "", 'text', 'readonly'); ?>
date_input_html("", "", 'inputs', "", $work_order_data['deadline_date_time'], "", 'readonly'); ?>
input_html("", $type['name'], '', '', 'inputs', 'width:auto;', '', '', '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']}"); $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()) { ?>
submit_btn("submit", "SAVE", ""); ?>
html_form_ajax("add_work_order", "UPDATE", "work_orders", '', false, [], '', [], 'date_time,user_id'); $html->html_form_ajax("mark_for_review", "UPDATE", "work_orders", '', false, [], '', [], 'date_time,user_id', "record_id={$_GET['record_id']},sent_for_review=1"); $html->html_form_ajax("mark_as_inprogress", "UPDATE", "work_orders", '', false, [], '', [], 'date_time,user_id', "record_id={$_GET['record_id']},inprogress=1"); $html->html_form_ajax("mark_as_not_inprogress", "UPDATE", "work_orders", '', false, [], '', [], '', "record_id={$_GET['record_id']},inprogress=0"); $html->html_form_ajax("start", "custom_insert", "work_order_timeline", '', false, [], '', [], "record_id", "status=start,work_order_id={$_GET['record_id']},user_id={$_SESSION['user_id']},date_time=$date"); $html->html_form_ajax("stop", "custom_insert", "work_order_timeline", '', false, [], '', [], "record_id", "status=stop,work_order_id={$_GET['record_id']},user_id={$_SESSION['user_id']},date_time=$date"); $html->html_form_ajax("send_for_review", "custom_insert", "work_order_timeline", '', false, [], '', [], "record_id", "status=sent_for_review,work_order_id={$_GET['record_id']},user_id={$_SESSION['user_id']},date_time=$date"); ?>