informatika.old/html/ic.php

<?

include("inc/head.inc");
include("inc/prava.inc");
include("inc/show_bool.inc");
include("inc/bgcolor.inc");
include("inc/radio.inc");
include("inc/sap_org_jed.inc");

if (!isset($datum) and !isset($lokacija)) {

$result = pg_Exec ($conn, "
        select datum,count(*) as nr from izvjestaji group by datum
        order by datum desc
        ");

print '
<h1>Izvje¹taji o otvaranju raèuna</h1>
<table border=1>
<tr bgcolor="#e0e0f0"><th>datum izvje¹taja</th><th>broj otvorenih raèuna</th></tr>
';

for ($k=0; $k < pg_numrows($result); $k++) {
        $arr=pg_fetch_row($result,$k);
        print "<tr".bgcolor()."><td><a href=\"$PHP_SELF?datum=".rawurlencode($arr[0])."\">$arr[0]</a></td>
                <td align=center>$arr[1]</td></tr>\n";
}

print '</table>';

print "
<form action=$PHP_SELF>
<table border=0>
<tr><td>
Zahtjevi koji
</td><td>
<input type=radio name=preskoci_podesene value=1 checked>èekaju pode¹avanje<br>
<input type=radio name=preskoci_podesene value=0>pripadaju
</td><td>
lokacija
<select name=lokacija>
";

$result = pg_Exec ($conn, "select id,naziv from lokacije where aktivna is true order by naziv");
for ($k=0; $k < pg_numrows($result); $k++) {
        $arr=pg_fetch_row($result,$k);
        print "<option value=$arr[0]>$arr[1]</option>\n";
}
print "</select>
<input type=submit value=Prikazi>
</td></tr>
</table>
</form>
";

} else {        // isset(datum)
        print "<h1>Izvje¹taj o otvaranju raèuna</h1>";

        if (isset($datum)) {
                $result = pg_Exec ($conn, "
                        select osobe.id,ime,prezime,tel,lokacije.naziv,
                                sifra,'',
                                lok_racunala,objekt,kat,soba,z_rac,umrezavanje,
                                kontakt_osobe.e_mail,podesavanje
                        from osobe
                        where osobe.id in ( select osoba_id from izvjestaji where datum='$datum' )
                                and lokacija_id=lokacije.id
                                and podesavanje=true
                                and kontakt_osobe.id=kontakt_osoba_id
                        order by lokacije.naziv,osobe.id
                        ");
                print "<p>Izvje¹taj za: $datum<p>";
        } else {
                $sql="select osobe.id,ime,prezime,tel,lokacije.naziv,
                                sifra,'',
                                lok_racunala,objekt,kat,soba,z_rac,umrezavanje,
                                kontakt_osobe.e_mail,podesavanje
                        from osobe
                        where lokacija_id = $lokacija
                                and lokacija_id=lokacije.id
                                and podesavanje=true
                                and kontakt_osobe.id=kontakt_osoba_id
                        order by lokacije.naziv,osobe.id
                        ";
#               print "<pre>$sql</pre>";
                $result = pg_Exec ($conn, "$sql");
        }


print '
<table border=1>
<tr bgcolor="#e0e0f0"><th>rbr</th><th>id</th><th>ime i prezime</th><th>tel</th><th>lokacija</th><th>org.jed</th></tr>
<tr bgcolor="#e0e0f0"><th colspan=2>pode¹eno</th><th>lokacija raèunala, mre¾a</th><th>¾</th><th colspan=2>objekat / kat / soba</th></tr>
';

$lokacija="";
$mreza="";
$rbr=1;
$podeseno="&nbsp;";

for ($k=0; $k < pg_numrows($result); $k++) {
        $arr=pg_fetch_row($result,$k);

        if ($lokacija != $arr[4]) {
                $lokacija=$arr[4];
                print "<tr bgcolor=#000000><td colspan=6><font size=+1 color=#ffffff>$lokacija</font></td></tr>";
        }

        $out="<tr".bgcolor()."><td>$rbr</td><td><a href=\"http://support.pliva.hr/obavijest.php?id=$arr[0]\">$arr[0]</a></td><td>$arr[1] $arr[2]</td><td>tel: $arr[3]</td><td><small>$arr[4]</small></td><td>".sap_org_jed($arr[5])."</td></tr>\n";


        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_array($result2,0);
                if ($row2["nr_of_status8"] > 0) {
                        $mreza='<i>umre¾avanje obavljeno</i>';
                } else {
                        $mreza='<b>potrebno umre¾avanje</b>';
                }
        }

        $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_html=show_bool("t");
                $podeseno=1;
        } else {
                $podeseno_html="<a href=\"http://support.pliva.hr/obavijest.php?id=$arr[0]\">".show_bool("f")."</a>";
                $podeseno=0;
        }

#       print "<tr><td colspan=6>$arr[12] | ".$row2["nr_of_status8"]." | ".$row3["nr_of_status6"]."</td></tr>\n";

        $out.="<tr".bgcolor()."><td colspan=2>$podeseno_html</td><td><small>$arr[7] $mreza</small></a><td><small>¾-$arr[11]</small></td><td colspan=2><small>$arr[8] / $arr[9] / $arr[10]</small></td></tr>\n";

        if ($preskoci_podesene & ! $podeseno || ! $preskoci_podesene) {
                print "$out";
        }
        $rbr++;

}
print "</table>";

}               // isset(datum)


print "<p>Povratak na ";
if (isset($HTTP_REFERER)) {
        print "<a href=\"$HTTP_REFERER\">stranicu sa koje ste do¹li</a> ili ";
}
print "<a href=\"/\">poèetnu stranicu</a>.";

include("inc/footer.inc");

?>

1	dpavlin	1.1	<?
2
3			include("inc/head.inc");
4			include("inc/prava.inc");
5			include("inc/show_bool.inc");
6			include("inc/bgcolor.inc");
7			include("inc/radio.inc");
8	dpavlin	1.7	include("inc/sap_org_jed.inc");
9	dpavlin	1.1
10	dpavlin	1.5	if (!isset($datum) and !isset($lokacija)) {
11	dpavlin	1.3
12	dpavlin	1.1	$result = pg_Exec ($conn, "
13	dpavlin	1.3	select datum,count(*) as nr from izvjestaji group by datum
14	dpavlin	1.4	order by datum desc
15	dpavlin	1.1	");
16
17	dpavlin	1.3	print '
18			<h1>Izvje¹taji o otvaranju raèuna</h1>
19			<table border=1>
20			<tr bgcolor="#e0e0f0"><th>datum izvje¹taja</th><th>broj otvorenih raèuna</th></tr>
21			';
22	dpavlin	1.1
23			for ($k=0; $k < pg_numrows($result); $k++) {
24	dpavlin	1.3	$arr=pg_fetch_row($result,$k);
25			print "<tr".bgcolor()."><td><a href=\"$PHP_SELF?datum=".rawurlencode($arr[0])."\">$arr[0]</a></td>
26			<td align=center>$arr[1]</td></tr>\n";
27			}
28
29			print '</table>';
30
31	dpavlin	1.6	print "
32			<form action=$PHP_SELF>
33			<table border=0>
34			<tr><td>
35			Zahtjevi koji
36			</td><td>
37			<input type=radio name=preskoci_podesene value=1 checked>èekaju pode¹avanje<br>
38			<input type=radio name=preskoci_podesene value=0>pripadaju
39			</td><td>
40			lokacija
41			<select name=lokacija>
42			";
43	dpavlin	1.5
44			$result = pg_Exec ($conn, "select id,naziv from lokacije where aktivna is true order by naziv");
45			for ($k=0; $k < pg_numrows($result); $k++) {
46			$arr=pg_fetch_row($result,$k);
47			print "<option value=$arr[0]>$arr[1]</option>\n";
48			}
49	dpavlin	1.6	print "</select>
50			<input type=submit value=Prikazi>
51			</td></tr>
52			</table>
53			</form>
54			";
55	dpavlin	1.3
56			} else { // isset(datum)
57	dpavlin	1.5	print "<h1>Izvje¹taj o otvaranju raèuna</h1>";
58	dpavlin	1.3
59	dpavlin	1.5	if (isset($datum)) {
60			$result = pg_Exec ($conn, "
61			select osobe.id,ime,prezime,tel,lokacije.naziv,
62	dpavlin	1.7	sifra,'',
63	dpavlin	1.5	lok_racunala,objekt,kat,soba,z_rac,umrezavanje,
64			kontakt_osobe.e_mail,podesavanje
65			from osobe
66			where osobe.id in ( select osoba_id from izvjestaji where datum='$datum' )
67			and lokacija_id=lokacije.id
68			and podesavanje=true
69			and kontakt_osobe.id=kontakt_osoba_id
70	dpavlin	1.7	order by lokacije.naziv,osobe.id
71	dpavlin	1.5	");
72			print "<p>Izvje¹taj za: $datum<p>";
73			} else {
74			$sql="select osobe.id,ime,prezime,tel,lokacije.naziv,
75	dpavlin	1.7	sifra,'',
76	dpavlin	1.5	lok_racunala,objekt,kat,soba,z_rac,umrezavanje,
77			kontakt_osobe.e_mail,podesavanje
78			from osobe
79			where lokacija_id = $lokacija
80			and lokacija_id=lokacije.id
81			and podesavanje=true
82			and kontakt_osobe.id=kontakt_osoba_id
83	dpavlin	1.7	order by lokacije.naziv,osobe.id
84	dpavlin	1.5	";
85			# print "<pre>$sql</pre>";
86			$result = pg_Exec ($conn, "$sql");
87			}
88	dpavlin	1.3
89
90			print '
91			<table border=1>
92			<tr bgcolor="#e0e0f0"><th>rbr</th><th>id</th><th>ime i prezime</th><th>tel</th><th>lokacija</th><th>org.jed</th></tr>
93	dpavlin	1.4	<tr bgcolor="#e0e0f0"><th colspan=2>pode¹eno</th><th>lokacija raèunala, mre¾a</th><th>¾</th><th colspan=2>objekat / kat / soba</th></tr>
94	dpavlin	1.3	';
95
96			$lokacija="";
97			$mreza="";
98			$rbr=1;
99	dpavlin	1.4	$podeseno=" ";
100	dpavlin	1.3
101			for ($k=0; $k < pg_numrows($result); $k++) {
102			$arr=pg_fetch_row($result,$k);
103
104			if ($lokacija != $arr[4]) {
105			$lokacija=$arr[4];
106			print "<tr bgcolor=#000000><td colspan=6><font size=+1 color=#ffffff>$lokacija</font></td></tr>";
107			}
108	dpavlin	1.4
109	dpavlin	1.7	$out="<tr".bgcolor()."><td>$rbr</td><td><a href=\"http://support.pliva.hr/obavijest.php?id=$arr[0]\">$arr[0]</a></td><td>$arr[1] $arr[2]</td><td>tel: $arr[3]</td><td><small>$arr[4]</small></td><td>".sap_org_jed($arr[5])."</td></tr>\n";
110	dpavlin	1.4
111
112			if ($arr[12] == "f") {
113	dpavlin	1.3	$mreza='umre¾eno';
114	dpavlin	1.1	} else {
115	dpavlin	1.3	$result2 = pg_Exec ($conn, "
116			select count(status_tip_id) as nr_of_status8 from status
117			where osoba_id = $arr[0] and status_tip_id=8");
118	dpavlin	1.4	$row2=pg_fetch_array($result2,0);
119	dpavlin	1.3	if ($row2["nr_of_status8"] > 0) {
120			$mreza='<i>umre¾avanje obavljeno</i>';
121			} else {
122			$mreza='<b>potrebno umre¾avanje</b>';
123			}
124	dpavlin	1.1	}
125	dpavlin	1.4
126			$result3 = pg_Exec ($conn, "
127			select count(status_tip_id) as nr_of_status6 from status
128			where osoba_id = $arr[0] and status_tip_id=6");
129			$row3=pg_fetch_array($result3,0);
130			if ($row3["nr_of_status6"] > 0) {
131	dpavlin	1.6	$podeseno_html=show_bool("t");
132			$podeseno=1;
133	dpavlin	1.4	} else {
134	dpavlin	1.6	$podeseno_html="<a href=\"http://support.pliva.hr/obavijest.php?id=$arr[0]\">".show_bool("f")."</a>";
135			$podeseno=0;
136	dpavlin	1.4	}
137
138			# print "<tr><td colspan=6>$arr[12] \| ".$row2["nr_of_status8"]." \| ".$row3["nr_of_status6"]."</td></tr>\n";
139
140	dpavlin	1.6	$out.="<tr".bgcolor()."><td colspan=2>$podeseno_html</td><td><small>$arr[7] $mreza</small></a><td><small>¾-$arr[11]</small></td><td colspan=2><small>$arr[8] / $arr[9] / $arr[10]</small></td></tr>\n";
141
142			if ($preskoci_podesene & ! $podeseno \|\| ! $preskoci_podesene) {
143			print "$out";
144			}
145	dpavlin	1.3	$rbr++;
146
147	dpavlin	1.1	}
148	dpavlin	1.3	print "</table>";
149
150			} // isset(datum)
151
152	dpavlin	1.1
153	dpavlin	1.4	print "<p>Povratak na ";
154			if (isset($HTTP_REFERER)) {
155			print "<a href=\"$HTTP_REFERER\">stranicu sa koje ste do¹li</a> ili ";
156			}
157			print "<a href=\"/\">poèetnu stranicu</a>.";
158	dpavlin	1.1
159			include("inc/footer.inc");
160
161			?>
162