X-Git-Url: http://git.hcoop.net/clinton/MarylandElectronicPetitionSignature.git/blobdiff_plain/78dc9b02ec6e23c007d22ef31a66caa16fe15f83..HEAD:/admin/report.php diff --git a/admin/report.php b/admin/report.php index 5c224d1..0518595 100644 --- a/admin/report.php +++ b/admin/report.php @@ -50,7 +50,7 @@ if($_COOKIE['level'] == 'admin'){ $r = $petition->query($q); while($d = mysqli_fetch_array($r)){ $pID = $d['petition_id']; - echo "
"; + echo "
"; $chart=''; $chart2=''; $chart3=''; @@ -111,7 +111,7 @@ while($d = mysqli_fetch_array($r)){ dataPoints: [ ] - },{ + },{ type: "line", visible: true, showInLegend: true, @@ -120,7 +120,7 @@ while($d = mysqli_fetch_array($r)){ dataPoints: [ ] - },{ + },{ 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 "
$d[petition_name] - Unprinted + echo "
$d[petition_name] - Unprinted Check All Uncheck All "; @@ -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 " - $d2[ip_address]$d2[date_time_signed]$d2[signed_name_as]$d2[signed_name_as_circulator]$d2[contact_phone]$d2[signature_status]-Flag for Review$d2[printed_status]"; + $d2[ip_address]$d2[date_time_signed]$d2[VoterList_table]$d2[signed_name_as]$d2[signed_name_as_circulator]$d2[contact_phone]$d2[signature_status]-Flag for Review$d2[printed_status]"; }else{ echo " - Override or Delete$d2[ip_address]$d2[date_time_signed]$d2[signed_name_as]$d2[signed_name_as_circulator]$d2[contact_phone]$d2[signature_status]$d2[printed_status]"; + Override or Delete$d2[ip_address]$d2[date_time_signed]$d2[VoterList_table]$d2[signed_name_as]$d2[signed_name_as_circulator]$d2[contact_phone]$d2[signature_status]$d2[printed_status]"; } } echo '
'; @@ -190,6 +191,48 @@ while($d = mysqli_fetch_array($r)){ ?> + + + +
+query($q); +while($d = mysqli_fetch_array($r)){ + echo "
$d[petition_name] - Flagged for Deletion or Override + Check All + Uncheck All + "; + echo ""; + 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 " + "; + }else{ + echo " + "; + } + } + echo '
$d2[ip_address]$d2[date_time_signed]$d2[VoterList_table]$d2[signed_name_as]$d2[signed_name_as_circulator]$d2[contact_phone]$d2[signature_status]-Flag for Review$d2[printed_status]
Override or Delete$d2[ip_address]$d2[date_time_signed]$d2[VoterList_table]$d2[signed_name_as]$d2[signed_name_as_circulator]$d2[contact_phone]$d2[signature_status]$d2[printed_status]
'; + + + +} + ?> +
+ + + +
query($q); while($d = mysqli_fetch_array($r)){ - echo "
$d[petition_name] - Printed + echo "
$d[petition_name] - Printed Check All Uncheck All "; @@ -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 "$d2[ip_address]$d2[date_time_signed]$d2[signed_name_as]$d2[signed_name_as_circulator]$d2[contact_phone]$d2[signature_status]-Flag for Review$d2[printed_status]"; + echo "$d2[ip_address]$d2[date_time_signed]$d2[VoterList_table]$d2[signed_name_as]$d2[signed_name_as_circulator]$d2[contact_phone]$d2[signature_status]-Flag for Review$d2[printed_status]"; }else{ - echo "Override or Delete$d2[ip_address]$d2[date_time_signed]$d2[signed_name_as]$d2[signed_name_as_circulator]$d2[contact_phone]$d2[signature_status]$d2[printed_status]"; + echo "Override or Delete$d2[ip_address]$d2[date_time_signed]$d2[VoterList_table]$d2[signed_name_as]$d2[signed_name_as_circulator]$d2[contact_phone]$d2[signature_status]$d2[printed_status]"; } } echo '
';