Aktuálně";
//echo $sup;
notice_board(20,$page,$zobraz,$sup,0,0);
/*
if($intro!=""){
echo "
Charakteristika
";
echo nl2br($intro);
}
*/
$data = ksa_query_db("select distinct worker.IDWorker, worker.TitleBefore, worker.Name, worker.Surname, worker.TitleAfter, worker.Email, worker.JobPhone, worker.NumberDoor,position.ExtInfo from works join worker on (works.IDWorker=worker.IDWorker) left join position on (position.IDPosition = works.IDPosition) where (works.IDDivision=$sup) && position.View = 1 && worker.IDWorker order by worker.Surname, worker.Name");
if (sizeof($data) > 0) {
echo "
Úřední hodiny
";
echo("
\n");
echo("| jméno a příjmení | \n");
echo("úřední hodiny | \n");
echo("místnost | \n");
echo("
");
for ($i=0; $i 0) {
$prvni = true;
for ($k=0; $k";
if ($prvni) {
echo "";
echo ksa_get_name($zaznam[0]);
echo "";
if ($zaznam[8])
echo " (".$zaznam[8].")";
$prvni = false;
}
echo(" | ");
if ($vypis != "") $vypis .= "
";
if ($kon[0] != 0) $vypis .= ksa_day_of_week($kon[0], "D");
if ($kon[1] != "" && $kon[2] != "") $vypis .= " $kon[1] - $kon[2]";
elseif ($kon[1] != "") $vypis .= " od $kon[1]";
elseif ($kon[2] != "") $vypis .= " do $kon[2]";
if (($kon[0] != 0 || $kon[1] != "" || $kon[2] != "") && ($kon[4] != "")) $vypis .= ", ";
if ($kon[4] != "") $vypis .= "$kon[4]";
echo("");
echo $vypis;
echo(" | ");
echo("");
if ($kon[3] != "") echo $kon[3];
else echo $zaznam[7];
echo(" | ");
echo("");
}
}
}
}
echo "
";
}
echo "
Kontakty
";
$data = ksa_query_db("select DISTINCT worker.IDWorker, worker.TitleBefore, worker.Name, worker.Surname, worker.TitleAfter, worker.Email, worker.JobPhone, worker.User,position.ExtInfo from works left join position on (position.IDPosition = works.IDPosition) left join worker on (works.IDWorker = worker.IDWorker) where ($where) order by worker.Surname, worker.Name");
//echo sizeof($data);
if (sizeof($data) > 0) {
//echo "
$titulek
\n";
echo("
\n");
echo("| jméno a příjmení | \n");
echo("e-mail | \n");
echo("telefon (37763xxxx) | \n");
// echo("foto | \n");
echo("
");
if($type!=0) //pokud neni katedra vypis normalne jinak dle akademickych titulu
for ($i=0; $i";
echo "";
echo ksa_get_name($zaznam[0]);
echo" | ";
if($zaznam[8])
echo "(".$zaznam[8].")";
echo " | ";
echo("");
echo ""). " ";
echo $mail. " ";
echo("");
echo(" | ");
echo("");
echo $telefon;
echo(" | ");
// echo $q->f("Foto");
// echo "";
echo("");
//echo("| $IDWorker |
");
}
echo "
";
}
listlink(0,$sup);
?>