setcookie("order", $order);
die();
} else {
- slack_general('Loop Detected for '.$_COOKIE['sign_email'],'automation');
+ slack_general('Loop Detected for '.$_COOKIE['sign_email'],'fatal_errors');
echo "<h1>Automated Loop Detected - Skip Setting - Reverse Sort (DESC)</h1>";
$order = 'DESC';
setcookie("order", $order);
}elseif(isset($_GET['php_session_id']) && empty($_GET['follow_up'])){
$php_session_id = $_GET['php_session_id'];
echo "<h1>Review $php_session_id</h1><table width='100%' border='1' cellpadding='5' cellspacing='5'>";
- $q = "SELECT * FROM presign where php_session_id = '$php_session_id' order by id desc ";
+ $q = "SELECT * FROM presign where php_session_id = '$php_session_id' and email_for_follow_up <> '$_COOKIE[sign_email]' order by id DESC ";
$r = $petition->query($q);
while($d = mysqli_fetch_array($r)){
$color = 'white';
-$q="SELECT distinct php_session_id FROM presign where presign_status = 'NEW' and email_for_follow_up <> '' order by id $order";
+$q="SELECT distinct php_session_id, email_for_follow_up FROM presign where presign_status = 'NEW' and email_for_follow_up <> '' order by id $order";
$r = $petition->query($q);
while($d = mysqli_fetch_array($r)){
$q2="SELECT * FROM presign where php_session_id = '$d[php_session_id]' order by id desc";
$d3 = mysqli_fetch_array($r3);
if ($d3['date_time_signed'] != ''){
$sig = "<b><a href='?sign_email=$d2[email_for_follow_up]'>SIGNATURE $d3[date_time_signed]</a></b><br>";
- js_redirect("analytics.php?sign_email=$d2[email_for_follow_up]");
+ js_redirect("analytics.php?r=1&sign_email=$d2[email_for_follow_up]");
}
}
$presig='';
$d4 = mysqli_fetch_array($r4);
if ($d4['action_on']){
$presig = "<b><a href='?sign_email=$d2[email_for_follow_up]'>PRESIG $d4[action_on]</a></b><br>";
- js_redirect("analytics.php?sign_email=$d2[email_for_follow_up]");
+ js_redirect("analytics.php?r=2&sign_email=$d2[email_for_follow_up]");
}
$invite_error='';
- $q4="SELECT * FROM presign where email_for_follow_up = '$d2[email_for_follow_up]' and invite_error <> '' ";
+ $q4="SELECT * FROM presign where email_for_follow_up = '$d2[email_for_follow_up]' and invite_error <> '' and email_for_follow_up <> '$_COOKIE[sign_email]' ";
$r4 = $petition->query($q4);
$d4 = mysqli_fetch_array($r4);
+ $php_session_id = $d2['php_session_id'];
if ($d4['invite_error'] != ''){
- $invite_error = "<b><a href='?clear_email=$d2[email_for_follow_up]'>$d4[invite_error]</a></b><br>";
- js_redirect("analytics.php?clear_email=$d2[email_for_follow_up]");
+ $invite_error = "<b>$d4[invite_error]</b><br>";
+ $petition->query("update presign set presign_status = 'DONE' where php_session_id = '$php_session_id' ");
+ //js_redirect("analytics.php?r=3&clear_email=$d2[email_for_follow_up]");
}
- $php_session_id = $d2['php_session_id'];
echo "<tr><td><a href='?php_session_id=$php_session_id'>$d2[action_on]</a></td><td>$presig $sig $invite_error</td>
<td>$d2[name]</td><td><a href='?email=$d2[email_for_follow_up]'>$d2[email_for_follow_up]</a></td>
<td>".id2petition($d2['petition'])."</td><td>$d2[invite]</td>
- <a href='?php_session_id=$php_session_id&follow_up=8'>Ivey</a></td></tr>";
if( $presig == '' && $invite_error == '' && $sig == '' ){
if ($d2['invite'] == 'Ivey'){
- js_redirect("analytics.php?php_session_id=$php_session_id&follow_up=8");
+ js_redirect("analytics.php?r=4&php_session_id=$php_session_id&follow_up=8");
die();
}
if ($d2['invite'] == 'mlp'){
- js_redirect("analytics.php?php_session_id=$php_session_id&follow_up=2");
+ js_redirect("analytics.php?r=5&php_session_id=$php_session_id&follow_up=2");
die();
}
if ($d2['invite'] == 'BTEC'){
- js_redirect("analytics.php?php_session_id=$php_session_id&follow_up=3");
+ js_redirect("analytics.php?r=6&php_session_id=$php_session_id&follow_up=3");
die();
}
if ($d2['invite'] == 'RestorePGTermLimits'){
- js_redirect("analytics.php?php_session_id=$php_session_id&follow_up=7");
+ js_redirect("analytics.php?r=7&php_session_id=$php_session_id&follow_up=7");
die();
}
if (id2petition($d2['petition']) == 'RESTORE TWO TERM (8 YEAR) TERM LIMITS IN PRINCE GEORGE'){
- js_redirect("analytics.php?php_session_id=$php_session_id&follow_up=7");
+ js_redirect("analytics.php?r=8&php_session_id=$php_session_id&follow_up=7");
die();
}
if ($d2['invite'] == 'mgp'){
- js_redirect("analytics.php?php_session_id=$php_session_id&follow_up=1");
+ js_redirect("analytics.php?r=9&php_session_id=$php_session_id&follow_up=1");
die();
}
- js_redirect("analytics.php?php_session_id=$php_session_id&follow_up=X"); // no invite found no petition found - send general follow/up
+ js_redirect("analytics.php?r=10&php_session_id=$php_session_id&follow_up=X"); // no invite found no petition found - send general follow/up
}
}
?></table>
// allow headers to be sent...
$html = ob_get_clean();
echo $html; // run javascript
-
+slack_general('automation complete','md-petition-admin');
include_once('footer.php');
?>