";
if (!$_REQUEST['id']) {
$query="SELECT i.id,i.naziv1,i.naziv2,i.naslov,i.posta,i.posta1,sifP.Kraj,sifD.NazivDrzave FROM izvajalec$leto_db AS i
LEFT JOIN sifPoste AS sifP ON sifP.Posta=i.posta
LEFT JOIN sifDrzave AS sifD ON sifD.Drzava=i.drzava
WHERE aktiven='1' AND status=10 ORDER BY naziv1";
$result=mysql_query($query);
$no=mysql_num_rows($result);
$izpis.="NACIONALNI KOORDINATOR ($no)
";
while($row=mysql_fetch_row($result)){
$test_chr=$row[1]{0};
$test_chr=strtoupper($test_chr);
$izpis.="
$row[1]
";
if ($row[2]) $izpis.= "$row[2]
";
if ($row[4]) $izpis.= "$row[3], $row[4] $row[6]";
else if ($row[5]) $izpis.= "$row[5], $row[7]";
$izpis.="
";
}
$query="SELECT i.id,i.naziv1,i.naziv2,i.naslov,i.posta,i.posta1,sifP.Kraj,sifD.NazivDrzave FROM izvajalec$leto_db AS i
LEFT JOIN sifPoste AS sifP ON sifP.Posta=i.posta
LEFT JOIN sifDrzave AS sifD ON sifD.Drzava=i.drzava
WHERE aktiven='1' AND status=1 ORDER BY naziv1";
$result=mysql_query($query);
$no=mysql_num_rows($result);
$izpis.="OBMOČNI KOORDINATORJI ($no)
";
while($row=mysql_fetch_row($result)){
$test_chr=$row[1]{0};
$test_chr=strtoupper($test_chr);
$izpis.="
$row[1]
";
if ($row[2]) $izpis.= "$row[2]
";
if ($row[4]) $izpis.= "$row[3], $row[4] $row[6]";
else if ($row[5]) $izpis.= "$row[5], $row[7]";
$izpis.="
";
}
$query="SELECT i.id,i.naziv1,i.naziv2,i.naslov,i.posta,i.posta1,sifP.Kraj,sifD.NazivDrzave FROM izvajalec$leto_db AS i
LEFT JOIN sifPoste AS sifP ON sifP.Posta=i.posta
LEFT JOIN sifDrzave AS sifD ON sifD.Drzava=i.drzava
WHERE aktiven='1' AND status=2 ORDER BY naziv1";
$result=mysql_query($query);
$no=mysql_num_rows($result);
$izpis.="
TEMATSKI KOORDINATORJI ($no)
";
while($row=mysql_fetch_row($result)){
$test_chr=$row[1]{0};
$test_chr=strtoupper($test_chr);
$izpis.="
$row[1]
";
if ($row[2]) $izpis.= "$row[2]
";
if ($row[4]) $izpis.= "$row[3], $row[4] $row[6]";
else if ($row[5]) $izpis.= "$row[5], $row[7]";
$izpis.="
";
}
$izpis.="
";
} // if !$id
else {
$query="SELECT i.naziv1,i.naziv2,i.naslov,i.posta,sifP.Kraj,sifD.NazivDrzave,i.url,i.kontakt_ime,i.telefon,i.kontakt_eposta,i.posta1 FROM izvajalec$leto_db AS i
LEFT JOIN sifPoste AS sifP ON sifP.Posta=i.posta
LEFT JOIN sifDrzave AS sifD ON sifD.Drzava=i.drzava
WHERE aktiven='1' AND id='$id'";
//$query="SELECT naziv1,naziv2,naslov,posta,kraj,drzava,spletna,kontaktna,telefon,mail FROM izvajalci AS i
$result_tblRegister=mysql_fetch_row(mysql_query($query));
$n=0;
$izpis.= "$result_tblRegister[0]
";
if ($result_tblRegister[1]) $izpis.= "$result_tblRegister[1]
";
//if ($result_tblRegister[2]) $izpis .= " $result_tblRegister[2]
";
//$izpis .= "
";
if ($result_tblRegister[2]) $izpis.= "$result_tblRegister[2], $result_tblRegister[3] $result_tblRegister[4]";
else if ($result_tblRegister[10]) $izpis.= "$result_tblRegister[10], $result_tblRegister[5]";
$izpis.= "
";
//if ($result_tblRegister[3] || $result_tblRegister[2]) $izpis .= "$result_tblRegister[2], $result_tblRegister[3] $result_tblRegister[4]
";
if ($result_tblRegister[6] && $result_tblRegister[6]!="http://") {
$result_tblRegister[6]=str_replace("http://","",$result_tblRegister[6]);
$izpis .= "Spletna stran: http://$result_tblRegister[6]
";
}
$izpis .= "
";
if ($result_tblRegister[7]) $izpis .= "Kontaktna oseba: $result_tblRegister[7]
";
if ($result_tblRegister[8]) $izpis .= "Telefon: $result_tblRegister[8]
";
if ($result_tblRegister[9]) {
$e_posteA=explode(";",$result_tblRegister[9]);
$n=0;
foreach ($e_posteA as $eposte) {
if (!$n) {
$izpis.= "E-pošta: ";
$n++;
}
if ($eposte) $izpis.= "$eposte ";
}
}
$izpis.= "
Vse prireditve izbranega koordinatorja in koordiniranih organizacij
";
$izpis.="
Koordinirani izvajalci
";
$query="SELECT i.id,i.naziv1,i.naziv2,i.naslov,i.posta,i.posta1,sifP.Kraj,sifD.NazivDrzave FROM izvajalec$leto_db AS i
LEFT JOIN sifPoste AS sifP ON sifP.Posta=i.posta
LEFT JOIN sifDrzave AS sifD ON sifD.Drzava=i.drzava
WHERE i.aktiven='1' AND (i.rkoord_id='$id' OR i.tkoord_id='$id') ORDER BY i.naziv1";
$result=mysql_query($query);
$n=0;
while($row=mysql_fetch_row($result)){
$n++;
$test_chr=$row[1]{0};
$test_chr=strtoupper($test_chr);
$izpis.="
$row[1]
";
if ($row[2]) $izpis.= "$row[2]
";
$izpis.=" ";
if ($row[4]) $izpis.= "$row[3], $row[4] $row[6]";
else if ($row[5]) $izpis.= "$row[5], $row[7]";
$izpis.="
";
}
$izpis.= "Skupaj koordiniranih izvajalcev: $n
";
}
$naslov="Koordinatorji TVU $leto_db";
require "../../inc/jedro_koledar.php";
?>