0,'moving'=>0,'acc_on'=>0,'latest'=>'—'];
try {
$stats['total']=(int)$pdo->query('SELECT COUNT(*) FROM `bmr_data`')->fetchColumn();
$stats['moving']=(int)$pdo->query('SELECT COUNT(*) FROM `bmr_data` WHERE `Speed` > 0')->fetchColumn();
$stats['acc_on']=(int)$pdo->query("SELECT COUNT(*) FROM `bmr_data` WHERE `Acc_Status` = 'On'")->fetchColumn();
$v=$pdo->query('SELECT MAX(`ReportingDate`) FROM `bmr_data`')->fetchColumn(); if($v)$stats['latest']=$v;
} catch(PDOException $e){error_log($e->getMessage());}
?>Fleet Dashboard
Fleet MonitoringSigned in: · Logout
Fleet Dashboard
Online BMR database · Latest records
Total recordsSpeed above zeroACC OnLatest report
BMR Records
| Registration | Reporting date | Status | Speed | Trip ODO | Location | Fence | ACC |
|---|
| Loading… |
Page 1