<?php
/**
 * Created by PhpStorm.
 * User: SERVER
 * Date: 06/02/2016
 * Time: 3:29 PM
 */
ob_start();
session_start();
$matNo='BS20220205432';//$_SESSION['matNo'];
require_once('../../connect.php');
$dat=date('l, M d, o, h:i:s a');
$db=db_connect();
$sql=$db->query("select * from realdata where matNo='$matNo'");
$sql_fetch=$sql->fetch(PDO::FETCH_BOTH);
$num=$sql->rowCount();
if ($num==1){
    $matNo=$sql_fetch['matNo'];
    $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.';
        $dd="He";
        $dd2="his";
        $dd3="him";
    }else{
        $title = 'Miss.';
        $dd="She";
        $dd2="her";
        $dd3="her";
    }

   // $k=count($fullName);
    $ku=$db->query("select * from current where sn=2");
    $ku_fetch=$ku->fetch(PDO::FETCH_BOTH);
    $it_date=$ku_fetch['start_date'];
    $it_session=$ku_fetch['it_session'];
}
$mainBody=
    '<img src="../../images/siwesHead.png">
<div align="right">Date: '.date('d/m/y').' </div>
<table width="100%">
<tr>
<td rowspan="3">
____________________________<p> &nbsp;</p>
    ____________________________<p> &nbsp;</p>
    ____________________________</td></tr><tr><td align="right"><div align="right" style="overflow"><img src="../../passport/Reg'. $matNo.'.jpg" alt="" width="115" height="125"  /></div></td>
</tr>
</table>

    Dear Sir/Ma,<p>
   <strong> <h3>REQUEST FOR ONE YEAR POST - ND INDUSTRIAL ATTACHMENT</h3></strong>
   <div style="font-size: 17px">
   <p align="justify">
   I am pleased to introduce to you <b>'.$title.' '.$surname.' '.$othernames.'</b> of this institution who completed a course of study during '.$it_session.' Academic Session leading to the award of the National Diploma (ND) in <b>'.$dept.'</b>.
<p align="justify">'.$dd. ' is to undergo the compulsory One Year Post - ND Industrial Attachment in your Corporation/Establishment with effect from '.$it_date.'.
<p align="justify">I shall be grateful if you grant this request, keep '.$dd3.' gainfully employed and supervised. You would be required during this period to pay '.$dd3.'  monthly stipend.
<p align="justify">Please note that the student should be engaged ONLY after showing evidence of having completed the programme (i.e. a letter of successful completion of course from this institution signed by the Registrar or his representatives).
    <p> Thank you for your kind consideration.
    <p>
    <p>
    Yours faithfully,
    <p>
    <br>
    <img src="../../images/siwesSign.png" width="100px" height="40px"><br>
    Engr. Dr.Agbolade James Olayemi
    <br> SIWES Director
</p></div>
    ';
//echo $mainBody;
$customizedFooter='<img src="../../images/siwesfooter.png"><br><div align="right">'. $dat.'</div>';

include("../../mpdf/mpdf.php");
$filename='IT_letter-'.$matNo.'.pdf';
$mpdf=new mPDF('c');
$mpdf->SetWatermarkImage('../../images/logoBack.png');
$mpdf->showWatermarkImage = true;


$mpdf->WriteHTML($mainBody);
$mpdf->setFooter($customizedFooter) ;
$mpdf->Output($filename,'D');
exit;

?>