Create search.php

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

diff --git a/admin/follow_up_emails.php b/admin/follow_up_emails.php
index ae635d4..b14f79e 100644 (file)
--- a/admin/follow_up_emails.php
+++ b/admin/follow_up_emails.php
@@ -1,7 +1,10 @@
 <?PHP
 include_once('../email.php');
 
-$base_message = "I just wanted to take a second and follow up with your visit to md-petition.com and see if you needed anything, or had any questions.";
+$base_message = "I just wanted to take a second and follow up with your visit to md-petition.com and
+see if you needed anything or had any questions? You should have received an
+alert 'Petition Signed' when you finished signing the petition and had the option to print a signed copy.
+If you did not receive the alert and would like help, let me know. The invite link is below to try again.";
 
 // USAGE meps_mail('Patrick <baltimorehacker@gmail.com>','','Petition Follow-Up');
 
@@ -9,36 +12,35 @@ $q="SELECT * FROM follow_up where status = 'NEW'";
 $r = $petition->query($q);
 while($d = mysqli_fetch_array($r)){
   $name = $d['name'];
-  $email = $d['email'];
-  
+  $email = $d['email']; 
   $q2 = "SELECT * FROM presign where php_session_id = '$d[php_session]'";
   $r2 = $petition->query($q2);
-  $presign = mysqli_fetch_array($r2);
-  
+  $presign = mysqli_fetch_array($r2);  
   $visit = $presign['action_on'];
-  
-  $q2 = "SELECT * FROM petitions where petition_id = '$d[petition_id]'";
-  $r2 = $petition->query($q2);
-  $petitions = mysqli_fetch_array($r2);
-  
-  $petition_name = $petitions['petition_name'];
-  $landing_page = $petitions['landing_page'];
-  $web_short_name   = $petitions['web_short_name'];
-  
-  $link = 'https://www.md-petition.com/?invite='.$web_short_name;
-  if ($landing_page != ''){
-    $link = 'https://www.md-petition.com/'.$landing_page;
+  $invite='';
+  $petition_name='Maryland';
+  if($d['petition_id'] != '0'){
+    $q2 = "SELECT * FROM petitions where petition_id = '$d[petition_id]'";
+    $r2 = $petition->query($q2);
+    $petitions = mysqli_fetch_array($r2);
+    $petition_name = $petitions['petition_name'];
+    $landing_page = $petitions['landing_page'];
+    $web_short_name   = $petitions['web_short_name'];
+    $link = 'https://www.md-petition.com/?invite='.$web_short_name;
+    if ($landing_page != ''){
+      $link = 'https://www.md-petition.com/'.$landing_page;
+    }
+    $invite = "<br><br>Petition: $petition_name at <a href='$link'>$link</a>";
   }
-  
-  $invite = "<br><br>Petition: $petition_name at <a href='$link'>$link</a>";
-  $last = "<br><br>Follow up was requested at $visit";
-  $body = $base_message.$invite.$last;
-  $subject = "$petition_name Petition Follow-Up";
-  $to = "$name <$email>";
+  $last             = "<br><br>Follow up was requested at $visit";
+  $body             = $base_message.$invite.$last;
+  $subject          = "$petition_name Petition Follow-Up";
+  $to               = "$name <$email>";
   $feedback_message = "TO: $to SUB: $subject MSG: $body sent on ".date('r')." by ".$_COOKIE['name'];
-  meps_mail($to,$body,$subject);
+  $response         = meps_mail($to,$body,$subject);
   $feedback_message = $petition->real_escape_string($feedback_message);
-  $petition->query("update follow_up set status = 'sent', feedback_message = '$feedback_message' where id = '$d[id]'  ");
+  $response         = $petition->real_escape_string($response);
+  $petition->query("update follow_up set status = 'sent', feedback_message = '$feedback_message', system_response='$response' where id = '$d[id]'  ");
 }
-
+header('Location: /admin/follow_up_success.php');
 ?>