" width="16%" height="30px" align="center" class="text2" style="background-color:#fff; border:1px dotted #B8B8B8;"><?php echo nnull($drOU["name"], "/"); ?> </td> <td id="_td-4-<?php echo $cnt_; ?> " width="16%" height="30px" align="center" class="text2" style="background-color:#fff; border:1px dotted #B8B8B8;"><?php echo DateTimeFormat($drOD["borndate"], $dateformat); ?> </td> <td id="_td-5-<?php echo $cnt_; ?> " width="12%" height="30px" align="center" class="text2" style="background-color:#fff; border:1px dotted #B8B8B8;"><?php echo nnull($drOD["licensetype"], "/"); ?> </td> <td id="_td-6-<?php echo $cnt_; ?> " width="15%" height="30px" align="center" class="text2" style="background-color:#fff; border:1px dotted #B8B8B8;"><?php echo DateTimeFormat($drOD["licenseexp"], $dateformat); ?> </td> <td id="_td-7-<?php echo $cnt_; ?> " width="8%" height="30px" align="center" class="text2" style="background-color:#fff; border:1px dotted #B8B8B8;"> <button id="_modBtn-<?php echo $cnt_;
$naslov = getQUERY("n"); $vozilo = getQUERY("vo"); $sofer1 = getQUERY("d1"); $sofer2 = getQUERY("d2"); $sofer3 = getQUERY("d3"); $datum = getQUERY("d"); $vreme = getQUERY("v"); $alarm = getQUERY("alarm"); $zadrz = getQUERY("zadrz"); $pause1 = getQUERY("pause1"); $pause2 = getQUERY("pause2"); $pause3 = getQUERY("pause3"); $pause4 = getQUERY("pause4"); $pause5 = getQUERY("pause5"); /*Za ZKPelagonija*/ $culid = nnull(getQUERY("culid"), 0); /*Za ZKPelagonija*/ $totalkm = getQUERY("totalkm"); $totaltime = getQUERY("totaltime"); if ($alarm == "/") { $alarm = 0; } if ($zadrz == "/") { $zadrz = 0; } //dim dat() as string = split(datum,"-") //dim datum1 = dat(2) & "-" & dat(1) & "-" & dat(0) $tmpDT = new DateTime($datum . ' ' . $vreme); $tmpDT = $tmpDT->format("Y-m-d H:i:s"); $sqlInsert = "insert into rnalogheder (datetime, VehicleID, DriverID1, DriverID2, DriverID3, StartDate, Name, ClientID, userID, Alarm, toStay, Pause1, Pause2, Pause3, Pause4, Pause5, TotalKm, TotalTime, culid) "; $sqlInsert .= " Values (now(), " . $vozilo . ", " . $sofer1 . ", " . $sofer2 . ", " . $sofer3 . ", '" . $tmpDT . "', '" . $naslov . "', " . session("client_id") . ", " . session("user_id") . ", " . $alarm . ", " . $zadrz . ", " . $pause1 . ", " . $pause2 . ", " . $pause3 . ", " . $pause4 . ", " . $pause5 . ", " . $totalkm . ", " . $totaltime . ", " . $culid . " )";
} ?> width:<?php echo $width; ?> %; font-size:11px; padding-left:3px" align="left" class="corner5 text5 <?php echo $classTr; ?> colZone"><span id="spanZone-<?php echo $drVehicle["id"]; ?> " onmousemove="ShowPopup(event, '<span class=\'text5\'><?php echo dic("Reports.CurrZone"); ?> </span>')" onmouseout="HidePopup()"><?php echo nnull(pg_fetch_result($dsCurrPos, 0, "zonenames"), "/"); ?> </span></td> <?php if ($clientType == 2) { $dsTaxiData = query("select count(*) cnt, sum(price) price, sum(pricewith) pricewith from reporttaxi where vehicleid=" . $drVehicle["id"] . " and startdate between '" . DateTimeFormat(now(), "Y-m-d 00:00:00") . "' and '" . DateTimeFormat(now(), "Y-m-d H:i:s") . "'"); ?> <td style="<?php echo $dntoursS; ?> ; width:6%; font-size:11px;" align="center" class="corner5 text5 <?php echo $classTr; ?> colNTours"> <span id="spanCntTours-<?php echo $drVehicle["id"];
<script type="text/javascript" src="../js/jquery.js"></script> <script type="text/javascript" src="../js/iScroll.js"></script> <script type="text/javascript" src="../js/jquery-ui.js"></script> <script type="text/javascript" src="../js/settings.js"></script> <script type="text/javascript" src="../js/share.js"></script> <link href="../tracking/mlColorPicker.css" rel="stylesheet" type="text/css" /> <script type="text/javascript" src="../tracking/mlColorPicker.js" ></script> <script type="text/javascript" src="../main/main.js"></script> </head> <?php if (session('user_id') == "261") { echo header('Location: ../sessionexpired/?l=' . $cLang); } if (is_numeric(nnull(session("user_id")) . "") == false) { echo header('Location: ../sessionexpired/?l=' . $cLang); } opendb(); $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") . ""; } $Allow = getPriv("settings", session("user_id")); if ($Allow == false) { echo header('Location: ../?l=' . $cLang . '&err=permission'); } $AllowUSettings = true; //getPriv("UserSettings", session("user_id"));
opendb(); $city = nnull(utf8_urldecode(getQUERY('city')), ""); $country = getQUERY("country"); $elevation = nnull(utf8_urldecode(getQUERY('elevation')), ""); $fullname = nnull(utf8_urldecode(getQUERY('fullname')), ""); $lon = getQUERY("lon"); $lat = getQUERY("lat"); $otime = getQUERY("otime"); $temp = getQUERY("temp"); $feelslike = getQUERY("feelslike"); $wind = getQUERY("wind"); $visibility = getQUERY("visibility"); $weather = nnull(utf8_urldecode(getQUERY("weather")), ""); $humidity = getQUERY("humidity"); $icon = nnull(utf8_urldecode(getQUERY("icon")), ""); $iconurl = nnull(utf8_urldecode(getQUERY("iconurl")), ""); $cntW = dlookup("select count(*) from weatherstations where city='" . $city . "'"); if ($cntW > 0) { $sqlAddW = "UPDATE weatherstations set observationtime='" . $otime . "', temerature=" . $temp; $sqlAddW .= ", feelslike=" . $feelslike . ", weather='" . $weather . "', humidity='" . $humidity; $sqlAddW .= "', visibility=" . $visibility . ", wind=" . $wind . ", icon='" . $icon . "', iconurl='" . $iconurl . "'"; $sqlAddW .= " where city='" . $city . "'"; RunSQL($sqlAddW); echo "update"; } else { $sqlAddW = "INSERT INTO weatherstations (city, country, elevation, fullname, latitude, longitude, observationtime, temerature, feelslike, weather, humidity, visibility, wind, icon, iconurl) VALUES "; $sqlAddW .= "('" . $city . "', '" . $country . "', '" . $elevation . "', '" . $fullname . "', " . $lat . ", " . $lon . ", '" . $otime . "', " . $temp . ", " . $feelslike . ", '" . $weather . "', '" . $humidity . "', " . $visibility . ", " . $wind . ", '" . $icon . "', '" . $iconurl . "')"; RunSQL($sqlAddW); echo "insert"; } closedb();
<?php include "../include/functions.php"; include "../include/db.php"; ?> <?php include "../include/params.php"; include "../include/dictionary2.php"; set_time_limit(0); opendb(); $vehid = getQUERY("vehid"); $lon = getQUERY('lon'); $lat = getQUERY('lat'); $_name = nnull(utf8_urldecode(getQUERY('name')), ""); $_description = nnull(utf8_urldecode(getQUERY('description')), ""); $garminid = dlookup("select coalesce((select garminid from stopstatus where toid=" . $vehid . " order by datetime desc limit 1), 0)"); $garminid = $garminid + 1; $sqlAddPoi = "insert into stopstatus (fromid, toid, clientid, userid, datetime, text, garminid, latitude, longitude, location) values"; $sqlAddPoi .= "(" . session("user_id") . ", " . $vehid . ", " . session("client_id") . ", " . session("user_id") . ", now(),"; $sqlAddPoi .= "'" . $_name . "', " . $garminid . ", " . $lat . ", " . $lon . ", '" . $_description . "')"; $ret = RunSQL($sqlAddPoi); echo $garminid; closedb();
function DateTimeFormat($date, $format) { return date_format(new Datetime(nnull($date, date($format))), $format); }
$pastKm = nnull(dlookup("select SUM(distance)/1000 from rshortreport where vehicleid=" . $vehId . " and Datetime >= '" . $lastDateKm . "' and Datetime <= '" . DateTimeFormat($LastDay, "Y-m-d" . " 23:59:59") . "'"), 0); $Km = nnull(dlookup("select km from currkm where vehicleid=" . $vehId), 0); $proKm = $pastKm + $Km; } else { $proKm = nnull(dlookup("select SUM(distance)/1000 from rshortreport where vehicleid=" . $vehId), 0); } } else { if ($lastDateKm != "") { if ($lastDateKm <= $dt) { $pastKm = nnull(dlookup("select SUM(distance)/1000 from rshortreport where vehicleid=" . $vehId . " and Datetime >= '" . $lastDateKm . "' and Datetime <= '" . DateTimeFormat($dt, "Y-m-d" . " 23:59:59") . "'"), 0); $Km = nnull(dlookup("select km from currkm where vehicleid=" . $vehId), 0); $proKm = $pastKm + $Km; } else { $proKm = nnull(dlookup("select SUM(distance)/1000 from rshortreport where vehicleid=" . $vehId . " and Datetime <= '" . DateTimeFormat($dt, "Y-m-d" . " 23:59:59") . "' "), 0); } /*$pastKm = nnull(dlookup("select SUM(distance)/1000 from rshortreport where vehicleid=" . $vehId . " and Datetime >= '" . DateTimeFormat($lastDateKm, "Y-m-d H:i:s") . "' and Datetime <= '" . DateTimeFormat($dt, "Y-m-d" . " 23:59:59") . "'"), 0); $Km = nnull(dlookup("select km from currkm where vehicleid=" . $vehId), 0); $proKm = $pastKm + $Km;*/ } else { $proKm = nnull(dlookup("select SUM(distance)/1000 from rshortreport where vehicleid=" . $vehId . " and Datetime <= '" . DateTimeFormat($dt, "Y-m-d" . " 23:59:59") . "' "), 0); } } $metric = dlookup("select metric from users where id=" . session("user_id")); if ($metric == 'mi') { $metricvalue = 0.621371; } else { $metricvalue = 1; } closedb(); echo number_format(round($proKm * $metricvalue, 0)); exit;
?> <?php session_start(); header("Content-type: text/html; charset=utf-8"); ?> <?php $vehID = getQUERY("vehID"); $dt = DateTimeFormat(getQUERY("dt"), 'Y-m-d H:i:s'); $driver = nnull(getQUERY("driver"), ""); $km = getQUERY("km"); $loc = getQUERY("loc"); $liters = nnull(getQUERY("liters"), 0); $litersLast = nnull(getQUERY("litersLast"), 0); $price = nnull(getQUERY("price"), 0); $pay = getQUERY("pay"); opendb(); $checkCnt = dlookup("select count(*) from fuel where vehicleid=" . $vehID . " and datetime = '" . $dt . "' and driverid=" . $driver . "\r\n\tand km = " . $km . " and price = " . $price . " and liters = " . $liters . " and literslast = " . $litersLast . " and pay = '" . $pay . "' and location = '" . $loc . "'"); if ($checkCnt == 0) { if ($driver == "") { RunSQL("INSERT INTO fuel (vehicleid, datetime, km, price, liters, literslast, pay, location) \r\n\t\t VALUES (" . $vehID . ", '" . DateTimeFormat($dt, "Y-m-d H:i:s") . "', " . $km . ", " . $price . ", " . $liters . ", \r\n\t\t " . $litersLast . ", '" . $pay . "','" . $loc . "')"); } else { RunSQL("INSERT INTO fuel (vehicleid, datetime, driverid, km, price, liters, literslast, pay, location) \r\n\t\t VALUES (" . $vehID . ", '" . DateTimeFormat($dt, "Y-m-d H:i:s") . "', " . $driver . ", " . $km . ", " . $price . ", " . $liters . ", \r\n\t\t " . $litersLast . ", '" . $pay . "', '" . $loc . "')"); } echo 1; } else { echo 0; } closedb(); exit;
<?php include "../include/db.php" ?> <?php include "../include/params.php" ?> <?php include "../include/dictionary2.php" ?> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <script> lang = '<?php echo $cLang?>'; </script> <?php opendb(); $clienttypeid = dlookup("select clienttypeid from clients where id = " . session("client_id")); $metric = nnull(dlookup("select metric from users where id = " . session("user_id")), "1"); if ($metric == 'mi') { $value = 0.621371; } else { $value = 1; } If ($metric == "Km" or $metric == 'km') { $unitSpeed = "Km/h"; } Else { $unitSpeed = "mph"; } $id = str_replace("'", "''", NNull($_GET['id'], '')); $dsedit = query("select * from alarms where id=" . $id . " and clientid = " . Session("client_id")); $tipotnaAlarmot = pg_fetch_result($dsedit, 0, "poiid"); ?> <script type="text/javascript">
<?php include "../include/db.php"; include "../include/functions.php"; include "../include/params.php"; include "../include/dictionary2.php"; ?> <?php session_start(); header("Content-type: text/html; charset=utf-8"); ?> <?php $datetime = getQUERY("dt"); $driver = nnull(getQUERY("driver"), ""); $veh = getQUERY("veh"); $km = getQUERY("km"); $type = getQUERY("type"); $loc = getQUERY("loc"); $desc = getQUERY("desc"); $comp = getQUERY("comp"); $price = getQUERY("price"); $pay = getQUERY("pay"); if (is_numeric($km) == false) { $km = "0"; } if (is_numeric($price) == false) { $price = "0"; } if ($type == 0) { $type = "Associate";
if (session('user_id') == "261") { echo header('Location: ../sessionexpired/?l=' . $cLang); } if (!is_numeric(session('user_id'))) { echo header('Location: ../sessionexpired/?l=' . $cLang); } $user_id = session("user_id"); $client_id = session("client_id"); opendb(); $dsAll = query("select defaultmap, datetimeformat, timezone, idleover, metric, cl.clienttypeid, ci.latitude, ci.longitude, cl.allowedrouting, cl.allowedfm, cl.allowedmess, cl.allowedalarms from users u left outer join clients cl on cl.id = u.clientid left outer join cities ci on ci.id = cl.cityid where u.id = " . $user_id); $allowedrouting = pg_fetch_result($dsAll, 0, "allowedrouting"); $allowedFM = pg_fetch_result($dsAll, 0, "allowedfm"); $allowedMess = pg_fetch_result($dsAll, 0, "allowedmess"); $allowedAlarms = pg_fetch_result($dsAll, 0, "allowedalarms"); $vh = nnull(getQUERY("v"), "0"); $mins = nnull(getQUERY("mins"), "0"); $DefMap = pg_fetch_result($dsAll, 0, "defaultmap"); $clientUnit = pg_fetch_result($dsAll, 0, "metric"); //$DefMap = "GOOGLEM"; $CPosition = ""; $strLon = ""; $strLat = ""; $AllowedMaps = ""; $MinMin = 1; $strTaxi = ""; $strPas = ""; $sLon = "21.432767"; $sLat = "41.996434"; $isEmpty = 0; $cntIgn = dlookup("select count(portname) from vehicleport where vehicleid=" . $vh . " and porttypeid=1"); if ($cntIgn == 0) {
$sql_ .= "left outer join vehicles v on v.id=hl.vehicleid "; $sql_ .= "where hl.datetime='" . $dat . "' and hl.vehicleid=" . $vehID; //$strLM = "select status, latitude, longitude, speed, " . $ign . " ignition, location, poinames, poiids from historylog where datetime='" . $dat . "' and vehicleid=" . $vehID; $dsH = query($sql_); //echo "select status, latitude, longitude, speed, " . $ign . " ignition, location, poinames, poiids from historylog where datetime='" . $dat . "' and vehicleid=" . $vehID; //exit; $status = pg_fetch_result($dsH, 0, "status"); $speed = pg_fetch_result($dsH, 0, "speed"); $sedista = pg_fetch_result($dsH, 0, "sedista"); $location = pg_fetch_result($dsH, 0, "location"); $poiname = pg_fetch_result($dsH, 0, "poinames"); $poiids = pg_fetch_result($dsH, 0, "poiids"); $ignition = pg_fetch_result($dsH, 0, $ign); $sLon = pg_fetch_result($dsH, 0, "longitude"); $sLat = pg_fetch_result($dsH, 0, "latitude"); $tzone = nnull(dlookup("select timezone from users where id=" . $uid), 1); $tzone = $tzone - 1; $DFormat1 = "dd-MM-yyyy"; //nnull(dlookup("select DateFormat from usersettings where userid=" . $uid),"dd-MM-yyyy"); $TFormat1 = "24 Hour Time"; //nnull(dlookup("select TimeFormat from usersettings where userid=" . $uid),"24 Hour Time"); $TFormat = ""; $DFormat = ""; if ($DFormat1 == "dd-MM-yyyy") { $DFormat = "d-m-Y"; } else { if ($DFormat1 == "yyyy-MM-dd") { $DFormat = "Y-m-d"; } else { $DFormat = "m-d-Y"; }
<td align=center style="background-color:#E5E3E3; border:1px dotted #2f5185; width:67px; color:#ff6633; font-weight:bold;"><?php dic("Fm.Delete") ?></td> </tr> <?php while ($drAd=pg_fetch_array($dsAD)) { $idDriver = $drAd["driverid"]; $cntDr = dlookup("select count(*) from drivers where ID=" . $idDriver); $sqlDrivers = "select fullname, code from drivers where id=" . $idDriver; $dsDrivers = query($sqlDrivers); If ($cntDr > 0) { //drDrivers = dsDrivers.Tables(0).Rows(0) ?> <tr id="tr<?php echo $cnt ?>" style=" color: #2F5185; font-family: Arial,Helvetica,sans-serif; font-size: 11px; "> <td height=25px align=left style="background-color:#fff; border:1px dotted #B8B8B8; padding-left:10px"><?php echo nnull(pg_fetch_result($dsDrivers, 0, "code"), "/") ?></td> <td height=25px align=left style="background-color:#fff; border:1px dotted #B8B8B8; padding-left:10px; width:200px"><?php echo nnull(pg_fetch_result($dsDrivers, 0, "fullname"), "/") ?></td> <td height=25px align=center style="background-color:#fff; border:1px dotted #B8B8B8; "> <button id="btn<?php echo $cnt ?>" class="btn-driver" style="height:27px; margin-left:8px; margin-right:8px; width:30px" onclick="DelAllowedDriver(<?php echo $cnt ?>, <?php echo $drAd["id"] ?>)"></button> </td> </tr> <?php $cnt = $cnt + 1; } //end if } //end while } else { ?> <tr><td colspan=3 class="text2" style="font-style:italic"><?php dic("Fm.NoAllDrivers") ?></td></tr> <?php
$clienttypeid = dlookup("select clienttypeid from clients where id = " . $cid); $holidays = nnull(getQUERY("holidays"), ''); if ($holidays == 1) { $dsNonworkingdays = query("select * from nonworkingdays where active='1' and datetime between '" . DateTimeFormat(now(), 'Y') . '-01-01' . " 00:00:00' and '" . DateTimeFormat(now(), 'Y') . '-12-31' . " 23:59:59'"); while ($drHoliday = pg_fetch_array($dsNonworkingdays)) { $sdH = DateTimeFormat($drHoliday["datetime"], 'Y-m-d 00:00:00'); $edH = DateTimeFormat($drHoliday["datetime"], 'Y-m-d 23:59:59'); //$r = runsql("insert into test1(lastitem, dt) values ('".$sdH . " - ".$edH . "', '1900-01-01')"); $ret = query("select cachereportsparams('" . $sdH . "', '" . $edH . "', ' clientid = " . $cid . "')"); if ($clienttypeid == 2) { $ret = query("select cachetaxiparams1('" . $sdH . "', '" . $edH . "', ' clientid = " . $cid . "')"); $ret = query("select cachetaxiparams2('" . $sdH . "', '" . $edH . "', ' clientid = " . $cid . "')"); } } } else { $date = nnull(getQUERY("date"), ''); if ($date != '') { $date = DateTimeFormat($date, 'Y-m-d'); $sd = $date . " 00:00:00"; $ed = $date . " 23:59:59"; $ret = query("select cachereportsparams('" . $sd . "', '" . $ed . "', ' clientid = " . $cid . "')"); if ($clienttypeid == 2) { $ret = query("select cachetaxiparams1('" . $sd . "', '" . $ed . "', ' clientid = " . $cid . "')"); $ret = query("select cachetaxiparams2('" . $sd . "', '" . $ed . "', ' clientid = " . $cid . "')"); } } else { $dayType = getQUERY("dayType"); $from = '00:00:00'; //getQUERY("from"); $to = '23:59:59'; //getQUERY("to");
<br>max: <?php $maxspeed = nnull(round(dlookup("select MAX(speed)from rMaxSpeed where Datetime>='" . DateTimeFormat(now(), "Y-m-d 00:00:00") . "' and Datetime<='" . DateTimeFormat(now(), "Y-m-d H:i:s") . "' and vehicleID=" . $drVehicle["id"])), "/"); echo $maxspeed; if ($maxspeed != "/") { echo " Km/h"; } ?> </div> </td> <!--td width=80px style="font-size:11px" align="center" class="corner5 text5 <?php echo $classTr; ?> "> <div> <?php $maxspeed = nnull(round(dlookup("select MAX(speed)from rMaxSpeed where Datetime>='" . DateTimeFormat(now(), "Y-m-d 00:00:00") . "' and Datetime<='" . DateTimeFormat(now(), "Y-m-d H:i:s") . "' and vehicleID=" . $drVehicle["id"])), "/"); echo $maxspeed; if ($maxspeed != "/") { echo " Km/h"; } ?> </div> </td--> <?php if ($clientType == 2) { $dsTaxiData = query("select count(*) cnt, sum(price) price, sum(pricewith) pricewith from reporttaxi where vehicleid=" . $drVehicle["id"] . " and startdate between '" . DateTimeFormat(now(), "Y-m-d 00:00:00") . "' and '" . DateTimeFormat(now(), "Y-m-d H:i:s") . "'"); ?> <td width=60px style="font-size:11px" align="center" class="corner5 text5 <?php echo $classTr; ?> "><div><?php
}); </script> <script type="text/javascript" src="../js/OpenLayers.js"></script> <!--Marjan--> <link rel="stylesheet" href="../css/mlColorPicker.css" type="text/css" media="screen" charset="utf-8" /> <script type="text/javascript" src="../js/mlColorPicker.js"></script> <!--Marjan--> <script type="text/javascript"> top.ShowWait(); </script> <?php opendb(); $DefMap = nnull(dlookup("select defaultmap from users where id=" . session("user_id")), 1); $cntz = dlookup("select count(*) from pointsofinterest where clientid=" . session("client_id")); $dsStartLL = query("select * from cities where id = (select cityid from clients where id=" . session("client_id") . " limit 1)"); $idGroup = getQUERY("id"); $cntRows1 = dlookup("select count(*) from pointsofinterest where type = 1 and groupid=" . $idGroup); $cntRows2 = dlookup("select count(*) from pointsofinterest where type = 2 and groupid=" . $idGroup); $glavnoQuery = query("select st_x(st_transform(geom, 4326)) lon, st_y(st_transform(geom, 4326)) lat, type,groupid from pointsofinterest where type = 1 and groupid =" . $idGroup); $type = pg_fetch_result($glavnoQuery, 0, "type"); if ($type == "1") { $dsPp = query("select id,st_x(st_transform(geom, 4326)) lon, st_y(st_transform(geom, 4326)) lat, type,groupid from pointsofinterest where type = 1 and groupid =" . $idGroup); $idTocka = pg_fetch_result($dsPp, 0, "id"); $boicka = pg_fetch_result($dsPp, 0, "groupid"); if ($boicka == "1") { $boja2 = "ff0000"; } else { $boja = query("select * from pointsofinterestgroups where clientid=" . session("client_id") . " and id = " . $boicka . "");
<td class="text2 td-row" style="color:<?php echo $fontVeh?>" onclick="hideVeh(<?php echo $tableRow['data']["id"] ?>)"> <?php echo $tableRow['vreg']; ?> </td> <td class="text2 td-row la" style="line-height:15px;"> <?php if($tableRow['data']["emails"]!="") echo str_replace(',', '<br>', $tableRow['data']["emails"]); // nema potreba od else ?> </td> <?php if ($clienttypeid == 6) { ?> <td class="text2 td-row la"> <?php echo nnull($tableRow['data']["sms"], "/")?> </td> <?php } ?> <?php if ($allowedSMSvEmail == 1) { ?> <td class="text2 td-row la"> <?php if($tableRow['data']["smsviaemail"] != null) { $gsse = explode('@',$tableRow['data']["smsviaemail"]); echo $gsse[0] . "<br>"; echo "(<b>" . dlookup("select name from operators where email='" . $gsse[1] . "'") . "</b>)"; } else echo "/"; ?> </td>
<?php include "../include/db.php"; include "../include/functions.php"; include "../include/params.php"; include "../include/dictionary2.php"; ?> <?php session_start(); header("Content-type: text/html; charset=utf-8"); ?> <?php $driverID = nnull(getQUERY("driID"), ""); opendb(); $payStr = ""; $payStr .= "<option value='g'>Готово</option>"; $payStr .= "<option value='f'>Фактура</option>"; if ($driverID != "") { $cntCards = dlookup("select count(*) from drivercard where driverid= " . $driverID); } else { $cntCards = 0; } if ($cntCards > 0) { $dsCards = query("select * from drivercard where driverid= " . $driverID); while ($drCards = pg_fetch_array($dsCards)) { $nameCard = dlookup("select cardname from clubcards where id=" . $drCards["cardid"]); $cardID = $drCards["cardid"]; //$payStr .= "<option value='k-" . $cardID . "' selected='selected'>" . $nameCard . "</option>"; $payStr .= "<option value='k-" . $cardID . "' >" . $nameCard . "</option>"; }
$sql_ .= "left outer join vehicles v on v.id=hl.vehicleid "; $sql_ .= "where hl.datetime='" . $dat . "' and hl.vehicleid=" . $vehID; //$strLM = "select status, latitude, longitude, speed, " . $ign . " ignition, location, poinames, poiids from historylog where datetime='" . $dat . "' and vehicleid=" . $vehID; $dsH = query($sql_); //echo "select status, latitude, longitude, speed, " . $ign . " ignition, location, poinames, poiids from historylog where datetime='" . $dat . "' and vehicleid=" . $vehID; //exit; $status = pg_fetch_result($dsH, 0, "status"); $speed = pg_fetch_result($dsH, 0, "speed"); $sedista = pg_fetch_result($dsH, 0, "sedista"); $location = pg_fetch_result($dsH, 0, "location"); $poiname = pg_fetch_result($dsH, 0, "poinames"); $poiids = pg_fetch_result($dsH, 0, "poiids"); $ignition = pg_fetch_result($dsH, 0, $ign); $sLon = pg_fetch_result($dsH, 0, "longitude"); $sLat = pg_fetch_result($dsH, 0, "latitude"); $tzone = nnull(dlookup("select timezone from users where id=" . session("user_id")), 1); $tzone = $tzone - 1; $DFormat1 = "dd-MM-yyyy"; //nnull(dlookup("select DateFormat from usersettings where userid=" . session("user_id")),"dd-MM-yyyy"); $TFormat1 = "24 Hour Time"; //nnull(dlookup("select TimeFormat from usersettings where userid=" . session("user_id")),"24 Hour Time"); $TFormat = ""; $DFormat = ""; if ($DFormat1 == "dd-MM-yyyy") { $DFormat = "d-m-Y"; } else { if ($DFormat1 == "yyyy-MM-dd") { $DFormat = "Y-m-d"; } else { $DFormat = "m-d-Y"; }
?> </td> <td colspan=2><?php echo $act; ?> </td> <td colspan=2><?php echo $desc; ?> </td> <td><?php echo nnull($drData["ipaddress"], "/"); ?> </td> <td colspan=6><?php echo nnull($drData["notes"], "/"); ?> </td> </tr> <?php $cnt++; } //end while } else { ?> <tr> <td colspan=13><strong><?php echo DateTimeFormat($_datumCnt, "d") . " " . dic_("Reports." . $meseci[intval(DateTimeFormat($_datumCnt, "m")) - 1] . "") . " " . DateTimeFormat($_datumCnt, "Y"); ?> <?php
<?php include "../include/functions.php"; include "../include/db.php"; ?> <?php include "../include/params.php"; include "../include/dictionary2.php"; set_time_limit(0); opendb(); $directionname = nnull(utf8_urldecode(getQUERY('directionname')), ""); $startgoogleaddress = nnull(utf8_urldecode(getQUERY('startgoogleaddress')), ""); $startgeocodeaddress = nnull(utf8_urldecode(getQUERY('startgeocodeaddress')), ""); $startlongitude = getQUERY("startlongitude"); $startlatitude = getQUERY("startlatitude"); $endgoogleaddress = nnull(utf8_urldecode(getQUERY('endgoogleaddress')), ""); $endgeocodeaddress = nnull(utf8_urldecode(getQUERY('endgeocodeaddress')), ""); $endlongitude = getQUERY("endlongitude"); $endlatitude = getQUERY("endlatitude"); $shortlineid = getQUERY('shortlineid'); $fastlineid = getQUERY('fastlineid'); $sqlAddDirection = "insert into directions (userid, clientid, directionname, startgoogleaddress, startgeocodeaddress, \r\n startlongitude, startlatitude, endgoogleaddress, endgeocodeaddress, \r\n endlongitude, endlatitude, shortlineid, fastlineid) values"; $sqlAddDirection .= "(" . session("user_id") . ", " . session("client_id") . ", '" . $directionname . "'"; $sqlAddDirection .= ",'" . $startgoogleaddress . "', '" . $startgeocodeaddress . "', " . $startlongitude; $sqlAddDirection .= "," . $startlatitude . ", '" . $endgoogleaddress . "', '" . $endgeocodeaddress . "'"; $sqlAddDirection .= "," . $endlongitude . ", " . $endlatitude . ", " . $shortlineid . ", " . $fastlineid . ")"; //echo $sqlAddDirection; $retID = RunSQL($sqlAddDirection); echo $retID; closedb(); exit;
} $toobject = nnull(getQUERY("toobj"), ""); $flag = '0'; $delivery = ""; $deliverycoll = ""; if ($action == 'user') { $fromid = session("user_id"); if ($toobject == 'vehicle') { $toid = nnull(getQUERY("toid"), ""); $toid = dlookup("select id from vehicles where gsmnumber='" . $toid . "'"); } else { $flag = '1'; $toid = nnull(getQUERY("toid"), ""); $delivery = ", now()"; $deliverycoll = ", dtdelivery"; } $garminid = dlookup("select coalesce((select garminid from messages where toid=" . $toid . " order by datetime desc limit 1), 0)"); $garminid = $garminid + 1; } $clientid = session("client_id"); $userid = session("user_id"); $datetime = nnull(getQUERY("dt"), now()); //$datetime = now(); $subject = nnull(getQUERY("subject"), ""); $body = nnull(utf8_urldecode(getQUERY("body")), ""); $checked = '0'; RunSQL("INSERT INTO messages (fromid, toobject, toid, clientid, userid, datetime, subject, body, checked, garminid, flag" . $deliverycoll . ") \r\n\t VALUES (" . $fromid . ", '" . $toobject . "', " . $toid . ", " . $clientid . ", " . $userid . ", \r\n\t '" . $datetime . "', '" . $subject . "', '" . $body . "', " . $checked . ", " . $garminid . ", '" . $flag . "'" . $delivery . ")"); closedb(); echo $garminid; //echo 54336; exit;
<?php $rep = getQUERY("rep"); $veh = getQUERY("veh"); $range = getQUERY("range"); $per = getQUERY("per"); $day = getQUERY("day"); $date1 = getQUERY("date1"); $saati = getQUERY("saati"); $email = getQUERY("email"); $uid = getQUERY("uid"); $path = getQUERY("path"); $doctype = getQUERY("doctype"); $Today = DateTimeFormat(now(), "Y-m-d H:i:s"); opendb(); $vehID = nnull(dlookup("select id from vehicles where registration = '" . $veh . "'"), 0); $dayInsert = ""; if ($per == "Weekly") { $dayInsert = $day; } if ($per == "Daily") { $dayInsert = ""; } if ($per == "Monthly") { $dayInsert = $date1; } $time = $saati . ":00"; /* echo "insert into Scheduler (clientID, userID, report, vehicle, period, day, time, email, subusers, range, vehID, path, CreationDate) values(" . Session("client_id") . "," . $uid . ", '" . $rep . "','" . $veh . "','" . $per . "','" . $dayInsert . "','" . $time . "','" . $email . "','', '" . $range . "', '" . $vehID . "', '" . $path . "', '" . $Today . "');";
<?php include "../include/db.php"; include "../include/functions.php"; include "../include/params.php"; include "../include/dictionary2.php"; ?> <?php header("Content-type: text/html; charset=utf-8"); ?> <?php opendb(); $action = nnull(getQUERY("action"), ""); if ($action == 'delete') { } if ($action == 'read') { } closedb(); exit;
} else { $greenCard = "../images/stikla3.png"; $actYN = 0; } if ($rV["visible"] == 1) { $activity = "../images/stikla2.png"; } else { $activity = "../images/stikla3.png"; } $_lastReg = explode(" ", DateTimeFormat($rV["lastregistration"], "d-m-Y")); $lastReg = $_lastReg[0]; $fuelType = query("select name from fueltypes where id = (select fueltypeid from vehicles where id=" . $rV["id"] . ")"); $row1 = pg_fetch_array($fuelType); $ld = query('select "DateTime" from currentposition where vehicleid=' . $rV["id"]); if (pg_num_rows($ld) > 0) { $lastDate = nnull(pg_fetch_result($ld, 0, 0), "/"); } else { $lastDate = "/"; } if ($lastDate != "/") { $lastDate = DateTimeFormat($lastDate, 'd-m-Y H:i:s'); } $color = ""; if ($lastDate != "/") { if (round(abs(strtotime(now()) - strtotime($lastDate)) / 60) > 1440) { $color = "red"; } else { $color = "green"; } } ?>
<?php if($row3["emails"]!="") { echo $row3["emails"]; } else { ?> <?php } ?> </td> <?php if ($clienttypeid == 6) { ?> <td align = "left" height="30px" class="text2" style="padding-left:10px; background-color:#fff; border:1px dotted #B8B8B8; "> <?= nnull($row3["sms"], "/")?> </td> <?php } ?> <td align = "center" height="30px" class="text2" style="background-color:#fff; border:1px dotted #B8B8B8; "> <?php echo dic_("Settings.Sound") . " " . $row3["soundid"]; ?> <?php $snoozeNajdi = query("select * from users where id=" . session("user_id") .""); $snoozot = pg_fetch_result($snoozeNajdi, 0, "snooze"); if($snoozot==0) { echo dic("Settings.NoRepetition"); }
<div onmouseover="MouseOverOptions('vehOption-<?php echo $row["code"]?>','<?php echo $row["vehicleid"]?>')" id="" style="background-color: #fafafa; width:205px; padding-left:5px; padding-right:5px; padding-top:2px; padding-bottom:2px; float:left; color:#333333; font-size:10px; border-top:1px dotted #333"> <?php echo dic("Reports.Alias")?>: <span style="font-weight: bold" id="vh-alias-<?php echo $row["code"]?>"><?php echo $row["alias"]?></span> </div> <?php } if($row["allowcamera"].'' == '1') { if (dlookup("select count(*) from camera where vehicleid=".$row["vehicleid"]."") > 0) { $dsLastPhoto = query("select * from camera where vehicleid=".$row["vehicleid"]." order by datetime desc limit 1"); $camImg = pg_fetch_result($dsLastPhoto, 0, "image"); $camTime = DateTimeFormat(pg_fetch_result($dsLastPhoto, 0, "datetime"), $dtformat); } else { $camImg = ""; $camTime = ""; } $checkCamera = nnull(dlookup("select count(*) from cameravehicle where vehicleid=".$row["vehicleid"]." and datetime between '".DateTimeFormat(now(), '"Y-m-d 00:00:00"')."' and '".DateTimeFormat(now(), '"Y-m-d 23:59:59"')."'"), 0); ?> <div onmouseover="MouseOverOptions('vehOption-<?php echo $row["code"]?>','<?php echo $row["vehicleid"]?>')" id="" style="background-color: #fafafa; width:205px; padding-left:5px; padding-right:5px; padding-top:1px; padding-bottom:1px; float:left; color:#333333; font-size:10px; border-top:1px dotted #333"> <span style="position: relative; top: 2px;" id="vh-image-<?php echo $row["code"]?>"><?= dic_("Reports.LastPhoto")?>: </span> <!--img style="cursor: pointer; position: relative; float: right; margin-top: -1px;" onclick="newImageFromCamera('<?=$row["gsmnumber"]?>', '<?=$row["code"]?>')" onmouseover="ShowPopup(event, 'Кликнете за нова слика')" onmouseout="HidePopup()" width="18px;" src="../images/camera2.png" /--> <img id="camera-<?=$row["vehicleid"]?>" style="cursor: pointer; position: relative; float: right; margin-top: -1px;" onclick="openCameraWindow('<?=$row["gsmnumber"]?>', '<?=$row["code"]?>', '<?= $camImg ?>', '<?= $camTime ?>', <?=$checkCamera?>)" onmouseover="ShowPopup(event, '<?= dic_("Reports.ClickNewPhoto")?>')" onmouseout="HidePopup()" width="18px;" src="../images/camera2.png" /> <img id="vh-img-newimage-<?= $row["code"]?>" src="../images/smallref.gif" width="17px" style="display:none; position: relative; float: right; right: 3px;" /> </div> <?php } if($ClientTypeID != "3" && $ClientTypeID != "7") { ?> <div onmouseover="MouseOverOptions('vehOption-<?php echo $row["code"]?>','<?php echo $row["vehicleid"]?>')" id="" style="height: 12px; background-color: #fafafa; width:205px; padding-left:5px; padding-right:5px; padding-top:2px; padding-bottom:2px; float:left; color:#333333; font-size:10px; border-top:1px dotted #333"> <?php echo dic_("Tracking.Driver") ?>: <span style="font-weight: bold" id="vh-driver-<?php echo $row["code"]?>"><?php echo $strDrivName ?></span> </div> <div onmouseover="MouseOverOptions('vehOption-<?php echo $row["code"]?>','<?php echo $row["vehicleid"]?>')" id="div-driverdest-<?php echo $row["code"]?>" style="<?=$driverDestStyle?>; height: 12px; background-color: #fafafa; width:205px; padding-left:5px; padding-right:5px; padding-top:2px; padding-bottom:2px; float:left; color:#333333; font-size:10px; border-top:1px dotted #333">
</head> <?php opendb(); if (nnull(is_numeric(nnull(getQUERY("u"))), 0) > 0) { $uid = getQUERY("u"); $cid = getQUERY("c"); } else { $uid = session("user_id"); $cid = session("client_id"); } $_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"); $_SESSION['role_id'] = nnull(dlookup("select roleid from users where id=" . $uid), 0); $roleid = session("role_id"); $sqlU1 = "select id, fullname from users where clientID=" . $cid; if ($roleid == "2") { $sqlU = "select id from users where clientID=" . $cid; } else { $sqlU = "select id from users where id=" . $uid; } $cLang = getQUERY("l"); $datetimeformat = dlookup("select datetimeformat from users where id=" . $uid); $datfor = explode(" ", $datetimeformat); $dateformat = $datfor[0]; $timeformat = $datfor[1]; if ($timeformat == "H:i:s") { $e_ = " 23:59"; $e1_ = "_23:59";
include "../include/functions.php"; include "../include/params.php"; include "../include/dictionary2.php"; ?> <?php session_start(); header("Content-type: text/html; charset=utf-8"); ?> <?php $id = getQUERY("id"); $reg = getQUERY("reg"); $code = getQUERY("code"); $orgUnit = nnull(getQUERY("orgUnit"), 0); $model = getQUERY("model"); $AliasName = getQUERY("prekar"); $fuelType = getQUERY("fuelType"); $chassis = getQUERY("chassis"); $motor = getQUERY("motor"); $firstReg = DateTimeFormat(getQUERY("firstReg"), "Y-m-d"); $lastReg = DateTimeFormat(getQUERY("lastReg"), "Y-m-d"); $greenCard = getQUERY("greenCard"); $activity = getQUERY("activity"); $range = str_replace(",", ".", NNull($_GET['range'], '')); if ($range == "") { $range = 0; } $capacity = getQUERY("capacity"); if (is_numeric($capacity) == false) {