75 |
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)"); |
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)"); |
76 |
} |
} |
77 |
} |
} |
78 |
} else if ($edit) |
} else if ($edit) DBQuery("DELETE FROM edukacije WHERE (sifra=$edit) AND (sif_radnika='$sifra') AND (sif_qualification=2)"); |
|
DBQuery("DELETE FROM edukacije WHERE (sifra=$edit) AND (sif_radnika='$sifra') AND (sif_qualification=2)"); |
|
79 |
if ($p != $page && !$warning && !$DBH->errstr) { |
if ($p != $page && !$warning && !$DBH->errstr) { |
80 |
DBClose(); |
DBClose(); |
81 |
Header("Location: $pages[$p]".Params($p)); |
Header("Location: $pages[$p]".Params($p)); |
88 |
unset($dat_do, $dat_do_d, $dat_do_m, $dat_do_g); |
unset($dat_do, $dat_do_d, $dat_do_m, $dat_do_g); |
89 |
} |
} |
90 |
include("inc/util.php"); |
include("inc/util.php"); |
91 |
$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"); |
92 |
$ustanove = array(); |
$ustanove = array(); |
93 |
for ($i = 0; $i < count($rows); $i++) { |
for ($i = 0; $i < count($rows); $i++) { |
94 |
list($sif, $naz, $grad) = $rows[$i]; |
list($sif, $naz, $grad) = $rows[$i]; |
95 |
if ($grad) $naz = "$naz, $grad"; |
if ($grad) $naz = "$naz, $grad"; |
96 |
array_push($ustanove, array("id" => $sif, |
array_push($ustanove, array( |
97 |
"name" => HTML_Escape(Win_ISO($naz)))); |
"id" => $sif, |
98 |
|
"name" => HTML_Escape(Win_ISO($naz)) |
99 |
|
)); |
100 |
} |
} |
101 |
usort($ustanove, "sort_name"); |
usort($ustanove, "sort_name"); |
102 |
|
/* STARO!!! |
103 |
$rows = DBQuery("SELECT DISTINCT stupanj FROM strucne_spreme WHERE (language='$language')"); |
$rows = DBQuery("SELECT DISTINCT stupanj FROM strucne_spreme WHERE (language='$language')"); |
104 |
$sss = array(); |
$sss = array(); |
105 |
for ($i = 0; $i < count($rows); $i++) { |
for ($i = 0; $i < count($rows); $i++) { |
106 |
list($naz) = $rows[$i]; |
list($naz) = $rows[$i]; |
107 |
$naz = Win_ISO($naz); |
$naz = Win_ISO($naz); |
108 |
array_push($sss, array("id" => $naz, |
array_push($sss, array( |
109 |
"name" => HTML_Escape(Win_ISO($naz)))); |
"id" => $naz, |
110 |
|
"name" => HTML_Escape(Win_ISO($naz)) |
111 |
|
)); |
112 |
} |
} |
113 |
usort($sss, "sort_name"); |
usort($sss, "sort_name"); |
114 |
|
*/ |
115 |
|
$sss = array(); |
116 |
|
switch ($language) { |
117 |
|
case "HR": |
118 |
|
$sss = array( |
119 |
|
array("id" => "VSS", "name" => "VSS"), |
120 |
|
array("id" => "Dr", "name" => "Dr"), |
121 |
|
array("id" => "Mr", "name" => "Mr"), |
122 |
|
array("id" => "MBA", "name" => "MBA"), |
123 |
|
array("id" => "Spec", "name" => "specijalizacija"), |
124 |
|
array("id" => "Stud", "name" => "studijski boravak") |
125 |
|
); |
126 |
|
break; |
127 |
|
case "EN": |
128 |
|
$sss = array( |
129 |
|
array("id" => "VSS", "name" => "VSS"), |
130 |
|
array("id" => "Dr", "name" => "PhD"), |
131 |
|
array("id" => "Mr", "name" => "Mr"), |
132 |
|
array("id" => "MBA", "name" => "MBA"), |
133 |
|
array("id" => "Spec", "name" => "specialization"), |
134 |
|
array("id" => "Stud", "name" => "professional experience") |
135 |
|
); |
136 |
|
break; |
137 |
|
default: |
138 |
|
$sss = array(); |
139 |
|
break; |
140 |
|
} |
141 |
$rows = DBQuery("SELECT sifra,opis FROM vrsta_strucne_spreme WHERE (language='$language') AND (opis<>'')"); |
$rows = DBQuery("SELECT sifra,opis FROM vrsta_strucne_spreme WHERE (language='$language') AND (opis<>'')"); |
142 |
$vss = array(); |
$vss = array(); |
143 |
for ($i = 0; $i < count($rows); $i++) { |
for ($i = 0; $i < count($rows); $i++) { |
144 |
list($sif, $naz) = $rows[$i]; |
list($sif, $naz) = $rows[$i]; |
145 |
array_push($vss, array("id" => $sif, |
array_push($vss, array( |
146 |
"name" => HTML_Escape(Win_ISO($naz)))); |
"id" => $sif, |
147 |
|
"name" => HTML_Escape(Win_ISO($naz)) |
148 |
|
)); |
149 |
} |
} |
150 |
usort($vss, "sort_name"); |
usort($vss, "sort_name"); |
151 |
$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"); |
$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"); |