<?php
ob_start();
/**
 * Created by PhpStorm.
 * User: SERVER
 * Date: 06/02/2016
 * Time: 3:29 PM
 */
    ?>
<script type="text/css">
    .table{
        font-size: 20px;
    }
    #table{
        font-size: 20px;

    }
</script>
<?php
session_start();
$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();
$sql=$db->query("select * from realdata where matNo='$matNo'");
$sql_fetch=$sql->fetch(PDO::FETCH_BOTH);
$num=$sql->rowCount();

$sql2=$db->query("select * from siwesbiodata where matNo='$matNo'");
$sql2_fetch=$sql2->fetch(PDO::FETCH_BOTH);
$num2=$sql2->rowCount();
$fromYear=$sql2_fetch['fromYear'];
$toYear=$sql2_fetch['toYear'];

$from=strtotime($fromYear);
$to=strtotime($toYear);
$dateDiff=$to-$from;

$dStart = new DateTime($fromYear);
$dEnd  = new DateTime($toYear);
$dDiff = $dStart->diff($dEnd);
$dateDi=$dDiff->days;
$dateDiff=$dateDi/7;
$dateDiff=ceil($dateDiff);
//$dateDiff=date_diff($fromYear,$toYear);

$sql3=$db->query("select * from siwesconfirm where matNo='$matNo'");
$sql3_fetch=$sql3->fetch(PDO::FETCH_BOTH);
$secured=$sql3_fetch['secured'];
$description=$sql3_fetch['description'];
$siwesDept=$sql3_fetch['siwesDept'];
$amtCollected=$sql3_fetch['amtCollected'];
$experience=$sql3_fetch['experience'];
$lastPlacement=$sql3_fetch['lastPlacement'];


// $k=count($fullName);

$placementName=$sql2_fetch['placementName'];
$eAddress=$sql2_fetch['eAddress'];
$nationality=$sql2_fetch['nationality'];
$dob=$sql_fetch['dob'];
$ePhoneNo=$sql2_fetch['ePhoneNo'];

if ($num==1){
    $matNo=$sql_fetch['matNo'];
    $phoneNo=$sql_fetch['gsm'];
    $fullName=explode(' ',($sql_fetch['names']));
    $surname=strtoupper($fullName[0]);
    $othernames=$fullName[1].' '.$fullName[2];
    $sex=$sql_fetch['sex'];
    $dept=$sql_fetch['course'];
    if ($sex=='Male') {
        $title = 'Mr.';
        $tiH='his';
    }else{
        $title = 'Miss.';
        $tiH='her';
    }
if ($secured=='No'){
    $k='If you have not secured a placement, indicate below Two Towns you hope to find SIWES placement in order of assurance<br> 1.'. $town1 .'<br>2.'. $town2;
}else{
    $k='';
}
}
$mainBody=
'
<img src="../../images/form8Head.png">

     <h3 align="center">     <BR>STUDENTS INDUSTRIAL WORK EXPERIENCE SCHEME<BR> END-OF-PROGRAMME REPORT SHEET</h3>

<table >

<tr><td colspan="6"><b>PART A (To be Completed by the Student)</b></td></tr>
<tr ><td>1.</td><td>(a)</td><td >Name in full:</td><td><b>'. $surname .' '.$othernames.'</b></td ><td>&nbsp;</td><td rowspan="4" align="right" colspan="2"><img src="../../passport/Reg'.$matNo.'.jpg" width="100px" height="100px"></td></tr>
<tr><td></td><td>(b)</td><td>Registration/Matric No:</td><td><b>'.$matNo. '</b> </td><td></td></tr>
<tr><td></td><td>(c)</td><td>Course of Study:</td><td><b>'.$dept.'</b> </td><td></td></tr>
<tr><td></td><td>(d)</td><td>Year of Study: </td><td>2 Years</td><td></td></tr>
<tr><td></td><td>(e)</td><td>Name of Institution:</td><td colspan="4"><b>Federal Polytechnic Ede, Osun State</b></td></tr>

<tr><td>2.</td><td>(a)</td><td>Name & Address of the Company/Establisment:</td><td colspan="4"><b>'. $placementName .', '.$eAddress.'</b></td ></tr>
<tr><td></td><td>(b)</td><td>The Department/Section:</td><td colspan="4"><b>'.$siwesDept. '</b> </td></tr>
<tr><td></td><td>(c)</td><td>Period of Attachement:</td><td colspan="4">From: <b>'.$fromYear.'</b> To: <b>'.$toYear.'</b> </td></tr>
<tr><td></td><td></td><td></td><td colspan="4">Number of Weeks: <b>'.$dateDiff.'</b> </td></tr>

<tr><td>3</td><td colspan="2">Total Allowance receieved by Student:</td><td colspan="4">N'.$amtCollected.'</td></tr>
<tr><td>4</td><td colspan="2">Brief outline of experience/relevance of training provided:</td><td colspan="4">'.$experience.'</td></tr>
<tr><td>5</td><td>(a)</td><td colspan="1">Where were you attached last?: (If Applicable):</td><td colspan="4">'.$lastPlacement.'</td></tr>
<tr><td>5</td><td>(b)</td><td colspan="2">Total number of weeks engaged on Industrial Attachement: (If Applicable):</td><td colspan="3">'.$dateDiff.'</td></tr>
<tr><td></td><td colspan="2">Signature of Student:&nbsp;<img src="../../signature/Reg'.$matNo.'.jpg" width="70px" height="30px"></td><td colspan="4"> Date:&nbsp;&nbsp;'.$dateNow.'</td></tr>
</table>
<p></p>
<div><b>PART B (To be Completed by the Employer)</b></div>
<div>Do you agree with the student\'s comments in items 3 & 4 in Part A?:YES / NO</div>
<div>If No, please comment:_________________________________________________________________________</div>
<br>
<div>___________________________________________________________________________________________</div>
<br>

<div>State total amount paid to student as ITF allowance: N____________________________K</div>
<br>
<div>In words ____________________________________________________________________________________</div>
<br>
<div>Please assess the student\'s overall performance by ticking the appropriate box as provided</div>
<br>
<div>VERY GOOD [  &nbsp;&nbsp;  ]&nbsp;&nbsp;&nbsp;&nbsp;GOOD [ &nbsp;&nbsp;   ]&nbsp;&nbsp;&nbsp;&nbsp; SATISFACTORY [&nbsp;&nbsp;    ]&nbsp;&nbsp;&nbsp;&nbsp;POOR [ &nbsp;&nbsp;   ]</div>
<br>
<div>Will you accept the student in any future attachment?: YES / NO</div>
<br>
<div>If No, please comment: _____________________________________________________________________</div>
<br>
<div>___________________________________________________________________________________________</div>
<br>
<div>If your Company/Establishment in a position to offer this student a job in future?:________________________</div>
<br>
<div>____________________________________________________________________________________________</div>
<br>
<div>Name of Reporting Officer::_____________________________________________________________________</div>
<br>
<div>Designation/Rank: ____________________________________________________________________________</div>
<br>
<div>Signature/Stamp: __________________________________________________ Date:______________________</div>
<br>
<div><i>N.B.: Forms duly completed by employers should be forwarded to/collected by the reprective Institutions under seal.</i></div>

<p></p>
<div><b>PART C (To be Completed by the Institution)</b></div>
<div>Indicate number of visits:________________________________________________________________________</div>

<br>
<div>Give your assessment of facilities provided by Company during visit(s) by ticking:</div>
<br>
<div>STANDARD [  &nbsp;&nbsp;  ]&nbsp;&nbsp;&nbsp;&nbsp;ADEQUATE [ &nbsp;&nbsp;   ]&nbsp;&nbsp;&nbsp;&nbsp; RELEVANT [&nbsp;&nbsp;    ]&nbsp;&nbsp;&nbsp;&nbsp;NOT RELEVANT [ &nbsp;&nbsp;]</div>
<br>
<div>Give your impression of the student\'s involvement in training: FULLY/PARTIALLY</div>
<br>
<div>____________________________________________________________________________________________</div>
<br>
<div>____________________________________________________________________________________________</div>
<br>

<div>____________________________________________________________________________________________</div>
<br>

<div>____________________________________________________________________________________________</div>
<br>
<div>____________________________________________________________________________________________</div>
<br>


<div>Assessment of student\'s performance (Grading "A, B, C, or D" has to be stated).</div>
<br>
<div>____________________________________________________________________________________________</div>
<br>

<div>____________________________________________________________________________________________</div>
<br>
<div>____________________________________________________________________________________________</div>
<br>
<div>____________________________________________________________________________________________</div>
<br>
<div>____________________________________________________________________________________________</div>
<br>


<div>Full Name of Supervisor:__________________________________  Status:_______________________________</div>
<br>
<div>Department/Discipline: _________________________________________________________________________</div>
<br>
<div>Signature/Stamp: __________________________________________________ Date:_______________________</div>
<br>
<div><i>N.B.: The form is to be returned to the ITF on completion bt the respective institution under seal.</i>
  </div>

<hr>
    ';

$customizedFooter='<img src="../../images/siwesfooter.png"><br><div align="right">'. $dat.'</div>';

include("../../mpdf/mpdf.php");
$mpdf=new mPDF('c');

$mpdf->setFooter($customizedFooter) ;
$mpdf->WriteHTML($mainBody);
$mpdf->Output();
exit;
ob_end_flush();
?>