<?php
/**
 * Created by PhpStorm.
 * User: SERVER
 * Date: 06/02/2016
 * Time: 3:29 PM
 */
session_start();
$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();
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.';
    }else{
        $title = 'Miss.';
    }

   // $k=count($fullName);
}
if ($matNo=='ND20180204562'){
    $title='Mrs.';
}
$mainBody=
    '<img src="../../images/siwesHead.png">
<p>____________________________<p>
    ____________________________<p>
    ____________________________<p>
    Dear Sir/Ma,<p>
   <strong> <h2>STUDENT INDUSTRIAL WORK EXPERIENCE SCHEME</h2></strong>
   <div style="font-size: 17px">
   <p align="justify">
   We are pleased to introduce  <b>'.$title.' '.$surname.' '.$othernames.'</b> a Student of <b>'.$dept.'</b> Department in this Polytechnic to your establishement for suitable placement for the Students\' Industrial Work Experience Scheme (SIWES).
   <p align="justify"> The Scheme which is for a period of four months is a requirement for the award of National Diploma in the Institution. The tentative SIWES 2023/2024 period shall be ............ to ..........
   During which the students are expected to work Monday to Friday and within the working hour not exceeding eight (8) hours excluding nights unless those arranged exclusively with students. <p align="justify">Kindly endorse and stamp the attached form and return same to us.
    <p> Thank you for your kind consideration.
    <p>
    <p>
    Yours faithfully,
    <p>
    <br>
    <img src="../../images/siwesSign.png" width="60px" height="40px"><br>
    Engr. Dr.Agbolade James Olayemi
    <br> SIWES Director
</p></div>
    ';
//echo $mainBody;
//die();
$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");
$mpdf=new mPDF('c');

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

?>