Output('../_builder/WorkOrder.pdf', 'I'); } // handle emailing. if($var_Method == "email" && $var_SendToEmailAddress) { // output work order as a file for email attachment. //$pdf->Output('../_builder/WorkOrder.pdf', 'F'); //tcpdf626 requires full path $var_OutputFile = '_builder/WorkOrder.pdf'; $var_OutputPath = $var_WOUploadDir.$var_OutputFile; $pdf->Output($var_OutputPath,'F'); // sendmail function expects filenames to be in an array, so let's keep it happy. $arr_PDF = array(); $arr_PDF[0] = "../_builder/WorkOrder.pdf"; // set up the from fields $GetUserEmailAddress_sql = " select col_EmailAddress, col_UsersName from tb_Users where col_UserID = '$var_User' "; // echo $GetUserEmailAddress_sql; $GetUserEmailAddress_myrow = mysqli_fetch_array(mysqli_query($dblink,$GetUserEmailAddress_sql)); $var_From = $GetUserEmailAddress_myrow['col_EmailAddress']; $var_FromName = $GetUserEmailAddress_myrow['col_UsersName']; $var_To = $var_SendToEmailAddress; $var_Subject = "Work order Re: $var_Centre - $var_Phase - $var_Lot - $var_SubCompanyName"; $var_Success = SendMailVince($var_From,$var_FromName,$var_To,'',$var_Subject,$var_EmailMessage,$var_EmailMessage,$arr_PDF); // $var_Success=1; echo "
Email: $var_To"; echo "
Company: $var_SubCompanyName"; echo "
Message: $var_EmailMessage"; if(!$var_Success) echo "
Status: Send Error
var_From $var_From
var_FromName $var_FromName
var_To $var_To
var_Subject $var_Subject
var_EmailMessage $var_EmailMessage
var_EmailMessage $var_EmailMessage
"; else { echo "
Status: Send Successful
"; //*********************************************** $var_Today = date("Y-m-d"); $var_Now = date("H:i"); // push send to tb_SentItem, one for each deficiency assignment id foreach($arr_DeficiencyAssignmentIDs as $DefAssID) { $PushSentItem_sql = " insert into tb_SentItem ( col_DeficiencyAssignmentID, col_CompanyName, col_PostDate, col_PostTime, col_Email, col_UserName, col_ListCompanyID, col_Type ) values ( '$DefAssID', '$var_SubCompanyName', '$var_Today', '$var_Now', '$var_To', '$var_FromName', '$var_SubCompanyID', 'Work Order - Email' ) "; // echo "
$PushSentItem_sql
"; mysqli_query($dblink,$PushSentItem_sql); } } } // handle faxing. if($var_Method == "fax") { // output work order as a file for email attachment. //$pdf->Output('../_builder/WorkOrder.pdf', 'F'); //tcpdf626 requires full path $var_OutputFile = '_builder/WorkOrder.pdf'; $var_OutputPath = $var_WOUploadDir.$var_OutputFile; $pdf->Output($var_OutputPath,'F'); // sendmail function expects filenames to be in an array, so let's keep it happy. $arr_PDF = array(); $arr_PDF[0] = "../_builder/WorkOrder.pdf"; // set up the from fields $GetUserEmailAddress_sql = " select col_EmailAddress, col_UsersName from tb_Users where col_UserID = '$var_User' "; // echo $GetUserEmailAddress_sql; $GetUserEmailAddress_myrow = mysqli_fetch_array(mysqli_query($dblink,$GetUserEmailAddress_sql)); $var_From = $GetUserEmailAddress_myrow['col_EmailAddress']; $var_FromName = $GetUserEmailAddress_myrow['col_UsersName']; $var_To = $ThisCompanyEmailToFax; //$var_WOFaxPrefix = ""; //remove the 1+ prefix for testing $var_ToFax = $var_WOFaxPrefix.$var_SendToFaxAddress; $var_Subject = "Work order Re: $var_Centre - $var_Phase - $var_Lot - $var_SubCompanyName"; $arr_UserName = array(); $arr_UserName = explode(" ", $var_FromName); // $var_FaxMessage = "::"."1".$var_ToFax."\n".$var_FaxMessage; $var_SendMessage = "::".$arr_UserName[0].", ".$ThisCompanyName.", ".$arr_UserName[1].",,, ".$var_ToFax."\n".$var_FaxMessage; // echo $var_SendMessage; $var_Success = SendMailPDF($var_From,$var_FromName,$var_To,'',$var_Subject,$var_SendMessage,NULL,$arr_PDF); // $var_Success=1; echo "
Fax: $var_ToFax"; echo "
Company: $var_SubCompanyName"; echo "
Message: $var_FaxMessage"; if(!$var_Success) echo "
Status: Send Error
"; else { echo "
Status: Send Successful
"; //*********************************************** $var_Today = date("Y-m-d"); $var_Now = date("H:i"); // push send to tb_SentItem, one for each deficiency assignment id foreach($arr_DeficiencyAssignmentIDs as $DefAssID) { $PushSentItem_sql = " insert into tb_SentItem ( col_DeficiencyAssignmentID, col_CompanyName, col_PostDate, col_PostTime, col_Email, col_Fax, col_UserName, col_ListCompanyID, col_Type ) values ( '$DefAssID', '$var_SubCompanyName', '$var_Today', '$var_Now', '$var_To', '$var_ToFax', '$var_FromName', '$var_SubCompanyID', 'Work Order - Fax' ) "; // echo "
$PushSentItem_sql
"; mysqli_query($dblink,$PushSentItem_sql); } } } /***************************************** END SEND CODEBLOCK *****************************************************/ ?>