// 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 (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)
if($type==6)
notice_board_hlavni(10,$page,$zobraz,$sup,0,0);
else{
echo "
Aktuálně
";
notice_board(10,$page,$zobraz,$sup,0,0);
}
//echo "
O nás
";
?>
if($intro!=""){
echo "
O nás
";
// echo "
O nás
";
echo "
";
echo "
";
echo "
";
echo nl2br($intro);
echo "
";
echo "
";
}
if($sup!=51){
if($type!=4)
if($type==6)
echo "
Redakční rada
";
else
echo "
Personální obsazení
";
ksa_structure($sup, 0);
?>
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 || position.IDposition = 50) order by worker.Surname, worker.Name");
if($type==6)
$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 = 110 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 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("");
if($type!=0) //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 |
");
}
else
// vypis("prof");
// vypis("doc")
for($j=0;$j<3;$j++){
$prof=0;
$doc=0;
$ostatni=0;
for ($i=0; $i
Profesoř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 = 21 || position.IDposition = 13) order by worker.Surname, worker.Name");
if (sizeof($data)!=0)echo "
| Externisté |
|---|
";
for ($i=0; $i
";
echo "";
echo($jmeno);
echo" | ";
echo("");
echo ""). " ";
echo $mail. " ";
echo("");
echo(" | ");
echo("");
echo $telefon;
echo(" | ");
// echo $q->f("Foto");
// echo "";
echo("");
//echo("| $IDWorker |
");
}*/
/*
* Vypis interních doktorandu
*
* */
$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 = 11 || position.IDposition = 12) order by worker.Surname, worker.Name");
if (sizeof($data)!=0)echo "Doktorandi
";
for ($i=0; $i ";
//echo("