// v pripade viceurovnoveho cleneni katedry je nutno predelat, viz funkce ksa_superiors v global.inc.php
//$shortcut="KJA";
//echo $shortcutdiv;
//echo $sup;
$AktualDate = strftime("%d.%m.%Y",time());
List($day,$month,$year,$others)=Explode(".",$AktualDate);
$AktualDate = $year.$month.$day;
//echo $and;
//echo "Divize:".$category;
$dotaz="SELECT * FROM news WHERE ((EndDate-$AktualDate)>=0 AND Language=0) AND (IDDivision=$sup) ORDER BY Important DESC,InsertDate DESC";
$result= ksa_query_db($dotaz);
$num_rows=sizeof($result); //počet záznamů
if ($num_rows>0)
echo "
Aktuálně
";
//echo "typ".$BoardHlavni;
//echo "board".$sup." ".$shortcutdiv." ".$hlavni;
if ($hlavni==0)
notice_board(10,$page,$zobraz,$sup,0,0);
else
notice_board_hlavni(8,$page,$zobraz,$sup,0,0);
//echo "
O nás
";
?>
if($intro!=""){
if (!(($type==5) OR ($type==4)OR ($type==6)))
echo "
O nás
";
// echo "
O nás
";
echo "
";
echo "
";
echo "
";
echo nl2br($intro);
echo "
";
echo "
";
}
if($type!=20){
if(!(($type==4)OR($type==5)OR ($type==6)))
echo "
Personální obsazení
";
ksa_structure($sup, 0);
?>
if($type!=6)
if($type==0)
$data = ksa_query_db("select DISTINCT worker.IDWorker, worker.TitleBefore, worker.Name, worker.Surname, worker.TitleAfter, worker.Email, worker.JobPhone, worker.User from works left join position on (position.idposition = works.IDPosition) left join worker on (works.IDWorker = worker.IDWorker) where ($where) && position.View = 1 && (position.IDposition = 5 || position.IDposition = 9 || position.IDposition = 21 || position.IDposition = 13 ) order by worker.Surname, worker.Name");
else
$data = ksa_query_db("select DISTINCT worker.IDWorker, worker.TitleBefore, worker.Name, worker.Surname, worker.TitleAfter, worker.Email, worker.JobPhone, worker.User, worker.Specialization from works left join position on (position.IDPosition = works.IDPosition) left join worker on (works.IDWorker = worker.IDWorker) where ($where) && position.View = 1 order by worker.Surname, worker.Name");
if (sizeof($data) > 0) {
//echo "
$titulek
\n";
// echo("
foto | \n");
//echo("");
//echo $type;
if(!(($type==0) OR ($type==5))) //pokud neni katedra vypis normalne jinak dle akademickych titulu
for ($i=0; $i
";
echo "
";
echo ksa_get_name($zaznam[0]);
echo"";
// echo $q->f("Foto");
// echo "";
echo("
");
//echo("
| $IDWorker |
");
}
elseif ($type==5) {
echo "
INTERNÍ ČLENOVÉ
";
for ($i=0; $i
0)
$int=1;
else
$int=0;
if ($int==1){
echo "");
}
//echo("| $IDWorker |
");
}
echo "EXTERNÍ ČLENOVÉ
";
for ($i=0; $i0)
$int=1;
else
$int=0;
if ($int==0){
$specialization=$zaznam[8];
echo "");
}
//echo("| $IDWorker |
");
}
}
else
// vypis("prof");
// vypis("doc")
for($j=0;$j<3;$j++){
$prof=0;
$doc=0;
$ostatni=0;
for ($i=0; $iProfesoři
";
if($doc==1)
echo "
Docenti
";
if($asistenti==1)
echo "
Odborní asistenti, asistenti a ostatní vyučující
";
//
//
if ($zaznam[5]!="")
$mail=$zaznam[5];
elseif($zaznam[7]!="")
$mail=ldap_get_info($zaznam[7],"mail");
else
$mail="";
if ($zaznam[6]!="")
$telefon=$zaznam[6];
elseif($zaznam[7]!=""){
$telefon=ldap_get_info($zaznam[7],"telefon");
}
else
$telefon="";
/*
if ($zaznam[5]!="")
$mail=$zaznam[5];
else
$mail=ldap_get_info($zaznam[7],"mail");
if ($zaznam[6]!="")
$telefon=$zaznam[6];
else{
$telefon=ldap_get_info($zaznam[7],"telefon");
}
*/
if (is_array($telefon))
$telefon=" ";
echo "
";
}
}
}
$data = ksa_query_db("select DISTINCT worker.IDWorker, worker.TitleBefore, worker.Name, worker.Surname, worker.TitleAfter, worker.Email, worker.JobPhone, worker.User from works left join position on (position.idposition = works.IDPosition) left join worker on (works.IDWorker = worker.IDWorker) where ($where) && (position.View = 1 && position.IDposition = 50 ) order by worker.Surname, worker.Name");
if (sizeof($data)!=0) echo "
Vědecko-výzkumní pracovníci
";
for ($i=0; $i
";
// echo $q->f("Foto");
// echo "";
//echo("