<?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'];
$eAddress=$sql2_fetch['eAddress'];

$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=(int)$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'];
$supervisor=$sql3_fetch['supervisor'];


// $k=count($fullName);

$placementName=$sql2_fetch['placementName'];
//$eAddress=$sql2_fetch['eAddress'];
$compName=$sql2_fetch['companyName'];
$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/siwesHead.png">

     <h3 align="center"> GRADING FORMAT FOR SIWES EXERCISE<br> STUDENT ASSESSMENT FORM  <br>FORM A1</h3>

<table >

<tr><td colspan="6" align="center"><b> (To be Completed by the industry based supervisor)</b></td></tr>
<tr ><td>1.</td><td  colspan="2">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>2.</td><td  colspan="2">Matric No:</td><td><b>'.$matNo. '</b> </td></tr>
<tr><td>3.</td><td  colspan="2">Department:</td><td><b>'.$dept.'</b> </td></tr>
<tr><td>4.</td><td  colspan="2">Name of The Organization: </td><td>'.$compName.'</td></tr>
<tr><td>5.</td><td  colspan="2">Organization\'s Address:</td><td colspan="4"><b>'.$eAddress.'</b></td></tr>
<tr><td>6.</td><td  colspan="2">Name of The Industry Based Supervisor:</td><td colspan="4"><b>'.$supervisor.'</b></td></tr>
<tr><td>7.</td><td  colspan="6">Period of Report: (From: _____________ 20_____ To ______________ 20_____)</td></tr>
<tr><td>8.</td><td  colspan="6">Assessment</td></tr></table>
<p>
<table border="1" cellspacing="0">
<tr><th>S/N</th><th>Description</th><th>Marks Obtainable</th><th>Marks Obtained</th><th>Remarks</th></tr>
<tr><td>1</td><td>Attendance</td><td align="center">10</td><td></td><td></td></tr>
<tr><td>2</td><td>Punctuality</td><td align="center">10</td><td></td><td></td></tr>
<tr><td>3</td><td>Inter-Personal Relationship</td><td align="center">10</td><td></td><td></td></tr>
<tr><td>4</td><td>Attitude to Work/Level of Knowledge</td><td align="center">30</td><td></td><td></td></tr>
<tr><td>5</td><td>Application of Theoretical Knowledge</td><td align="center">30</td><td></td><td></td></tr>
<tr><td>6</td><td>Level of Compliance with Rules and Regulations</td><td align="center">10</td><td></td><td></td></tr>
<tr><td>7</td><td>Total %</td><td align="center">100</td><td></td><td></td></tr>
</table>
<br>
<div>* To be converted to 30%</div>
<br>
<div>Comments</div>
<br>
<div>____________________________________________________________________________________________</div>
<br>
<div>____________________________________________________________________________________________</div>
<br>

<div>____________________________________________________________________________________________</div>
<br>

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

<div>Signature & Stamp: _______________________________________________ Date:_______________________</div>
<br>



  </div>








    ';

$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();
?>