<?php
ob_start();
/**
 * Created by PhpStorm.
 * User: SERVER
 * Date: 06/02/2016
 * Time: 3:29 PM
 */
session_start();
extract($_POST);
if(isset($supervisor)){
    $_SESSION['supervisor']=$supervisor;
    $_SESSION['compName']=$compName;
}else{
    $supervisor=$_SESSION['supervisor'];
    $compName=$_SESSION['compName'];
}
$dat=date('l, M d, o, h:i:s a');
$dateNow=date('d/ m/ y');
$matNo=$_SESSION['matNo'];
require_once('../../connect.php');
$db=db_connect();



//echo $supervisor;
//echo '<br>'.$compName;
$sql3=$db->query("select * from siwesbiodata where placementName='$supervisor' and companyName='$compName'");
 $num=$sql3->rowCount();

$sql31=$db->query("select * from siwesbiodata where placementName='$supervisor' and companyName='$compName'");

 $sql31_fetch=$sql31->fetch(PDO::FETCH_BOTH);
$address=$sql31_fetch['eAddress'];

$mainBody=
'
     <h2 align="center"> <u>INDUSTRIAL TRAINING FUND
     <BR>STUDENTS COMMENCEMENT ATTACHEMENT FORM (SCAF)</u></h2>

     <div style="text-align: right">Appendix A1</div>
     <table>
        <tr>
     <td><strong>INSTITUTION: </strong></td><td>FEDERAL POLYTECHNIC EDE, OSUN STATE</td><td></td><td><strong>To: </strong>The Area Manager</td>
</tr>

   <tr>
     <td><strong>FROM:</strong></td><td>'.$compName.'</td><td></td><td><strong>ITF: </strong>..........................Area Office</td>
</tr>
 <tr>
     <td><strong>LOCATION ADDRESS:</strong></td><td> '.$address.'</td>
</tr>
</table>
<p></p>
<table border="1" cellspacing="0" align="center">
<tr><th>S/N</th><th>NAME OF STUDNETS</th><th>MATRIC NO</th><th>COURSE OF STUDY</th><th>PERIOD OF ATTACHMENT IN MONTHS</th><th>DATE OF COMMENCEMENT</th><th>DATE OF COMPLETION</th><th>REMARK</th></tr>
';
$i=1;
while($row=$sql3->fetch(PDO::FETCH_BOTH)){
   echo $matNo=$row['matNo'];


    $mainBody.= '<tr><td>'.$i.'</td><td>';

    $sql=$db->query("select * from realdata where matNo='$matNo'");
    $sql_fetch=$sql->fetch(PDO::FETCH_BOTH);

    $mainBody.= $sql_fetch['names'].'</td><td>'.$row['matNo'].'</td><td>'.$sql_fetch['course'].'</td><td align="center">'.dateDifferenceD($row['toYear'],$row['fromYear'],"%m").'</td><td align="center">'.$row['fromYear'].'</td><td align="center">'.$row['toYear'].'</td><td></td>';
    $i++;
}
$mainBody.='</tr></table>
<p></p>
<div>
    <div><strong> Name of Institutions\' SIWES Coordinator:</strong> Engr. Dr. J. O. Petinrin</div>
    <br>
    <div><strong>Designation: </strong></div>
    <br>
    <div><strong>Stamp/Signature/Date: </strong><div>
</div>

    ';
//echo $mainBody;

$dat=date('l, M d, o, h:i:s a');
//$customizedFooter='<img src="../../images/siwesfooter.png"><br><div align="right">'. $dat.'</div>';

include("../../mpdf/mpdf.php");
//$form8=new mPDF('c');
$form8=new mPDF('c');
$form8->AddPage('L','','','','',10,10,10,10,10,10);;

$form8->WriteHTML($mainBody);
//$mpdf->setFooter($customizedFooter) ;
$form8->Output();
exit;


function dateDifferenceM($date_1 , $date_2 , $differenceFormat = '%i' )
{
    $datetime1 = date_create($date_1);
    $datetime2 = date_create($date_2);

    $interval = date_diff($datetime1, $datetime2);

    return $interval->format($differenceFormat);

}
function dateDifferenceD($date_1 , $date_2 , $differenceFormat = '%a' )
{
    $datetime1 = date_create($date_1);
    $datetime2 = date_create($date_2);

    $interval = date_diff($datetime1, $datetime2);

    return $interval->format($differenceFormat);

}

ob_end_flush();
?>