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'); ?> complete_text_editor('description', 'work_orders', 'description', "record_id = {$_GET['record_id']}"); echo $html->submit_btn("submit", "SAVE", "save()"); ?>
submit_btn("submit", "STOP", "stop();set_not_in_review();"); } elseif ($work_order['status'] == 'review_stop') { echo $html->submit_btn("submit", "START", "start();set_in_review();"); echo $html->submit_btn("submit", "RE OPEN WORK ORDER", 're_open_work_order();'); echo $html->submit_btn("submit", "MARK AS COMPLETE", 'complete();mark_as_complete();'); } else { echo $html->submit_btn("submit", "START", "start();"); } } ?>

NOTES

html_form_ajax("save", "UPDATE", "work_orders", '', false, [], '', ['description'], 'date_time,user_id'); $html->html_form_ajax("re_open_work_order", "UPDATE", "work_orders", '', false, [], '', ['description'], 'date_time,user_id', 'in_review=0,sent_for_review=0'); $html->html_form_ajax("set_in_review", "UPDATE", "work_orders", '', false, [], '', ['description'], 'date_time,user_id', 'in_review=1'); $html->html_form_ajax("set_not_in_review", "UPDATE", "work_orders", '', false, [], '', ['description'], 'date_time,user_id', 'in_review=0'); $html->html_form_ajax("mark_as_complete", "UPDATE", "work_orders", '', false, [], '', ['description'], 'date_time,user_id', 'completed=1,in_review=0,sent_for_review=0'); $html->html_form_ajax("start", "custom_insert", "work_order_timeline", '', false, [], '', ['description'], "record_id,description", "status=review_start,work_order_id={$_GET['record_id']}"); $html->html_form_ajax("stop", "custom_insert", "work_order_timeline", '', false, [], '', ['description'], "record_id,description", "status=review_stop,work_order_id={$_GET['record_id']}"); $html->html_form_ajax("complete", "custom_insert", "work_order_timeline", '', false, [], '', ['description'], "record_id,description", "status=complete,work_order_id={$_GET['record_id']}"); ?>