1 |
<?php |
2 |
include("inc/global.php"); |
3 |
if (!Auth()) exit; |
4 |
$page = CalcPage($PHP_SELF); |
5 |
$p = $page; |
6 |
if (isparam("wb_p")) $p--; |
7 |
if (isparam("wb_OK")) $p++; |
8 |
if (isparam("wb_h")) $p = $PG_HOME; |
9 |
if (isparam("wb_o")) $p = $PG_OVERVIEW; |
10 |
include("inc/conn.php"); |
11 |
DBOpen(); |
12 |
if ($p != $page) { |
13 |
DBQuery("UPDATE osoba SET smjer='".ISO_Win($smjer)."',titula='".ISO_Win($zvanje)."' WHERE (sif_radnika='$sifra') AND (language='$language')"); |
14 |
$ret = $DBH->errstr; |
15 |
DBClose(); |
16 |
if (!$ret) { |
17 |
Header("Location: $pages[$p]".Params($p)); |
18 |
exit; |
19 |
} |
20 |
} |
21 |
$row = DBQuery("SELECT sif_radnika,ime,prezime,datum_rodjenja,spol,naziv_struke,smjer,stupanj_str_spreme,titula,org_jed.opis,radna_jedinica,radno_mjesto,telefon,email FROM osoba,org_jed WHERE (osoba.sif_org_jed=org_jed.sifra) AND (sif_radnika='$sifra') AND (org_jed.language=osoba.language) AND (osoba.language='$language')"); |
22 |
DBClose(); |
23 |
$row = $row[0]; |
24 |
for ($i = 0; $i < count($row); $i++) { |
25 |
$row[$i] = HTML_escape(Win_ISO($row[$i])); |
26 |
if ($i != 6 && $i != 8) nepoznato($row[$i]); |
27 |
} |
28 |
$tpl = new MySmarty; |
29 |
$tpl->assign("sifra", $row[0]); |
30 |
$tpl->assign("ime", $row[1]); |
31 |
$tpl->assign("prezime", $row[2]); |
32 |
$row[3] = ParseDate($row[3]); |
33 |
$tpl->assign("dat_rod_d", $row[3]["mday"]); |
34 |
$tpl->assign("dat_rod_m", $row[3]["mon"]); |
35 |
$tpl->assign("dat_rod_g", $row[3]["year"]); |
36 |
$spol = $row[4]; |
37 |
if (ereg("^[mM]$", $row[4])) $spol = 1; |
38 |
if (ereg("^[zZ¾®]$", $row[4])) $spol = 2; |
39 |
$tpl->assign("spol", $spol); |
40 |
$tpl->assign("naziv_struke", $row[5]); |
41 |
$tpl->assign("smjer", $row[6]); |
42 |
$tpl->assign("strucna_sprema", $row[7]); |
43 |
$tpl->assign("zvanje", $row[8]); |
44 |
$tpl->assign("org_jedinica", $row[9]); |
45 |
$tpl->assign("radna_jedinica", $row[10]); |
46 |
$tpl->assign("radno_mjesto", $row[11]); |
47 |
$tpl->assign("telefon", $row[12]); |
48 |
$tpl->assign("email", $row[13]); |
49 |
$tpl->show(); |
50 |
?> |