Příloha 10
Ukázka zdrojového kódy PHP aplikace
<?php
@require $c["absInc"] . "attachedCode.php";
$OUTPUT["chyby"] = array();
if (isset($_REQUEST["cancelTraceId"]) &&
is_numeric($_REQUEST["cancelTraceId"])){
$r = $conn[0]->gd("SELECT * FROM pk_pohyb_kol WHERE id=" .
$_REQUEST["cancelTraceId"]);
if (count($r)>0){
$upd = array();
$upd["vraceniStojanId"] = 0;
$upd["vraceniDatum"] = date("Y-m-d H:i:s");
$upd["dobaVypujckyMin"] = round(((time() - strtotime($r[0]["vypujckaDatum"]))/60),0);
$upd["cestaUkoncena"] = 1;
$conn[0]->makeupdate("pk_pohyb_kol",$upd,"id=" .
$_REQUEST["cancelTraceId"]);
$upd = array();
$upd["aktualniStav"] = 0;
$upd["aktualniStojanId"] = 0;
$conn[0]->makeupdate("pk_kola",$upd,"id=" . $r[0]["koloId"]);
header("location:" . $c["root"] . "private/kola/?id=" .
$r[0]["koloId"]);
exit;
} }
if (isset($_REQUEST["useReminder"])){ // chci pouzit pamatovaka while (list($k,$v)=@each($_SESSION["reminder"]["get"])) { $_GET[$k] = $v;
$_REQUEST[$k] = $v;
}
while (list($k,$v)=@each($_SESSION["reminder"]["post"])) { $_POST[$k] = $v;
$_REQUEST[$k] = $v;
}
if (isset($_REQUEST["useLastPage"]) &&
$_SESSION["reminder"]["lastPage"]>0)
$_REQUEST["actualPage"] = $_SESSION["reminder"]["lastPage"];
}
if (!isset($_REQUEST["actualPage"])) $_REQUEST["actualPage"] = 1;
$cond = "";
if (isset($_REQUEST["srchChip"]) &&
strlen($_REQUEST["srchChip"])>0) $cond .= " AND k.cipId LIKE '%" . $conn[0]->todb($_REQUEST["srchChip"]) . "%'";
if (isset($_REQUEST["srchUzivatel"]) &&
strlen($_REQUEST["srchUzivatel"])>0) $cond .= " AND CONCAT(u.prijmeni,' ',u.jmeno) LIKE '%" . $conn[0]-
>todb($_REQUEST["srchUzivatel"]) . "%'";
if (isset($_REQUEST["srchVypujcenoOd"]) &&
strlen($_REQUEST["srchVypujcenoOd"])>0) $cond .= " AND p.vypujckaDatum<='" . $conn[0]-
>todb($_REQUEST["srchVypujcenoOd"]) . " 00:00:00'";
if (isset($_REQUEST["srchVracenoOd"]) &&
strlen($_REQUEST["srchVracenoOd"])>0) $cond .= " AND p.vraceniDatum<='" . $conn[0]-
>todb($_REQUEST["srchVracenoOd"]) . " 00:00:00'";
if (isset($_REQUEST["srchStav"]) &&
is_numeric($_REQUEST["srchStav"]) &&
$_REQUEST["srchStav"]==1) $cond .=" AND p.cestaUkoncena=0";
if (isset($_REQUEST["srchStav"]) &&
is_numeric($_REQUEST["srchStav"]) &&
$_REQUEST["srchStav"]==2) $cond .=" AND p.cestaUkoncena=1";
$sql = "SELECT p.*,k.cipId as cipId,CONCAT(u.prijmeni,' ',u.jmeno) AS jmeno
FROM pk_pohyb_kol as p,pk_kola as k,pk_uzivatele as u
WHERE p.koloId=k.id AND p.uzivatelId=u.id " . $cond . "
ORDER BY p.vypujckaDatum ASC";
$r = $vwbSys-
>getPaging2($conn[0],$sql,20,$_REQUEST["actualPage"],10);
$OUTPUT["list"] = $conn[0]->gd($r["sql"]);
for ($x=0;$x<count($OUTPUT["list"]);$x++){
if ($OUTPUT["list"][$x]["vypujckaStojanId"]>0){
$t= $conn[0]->gd("SELECT s.*,sg.adresa AS skupinaAdresa,sg.nazev AS skupinaNazev
FROM pk_stojany AS s,pk_stojany_skupina AS sg WHERE s.skupinaId=sg.id
AND s.id=" .
$OUTPUT["list"][$x]["vypujckaStojanId"] . "
ORDER BY sg.adresa ASC,s.popis ASC");
$OUTPUT["list"][$x]["stojanInfoStart"] = $t[0];
}
if ($OUTPUT["list"][$x]["vraceniStojanId"]>0){
$t= $conn[0]->gd("SELECT s.*,sg.adresa AS skupinaAdresa,sg.nazev AS skupinaNazev
FROM pk_stojany AS s,pk_stojany_skupina AS sg WHERE s.skupinaId=sg.id
AND s.id=" . $OUTPUT["list"][$x]["vraceniStojanId"] .
"
ORDER BY sg.adresa ASC,s.popis ASC");
$OUTPUT["list"][$x]["stojanInfoEnd"] = $t[0];
}
if ($OUTPUT["list"][$x]["cestaUkoncena"]==1){
}else{
$OUTPUT["list"][$x]["dobaVypujckyMin"] = round(((time() - strtotime($OUTPUT["list"][$x]["vypujckaDatum"]))/60),0);
} }
if (count($OUTPUT["list"])>0){
$OUTPUT["pages"] = $r["pages"];
$OUTPUT["found"] = $r["found"];
$OUTPUT["displayedFrom"] = $r["displayedFrom"];
$OUTPUT["displayedTo"] = $r["displayedTo"];
$OUTPUT["pagesCount"] = $r["pagesCount"];
}else{
$OUTPUT["pages"] = array();
$OUTPUT["found"] = 0;
$OUTPUT["displayedFrom"] = 0;
$OUTPUT["displayedTo"] = 0;
$OUTPUT["pagesCount"] = 0;
}
// zapis pamatovaka
$_SESSION["reminder"]["post"] = "";
$_SESSION["reminder"]["get"] = "";
while (list($k,$v)=each($_POST)){
if ($k!="actualPage" && $k!="useReminder" &&
$k!="useLastPage") $_SESSION["reminder"]["post"][$k] = $v;
}
while (list($k,$v)=each($_GET)){
if ($k!="actualPage" && $k!="useReminder" &&
$k!="useLastPage") $_SESSION["reminder"]["get"][$k] = $v;
}
$_SESSION["reminder"]["lastPage"] =
$_REQUEST["actualPage"];
//////
$OUTPUT["request"] = $_REQUEST;
?>
