';
$jobcards_res = $db->exec_query('job_cards', ['*'], '', '', '', '', "record_id = {$_GET['jobcard_num']}");
$jobcard_info = $jobcards_res->fetch_assoc();
$get_last_odo_res = $db->exec_query('asset_odo', ['*'], '', '', '', '', "asset_record_id = {$jobcard_info['asset_id']}", "ORDER BY record_id DESC");
$get_last_odo = $get_last_odo_res->fetch_assoc();
$asset_info = $db->exec_query('assets', ['*'], '', '', '', '', "record_id = {$jobcard_info['asset_id']}");
$asset = $asset_info->fetch_assoc();
$jobcard_type_res = $db->exec_query('jobcard_types', ['*'], '', '', '', '', "name = '{$jobcard_info['job_card_type']}'");
$jobcard_type = $jobcard_type_res->fetch_assoc();
$inspection_res = $db->exec_query('jobcard_q_a_list', ['*'], '', '', '', '', "jobcard_type_id = '{$jobcard_type['record_id']}'");
$pre_inspection_info = $inspection_res->fetch_assoc();
$index = 0;
$questions_array_part_1 = explode(',', $pre_inspection_info['questions']);
$questions_array_part_2 = explode(',', $pre_inspection_info['answers']);
$questions_array_part_3 = explode(',', $pre_inspection_info['warnings']);
$array_count = count($questions_array_part_1);
$questions_array = [];
while ($index <= $array_count) {
$questions_array[] = $questions_array_part_1[$index] . '||' . $questions_array_part_2[$index] . '||' . $questions_array_part_3[$index];
$index++;
}
if (strlen($jobcard_info['date_time_opened']) < 1) {
$db->Update('job_cards', ['date_time_opened'], [$date], "record_id = {$_GET['jobcard_num']}");
echo "";
}
$html = new html('JOB CARD');
?>