"neTUL","en"=>"nonTUL"];
unset($fakulta);
if (empty($_POST)) die ("POST not serializable, coctact the administrator");
foreach ($_POST as $klic => $hodnota) {
switch (gettype($hodnota)) {
case "integer": $$klic=intval($hodnota); break;
case "double": $$klic=floatval($hodnota); break;
case "string": $$klic=trim(str_replace("'","'",$hodnota)); break;
case "array": $$klic=$hodnota; break;
}
}
function get_ciselnik_all($cesta,$prefix="ciselniky/") {
$soubor=file($prefix.$cesta,FILE_IGNORE_NEW_LINES|FILE_SKIP_EMPTY_LINES);
foreach ($soubor as $hodnota) {
$jeden=explode("|",$hodnota);
$vystup[]=$jeden[0]."|".$jeden[array_search($_SESSION[lang],$jeden)+1];
}
return $vystup;
}
if ($akce=="rewritenewselect") {
if ($druh=="vypisprijemce") {
$vysledek=mysqli_query($connect,"select nazev,kod,zkratka from personal.fakulty order by nazev");
while ($zaznam=mysqli_fetch_assoc($vysledek)) {
$texthandler=!empty($handler)?",".$handler.",".$zaznam[kod]:"";
$vystup[]="";
}
$texthandler=!empty($handler)?",".$handler:"";
if (($priznaky&128)==128) array_unshift($vystup,"");
}
if ($druh=="vypiskodyprojektu") {
$fraze=$fraze!=""?" where kod like '%".$fraze."%'":"";
$vysledek=mysqli_query($connect,"select ident,kod from regprojekty".$fraze." order by kod");
while ($zaznam=mysqli_fetch_assoc($vysledek)) $vystup[]="\n";
}
if ($druh=="vypisprojekty") {
$typ=$typ!=""?" and typ in('".str_replace(",","','",$typ)."')":"";
$pouzite=!empty($vypustit)?" and kod not in('".str_replace(",","','",$vypustit)."')":"";
$fraze=$fraze!=""?" and concat_ws('|',nazev,kod,akronym) like '%".$fraze."%'":"";
$vysledek=mysqli_query($connect,"select ident,kod,nazev,akronym from regprojekty where konec>".strtotime("-5 years").$typ.$pouzite.$fraze." order by kod") or die (mysqli_error($connect));
while($zaznam=mysqli_fetch_assoc($vysledek)) {
$append=(!in_array($zaznam[akronym],["",$zaznam[kod]])?$zaznam[akronym]:$zaznam[nazev]);
$vystup[]="";
}
if (($priznaky&128)==128) array_unshift($vystup,"");
}
if ($druh=="vypisposkytovatele") {
$vysledek=mysqli_query($connect,"select * from poskytovatele order by nazev") or die (mysqli_error($connect));
while ($zaznam=mysqli_fetch_assoc($vysledek)) {
$texthandler=!empty($handler)?",".$handler.",'".$zaznam[zkratka]."'":"";
$vystup[]="";
}
$append=!empty($handler)?",".$handler:"";
if (($priznaky&128)==128) array_unshift($vystup,"");
}
if ($druh=="vypisnavaznosti") {
foreach (get_ciselnik_all("navaznosti.csv") as $hodnota) {
$jeden=explode("|",$hodnota);
$vystup[]="";
}
if (($priznaky&128)==128) array_unshift($vystup,"");
}
if ($druh=="vypistypy") {
$soubor=explode("\n",file_get_contents("ciselniky/navaznosti.csv"));
reset($soubor); do {
$jeden=explode("|",current($soubor));
if (strpos($povolene,$jeden[0])!==false) {
for ($i=0;$i
".$jeden[$numlang]."
";
}
} while (next($soubor)!==false);
}
if ($druh=="vypisjmena") {
//if ($debug==1) {print_r($_POST); die(); }
if (empty($rok_vyd)) $rok_vyd=date('Y');
$fraze=str_replace("'","'",iconv("UTF-8","ISO-8859-2//TRANSLIT",$fraze));
$novyautor=["cs_CZ"=>"přidat jiného autora","en"=>"add an other author"];
$dotaz=($priznaky&32)==32?"select crew.ident,crew.flags,jmeno, ifnull(pred.prijmeni,'') as predchozi, ifnull(max(pred.dokdy),'') as pred_zmena, ifnull(za.prijmeni,crew.prijmeni) as nasledujici ,ifnull(za.dokdy,0) as za_zmena, tul.ident as tul,domov from personal.crew left join personal.tul on tul.ident=crew.ident left join personal.netul on netul.ident=crew.ident left join personal.prijmeni as pred on pred.ident=crew.ident and year(from_unixtime(pred.dokdy))=".$rok_vyd." left join personal.prijmeni as za on za.ident=crew.ident and year(from_unixtime(za.dokdy))>".$rok_vyd." group by crew.ident having concat_ws('|',predchozi,nasledujici) like '%".$fraze."%'":"select crew.ident,crew.flags,jmeno, ifnull(pred.prijmeni,'') as predchozi, ifnull(max(pred.dokdy),'') as pred_zmena, ifnull(za.prijmeni,crew.prijmeni) as nasledujici ,ifnull(za.dokdy,0) as za_zmena, ifnull(tul.ident,0) as tul,domov from personal.crew left join personal.tul on tul.ident=crew.ident left join personal.netul on netul.ident=crew.ident left join personal.prijmeni as pred on pred.ident=crew.ident and year(from_unixtime(pred.dokdy))=".$rok_vyd." left join personal.prijmeni as za on za.ident=crew.ident and year(from_unixtime(za.dokdy))>".$rok_vyd." group by crew.ident having concat_ws('|',predchozi,nasledujici) like '%".$fraze."%'";
$vysledek=mysqli_query($connect,$dotaz);
while ($zaznam=mysqli_fetch_assoc($vysledek)) {
reset($zaznam); do { $klic=key($zaznam); $$klic=current($zaznam); } while (next($zaznam)!==false);
$vysledek2=mysqli_query($connect,"select group_concat(distinct oddeleni order by oddeleni) from personal.funkce where clovek=".$ident);
if ($zaznam=mysqli_fetch_row($vysledek2)) $katedry=$zaznam[0];
unset($tridy); $vsechnaprijmeni=array_filter([$predchozi,$nasledujici]);
foreach ($vsechnaprijmeni as &$prijmeni) if (strpos($prijmeni,$fraze)!==false) break;
$dokdy=$prijmeni==$predchozi?$pred_zmena:$za_zmena;
$zmena=count($vsechnaprijmeni)>1?1:0;
//if ($domov=="") $domov="neTUL";
$netul=["cs_CZ"=>"neTUL","en"=>"nonTUL"];
$utvar=$tul>0?$katedry:$netul[$_SESSION[lang]];
$utvar=strval($domov)!=""?$domov:$utvar;
if ((intval($flags)&1)==0) $tridy[]="slanted";
if (count($vsechnaprijmeni)>1) $tridy[]="zelena";
$trida=is_array($tridy)?" class='".implode(" ",$tridy)."'":"";
//if ($debug==1)die($handler);
$append=isset($handler)?",".$handler.",\"".intval($dokdy).",".intval($zmena)."\"":"";
$jeden[$ident]=$prijmeni."|".$jmeno."|".$utvar."|".$trida."|".$append;
}
if (!empty($jeden)) {
asort($jeden,SORT_LOCALE_STRING);
reset($jeden); do {
$radek=explode("|",current($jeden));
$vystup[key($jeden)]="
".$radek[0]." ".$radek[1]." [".$radek[2]."]
";
} while (next($jeden)!==false);
}
if (($priznaky&16)!=16) $vystup[0]="";
if (($priznaky&128)==128) {
$append=!empty($nullhandler)?",".$nullhandler:"";
array_unshift($vystup,"");
}
}
if ($druh=="vypisobory") {
if ($sber<2017) {
foreach(explode("\n",file_get_contents("ciselniky/obory.csv")) as $jeden) {
$radek=explode("|",$jeden);
$varobor=$radek[array_search($_SESSION[lang],$radek)+1];
$vystup[]="";
}
} else {
$vysledek=mysqli_query($connect,"select kod,nazev,en,riv from frascati where kod rlike '^([0-9]+\.){2}'");
$klic=$_SESSION[lang]!="cs_CZ"?$_SESSION[lang]:"nazev";
while ($zaznam=mysqli_fetch_assoc($vysledek)) $vystup[]="";
}
}
if ($druh=="vypisfrascati") {
$vysledek=mysqli_query($connect,"select kod,nazev,en,riv from frascati where kod rlike '^([0-9]+\.){2}'");
$klic=$_SESSION[lang]!="cs_CZ"?$_SESSION[lang]:"nazev";
while ($zaznam=mysqli_fetch_assoc($vysledek)) {
$vystup[]="";
}
}
echo "OK|".implode("",$vystup);
}
if ($akce=="zmenaprijmeni") {
$vysledek=mysqli_query($connect,"select prijmeni,dokdy from personal.prijmeni where ident=".$ident." and year(from_unixtime(dokdy))=".$rok_vyd." order by dokdy") or die (mysqli_error($connect));
while ($zaznam=mysqli_fetch_assoc($vysledek)) { $casy[]=$zaznam[dokdy]; $prijmeni[]=$zaznam[prijmeni]; }
$vysledek=mysqli_query($connect,"select crew.ident,jmeno,ifnull(prijmeni.prijmeni,crew.prijmeni) as prijmeni,ifnull(dokdy,0) as dokdy,ifnull(group_concat(distinct oddeleni order by oddeleni),'') as katedry, ifnull(tul.ident,'') as tul from personal.crew left join personal.prijmeni on prijmeni.ident=crew.ident and year(from_unixtime(dokdy))>".$rok_vyd." left join personal.tul on tul.ident=crew.ident left join personal.funkce on clovek=crew.ident where crew.ident=".$ident." group by ident order by dokdy limit 1") or die (mysqli_error($connect));
if ($zaznam=mysqli_fetch_assoc($vysledek)) { $casy[]=$zaznam[dokdy]; $prijmeni[]=$zaznam[prijmeni]; }
$klic=array_search($dokdy,$casy)+1;
$katedra=$zaznam[tul]==""?$netul[$_SESSION[lang]]:$zaznam[katedry];
if ($klic==count($casy)) $klic=0;
echo "OK|".$prijmeni[$klic]." ".$zaznam[jmeno]." [".$katedra."]|".$casy[$klic];
}
?>