GA4

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

<?PHP
include_once('../email.php');
include_once('../slack.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? 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');

$q="SELECT * FROM follow_up where status = 'NEW'";
$r = $petition->query($q);
while($d = mysqli_fetch_array($r)){
  $name = $d['name'];
  $email = $d['email']; 
  $q2 = "SELECT * FROM presign where php_session_id = '$d[php_session]'";
  $r2 = $petition->query($q2);
  $presign = mysqli_fetch_array($r2);  
  $visit = $presign['action_on'];
  $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>";
  }
  $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'];
  $response         = meps_mail($to,$body,$subject);
  $feedback_message = $petition->real_escape_string($feedback_message);
  $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]'  ");
  slack_general('Sending Follow Up Email to '.$to,'automation');
}
header('Location: /admin/follow_up_success.php');
?>