<?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 STUDENTS</th><th>MATRIC NO</th><th width="15%">COURSE OF STUDY</th><th>LEVEL OF STUDY</th><th>ATTACHMENT PERIOD</th><th>NATIONALITY</th><th>BANK NAME/BRANCH</th><th>ACCOUNT NO</th><th>SORT CODE</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 levelID>7");
    $sql_fetch = $sql->fetch(PDO::FETCH_BOTH);

   if (($i >= $start) and ($i <= $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>' . $dateDiff . '</td><td>' . $row['nationality'] . '</td><td>' . $row['bankName'] . '</td><td>' . $row['AccountNo'] . '</td><td>';

            $bank = $row['bankName'];
            $bankData = $db->query("select * from bankdetail where bank_name='$bank'");
            $bank_fetch = $bankData->fetch(PDO::FETCH_BOTH);
            $bankCode = $bank_fetch['isw_code'];
            $mainBody .= $bankCode . '</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;

?>