PHP getQUERY函数代码示例

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;
    }
}

<?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");

$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";

<?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();

<?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();

$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");

<?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;

  
    <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");
?>

<?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();

	<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");

 <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 

            $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 . "')");
                        }

<?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();

	<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");

<?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) ";