Add files via upload

[clinton/MarylandElectronicPetitionSignature.git] / admin / report.php

diff --git a/admin/report.php b/admin/report.php
index 6aad268..0518595 100644 (file)
--- a/admin/report.php
+++ b/admin/report.php
@@ -111,7 +111,7 @@ while($d = mysqli_fetch_array($r)){
                        dataPoints: [
                                <?PHP echo $chart2; ?>
                        ]
-               },{
+               },<?PHP if(1 == 2){ ?>{
                        type: "line",
                        visible: true,
                        showInLegend: true,
@@ -120,7 +120,7 @@ while($d = mysqli_fetch_array($r)){
                        dataPoints: [
                                <?PHP echo $chart3; ?>
                        ]
-               },{
+               },<?PHP } ?>{
                        type: "column",
                        visible: true,
                        showInLegend: true,
@@ -163,7 +163,7 @@ while($d = mysqli_fetch_array($r)){
   }
 $r = $petition->query($q);
 while($d = mysqli_fetch_array($r)){
-  echo "<fieldset style='background-color:$d[web_color];'><legend style='background-color:white;'>$d[petition_name] - Unprinted</legend>
+  echo "<fieldset style='border: solid 1px $d[web_color];'><legend style='background-color:white;'>$d[petition_name] - Unprinted</legend>
   <a onclick=\"javascript:checkAll('form3', true);\" href=\"javascript:void();\">Check All</a>
   <a onclick=\"javascript:checkAll('form3', false);\" href=\"javascript:void();\">Uncheck All</a>
   <input type='submit' value='PRINT'>";
@@ -171,15 +171,16 @@ while($d = mysqli_fetch_array($r)){
   unset($hide);
   $hide = array();
   $pID = $d['petition_id'];
-  $q2="SELECT * FROM signatures where petition_id = '$pID' and printed_status = '' and signature_status <> 'deleted' order by signature_status, id desc";
+  $q2="SELECT * FROM signatures where petition_id = '$pID' and printed_status = '' and signature_status = 'verified' order by signature_status, id desc";
   $r2 = $petition->query($q2);
   while($d2 = mysqli_fetch_array($r2)){
     if ($d2['signature_status'] == 'verified'){
+           $id = $d2['id'];
       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]-<a href='?review=$d2[id]'>Flag for Review</a></td><td>$d2[printed_status]</td></tr>";
+      <td><input type='checkbox' name='print[".$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>";
     }else{
       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[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>";
+      <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>";
     }
   }
   echo '</table></fieldset>';
@@ -190,6 +191,48 @@ while($d = mysqli_fetch_array($r)){
     ?>
 </form>
 
+
+<?PHP if($_COOKIE['level'] == 'admin'){ ?>
+
+<form id='form5' name='form5' method='POST' action='printer.php'>
+<?PHP
+  if($_COOKIE['level'] == 'admin'){
+    $q="SELECT * FROM petitions where admin_status = 'approved' ";
+  }else{
+    $q="SELECT * FROM petitions where group_id = '$group_id' and admin_status = 'approved'";
+  }
+$r = $petition->query($q);
+while($d = mysqli_fetch_array($r)){
+  echo "<fieldset style='border: solid 1px $d[web_color];'><legend style='background-color:white;'>$d[petition_name] - Flagged for Deletion or Override</legend>
+  <a onclick=\"javascript:checkAll('form3', true);\" href=\"javascript:void();\">Check All</a>
+  <a onclick=\"javascript:checkAll('form3', false);\" href=\"javascript:void();\">Uncheck All</a>
+  <input type='submit' value='PRINT'>";
+  echo "<table border='1' cellpadding='0' cellspacing='5'>";
+  unset($hide);
+  $hide = array();
+  $pID = $d['petition_id'];
+  $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";
+  $r2 = $petition->query($q2);
+  while($d2 = mysqli_fetch_array($r2)){
+    if ($d2['signature_status'] == 'verified'){
+      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>";
+    }else{
+      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>";
+    }
+  }
+  echo '</table></fieldset>';
+
+       
+       
+}
+    ?>
+</form>
+
+<?PHP } ?>
+
+
 <form id='form2' name='form2' method='POST' action='printer.php'>
 
 <?PHP
@@ -200,7 +243,7 @@ while($d = mysqli_fetch_array($r)){
   }
 $r = $petition->query($q);
 while($d = mysqli_fetch_array($r)){
-  echo "<fieldset style='background-color:$d[web_color];'><legend style='background-color:white;'>$d[petition_name] - Printed</legend>
+  echo "<fieldset style='border: solid 1px $d[web_color];'><legend style='background-color:white;'>$d[petition_name] - Printed</legend>
   <a onclick=\"javascript:checkAll('form2', true);\" href=\"javascript:void();\">Check All</a>
   <a onclick=\"javascript:checkAll('form2', false);\" href=\"javascript:void();\">Uncheck All</a>
   <input type='submit' value='PRINT'>";
@@ -212,9 +255,9 @@ while($d = mysqli_fetch_array($r)){
   $r2 = $petition->query($q2);
   while($d2 = mysqli_fetch_array($r2)){
     if ($d2['signature_status'] == 'verified'){
-      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]-<a href='?review=$d2[id]'>Flag for Review</a></td><td>$d2[printed_status]</td></tr>";
+      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>";
     }else{
-      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[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>";
+      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>";
     }
   }
   echo '</table></fieldset>';