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

<?PHP 
include_once('security.php');
include_once('/var/www/secure.php'); //outside webserver
if (isset($_GET['override'])){
  $id = $_GET['override'];
  $petition->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='';
?>
<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; }
  td{ white-space: pre; }
</style>
<?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'";
}
//echo "<li>$q</li>";
$r = $petition->query($q);
while($d = mysqli_fetch_array($r)){
	$pID = $d['petition_id'];
	echo "<div id=\"chartContainer$d[petition_id]\" style=\"height: 200px; width: 100%; margin: 0px auto;\"></div>";
	$chart='';
	$chart2='';
	$q3 = "SELECT just_date FROM signatures where petition_id = '$pID' and just_date <> '0000-00-00' group by just_date";
	echo "<li>$q3</li>";
	$r3 = $core->query($q3) or die(mysqli_error($core));
	$total=0;
	while ($d3 = mysqli_fetch_array($r3)){
	  $q2 = "SELECT * FROM signatures where petition_id = '$pID' and just_date = '$d3[just_date]' and signature_status = 'verified'  ";
	  echo "<li>$q2</li>";
	  $r2 = $core->query($q2);
	  $count  = mysqli_num_rows($r2);
	  $chart .=  '{ label: "'.$d['just_date'].'", y: '.intval($count).' }, ';
	  $total = $total + intval($count);
	  $chart2 .=  '{ label: "'.$d['just_date'].'", y: '.intval($total).' }, ';
	}
	$chart = rtrim(trim($chart), ",");
	$chart2 = rtrim(trim($chart2), ",");
	
	
	ob_start(); ?>
	var chart<?PHP echo $d['petition_id'];?> = new CanvasJS.Chart("chartContainer<?PHP echo $d['petition_id'];?>", {
		theme:"light2",
		animationEnabled: true,
		exportEnabled: true,
		title:{
			text: "<?PHP echo $d['petition_name'];?> 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: "spline",
			visible: true,
			showInLegend: true,
			yValueFormatString: "#####",
			name: "Total Signatures",
			dataPoints: [
				<?PHP echo $chart2; ?>
			]
		},{
			type: "column",
			visible: true,
			showInLegend: true,
			yValueFormatString: "#####",
			name: "New Signatures",
			dataPoints: [
				<?PHP echo $chart; ?>
			]
		}]
	}


				      );
	chart<?PHP echo $d['petition_id'];?>.render();

	<?PHP $javascript .= ob_get_clean();
}
?>


<form id='form3' name='form3' method='POST' action='printer.php'>
<?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 style='background-color:$d[web_color];'><legend style='background-color:white;'>$d[petition_name] - Unprinted</legend>
  <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'>";
  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 = '' and signature_status <> 'deleted' order by signature_status, id desc";
  $r2 = $petition->query($q2);
  while($d2 = mysqli_fetch_array($r2)){
    if ($d2['signature_status'] == 'verified'){
      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]-<a href='?review=$d2[id]'>Flag for Review</a></td><td>$d2[printed_status]</td></tr>";
    }else{
      echo "<tr><td><a href='?override=$d2[id]'>Override</a> or <a href='?delete=$d2[id]'>Delete</a></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'>

<?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 style='background-color:$d[web_color];'><legend style='background-color:white;'>$d[petition_name] - Printed</legend>
  <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'>";
  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 <> '' and signature_status <> 'deleted' order by signature_status, id desc";
  $r2 = $petition->query($q2);
  while($d2 = mysqli_fetch_array($r2)){
    if ($d2['signature_status'] == 'verified'){
      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]-<a href='?review=$d2[id]'>Flag for Review</a></td><td>$d2[printed_status]</td></tr>";
    }else{
      echo "<tr><td><a href='?override=$d2[id]'>Override</a> or <a href='?delete=$d2[id]'>Delete</a></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>


<script>
window.onload = function () {

<?PHP echo $javascript;?>

function toggleDataSeries(e) {
	if (typeof(e.dataSeries.visible) === "undefined" || e.dataSeries.visible ){
		e.dataSeries.visible = false;
	} else {
		e.dataSeries.visible = true;
	}
	chart.render();
}

}
</script>


<script src="../files/canvasjs.min.js"></script>
<?PHP
include_once('footer.php');
?>
Commit	Line	Data
e3599ddc PM	1	<?PHP
e3599ddc PM	2	include_once('security.php');
3d88cafe PM	3	include_once('/var/www/secure.php'); //outside webserver
	4	if (isset($_GET['override'])){
	5	$id = $_GET['override'];
	6	$petition->query("update signatures set signature_status = 'verified' where id = '$id' ");
	7	header('Location: report.php');
	8	}
	9	if (isset($_GET['delete'])){
	10	$id = $_GET['delete'];
	11	$petition->query("update signatures set signature_status = 'deleted' where id = '$id' ");
	12	header('Location: report.php');
	13	}
dddebd21 PM	14	if (isset($_GET['review'])){
	15	$id = $_GET['review'];
	16	$petition->query("update signatures set signature_status = 'review_requested' where id = '$id' ");
	17	header('Location: report.php');
	18	}
e3599ddc	19	include_once('header.php');
9970efb3	20	slack_general('ADMIN: Reports Loaded ('.$_COOKIE['name'].') ('.$_COOKIE['level'].')','md-petition');
f1f9b284	21	$group_id = $_COOKIE['group_id'];
6865119a	22	$javascript='';
3f627365 PM	23	?>
	24	<script>
	25	function checkAll(formname, checktoggle)
	26	{
	27	var checkboxes = new Array();
	28	checkboxes = document[formname].getElementsByTagName('input');
	29
	30	for (var i=0; i<checkboxes.length; i++) {
	31	if (checkboxes[i].type == 'checkbox') {
	32	checkboxes[i].checked = checktoggle;
	33	}
	34	}
	35	}
	36	</script>
a8545882 PM	37	<style>
a8545882 PM	38	body { background-color:lightgrey; }
3f6d2be7 PM	39	fieldset{ border: solid 1px lightblue; background-color:white; margin:10px; padding:10px; }
3f6d2be7 PM	40	legend{ border: solid 1px blue; background-color:white; margin:10px; padding:10px; }
ecd65c5a	41	td{ white-space: pre; }
a8545882	42	</style>
fbdd1785 PM	43	<?PHP
	44	if($_COOKIE['level'] == 'admin'){
	45	$q="SELECT * FROM petitions where admin_status = 'approved' ";
	46	}else{
	47	$q="SELECT * FROM petitions where group_id = '$group_id' and admin_status = 'approved'";
	48	}
7daacef3	49	//echo "<li>$q</li>";
fbdd1785 PM	50	$r = $petition->query($q);
fbdd1785 PM	51	while($d = mysqli_fetch_array($r)){
7ff158cf	52	$pID = $d['petition_id'];
7daacef3	53	echo "<div id=\"chartContainer$d[petition_id]\" style=\"height: 200px; width: 100%; margin: 0px auto;\"></div>";
fbdd1785 PM	54	$chart='';
fbdd1785 PM	55	$chart2='';
74236c17	56	$q3 = "SELECT just_date FROM signatures where petition_id = '$pID' and just_date <> '0000-00-00' group by just_date";
7a955ef7 PM	57	echo "<li>$q3</li>";
7a955ef7 PM	58	$r3 = $core->query($q3) or die(mysqli_error($core));
fbdd1785	59	$total=0;
74236c17	60	while ($d3 = mysqli_fetch_array($r3)){
10815476	61	$q2 = "SELECT * FROM signatures where petition_id = '$pID' and just_date = '$d3[just_date]' and signature_status = 'verified' ";
b3712021	62	echo "<li>$q2</li>";
fbdd1785 PM	63	$r2 = $core->query($q2);
	64	$count = mysqli_num_rows($r2);
	65	$chart .= '{ label: "'.$d['just_date'].'", y: '.intval($count).' }, ';
	66	$total = $total + intval($count);
	67	$chart2 .= '{ label: "'.$d['just_date'].'", y: '.intval($total).' }, ';
	68	}
	69	$chart = rtrim(trim($chart), ",");
	70	$chart2 = rtrim(trim($chart2), ",");
b3712021 PM	71
	72
	73
	74
	75
fbdd1785 PM	76	ob_start(); ?>
	77	var chart<?PHP echo $d['petition_id'];?> = new CanvasJS.Chart("chartContainer<?PHP echo $d['petition_id'];?>", {
	78	theme:"light2",
	79	animationEnabled: true,
	80	exportEnabled: true,
	81	title:{
	82	text: "<?PHP echo $d['petition_name'];?> MD-Petition.com Signature Tracker"
	83	},
	84	axisY :{
	85	includeZero: false,
	86	title: "Number of Signatures",
	87	suffix: "",
	88	scaleBreaks: {
	89	autoCalculate: true
	90	}
	91	},
	92	toolTip: {
	93	shared: "true"
	94	},
	95	legend:{
	96	cursor:"pointer",
	97	itemclick : toggleDataSeries
	98	},
	99	data: [{
	100	type: "spline",
	101	visible: true,
	102	showInLegend: true,
	103	yValueFormatString: "#####",
	104	name: "Total Signatures",
	105	dataPoints: [
	106	<?PHP echo $chart2; ?>
	107	]
	108	},{
2e96f88a	109	type: "column",
fbdd1785 PM	110	visible: true,
	111	showInLegend: true,
	112	yValueFormatString: "#####",
	113	name: "New Signatures",
	114	dataPoints: [
	115	<?PHP echo $chart; ?>
	116	]
	117	}]
	118	}
	119
	120
	121	);
	122	chart<?PHP echo $d['petition_id'];?>.render();
	123
	124	<?PHP $javascript .= ob_get_clean();
	125	}
	126	?>
	127
	128
	129
	130
	131
	132
	133
	134
	135
	136
	137
	138
	139
	140
6865119a	141
79f261d4	142	<form id='form3' name='form3' method='POST' action='printer.php'>
3f627365	143	<?PHP
214e6829	144	if($_COOKIE['level'] == 'admin'){
feef9b7e	145	$q="SELECT * FROM petitions where admin_status = 'approved' ";
214e6829	146	}else{
feef9b7e	147	$q="SELECT * FROM petitions where group_id = '$group_id' and admin_status = 'approved'";
80b72550 PM	148	}
	149	$r = $petition->query($q);
	150	while($d = mysqli_fetch_array($r)){
6b1f3680	151	echo "<fieldset style='background-color:$d[web_color];'><legend style='background-color:white;'>$d[petition_name] - Unprinted</legend>
9a5ee71a PM	152	<a onclick=\"javascript:checkAll('form3', true);\" href=\"javascript:void();\">Check All</a>
	153	<a onclick=\"javascript:checkAll('form3', false);\" href=\"javascript:void();\">Uncheck All</a>
	154	<input type='submit' value='PRINT'>";
80b72550 PM	155	echo "<table border='1' cellpadding='0' cellspacing='5'>";
	156	unset($hide);
	157	$hide = array();
	158	$pID = $d['petition_id'];
0c13e2c5	159	$q2="SELECT * FROM signatures where petition_id = '$pID' and printed_status = '' and signature_status <> 'deleted' order by signature_status, id desc";
80b72550 PM	160	$r2 = $petition->query($q2);
80b72550 PM	161	while($d2 = mysqli_fetch_array($r2)){
6a911fb1	162	if ($d2['signature_status'] == 'verified'){
96e91f82	163	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]-<a href='?review=$d2[id]'>Flag for Review</a></td><td>$d2[printed_status]</td></tr>";
8452f380 PM	164	}else{
	165	echo "<tr><td><a href='?override=$d2[id]'>Override</a> or <a href='?delete=$d2[id]'>Delete</a></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>";
	166	}
80b72550	167	}
22e166b5	168	echo '</table></fieldset>';
fbdd1785	169
6865119a PM	170
	171
	172	}
	173	?>
	174	</form>
	175
	176	<form id='form2' name='form2' method='POST' action='printer.php'>
	177
	178	<?PHP
	179	if($_COOKIE['level'] == 'admin'){
	180	$q="SELECT * FROM petitions where admin_status = 'approved' ";
	181	}else{
	182	$q="SELECT * FROM petitions where group_id = '$group_id' and admin_status = 'approved' ";
	183	}
	184	$r = $petition->query($q);
	185	while($d = mysqli_fetch_array($r)){
	186	echo "<fieldset style='background-color:$d[web_color];'><legend style='background-color:white;'>$d[petition_name] - Printed</legend>
	187	<a onclick=\"javascript:checkAll('form2', true);\" href=\"javascript:void();\">Check All</a>
	188	<a onclick=\"javascript:checkAll('form2', false);\" href=\"javascript:void();\">Uncheck All</a>
	189	<input type='submit' value='PRINT'>";
	190	echo "<table border='1' cellpadding='0' cellspacing='5'>";
	191	unset($hide);
	192	$hide = array();
	193	$pID = $d['petition_id'];
	194	$q2="SELECT * FROM signatures where petition_id = '$pID' and printed_status <> '' and signature_status <> 'deleted' order by signature_status, id desc";
	195	$r2 = $petition->query($q2);
	196	while($d2 = mysqli_fetch_array($r2)){
	197	if ($d2['signature_status'] == 'verified'){
	198	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]-<a href='?review=$d2[id]'>Flag for Review</a></td><td>$d2[printed_status]</td></tr>";
	199	}else{
	200	echo "<tr><td><a href='?override=$d2[id]'>Override</a> or <a href='?delete=$d2[id]'>Delete</a></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>";
	201	}
	202	}
	203	echo '</table></fieldset>';
	204
	205
	206	}
	207	?>
	208	</form>
	209
	210
	211
	212
	213
	214	<script>
	215	window.onload = function () {
	216
	217	<?PHP echo $javascript;?>
ddec0164 PM	218
	219	function toggleDataSeries(e) {
	220	if (typeof(e.dataSeries.visible) === "undefined" \|\| e.dataSeries.visible ){
	221	e.dataSeries.visible = false;
	222	} else {
	223	e.dataSeries.visible = true;
	224	}
	225	chart.render();
	226	}
	227
	228	}
	229	</script>
	230
	231
	232
6865119a	233	<script src="../files/canvasjs.min.js"></script>
3f627365	234	<?PHP
e3599ddc PM	235	include_once('footer.php');
e3599ddc PM	236	?>