/[hr-web]/Overview.php
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Annotation of /Overview.php

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.2 - (hide annotations)
Wed Apr 25 13:18:46 2001 UTC (23 years ago) by dpavlin
Branch: MAIN
Changes since 1.1: +109 -75 lines
promjene za finalnu verziju

1 dpavlin 1.1 <?php
2     include("inc/global.php");
3     if (!Auth()) exit;
4     include("inc/conn.php");
5 dpavlin 1.2 function Prepare($str, $ne = true) {
6 dpavlin 1.1 $str = ereg_replace("\r?\n", "<BR>",
7     HTML_Escape(Win_ISO($str)));
8     if ($ne) nepoznato($str);
9     return $str;
10     }
11 dpavlin 1.2 $tpl = new MySmarty;
12 dpavlin 1.1 for ($i = 0; $i < count($pages); $i++)
13     $tpl->assign("page_".$i, $pages[$i].Params($i));
14     $tpl->assign("page_logout", $dir);
15     DBOpen();
16 dpavlin 1.2 # -- 1. Opci podaci
17 dpavlin 1.1 $rows = DBQuery("SELECT sif_radnika,ime,prezime,naziv_struke,opis,radna_jedinica,radno_mjesto,spol FROM osoba,org_jed WHERE (sif_radnika='$sifra') AND (sif_org_jed=sifra) AND (org_jed.language=osoba.language) AND (osoba.language='$language')");
18     list($sif, $ime, $prez, $struka, $org_jed, $rad_jed, $rm, $sp) = $rows[0];
19     $tpl->assign("sifra", Prepare($sif));
20     $tpl->assign("ime", Prepare($ime));
21     $tpl->assign("prezime", Prepare($prez));
22     $tpl->assign("struka", Prepare($struka));
23     $tpl->assign("org_jed", Prepare($org_jed));
24     $tpl->assign("radna_jed", Prepare($rad_jed));
25     $tpl->assign("radno_mj", Prepare($rm));
26 dpavlin 1.2 $sp = Prepare($sp, false);
27 dpavlin 1.1 $spol = $sp;
28     if (ereg("^[mM]$", $sp)) $spol = 1;
29     if (ereg("^[zZ¾®]$", $sp)) $spol = 2;
30     if (!$spol) $spol = "?";
31     $tpl->assign("spol", $spol);
32 dpavlin 1.2 # -- 2. Radna mjesta u Plivi
33     $rows = DBQuery("SELECT radno_mjesto,zadaci,datum_od,datum_do FROM u_plivi WHERE (sif_radnika='$sifra') ORDER BY datum_od");
34 dpavlin 1.1 $tmp = array();
35     for ($i = 0; $i < count($rows); $i++) {
36     list($rm, $zad, $od, $do) = $rows[$i];
37     $od = ParseDate($od);
38     $do = ParseDate($do);
39     array_push($tmp, array(
40     "radno_mj" => Prepare($rm),
41     "zadaci" => Prepare($zad),
42     "od_d" => $od["mday"], "od_m" => $od["mon"], "od_g" => $od["year"],
43     "do_d" => $do["mday"], "do_m" => $do["mon"], "do_g" => $do["year"]
44     ));
45     }
46     $tpl->assign("uplivi", $tmp);
47 dpavlin 1.2 # -- 3. Radna mjesta izvan Plive
48     $rows = DBQuery("SELECT tvrtka,radno_mjesto,zadaci,datum_od,datum_do FROM izvan_plive WHERE (sif_radnika='$sifra') ORDER BY datum_od");
49 dpavlin 1.1 $tmp = array();
50     for ($i = 0; $i < count($rows); $i++) {
51     list($tv, $rm, $zad, $od, $do) = $rows[$i];
52     $od = ParseDate($od);
53     $do = ParseDate($do);
54     array_push($tmp, array(
55     "tvrtka" => Prepare($tv),
56     "radno_mj" => Prepare($rm),
57     "zadaci" => Prepare($zad),
58     "od_d" => $od["mday"], "od_m" => $od["mon"], "od_g" => $od["year"],
59     "do_d" => $do["mday"], "do_m" => $do["mon"], "do_g" => $do["year"]
60     ));
61     }
62     $tpl->assign("izvanplive", $tmp);
63 dpavlin 1.2 # -- 4. Dodiplomski studij
64     $rows = DBQuery("SELECT sifra,naziv,grad FROM obrazovna_ustanova WHERE (language='$language')");
65     $ou = array();
66     for ($i = 0; $i < count($rows); $i++) {
67     list($sif, $naz, $grad) = $rows[$i];
68     if ($grad) $naz = "$naz, $grad";
69     $ou[$sif] = $naz;
70     }
71     $rows = DBQuery("SELECT sifra,opis FROM vrsta_strucne_spreme WHERE (language='$language')");
72     $vss = array();
73     for ($i = 0; $i < count($rows); $i++) {
74     list($sif, $opis) = $rows[$i];
75     $vss[$sif] = $opis;
76     }
77     $rows = DBQuery("SELECT sif_ustanove,naziv,titula,stupanj,sif_vrsta_str_spreme,datum_upisa,datum_zavrsetka FROM edukacije,strucne_spreme WHERE (sif_radnika='$sifra') AND (sif_qualification=1) AND (strucne_spreme.sif_str_spreme=edukacije.sif_strucna_sprema)");
78 dpavlin 1.1 $tmp = array();
79     for ($i = 0; $i < count($rows); $i++) {
80 dpavlin 1.2 list($naz, $sm, $zv, $st, $vr, $od, $do) = $rows[$i];
81 dpavlin 1.1 $od = ParseDate($od);
82     $do = ParseDate($do);
83     array_push($tmp, array(
84 dpavlin 1.2 "naziv" => Prepare($ou[$naz]),
85 dpavlin 1.1 "smjer" => Prepare($sm),
86     "zvanje" => Prepare($zv),
87     "sss" => Prepare($st),
88 dpavlin 1.2 "vss" => Prepare($vss[$vr]),
89 dpavlin 1.1 "od_d" => $od["mday"], "od_m" => $od["mon"], "od_g" => $od["year"],
90     "do_d" => $do["mday"], "do_m" => $do["mon"], "do_g" => $do["year"]
91     ));
92     }
93     $tpl->assign("dodiplomski", $tmp);
94 dpavlin 1.2 # -- 5. Poslijediplomski studij
95     # $ou je vec popunjeno.
96     # $vss je vec popunjeno.
97     $rows = DBQuery("SELECT 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");
98 dpavlin 1.1 $tmp = array();
99     for ($i = 0; $i < count($rows); $i++) {
100 dpavlin 1.2 list($naz, $sm, $zv, $st, $vr, $od, $do, $ui, $pi, $us, $ps) = $rows[$i];
101 dpavlin 1.1 $od = ParseDate($od);
102     $do = ParseDate($do);
103     array_push($tmp, array(
104 dpavlin 1.2 "naziv" => Prepare($ou[$naz]),
105 dpavlin 1.1 "studij" => Prepare($sm),
106     "zvanje" => Prepare($zv),
107     "sss" => Prepare($st),
108 dpavlin 1.2 "vss" => Prepare($vss[$vr]),
109 dpavlin 1.1 "od_d" => $od["mday"], "od_m" => $od["mon"], "od_g" => $od["year"],
110     "do_d" => $do["mday"], "do_m" => $do["mon"], "do_g" => $do["year"],
111     "uispita" => $ui, "pispita" => $pi,
112     "usemestara" => $us, "psemestara" => $ps
113     ));
114     }
115     $tpl->assign("poslijediplomski", $tmp);
116 dpavlin 1.2 # -- 6. Obrazovanje po propisima
117     $rows = DBQuery("SELECT sifra,naziv FROM tecajevi WHERE (language='$language') AND (sif_qualification=5)");
118     $tec = array();
119     for ($i = 0; $i < count($rows); $i++) {
120     list($id, $naz) = $rows[$i];
121     $tec[$id] = $naz;
122     }
123 dpavlin 1.1 $rows = DBQuery("SELECT sifra,naziv,grad FROM ustanove WHERE (language='$language')");
124     $ustanove = array();
125     for ($i = 0; $i < count($rows); $i++) {
126     list($sif, $naz, $gr) = $rows[$i];
127 dpavlin 1.2 if ($gr) $naz = "$naz, $gr";
128     $ustanove[$sif] = $naz;
129 dpavlin 1.1 }
130 dpavlin 1.2 $rows = DBQuery("SELECT sif_tecaja,certifikati.sif_ustanove,edukacije.sif_ustanove,datum_upisa,datum_zavrsetka,certifikati.naziv,certifikati.titula,dat_polaganja,dat_izdavanja,dat_vrijedi_do FROM certifikati,edukacije WHERE (certifikati.sif_radnika=edukacije.sif_radnika) AND (edukacije.sif_radnika='$sifra') AND (certifikati.sif_edukacije=edukacije.sifra) AND (sif_qualification=5) ORDER BY datum_upisa");
131 dpavlin 1.1 $tmp = array();
132     for ($i = 0; $i < count($rows); $i++) {
133     list($edu, $ust, $tec, $od, $do, $naz, $tit, $pol, $izd, $ist) = $rows[$i];
134     $od = ParseDate($od);
135     $do = ParseDate($do);
136     $pol = ParseDate($pol);
137     $izd = ParseDate($izd);
138     $ist = ParseDate($ist);
139     array_push($tmp, array(
140 dpavlin 1.2 "edukacija" => Prepare($tec[$edu]),
141     "tecaj_naz" => Prepare($ustanove[$tec]),
142     "ispit_naz" => Prepare($ustanove[$ust]),
143 dpavlin 1.1 "licenca" => Prepare($naz),
144     "zvanje" => Prepare($tit),
145     "od_d" => $od["mday"], "od_m" => $od["mon"], "od_g" => $od["year"],
146     "do_d" => $do["mday"], "do_m" => $do["mon"], "do_g" => $do["year"],
147     "pol_d" => $pol["mday"], "pol_m" => $pol["mon"], "pol_g" => $pol["year"],
148     "izd_d" => $izd["mday"], "izd_m" => $izd["mon"], "izd_g" => $izd["year"],
149     "ist_d" => $ist["mday"], "ist_m" => $ist["mon"], "ist_g" => $ist["year"]
150     ));
151     }
152     $tpl->assign("obrazovanje", $tmp);
153 dpavlin 1.2 # -- 7. Tecajevi managementa
154 dpavlin 1.1 $rows = DBQuery("SELECT sifra,naziv FROM tecajevi WHERE (language='$language') AND (sif_qualification=6)");
155 dpavlin 1.2 $tec = array();
156 dpavlin 1.1 for ($i = 0; $i < count($rows); $i++) {
157 dpavlin 1.2 list($id, $naz) = $rows[$i];
158     $tec[$id] = $naz;
159 dpavlin 1.1 }
160 dpavlin 1.2 # $ustanove je vec popunjeno.
161     $rows = DBQuery("SELECT sif_tecaja,sif_ustanove,datum_upisa,datum_zavrsetka,grad_odrzavanja_tecaja FROM edukacije WHERE (sif_radnika='$sifra') AND (sif_qualification=6) ORDER BY datum_upisa");
162 dpavlin 1.1 $tmp = array();
163     for ($i = 0; $i < count($rows); $i++) {
164 dpavlin 1.2 list($edu, $ust, $od, $do, $mj) = $rows[$i];
165 dpavlin 1.1 $od = ParseDate($od);
166     $do = ParseDate($do);
167     array_push($tmp, array(
168 dpavlin 1.2 "tecaj" => Prepare($tec[$edu]),
169     "ust_naz" => Prepare($ustanove[$ust]),
170 dpavlin 1.1 "od_d" => $od["mday"], "od_m" => $od["mon"], "od_g" => $od["year"],
171     "do_d" => $do["mday"], "do_m" => $do["mon"], "do_g" => $do["year"],
172     "mjesto" => Prepare($mj)
173     ));
174     }
175     $tpl->assign("tecajevi", $tmp);
176 dpavlin 1.2 # -- 8. Strucne i ostale edukacije
177     $rows = DBQuery("SELECT sifra,naziv FROM tecajevi WHERE (language='$language') AND (sif_qualification=7)");
178     $tec = array();
179     for ($i = 0; $i < count($rows); $i++) {
180     list($id, $naz) = $rows[$i];
181     $tec[$id] = $naz;
182     }
183     # $ustanove je vec popunjeno.
184     $rows = DBQuery("SELECT sif_tecaja,sif_ustanove,datum_upisa,datum_zavrsetka,grad_odrzavanja_tecaja,titula,zavrsio_ispitom FROM edukacije WHERE (sif_radnika='$sifra') AND (sif_qualification=7) ORDER BY datum_upisa");
185 dpavlin 1.1 $tmp = array();
186     for ($i = 0; $i < count($rows); $i++) {
187 dpavlin 1.2 list($edu, $ust, $od, $do, $mj, $tit, $form) = $rows[$i];
188 dpavlin 1.1 $od = ParseDate($od);
189     $do = ParseDate($do);
190     array_push($tmp, array(
191 dpavlin 1.2 "tecaj" => Prepare($tec[$edu]),
192     "ust_naz" => Prepare($ustanove[$ust]),
193 dpavlin 1.1 "mjesto" => Prepare($mj),
194     "zvanje" => Prepare($tit),
195 dpavlin 1.2 "formalno" => (strcasecmp("false", $form) != 0),
196 dpavlin 1.1 "od_d" => $od["mday"], "od_m" => $od["mon"], "od_g" => $od["year"],
197     "do_d" => $do["mday"], "do_m" => $do["mon"], "do_g" => $do["year"],
198     ));
199     }
200     $tpl->assign("ostalo", $tmp);
201 dpavlin 1.2 # -- 9. Strani jezici
202     $rows = DBQuery("SELECT sifra,opis FROM strani_jezik WHERE (language='$language') AND (opis<>'')");
203     $sj = array();
204     for ($i = 0; $i < count($rows); $i++) {
205     list($id, $naz) = $rows[$i];
206     $sj[$id] = $naz;
207     }
208     $rows = DBQuery("SELECT sifra,stupanj FROM stupanj_str_jezika WHERE (language='$language') AND (stupanj<>'')");
209     $st = array();
210     for ($i = 0; $i < count($rows); $i++) {
211     list($id, $naz) = $rows[$i];
212     $st[$id] = $naz;
213     }
214     $rows = DBQuery("SELECT sif_stranog_jezika,stupanj_str_jezika FROM edukacije WHERE (sif_radnika='$sifra') AND (sif_qualification=3)");
215 dpavlin 1.1 $tmp = array();
216     for ($i = 0; $i < count($rows); $i++) {
217     list($jez, $stup) = $rows[$i];
218     array_push($tmp, array(
219 dpavlin 1.2 "naziv" => Prepare($sj[$jez]),
220     "stupanj" => Prepare($st[$stup])
221 dpavlin 1.1 ));
222     }
223     $tpl->assign("jezici", $tmp);
224 dpavlin 1.2 # -- 10. Vjestina rada s racunalom
225     $rows = DBQuery("SELECT sifra,naziv FROM tecajevi WHERE (language='$language') AND (sif_qualification=4) AND (naziv<>'')");
226     $ap = array();
227     for ($i = 0; $i < count($rows); $i++) {
228     list($id, $naz) = $rows[$i];
229     $ap[$id] = $naz;
230     }
231     $rows = DBQuery("SELECT sif_tecaja FROM edukacije WHERE (sif_radnika='$sifra') AND (sif_qualification=4)");
232 dpavlin 1.1 $tmp = array();
233     for ($i = 0; $i < count($rows); $i++) {
234 dpavlin 1.2 list($a) = $rows[$i];
235 dpavlin 1.1 array_push($tmp, array(
236 dpavlin 1.2 "naziv" => Prepare($ap[$a]),
237 dpavlin 1.1 ));
238     }
239     $tpl->assign("racunalo", $tmp);
240 dpavlin 1.2 # -- 11. Nagrade i priznanja
241     # $ustanove je vec popunjeno.
242     $rows = DBQuery("SELECT naziv,sif_ustanove,urucitelj,godina FROM nagrade WHERE (sif_radnika='$sifra') ORDER BY godina");
243 dpavlin 1.1 $tmp = array();
244     for ($i = 0; $i < count($rows); $i++) {
245 dpavlin 1.2 list($naz, $ust, $ur, $god) = $rows[$i];
246 dpavlin 1.1 array_push($tmp, array(
247     "naziv" => Prepare($naz),
248 dpavlin 1.2 "ust_naz" => Prepare($ustanove[$ust]),
249 dpavlin 1.1 "urucitelj" => Prepare($ur),
250 dpavlin 1.2 "godina" => Prepare($god, false)
251 dpavlin 1.1 ));
252     }
253     $tpl->assign("nagrade", $tmp);
254 dpavlin 1.2 # -- 12. Objavljeni radovi / clanci / knjige
255     $rows = DBQuery("SELECT naziv_rada_knjige,naziv_casopisa,godina FROM radovi WHERE (sif_str_skupa=0) AND (sif_radnika='$sifra') ORDER BY godina");
256 dpavlin 1.1 $tmp = array();
257     for ($i = 0; $i < count($rows); $i++) {
258     list($rad, $kom, $god) = $rows[$i];
259     array_push($tmp, array(
260     "naziv" => Prepare($rad),
261     "komentar" => Prepare($kom),
262 dpavlin 1.2 "godina" => Prepare($god, false)
263 dpavlin 1.1 ));
264     }
265     $tpl->assign("radovi", $tmp);
266 dpavlin 1.2 # -- 13. Sudjelovanje na strucnim skupovima
267     $rows = DBQuery("SELECT naziv,grad,datum_od,datum_do,naziv_rada_knjige FROM strucni_skupovi,radovi WHERE (radovi.sif_str_skupa=strucni_skupovi.rbr) AND (strucni_skupovi.sif_radnika=radovi.sif_radnika) AND (radovi.sif_radnika='$sifra') ORDER BY datum_od");
268 dpavlin 1.1 $tmp = array();
269     for ($i = 0; $i < count($rows); $i++) {
270     list($naz, $mj, $od, $do, $rd) = $rows[$i];
271     $od = ParseDate($od);
272     $do = ParseDate($do);
273     array_push($tmp, array(
274     "naziv" => Prepare($naz),
275     "mjesto" => Prepare($mj),
276     "rad" => Prepare($rd),
277     "od_d" => $od["mday"], "od_m" => $od["mon"], "od_g" => $od["year"],
278     "do_d" => $do["mday"], "do_m" => $do["mon"], "do_g" => $do["year"],
279     ));
280     }
281     $tpl->assign("skupovi", $tmp);
282 dpavlin 1.2 # -- 14. O meni
283 dpavlin 1.1 $rows = DBQuery("SELECT opis FROM o_meni WHERE (sif_radnika='$sifra')");
284 dpavlin 1.2 $tpl->assign("omeni", Prepare($rows[0][0], false));
285     # -- KRAJ
286 dpavlin 1.1 DBClose();
287 dpavlin 1.2 $tpl->show();
288 dpavlin 1.1 ?>

  ViewVC Help
Powered by ViewVC 1.1.26