<?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();

$sola="select * from current";
$sola_exe=$db->query($sola);
if ($sola_exe->rowCount()==1){
    $sola_exe_fetch=$sola_exe->fetch(PDO::FETCH_BOTH);
    $asession=$sola_exe_fetch['asession'];
}

$mainBody='<center><H3 align="center"><img src="../images/siwesHead.png"><BR> '.$asession.' SCHOOL FEES REPORT</H3>';
$dat=date('l, M d, o, h:i:s a');
$dateNow=date('d/ m/ y');

 $summerSQL="select asession from current where sn=2";
$summerSQL_exe=$db->query($summerSQL);
$summerSQL_fetch=$summerSQL_exe->fetch(PDO::FETCH_BOTH);
 $asession=$summerSQL_fetch['asession'];

 $aspoaS="select a.course,a.levelID,a.amount,a.regNo,b.status from vw_schoolfees_2018_2019 a left join realdata b on b.matNo=a.regNo group by course,levelID order by course,levelID";
$sql3=$db->query($aspoaS);
$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;

$tution_112=0;
$registration_115=0;
$caution_515=0;
$exam_114=0;
$games_117=0;
$library_129=0;
$swiss_551=0;
$id_116=0;
$verification_119=0;
$handbook_120=0;
$entrepreneurship_123B=0;
$std_127=0;
$matriculation_174=0;
$convocation_174A=0;
$xray_142=0;
$ict_191=0;
$lab_123=0;
$log_122=0;
$transport_191A=0;
$std_138=0;

while($row=$sql3->fetch(PDO::FETCH_BOTH)) {
    // $mainBody .= '<tr><td>' . $i . '</td><td>';
    $dept = $row['course'];
    $sql_dept = $db->query("select * from dept where DOption='$dept'");
    $sql_fetch_dept = $sql_dept->fetch(PDO::FETCH_BOTH);
    $deptID=$sql_fetch_dept['sn'];

    $levelID = $row['levelID'];
    $population = $row['population'];
    $amt=$row['amt'];
    $status=$row['status'];
//    $asession=$row['asession'];
    if ($status==''){
        $status='Normal';
    }

    $tution_112+=$tution_112;

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

      $jes="select *,(select names from schoolfeecode where schoolfeecode.code=schoolfeedetails.code) as names from schoolfeedetails where dept='$deptID' and level='$levelID' and status='$status' and asession='$asession'";
    $sqlFees=$db->query($jes);
//    die("here");

    $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();

?>