Commit | Line | Data |
---|---|---|
e3599ddc PM |
1 | <?PHP |
2 | include_once('security.php'); | |
3 | include_once('header.php'); | |
9970efb3 | 4 | slack_general('ADMIN: Reports Loaded ('.$_COOKIE['name'].') ('.$_COOKIE['level'].')','md-petition'); |
f1f9b284 | 5 | $group_id = $_COOKIE['group_id']; |
3f627365 PM |
6 | ?> |
7 | <script> | |
8 | function checkAll(formname, checktoggle) | |
9 | { | |
10 | var checkboxes = new Array(); | |
11 | checkboxes = document[formname].getElementsByTagName('input'); | |
12 | ||
13 | for (var i=0; i<checkboxes.length; i++) { | |
14 | if (checkboxes[i].type == 'checkbox') { | |
15 | checkboxes[i].checked = checktoggle; | |
16 | } | |
17 | } | |
18 | } | |
19 | </script> | |
9ff09ac4 | 20 | <form id='form3' name='form3' method='POST' action='print.php'> |
3f627365 PM |
21 | <a onclick="javascript:checkAll('form3', true);" href="javascript:void();">check all</a> |
22 | <a onclick="javascript:checkAll('form3', false);" href="javascript:void();">uncheck all</a> | |
9ff09ac4 | 23 | <input type='submit' value='PRINT'> |
3f627365 | 24 | <?PHP |
214e6829 PM |
25 | if($_COOKIE['level'] == 'admin'){ |
26 | $q="SELECT * FROM petitions where admin_status = 'approved'"; | |
27 | }else{ | |
28 | $q="SELECT * FROM petitions where group_id = '$group_id' and admin_status = 'approved'"; | |
29 | } | |
30 | $r = $petition->query($q); | |
f1f9b284 | 31 | while($d = mysqli_fetch_array($r)){ |
3f627365 | 32 | echo "<h1>$d[petition_name]</h1>"; |
b4906349 | 33 | echo "<table border='1' cellpadding='0' cellspacing='5'>"; |
d07e2f50 PM |
34 | unset($hide); |
35 | $hide = array(); | |
66c9275f | 36 | $pID = $d['petition_id']; |
d156fc32 | 37 | $q2="SELECT * FROM signatures where petition_id = '$pID' order by id desc"; |
f1f9b284 PM |
38 | $r2 = $petition->query($q2); |
39 | while($d2 = mysqli_fetch_array($r2)){ | |
d156fc32 PM |
40 | if (!in_array($d2['VTRID'], $hide)) { |
41 | $hide[] = $d2['VTRID']; | |
3f627365 | 42 | echo "<tr><td><input type='checkbox' name='print[".$d2[id]."]'></td><td>$d2[ip_address]</td><td>$d2[date_time_signed]</td><td>$d2[signed_name_as]</td><td>$d2[signed_name_as_circulator]</td><td>$d2[contact_phone]</td><td>$d2[signature_status]</td><td>$d2[printed_status]</td></tr>"; |
d156fc32 | 43 | } |
f1f9b284 | 44 | } |
71c08090 | 45 | echo '</table>'; |
f1f9b284 | 46 | } |
ef5d85f4 | 47 | ?> |
3f627365 PM |
48 | </form> |
49 | <?PHP | |
e3599ddc PM |
50 | include_once('footer.php'); |
51 | ?> |