<?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');
$db=db_connect();
$summerSQL="select summer from current where sn=2";
$summerSQL_exe=$db->query($summerSQL);
$summerSQL_fetch=$summerSQL_exe->fetch(PDO::FETCH_BOTH);
 $summ=$summerSQL_fetch['summer'];
$mainBody='<center><H3 align="center"><img src="../images/siwesHead.png"><BR>'.$summ. ' SUMMER SCHOOL FEES REPORT</H3>';

$dat=date('l, M d, o, h:i:s a');
$dateNow=date('d/ m/ y');

$sql3=$db->query("select course,levelID,count(sn) as population,sum(amount) as amt from vw_summerschoolfees_2018_2019 group by course,levelID order by course,levelID");
$numCourse=$sql3->rowCount();
//die("am here");
$mainBody.='
<table border="1" cellspacing="0">
<tr>
<th width="10%">S/N</th>
<th width="40%">NAME OF DEPARTMENT</th>
<th width="15%">LEVEL </th>
<th width="15%">POPULATION</th>
<th width="20%">AMOUNT (N)</th>

</tr>
';
$i=1;
$numStudent=0;
$amtTotal=0;
while($row=$sql3->fetch(PDO::FETCH_BOTH)) {
    // $mainBody .= '<tr><td>' . $i . '</td><td>';
    $dept = $row['course'];

    $levelID = $row['levelID'];
    $population = $row['population'];
    $amt=$row['amt'];

    $sql = $db->query("select * from leveltb where id='$levelID'");
    $sql_fetch = $sql->fetch(PDO::FETCH_BOTH);

    $numStudent+=$population;
    $amtTotal+=$amt;
    if ($sql->rowCount() > 0) {
        $mainBody .= '<tr><td width="10%">' . $i . '</td><td width="60%">' . $dept . '</td><td>' . $sql_fetch['levelName'] . '</td><td>' . $population . '</td><td>' . number_format($amt) . '</td>';
    }
    $i++;
}

$numCourse=$numCourse;
$mainBody.='
         <tr>
            <td colspan="3" align="right"><B> Total Number of Students = </B></td>
            <td colspan="1"><B>  '. $numStudent.'</B></td>
             <td colspan="1"><B>  N'.number_format($amtTotal) .'</B></td>
          </tr>';
$mainBody.='</tr></table>';
//echo $mainBody;
//die();

//$dat=date('l, M d, o, h:i:s a');
include("../mpdf/mpdf.php");
//$mpdf=new mPDF('c');
$mpdf=new mPDF('','', 0, '', 10, 10, 10, 10, 9, 9, 'P');

$mpdf->SetWatermarkImage('../../images/logoBack.png');
$mpdf->showWatermarkImage = true;

$dat=date('l, M d, o, h:i:s a');
$customizedFooter='<img src="../../images/siwesfooter.png"><br><div align="right">'. $dat.'</div>';

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

ob_end_flush();

?>