';
$jobcards_res = $db->exec_query('inspections', ['*'], '', '', '', '', $where_data, 'ORDER BY record_id DESC LIMIT 100');
$where_data = str_replace("'", "|", $where_data);
$index = 0;
$total = 0;
$total_open = 0;
$total_closed = 0;
$total_waiting = 0;
$html = new html("REPORTS");
while ($jobcard_info = $jobcards_res->fetch_assoc()) {
$asset_info_res = $db->exec_query('assets', ['*'], '', '', '', '', "record_id = {$jobcard_info['asset_record_id']}");
$asset_info = $asset_info_res->fetch_assoc();
$user_info_res = $db->exec_query('users', ['*'], '', '', '', '', "record_id = {$jobcard_info['user_id']}");
$user_info = $user_info_res->fetch_assoc();
$pre_inspection_res = $db->exec_query('pre_inspection_content', ['*'], '', '', '', '', '', "record_id = {$jobcard_info['inpection_id']}");
$pre_inspection_info = $pre_inspection_res->fetch_assoc();
$farm_res = $db->exec_query('farms', ['*'], '', '', '', '', "record_id = {$jobcard_info['farm_id']}");
$farm = $farm_res->fetch_assoc();
//
$table_data = $table_data . "
|
| |
|
|
|
|
";
$index++;
$total++;
}
?>
|
NO.
|
DATE
|
INSPECTION TYPE
|
FLEET NO
|
USERNAME
|