add_styles_page();
$db = new db_safeguard();
$work_orders_res = $db->select_query('work_orders', '*', "record_id = {$_GET['record_id']}");
$work_order = $work_orders_res->fetch_assoc();
$projects_res = $db->select_query('projects', '*', "record_id = {$work_order['project_id']}");
$project = $projects_res->fetch_assoc();
function get_username($id)
{
$db = new db_safeguard();
$user_res = $db->select_query('users', '*', "record_id = {$id}");
$user = $user_res->fetch_assoc();
return $user['username'];
}
?>
input_html_from_db('work_orders', 'date_time_created', "record_id = {$_GET['record_id']}");
echo $html->select_html_from_db('users', 'record_id', 'username', '', 'user_id', 'user_id');
echo $html->select_from_db_add_current_selected_column('work_orders', 'user_id', "record_id = {$_GET['record_id']}", 'user_id');
echo $html->select_html_from_db('users', 'record_id', 'username', '', 'user_id_assigned', 'user_id_assigned');
echo $html->select_from_db_add_current_selected_column('work_orders', 'user_id_assigned', "record_id = {$_GET['record_id']}", 'user_id_assigned');
?> WORK DESCRIPTION
USER NOTES
submit_btn('submit', 'OPEN PDF', 'PDF()');
?>
html_form_ajax("signoff", "UPDATE", "work_orders", '', false);
?>