Create search.php

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

diff --git a/admin/follow_up_success.php b/admin/follow_up_success.php
index d63c6f1..41b2731 100644 (file)
--- a/admin/follow_up_success.php
+++ b/admin/follow_up_success.php
@@ -10,8 +10,37 @@ if ($_COOKIE['level'] == 'manager'){
   header('Location: manager_home.php');
 }
 include_once('header.php');
+$list1  = '';
+$list2  = '';
+$list3  = '';
 
-$q="SELECT * FROM follow_up where status <> 'NEW'";
+$q="SELECT * FROM follow_up where status = 'NEW'";
+$r = $petition->query($q);
+while($d = mysqli_fetch_array($r)){
+   $sig = '';
+  if ($d['name'] != ''){
+    $q3 = "SELECT date_time_signed FROM signatures where signed_name_as = '$d[name]'";
+    $r3 = $petition->query($q3);
+    $d3 = mysqli_fetch_array($r3); 
+    if ($d3['date_time_signed'] != ''){
+      $sig = "<b>SIGNATURE $d3[date_time_signed]</b>";
+    }
+  }
+  $presig='';
+  $q4="SELECT * FROM presign where email_for_follow_up = '$d[email]' and php_page like '/sign.php%'";
+  $r4 = $petition->query($q4);
+  $d4 = mysqli_fetch_array($r4);
+  if ($d4['action_on']){
+    $presig = "<b>PRESIG $d4[action_on]</b>";
+  }
+  if ($presig != '' || $sig != ''){ 
+    $list3 .= "<li>$d[email] $presig $d[name] $sig</li>";    
+  }else{
+    $list3 .= "<li>$d[date_sent] $d[email] $d[name]</li>";
+  }    
+}
+
+$q="SELECT * FROM follow_up where status <> 'NEW' order by id DESC";
 $r = $petition->query($q);
 while($d = mysqli_fetch_array($r)){
   $sig = '';
@@ -37,6 +66,15 @@ while($d = mysqli_fetch_array($r)){
   }
   
 }
+ob_start();
+echo "<h1>Outbox</h1>";
+echo "<ol>";
+echo $list3;
+echo "</ol>";
+$buffer = ob_get_clean();
+if ($list3 != ''){
+ echo $buffer; 
+}
 echo "<h1>Signed</h1>";
 echo "<ol>";
 echo $list1;