Update report.php

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

<?PHP 
include_once('security.php');
include_once('header.php');
slack_general('ADMIN: Reports Loaded ('.$_COOKIE['name'].') ('.$_COOKIE['level'].')','md-petition');
$group_id = $_COOKIE['group_id'];
?>
<script>
  function checkAll(formname, checktoggle)
{
  var checkboxes = new Array(); 
  checkboxes = document[formname].getElementsByTagName('input');
 
  for (var i=0; i<checkboxes.length; i++)  {
    if (checkboxes[i].type == 'checkbox')   {
      checkboxes[i].checked = checktoggle;
    }
  }
}
</script>
<style>
  body { background-color:lightgrey; }
  fieldset{ border: solid 1px lightblue; background-color:white; margin:10px; padding:10px; }
  legend{ border: solid 1px blue; background-color:white; margin:10px; padding:10px; }
</style>
<form id='form3' name='form3' method='POST' action='printer.php'>
  
<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'>
<?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><legend>$d[petition_name] - Unprinted</legend>";
  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 = '' order by id desc";
  $r2 = $petition->query($q2);
  while($d2 = mysqli_fetch_array($r2)){
   // if (!in_array($d2['VTRID'], $hide)) {
      //$hide[] = $d2['VTRID'];
      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>";
    //}
  }
  echo '</table></fieldset>';
}
    ?>
</form>

<form id='form2' name='form2' method='POST' action='printer.php'>
<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'>
<?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><legend>$d[petition_name] - Printed</legend>";
  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 <> '' order by id desc";
  $r2 = $petition->query($q2);
  while($d2 = mysqli_fetch_array($r2)){
    //if (!in_array($d2['VTRID'], $hide)) {
      //$hide[] = $d2['VTRID'];
      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>";
    //}
  }
  echo '</table></fieldset>';
}
?>
</form>

<?PHP
include_once('footer.php');
?>