X-Git-Url: http://git.hcoop.net/clinton/MarylandElectronicPetitionSignature.git/blobdiff_plain/f8ab31d6ce566d29e0e185328b78c71fe6060dea..3ed46210922595ddff26b710533bade4cd001bed:/admin/report.php diff --git a/admin/report.php b/admin/report.php index 4dd0d5b..527b1c3 100644 --- a/admin/report.php +++ b/admin/report.php @@ -1,8 +1,25 @@ query("update signatures set signature_status = 'verified' where id = '$id' "); + header('Location: report.php'); +} +if (isset($_GET['delete'])){ + $id = $_GET['delete']; + $petition->query("update signatures set signature_status = 'deleted' where id = '$id' "); + header('Location: report.php'); +} +if (isset($_GET['review'])){ + $id = $_GET['review']; + $petition->query("update signatures set signature_status = 'review_requested' where id = '$id' "); + header('Location: report.php'); +} include_once('header.php'); slack_general('ADMIN: Reports Loaded ('.$_COOKIE['name'].') ('.$_COOKIE['level'].')','md-petition'); $group_id = $_COOKIE['group_id']; +$javascript=''; ?> + +$q"; +$r = $petition->query($q); +while($d = mysqli_fetch_array($r)){ + $pID = $d['petition_id']; + echo "
"; + $chart=''; + $chart2=''; + $chart3=''; + $q3 = "SELECT just_date FROM signatures where petition_id = '$pID' and just_date <> '0000-00-00' group by just_date"; + //echo "
  • $q3
    • "; + $r3 = $petition->query($q3); + $total=0; + $goal = $d['signature_goal']; + if ($goal == 0){ + $goal = 10000; + } + while ($d3 = mysqli_fetch_array($r3)){ + $just_date = $d3['just_date']; + $q2 = "SELECT * FROM signatures where petition_id = '$pID' and just_date = '$just_date' and signature_status = 'verified' "; + //echo "
  • $q2
    • "; + $r2 = $petition->query($q2); + $count = mysqli_num_rows($r2); + $chart .= '{ label: "'.$just_date.'", y: '.intval($count).' }, '; + $total = $total + intval($count); + $chart2 .= '{ label: "'.$just_date.'", y: '.intval($total).' }, '; + $goal = $goal - intval($count); + $chart3 .= '{ label: "'.$just_date.'", y: '.intval($goal).' }, '; + } + $chart = rtrim(trim($chart), ","); + $chart2 = rtrim(trim($chart2), ","); + $chart3 = rtrim(trim($chart3), ","); + + ob_start(); ?> + + var chart = new CanvasJS.Chart("chartContainer", { + theme:"light2", + animationEnabled: true, + exportEnabled: true, + title:{ + text: " MD-Petition.com Signature Tracker" + }, + axisY :{ + includeZero: false, + title: "Number of Signatures", + suffix: "", + scaleBreaks: { + autoCalculate: true + } + }, + toolTip: { + shared: "true" + }, + legend:{ + cursor:"pointer", + itemclick : toggleDataSeries + }, + data: [{ + type: "line", + visible: true, + showInLegend: true, + yValueFormatString: "#####", + name: "Total Signatures Count", + dataPoints: [ + + ] + },{ + type: "line", + visible: true, + showInLegend: true, + yValueFormatString: "#####", + name: "Signatures Remaining to Goal", + dataPoints: [ + + ] + },{ + type: "column", + visible: true, + showInLegend: true, + yValueFormatString: "#####", + name: "New Daily Signatures", + dataPoints: [ + + ] + }] + } + + + ); + chart.render(); + + + + + + + + + + + + + + + +
    -check all -uncheck all - query($q); while($d = mysqli_fetch_array($r)){ - echo "

    $d[petition_name]

    "; + echo "
    $d[petition_name] - Unprinted + Check All + Uncheck All + "; echo ""; unset($hide); $hide = array(); $pID = $d['petition_id']; - $q2="SELECT * FROM signatures where petition_id = '$pID' order by 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 (!in_array($d2['VTRID'], $hide)) { - //$hide[] = $d2['VTRID']; - echo ""; - //} + if ($d2['signature_status'] == 'verified'){ + $id = $d2['id']; + echo " + "; + }else{ + echo " + "; + } } - echo '
    $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]
    $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]
    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 '
    '; + + + } -?> + ?>
    + + + +
    +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[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[signed_name_as]$d2[signed_name_as_circulator]$d2[contact_phone]$d2[signature_status]$d2[printed_status]
    '; + + + +} + ?> +
    + + + +
    -check all -uncheck all - + '' "; + $q="SELECT * FROM petitions where admin_status = 'approved' "; }else{ - $q="SELECT * FROM petitions where group_id = '$group_id' and admin_status = 'approved' and printed_status <> '' "; + $q="SELECT * FROM petitions where group_id = '$group_id' and admin_status = 'approved' "; } $r = $petition->query($q); while($d = mysqli_fetch_array($r)){ - echo "

    $d[petition_name] - Printed

    "; + echo "
    $d[petition_name] - Printed + Check All + Uncheck All + "; echo ""; unset($hide); $hide = array(); $pID = $d['petition_id']; - $q2="SELECT * FROM signatures where petition_id = '$pID' order by id desc"; + $q2="SELECT * FROM signatures where petition_id = '$pID' and printed_status <> '' and signature_status <> 'deleted' order by signature_status, id desc"; $r2 = $petition->query($q2); while($d2 = mysqli_fetch_array($r2)){ - //if (!in_array($d2['VTRID'], $hide)) { - //$hide[] = $d2['VTRID']; - echo ""; - //} + if ($d2['signature_status'] == 'verified'){ + echo ""; + }else{ + echo ""; + } } - echo '
    $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]
    $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]
    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 '
    '; + + } ?>
    + + + + + + + + +