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 *****************************************************/
?>