<?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 INDUSTIAL WORK EXPERIENCE SCHEME (SIWES) <BR> 2017 MASTER LIST</H3>';
$mainBody='<img src="../images/ACE_LETTER_HEAD_EXAM_attecdance_2.png" align="center">';

$db=db_connect();
$dat=date('l, M d, o, h:i:s a');
$dateNow=date('d/ m/ y');
//$db=db_connect();
if (isset($_GET['id'])){
       $id=$_GET['id'];
    $d="select dOption from dept where sn='$id'";
    $d_ex=$db->query($d);
    $d_fetch=$d_ex->fetch(PDO::FETCH_BOTH);
    $course=$d_fetch['dOption'];
//    die($course);

    }else{

    }


$sql3=$db->query("select * from ace_realdata where matNo in (select regNo from ace_remitaorder where transapproved='True' and paymentType='Acceptance Fee') and course='$course' order by matNo ");
//$sql3=$db->query("select * from ace_realdata where matNo in (select regNo from ace_remitaorder where transapproved='True' and paymentType='School Fees') and course='$course' order by matNo ");
//$sql3_fetch=$sql3->fetch(PDO::FETCH_BOTH);
$numRecord=$sql3->rowCount();
$mainBody.='<br><b>Department - '.$course.'</b>';
$mainBody.='
<table border="1" cellspacing="0">
<tr>
<th>S/N</th>
<th>MATRIC NO</th>
<th width="">NAME OF STUDENT</th>

<th width="">COVER PAGE</th>
<th>INNER PAGE</th>
<th>SIGN IN</th>
<th>SIGN OUT</th>
</tr>
';
$i=1;
$k=1;
while($row=$sql3->fetch(PDO::FETCH_BOTH)) {
    // $mainBody .= '<tr><td>' . $i . '</td><td>';
    $matNo = $row['matNo'];

    $names = $row['names'];
    $dept = $row['course'];
            $mainBody .= '<tr><td>' . $k . '</td><td>' . $row['matNo'] . '</td><td>' . $row['names'] . '</td><td></td><td></td><td></td><td></td>';
            ++$k;


}
$k=$k-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>Invigilators\' Signature & Date :............................................





    ';
//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('P','','','','',5,5,5,5,5,5);

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

?>