<?php
//ics includes
require_once('../../../_common/icalendar-master/zapcallib.php');
require_once('../../../_common/icalendar-master/MakeIcs.inc');
require_once('../../../_common/_uti/BstEmail.inc');
/***************************************** BEGIN SEND CODEBLOCK *****************************************************/

// if we're printing, show the work order inline.
if($var_Method == "preview")
{
    $pdf->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] .= "<br>".$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 "<br>Email: $var_To";
    if ($var_Cc) echo "<br>CC: $var_Cc";

    echo "<br>Company: $var_SubCompanyName";
    echo "<br>Message: $var_EmailMessage";

    if(!$var_Success)
    {
        echo "<br>Status: Send Error<br>";
    }
    else
    {
        echo "<br>Status: Send Email to $var_To - $var_Success<br>";

        //***********************************************
        $esc_SubCompanyName = mysqli_escape_string($dblink,$var_SubCompanyName);
        $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',
                    '$esc_SubCompanyName',
                    '$var_Today',
                    '$var_Now',
                    '$var_To',
                    '$var_Success',
                    '$var_FromName',
                    '$var_SubCompanyID',
                    'Work Order - Email')";
            //echo "<br />$PushSentItem_sql<br />";
            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 "<br>Fax: $var_ToFax";
    //if ($var_Cc) echo "<br>CC: $var_Cc";

    echo "<br>Company: $var_SubCompanyName";
    echo "<br>Message: $var_FaxMessage";

    if(!$var_Success)
    {
        echo "<br>Status: Send Error<br>";
    }
    else
    {
        echo "<br>Status: Send Fax to $var_To - $var_ToFax - $var_Success<br>";
        //***********************************************
        $esc_SubCompanyName = mysqli_escape_string($dblink,$var_SubCompanyName);
        $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',
                    '$esc_SubCompanyName',
                    '$var_Today',
                    '$var_Now',
                    '$var_To',
                    'fax',
                    '$var_ToFax',
                    '$var_FromName',
                    '$var_SubCompanyID',
                    'Work Order - Fax')";
            //echo "<br />$PushSentItem_sql<br />";
            mysqli_query($dblink,$PushSentItem_sql);
        }
    }
}
/***************************************** END SEND CODEBLOCK *****************************************************/
?>