$tf = " h:i A";
}
$datejs = str_replace('d', 'dd', $dateformat);
$datejs = str_replace('m', 'mm', $datejs);
$datejs = str_replace('Y', 'yy', $datejs);
$clientType = pg_fetch_result($dsAll, 0, "clienttypeid");
$clientUnit = pg_fetch_result($dsAll, 0, "metric");
//$allPOI = dlookup("select count(*) from pinpoints where clientID=" . session("client_id"));
//$allPOIs As String = "false"
//If allPOI < 1000 Then allPOIs = "true"
$DefMap = pg_fetch_result($dsAll, 0, "defaultmap");
$currDateTime0 = new Datetime();
$currDateTime = $currDateTime0->format("d-m-Y H:i");
$currDateTime1 = $currDateTime0->format($dateformat);
$currDateTime2 = $currDateTime0->format($dateformat);
$currDateTime2 = addToDateU($currDateTime, -1, 'days', $dateformat);
//dd-MM-yyyy HH:mm
//now()->format("Y-m-d H:i:s");
$AllowedMaps = "11111";
$cntz = dlookup("select count(*) from pointsofinterest where active='1' and type=2 and clientid=" . Session("client_id"));
//$CurrentTime = DlookUP("select Convert(nvarchar(20), DATEADD(HOUR,(select timeZone from clients where ID=" . Session("client_id") . ") - 1,GETDATE()), 120) DateTime");
$tzone = pg_fetch_result($dsAll, 0, "timezone");
$tzone = $tzone - 1;
//$AllowAddPoi = getPriv("AddPOI", Session("user_id"))
//$AllowViewPoi = getPriv("ViewPOI", Session("user_id"))
//$AllowAddZone = getPriv("AddZones", Session("user_id"))
//$AllowViewZone = getPriv("ViewZones", Session("user_id"))
$ua = getBrowser();
$yourbrowser = (bool) strpos($ua['userAgent'], "iPad");
addlog(37, '');
?>
$s_ = " 12:00 AM";
$s1_ = "_12:00_AM";
$tf = " h:i a";
}
//$_SESSION['role_id'] = nnull(dlookup("select roleid from users where id=" . $user_id), 0 );
$role_id = nnull(dlookup("select roleid from users where id=" . $uid), 0);
$vh = nnull(getQUERY("vh"), "0");
//645;//
$sdG = DateTimeFormat(getQUERY("sd"), 'd-m-Y H:i:s');
$edG = DateTimeFormat(getQUERY("ed"), 'd-m-Y H:i:s');
$sd = DateTimeFormat(getQUERY("sd"), $dateformat) . $s_;
//'01-09-2012 00:00';
$ed = DateTimeFormat(getQUERY("ed"), $dateformat) . $e_;
//'01-09-2012 23:59';
$tzone = dlookup("select tzone from users where id=" . $uid);
$CreationDate = strtoupper(DateTimeFormat(addToDateU(now(), $tzone, "hour", "Y-m-d H:i"), $datetimeformat));
/*format na datum*/
$_SESSION["user_fullname"] = dlookup("select fullname from users where id='" . $uid . "'");
$_SESSION["company"] = dlookup("select name from clients where id in (select clientid from users where id=" . $uid . " limit 1) limit 1");
$langArr = explode("?", getQUERY("l"));
$cLang = $langArr[0];
$vh = getQUERY("vh");
$meseci = array("January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December");
$countALL = 0;
$langArr = explode("?", getQUERY("l"));
$cLang = $langArr[0];
?>
<?php
if (getQUERY("from") == "a") {
$filename = "Log_report_" . $cid . "_" . DateTimeFormat($sdG, $dateformat) . $s1_ . "_" . DateTimeFormat($edG, $dateformat) . $e1_ . ".xls";
if ($DFormat1 == "yyyy-MM-dd") {
$DFormat = "Y-m-d";
} else {
$DFormat = "m-d-Y";
}
}
if ($TFormat1 == "24 Hour Time") {
$TFormat = "H:i:s";
} else {
$TFormat = "h:i:s A";
}
$DTFormat = $DFormat . " " . $TFormat;
$dbDatum = DlookUP("select now() DateTime");
$dtTmp111 = new Datetime($dbDatum);
$dbDatum = $dtTmp111->format("Y-m-d H:i:s");
$dbDatum = addToDateU($dbDatum, $tzone1, 'hour', 'Y-m-d H:i:s');
//$dbDatum123 = DlookUP("select DATEADD(MINUTE, -30, GETDATE()) DateTime");
$sqlV = "";
if (session("role_id") . "" == "2") {
$sqlV = "select id from vehicles where clientid=" . session("client_id");
} else {
$sqlV = "select vehicleid from uservehicles where userid=" . session("user_id");
}
$ClientTypeID = dlookup("select clienttypeid from clients where id=" . session("client_id"));
$sqlStyles = "";
$sqlStyles .= "SELECT c1.name engineon, c2.name engineoff, c3.name engineoffpassengeron, c4.name satelliteoff, c5.name taximeteron, c6.name taximeteroffpassengeron, c7.name passiveon, c8.name activeoff ";
$sqlStyles .= "from users us ";
$sqlStyles .= "left outer join statuscolors c1 on c1.id=us.engineon ";
$sqlStyles .= "left outer join statuscolors c2 on c2.id=us.engineoff ";
$sqlStyles .= "left outer join statuscolors c3 on c3.id=us.engineoffpassengeron ";
$sqlStyles .= "left outer join statuscolors c4 on c4.id=us.satelliteoff ";
