admin/follow_up_emails.php

   1 <?PHP
   2 include_once('../email.php');
   3 include_once('../slack.php');
   4 $base_message = "I just wanted to take a second and follow up with your visit to md-petition.com and
   5 see if you needed anything or had any questions? You should have received an
   6 alert 'Petition Signed' when you finished signing the petition and had the option to print a signed copy.
   7 If you did not receive the alert and would like help, let me know. The invite link is below to try again.";
   8
   9 // USAGE meps_mail('Patrick <baltimorehacker@gmail.com>','','Petition Follow-Up');
  10
  11 $q="SELECT * FROM follow_up where status = 'NEW'";
  12 $r = $petition->query($q);
  13 while($d = mysqli_fetch_array($r)){
  14   $name = $d['name'];
  15   $email = $d['email'];
  16   $q2 = "SELECT * FROM presign where php_session_id = '$d[php_session]'";
  17   $r2 = $petition->query($q2);
  18   $presign = mysqli_fetch_array($r2);
  19   $visit = $presign['action_on'];
  20   $invite='';
  21   $petition_name='Maryland';
  22   if($d['petition_id'] != '0'){
  23     $q2 = "SELECT * FROM petitions where petition_id = '$d[petition_id]'";
  24     $r2 = $petition->query($q2);
  25     $petitions = mysqli_fetch_array($r2);
  26     $petition_name = $petitions['petition_name'];
  27     $landing_page = $petitions['landing_page'];
  28     $web_short_name   = $petitions['web_short_name'];
  29     $link = 'https://www.md-petition.com/?invite='.$web_short_name;
  30     if ($landing_page != ''){
  31       $link = 'https://www.md-petition.com/'.$landing_page;
  32     }
  33     $invite = "<br><br>Petition: $petition_name at <a href='$link'>$link</a>";
  34   }
  35   $last             = "<br><br>Follow up was requested at $visit";
  36   $body             = $base_message.$invite.$last;
  37   $subject          = "$petition_name Petition Follow-Up";
  38   $to               = "$name <$email>";
  39   $feedback_message = "TO: $to SUB: $subject MSG: $body sent on ".date('r')." by ".$_COOKIE['name'];
  40   $response         = meps_mail($to,$body,$subject);
  41   $feedback_message = $petition->real_escape_string($feedback_message);
  42   $response         = $petition->real_escape_string($response);
  43   $petition->query("update follow_up set status = 'sent', feedback_message = '$feedback_message', system_response='$response' where id = '$d[id]'  ");
  44   slack_general('Sending Follow Up Email to '.$to,'automation');
  45 }
  46 header('Location: /admin/follow_up_success.php');
  47 ?>