62 |
if ($psemestara == "") $warning = 10; |
if ($psemestara == "") $warning = 10; |
63 |
} |
} |
64 |
if (!$warning) { |
if (!$warning) { |
65 |
$studij = nl2br(ISO_Win($studij)); |
$studij = ISO_Win($studij); |
66 |
$zvanje = nl2br(ISO_Win($zvanje)); |
$zvanje = ISO_Win($zvanje); |
67 |
$sif = DBQuery("SELECT sif_str_spreme FROM strucne_spreme WHERE (language='$language') AND (stupanj='$st_spreme') AND (sif_vrsta_str_spreme=$vr_spreme)"); |
$sif = DBQuery("SELECT sif_str_spreme FROM strucne_spreme WHERE (language='$language') AND (stupanj='$st_spreme') AND (sif_vrsta_str_spreme=$vr_spreme)"); |
68 |
$sif = $sif[0][0]; |
$sif = $sif[0][0]; |
69 |
if (!$sif) $sif = 0; |
if (!$sif) $sif = 0; |
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"); |
172 |
$sm = HTML_Escape(Win_ISO($sm)); |
$sm = HTML_Escape(Win_ISO($sm)); |
173 |
$zv = HTML_Escape(Win_ISO($zv)); |
$zv = HTML_Escape(Win_ISO($zv)); |
174 |
$st = HTML_Escape(Win_ISO($st)); |
$st = HTML_Escape(Win_ISO($st)); |
175 |
$ust2 = ereg_replace("\r?\n", "<BR>", $ust2); |
$ust2 = nl2br($ust2); |
176 |
$sm2 = ereg_replace("\r?\n", "<BR>", $sm); |
$sm2 = nl2br($sm); |
177 |
$zv2 = ereg_replace("\r?\n", "<BR>", $zv); |
$zv2 = nl2br($zv); |
178 |
$st2 = ereg_replace("\r?\n", "<BR>", $st); |
$st2 = nl2br($st); |
179 |
$vr2 = ereg_replace("\r?\n", "<BR>", $vr2); |
$vr2 = nl2br($vr2); |
180 |
nepoznato($ust2); |
nepoznato($ust2); |
181 |
nepoznato($sm2); |
nepoznato($sm2); |
182 |
nepoznato($zv2); |
nepoznato($zv2); |