2 |
|
|
3 |
include("inc/head.inc"); |
include("inc/head.inc"); |
4 |
include("inc/prava.inc"); |
include("inc/prava.inc"); |
5 |
|
include("inc/checkbox.inc"); |
6 |
|
|
7 |
if (! isset($from)) { |
if (! isset($from)) { |
8 |
$from=0; |
$from=0; |
9 |
|
$podesavanje="on"; $umrezavanje="on"; |
10 |
} |
} |
11 |
|
|
12 |
if (! isset($kontakt_osoba_id) || ! intval($kontakt_osoba_id)!=0) { |
if (! isset($kontakt_osoba_id) || ! intval($kontakt_osoba_id)!=0) { |
40 |
echo ">$text</option>"; |
echo ">$text</option>"; |
41 |
} |
} |
42 |
|
|
|
function checkbox($name,$current) { |
|
|
echo "<input type=\"checkbox\" name=\"$name\""; |
|
|
if (isset($current)) { |
|
|
echo " checked"; |
|
|
} |
|
|
echo ">"; |
|
|
} |
|
43 |
|
|
44 |
if (! isset($sql_upit)) { $sql_upit="novi_na_vrh"; } |
if (! isset($sql_upit)) { $sql_upit="novi_na_vrh"; } |
45 |
|
|
56 |
option("novi_na_vrh","noviji na početak popisa",$sql_upit); |
option("novi_na_vrh","noviji na početak popisa",$sql_upit); |
57 |
option("order_ime","sortirano po imenu",$sql_upit); |
option("order_ime","sortirano po imenu",$sql_upit); |
58 |
option("order_prezime","sortirano po prezimenu",$sql_upit); |
option("order_prezime","sortirano po prezimenu",$sql_upit); |
59 |
|
option("umrezavanje","potrebno umrežavanje",$sql_upit); |
60 |
|
|
61 |
echo ' </select> |
echo ' </select> |
62 |
<small><i>za opcije označenje zvjezdicom (*) prvo morate |
<small><i>za opcije označenje zvjezdicom (*) prvo morate |
76 |
|
|
77 |
$on_page=50; |
$on_page=50; |
78 |
|
|
|
$conn = pg_connect("dbname=informatika user=dpavlin"); |
|
|
|
|
79 |
$sql_polja="osobe.id as id,osobe.ime as ime, |
$sql_polja="osobe.id as id,osobe.ime as ime, |
80 |
osobe.prezime as prezime, |
osobe.prezime as prezime, |
81 |
org_jed.naziv||'<br><small>'||org_pod_jed.pod_naziv||'<small>' as orgjed, |
org_jed.naziv||'<br><small>'||org_pod_jed.pod_naziv||'<small>' as orgjed, |
83 |
e_mail,kontakt_osoba_id |
e_mail,kontakt_osoba_id |
84 |
"; |
"; |
85 |
$sql_tablice="osobe,org_jed,kontakt_osobe"; |
$sql_tablice="osobe,org_jed,kontakt_osobe"; |
86 |
$sql_where="org_jed.id=org_jed_id |
$sql_where="org_jed.id=osobe.org_jed_id |
87 |
and org_pod_jed.pod_id=org_pod_jed_id |
and org_pod_jed.pod_id=osobe.org_pod_jed_id |
88 |
and kontakt_osoba_id=kontakt_osobe.id |
and kontakt_osoba_id=kontakt_osobe.id |
89 |
"; |
"; |
90 |
$sql_order="order by id"; |
$sql_order="order by id"; |
105 |
case "novi_na_vrh": |
case "novi_na_vrh": |
106 |
$sql_order="order by id desc"; |
$sql_order="order by id desc"; |
107 |
break; |
break; |
108 |
|
case "umrezavanje": |
109 |
|
$sql_where.=" and umrezavanje is true"; |
110 |
|
break; |
111 |
} |
} |
112 |
} |
} |
113 |
|
|
138 |
<th>organizacijska jedinica</th> |
<th>organizacijska jedinica</th> |
139 |
<th>status zahtjeva</th> |
<th>status zahtjeva</th> |
140 |
<th>kontakt osoba</th> |
<th>kontakt osoba</th> |
141 |
|
<td><small>",pg_numrows($result),"</small></td> |
142 |
</tr> |
</tr> |
143 |
"; |
"; |
144 |
|
|
145 |
include("inc/print_bool.inc"); |
include("inc/print_bool2.inc"); |
146 |
|
|
147 |
|
|
148 |
for ($k = 0; $k < pg_numrows($result); $k++) { |
for ($k = 0; $k < pg_numrows($result); $k++) { |
149 |
$row=pg_fetch_array($result,$k); |
$row=pg_fetch_array($result,$k); |
161 |
print "</td><td>$row[ime] $row[prezime]</td> |
print "</td><td>$row[ime] $row[prezime]</td> |
162 |
<td>$row[orgjed]</td><td>"; |
<td>$row[orgjed]</td><td>"; |
163 |
|
|
164 |
$result1 = pg_Exec ($conn, "select datum,opis from status,status_tip where status.status_tip_id=status_tip.id and osoba_id=$row[id]"); |
$result1 = pg_Exec ($conn, "select datum,opis from status,status_tip where status.status_tip_id=status_tip.id and osoba_id=$row[id] order by datum"); |
165 |
for ($l = 0; $l < pg_numrows($result1); $l++) { |
for ($l = 0; $l < pg_numrows($result1); $l++) { |
166 |
$row1=pg_fetch_array($result1,$l); |
$row1=pg_fetch_array($result1,$l); |
167 |
print "<small>$row1[datum]</small> $row1[opis]<br>"; |
print "<small>$row1[datum]</small> $row1[opis]<br>"; |