function dbAlarm($idname)
{
global $db;
foreach ($_SESSION['license'] as $r) {
$lics .= "'" . $r[1] . "',";
}
$lics = substr($lics, 0, -1);
$ret = "<table id=\"{$idname}\">" . " <thead>" . " <tr>" . " <th>License</th>" . " <th>Nama Jalan</th>" . " <th>Waktu</th>" . " <th>Kecepatan</th>" . " <th>Arah</th>" . " <th>Tegangan Aki</th>" . " </tr>" . " </thead>" . " <tbody>";
try {
foreach ($_SESSION['license'] as $r) {
$lics .= "'" . $r[1] . "',";
}
$lics = substr($lics, 0, -1);
$sql = "select license,latitude,longitude,`time` as waktu,speed,course,`input power` as power " . "from tblatestlocation where license IN ({$lics})";
$sth = $db->prepare($sql, array(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY));
$sth->execute();
$rows = $sth->fetchAll(PDO::FETCH_ASSOC);
foreach ($rows as $r) {
$alamat = fAlamat($r['latitude'], $r['longitude']);
$ret .= "<tr>" . " <td>" . $r['license'] . "</td>" . " <td>" . $alamat["alamat"] . "</td>" . " <td>" . $r['waktu'] . "</td>" . " <td>" . round($r['speed'], 0) . "</td>" . " <td>" . fArah($r['course']) . "</td>" . " <td>" . dbBaterai($r['power']) . "</td>" . "</tr>";
}
} catch (PDOException $e) {
print $e->getMessage();
exit;
}
$ret .= "</tbody>";
$ret .= "</table>";
return $ret;
}
fAuth();
$lics = substr($lics, 0, -1);
$ret = "<table id=\"alarm\">" . " <thead>" . " <tr>" . " <th>License</th>" . " <th>Nama Jalan</th>" . " <th>Waktu</th>" . " <th>Speed</th>" . " <th>Kontak</th>" . " <th>Arah</th>" . " <th>Tegangan</th>" . " </tr>" . " </thead>" . " <tbody>";
if (count($_SESSION['license']) > 0) {
try {
foreach ($_SESSION['license'] as $r) {
$lics .= "'" . $r[1] . "',";
}
$lics = substr($lics, 0, -1);
if ($_cfg['db_driver'] == "mysql") {
$sql = "select license,latitude,longitude,DATE_FORMAT(DATE_ADD(`time`, INTERVAL 7 HOUR),'%d/%m/%y') as tanggal,DATE_FORMAT(DATE_ADD(`time`, INTERVAL 7 HOUR),'%H:%i:%s') as jam,speed,course,`input power` as power,`ignition on` as kontak " . "from tblatestlocation where license IN ({$lics}) order by `time` desc";
} else {
$sql = "select license,latitude,longitude,CONVERT(VARCHAR(8), DATEADD(hour, 7,time), 3) AS tanggal,CONVERT(VARCHAR(8), DATEADD(hour, 7,time), 108) AS jam,speed,course,[input power] as power,[ignition on] as kontak " . "from tblatestlocation where license IN ({$lics}) order by time desc";
}
$sth = $db->prepare($sql, array(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY));
$sth->execute();
$rows = $sth->fetchAll(PDO::FETCH_ASSOC);
if (count($rows) > 0) {
foreach ($rows as $r) {
$alamat = fAlamat($r['latitude'], $r['longitude']);
$ret .= "<tr>" . " <td><span onclick=\"temukan('" . $r['license'] . "');\" style=\"cursor:pointer;\">" . $r['license'] . "</span></td>" . " <td>" . $alamat["alamat"] . "</td>" . " <td align=\"center\">" . $r['tanggal'] . " " . $r['jam'] . "</td>" . " <td align=\"right\">" . round($r['speed'], 0) . " km/jam</td>" . " <td align=\"center\">" . ($r['kontak'] == '0' ? 'OFF' : 'ON') . "</td>" . " <td align=\"center\">" . fArah($r['course']) . "</td>" . " <td align=\"center\">" . dbBaterai($r['power']) . "</td>" . "</tr>";
}
}
} catch (PDOException $e) {
print $e->getMessage();
exit;
}
}
$ret .= "</tbody>";
$ret .= "</table>";
echo $ret;
