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();