本文整理汇总了PHP中getQUERY函数的典型用法代码示例。如果您正苦于以下问题：PHP getQUERY函数的具体用法？PHP getQUERY怎么用？PHP getQUERY使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了getQUERY函数的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: createXls
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;
}
}
开发者ID:hew86i，项目名称:panorama，代码行数:48，代码来源:createXls.php
示例2: getQUERY
<?php
include "../include/functions.php";
include "../include/db.php";
?>
<?php
include "../include/params.php";
include "../include/dictionary2.php";
$_routeID = getQUERY("id");
$str = "";
opendb();
//echo "select ND.rbr, PP.ID, ST_X(pp.geom) lat, ST_Y(pp.geom) long, PP.Name from pointsofinterest PP left join rNalogDetail ND on PP.ID=ND.ppid where PP.ID in (select ND.ppid from rNalogDetail ND where ND.hederID=" . $_routeID . ") and pp.clientid=" . session("client_id") . " ND.hederID=" . $_routeID . " order by ND.rbr asc";
//exit;
//$type = dlookup("select type from pointsofinterest where id = (select ppid from rNalogDetail where hederid=" . $_routeID . " limit 1)");
$str1 = "";
$str1 .= " (select ND.rbr, PP.ID, st_y(st_centroid(geom)) long, st_x(st_centroid(geom)) lat, PP.Name, PP.type ";
$str1 .= " from pointsofinterest PP left join rNalogDetailpre ND on PP.ID=ND.ppid ";
$str1 .= " where pp.active='1' and PP.type=2 and PP.ID in (select ND.ppid from rNalogDetailpre ND where ND.hederID=" . $_routeID . ") and ";
$str1 .= " pp.clientid=" . session("client_id") . " and ND.hederID=" . $_routeID . " order by ND.rbr asc) ";
$str1 .= " union ";
$str1 .= " (select ND.rbr, PP.ID, st_y(st_centroid(geom)) long, st_x(st_centroid(geom)) lat, PP.Name, PP.type ";
$str1 .= " from pointsofinterest PP left join rNalogDetailpre ND on PP.ID=ND.ppid ";
$str1 .= " where pp.active='1' and PP.type=3 and PP.ID in (select ND.ppid from rNalogDetailpre ND where ND.hederID=" . $_routeID . ") and ";
$str1 .= " pp.clientid=" . session("client_id") . " and ND.hederID=" . $_routeID . " order by ND.rbr asc) ";
$str1 .= " union ";
$str1 .= " (select ND.rbr, PP.ID, ST_X(ST_Transform(pp.geom,4326)) long, ST_Y(ST_Transform(pp.geom,4326)) lat, PP.Name, PP.type ";
$str1 .= " from pointsofinterest PP left join rNalogDetailpre ND on PP.ID=ND.ppid ";
$str1 .= " where pp.active='1' and PP.type=1 and PP.ID in (select ND.ppid from rNalogDetailpre ND where ND.hederID=" . $_routeID . ") and ";
$str1 .= " pp.clientid=" . session("client_id") . " and ND.hederID=" . $_routeID . " order by ND.rbr asc) order by 1";
$dsR = query($str1);
//$dsR = query("select ND.rbr, PP.ID, st_y(st_centroid(geom)) long, st_x(st_centroid(geom)) lat, PP.Name, PP.type from pointsofinterest PP left join rNalogDetail ND on PP.ID=ND.ppid where PP.ID in (select ND.ppid from rNalogDetail ND where ND.hederID=" . $_routeID . ") and pp.clientid=" . session("client_id") . " and ND.hederID=" . $_routeID . " order by ND.rbr asc");
开发者ID:hew86i，项目名称:panorama，代码行数:31，代码来源:LoadRoutePre.php
示例3: pg_fetch_result
$metric = pg_fetch_result($dsUsersSett, 0, 'metric');
$currency = pg_fetch_result($dsUsersSett, 0, 'currency');
$currencyvalue = dlookup("select value from currency where name='" . $currency . "'");
$currency = strtolower($currency);
if ($metric == 'mi') {
$metricvalue = 0.621371;
$speedunit = "mph";
} else {
$metricvalue = 1;
$speedunit = "Km/h";
}
$Allow = getPriv("idlingreport", session("user_id"));
if ($Allow == False) {
echo header('Location: ../permission/?l=' . $cLang);
}
$vh = getQUERY("v");
$datetimeformat = pg_fetch_result($dsUsersSett, 0, 'datetimeformat');
$datfor = explode(" ", $datetimeformat);
$dateformat = $datfor[0];
$timeformat = $datfor[1];
if ($timeformat == 'h:i:s') {
$timeformat = $timeformat . " a";
}
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";
开发者ID:hew86i，项目名称:panorama，代码行数:31，代码来源:CurrentData1.php
示例4: session_start
<?php
include "../include/functions.php";
include "../include/db.php";
?>
<?php
include "../include/params.php";
include "../include/dictionary2.php";
session_start();
opendb();
$opis = getQUERY("o");
$rbr = getQUERY("rbr");
$h = getQUERY("h");
$ppid = getQUERY("ppid");
$pointkm = getQUERY("pointkm");
$pointtime = getQUERY("pointtime");
$sqlInsert = "insert into rnalogdetailpre (opis, ppid, hederid, rbr, poikm, poitime) values ('" . $opis . "', " . $ppid . ", " . $h . ", " . $rbr . ", " . $pointkm . ", " . $pointtime . ") ";
runsql($sqlInsert);
print "OK";
closedb();
开发者ID:hew86i，项目名称:panorama，代码行数:20，代码来源:UpdateNDetailPre.php
示例5: session_start
<?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
$table = getQUERY("table");
$id = getQUERY("id");
opendb();
RunSQL("delete from " . $table . " where id = " . $id);
if ($table == 'fmCosts') {
RunSQL("delete from newcosts where costtypeid = " . $id);
}
closedb();
开发者ID:hew86i，项目名称:panorama，代码行数:21，代码来源:DeleteSett.php
示例6: getQUERY
$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 . " )";
//$dsInsert = query($sqlInsert);
$dsInsert = dlookup($sqlInsert . " RETURNING id");
//$dsInsert1 = query("select id from rnalogheder order by id desc limit 1");
开发者ID:hew86i，项目名称:panorama，代码行数:31，代码来源:SaveNHeaderTest.php
示例7: header
<?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;
开发者ID:hew86i，项目名称:panorama，代码行数:20，代码来源:MessageOperations.php
示例8: DateTimeFormat
<link href="../css/ui-lightness/jquery-ui-1.8.14.custom.css" rel="stylesheet" type="text/css" />
<!--script src="js/jquery-ui-timepicker-addon.js" type="text/javascript"></script-->
<script src="../js/jquery-ui.js"></script>
<script src="../js/jquery-ui-timepicker-addon.js" type="text/javascript"></script>
<body>
<?php
$LastDay = DateTimeFormat(addDay(-1), "d-m-Y");
$vehID_ = getQUERY("vehid");
$tpoint = getQUERY("tpoint");
opendb();
$reg = "";
//dlookup("select registration from vehicles where id=" . $vehID);
$cLang = getQUERY("l");
?>
<table class="text2_" width=400px align="center" style="padding-top: 13px; margin-left:60px">
<tr>
<td width=160px style="font-size:13px" ><b><?php
echo dic_("Reports.ChooseCost");
?>
:</b></td>
<td style="padding-left:0px">
<input id="searchCost" type="text" onkeyup="OnKeyPressSearchCost(event.keyCode)" onclick="OnKeyPressSearchCost()" onblur="hideSearchCost()" style="margin-top:5px; color: #2F5185; font-family: Arial,Helvetica,sans-serif; font-size: 11px; height:25px; border: 1px solid #CCCCCC; border-radius: 5px 5px 5px 5px; width:180px; padding-left:5px"/>
<div class="corner5" style="color:#2F5185; opacity:1; padding:5px; background-color:#fff; display:none; position:absolute; border:1px solid #CCCCCC; width:170px;height: 74px; float:left; overflow-y: auto; z-index:9999" id="listCost">
<a id="a-F" class="" onmouseover="overDiv('F')" onmouseout="outDiv('F')" style="cursor:pointer; color:#2F5185; width:100%; display: inline-block; float:left; padding-left:3px" onclick="">
<span onclick="OnCLickCost('F')"><?php
echo dic_("Reports.Fuel");
?>
开发者ID:hew86i，项目名称:panorama，代码行数:30，代码来源:AddCostW.php
示例9: set_time_limit
<?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();
开发者ID:hew86i，项目名称:panorama，代码行数:23，代码来源:AddGarmin.php
示例10: opendb
<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 . "");
$boja2 = pg_fetch_result($boja, 0, "fillcolor");
}
$sLon = pg_fetch_result($dsPp, 0, "lon");
开发者ID:hew86i，项目名称:panorama，代码行数:31，代码来源:LoadMap2.php
示例11: dic
<body>
<?php
//$cLang = getQUERY('lang');
?>
<div id="div-add" style="display:none" title=""></div>
<div id="dialog-message" title="<?php
echo dic("Reports.Message");
?>
" style="display:none">
<p>
<span class="ui-icon ui-icon-circle-check" style="float:left; margin:0 7px 50px 0;"></span>
<div id="div-msgbox" style="font-size:14px"></div>
</p>
</div>
<?php
$id = getQUERY('id');
opendb();
$code = NNull(DlookUP("select Code from organisation where id=" . $id), "");
$name = NNull(DlookUP("select Name from organisation where id=" . $id), "");
$desc = NNull(DlookUP("select Description from organisation where id=" . $id), "");
?>
<table style="padding-left:20px;" class="text2_" width=50%>
<tr style="height:10px"></tr>
<tr >
<td width=20% style="font-weight:bold"><?php
dic("Fm.Code");
?>
:</td>
<td width=30% style="padding-left:10px"><input id="code" value="<?php
开发者ID:hew86i，项目名称:panorama，代码行数:31，代码来源:ModifyOrgUnit.php
示例12: query
$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");
$f = addToDate(now(), -1, "months");
while ($f < now()) {
//ponedelnik-nedela
if ($dayType >= 1 and $dayType <= 7) {
if ($dayType == 7) {
if (DateTimeFormat($f, 'w') == 0) {
$ret = query("select cachereportsparams('" . DateTimeFormat($f, 'Y-m-d') . " " . $from . "', '" . DateTimeFormat($f, 'Y-m-d') . " " . $to . "', ' clientid = " . $cid . "')");
if ($clienttypeid == 2) {
$ret = query("select cachetaxiparams1('" . DateTimeFormat($f, 'Y-m-d') . " " . $from . "', '" . DateTimeFormat($f, 'Y-m-d') . " " . $to . "', ' clientid = " . $cid . "')");
$ret = query("select cachetaxiparams2('" . DateTimeFormat($f, 'Y-m-d') . " " . $from . "', '" . DateTimeFormat($f, 'Y-m-d') . " " . $to . "', ' clientid = " . $cid . "')");
}
开发者ID:hew86i，项目名称:panorama，代码行数:31，代码来源:cachereports_sett.php
示例13: session_start
<?php
include "../include/functions.php";
include "../include/db.php";
?>
<?php
include "../include/params.php";
include "../include/dictionary2.php";
session_start();
$userID = getQUERY("uid");
$lista = getQUERY("lista");
$lista1 = explode(",", $lista);
$list1 = '';
for ($i = 0; $i < sizeof($lista1); $i++) {
$list1 = $list1 . "'1'";
if ($i < sizeof($lista1) - 1) {
$list1 = $list1 . ',';
}
}
opendb();
RunSQL("delete from privilegessettings where userID = " . $userID);
RunSQL("insert into privilegessettings (userid," . $lista . ") values (" . $userID . "," . $list1 . ")");
print "Ok";
closedb();
开发者ID:hew86i，项目名称:panorama，代码行数:24，代码来源:SavePrivilegies.php
示例14: getQUERY
<script type="text/javascript" src="./js/highcharts.src.js"></script>
<link href="../css/ui-lightness/jquery-ui-1.8.14.custom.css" rel="stylesheet" type="text/css" />
<script src="../js/jquery-ui.js"></script>
<script src="../report/js/jquery-ui-timepicker-addon.js" type="text/javascript"></script>
</head>
<?php
$name = getQUERY("name");
$dtfrom = getQUERY("dtfrom");
$dtto = getQUERY("dtto");
$vozilo = getQUERY("vozilo");
$sofer = getQUERY("sofer");
$alarm = getQUERY("alarm");
$poiid = getQUERY("poiid");
if ($alarm == "/") {
$alarm = 0;
}
/*echo "name=".$name."<br/>";
echo "dtfrom=".$dtfrom."<br/>";
echo "dtto=".$dtto."<br/>";
echo "vozilo=".$vozilo."<br/>";
echo "sofer=".$sofer."<br/>";
echo "alarm=".$alarm."<br/>";
echo "poiid=".$poiid."<br/>";
exit;*/
$user_id = session("user_id");
opendb();
$dsAll = query("select u.cityid, defaultmap, datetimeformat, timezone, 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 = " . session("user_id"));
$clientUnit = pg_fetch_result($dsAll, 0, "metric");
开发者ID:hew86i，项目名称:panorama，代码行数:31，代码来源:getReports.php
示例15: ob_start
<?php
ob_start();
header("Content-type: text/html; charset=utf-8");
include "../include/functions.php";
include "../include/db.php";
include "../include/params.php";
include "../include/dictionary2.php";
if (!is_numeric(session('user_id'))) {
echo header('Location: ../sessionexpired/?l=' . $cLang);
}
$clientid = session("client_id");
$q = getQUERY("q");
$q1 = $q;
$healthy = array("a", "b", "v", "g", "d", "g", "e", "z", "z", "dz", "i", "j", "k", "l", "lj", "m", "n", "nj", "o", "p", "r", "s", "t", "k", "u", "f", "h", "c", "c", "gz", "s");
$yummy = array("а", "б", "в", "г", "д", "ѓ", "е", "ж", "з", "ѕ", "и", "ј", "к", "л", "љ", "м", "н", "њ", "о", "п", "р", "с", "т", "ќ", "у", "ф", "х", "ц", "ч", "џ", "ш");
$q1 = mb_strtolower($q1, 'UTF-8');
$q1 = str_replace($healthy, $yummy, $q1);
$q = mb_strtolower($q, 'UTF-8');
$q = str_replace($yummy, $healthy, $q);
opendb();
// Vraboteni
// vaka treba
//$allowedUsers = "-1,".dlookup("select getmembers(".session("user_id").", ".$wsid.")");
//ama sega privremeno ke bide
//$allowedUsers = "select userid from members where wsid=".$wsid." union all select ".session("user_id")." userid";
$srcStringUser = "(select id, name fullname, type, ST_Y(ST_Transform(geom,4326)) latitude, ST_X(ST_Transform(geom,4326)) longitude ";
$srcStringUser .= "from pointsofinterest where type=1 and active='1' and (lower(name) like '%" . $q . "%' or lower(name) like '%" . $q1 . "%') and clientid=" . $clientid . " order by fullname) ";
$srcStringUser .= "union ";
$srcStringUser .= "(select id, name fullname, type, st_x(st_centroid(geom)) latitude, st_y(st_centroid(geom)) longitude ";
$srcStringUser .= "from pointsofinterest where type=2 and active='1' and (lower(name) like '%" . $q . "%' or lower(name) like '%" . $q1 . "%') and clientid=" . $clientid . " order by fullname) ";
开发者ID:hew86i，项目名称:panorama，代码行数:31，代码来源:loadpointsofinterestAll.php
示例16: header
<?php
include "../../include/functions.php";
include "../../include/db.php";
include "../../include/params.php";
header("Content-type: text/html; charset=utf-8");
$page = getQUERY("page");
$page1 = $page;
$req = getQUERY("req");
$req1 = str_replace("**", "&", $req);
$temp = explode("&", $req1);
$uid = getQUERY("u");
$cid = getQUERY("c");
$sd = substr($temp[1], 3);
$ed = substr($temp[2], 3);
$namePDF = $page1 . '_' . $cid . '_' . $sd . '_' . $ed . '.pdf';
$namePDF1 = str_replace(" ", "_", $namePDF);
$namePDF1 = str_replace("(", "_", $namePDF1);
$namePDF1 = str_replace(")", "_", $namePDF1);
$namePDF1 = str_replace("__", "_", $namePDF1);
$req1 .= "&c=" . $cid . "&u=" . $uid;
if ($page == 'LogReport') {
$req1 .= "&foruser=" . getQUERY("foruser");
}
$output = shell_exec('xvfb-run --server-args="-screen 0, 1200x800x24" wkhtmltopdf --dpi 300 "panorama.gps.mk/settings/' . $page . 'PDF.php?' . $req1 . '" --redirect-delay 10000 ../../savePDF/' . $namePDF1);
echo $namePDF1;
开发者ID:hew86i，项目名称:panorama，代码行数:26，代码来源:index.php
示例17: nnull
}
$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;
开发者ID:hew86i，项目名称:panorama，代码行数:31，代码来源:SendMess.php
示例18: Session
//dim allPOI as integer = dlookup("select count(*) from pinpoints where clientID=" & session("client_id"))
//Dim allPOIs As String = "false"
//If allPOI < 1000 Then allPOIs = "true"
$user_id = Session("user_id");
$client_id = Session("client_id");
$roleid = Session("role_id");
$DefMap = pg_fetch_result($dsAll, 0, "defaultmap");
$currDateTime = new Datetime();
$cdt1 = $currDateTime->format("Y-m-d");
$currDateTime = $currDateTime->format("d-m-Y H:i");
$currDateTime1 = new Datetime();
$cdt2 = $currDateTime1->format("Y-m-d");
$currDateTime1 = $currDateTime1->format("d-m-Y");
$dateS = getQUERY("dateS");
$dateE = getQUERY("dateE");
$tourid = getQUERY("tourid");
if ($tourid == "") {
if ($dateS == "") {
if ($roleid == "2") {
if (dlookup("select count(*) from rNalogHeder where clientid=" . $client_id . " and startdate < cast(now() as date) + cast('1 day' as interval)") > 0) {
$currDateTime2 = dlookup("select cast(startdate as date) from rNalogHeder where clientid=" . $client_id . " and startdate < cast(now() as date) + cast('1 day' as interval) order by startdate desc limit 1");
} else {
$currDateTime2 = "";
}
} else {
if (dlookup("select count(*) from rNalogHeder where userid=" . $user_id . " and startdate < cast(now() as date) + cast('1 day' as interval)") > 0) {
$currDateTime2 = dlookup("select cast(startdate as date) from rNalogHeder where userid=" . $user_id . " and startdate < cast(now() as date) + cast('1 day' as interval) order by startdate desc limit 1");
} else {
$currDateTime2 = "";
}
}
开发者ID:hew86i，项目名称:panorama，代码行数:31，代码来源:SiteNaloziNew.php
示例19: opendb
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();
开发者ID:hew86i，项目名称:panorama，代码行数:31，代码来源:weatherStations.php
示例20: session_start
<?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();
开发者ID:hew86i，项目名称:panorama，代码行数:25，代码来源:UpdateNoteAlarm.php
注：本文中的getQUERY函数示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。 |
客服电话
APP下载
官方微信
请发表评论