"neTUL","en"=>"nonTUL"];
unset($fakulta);
if (empty($_POST)) die ("POST not serializable, coctact the administrator");
reset($_POST); do {
$klic=key($_POST); $hodnota=current($_POST);
switch (gettype($hodnota)) {
case "integer": $$klic=intval($hodnota); break;
case "double": $$klic=floatval($hodnota); break;
case "string": $$klic=mysqli_real_escape_string($connect,$hodnota); break;
case "array": $$klic=$hodnota; break;
}
} while (next($_POST)!==false);
$navrat=$preklad['nedefnabidka'];
$handler=!empty($handler)?",".$handler:"";
switch ($typ) {
case "jmena":
unset($jeden,$podminka);
if (!empty($fraze)) $podminka[]="crew.prijmeni like '%".$fraze."%'";
$textpodminka=!empty($podminka)?" where ".implode(" and ",$podminka):"";
$infix=$_SESSION['lang']=="cs_CZ"?"nazev":"en";
$vystup=$priznaky&128?[""]:[];
$vysledek=mysqli_query($connect,"select crew.ident,crew.flags&1 as aktivni,jmeno, crew.prijmeni,organizace,ifnull(tul.ident,0) as tul,count(netul.ident) as netul,count(prijmeni.ident) as zmena,group_concat(distinct oddeleni order by oddeleni) as oddeleni from personal.crew left join personal.tul on tul.ident=crew.ident left join personal.funkce on clovek=crew.ident left join personal.netul on netul.ident=crew.ident left join personal.prijmeni on prijmeni.ident=crew.ident".$textpodminka." group by ident order by prijmeni") or die (mysqli_error($connect));
while ($zaznam=mysqli_fetch_assoc($vysledek)) {
unset ($tridy,$domov,$organizace,$katedry,$textkatedry);
foreach ($zaznam as $klic => $hodnota) $$klic=$hodnota;
$textjmeno=$prijmeni." ".$jmeno;
if (!$aktivni) $tridy[]="slanted";
if ($zmena) $tridy[]="zelena";
$texttridy=!empty($tridy)?" class='".implode(" ",$tridy)."'":"";
$pretok=$flags&512?" class=pretok":"";
if (!empty($oddeleni)) $katedry["TUL"]=array_filter(explode(",",$oddeleni));
if ($netul>0) {
$vysledek2=mysqli_query($connect,"select domov,organizace from personal.netul where ident=".$ident) or die (mysqli_error($connect));
while ($vysledek2 && $zaznam=mysqli_fetch_row($vysledek2)) {
list($domov,$organizace)=$zaznam;
$katedry[0][]=$domov;
}
}
foreach((array)$katedry as $klic=>$hodnota) {
if ($klic===0) continue;
$textkatedry[]=$klic.":".implode(",",$hodnota);
}
if (!empty($katedry[0])) $textkatedry[]=implode("; ",$katedry[0]);
$vystup[]="".$textjmeno." [".implode("; ",(array)$textkatedry)."]";
}
break;
default:
// die ($podminka);
if ($encode==1) $podminka=base64_decode($podminka);
$vystup=$priznaky&128?[""]:[];
if (!empty ($typ)) die ("Unsupported type „".$typ."“");
if (!$tabulka) die ("Neni definovana zdrojova tabulka");
$hodnoty=empty($hodnoty)?"obsah":$hodnoty;
if (!preg_match("/^(\w+\.)+\w+$/",$tabulka)) $tabulka="ciselniky.".$tabulka;
if (!$textformat) $textformat="%".$hodnoty."% – %nazev%";
$orderby=isset($orderby)?strtopercent($orderby,true," =&><"):" ".$hodnoty;
$pretok=($priznaky&512)?" class=pretok":"";
$podminka=mass_replace($podminka,1,[">",">","<","<"]);
$append=!empty($podminka)?" and ".strtopercent($podminka,true):"";
$podminka=" where ".$langnazev." like '%".strval($fraze)."%'".$append;
$dotaz="select ".$langnazev." as nazev,".$hodnoty." from ".$tabulka.$podminka." order by ".$orderby;
//print_r($dotaz); die();
$vysledek=mysqli_query($connect,$dotaz) or die (mysqli_error($connect));
while ($zaznam=mysqli_fetch_assoc($vysledek)) {
$option=$textformat;
foreach ($zaznam as $klic=>$hodnota) {$option=str_replace("%".$klic."%",$hodnota,$option);}
if ($priznaky&2) {
$checked=in_array($zaznam[$hodnoty],$oldpole)?" checked":"";
$checkbox="";
$onclick="multiSelect(this".$handler.")";
} else $onclick="selectOption(this,\"".$zaznam[$hodnoty]."\"".$handler.")";
$vystup[]="";
unset($option);
} if (empty($vystup)) $vystup=[];
if (($priznaky&16) && $tabulka=="organizace") $vystup[]= "";
}
if (isset($vystup)) $navrat="OK|".implode("",$vystup);
echo $navrat;