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");

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