--- Poslijediplomski.php 2002/07/23 13:08:57 1.6 +++ Poslijediplomski.php 2002/09/05 08:52:21 1.7 @@ -75,8 +75,7 @@ DBQuery("INSERT INTO edukacije (sifra,sif_radnika,sif_ustanove,naziv,titula,sif_strucna_sprema,datum_upisa,datum_zavrsetka,ukupno_ispita,polozenih_ispita,ukupno_semestara,polozenih_semestara,sif_qualification) VALUES ($id,'$sifra',$obr_ust,'$studij','$zvanje',$sif,'$datum_od',".($datum_do?"'$datum_do'":"NULL").",$uispita,$pispita,$usemestara,$psemestara,2)"); } } - } else if ($edit) - DBQuery("DELETE FROM edukacije WHERE (sifra=$edit) AND (sif_radnika='$sifra') AND (sif_qualification=2)"); + } else if ($edit) DBQuery("DELETE FROM edukacije WHERE (sifra=$edit) AND (sif_radnika='$sifra') AND (sif_qualification=2)"); if ($p != $page && !$warning && !$DBH->errstr) { DBClose(); Header("Location: $pages[$p]".Params($p)); @@ -89,30 +88,64 @@ unset($dat_do, $dat_do_d, $dat_do_m, $dat_do_g); } include("inc/util.php"); - $rows = DBQuery("SELECT sifra,naziv,grad FROM ustanove WHERE (language='$language') AND (naziv||grad <> '') AND (obrazovna)"); + $rows = DBQuery("SELECT sifra, naziv, grad FROM ustanove WHERE language='$language' AND naziv||grad<>'' AND obrazovna"); $ustanove = array(); for ($i = 0; $i < count($rows); $i++) { list($sif, $naz, $grad) = $rows[$i]; if ($grad) $naz = "$naz, $grad"; - array_push($ustanove, array("id" => $sif, - "name" => HTML_Escape(Win_ISO($naz)))); + array_push($ustanove, array( + "id" => $sif, + "name" => HTML_Escape(Win_ISO($naz)) + )); } usort($ustanove, "sort_name"); +/* STARO!!! $rows = DBQuery("SELECT DISTINCT stupanj FROM strucne_spreme WHERE (language='$language')"); $sss = array(); for ($i = 0; $i < count($rows); $i++) { list($naz) = $rows[$i]; $naz = Win_ISO($naz); - array_push($sss, array("id" => $naz, - "name" => HTML_Escape(Win_ISO($naz)))); + array_push($sss, array( + "id" => $naz, + "name" => HTML_Escape(Win_ISO($naz)) + )); } usort($sss, "sort_name"); +*/ + $sss = array(); + switch ($language) { + case "HR": + $sss = array( + array("id" => "VSS", "name" => "VSS"), + array("id" => "Dr", "name" => "Dr"), + array("id" => "Mr", "name" => "Mr"), + array("id" => "MBA", "name" => "MBA"), + array("id" => "Spec", "name" => "specijalizacija"), + array("id" => "Stud", "name" => "studijski boravak") + ); + break; + case "EN": + $sss = array( + array("id" => "VSS", "name" => "VSS"), + array("id" => "Dr", "name" => "PhD"), + array("id" => "Mr", "name" => "Mr"), + array("id" => "MBA", "name" => "MBA"), + array("id" => "Spec", "name" => "specialization"), + array("id" => "Stud", "name" => "professional experience") + ); + break; + default: + $sss = array(); + break; + } $rows = DBQuery("SELECT sifra,opis FROM vrsta_strucne_spreme WHERE (language='$language') AND (opis<>'')"); $vss = array(); for ($i = 0; $i < count($rows); $i++) { list($sif, $naz) = $rows[$i]; - array_push($vss, array("id" => $sif, - "name" => HTML_Escape(Win_ISO($naz)))); + array_push($vss, array( + "id" => $sif, + "name" => HTML_Escape(Win_ISO($naz)) + )); } usort($vss, "sort_name"); $rows = DBQuery("SELECT edukacije.sifra,sif_ustanove,naziv,titula,stupanj,sif_vrsta_str_spreme,datum_upisa,datum_zavrsetka,ukupno_ispita,polozenih_ispita,ukupno_semestara,polozenih_semestara FROM edukacije,strucne_spreme WHERE (sif_radnika='$sifra') AND (sif_qualification=2) AND (strucne_spreme.sif_str_spreme=edukacije.sif_strucna_sprema) ORDER BY datum_upisa");