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'];
$hide = array();
?>

<table border="1" cellpadding='0' cellspacing='5'>
<?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 "<h1>$d[petition_name]</h1>";
  $pID = $d['petition_id'];
  $q2="SELECT * FROM signatures where petition_id = '$pID' 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'></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></tr>";
    }
  }
}
?>
</table>
  <?PHP
include_once('footer.php');
?>