<?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=
'
     <h3 align="center"> <u>INDUSTRIAL TRAINING FUND
     <BR>PAYMENT OF STUDENTS ALLOWANCES THROUGH THE EMPLOYERE
     <BR>(TO BE COMPLETED BEFORE MONEY IS DEPOSITED WITH EMPLOYER)</u></h3>
     <div style="text-align: right">FORM SPE - 1</div>
     <table>
     <tr>
     <td>FROM: </td><td>'. $_SESSION['supervisor'].'</td><td>TO: </td><td>The Area Officer</td>
</tr>
   <tr>
     <td>NAME OF ORGANISATION:</td><td>'.$compName.'</td><td>ITF: </td><td>..........................</td>
</tr>
 <tr>
     <td>LOCATION ADDRESS</td><td>'.$address.'</td>
</tr>
</table>

<table border="1" cellspacing="0">
<tr><th>S/N</th><th>NAME OF STUDNETS</th><th>MATRIC NO</th><th>COURSE OF STUDY</th><th>NAME OF INSTITUTION</th><th>PERIOD OF ATTACHMENT</th><th>DATE STUDNET COMMENCED</th><th>DATE STUDENT WILL COMPLETE</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>Federal Polytechnic Ede</td><td>'.$sql_fetch['course'].'</td><td>'.$row['fromYear'].'</td><td>'.$row['toYear'].'</td><td></td>';
    $i++;
}
$mainBody.='</tr></table><p>This form is to be completed by the Employer signed and stamped to ITF Area Office............................................
    ';
//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;

ob_end_flush();
?>