';
$jobcards_res = $db->exec_query('job_cards', ['*'], '', '', '', '', $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;
while ($jobcard_info = $jobcards_res->fetch_assoc()) {
$asset_info_res = $db->exec_query('assets', ['*'], '', '', '', '', "record_id = {$jobcard_info['asset_id']}");
$asset_info = $asset_info_res->fetch_assoc();
$user_info_res = $db->exec_query('users', ['*'], '', '', '', '', "record_id = {$jobcard_info['user_id_opened']}");
$user_info = $user_info_res->fetch_assoc();
if ($jobcard_info['job_card_status'] == 'OPEN') {
$total_open = $total_open + 1;
$table_data = $table_data . "|
";
}
if ($jobcard_info['job_card_status'] == 'CLOSED') {
$total_closed = $total_closed + 1;
$table_data = $table_data . " |
|
";
}
if ($jobcard_info['job_card_status'] == 'AWAITING PARTS') {
$total_waiting = $total_waiting + 1;
$table_data = $table_data . " |
|
";
}
$table_data = $table_data . "
| |
|
|
|
|
|
";
$index++;
$total++;
}
?>
|
OPEN:
|
CLOSED:
|
WAITING PARTS:
|
TOTAL:
|
|
|
DATE
|
DESCRIPTION
|
FLEET NO
|
TYPE
|
STATUS
|
J.C NUM.
|