Update analytics.php

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

diff --git a/admin/analytics.php b/admin/analytics.php
index d243ed9..2e45f63 100644 (file)
--- a/admin/analytics.php
+++ b/admin/analytics.php
@@ -1,14 +1,56 @@
 <?PHP 
-include_once('../slack.php');
-include_once('security.php');
-include_once('/var/www/secure.php'); //outside webserver
-include_once('functions.php');
+global $order;
+$order = 'ASC';
+if (isset($_COOKIE['order'])){
+  $order = $_COOKIE['order'];
+}
+
+if (empty($_GET['run'])){
+  if ($_COOKIE['name'] == ''){
+    die('no name');
+  }
+  include_once('bots.php');
+  include_once('../slack.php');
+  include_once('security.php');
+  include_once('/var/www/secure.php'); //outside webserver
+  include_once('functions.php');
+}else{
+  include_once('../slack.php');
+  include_once('/var/www/secure.php'); //outside webserver
+  include_once('functions.php');
+}
+ob_start();
+
+$sign_email = $_COOKIE['sign_email'];
+if (isset($_GET['sign_email'])){
+  // here we use it, if it shows up next run, we block
+  $sign_email = $_GET['sign_email'];
+  $_COOKIE['sign_email'] = $sign_email;
+  setcookie("sign_email", $sign_email);
+  
+}
 
-function js_redirect($page){
+function js_redirect($page){ // now header - prep for full auto
   $base = 'https://www.md-petition.com/admin/';
-  $url = $base.$page;
-  echo "<script>window.location.href = \"$url\";</script>";
-  die(); 
+  $url = $base.$page.'&run=1';
+  $pos = strpos($page, $_COOKIE['sign_email']);
+  global $order;
+  if ($pos === false) {
+    // email not found - good to redirect
+    //echo "<script>window.location.href = \"$url\";</script>";
+    slack_general('js_redirect('.$page.')','automation');
+    header('Location: '.$url);
+    //slack_general('CHECK COOKIE ('.$_COOKIE['sign_email'].') PAGE ('.$page.')','md-petition-admin');
+    $order = 'ASC';
+    setcookie("order", $order);
+    die(); 
+  } else {
+    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);
+  }
+  
 }
 
 if ($_COOKIE['level'] == 'user'){
@@ -136,7 +178,7 @@ if (isset($_GET['ip_address'])){
 }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';
@@ -289,7 +331,10 @@ while($d = mysqli_fetch_array($r)){
 <div>Follow up requested - never signed.</div>
 <form method='GET'><input name='email'><input type='submit' value='SEARCH E-MAIL'></form><table>
 <?PHP
-$q="SELECT distinct php_session_id FROM presign where presign_status = 'NEW' and email_for_follow_up <> '' order by id";
+  
+
+  
+$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";
@@ -302,7 +347,7 @@ while($d = mysqli_fetch_array($r)){
     $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='';
@@ -311,24 +356,54 @@ while($d = mysqli_fetch_array($r)){
   $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>
+  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>
   <td><a href='?php_session_id=$php_session_id&follow_up=X'>General</a>
   - <a href='?php_session_id=$php_session_id&follow_up=1'>MGP</a> 
   - <a href='?php_session_id=$php_session_id&follow_up=2'>MLP</a>
   - <a href='?php_session_id=$php_session_id&follow_up=3'>BTEC</a>
   - <a href='?php_session_id=$php_session_id&follow_up=7'>PG</a>
   - <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?r=4&php_session_id=$php_session_id&follow_up=8");
+      die();
+    }
+    if ($d2['invite'] == 'mlp'){
+      js_redirect("analytics.php?r=5&php_session_id=$php_session_id&follow_up=2");
+      die();
+    }
+    if ($d2['invite'] == 'BTEC'){
+      js_redirect("analytics.php?r=6&php_session_id=$php_session_id&follow_up=3");
+      die();
+    }
+    if ($d2['invite'] == 'RestorePGTermLimits'){
+      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?r=8&php_session_id=$php_session_id&follow_up=7");
+      die();
+    }
+    if ($d2['invite'] == 'mgp'){
+      js_redirect("analytics.php?r=9&php_session_id=$php_session_id&follow_up=1");
+      die();
+    }
+    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>
   </td>
@@ -344,6 +419,7 @@ while($d = mysqli_fetch_array($r)){
     echo "<li>$d[date_time_signed] ".id2petition($d['petition_id'])." $d[signed_name_as]</li>"; 
 }
 ?></ol>
+
   </td>
 
   </tr>
@@ -407,5 +483,9 @@ while($d = mysqli_fetch_array($r)){
 
 
 <?PHP
+// allow headers to be sent...
+$html = ob_get_clean();
+echo $html; // run javascript
+slack_general('automation complete','md-petition-admin');
 include_once('footer.php');
 ?>