";
else
echo "";
$uriz="projekty.php";
$urivyzkumne=$uriz."?section=vyzkumne";
$urirozvojove=$uriz."?section=rozvojove";
$uriostatni=$uriz."?section=ostatni";
$urivse=$uriz."?section=vse";
if (($section!="")or($year!=""))
$uri=$uriz."?";
if ($section!=""){
$uri.="section=$section";
}
if (($section!="")and($year!="")){
$uri=$uri."&";
}
if ($year!=""){
$yearplus=$year+1;
$yearminus=$year-1;
$urivyzkumne.="&year=$year";
$urirozvojove.="&year=$year";
$uriostatni.="&year=$year";
$urivse.="&year=$year";
$uriplus=$uri."year=$yearplus";
$uriminus=$uri."year=$yearminus";
}
if ($year!=""){
echo "
";
$where=" and ((Year=$year) or ((Year<=$year) and (YearEnd>=$year)))";
}
else{
$year=date(Y);
echo "
";
}
?>
";
$vyzkumnezvza="";
}
elseif ($section=="rozvojove"){
$rozvojovezvpred="
";
$rozvojovezvza="";
}
elseif ($section=="ostatni"){
$ostatnizvpred="
";
$ostatnizvza="";
}
elseif ($section=="vse"){
$vsezvpred="
";
$vsezvza="";
}
else{
$section="vse";
}
echo $vyzkumnezvpred;
echo "
Výzkumné projekty ";
echo $vyzkumnezvza;
echo "| ";
echo $rozvojovezvpred;
echo "
Rozvojové a vzdělávací projekty ";
echo $rozvojovezvza;
echo "| ";
echo $ostatnizvpred;
echo "
Ostatní projekty ";
echo $ostatnizvza;
echo "| ";
echo $vsezvpred;
echo "
Kompletní výpis";
echo $vsezvza;
?>
0,YearEnd,Year) as rok from project left join research on (research.IDProject=project.IDProject) join project_type on (project.ProjectType=project_type.IDType) where project_type.Superior=1 $where ORDER BY rok Desc,project_type.Priority Desc,ProjectType");
$rozvojove=ksa_query_db("select distinct project.IDProject,Number,Year,YearEnd,Name,Text, Head, project.Superior, IDDivision, ProjectType,Investor,IF (YearEnd>0,YearEnd,Year) as rok from project left join research on (research.IDProject=project.IDProject) join project_type on (project.ProjectType=project_type.IDType) where project_type.Superior=2 $where ORDER BY rok Desc,project_type.Priority Desc,ProjectType");
$ostatni=ksa_query_db("select distinct project.IDProject,Number,Year,YearEnd,Name,Text, Head, project.Superior, IDDivision, ProjectType,Investor,IF (YearEnd>0,YearEnd,Year) as rok from project left join research on (research.IDProject=project.IDProject) join project_type on (project.ProjectType=project_type.IDType) where project_type.Superior=3 $where ORDER BY rok Desc");
if (($section=="vyzkumne")OR($section=="vse")){
if (sizeof($vyzkumne)>0){
echo "
Výzkumné projekty
";
//echo "
";
for ($i=0; $i";
echo "| ";
echo "";
if ($Number!="")
echo " $Number - ";
echo "$Name";
echo "";
echo " |
";
echo "| Řešitel na KAR: ".ksa_get_name($head)." |
";
if ($poskytovatel!="")
echo "| Poskytovatel: $poskytovatel |
";
if ($Year!=0){
echo "| Období řešení: ";
if ($Year)
echo "$Year";
if ($YearEnd)
echo "-$YearEnd";
echo " |
";
}
echo "";
echo "
";
/* echo "- ";
if ($Year)
echo "$Year";
if ($YearEnd)
echo "-$YearEnd";
if ($poskytovatel!="")
echo " $poskytovatel ";
if ($Number!=0)
echo " $Number-";
echo " $Name";
echo " ".ksa_get_name($head);*/
}
//echo "
";
}
}
if (($section=="rozvojove")OR($section=="vse")){
if (sizeof($rozvojove)>0){
echo "
Rozvojové a vzdělávací projekty
";
//echo "
";
for ($i=0; $i";
echo "| ";
echo "";
if ($Number!="")
echo " $Number - ";
echo "$Name";
echo "";
echo " |
";
echo "| Řešitel na KAR: ".ksa_get_name($head)." |
";
if ($poskytovatel!="")
echo "| Poskytovatel: $poskytovatel |
";
if ($Year!=0){
echo "| Období řešení: ";
if ($Year)
echo "$Year";
if ($YearEnd)
echo "-$YearEnd";
echo " |
";
}
echo "";
echo "
";
/* echo "- ";
if ($Year)
echo "$Year";
if ($YearEnd)
echo "-$YearEnd";
if ($Number!=0)
echo " $Number-";
echo " $Name";
if ($head!=$IDWorker)
echo " (spoluřešitel)";
if ($text!="")
echo " - $text";*/
}
//echo "
";
}
}
if (($section=="ostatni")OR($section=="vse")){
if (sizeof($ostatni)>0){
echo "
Ostatní projekty
";
// echo "
";
for ($i=0; $i";
echo "| ";
echo "";
if ($Number!="")
echo " $Number - ";
echo "$Name";
echo "";
echo " |
";
echo "| Řešitel na KAR: ".ksa_get_name($head)." |
";
if ($poskytovatel!="")
echo "| Poskytovatel: $poskytovatel |
";
if ($Year!=0){
echo "| Období řešení: ";
if ($Year)
echo "$Year";
if ($YearEnd)
echo "-$YearEnd";
echo " |
";
}
echo "";
echo "
";
/* echo "- ";
if ($Year)
echo "$Year";
if ($YearEnd)
echo "-$YearEnd";
if ($Number!=0)
echo " $Number-";
echo " $Name";
if ($head!=$IDWorker)
echo " (spoluřešitel)";
echo " $text";*/
}
//echo "
";
}
}
?>