modify("$days days");
return $date->format($format);
}
$data = [];
$html = "";
$db = new db();
$farm_res = $db->exec_query('farms', ['*'], '', '', '', '', 'record_id = 5', "ORDER BY record_id ASC");
while ($farm = $farm_res->fetch_assoc()) {
// $html = $html . " FARM : {$farm['farm_name']}
";
$asset_type_res = $db->exec_query('asset_types', ['*'], '', '', '', '', "record_id = 9 OR record_id = 10 OR record_id = 11 OR record_id = 12 OR record_id = 17 OR record_id = 18 OR record_id = 19");
while ($asset_type = $asset_type_res->fetch_assoc()) {
// $html = $html . "
{$asset_type['asset_type_name']}
";
$assets_res = $db->exec_query('assets', ['*'], '', '', '', '', " asset_type_id = {$asset_type['record_id']} AND farm_id = {$farm['record_id']}");
while ($asset = $assets_res->fetch_assoc()) {
// $html = $html . "
{$asset['fleet_no']} {$asset['description']} ";
$odo_res2 = $db->exec_query('asset_odo', ['*'], '', '', '', '', "asset_record_id = {$asset['record_id']}", 'ORDER BY record_id DESC');
$odo2 = $odo_res2->fetch_assoc();
$last_known_service_res = $db->exec_query('job_cards', ['*'], '', '', '', '', "asset_id = {$asset['record_id']} AND job_card_type = 'SERVICE'", "ORDER BY record_id DESC");
if ($last_known_service_res->num_rows > 0) {
$last_known_service = $last_known_service_res->fetch_assoc();
$odo_res = $db->exec_query('asset_odo', ['*'], '', '', '', '', "asset_record_id = {$asset['record_id']} AND `date` BETWEEN '" . addDays(substr($last_known_service['date_time_opened'], 0, 10), "-5") . " 00:00' AND '" . addDays(substr($last_known_service['date_time_opened'], 0, 10), "+5") . " 23:59'", 'ORDER BY record_id DESC');
if ($odo_res->num_rows < 1) {
$odo_res = $db->exec_query('asset_odo', ['*'], '', '', '', '', "asset_record_id = {$asset['record_id']} AND `date` < '" . addDays(substr($last_known_service['date_time_opened'], 0, 10), "+0") . " 23:59'", 'ORDER BY record_id DESC');
}
$odo = $odo_res->fetch_assoc();
// $html = $html . "
LAST KNOWN SERVICE :
JC. No. : {$last_known_service['record_id']}
DATE OPENED : {$last_known_service['date_time_opened']}
JC. STATUS : {$last_known_service['job_card_status']}
ODO for that day : {$odo['odo']}";
// $html = $html . "
CURRENT ODO: {$odo2['odo']} {$odo2['date']} ";
$service_type_res = $db->exec_query('service_types', ['*'], '', '', '', '', "record_id = '{$asset_type['service_type_id']}'");
$service_type = $service_type_res->fetch_assoc();
// $html = $html . "
SERVICE INTERVAL : {$service_type['service_interval']}";
// $html = $html . "
NEXT SERVICE : " . ($odo['odo'] + $service_type['service_interval']) . '';
if($odo2['odo'] > ($odo['odo'] + $service_type['service_interval'])/1.05){
if((($odo['odo'] + $service_type['service_interval']) - $odo2['odo']) < 0){
$data[] = " | | | | |
";
}else{
$data[] = " | | | | |
";
}
}
// $amlost_due[] = "{$asset['fleet_no']} {$asset['description']} DUE IN " . (($odo['odo'] + $service_type['service_interval']) - $odo2['odo']) . " {$service_type['odo_type']}";
} else {
$data[] = " | | |
";
// $html = $html . "
CURRENT ODO: {$odo2['odo']} {$odo2['date']} ";
// $html = $html . "
NO SERIVICE HISTORY FOUND ON THE SYSTEM
";
}
}
}
// var_dump($amlost_due);
// echo $html;
}
// var_dump($data);
?>
|
Desription
|
Fleet No
|
Next Service
|
Current ODO
|
Net ODO
|