4 |
include("inc/prava.inc"); |
include("inc/prava.inc"); |
5 |
include("inc/show_bool.inc"); |
include("inc/show_bool.inc"); |
6 |
include("inc/bgcolor.inc"); |
include("inc/bgcolor.inc"); |
7 |
|
include("inc/sap_org_jed.inc"); |
8 |
|
|
9 |
$nresult = pg_Exec ($conn, " |
$nresult = pg_Exec ($conn, " |
10 |
select osobe.id as id,ime,prezime,tel,lokacije.naziv as lok,sifra, |
select osobe.id as id,ime,prezime,tel,lokacije.naziv as lok,sifra, |
|
org_jed.naziv as orgjed,org_pod_jed.pod_naziv as orgpodjed, |
|
11 |
lok_racunala as lokrac,objekt,kat,soba,z_rac,podesavanje, |
lok_racunala as lokrac,objekt,kat,soba,z_rac,podesavanje, |
12 |
umrezavanje,shell |
umrezavanje,shell |
13 |
from osobe |
from osobe |
14 |
where osobe.id=$osoba_id |
where osobe.id=$osoba_id |
15 |
and lokacija_id=lokacije.id and org_jed_id=org_jed.id |
and lokacija_id=lokacije.id |
|
and org_pod_jed_id=org_pod_jed.pod_id |
|
16 |
"); |
"); |
17 |
|
|
18 |
$oresult = pg_Exec ($conn, " |
$oresult = pg_Exec ($conn, " |
19 |
select osobe.id as id,ime,prezime,tel,lokacije.naziv as lok,sifra, |
select osobe.id as id,ime,prezime,tel,lokacije.naziv as lok,sifra, |
|
org_jed.naziv as orgjed,org_pod_jed.pod_naziv as orgpodjed, |
|
20 |
lok_racunala as lokrac,objekt,kat,soba,z_rac,podesavanje, |
lok_racunala as lokrac,objekt,kat,soba,z_rac,podesavanje, |
21 |
umrezavanje,shell |
umrezavanje,shell |
22 |
from promjene_osobe |
from promjene_osobe |
23 |
where promjene_osobe.status_id=$status_id |
where promjene_osobe.status_id=$status_id |
24 |
and lokacija_id=lokacije.id and org_jed_id=org_jed.id |
and lokacija_id=lokacije.id |
|
and org_pod_jed_id=org_pod_jed.pod_id |
|
25 |
"); |
"); |
26 |
|
|
27 |
if (pg_numrows($nresult) > 0 && pg_numrows($oresult) > 0) { |
if (pg_numrows($nresult) > 0 && pg_numrows($oresult) > 0) { |
45 |
".cmptd("$orow[ime] $orow[prezime]","$nrow[ime] $nrow[prezime]")." |
".cmptd("$orow[ime] $orow[prezime]","$nrow[ime] $nrow[prezime]")." |
46 |
".cmptd("<small>Tel:</small> $orow[tel]","<small>Tel:</small> $nrow[tel]")." |
".cmptd("<small>Tel:</small> $orow[tel]","<small>Tel:</small> $nrow[tel]")." |
47 |
</tr> |
</tr> |
48 |
<tr><td><small>Org. jedinica:</small></td> |
<tr><td rowspan=2><small>Org. jedinica:</small></td> |
49 |
".cmptd("$orow[orgjed]","$nrow[orgjed]")." |
".cmptd(sap_org_jed($orow[sifra]),sap_org_jed($nrow[sifra]))." |
50 |
".cmptd("<small>Šifra radnika:</small> $orow[sifra]","<small>Šifra radnika:</small> $nrow[sifra]")."</tr> |
".cmptd("<small>Šifra radnika:</small> $orow[sifra]","<small>Šifra radnika:</small> $nrow[sifra]")."</tr> |
51 |
<tr><td><small>Podjedinica:</small></td> |
<tr><td></td> |
|
".cmptd("$orow[orgpodjed]","$nrow[orgpodjed]")." |
|
52 |
<td><small>Lokacija računala:</small></td></tr> |
<td><small>Lokacija računala:</small></td></tr> |
53 |
<tr><td><small>Lokacija:</small></td> |
<tr><td><small>Lokacija:</small></td> |
54 |
".cmptd("$orow[lok]","$nrow[lok]")." |
".cmptd("$orow[lok]","$nrow[lok]")." |