--- Overview.php 2002/06/19 18:32:42 1.5 +++ Overview.php 2002/06/26 14:50:40 1.6 @@ -14,8 +14,8 @@ $tpl->assign("page_logout", $dir); DBOpen(); # -- 1. Opci podaci - $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)"); - list($sif, $ime, $prez, $struka, $org_jed, $rad_jed, $rm, $sp) = $rows[0]; + $rows = DBQuery("SELECT sif_radnika,ime,prezime,naziv_struke,opis,radna_jedinica,radno_mjesto,spol,telefon,email,stupanj_str_spreme,smjer,titula,datum_rodjenja FROM osoba,org_jed WHERE (sif_radnika='$sifra') AND (sif_org_jed=sifra) AND (org_jed.language=osoba.language)"); + list($sif, $ime, $prez, $struka, $org_jed, $rad_jed, $rm, $sp, $tel, $em, $sss, $smj, $zv, $dr) = $rows[0]; $tpl->assign("sifra", Prepare($sif)); $tpl->assign("ime", Prepare($ime)); $tpl->assign("prezime", Prepare($prez)); @@ -23,6 +23,15 @@ $tpl->assign("org_jed", Prepare($org_jed)); $tpl->assign("radna_jed", Prepare($rad_jed)); $tpl->assign("radno_mj", Prepare($rm)); + $tpl->assign("smjer", Prepare($smj)); + $tpl->assign("zvanje", Prepare($zv)); + $tpl->assign("sss", Prepare($sss)); + $tpl->assign("telefon", Prepare($tel)); + $tpl->assign("email", Prepare($em)); + $dr = ParseDate($dr); + $tpl->assign("dat_rod_d", $dr["mday"]); + $tpl->assign("dat_rod_m", $dr["mon"]); + $tpl->assign("dat_rod_g", $dr["year"]); $sp = Prepare($sp, false); $spol = $sp; if (ereg("^[mM]$", $sp)) $spol = 'M';