$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";
Ejemplo n.º 2
0
 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);
     }
 }