<?php require_once "../include/phpmailer/class.phpmailer.php"; require_once "../include/mail_utils.php"; $mail = getSocksMailer(); $mail->Subject = "TEST Litesprite Reminder"; $mail->Body = "this is a test"; $mail->AddAddress('*****@*****.**'); sendMail($mail);
function sendFinalEmails($email, $client_key, $final1, $final2, $final3) { //echo "<br>final: ".$email; //GET CLIENT KEY //find device email and device type $sql = "call getDeviceInfo(" . sql_escape_string($email, 1) . ")"; $Result = execute_query($mysqli, $sql); if ($Result) { $row = $Result[0]->fetch_assoc(); $device_email = $row['email']; $device = $row['device']; $fname = $row['fname']; $lname = $row['lname']; //send to Socks $sMail = getSocksMailer(); $sMail->Subject = "Litesprite User Completed Onboarding"; $sMail->Body = "client key: " . $client_key . "<br>\n\t\t\t\t\t\tCodes and Instructions have been sent to: " . $email . "<br> \n\t\t\t\t\t\tDevice: " . ($device == 'A' ? 'Android' : 'iOS') . "<br> \n\t\t\t\t\t\tDevice email: " . $device_email . "<br>\n\t\t\t\t\t\tLast name: " . $lname . "<br>\n\t\t\t\t\t\tFirst name:" . $fname; $sMail->AddAddress("*****@*****.**"); sendMail($sMail); //send to User $uMail = getSocksMailer(); $uMail->Subject = "Litesprite Beta Sign-Up Completed!"; $uMail->AddEmbeddedImage('../images/paw.png', 'paw'); $uMail->Body = $final1 . $client_key . $final2 . $device_email . $final3; $uMail->AddAddress($email); sendMail($uMail); } }
function sendFinalEmails($email, $client_key, $final1, $final2, $final3, $final4) { //echo 'final email '.$email.' '.$client_key.'<br>'; //find device email and device type $sql = "call getDeviceInfo(" . sql_escape_string($email, 1) . ");"; echo $sql; $Result = execute_query($mysqli, $sql); if ($Result) { $row = $Result[0]->fetch_assoc(); $device_email = $row['email']; $device = $row['device']; $fname = $row['fname']; $lname = $row['lname']; $gSQL = 'CALL getOrgByKey(' . sql_escape_string($client_key, 1) . ');'; //echo $gSQL; //echo '<br>'; $gResult = execute_query($mysqli, $gSQL); $group_code = $gResult[0]->fetch_array()[0]; //echo $group_code; //echo '<br>'; //send to Socks $sMail = getSocksMailer(); $sMail->Subject = "Litesprite User Completed Onboarding"; $sMail->Body = "client key: " . $client_key . "<br>\n\t\t\t\t\t\tgroup: " . $group_code . "<br>\n\t\t\t\t\t\tCodes and Instructions have been sent to: " . $email . "<br> \n\t\t\t\t\t\tDevice: " . ($device == 'A' ? 'Android' : 'iOS') . "<br> \n\t\t\t\t\t\tDevice email: " . $device_email . "<br>\n\t\t\t\t\t\tLast name: " . $lname . "<br>\n\t\t\t\t\t\tFirst name:" . $fname; //echo $sMail->Body; //echo '<br>'; $sMail->AddAddress("*****@*****.**"); sendMail($sMail); //send to User $uMail = getSocksMailer(); $uMail->Subject = "Litesprite Beta Sign-Up Completed!"; $uMail->AddEmbeddedImage('../images/paw.png', 'paw'); $uMail->Body = $final1 . $group_code . $final2 . $client_key . $final3 . $device_email . $final4; //echo $uMail->Body; $uMail->AddAddress($email); sendMail($uMail); } }
$nda_row = $ndas[0]->fetch_assoc(); } } //pull everyone from the db who hasn't completed survey $sql = "call getSurveyNotDoneTest();"; $surveys = execute_query($mysqli, $sql); //for ea if time since intial sign up > 2 days && < 3 days || time > 5 days < 6 days send reminder email if ($surveys) { $sur_row = $surveys[0]->fetch_assoc(); while ($sur_row) { $interval = time_diff($sur_row["time"], $now); $int_val = intval($interval->format('%a')); if ($int_val == 2 || $int_val == 5) { echo 'missing survey: ' . $sur_row['key'] . ', ' . $sur_row['email'] . ', ' . $sur_row['time'] . ", diff = " . $interval->format('%R%a days') . '<br>'; //send email sendReminder(getSocksMailer(), $sur_row['email'], 'survey', $key); } $sur_row = $surveys[0]->fetch_assoc(); } } function sendReminder($mail, $address, $type, $key) { $mail->AddAddress($address); if ($type == 'survey') { //add survey body } else { if ($type == 'nda') { //add nda body } } //$mail->SendMail();