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 6df3461..41b2731 100644 (file)
--- a/admin/follow_up_success.php
+++ b/admin/follow_up_success.php
@@ -17,10 +17,30 @@ $list3  = '';
 $q="SELECT * FROM follow_up where status = 'NEW'";
 $r = $petition->query($q);
 while($d = mysqli_fetch_array($r)){
-   $list3 .= "<li>$d[email] $d[name]</li>";    
+   $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'";
+$q="SELECT * FROM follow_up where status <> 'NEW' order by id DESC";
 $r = $petition->query($q);
 while($d = mysqli_fetch_array($r)){
   $sig = '';