2 include_once('security.php');
3 include_once('/var/www/secure.php'); //outside webserver
4 if (isset($_GET['override'])){
5 $id = $_GET['override'];
6 $petition->query("update signatures set signature_status = 'verified' where id = '$id' ");
7 header('Location: report.php');
9 if (isset($_GET['delete'])){
10 $id = $_GET['delete'];
11 $petition->query("update signatures set signature_status = 'deleted' where id = '$id' ");
12 header('Location: report.php');
14 if (isset($_GET['review'])){
15 $id = $_GET['review'];
16 $petition->query("update signatures set signature_status = 'review_requested' where id = '$id' ");
17 header('Location: report.php');
19 include_once('header.php');
20 slack_general('ADMIN: Reports Loaded ('.$_COOKIE['name'].') ('.$_COOKIE['level'].')','md-petition');
21 $group_id = $_COOKIE['group_id'];
25 function checkAll(formname
, checktoggle
)
27 var checkboxes
= new Array();
28 checkboxes
= document
[formname
].getElementsByTagName('input');
30 for (var i
=0; i
<checkboxes
.length
; i++
) {
31 if (checkboxes
[i
].type
== 'checkbox') {
32 checkboxes
[i
].checked
= checktoggle
;
38 body
{ background
-color
:lightgrey
; }
39 fieldset
{ border
: solid
1px lightblue
; background
-color
:white
; margin
:10px
; padding
:10px
; }
40 legend
{ border
: solid
1px blue
; background
-color
:white
; margin
:10px
; padding
:10px
; }
41 td
{ white
-space
: pre
; }
44 if($_COOKIE['level'] == 'admin'){
45 $q="SELECT * FROM petitions where admin_status = 'approved' order by admin_sort DESC ";
47 $q="SELECT * FROM petitions where group_id = '$group_id' and admin_status = 'approved'";
50 $r = $petition->query($q);
51 while($d = mysqli_fetch_array($r)){
52 $pID = $d['petition_id'];
53 echo "<div id=\"chartContainer$pID\" style=\"height: 400px; width: 100%; margin: 0px auto;\"></div>";
57 $q3 = "SELECT just_date FROM signatures where petition_id = '$pID' and just_date <> '0000-00-00' group by just_date";
58 //echo "<li>$q3</li>";
59 $r3 = $petition->query($q3);
61 $goal = $d['signature_goal'];
65 while ($d3 = mysqli_fetch_array($r3)){
66 $just_date = $d3['just_date'];
67 $q2 = "SELECT * FROM signatures where petition_id = '$pID' and just_date = '$just_date' and signature_status = 'verified' ";
68 //echo "<li>$q2</li>";
69 $r2 = $petition->query($q2);
70 $count = mysqli_num_rows($r2);
71 $chart .= '{ label: "'.$just_date.'", y: '.intval($count).' }, ';
72 $total = $total +
intval($count);
73 $chart2 .= '{ label: "'.$just_date.'", y: '.intval($total).' }, ';
74 $goal = $goal - intval($count);
75 $chart3 .= '{ label: "'.$just_date.'", y: '.intval($goal).' }, ';
77 $chart = rtrim(trim($chart), ",");
78 $chart2 = rtrim(trim($chart2), ",");
79 $chart3 = rtrim(trim($chart3), ",");
83 var chart
<?PHP
echo $pID;?
> = new CanvasJS
.Chart("chartContainer<?PHP echo $pID;?>", {
85 animationEnabled
: true,
88 text
: "<?PHP echo $d['petition_name'];?> MD-Petition.com Signature Tracker"
92 title
: "Number of Signatures",
103 itemclick
: toggleDataSeries
109 yValueFormatString
: "#####",
110 name
: "Total Signatures Count",
112 <?PHP
echo $chart2; ?
>
114 },<?PHP
if(1 == 2){ ?
>{
118 yValueFormatString
: "#####",
119 name
: "Signatures Remaining to Goal",
121 <?PHP
echo $chart3; ?
>
127 yValueFormatString
: "#####",
128 name
: "New Daily Signatures",
130 <?PHP
echo $chart; ?
>
137 chart
<?PHP
echo $pID;?
>.render();
139 <?PHP
$javascript .= ob_get_clean();
157 <form id
='form3' name
='form3' method
='POST' action
='printer.php'>
159 if($_COOKIE['level'] == 'admin'){
160 $q="SELECT * FROM petitions where admin_status = 'approved' ";
162 $q="SELECT * FROM petitions where group_id = '$group_id' and admin_status = 'approved'";
164 $r = $petition->query($q);
165 while($d = mysqli_fetch_array($r)){
166 echo "<fieldset style='border: solid 1px $d[web_color];'><legend style='background-color:white;'>$d[petition_name] - Unprinted</legend>
167 <a onclick=\"javascript:checkAll('form3', true);\" href=\"javascript:void();\">Check All</a>
168 <a onclick=\"javascript:checkAll('form3', false);\" href=\"javascript:void();\">Uncheck All</a>
169 <input type='submit' value='PRINT'>";
170 echo "<table border='1' cellpadding='0' cellspacing='5'>";
173 $pID = $d['petition_id'];
174 $q2="SELECT * FROM signatures where petition_id = '$pID' and printed_status = '' and signature_status = 'verified' order by signature_status, id desc";
175 $r2 = $petition->query($q2);
176 while($d2 = mysqli_fetch_array($r2)){
177 if ($d2['signature_status'] == 'verified'){
180 <td><input type='checkbox' name='print[".$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]-<a href='?review=$d2[id]'>Flag for Review</a></td><td>$d2[printed_status]</td></tr>";
183 <td><a href='?override=$d2[id]'>Override</a> or <a href='?delete=$d2[id]'>Delete</a></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>";
186 echo '</table></fieldset>';
195 <?PHP
if($_COOKIE['level'] == 'admin'){ ?
>
197 <form id
='form5' name
='form5' method
='POST' action
='printer.php'>
199 if($_COOKIE['level'] == 'admin'){
200 $q="SELECT * FROM petitions where admin_status = 'approved' ";
202 $q="SELECT * FROM petitions where group_id = '$group_id' and admin_status = 'approved'";
204 $r = $petition->query($q);
205 while($d = mysqli_fetch_array($r)){
206 echo "<fieldset style='border: solid 1px $d[web_color];'><legend style='background-color:white;'>$d[petition_name] - Flagged for Deletion or Override</legend>
207 <a onclick=\"javascript:checkAll('form3', true);\" href=\"javascript:void();\">Check All</a>
208 <a onclick=\"javascript:checkAll('form3', false);\" href=\"javascript:void();\">Uncheck All</a>
209 <input type='submit' value='PRINT'>";
210 echo "<table border='1' cellpadding='0' cellspacing='5'>";
213 $pID = $d['petition_id'];
214 $q2="SELECT * FROM signatures where petition_id = '$pID' and printed_status = '' and signature_status <> 'deleted' and signature_status <> 'verified' order by signature_status, id desc";
215 $r2 = $petition->query($q2);
216 while($d2 = mysqli_fetch_array($r2)){
217 if ($d2['signature_status'] == 'verified'){
219 <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]-<a href='?review=$d2[id]'>Flag for Review</a></td><td>$d2[printed_status]</td></tr>";
222 <td><a href='?override=$d2[id]'>Override</a> or <a href='?delete=$d2[id]'>Delete</a></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>";
225 echo '</table></fieldset>';
236 <form id
='form2' name
='form2' method
='POST' action
='printer.php'>
239 if($_COOKIE['level'] == 'admin'){
240 $q="SELECT * FROM petitions where admin_status = 'approved' ";
242 $q="SELECT * FROM petitions where group_id = '$group_id' and admin_status = 'approved' ";
244 $r = $petition->query($q);
245 while($d = mysqli_fetch_array($r)){
246 echo "<fieldset style='border: solid 1px $d[web_color];'><legend style='background-color:white;'>$d[petition_name] - Printed</legend>
247 <a onclick=\"javascript:checkAll('form2', true);\" href=\"javascript:void();\">Check All</a>
248 <a onclick=\"javascript:checkAll('form2', false);\" href=\"javascript:void();\">Uncheck All</a>
249 <input type='submit' value='PRINT'>";
250 echo "<table border='1' cellpadding='0' cellspacing='5'>";
253 $pID = $d['petition_id'];
254 $q2="SELECT * FROM signatures where petition_id = '$pID' and printed_status <> '' and signature_status <> 'deleted' order by signature_status, id desc";
255 $r2 = $petition->query($q2);
256 while($d2 = mysqli_fetch_array($r2)){
257 if ($d2['signature_status'] == 'verified'){
258 echo "<tr><td><input type='checkbox' name='print[".$d2[id
]."]'></td><td>$d2[ip_address]</td><td>$d2[date_time_signed]</td><td>$d2[VoterList_table]</td><td>$d2[signed_name_as]</td><td>$d2[signed_name_as_circulator]</td><td>$d2[contact_phone]</td><td>$d2[signature_status]-<a href='?review=$d2[id]'>Flag for Review</a></td><td>$d2[printed_status]</td></tr>";
260 echo "<tr><td><a href='?override=$d2[id]'>Override</a> or <a href='?delete=$d2[id]'>Delete</a></td><td>$d2[ip_address]</td><td>$d2[date_time_signed]</td><td>$d2[VoterList_table]</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>";
263 echo '</table></fieldset>';
275 window
.onload
= function () {
277 <?PHP
echo $javascript;?
>
279 function toggleDataSeries(e
) {
280 if (typeof(e
.dataSeries
.visible
) === "undefined" || e
.dataSeries
.visible
){
281 e
.dataSeries
.visible
= false;
283 e
.dataSeries
.visible
= true;
293 <script src
="../files/canvasjs.min.js"></script
>
295 include_once('footer.php');