--- html/ic.php 2000/07/11 13:49:15 1.3
+++ html/ic.php 2000/07/13 08:01:28 1.4
@@ -10,7 +10,7 @@
$result = pg_Exec ($conn, "
select datum,count(*) as nr from izvjestaji group by datum
- order by datum
+ order by datum desc
");
print '
@@ -54,12 +54,13 @@
rbr | id | ime i prezime | tel | lokacija | org.jed |
- | | lokacija računala, mreža | ž | objekat / kat / soba |
+podešeno | lokacija računala, mreža | ž | objekat / kat / soba |
';
$lokacija="";
$mreza="";
$rbr=1;
+$podeseno=" ";
for ($k=0; $k < pg_numrows($result); $k++) {
$arr=pg_fetch_row($result,$k);
@@ -68,21 +69,37 @@
$lokacija=$arr[4];
print "$lokacija |
";
}
+
print "$rbr | $arr[0] | $arr[1] $arr[2] | tel: $arr[3] | $arr[4] | $arr[5] $arr[6] |
\n";
- if ($arr[12] == 0) {
+
+
+ if ($arr[12] == "f") {
$mreza='umreženo';
} else {
$result2 = pg_Exec ($conn, "
select count(status_tip_id) as nr_of_status8 from status
where osoba_id = $arr[0] and status_tip_id=8");
- $row2=pg_fetch_row($result2,0);
+ $row2=pg_fetch_array($result2,0);
if ($row2["nr_of_status8"] > 0) {
$mreza='umrežavanje obavljeno';
} else {
$mreza='potrebno umrežavanje';
}
}
- print " | $arr[7] $mreza | ž-$arr[11] | $arr[8] / $arr[9] / $arr[10] |
\n";
+
+ $result3 = pg_Exec ($conn, "
+ select count(status_tip_id) as nr_of_status6 from status
+ where osoba_id = $arr[0] and status_tip_id=6");
+ $row3=pg_fetch_array($result3,0);
+ if ($row3["nr_of_status6"] > 0) {
+ $podeseno=show_bool("t");
+ } else {
+ $podeseno="".show_bool("f")."";
+ }
+
+# print "$arr[12] | ".$row2["nr_of_status8"]." | ".$row3["nr_of_status6"]." |
\n";
+
+ print "$podeseno | $arr[7] $mreza | ž-$arr[11] | $arr[8] / $arr[9] / $arr[10] |
\n";
$rbr++;
}
@@ -91,7 +108,11 @@
} // isset(datum)
-print "Povratak na početnu stranicu.";
+print "
Povratak na ";
+if (isset($HTTP_REFERER)) {
+ print "stranicu sa koje ste došli ili ";
+}
+print "početnu stranicu.";
include("inc/footer.inc");