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(); ?>

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:100%;', '', '', 'readonly'); ?>

input_html("", $_GET['record_id'], 'record_id', 'record_id', 'inputs', '', '', '', 'hidden'); ?> input_html("", $_SESSION['user_id'], 'user_id', 'user_id', 'inputs', '', '', '', 'hidden'); ?> input_html("", date("Y-m-d H:i", strtotime('+2 Hours')), 'date_time', 'date_time', 'inputs', '', '', '', 'hidden'); ?>

TO DO

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()"); } echo $html->submit_btn("submit", "SAVE", "add_work_order()"); } ?> complete_text_editor('notes', 'work_orders', 'notes', 'record_id = ' . $_GET['record_id'] . ''); ?>

html_form_ajax("add_work_order", "UPDATE", "work_orders", '', false, [], '', ['notes'], 'date_time,user_id'); $html->html_form_ajax("mark_for_review", "UPDATE", "work_orders", '', false, [], '', ['notes'], 'date_time,user_id', 'sent_for_review=1'); $html->html_form_ajax("mark_as_inprogress", "UPDATE", "work_orders", '', false, [], '', ['notes'], 'date_time,user_id', 'inprogress=1'); $html->html_form_ajax("mark_as_not_inprogress", "UPDATE", "work_orders", '', false, [], '', ['notes'], 'date_time,user_id', 'inprogress=0'); $html->html_form_ajax("start", "custom_insert", "work_order_timeline", '', false, [], '', ['notes'], "record_id,notes", "status=start,work_order_id={$_GET['record_id']}"); $html->html_form_ajax("stop", "custom_insert", "work_order_timeline", '', false, [], '', ['notes'], "record_id,notes", "status=stop,work_order_id={$_GET['record_id']}"); $html->html_form_ajax("send_for_review", "custom_insert", "work_order_timeline", '', false, [], '', ['notes'], "record_id,notes", "status=sent_for_review,work_order_id={$_GET['record_id']}"); ?>