misc/horsensspejder-web/personer.php

<?php
if (isset($_GET["print"]) && $_GET["print"] == "1") {
        $print = 1;
} else {
        $print = 0;
}

if ($print == 0) {
        include "header.php";
} else {
        $tablestyle = " border='1' width='100%' cellpadding='15' cellspacing='0' ";
}

include "inc/mysql.php";
?>

<script>
$(document).ready( function() {
        $('#persontable').dataTable( {
        "bPaginate": false,
        "bLengthChange": false,
        "bFilter": true,
        "bSort": true,
        "bInfo": false,
        "bAutoWidth": false
    }
        );      
});
</script>


<?php
if ( isset($_GET["enhed"]) ) {
        $enhed = $_GET["enhed"];
        $filter = "WHERE r.enhed = '$enhed'";

        echo "<H2>$enhed</H2>";
        if ($print == 0) {
                echo "<a target='_blank' href='personer.php?enhed={$enhed}&print=1'>[Udskriv]</a><br>";
        }
} else {
        $filter = "";
        echo "<H2>Medlemmer</H2>";
}


$sql = "select fornavn, efternavn, mobil, email, group_concat(enhed) as enhed,group_concat( rolle) as rolle from 
                stamdata s left join roller r on (s.id = r.medlemsid) 
                $filter
                group by s.id order by fornavn,efternavn";
$rows = query($sql);


echo "<table {$tablestyle} id='persontable'>";
echo "<thead>\n";
echo "<tr><th width='100'>Fornavn</th><th>Efternavn</th><th>Mobil</th><th>Email</th>";
if (isset($enhed)) {
        echo "<th>Rolle</th>";
} else {
        echo "<th>Enheder</td>";
}
echo "</tr>\n";
echo "</thead>\n";
echo "<tbody>\n";

$i = 0;

foreach($rows as $row) {
        echo "<tr><td>{$row->fornavn}</td><td>{$row->efternavn}</td><td>{$row->mobil}</td><td>{$row->email}</td>";
        if (isset($enhed)) {
                echo "<td>{$row->rolle}</td>";
        } else {
                echo "<td>{$row->enhed}</td>";
        }
        echo "</tr>\n";

        $i = ($i+1)%2;
}
echo "</tbody>\n";
echo "</table>";
echo "<font size='-1'>Antal: " . sizeof($rows) . "</font>";

if ($print == 0) {
        require("footer.php");
}
?>
1	torben	2125	<?php
2			if (isset($_GET["print"]) && $_GET["print"] == "1") {
3			$print = 1;
4			} else {
5			$print = 0;
6			}
7
8			if ($print == 0) {
9			include "header.php";
10			} else {
11			$tablestyle = " border='1' width='100%' cellpadding='15' cellspacing='0' ";
12			}
13
14			include "inc/mysql.php";
15			?>
16
17			<script>
18			$(document).ready( function() {
19			$('#persontable').dataTable( {
20			"bPaginate": false,
21			"bLengthChange": false,
22			"bFilter": true,
23			"bSort": true,
24			"bInfo": false,
25			"bAutoWidth": false
26			}
27			);
28			});
29			</script>
30
31
32			<?php
33			if ( isset($_GET["enhed"]) ) {
34			$enhed = $_GET["enhed"];
35			$filter = "WHERE r.enhed = '$enhed'";
36
37			echo "<H2>$enhed</H2>";
38			if ($print == 0) {
39			echo "<a target='_blank' href='personer.php?enhed={$enhed}&print=1'>[Udskriv]</a><br>";
40			}
41			} else {
42			$filter = "";
43			echo "<H2>Medlemmer</H2>";
44			}
45
46
47
48			$sql = "select fornavn, efternavn, mobil, email, group_concat(enhed) as enhed,group_concat( rolle) as rolle from
49			stamdata s left join roller r on (s.id = r.medlemsid)
50			$filter
51			group by s.id order by fornavn,efternavn";
52			$rows = query($sql);
53
54
55			echo "<table {$tablestyle} id='persontable'>";
56			echo "<thead>\n";
57			echo "<tr><th width='100'>Fornavn</th><th>Efternavn</th><th>Mobil</th><th>Email</th>";
58			if (isset($enhed)) {
59			echo "<th>Rolle</th>";
60			} else {
61			echo "<th>Enheder</td>";
62			}
63			echo "</tr>\n";
64			echo "</thead>\n";
65			echo "<tbody>\n";
66
67			$i = 0;
68
69			foreach($rows as $row) {
70			echo "<tr><td>{$row->fornavn}</td><td>{$row->efternavn}</td><td>{$row->mobil}</td><td>{$row->email}</td>";
71			if (isset($enhed)) {
72			echo "<td>{$row->rolle}</td>";
73			} else {
74			echo "<td>{$row->enhed}</td>";
75			}
76			echo "</tr>\n";
77
78			$i = ($i+1)%2;
79			}
80			echo "</tbody>\n";
81			echo "</table>";
82			echo "<font size='-1'>Antal: " . sizeof($rows) . "</font>";
83
84			if ($print == 0) {
85			require("footer.php");
86			}
87			?>