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";
$arr_idx = 0;
//create appointment calander events ics
$location = $var_Lot.' - '.$var_MunAddress;
asort($arr_DeficiencyAptDateTime);
$arr_DAID = array();
$arr_TIME = array();
$arr_SUMM = array();
$arr_DESC = array();
$arr_LOCA = array();
$arr_cnt = 0;
//process each event
foreach ($arr_DeficiencyAptDateTime as $key => $value)
{
if ($value)
{
if ($arr_cnt)
$tmp_idxx = array_search($value,$arr_TIME);
else
$tmp_idxx = FALSE;
if ($tmp_idxx===FALSE)
{
$arr_TIME[$arr_cnt] = $arr_DeficiencyAptDateTime[$key];
$arr_TEND[$arr_cnt] = $arr_DeficiencyAptDateTend[$key];
$arr_DAID[$arr_cnt] = $arr_DeficiencyAssignmentIDs[$key];
$arr_SUMM[$arr_cnt] = $arr_DeficiencyGroupRoom[$key];
$arr_DESC[$arr_cnt] = $arr_DeficiencyGroupRoom[$key].' '.$arr_DeficiencyIssues[$key].' '.$arr_DeficiencyNotes[$key];
$arr_cnt++;
}
else
{
$arr_DESC[$tmp_idxx] .= "
".$arr_DeficiencyGroupRoom[$key].' '.$arr_DeficiencyIssues[$key].' '.$arr_DeficiencyNotes[$key];
$arr_TEND[$tmp_idxx] = ($arr_DeficiencyAptDateTend[$key]>$arr_TEND[$tmp_idxx])? $arr_DeficiencyAptDateTend[$key] : $arr_TEND[$tmp_idxx];
}
}
}
//create event ics files
if ($arr_cnt && $var_SendIcsYN=='Yes')
foreach ($arr_TIME as $key => $value)
{
$arr_idx++;
$event = MakeIcs($value, $arr_TEND[$key], $arr_SUMM[$key], $arr_DESC[$key], $location);
$var_EventFileName = "../_builder/DAI".$arr_DAID[$key].".ics";
$var_file = fopen($var_EventFileName,'w') or die('Cannot open file for write $var_EventFileName');
fwrite($var_file,$event);
fclose($var_file);
$arr_PDF[$arr_idx] = $var_EventFileName;
}
// set up the from fields
$GetUserEmailAddress_sql = "
SELECT tb_Users.col_EmailAddress,
tb_Users.col_UsersName,
tb_UsersSendMailCC.col_PASSSendWorkOrderCCYN
FROM tb_Users
LEFT JOIN tb_UsersSendMailCC
ON tb_Users.col_UserID = tb_UsersSendMailCC.col_UserID
WHERE tb_Users.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_PASSSendWorkOrderCCYN = $GetUserEmailAddress_myrow['col_PASSSendWorkOrderCCYN'];
if ($var_PASSSendWorkOrderCCYN=="Yes")
{
//send a copy to the user
$var_Cc = $var_From;
$var_CcName = $var_FromName;
}
else
{
$var_Cc = "";
$var_CcName = "";
}
$var_To = $var_SendToEmailAddress;
$var_ToName = "";
$var_ProjectCentre = ($var_ListByCentreOrProject=='Project')? $var_Project : $var_Centre;
$var_Subject = "Work order Re: $var_ProjectCentre - $var_Phase - $var_Lot - $var_SubCompanyName";
$var_Text = $var_EmailMessage?$var_EmailMessage:" ";
$var_Html = NULL;
//$var_Success = SendMailVince($var_From,$var_FromName,$var_To,'',$var_Subject,$var_EmailMessage,$var_EmailMessage,$arr_PDF);
$var_Success = SendMailBST($var_From,$var_FromName,$var_To,$var_ToName,$var_Cc,$var_CcName,$var_Subject,$var_Text,$var_Html,$arr_PDF);
//$var_Success=1;
echo "
Email: $var_To";
if ($var_Cc) echo "
CC: $var_Cc";
echo "
Company: $var_SubCompanyName";
echo "
Message: $var_EmailMessage";
if(!$var_Success)
{
echo "
Status: Send Error
";
}
else
{
echo "
Status: Send Email to $var_To - $var_Success
";
//***********************************************
$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_EmailStatus,
col_UserName,
col_ListCompanyID,
col_Type)
VALUES
('$DefAssID',
'$var_SubCompanyName',
'$var_Today',
'$var_Now',
'$var_To',
'$var_Success',
'$var_FromName',
'$var_SubCompanyID',
'Work Order - Email')";
//echo "
$PushSentItem_sql
";
mysqli_query($dblink,$PushSentItem_sql);
}
}
if ($arr_PDF)
foreach($arr_PDF as $str_PDF)
{
if (file_exists($str_PDF))
unlink($str_PDF);
}
}
// 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 tb_Users.col_EmailAddress,
tb_Users.col_UsersName,
tb_UsersSendMailCC.col_PASSSendWorkOrderCCYN
FROM tb_Users
LEFT JOIN tb_UsersSendMailCC
ON tb_Users.col_UserID = tb_UsersSendMailCC.col_UserID
WHERE tb_Users.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_PASSSendWorkOrderCCYN = $GetUserEmailAddress_myrow['col_PASSSendWorkOrderCCYN'];
if ($var_PASSSendWorkOrderCCYN=="Yes")
{
//send a copy to the user
$var_Cc = $var_From;
$var_CcName = $var_FromName;
}
else
{
$var_Cc = "";
$var_CcName = "";
}
//get the email address from header.inc
$var_To = $ThisCompanyEmailToFax;
$var_ToName = "";
$var_ToFax = $var_WOFaxPrefix.$var_SendToFaxAddress;
$var_ProjectCentre = ($var_ListByCentreOrProject=='Project')? $var_Project : $var_Centre;
$var_Subject = "Work order Re: $var_ProjectCentre - $var_Phase - $var_Lot - $var_SubCompanyName";
// $var_FaxMessage = "::"."1".$var_ToFax."\n".$var_FaxMessage;
$var_SendMessage = "::".$var_SubContact.",".$var_SubCompanyName.",,,,".$var_ToFax."\n".$var_FaxMessage;
$var_Html = NULL;
// echo $var_SendMessage;
//SendMailBST does not send to fax sender properly, so use SendMailPDF
//$var_Success = SendMailPDF($var_From,$var_FromName,$var_To,$var_ToName,$var_Subject,$var_SendMessage,NULL,$arr_PDF);
$var_Success = SendMailFax($var_From,$var_FromName,$var_To,$var_ToName,$var_Cc,$var_CcName,$var_Subject,$var_SendMessage,$var_Html,$arr_PDF);
// $var_Success=1;
echo "
Fax: $var_ToFax";
//if ($var_Cc) echo "
CC: $var_Cc";
echo "
Company: $var_SubCompanyName";
echo "
Message: $var_FaxMessage";
if(!$var_Success)
{
echo "
Status: Send Error
";
}
else
{
echo "
Status: Send Fax to $var_To - $var_ToFax - $var_Success
";
//***********************************************
$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_EmailStatus,
col_Fax,
col_UserName,
col_ListCompanyID,
col_Type)
VALUES
('$DefAssID',
'$var_SubCompanyName',
'$var_Today',
'$var_Now',
'$var_To',
'fax',
'$var_ToFax',
'$var_FromName',
'$var_SubCompanyID',
'Work Order - Fax')";
// echo "
$PushSentItem_sql
";
mysqli_query($dblink,$PushSentItem_sql);
}
}
}
/***************************************** END SEND CODEBLOCK *****************************************************/
?>