$today = getdate();
$q = '' . $today[0];
$orgEdinica = str_replace("'", "''", NNull($_GET['orgEdinica2'], ''));
$najdiVozila = query("select * from vehicles where organisationid = " . $orgEdinica . " and clientid = " . $cid);
$brisi = query("delete from alarms where id = " . $id . " and clientid = " . $cid . "");
while ($row = pg_fetch_array($najdiVozila)) {
$data[] = $row;
}
foreach ($data as $row) {
$posledno = dlookup("select Max(id)+1 from alarms");
$ret = query("insert into alarms values('" . $posledno . "','" . $tipNaAlarm . "','" . $orgEdinica . "','" . $dostapno . "','" . $emails . "','" . $sms . "','" . $zvukot . "',1," . Session("client_id") . " , '" . $row["id"] . "',NULL,NULL,NULL,'" . $q . "', 2)");
//RunSQL("update alarms set alarmtypeid = '" . $tipNaAlarm . "',settings = ".$orgEdinica." , available ='" . $dostapno . "', emails ='" . $emails . "', sms = '" .$sms. "',soundid = '" .$zvukot. "',vehicleid = ".$row["id"].",speed = null,poiid = null,timeofpoi = null,uniqid = ".$q.",typeofgroup = 2 where id = '" . $id . "' and clientid =" .$cid);
}
}
if ($vnesiAlertZa == 3) {
$today = getdate();
$q = '' . $today[0];
$najdiVozila = query("select * from vehicles where clientid = " . $cid);
$brisi = query("delete from alarms where id = " . $id . " and clientid = " . $cid . "");
while ($row = pg_fetch_array($najdiVozila)) {
$data[] = $row;
}
foreach ($data as $row) {
$posledno = dlookup("select Max(id)+1 from alarms");
$ret = query("insert into alarms values('" . $posledno . "','" . $tipNaAlarm . "','','" . $dostapno . "','" . $emails . "','" . $sms . "','" . $zvukot . "',1," . Session("client_id") . " , '" . $row["id"] . "',NULL ,NULL ,NULL ,'" . $q . "', 3)");
//RunSQL("update alarms set alarmtypeid = '" . $tipNaAlarm . "',settings = null , available ='" . $dostapno . "', emails ='" . $emails . "', sms = '" .$sms. "',soundid = '" .$zvukot. "',vehicleid = ".$row["id"].",speed = null,poiid = null,timeofpoi = null,uniqid = ".$q.",typeofgroup = 3 where id = '" . $id . "' and clientid =" .$cid);
}
}
}
}
closedb();
function combat_ticker($alliances, $users)
{
$week = dlookup("week", "timeinfo");
foreach ($users as $uid => $count) {
ticker($uid, "*lbattlereport.php?act=show_own&_minw={$week}&_maxw={$week}*You were involved in " . $count . " battles!", "a");
}
foreach ($alliances as $aid => $count) {
$members = get_alliance_members($aid);
foreach ($members as $uid => $name) {
// mop: gabs ausser den eigenen auch noch kämpfe?
if ($count - $users[$uid] > 0) {
ticker($uid, "*lbattlereport.php?act=show_alliance&_minw={$week}&_maxw={$week}*Your alliance was involved in " . ($count - $users[$uid]) . " battles!", "a");
}
}
}
}
<?php
while ($drData = pg_fetch_array($dsData)) {
$tmpIDA = explode(",", $idUsers);
$ifNE = true;
for ($ch = 0; $ch < sizeof($tmpIDA); $ch++) {
if ($drData["userid"] == $tmpIDA[$ch]) {
$ifNE = false;
break;
}
}
if ($ifNE) {
$idUsers .= $drData["userid"] . ",";
}
$LastDay = DatetimeFormat(addDay(-1), 'd-m-Y');
$dt = DateTimeFormat(nnull($LastDay, "01-01-1900"), "Y-m-d" . " 00:00:00");
$user = dlookup("select fullname from users where id=" . $drData["userid"]);
$desc = nnull($drData["description"], "/");
$act = "";
if (nnull($drData["activity"], "/") != "/") {
$actarr = explode("/", $drData["activity"]);
if (count($actarr) > 1) {
$actarr = array_reverse($actarr);
for ($i = 0; $i < count($actarr); $i++) {
$act .= " -> " . dic_($actarr[$i]);
}
} else {
$act .= " -> " . dic_($drData["activity"]);
}
}
$act = substr($act, 4);
?>
function createXls()
{
$page = getQUERY("page");
$from = getQUERY("from");
$page1 = $page;
$req = getQUERY("req");
$req1 = str_replace("**", "&", $req);
$url = "";
$temp = explode("&", $req1);
$cid = getQUERY("c");
$uid = getQUERY("u");
$sd = substr($temp[1], 3);
$ed = substr($temp[2], 3);
$lang = substr($temp[0], 2);
opendb();
/* format na datum */
$datetimeformat = dlookup("select datetimeformat from users where id=" . $uid);
//'Y-m-d h:i:s a'; //
$datfor = explode(" ", $datetimeformat);
$dateformat = $datfor[0];
$timeformat = $datfor[1];
if ($timeformat == "H:i:s") {
$e_ = " 23:59";
$e1_ = "_23:59";
$s_ = " 00:00";
$s1_ = "_00:00";
$tf = " H:i";
} else {
$e_ = " 11:59 PM";
$e1_ = "_11:59_PM";
$s_ = " 12:00 AM";
$s1_ = "_12:00_AM";
$tf = " h:i a";
}
$sdG = DateTimeFormat($sd, 'd-m-Y H:i:s');
$edG = DateTimeFormat($ed, 'd-m-Y H:i:s');
/* format na datum */
$nameXls = $page1 . '_' . $cid . '_' . DateTimeFormat($sdG, $dateformat) . $s1_ . '_' . DateTimeFormat($edG, $dateformat) . $e1_ . '.xls';
$url = $page . "1.php?l=" . $lang . "&u=" . $uid . "&c=" . $cid . "&sd=" . DateTimeFormat($sd, "d-m-Y") . "%2000:00:00&ed=" . DateTimeFormat($ed, "d-m-Y") . "%2023:59:00&from=s";
closedb();
if ($from == "s") {
$handle = fopen('../savePDF/' . $nameXls, 'w+') or die('Cannot open file: ' . $nameXls);
$data = file_get_contents("http://panorama.gps.mk/settings/" . $url);
fwrite($handle, $data);
fclose($handle);
echo $nameXls;
}
}
if ($lastNalog == '' or $lastNalog != $drActivity["orderno"]) {
$nalogname1 = dlookup("select name from rnalogheder where id = " . $drActivity["orderno"]);
$culid1 = dlookup("select culid from rnalogheder where id = " . $drActivity["orderno"]);
$culid2 = dlookup("select culid from route_defculture where id = " . $culid1);
$culname = dlookup("select name from route_culture where id = " . $culid2);
$nalogname = "<font style='font-size:16px'>Налог број: <strong>" . $drActivity["orderno"] . "</strong>";
if ($nalogname1 != "") {
$nalogname .= ' (<strong>' . $nalogname1 . '</strong>)</font>';
}
//$culture = dlookup("select coalesce((select name from route_culture where id = " . $drActivity["culid"] . "), '/')");
$nalogname .= "<font style='font-style:italic'><br>Култура: <strong>" . $culname . "</strong>";
$operation = dlookup("select coalesce((select name from route_operation where id = " . $drActivity["operid"] . "), '/')");
$nalogname .= "<font style='font-style:italic'> Операција: <strong>" . $operation . "</strong>";
$material = dlookup("select coalesce((select name from route_material where id = " . $drActivity["matid"] . "), '/')");
$nalogname .= " Материјал: <strong>" . $material . "</strong>";
$mechanisation = dlookup("select coalesce((select name from route_mechanisation where id = " . $drActivity["mechid"] . "), '/')");
$nalogname .= " Механизација: <strong>" . $mechanisation . "</strong></font>";
?>
<tr><td colspan=8 height=25px></td></tr>
<tr>
<td valign="bottom" height="29px" style="color:#fff; font-size:14px; border:1px solid #ff6633; background-color:#f7962b; padding-bottom: 5px; padding-left: 10px " class="text2" colspan="8"><?php
echo $nalogname;
?>
</td>
</tr>
<tr>
<td width="5%" height="22px" align="center" style="background-color:#E5E3E3; border:1px dotted #2f5185" class="text2"><strong><?php
dic("Reports.Rbr");
?>
</strong></td>
$strSQL .= " and datetime > (select datetime from historylog where vehicleid = " . pg_fetch_result($dsv, 0, "id") . " and datetime <= now() + cast('" . $tzone1 . " hour' as interval) order by datetime desc limit 1)+cast('-' || (select trace from users where id=" . session("user_id") . ") || ' min' as interval)";
$strSQL .= " and datetime <= now() + cast('" . $tzone1 . " hour' as interval) order by datetime asc";
$ds = query($strSQL);
//"select latitude, longitude from historylog where vehicleid = " . pg_fetch_result($dsv, 0, "id") . " order by datetime desc");
$str1 = "";
$str2 = "";
$dist = "";
$dt = "";
$alpha = "";
$lastdt = "";
$lastLon = "";
$lastLat = "";
while ($row = pg_fetch_array($ds)) {
$dtTmp = new Datetime($row["datetime"]);
$dtTmp = $dtTmp->format($timeformat . " " . $dateformat);
$str1 .= "," . $row["longitude"];
$str2 .= "," . $row["latitude"];
if ($lastLon != "") {
$dist .= "," . dlookup("select dist_lonlat(" . $row["latitude"] . ", " . $row["longitude"] . ", " . $lastLat . ", " . $lastLon . ")");
$alpha .= "," . dlookup("select getalpha(" . $row["latitude"] . ", " . $row["longitude"] . ", " . $lastLat . ", " . $lastLon . ")");
$dt .= "," . $dtTmp;
// . " - " . $lastdt;
}
$lastLon = $row["longitude"];
$lastLat = $row["latitude"];
$lastdt = $dtTmp;
}
$str = $str2 . "#" . $str1 . "#" . $dist . "#" . $dt . "#" . $alpha;
print $str;
//print base64_encode(gzencode($str));
closedb();
function GetCurrentPosition($RoleID, $ClientID, $UserID)
{
//if($RoleID == "2")
$sqlV = "";
if ($RoleID == "2") {
$sqlV = "select id from vehicles where clientid=" . $ClientID;
} else {
$sqlV = "select vehicleid from uservehicles where userid=" . $UserID . "";
}
$ClientTypeID = dlookup("select clienttypeid from clients where id=" . $ClientID);
$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 ";
$sqlStyles .= "left outer join statuscolors c5 on c5.id=us.taximeteron ";
$sqlStyles .= "left outer join statuscolors c6 on c6.id=us.taximeteroffpassengeron ";
$sqlStyles .= "left outer join statuscolors c7 on c7.id=us.passiveon ";
$sqlStyles .= "left outer join statuscolors c8 on c8.id=us.activeoff ";
$sqlStyles .= "where us.id=" . $UserID;
$dsStyles = query($sqlStyles);
//$dsStyles = query("SELECT [c1].[name] [EngineON] from [UserSettings] [us] left outer join [Colors] [c1] on [c1].[id] = [us].[EngineON] where [us].[id]=506");
//echo "select * from (SELECT c1.name EngineON from UserSettings us left outer join Colors c1 on c1.id=us.EngineON where us.UserId=506) t";
//echo odbc_field_name($dsStyles, 1) ;
//exit;
$sql = "";
//$sql .= "select v.numberofvehicle, v.registration, geonet.dbo.fn_seats_goran(seats) sedista, cp.* ";
$sql .= "select cast(v.code as integer), v.registration, '1' sedista, cp.* ";
$sql .= "from currentposition cp ";
$sql .= "left outer join vehicles v on v.id=cp.vehicleid ";
$sql .= "where vehicleid in (" . $sqlV . ") order by cast(v.code as integer) asc";
$ds = query($sql);
$str = "";
if ($ClientTypeID == 2) {
//ako e taksi kompanija
while ($row = pg_fetch_array($ds)) {
$lon = $row["longitude"];
$lat = $row["latitude"];
//if($row["LongOrientation"] == "W") $lon = "-" . $lon;
//if($row["LatOrientation"] == "S") $lat = "-" . $lat;
$stil = "";
$row["sedista"] = NNull($row["sedista"], 0);
/*if($row["Ignition"]."" == "0" && $row["sedista"]."" == "0")*/
$stil = pg_fetch_result($dsStyles, 0, "EngineOFF");
//if($row["Ignition"]."" == "0" && $row["sedista"]."" <> "0") $stil = pg_fetch_result($dsStyles, 0, "EngineOFFPassengerON");
//if($row["Ignition"]."" == "1" && $row["sedista"]."" <> "0" && $row["Taximeter"]."" == "0") $stil = pg_fetch_result($dsStyles, 0, "TaximeterOFFPassengerON");
//if($row["Ignition"]."" == "1" && $row["Taximeter"]."" == "1") $stil = pg_fetch_result($dsStyles, 0, "TaximeterON");
//if($row["Ignition"]."" == "1" && $row["sedista"]."" == "0" and $row["Taximeter"]."" == "0") $stil = pg_fetch_result($dsStyles, 0, "EngineON");
//if($row["passive"]."" == "1") $stil = pg_fetch_result($dsStyles, 0, "PassiveON");
if ($row["status"] . "" == "0") {
$stil = pg_fetch_result($dsStyles, 0, "SatelliteOFF");
}
$str .= "#" . $row["code"] . "|" . $lon . "|" . $lat . "|" . "Gray" . "|" . $row["registration"];
}
} else {
// Ostanati
while ($row = pg_fetch_array($ds)) {
$lon = $row["longitude"];
$lat = $row["latitude"];
//if($row["LongOrientation"] == "W") $lon = "-" . $lon;
//if($row["LatOrientation"] == "S") $lat = "-" . $lat;
$stil = "";
/*if($row["Ignition"]."" == "0") */
$stil = pg_fetch_result($dsStyles, 0, "EngineON");
//if($row["Ignition"]."" == "1") $stil = pg_fetch_result($dsStyles, 0, "EngineOFF");
//if($row["status"] == "1") $stil = pg_fetch_result($dsStyles, 0, "SatelliteOFF");
$str .= "#" . $row["code"] . "|" . $lon . "|" . $lat . "|" . "Gray" . "|" . $row["registration"];
}
}
return $str;
}
<?php
include "../include/functions.php";
include "../include/db.php";
include "../include/params.php";
include "../include/dictionary2.php";
?>
<?php
$id = str_replace("'", "''", NNull($_GET['id'], ''));
opendb();
$kveri = query("select * from companydaysholiday where id = " . $id);
$idTO = pg_fetch_result($kveri, 0, "holidayid");
$proverka = dlookup("SELECT count(*) FROM companydays where typeofholiday = '" . $idTO . "' and clientid =" . Session("client_id"));
if ($proverka > 0) {
echo 1;
exit;
} else {
$brisi = query("Delete from companydaysholiday where id = " . $id . " and clientid =" . Session("client_id"));
}
closedb();
<?php
include "../include/functions.php";
include "../include/db.php";
?>
<?php
include "../include/params.php";
include "../include/dictionary2.php";
session_start();
header("Expires: Mon, 20 Jul 2000 05:00:00 GMT");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", FALSE);
header("Pragma: no-cache");
set_time_limit(0);
opendb();
$uid = str_replace("'", "''", NNull($_GET['uid'], ''));
//echo "select getGeocode(" . $lat . "," . $lon . ") geocode";
$temp = dlookup("select menuorder from users where id=" . $uid);
echo $temp;
closedb();
</script>
<?php
$id = str_replace("'", "''", NNull($_GET['id'], ''));
$dspoi = query("select id,name from pointsofinterest where id =" . $id . " and clientid = " . Session("client_id") . "order by name");
if (pg_num_rows($dspoi) == 0) {
echo dic("Settings.NemaPOI");
} else {
?>
<p><?php
echo dic("Settings.SelectPOI");
?>
</p>
<div id="allCheckboxes2">
<?php
while ($row = pg_fetch_array($dspoi)) {
$count = dlookup("select count(*) from pointsofinterest where id = " . $row["id"] . " and clientid =" . Session("client_id"));
if ($count == 1) {
?>
<input type="checkbox" checked="checked" id="<?php
echo $row["id"];
?>
" /><?php
echo $row["name"];
?>
<br />
<?php
} else {
?>
<input type="checkbox" id="<?php
echo $row["id"];
?>
?>
<?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>";
}
} else {
$dsCards = query("select * from clubcards where clientid= " . session("client_id") . " order by id asc");
while ($drCards = pg_fetch_array($dsCards)) {
$cardID = $drCards["id"];
$payStr .= "<option value='k-" . $cardID . "'>" . $drCards["cardname"] . "</option>";
}
}
closedb();
echo $payStr;
exit;
<?php
include "../include/functions.php";
include "../include/db.php";
?>
<?php
include "../include/params.php";
include "../include/dictionary2.php";
session_start();
$dat = getQUERY("dt");
$reg = getQUERY("reg");
$type = getQUERY("type");
$note = getQUERY("note");
//list($d, $m, $y) = explode('-', $dat);
//$a = explode(" ", $y);
//$d1 = explode(":", $a[1]);
//$d2 = explode(".", $d1[2]);
//echo $dat . "<br />";
//echo $d . "_" . $m . "_" . $a[0] . "_" . $d1[0] . "_" . $d1[1] . "_" . $d2[0] . "_" . $d2[1];
//exit;
opendb();
$vehID = dlookup("select id from vehicles where registration='" . $reg . "'");
RunSQL("update alarmshistory set note='" . $note . "' where datetime='" . $dat . "' and vehicleid=" . $vehID . " and name='" . $type . "'");
print "Ok";
closedb();
}
$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;
</strong></td>
</tr>
<?php
while ($drData = pg_fetch_array($dsData)) {
if ($drData["checked"] == "1") {
$viewed = "../images/messageread.png";
$style = "style='position:relative; left:-2px'";
} else {
$viewed = "../images/messageunread.png";
$style = "style='height:14px'";
}
$from = dlookup("select fullname from users where id=" . $drData["fromid"]);
if ($drData["toobject"] == 'user') {
$to = dlookup("select fullname from users where id=" . $drData["toid"]);
} else {
$to = dlookup("select registration from vehicles where id=" . $drData["toid"]);
}
?>
<tr class="<?php
echo $drData["userid"];
?>
" height=22px>
<!--<td align="center" style="background-color:#fff; border:1px dotted #B8B8B8;" class="text2" ><?php
echo $cnt;
?>
</td>-->
<td align="center" style="background-color:#fff; border:1px dotted #B8B8B8;" class="text2" ><img src=<?php
echo $viewed;
?>
<?php
<?php
include "../include/functions.php";
include "../include/db.php";
?>
<?php
include "../include/params.php";
include "../include/dictionary2.php";
?>
<?php
opendb();
?>
<?php
$id = str_replace("'", "''", NNull($_GET['id'], ''));
$mehanizacija = str_replace("'", "''", NNull($_GET['mehanizacijaIme'], ''));
$mehanizacijaRange = str_replace(",", ".", NNull($_GET['mehanizacijaRange'], ''));
if ($mehanizacijaRange == "") {
$mehanizacijaRange = 0;
}
$mehanizacijaCheck = dlookup("SELECT count(*) FROM route_mechanisation WHERE clientid = " . Session("client_id") . " and name = '" . $mehanizacija . "' and name not in (select name from route_mechanisation where id=" . $id . ")");
if ($mehanizacijaCheck > 0) {
echo 1;
} else {
$updt = query("update route_mechanisation set name = '" . $mehanizacija . "', range = " . $mehanizacijaRange . " where id = '" . $id . "' and clientid = " . Session("client_id"));
}
closedb();
<?php
include "../include/functions.php";
include "../include/db.php";
include "../include/params.php";
include "../include/dictionary2.php";
?>
<?php
opendb();
$vozacID = str_replace("'", "''", NNull($_GET['id'], ''));
$kartickaID = str_replace("'", "''", NNull($_GET['kartickataID'], ''));
$posledno = dlookup("select Max(id)+1 from drivercard");
$workCheck = dlookup("SELECT count(*) FROM drivercard WHERE driverid = '" . $vozacID . "' and cardid = " . $kartickaID);
if ($workCheck > 0) {
echo 1;
exit;
} else {
$vnesi = query("INSERT into drivercard(id,driverid,cardid) values ('" . $posledno . "','" . $vozacID . "'," . $kartickaID . "); ");
echo 0;
}
closedb();
$speed = '0 mph';
}
} else {
$speed = round(pg_fetch_result($dsCurrPos, 0, "speed"), 0) . ' Km/h';
if ($metric == "mi") {
$speed = round(round(pg_fetch_result($dsCurrPos, 0, "speed") * 0.621371 * 100) / 100) . ' mph';
}
}
}
?>
<?php
echo $speed;
?>
</span>
<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"])), "/");
if ($maxspeed != "/") {
if ($metric == "mi") {
$maxspeed = round(round($maxspeed * 0.621371 * 100) / 100) . ' mph';
} else {
$maxspeed .= " Km/h";
}
}
?>
<span id="spanMaxSpeed-<?php
echo $drVehicle["id"];
?>
" onmousemove="ShowPopup(event, '<span class=\'text5\'><?php
echo dic("Reports.MaxSpeedDay");
?>
</span>')" onmouseout="HidePopup()"><?php
if ($fromto == "inbox") {
$from = dlookup("select fullname from users where id=" . pg_fetch_result($mess, 0, "fromid"));
?>
<?php
echo dic_("Reports.From");
?>
: <strong><?php
echo $from;
?>
</strong>
<?php
} else {
if (pg_fetch_result($mess, 0, "toobject") == 'user') {
$to = dlookup("select fullname from users where id=" . pg_fetch_result($mess, 0, "toid"));
} else {
$to = dlookup("select registration from vehicles where id=" . pg_fetch_result($mess, 0, "toid"));
}
?>
<?php
echo dic_("Reports.To");
?>
: <strong><?php
echo $to;
?>
</strong>
<?php
}
?>
<br>
<?php
echo dic_("Reports.DateTime");
<select id="vozila" style="width: 365px;" class="combobox text2" onchange="OptionsChangeVehicle()">
<option value="0"><?php echo dic_("Tracking.SelectOption")?></option>
<option value="1"><?php echo dic_("Tracking.OneVehicle")?></option>
<?php
if (pg_num_rows(query($strOrg)) > 0) {
?>
<option value="2"><?php echo dic_("Tracking.VehInOrgU")?></option>
<?php
}
if ((dlookup("select count(*) from vehicles where clientID=" . session("client_id") . " and active='1'")) == pg_num_rows(query($strCom))) {
?>
<option value="3"><?php echo dic_("Tracking.AllVehCompany") ?></option>
<?php
}
?>
</select>
</div>
</td>
</tr>
<tr id="ednoVozilo" style="display:none;">
<td width = "25%" style="font-weight:bold" class ="text2" align="left"><?php echo dic_("Tracking.SelectVeh")?>:</td>
<td width = "75%" style="font-weight:bold" class ="text2">
* 9 - празник за еврејската заедница
* 10 - празник за бошњачката заедница
* 11 - празник за турската заедница
*
*/
$imePraznik = str_replace("'", "''", NNull($_GET['imePraznik'], ''));
$datum = DateTimeFormat(getQUERY("Datum"), 'Y-m-d');
opendb();
$tipDen = str_replace("'", "''", NNull($_GET['tipDen'], ''));
//$den = str_replace("'", "''", NNull($_GET['den'], ''));
$den = dlookup("select getdayofweek(cast('" . $datum . "' as date))");
$color = str_replace("'", "''", NNull($_GET['boja'], ''));
$tipPraznik = str_replace("'", "''", NNull($_GET['tipPraznik'], ''));
if ($tipDen == 8) {
$proverka = query("select * from companydays");
if (pg_num_rows($proverka) == 0) {
$vnes = query("insert into companydays(id,clientid,dayname,typeofday,datum,companyholiday,cellcolor\t,typeofholiday) values(1," . Session("client_id") . ",N'" . $imePraznik . "','" . $den . "','" . DateTimeFormat($datum, "Y-m-d") . "','" . $tipDen . "','#" . $color . "','" . $tipPraznik . "'); ");
} else {
$posledno = dlookup("select Max(id)+1 from companydays");
$vnes = query("insert into companydays(id,clientid,dayname,typeofday,datum,companyholiday,cellcolor,typeofholiday) values('" . $posledno . "'," . Session("client_id") . ",N'" . $imePraznik . "','" . $den . "','" . DateTimeFormat($datum, "Y-m-d") . "','" . $tipDen . "','#" . $color . "','" . $tipPraznik . "'); ");
}
} else {
$proverka = query("select * from companydays");
if (pg_num_rows($proverka) == 0) {
$vnes = query("insert into companydays(id,clientid,dayname,typeofday,datum,companyholiday,cellcolor) values(1," . Session("client_id") . ",N'" . $imePraznik . "','" . $den . "','" . DateTimeFormat($datum, "Y-m-d") . "','" . $tipDen . "','#" . $color . "'); ");
} else {
$posledno = dlookup("select Max(id)+1 from companydays");
$vnes = query("insert into companydays(id,clientid,dayname,typeofday,datum,companyholiday,cellcolor) values('" . $posledno . "'," . Session("client_id") . ",N'" . $imePraznik . "','" . $den . "','" . DateTimeFormat($datum, "Y-m-d") . "','" . $tipDen . "','#" . $color . "'); ");
}
}
closedb();
<?php
include "../include/functions.php";
include "../include/db.php";
include "../include/params.php";
include "../include/dictionary2.php";
opendb();
$userid = Session('user_id');
$recordExists = dlookup("select count(1) from userfirstlogin where userid=" . $userid);
if ($recordExists == 0) {
$userfirstlogin = query("insert into userfirstlogin (userid, firstlogin) values (" . $userid . ", now())");
}
// return the sotored first login date
$recordDate = dlookup("select firstlogin from userfirstlogin where userid=" . $userid);
$days = DateDiffDays($recordDate, now());
echo json_encode($days);
closedb();
exit;
<?php
include "../include/functions.php";
include "../include/db.php";
include "../include/params.php";
include "../include/dictionary2.php";
?>
<?php
opendb();
$imeKultura = str_replace("'", "''", NNull($_GET['kulturaIme'], ''));
$posledno = dlookup("select Max(id)+1 from route_culture");
$proverka = dlookup("SELECT count(*) FROM route_culture WHERE name = '" . $imeKultura . "' and clientid = " . Session("client_id"));
if ($proverka > 0) {
echo 1;
} else {
$vnesi = query("INSERT into route_culture(id,name,clientid) values ('" . $posledno . "','" . $imeKultura . "'," . Session("client_id") . "); ");
echo 0;
}
closedb();
<?php
include "../include/functions.php";
include "../include/db.php";
?>
<?php
include "../include/params.php";
include "../include/dictionary2.php";
session_start();
$id = str_replace("'", "''", NNull($_GET['id'], ''));
opendb();
$daliUniqId = dlookup("select uniqid from alarms where id = " . $id . " and clientid =" . Session("client_id"));
if ($daliUniqId != "") {
$brisi = query("Delete from alarms where uniqid = " . $daliUniqId . " and clientid =" . Session("client_id"));
} else {
$brisi = query("Delete from alarms where id = " . $id . " and clientid =" . Session("client_id"));
}
closedb();
$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 . " )";
//$dsInsert = query($sqlInsert);
$dsInsert = dlookup($sqlInsert . " RETURNING id");
//$dsInsert1 = query("select id from rnalogheder order by id desc limit 1");
//$id = pg_fetch_result($dsInsert1, 0, "id");
addlog(38, dic_('Routes.NewOrderWithNumber') . " " . $dsInsert);
print $dsInsert;
closedb();
$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();
exit;
<?php
include "../include/functions.php";
include "../include/db.php";
include "../include/params.php";
include "../include/dictionary2.php";
?>
<?php
if (session('user_id') == "261") {
echo header('Location: ../sessionexpired/?l=' . $cLang);
}
if (!is_numeric(session('user_id'))) {
echo header('Location: ../sessionexpired/?l=' . $cLang);
}
header("Expires: Mon, 20 Jul 2000 05:00:00 GMT");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", FALSE);
header("Pragma: no-cache");
set_time_limit(0);
$str = "";
opendb();
if (session("role_id") . "" == "2") {
$str .= dlookup("select getcurrentpositionzone(" . session("user_id") . ", 'select id from vehicles where clientid = " . session("client_id") . "', 'select tourid, vehicleid, vozilo, timein, timeout, diff, poiid, rbr1 from gettoursbycid(" . session("client_id") . ")')");
} else {
$str .= dlookup("select getcurrentpositionzone(" . session("user_id") . ", 'select vehicleid from uservehicles where userid=" . session("user_id") . "', 'select tourid, vehicleid, vozilo, timein, timeout, diff, poiid, rbr1 from gettoursbyuid(" . session("user_id") . ")')");
}
print $str;
closedb();
$sqlAl1 = "";
}
} else {
$dsVehByCID = query("select id from vehicles where clientid=" . session("client_id"));
while ($row = pg_fetch_array($dsVehByCID)) {
$sqlAl1 .= "insert into alarms (alarmtypeid, settings, available, emails, sms, soundid, snooze, clientid, vehicleid, poiid, uniqid, typeofgroup) ";
$sqlAl1 .= " Values ('8', '" . $oeid . "', '" . $_avail . "', '" . $em . "', '" . $ph . "', 1, '" . $snooze . "', '" . session("client_id") . "', '" . $row["id"] . "', '" . $id . "', '" . $q . "', '" . $sidx . "')";
$dsAl1 = query($sqlAl1);
$sqlAl1 = "";
}
}
}
}
if ($aliz == "true") {
$q = $q + 1;
$snooze = dlookup("select snooze from users where id=" . session("user_id"));
$sqlAl1 = "";
if ($sidx == "1") {
$sqlAl1 .= "insert into alarms (alarmtypeid, settings, available, emails, sms, soundid, snooze, clientid, vehicleid, poiid, typeofgroup) ";
$sqlAl1 .= " Values ('9', '" . $oeid . "', '" . $_avail . "', '" . $em . "', '" . $ph . "', 1, '" . $snooze . "', '" . session("client_id") . "', '" . $selveh . "', '" . $id . "', '" . $sidx . "')";
$dsAl1 = query($sqlAl1);
$sqlAl1 = "";
} else {
if ($sidx == "2") {
$dsVehByOE = query("select id from vehicles where organisationid=" . $oeid);
while ($row = pg_fetch_array($dsVehByOE)) {
$sqlAl1 .= "insert into alarms (alarmtypeid, settings, available, emails, sms, soundid, snooze, clientid, vehicleid, poiid, uniqid, typeofgroup) ";
$sqlAl1 .= " Values ('9', '" . $oeid . "', '" . $_avail . "', '" . $em . "', '" . $ph . "', 1, '" . $snooze . "', '" . session("client_id") . "', '" . $row["id"] . "', '" . $id . "', '" . $q . "', '" . $sidx . "')";
$dsAl1 = query($sqlAl1);
$sqlAl1 = "";
}
function getPriv($key, $userID)
{
$rid = dlookup("select roleid from users where id=" . $userID);
if ($rid == 2) {
return 1;
}
$ret = nnull(dlookup("select " . $key . " from privilegessettings where userid=" . $userID), 1);
return $ret;
}
<?php
include "../include/functions.php";
include "../include/db.php";
?>
<?php
include "../include/params.php";
include "../include/dictionary2.php";
session_start();
opendb();
$id = str_replace("'", "''", NNull($_GET['id'], ''));
$ime = str_replace("'", "''", NNull($_GET['name'], ''));
$prezime = str_replace("'", "''", NNull($_GET['lastname'], ''));
$email = str_replace("'", "''", NNull($_GET['email'], ''));
$telefon = str_replace("'", "''", NNull($_GET['phone'], ''));
$username = str_replace("'", "''", NNull($_GET['username'], ''));
$pomosno = str_replace("'", "''", NNull($_GET['pomosno'], ''));
$userCheck = dlookup("SELECT count(*) FROM users WHERE username = '******' and username not in (select username from users where id=" . $id . ")");
if ($userCheck > 0) {
echo 1;
} elseif ($pomosno == 1) {
$password = str_replace("'", "''", NNull($_GET['passwordstar'], ''));
$updt = query("update users set fullname = '" . $ime . " " . $prezime . "', username='******', password='******', email='" . $email . "', phone = '" . $telefon . "' where id = " . $id . " and clientid = " . Session("client_id"));
print $id;
} else {
$passwordNov = str_replace("'", "''", NNull($_GET['passwordNov'], ''));
$updt = query("update users set fullname = '" . $ime . " " . $prezime . "', username='******', password='******', email='" . $email . "', phone = '" . $telefon . "' where id = " . $id . " and clientid = " . Session("client_id"));
print $id;
}
closedb();
//ShowHideMail();
snoozeAlarm();
AjaxNotify();
AjaxMessageNotify();
</script>
<?php
$sqlAlarm = "";
$sqlAlarm .= "select ah.*, v.registration from alarmshistory ah left join vehicles v on v.id=ah.vehicleid ";
$sqlAlarm .= " where ah.vehicleid in (" . $sqlV . ") ";
$sqlAlarm .= " and ah.datetime > cast((select now()) as date) + cast('-1 day' as interval) ";
$sqlAlarm .= " order by read asc, datetime desc";
$dsAlarms = query($sqlAlarm);
$brojac = 1;
$brojac1 = dlookup("select count(*) from alarmshistory where vehicleid in (" . $sqlV . ") and datetime > cast((select now()) as date) + cast('-1 day' as interval) and read='0'");
while ($row = pg_fetch_array($dsAlarms)) {
$tzDatetime = new DateTime($row["datetime"]);
list($d, $m, $y) = explode('-', $row["datetime"]);
$a = explode(" ", $y);
$d1 = explode(":", $a[1]);
$d2 = explode(".", $d1[2]);
$idCreate = $row["vehicleid"] . "_" . $d . "_" . $m . "_" . $a[0] . "_" . $d1[0] . "_" . $d1[1] . "_" . $d2[0] . "_" . $d2[1];
if ($row["read"] == "0") {
?>
<script>
AlertEventInit('<?php
echo $row["datetime"];
?>
', '<?php
echo $row["registration"];
