1 |
dpavlin |
1.1 |
<? |
2 |
|
|
|
3 |
|
|
include("inc/head.inc"); |
4 |
dpavlin |
1.7 |
include("inc/prava.inc"); |
5 |
dpavlin |
1.1 |
|
6 |
|
|
if (! isset($from)) { |
7 |
|
|
$from=0; |
8 |
|
|
} |
9 |
|
|
|
10 |
dpavlin |
1.4 |
if (! isset($kontakt_osoba_id) || ! intval($kontakt_osoba_id)!=0) { |
11 |
dpavlin |
1.1 |
echo '<form method="post" action="'.$PHP_SELF.'?'.$QUERY_STRING.'" name="forma"> |
12 |
|
|
Odaberite Va¹e ime i prezime: |
13 |
|
|
<select name="kontakt_osoba_id">'; |
14 |
|
|
|
15 |
|
|
$result = pg_Exec ($conn, "select id,ime,prezime from kontakt_osobe |
16 |
|
|
where aktivna=true order by ime"); |
17 |
|
|
for ($k = 0; $k < pg_numrows($result); $k++) { |
18 |
|
|
$row=pg_fetch_array($result,$k); |
19 |
|
|
echo "<option value=\"$row[id]\""; |
20 |
|
|
if ($row[id]==$kontakt_osoba_id) { echo " selected"; } |
21 |
|
|
echo ">$row[ime] $row[prezime]</option>\n"; |
22 |
|
|
} |
23 |
|
|
echo '</select> |
24 |
|
|
<input type=submit value="Posebno oznaèi moje zahtjeve"> |
25 |
|
|
</form>'; |
26 |
|
|
} else { |
27 |
dpavlin |
1.7 |
$result = pg_Exec ($conn, "select ime,prezime,passwd,prava from kontakt_osobe where aktivna=true and id=$kontakt_osoba_id"); |
28 |
dpavlin |
1.1 |
$row=pg_fetch_array($result,0); |
29 |
|
|
print "<small>Trenutno ste prijavljeni kao $row[ime] $row[prezime], ako je to krivo odaberite <a href=\"$PHP_SELF?what=relogin\">ovaj link</a>.</small>"; |
30 |
dpavlin |
1.7 |
$prava=$row[prava]; |
31 |
dpavlin |
1.1 |
} |
32 |
|
|
|
33 |
|
|
function option($value,$text,$current) { |
34 |
|
|
echo "<option value=\"$value\""; |
35 |
|
|
if (isset($current) && $current==$value || !isset($current) & $default) { |
36 |
|
|
echo " selected"; |
37 |
|
|
} |
38 |
|
|
echo ">$text</option>"; |
39 |
|
|
} |
40 |
|
|
|
41 |
|
|
function checkbox($name,$current) { |
42 |
|
|
echo "<input type=\"checkbox\" name=\"$name\""; |
43 |
|
|
if (isset($current)) { |
44 |
|
|
echo " checked"; |
45 |
|
|
} |
46 |
|
|
echo ">"; |
47 |
|
|
} |
48 |
|
|
|
49 |
|
|
if (! isset($sql_upit)) { $sql_upit="novi_na_vrh"; } |
50 |
|
|
|
51 |
|
|
echo ' <form method="post" action="'.$PHP_SELF.'?'.$QUERY_STRING.'" name="forma2"> |
52 |
dpavlin |
1.5 |
Upi¹ite ime ili prezime po kojem ¾elite pretra¾ivati: |
53 |
|
|
<input type=text name=imepr size=40 value="'.$imepr.'"> |
54 |
|
|
<br><input type=submit value="Prika¾i"> |
55 |
dpavlin |
1.1 |
slogove |
56 |
|
|
<select name="sql_upit"> |
57 |
|
|
'; |
58 |
|
|
|
59 |
|
|
option("","bez specijalnog odabira",$sql_upit); |
60 |
|
|
option("samo_moji","samo za moje upite *",$sql_upit); |
61 |
|
|
option("novi_na_vrh","noviji na poèetak popisa",$sql_upit); |
62 |
|
|
option("order_ime","sortirano po imenu",$sql_upit); |
63 |
|
|
option("order_prezime","sortirano po prezimenu",$sql_upit); |
64 |
dpavlin |
1.8 |
option("umrezavanje","potrebno umre¾avanje",$sql_upit); |
65 |
dpavlin |
1.1 |
|
66 |
|
|
echo ' </select> |
67 |
|
|
<small><i>za opcije oznaèenje zvjezdicom (*) prvo morate |
68 |
|
|
odabrati Va¹e ime i prezime!</i></small> |
69 |
dpavlin |
1.2 |
<input type=hidden name=from value=0>'; |
70 |
|
|
|
71 |
|
|
if (isset($kontakt_osoba_id)) { |
72 |
|
|
echo '<input type=hidden name=kontakt_osoba_id value='.$kontakt_osoba_id.'>'; |
73 |
|
|
} |
74 |
|
|
echo '<br><small>Prika¾i status zahtjeva za: |
75 |
dpavlin |
1.1 |
',checkbox("shell",$shell),' shell |
76 |
|
|
',checkbox("podesavanje",$podesavanje),' pode¹avanje |
77 |
|
|
',checkbox("umrezavanje",$umrezavanje),' umre¾avanje |
78 |
|
|
</small> |
79 |
|
|
</form> |
80 |
|
|
'; |
81 |
|
|
|
82 |
|
|
$on_page=50; |
83 |
|
|
|
84 |
|
|
$conn = pg_connect("dbname=informatika user=dpavlin"); |
85 |
|
|
|
86 |
|
|
$sql_polja="osobe.id as id,osobe.ime as ime, |
87 |
|
|
osobe.prezime as prezime, |
88 |
|
|
org_jed.naziv||'<br><small>'||org_pod_jed.pod_naziv||'<small>' as orgjed, |
89 |
|
|
kontakt_osobe.ime||' '||kontakt_osobe.prezime as kontakt_osoba, |
90 |
|
|
e_mail,kontakt_osoba_id |
91 |
|
|
"; |
92 |
|
|
$sql_tablice="osobe,org_jed,kontakt_osobe"; |
93 |
|
|
$sql_where="org_jed.id=org_jed_id |
94 |
|
|
and org_pod_jed.pod_id=org_pod_jed_id |
95 |
|
|
and kontakt_osoba_id=kontakt_osobe.id |
96 |
|
|
"; |
97 |
|
|
$sql_order="order by id"; |
98 |
|
|
|
99 |
|
|
if (isset($sql_upit)) { |
100 |
|
|
switch($sql_upit) { |
101 |
|
|
case "samo_moji": |
102 |
|
|
if (isset($kontakt_osoba_id)) { |
103 |
|
|
$sql_where.=" and kontakt_osobe.id=$kontakt_osoba_id"; |
104 |
|
|
} |
105 |
|
|
break; |
106 |
|
|
case "order_ime": |
107 |
|
|
$sql_order="order by ime"; |
108 |
|
|
break; |
109 |
|
|
case "order_prezime": |
110 |
|
|
$sql_order="order by prezime"; |
111 |
|
|
break; |
112 |
|
|
case "novi_na_vrh": |
113 |
|
|
$sql_order="order by id desc"; |
114 |
dpavlin |
1.8 |
break; |
115 |
|
|
case "umrezavanje": |
116 |
|
|
$sql_where.=" and umrezavanje is true"; |
117 |
dpavlin |
1.1 |
break; |
118 |
|
|
} |
119 |
|
|
} |
120 |
|
|
|
121 |
|
|
if (isset($shell)) { |
122 |
|
|
$sql_polja.=",shell"; |
123 |
|
|
} |
124 |
|
|
if (isset($podesavanje)) { |
125 |
|
|
$sql_polja.=",podesavanje"; |
126 |
|
|
} |
127 |
|
|
if (isset($umrezavanje)) { |
128 |
|
|
$sql_polja.=",umrezavanje"; |
129 |
|
|
} |
130 |
|
|
|
131 |
dpavlin |
1.5 |
if (isset($imepr) && $imepr != "") { |
132 |
|
|
$sql_where.=" and ( upper(toczs(osobe.ime)) like upper(toczs('$imepr')) or upper(toczs(osobe.prezime)) like upper(toczs('$imepr')) )"; |
133 |
|
|
} |
134 |
|
|
|
135 |
dpavlin |
1.1 |
$sql="select $sql_polja from $sql_tablice where $sql_where $sql_order limit $on_page,$from"; |
136 |
|
|
|
137 |
|
|
# echo "<pre>$sql</pre>"; |
138 |
dpavlin |
1.5 |
# echo "<pre>$sql_where</pre>"; |
139 |
dpavlin |
1.1 |
$result = pg_Exec ($conn, "$sql"); |
140 |
|
|
|
141 |
|
|
echo "<table border=1> |
142 |
|
|
<tr> |
143 |
|
|
<th>br</th> |
144 |
|
|
<th>ime i prezime</th> |
145 |
|
|
<th>organizacijska jedinica</th> |
146 |
|
|
<th>status zahtjeva</th> |
147 |
|
|
<th>kontakt osoba</th> |
148 |
|
|
</tr> |
149 |
|
|
"; |
150 |
|
|
|
151 |
dpavlin |
1.6 |
include("inc/print_bool.inc"); |
152 |
dpavlin |
1.1 |
|
153 |
|
|
for ($k = 0; $k < pg_numrows($result); $k++) { |
154 |
|
|
$row=pg_fetch_array($result,$k); |
155 |
|
|
if ($k % 2 != 0) { |
156 |
|
|
print "<tr>"; |
157 |
|
|
} else { |
158 |
|
|
print '<tr bgcolor="#f0f0f0">'; |
159 |
|
|
} |
160 |
|
|
print "<td>"; |
161 |
dpavlin |
1.7 |
if ($row[kontakt_osoba_id]==$kontakt_osoba_id || isset($prava) && $prava==$pr_admin) { |
162 |
dpavlin |
1.1 |
print "<a href=\"osoba.php?what=select-osoba&id=$row[id]\">$row[id]</a>"; |
163 |
|
|
} else { |
164 |
|
|
print "$row[id]"; |
165 |
|
|
} |
166 |
|
|
print "</td><td>$row[ime] $row[prezime]</td> |
167 |
|
|
<td>$row[orgjed]</td><td>"; |
168 |
|
|
|
169 |
|
|
$result1 = pg_Exec ($conn, "select datum,opis from status,status_tip where status.status_tip_id=status_tip.id and osoba_id=$row[id]"); |
170 |
|
|
for ($l = 0; $l < pg_numrows($result1); $l++) { |
171 |
|
|
$row1=pg_fetch_array($result1,$l); |
172 |
|
|
print "<small>$row1[datum]</small> $row1[opis]<br>"; |
173 |
|
|
} |
174 |
|
|
print "</td><td><a href=\"mailto:$row[e_mail]\">$row[kontakt_osoba]</a><small>"; |
175 |
|
|
|
176 |
|
|
|
177 |
|
|
if (isset($shell)) { |
178 |
dpavlin |
1.6 |
print "<br>shell: ".print_bool($row[shell]); |
179 |
dpavlin |
1.1 |
} |
180 |
|
|
if (isset($podesavanje)) { |
181 |
dpavlin |
1.6 |
print "<br>pode¹avanje: ".print_bool($row[podesavanje]); |
182 |
dpavlin |
1.1 |
} |
183 |
|
|
if (isset($umrezavanje)) { |
184 |
dpavlin |
1.6 |
print "<br>umre¾avanje: ".print_bool($row[umrezavanje]); |
185 |
dpavlin |
1.1 |
} |
186 |
dpavlin |
1.6 |
print "</small>"; |
187 |
|
|
print "</td><td> |
188 |
|
|
<a href=\"obavijest.php?id=$row[id]\"> |
189 |
|
|
<img src=pix/text.gif border=0 |
190 |
|
|
alt=\"Prika¾i sve podatke o ovom zahtjevu\"></a> |
191 |
|
|
"; |
192 |
|
|
print "</td></tr>"; |
193 |
dpavlin |
1.1 |
} |
194 |
|
|
|
195 |
|
|
|
196 |
|
|
echo "</table>"; |
197 |
|
|
|
198 |
|
|
echo "<p><small>Druge stranice: <tt>"; |
199 |
|
|
|
200 |
|
|
if ($from >= $on_page) { |
201 |
|
|
echo "<a href=$PHP_SELF?from=".($from-$on_page)."&sql_upit=$sql_upit>-</a> "; |
202 |
|
|
} else { |
203 |
|
|
echo " "; |
204 |
|
|
} |
205 |
|
|
|
206 |
|
|
if (pg_numrows($result) >= $on_page) { |
207 |
|
|
echo "<a href=$PHP_SELF?from=".($from+$on_page)."&sql_upit=$sql_upit>+</a> "; |
208 |
|
|
} else { |
209 |
|
|
echo " "; |
210 |
|
|
} |
211 |
|
|
|
212 |
|
|
echo '</tt></small> |
213 |
|
|
|
214 |
|
|
<p>Povratak na <a href="index.php">poèetnu stranicu</a>... |
215 |
|
|
|
216 |
|
|
'; |
217 |
|
|
|
218 |
|
|
include("inc/footer.inc"); |
219 |
|
|
?> |