$pdf_file = "mpdf/pdfs/sub_contractor_report.pdf"; @unlink($pdf_file); @shell_exec("rm -rf " . $pdf_file); $emailBody_pdf = str_replace("<img src='{$host_url}", "<img src='", str_replace("<img src='{$host_url}/", "<img src='", str_replace("<img src=\"{$host_url}/", "<img src=\"", $email_message))); preg_match_all("/<img src=[\"\\'](.*?)[\"\\']/i", $emailBody_pdf, $array); for ($i = 0; $i < count($array[1]); $i++) { if (!file_exists($array[1][$i])) { $emailBody_pdf = str_replace($array[1][$i], "", $emailBody_pdf); } } $mpdf = new mPDF('c'); $mpdf->WriteHTML($emailBody_pdf); $mpdf->Output($pdf_file); $subject = "Subcontractor Reports for " . date("m/d/Y", time() - 3600); $attachMailer = new attach_mailer("Paxis Group", "*****@*****.**", $companyAdminEmails, $cc = "", $bcc = "*****@*****.**", $subject, $email_message); if (file_exists($pdf_file)) { $attachMailer->create_attachment_part($pdf_file, "attachment", "application/pdf"); } $attachMailer->process_mail(); //mail($companyAdminEmails,"Subcontractor Reports for ".date("m/d/Y",time()-3600),$email_message,$array_emails[$i]['headers']) or die("Error: There was an error sending mails"); //@mail("*****@*****.**","Subcontractor Reports for " . date("m/d/Y",time()-3600),$email_message,$array_emails[0]['headers']) or die("Error: There was an error sending mails"); } $query = "UPDATE subcontractor_emails SET sent = 1"; $subcontractor_emails_obj->customExecuteQuery($query); $query = "SELECT COUNT(*) AS count_emails FROM subcontractor_emails WHERE sent = 1"; $array_sub_contractor_emails = $subcontractor_emails_obj->customFetchQuery($query); if ($array_sub_contractor_emails[0]['count_emails'] > 3000) { $query = "DELETE FROM subcontractor_emails WHERE sent = 1"; $subcontractor_emails_obj->customExecuteQuery($query); } print "Emails successfully sent";
public function sendEmailReport($propertyEmails, $propertyName, $propertyAddress, $propertyStatus, $propertyCommunity, $propertyType, $propertyJobType, $generalComments, $reportId, $mysqli) { $mailto = $propertyEmails; $mailSubject = 'Report for ' . $propertyCommunity . ", " . $propertyName; $host_url = "http://" . $_SERVER['HTTP_HOST'] . rtrim(dirname(dirname($_SERVER['PHP_SELF'])), '/\\'); $replace_title = "<a href='" . $host_url . "/view_report.html?reportId=" . $reportId . "'>" . $mailSubject . "</a>"; $searchArray = array('__PROPERTYCOMMUNITY__', '__PROPERTYNAME__', '__PROPERTYTYPE__', '__PROPERTYJOBTYPE__', '__ADDRESS__', '__REPORTDATE__', '__STATUS__', '__REPORTEDBY__', '__ROOMS__', '__GENERALCOMMENTS__'); $replaceArray = array($propertyCommunity, $propertyName, $propertyType, $propertyJobType, $propertyAddress, date('m/d/Y g:ia'), $propertyStatus == 1 ? 'Open' : 'Closed/Archived', $_SESSION['user_firstname'] . ' ' . $_SESSION['user_lastname'], $this->roomsEmailBody, $generalComments); $emailBody = file_get_contents(dirname(dirname(__FILE__)) . '/email_template/report.tpl'); $emailBody = str_replace($searchArray, $replaceArray, $emailBody); $emailBody = str_replace($mailSubject, $replace_title, $emailBody); $host_url = "http://" . $_SERVER['HTTP_HOST'] . rtrim(dirname(dirname($_SERVER['PHP_SELF'])), '/\\'); $emailBody = str_replace('__HOST__', $host_url, $emailBody); $pdf_file = "../mpdf/pdfs/report.pdf"; @unlink($pdf_file); @shell_exec("rm -rf " . $pdf_file); $emailBody_pdf = str_replace("<img src='{$host_url}", "<img src='..", str_replace("<img src=\"{$host_url}", "<img src=\"..", $emailBody)); preg_match_all("/<img src=[\"\\'](.*?)[\"\\']/i", $emailBody_pdf, $array); for ($i = 0; $i < count($array[1]); $i++) { if (!file_exists($array[1][$i])) { $emailBody_pdf = str_replace($array[1][$i], "", $emailBody_pdf); } } $mpdf = new mPDF('c'); $mpdf->WriteHTML($emailBody_pdf); $mpdf->Output($pdf_file); $mailHeaders = "From: Paxis Group <*****@*****.**> \r\n"; $mailHeaders .= "Reply-To: Paxis Group <*****@*****.**>\r\n"; $mailHeaders .= "Return-Path: Paxis Group <*****@*****.**>\r\n"; $mailHeaders .= "Bcc: Wendell Malpas <*****@*****.**>\r\n"; $mailHeaders .= "X-Mailer: PHP v" . phpversion() . "\r\n"; $mailHeaders .= "MIME-Version: 1.0\r\n"; $mailHeaders .= "Content-Type: text/html; charset=utf-8"; if ($_SESSION['user_type'] == 5) { $insertSubContractorSql = "INSERT INTO subcontractor_emails(emailAddress, subject, emailBody, headers, sent, timestamp) VALUES(?, ?, ?, ?, 0, NOW())"; if ($insertSubContractorStmt = $mysqli->prepare($insertSubContractorSql)) { $insertSubContractorStmt->bind_param("ssss", $mailto, $mailSubject, $emailBody, $mailHeaders); if ($insertSubContractorStmt->execute()) { return true; } else { return false; } } } else { $attachMailer = new attach_mailer("Paxis Group", "*****@*****.**", $mailto, $cc = "", $bcc = "*****@*****.**", $mailSubject, $emailBody); if (file_exists($pdf_file)) { $attachMailer->create_attachment_part($pdf_file, "attachment", "application/pdf"); } return $attachMailer->process_mail(); //return mail($mailto, $mailSubject, $emailBody, $mailHeaders); } }