X-Git-Url: https://git.hcoop.net/clinton/MarylandElectronicPetitionSignature.git/blobdiff_plain/d649512287f4055c589a77e98af3ef31633ef3d2..b74d50618e5226840452705ac0dfdbb86979db2c:/admin/analytics.php

diff --git a/admin/analytics.php b/admin/analytics.php
index 4230e42..a69d2fe 100644
--- a/admin/analytics.php
+++ b/admin/analytics.php
@@ -59,8 +59,9 @@ if (isset($_GET['flag_phone'])){
 include_once('header.php');
 if (isset($_GET['ip_address'])){ 
   $ip = $_GET['ip_address']; 
+  $petition_id = $_GET['petition_id']; 
   echo "<h1>Review $ip</h1><table width='100%' border='1' cellpadding='5' cellspacing='5'>";    
-  $q = "SELECT * FROM  signatures where ip_address = '$ip' order by signature_status desc ";
+  $q = "SELECT * FROM signatures where ip_address = '$ip' and signature_status = 'verified' and petition_id = '$petition_id' order by signature_status desc ";
   $r = $petition->query($q);
   while($d = mysqli_fetch_array($r)){
     $color = 'white';
@@ -75,7 +76,6 @@ if (isset($_GET['ip_address'])){
       <td>$d[signed_name_as]</td>
       <td>$d[signed_name_as_circulator]</td>
       <td>$d[contact_phone]</td>
-      <td>$d[signature_status]</td>
       <td>$d[printed_status]</td>
       <td><a href='?flag_invalid_signature=$d[id]'>flag invalid signature</a></td>
       <td><a href='?flag_VTRID=$d[VTRID]'>flag VTRID</a></td>
@@ -101,7 +101,7 @@ if (isset($_GET['ip_address'])){
     } 
     echo "<tr style='background-color:$color;'>
       <td style='white-space:pre;'><b>$d[action_on]</b></td>
-      <td style='white-space:pre;'><a href='$d[php_session_id]'>$d[php_session_id]</a></td>
+      <td style='white-space:pre;'><a href='?php_session_id=$d[php_session_id]'>$d[php_session_id]</a></td>
       <td style='white-space:pre;'>$d[php_page]</td>
       <td style='white-space:pre;'>".id2petition($d['petition'])."</td>
       <td style='white-space:pre;'>$d[invite]</td>
@@ -142,11 +142,12 @@ if (isset($_GET['ip_address'])){
     </tr>"; 
   }
   echo "</table><a href='?clear_php_session_id=$php_session_id'>CLEAR ALERT</a> - 
-  <a href='?sign_php_session_id=$php_session_id'>SIGNATURE FOUND</a> - 
-  - <a href='?php_session_id=$php_session_id&follow_up=1'>ADD TO FOLLOW UP LIST MGP</a>
-  - <a href='?php_session_id=$php_session_id&follow_up=2'>ADD TO FOLLOW UP LIST MLP</a>
-  - <a href='?php_session_id=$php_session_id&follow_up=3'>ADD TO FOLLOW UP LIST BTEC</a>
-  - <a href='?php_session_id=$php_session_id&follow_up=7'>ADD TO FOLLOW UP LIST PG</a>
+  <a href='?sign_php_session_id=$php_session_id'>SIGNATURE FOUND</a><br> 
+  - <a href='?php_session_id=$php_session_id&follow_up=0'>ADD TO FOLLOW UP LIST Maryland General</a><br>
+  - <a href='?php_session_id=$php_session_id&follow_up=1'>ADD TO FOLLOW UP LIST MGP</a><br> 
+  - <a href='?php_session_id=$php_session_id&follow_up=2'>ADD TO FOLLOW UP LIST MLP</a><br> 
+  - <a href='?php_session_id=$php_session_id&follow_up=3'>ADD TO FOLLOW UP LIST BTEC</a><br> 
+  - <a href='?php_session_id=$php_session_id&follow_up=7'>ADD TO FOLLOW UP LIST PG</a><br> 
   - <a href='?php_session_id=$php_session_id&follow_up=8'>ADD TO FOLLOW UP LIST Ivey</a>
   ";
 }elseif(isset($_GET['php_session_id']) && isset($_GET['follow_up'])){ 
@@ -184,11 +185,13 @@ if ($d[email_for_follow_up] != ''){
   }
   $petition->query("insert into follow_up (name, email, php_session, petition_id) values ('$name','$email','$php_session_id','$_GET[follow_up]') ");  
   $petition->query("update presign set presign_status = 'DONE' where php_session_id = '$php_session_id' ");
+  $petition->query("update presign set presign_status = 'DONE' where email = '$email' ");
   echo "</table>";
 }elseif (isset($_GET['VTRID'])){ 
   $VTRID = $_GET['VTRID'];
+   $petition_id = $_GET['petition_id']; 
   echo "<h1>Review $VTRID</h1><table width='100%' border='1' cellpadding='5' cellspacing='5'>";   
-  $q = "SELECT * FROM  signatures where VTRID = '$VTRID' and signature_status <> 'deleted' order by petition_id, id DESC ";
+  $q = "SELECT * FROM  signatures where VTRID = '$VTRID' and signature_status = 'verified' and petition_id = '$petition_id' order by petition_id, id DESC ";
   $r = $petition->query($q);
   while($d = mysqli_fetch_array($r)){
     $color = 'white';
@@ -203,7 +206,6 @@ if ($d[email_for_follow_up] != ''){
           <td>$d[signed_name_as]</td>
           <td>$d[signed_name_as_circulator]</td>
           <td>$d[contact_phone]</td>
-          <td>$d[signature_status]</td>
           <td>$d[printed_status]</td>
           <td><a href='?flag_invalid_signature=$d[id]'>flag invalid signature</a></td>
           <td><a href='?flag_VTRID=$d[VTRID]'>flag VTRID</a></td>
@@ -221,11 +223,41 @@ if ($d[email_for_follow_up] != ''){
 <h1>Signature Analytics</h1>
 <h2>NEVER NEVER NEVER CALL OR TEXT ANYONE - ONLY EMAIL!!!</h2>
 <h3>SysOp Says: Transparency = Trust</h3>
-<table><tr>
+<table>
+  
+  <tr>
+  <td valign="top"><?PHP /*
+<h2>IP Address</h2>
+<div>Watching for duplicates.</div><ol>
+<?PHP
+$q="SELECT ip_address, petition_id,VTRID, COUNT(*) as count FROM signatures where signature_status = 'verified' group by ip_address, petition_id, VTRID";
+$r = $petition->query($q);
+while($d = mysqli_fetch_array($r)){
+  if ($d['count'] > 1){
+    echo "<li><a href='?ip_address=$d[ip_address]&petition_id=$d[petition_id]'>$d[ip_address]</a> ".id2petition($d['petition_id'])." <b>$d[count]</b> $d[signed_name_as]</li>"; 
+  }
+}
+?></ol> */ ?>
+  </td><td valign="top">
+<h2>VTRID</h2>
+<div>Watching for duplicates.</div><ol>
+<?PHP
+$q="SELECT VTRID, petition_id, COUNT(*) as count FROM signatures where signature_status = 'verified' group by VTRID, petition_id";
+$r = $petition->query($q);
+while($d = mysqli_fetch_array($r)){ 
+  if ($d['count'] > 1){
+    echo "<li><a href='?VTRID=$d[VTRID]&petition_id=$d[petition_id]'>$d[VTRID]</a> ".id2petition($d['petition_id'])." <b>$d[count]</b> $d[signed_name_as]</li>"; 
+  }
+}
+  ?></ol>
+  </td></tr>
+  
+  
 <tr>
 <td valign="top">
 <h2>Pre-Sign</h2>
-<div>Follow up requested - never signed.</div><ol>
+<div>Follow up requested - never signed.</div>
+<form method='GET'><input name='email'><input type='submit' value='SEARCH E-MAIL'></form><ol>
 <?PHP
 $q="SELECT distinct php_session_id FROM presign where presign_status = 'NEW' and email_for_follow_up <> '' order by id desc";
 $r = $petition->query($q);
@@ -250,31 +282,7 @@ while($d = mysqli_fetch_array($r)){
   </td>
 
   </tr>
-  <td valign="top">
-<h2>IP Address</h2>
-<div>Watching for duplicates.</div><ol>
-<?PHP
-$q="SELECT ip_address, petition_id,VTRID, COUNT(*) as count FROM signatures where signature_status = 'verified' group by ip_address, petition_id, VTRID";
-$r = $petition->query($q);
-while($d = mysqli_fetch_array($r)){
-  if ($d['count'] > 1){
-    echo "<li><a href='?ip_address=$d[ip_address]'>$d[ip_address]</a> ".id2petition($d['petition_id'])." <b>$d[count]</b> $d[signed_name_as]</li>"; 
-  }
-}
-?></ol>
-  </td><td valign="top">
-<h2>VTRID</h2>
-<div>Watching for duplicates.</div><ol>
-<?PHP
-$q="SELECT VTRID, petition_id, COUNT(*) as count FROM signatures where signature_status = 'verified' group by VTRID, petition_id";
-$r = $petition->query($q);
-while($d = mysqli_fetch_array($r)){ 
-  if ($d['count'] > 1){
-    echo "<li><a href='?VTRID=$d[VTRID]'>$d[VTRID]</a> ".id2petition($d['petition_id'])." <b>$d[count]</b> $d[signed_name_as]</li>"; 
-  }
-}
-  ?></ol>
-  </td></tr><tr><td valign="top">
+  <tr><td valign="top">
 <h2>VTRID Bugs</h2>
 <div>Watching for 0</div><ol>
 <?PHP