<?php
ini_set('memory_limit', '512M');
/**
 * Created by PhpStorm.
 * User: SERVER
 * Date: 06/02/2016
 * Time: 3:29 PM
 */
session_start();
require_once('../connect.php');
$mainBody='<center><H3 align="center">THE FEDERAL POLYTECHNIC EDE<BR> STUDENT INDUSTRIAL WORK EXPERIENCE SCHEME (SIWES) <BR> 2021 MASTER LIST</H3>';
$db=db_connect();
$dat=date('l, M d, o, h:i:s a');
$dateNow=date('d/ m/ y');
//$db=db_connect();
if (isset($_GET['start'])){
    if (($_GET['start']) and ($_GET['start'])){
        $start=$_GET['start'];
        $end=$_GET['end'];
        $ko=$end-$start+1;
    }else{
        $start=1;
        $end=100;
        $ko=$end-$start+1;
    }
}else{
    $start=1;
    $end=100;
    $ko=$end-$start+1;
}

$sql3=$db->query("select * from siwesbiodata order by matNo ");
//$sql3_fetch=$sql3->fetch(PDO::FETCH_BOTH);
$numCourse=$sql3->rowCount();

$mainBody.='
<table border="1" cellspacing="0">
<tr>
<th>S/N</th>
<th width="28%">NAME OF STUDENT</th>
<th>MATRIC NO</th>
<th width="15%">COURSE OF STUDY</th>
<th>LEVEL OF STUDY</th>
<th>ATTACHMENT PERIOD</th>
<th>NATIONALITY</th>
</tr>
';
$i=1;
$k=$start;
while($row=$sql3->fetch(PDO::FETCH_BOTH)) {
    // $mainBody .= '<tr><td>' . $i . '</td><td>';
    $matNo = $row['matNo'];

    $fromYear = $row['fromYear'];
    $toYear = $row['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=(int)$dateDiff;
    $dateDiff = (ceil($dateDiff)) . ' weeks';


    $sql = $db->query("select * from realdata where matNo='$matNo' and matNo  like '%dpt%'");
    $sql_fetch = $sql->fetch(PDO::FETCH_BOTH);

    if (($i >= $start) and ($k <= $end)) {
        if ($sql->rowCount() > 0) {
            $mainBody .= '<tr><td>' . $k . '</td><td>' . $sql_fetch['names'] . '</td><td>' . $row['matNo'] . '</td><td>' . $sql_fetch['course'] . '</td><td>';
            $level = $sql_fetch['levelID'];
            $levelData = $db->query("select * from leveltb where id='$level'");
            $level_fetch = $levelData->fetch(PDO::FETCH_BOTH);
            $levelName = $level_fetch['levelName'];
            $mainBody .= $levelName . '</td><td>'.$row['fromYear'].' To '.$row['toYear'].'</td><td>' . $row['nationality'] . '</td>';

            // if ($i == 10) {
            //    break;
            ++$k;

        }



    }
    $i++;

}
$k=$k-1;
$numCourse=$numCourse-1;
$mainBody.='
         <tr>
            <td colspan="4" align="right"><B>  </B></td>
            <td colspan="3"><B> Total Number of Records = '. $k.'</B></td>
            <td>&nbsp;</td>
          </tr>';



$mainBody.='</tr></table><p>This form is to be completed by the Employer signed and stamped to ITF Area Office............................................





    ';
//echo $mainBody
;

$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");
//$form8=new mPDF('c');
$form8=new mPDF('c');
$form8->AddPage('L','','','','',5,5,5,5,5,5);

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

?>