<?php
/**
 * Created by PhpStorm.
 * User: SERVER
 * Date: 06/02/2016
 * Time: 3:29 PM
 */
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);
$stdAddress=$sql_fetch['address'];
$num=$sql->rowCount();

$sql2=$db->query("select * from siwesbiodata where matNo='$matNo'");
$sql2_fetch=$sql2->fetch(PDO::FETCH_BOTH);
$num2=$sql2->rowCount();
$sql3=$db->query("select * from siwesconfirm where matNo='$matNo'");
$sql3_fetch=$sql3->fetch(PDO::FETCH_BOTH);
$secured=$sql3_fetch['secured'];
$description=$sql3_fetch['description'];
// $k=count($fullName);

$placementName=$sql2_fetch['placementName'];
$companyName=$sql2_fetch['companyName'];
$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=
'<div align="right">FPE/SIWES/SP/2</div>
<img src="../../images/siwesHead.png">

     <div style="font-size: 15px">
     <h3 align="center">     <BR>(SIWES COORDINATOR\'S OFFICE)<BR> SIWES PLACEMENT REFERENCE FORM</h3>
<table>

<tr><td>Name of student:</td>&nbsp;<td><b>'. $surname .' '.$othernames.'</b></td ><td rowspan="3" align="right" colspan="2"><img src="../../passport/Reg'.$matNo.'.jpg" width="100px" height="100px"></td></tr>
<tr><td>Department:</td>&nbsp;<td><b>'.$dept. '</b> </td><td></td>&nbsp;<td> </td></tr>
<tr><td>Matric No:</td>&nbsp;<td><b>'.$matNo.'</b> </td><td></td>&nbsp;<td> </td></tr>
<tr><td>Year of Study:</td>&nbsp;<td><b><b>2 Years</b></b></td><td> Phone No: </td>&nbsp;<td> <b>'.$phoneNo.'</b></td></tr>
<tr><td>Student\'s Address:</td>&nbsp;<td> <b> '.$stdAddress.'</b></td></tr>
<tr><td>Date of Birth: </td>&nbsp;<td><b> '.$dob.'</b></td>td>Nationality: </td>&nbsp;<td><b>'. $nationality.'</b></td></tr>
<tr><td>Have you secured a placement?: </td>&nbsp;<td> <b> '.$secured.'</b></td></tr>
<tr><td>Description: </td>&nbsp;<td colspan="4"><div style="align:justify"><i><b>'.$description.'</i></b></div></td></tr>
<tr><td>Name and Street Address of Establishment:</td>&nbsp;<td colspan="4"> <b> '.$companyName.', '.$eAddress.'</b></td></tr>
<tr><td>Phone Number:</td>&nbsp;<td><b> '.$ePhoneNo.'</b></td></tr>
<tr><td>Date: </td>&nbsp;<td><b> '.$dateNow.'</b></td><td>  Signature:  </td>&nbsp;<td><b> ___________________________</b></td></tr>
</table>


<hr>
<p>
<p>

<table>
<tr><td><u><b>FOR OFFICIAL USE ONLY</b></u></td></tr>
<tr><td>NAME OF VISITING LECTURERS:</td></tr>
<tr><td>(i).___________________________________</td><td>&nbsp;&nbsp;</td><td>RANK:_______________________________________</td></tr>
<tr><td>(2).___________________________________</td><td>&nbsp;&nbsp;</td><td>RANK:_______________________________________</td></tr>
<tr><td>DEPARTMENT:</td><td></td></tr>
<tr><td>(i) ______________________________</td><td>&nbsp;&nbsp;&nbsp;</td><td>(ii)______________________________</td></tr>
<tr><td> DATE OF FIRST VISIT:__________________</td><td>&nbsp;</td><td>DATE OF SECOND VISIT:_____________________</td></tr>
<tr><td> SIGNATURE OF OFFICERS:</td><td>&nbsp;</td><td></td></tr></tr>
<tr><td colspan="3"> (i). ________________________ DATE: ______________________________</td></tr>
<tr><td colspan="3"> (ii). ________________________ DATE: ______________________________</td></tr>
<tr><td colspan="3"> SIWES COORDINATING OFFICER: ________________________________________________________</td><td>&nbsp;</td><td></td></tr></tr>
<tr><td colspan="3"> SIGNATURE: _____________________________________ DATE: _______________________________</td></tr>
</table>


    </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;

?>