/[informatika.old]/html/lista.php
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Contents of /html/lista.php

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.12 - (show annotations)
Tue Jul 4 08:45:32 2000 UTC (23 years, 8 months ago) by dpavlin
Branch: MAIN
Branch point for: dbi
Changes since 1.11: +1 -0 lines
Na zahtjev Sanje iz IC-a, status umre¾avanja i pode¹avanje se prikazuje
po default-u

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

  ViewVC Help
Powered by ViewVC 1.1.26