<?php
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 03/31/2023
 * Time: 09:25
 */
include('headMain_light.php');
require_once('connect.php');
$db=db_connect();
extract($_POST);
$title="APPROVED SCHEDULE OF FEES FOR 2024/2025 ACADEMIC SESSION";

//echo $level_name;
//echo $aspoa1->rowCount();
echo "<div align='right'><a href=\"javascript:history.go(-1)\" >GO BACK</a></div>";
?>

<table width="80%" border="0">
    <tr><td style="color: #003166; font-size: 20px"><?php echo $title;?></td></tr>
<!--    <tr><td>Department/Course Name: </td><td>--><?php //echo $dept_name;?><!--</td></tr>-->
<!--    <tr><td>Level Name: </td><td>--><?php //echo $levelN;?><!--</td></tr>-->
<!--    <tr><td>Semester: </td><td>--><?php //echo $semester;?><!--</td></tr>-->
</table>
<hr>
<table  width="70%" border="1">
<!--    <tr><td>'.$sn.'</td><td>'.$dept_name.'</td><td>'.$levelName.'</td><td>'.$status.'</td><td>'.$amount.'</td></tr>-->
    <tr><th>SN</th><th>Department</th><th>Level Name</th><th>Status</th><th>Amount</th></tr>


<?php
//echo "select * from coursepool where dept='$dept_name' and levelID='$levelN' and semester='$semester'";
$asp=$db->query("select * from schoolfee where asession='2024/2025' and dept in (3,14) order by dept,level,status");
//echo $asp->rowCount();
$sn=1;
$sumUnit=0;
while ($row=$asp->fetch(PDO::FETCH_BOTH)){
//    $sumUnit=$sumUnit+$row[6];
    $dept=$row['dept'];
    $levelID=$row['level'];
    $status=$row['status'];
    $amount=$row['amount'];
    $aspoa=$db->query("select * from dept where sn='$dept'");
    if ($aspoa->rowCount()==1){
        $aspoa_fet=$aspoa->fetch(PDO::FETCH_BOTH);
        $dept_name=$aspoa_fet[3];
    }else{
        $dept_name=0;
    }
    if ($dept_name=='Accountancy'){
        $deptK='SOCIAL SCIENCE';
    }else{
        $deptK='SCIENCE AND TECHNOLOGY';
    }
//echo "select * from leveltb where sn='$levelID'";
    $aspoa1=$db->query("select * from leveltb where id='$levelID'");
    if ($aspoa1->rowCount()==1){
        $aspoa1_fet=$aspoa1->fetch(PDO::FETCH_BOTH);
        $levelName=$aspoa1_fet[1];
    }else{
        $levelName=0;
    }
   $amount= number_format($amount,2);
   echo ' <tr><td>'.$sn.'</td><td>'.$deptK.'</td><td>'.$levelName.'</td><td>'.$status.'</td><td>'.$amount.'</td></tr>';
    ++$sn;
}
echo '<tr><th colspan="5"><hr></th></tr>';
echo '<tr><th colspan="5" style="color:red">NOTE</th></tr>';
echo '<tr><th colspan="5">* N2500 to be paid by student using extra result</th></tr>';
echo '<tr><th colspan="5">* THAT AN ADDITIONAL ₦10,000 ONLY IS REQUIRED FOR SGI, GEOLOGY & OTHER CAMPING & EXCURSION</th></tr>';
echo '<tr><th colspan="5">** Library & Information Science and Office Technology and Management students are to pay the same amount with science students</th></tr>'
?>

</table>
<hr>
<div style="color: #b05b0a">NOTE: Kindly visit ICT Directorate or Contact (07061230735 - WhatsApp ONLY) For ANY CORRECTION. Thanks</div>
<hr>