function emailInvoice($invoice_type_id, $invoiceid, $user_id)
{
global $wpdb;
require_once ABSPATH . 'wp-content/themes/CSTEM/PHPMailer-master/class.phpmailer.php';
$form_type = $wpdb->get_var($wpdb->prepare("SELECT form_type FROM wp_invoice_type WHERE invoice_type_id = %d", $invoice_type_id));
$form_name = $wpdb->get_var($wpdb->prepare("SELECT invoice_name FROM wp_invoice_type WHERE invoice_type_id = %d", $invoice_type_id));
$user_info = get_userdata($user_id);
$to = $user_info->user_email;
// user's email or that of first email if submitting for others
$recipients = get_recipients_list($form_type, $invoice_type_id, $invoiceid);
// get recipients (CC Addresses)
$email_contents = get_email_contents($form_type, $invoice_type_id, $invoiceid, $user_id);
// get subject & body
$subject = $email_contents["subject"];
$message = $email_contents["message"];
// message lines should not exceed 70 characters (PHP rule), so wrap it
$message = wordwrap($message, 70);
// Email object
$email = new PHPMailer();
$email->isHTML(true);
// allows for email formatting
$email->CharSet = "UTF-8";
// allows for special character display
switch ($invoice_type_id) {
case 8:
//Student Application
$email->From = "*****@*****.**";
$email->FromName = "C-STEM Center";
$location_name = $wpdb->get_var($wpdb->prepare("SELECT field_value FROM `wp_invoice_data` WHERE invoice_no = %d AND field_name = 'location'", $invoiceid));
if (strcmp($location_name, "Valley View, Pleasant Hill, CA") == 0) {
$email->AddBCC("hawess@mdusd.org ", "Shauna Hawes");
//$email->AddBCC("*****@*****.**", "Shauna Hawes");
}
//If the student will be participating in Valley View, Pleasant Hill, BCC the email to Shauna Hawes
break;
case 9:
//Assistant Coach Application
$email->From = "*****@*****.**";
$email->FromName = "C-STEM Center";
$location_name = $wpdb->get_var($wpdb->prepare("SELECT field_value FROM `wp_invoice_data` WHERE invoice_no = %d AND field_name = 'location'", $invoiceid));
if (strcmp($location_name, 'Valley View, Pleasant Hill, CA') == 0) {
//$email->AddBCC("*****@*****.**", "Shauna Hawes");
$email->AddBCC("hawess@mdusd.org ", "Shauna Hawes");
}
//If the student will be participating in Valley View, Pleasant Hill, BCC the email to Shauna Hawes break;
break;
case 18:
//Coach Application
$email->From = "*****@*****.**";
$email->FromName = "C-STEM Center";
$location_name = $wpdb->get_var($wpdb->prepare("SELECT field_value FROM `wp_invoice_data` WHERE invoice_no = %d AND field_name = 'location'", $invoiceid));
if (strcmp($location_name, 'Valley View, Pleasant Hill, CA') == 0) {
$email->AddBCC("hawess@mdusd.org ", "Shauna Hawes");
}
//If the student will be participating in Valley View, Pleasant Hill, BCC the email to Shauna Hawes
break;
case 17:
//Order Review Copies
$email->From = "*****@*****.**";
$email->FromName = "C-STEM Center";
$to = $wpdb->get_var($wpdb->prepare("SELECT `field_value` FROM `wp_invoice_data` WHERE `invoice_no` = %d AND `field_name` = 'email_address'", $invoiceid));
break;
case 13:
// Tech Support
$email->From = "*****@*****.**";
$email->FromName = "C-STEM Tech Support";
break;
default:
$email->From = "*****@*****.**";
$email->FromName = "C-STEM Center";
break;
}
// switch: From
$email->Subject = $subject;
$email->Body = $message;
$email->AddAddress($to);
foreach ($recipients as $mail => $name) {
$email->AddBCC($mail);
}
$form_name = str_replace(' ', '_', $form_name);
$file_name = $form_name . '_' . $invoiceid . '.pdf';
/* // add attachments
switch($invoice_type_id) {
case 8: // Girl Camp
$invoice_file = 'Application_' . $invoiceid . '.pdf';
break;
case 13: // Tech Support
$invoice_file = 'Support_' . $invoiceid . '.pdf';
break;
default:
$invoice_file = 'Quote_' . $invoiceid . '.pdf';
break;
} // switch: attachment file name*/
switch ($invoice_type_id) {
case 9:
// Girl Camp Assistant Coach
$rec_file = '2015TeacherRecForm(fillable).pdf';
$rec_file_attachment = 'wp-content/invoices_files/' . $rec_file;
$email->AddAttachment($rec_file_attachment, $rec_file);
break;
case 10:
//C-STEM Awards
$rec_file = 'CSTEMAwardApplicationForm.pdf';
$rec_file_attachment = 'wp-content/invoice_files/' . $rec_file;
$email->AddAttachment($rec_file_attachment, $rec_file);
break;
case 18:
//Coach application
$rec_file = '2015TeacherRecForm(fillable).pdf';
$rec_file_attachment = 'wp-content/invoice_files/' . $rec_file;
$email->AddAttachment($rec_file_attachment, $rec_file);
break;
}
//$file_to_attach = 'wp-content/plugins/contact-form-7/html2pdf/' . $file_name;
$file_to_attach = '/var/www/wordpress/wp-content/invoice_files/' . $file_name;
if ($invoice_type_id != 10) {
$email->AddAttachment($file_to_attach, $file_name);
}
$email->Send();
}
function emailInvoice($invoice_type_id, $invoiceid, $user_id)
{
global $wpdb;
require_once ABSPATH . 'wp-content/themes/CSTEM/PHPMailer-master/class.phpmailer.php';
$form_type = $wpdb->get_var($wpdb->prepare("SELECT form_type FROM wp_invoice_type WHERE invoice_type_id = %d", $invoice_type_id));
$form_name = $wpdb->get_var($wpdb->prepare("SELECT invoice_name FROM wp_invoice_type WHERE invoice_type_id = %d", $invoice_type_id));
$user_info = get_userdata($user_id);
$to = $user_info->user_email;
// user's email or that of first email if submitting for others
$recipients = get_recipients_list($form_type, $invoice_type_id, $invoiceid);
// get recipients (CC Addresses)
$email_contents = get_email_contents($form_type, $invoice_type_id, $invoiceid, $user_id);
// get subject & body
$subject = $email_contents["subject"];
$message = $email_contents["message"];
// message lines should not exceed 70 characters (PHP rule), so wrap it
$message = wordwrap($message, 70);
// Email object
$email = new PHPMailer();
$email->isHTML(true);
// allows for email formatting
$email->CharSet = "UTF-8";
// allows for special character display
switch ($invoice_type_id) {
case 13:
// Tech Support
$email->From = "*****@*****.**";
$email->FromName = "C-STEM Tech Support";
break;
default:
$email->From = "*****@*****.**";
$email->FromName = "C-STEM Center";
break;
}
// switch: From
$email->Subject = $subject;
$email->Body = $message;
$email->AddAddress($to);
foreach ($recipients as $mail => $name) {
$email->AddBCC($mail);
}
$form_name = str_replace(' ', '_', $form_name);
$file_name = $form_name . '_' . $invoiceid . '.pdf';
/* // add attachments
switch($invoice_type_id) {
case 8: // Girl Camp
$invoice_file = 'Application_' . $invoiceid . '.pdf';
break;
case 13: // Tech Support
$invoice_file = 'Support_' . $invoiceid . '.pdf';
break;
default:
$invoice_file = 'Quote_' . $invoiceid . '.pdf';
break;
} // switch: attachment file name*/
switch ($invoice_type_id) {
case 8:
// Girl Camp
$rec_file = 'Teacher_Rec.pdf';
$rec_file_attachment = 'wp-content/invoice_files/' . $rec_file;
$email->AddAttachment($rec_file_attachment, $rec_file);
break;
}
$file_to_attach = 'wp-content/invoice_files/' . $file_name;
if ($invoice_type_id != 10) {
$email->AddAttachment($file_to_attach, $file_name);
}
$email->Send();
}
