X-Git-Url: http://git.hcoop.net/clinton/MarylandElectronicPetitionSignature.git/blobdiff_plain/37ae64f86c0ea10e24a3b4629fad8bccfc7cecd1..3ed46210922595ddff26b710533bade4cd001bed:/admin/index.php

diff --git a/admin/index.php b/admin/index.php
index eed4952..5bbeb8a 100644
--- a/admin/index.php
+++ b/admin/index.php
@@ -40,6 +40,34 @@ slack_general('ADMIN: Home Page Loaded ('.$_COOKIE['name'].') ('.$_COOKIE['level
 
 <h1>Admin Home</h1>
 <div id="chartContainer1" style="height: 400px; width: 100%; margin: 0px auto;"></div>
+<div id="chartContainer2" style="height: 400px; width: 100%; margin: 0px auto;"></div>
+
+<table><tr><td valign='top'>
+<h2>Admin Sessions</h2>
+<div>Last 50</div><ol>
+<?PHP
+$q="SELECT * FROM admin_sessions where username <> 'Patrick McGuire' ORDER BY id DESC LIMIT 50";
+$r = $petition->query($q);
+while($d = mysqli_fetch_array($r)){ 
+    echo "<li title='$d[action_on]'>$d[ip] $d[username] $d[php_page]</li>"; 
+}
+?></ol>	
+	
+	</td><td valign='top'>
+
+	<h2>User Sessions</h2>
+<div>Last 50</div><ol>
+<?PHP
+$q="SELECT * FROM presign ORDER BY id DESC LIMIT 50";
+$r = $petition->query($q);
+while($d = mysqli_fetch_array($r)){ 
+    echo "<li title='$d[action_on]'>$d[php_page] $d[browser_string]</li>"; 
+}
+?></ol>
+	
+	</td></tr></table>
+
+
 <h1>Users</h1>
 <form method='post'>
   <table>
@@ -119,6 +147,7 @@ while($d = mysqli_fetch_array($r)){
 	if ($goal == 0){
 		$goal = 10000;
 	}
+	$trader_sma_timePeriod=0;
 	while ($d3 = mysqli_fetch_array($r3)){
 	  $just_date = $d3['just_date'];
 	  $q2 = "SELECT * FROM signatures where just_date = '$just_date' and signature_status = 'verified'  ";
@@ -136,13 +165,33 @@ while($d = mysqli_fetch_array($r)){
 	  $chart4 .=  '{ label: "'.$just_date.'", y: '.intval($count).' }, ';
 	  $total2 = $total2 + $count;
 	  $chart5 .=  '{ label: "'.$just_date.'", y: '.intval($total2).' }, ';
+	  
+	  $q2 = "SELECT * FROM presign where only_date = '$just_date'  ";
+	  $r2 = $petition->query($q2);	
+	  $count  = mysqli_num_rows($r2);
+	  if($count > 0){ // start this graph when there is data
+		  $chart6 .=  '{ label: "'.$just_date.'", y: '.intval($count).' }, ';
+		  // graph latest sma
+		  $trader_sma_real[] = intval($count);
+		  $trader_sma_timePeriod++;
+		  $trader_sma = trader_sma($trader_sma_real,$trader_sma_timePeriod);
+		  //print_r($trader_sma);
+		  $the_index = $trader_sma_timePeriod - 1;
+		  $this_sma = $trader_sma[$the_index]; // should be last value?
+		  $chart7 .=  '{ label: "'.$just_date.'", y: '.intval($this_sma).' }, ';
+	  }
 	}
+	
 	$chart = rtrim(trim($chart), ",");
 	$chart2 = rtrim(trim($chart2), ",");
 	$chart3 = rtrim(trim($chart3), ",");
 	$chart4 = rtrim(trim($chart4), ",");
         $chart5 = rtrim(trim($chart5), ",");
+	$chart6 = rtrim(trim($chart6), ",");
+        $chart7 = rtrim(trim($chart7), ",");
+
 	
+
 	ob_start(); ?>
 
 	var chart<?PHP echo $pID;?> = new CanvasJS.Chart("chartContainer<?PHP echo $pID;?>", {
@@ -207,6 +256,53 @@ while($d = mysqli_fetch_array($r)){
 	}
 
 
+				      );
+	chart<?PHP echo $pID; $pID = $pID + 1; ?>.render();
+
+         var chart<?PHP echo $pID;?> = new CanvasJS.Chart("chartContainer<?PHP echo $pID;?>", {
+		theme:"light2",
+		animationEnabled: true,
+		exportEnabled: true,
+		title:{
+			text: "MD-Petition.com Web Monitor"
+		},
+		axisY :{
+			includeZero: false,
+			title: "Number of Pages Loaded",
+			suffix: "",
+	    scaleBreaks: {
+					autoCalculate: true
+				}
+		},
+		toolTip: {
+			shared: "true"
+		},
+		legend:{
+			cursor:"pointer",
+			itemclick : toggleDataSeries
+		},
+		data: [{
+			type: "line",
+			visible: true,
+			showInLegend: true,
+			yValueFormatString: "#####",
+			name: "Web Activity",
+			dataPoints: [
+				<?PHP echo $chart6; ?>
+			]
+		},{
+			type: "line",
+			visible: true,
+			showInLegend: true,
+			yValueFormatString: "#####",
+			name: "Simple Moving Average",
+			dataPoints: [
+				<?PHP echo $chart7; ?>
+			]
+		}]
+	}
+
+
 				      );
 	chart<?PHP echo $pID;?>.render();