';
// $jobcards_res = $db->exec_query('job_cards', ['*'], '', '', '', '', 1, 'ORDER BY record_id DESC LIMIT 100');
$jobcards_res = $db->exec_query("job_cards", ["*"], '', '', '', '', "date_time_closed = '' AND UNIX_TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 15 DAY)) <= UNIX_TIMESTAMP(date_time_created) AND UNIX_TIMESTAMP(date_time_created) <= UNIX_TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 0 DAY))");
$index = 0;
$total = 0;
$total_open = 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:
|
WAITING PARTS:
|
TOTAL:
|
|
DATE
|
DESCRIPTION
|
FLEET NO
|
TYPE
|
STATUS
|
J.C NUM.
|
';
// $jobcards_res = $db->exec_query('job_cards', ['*'], '', '', '', '', 1, 'ORDER BY record_id DESC LIMIT 100');
$jobcards_res = $db->exec_query("job_cards", ["*"], '', '', '', '', "date_time_closed = '' AND UNIX_TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 30 DAY)) <= UNIX_TIMESTAMP(date_time_created) AND UNIX_TIMESTAMP(date_time_created) <= UNIX_TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 16 DAY))");
$index = 0;
$total = 0;
$total_open = 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:
|
WAITING PARTS:
|
TOTAL:
|
|
DATE
|
DESCRIPTION
|
FLEET NO
|
TYPE
|
STATUS
|
J.C NUM.
|
';
// $jobcards_res = $db->exec_query('job_cards', ['*'], '', '', '', '', 1, 'ORDER BY record_id DESC LIMIT 100');
$jobcards_res = $db->exec_query("job_cards", ["*"], '', '', '', '', "date_time_closed = '' AND UNIX_TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 60 DAY)) <= UNIX_TIMESTAMP(date_time_created) AND UNIX_TIMESTAMP(date_time_created) <= UNIX_TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 31 DAY))");
$index = 0;
$total = 0;
$total_open = 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:
|
WAITING PARTS:
|
TOTAL:
|
|
DATE
|
DESCRIPTION
|
FLEET NO
|
TYPE
|
STATUS
|
J.C NUM.
|
';
// $jobcards_res = $db->exec_query('job_cards', ['*'], '', '', '', '', 1, 'ORDER BY record_id DESC LIMIT 100');
$jobcards_res = $db->exec_query("job_cards", ["*"], '', '', '', '', "date_time_closed = '' AND UNIX_TIMESTAMP(CURDATE()) - UNIX_TIMESTAMP(date_time_created) > 60*24*60*60");
$index = 0;
$total = 0;
$total_open = 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:
|
WAITING PARTS:
|
TOTAL:
|
|
DATE
|
DESCRIPTION
|
FLEET NO
|
TYPE
|
STATUS
|
J.C NUM.
|