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';
<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>
}
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>
</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'])){
}
$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';
<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>
<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);
</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