<?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);
$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;
}
//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);
    $levelN=$aspoa1_fet[1];
}else{
    $levelN=0;
}
//echo $level_name;
//echo $aspoa1->rowCount();
echo "<div align='right'><a href=\"javascript:history.go(-1)\" >GO BACK</a></div>";
?>

<table width="60%" border="0">
    <tr><td>School Name: </td><td><?php echo $school;?></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><th>SN</th><th>Course Code</th><th>Course Title</th><th>Course Unit</th></tr>


<?php
//echo "select * from coursepool where dept='$dept_name' and levelID='$levelN' and semester='$semester'";
$asp=$db->query("select * from coursepool where dept='$dept_name' and levelID='$levelID' and semester='$semester' order by courseCode");
//echo $asp->rowCount();
$sn=1;
$sumUnit=0;
while ($row=$asp->fetch(PDO::FETCH_BOTH)){
    $sumUnit=$sumUnit+$row[6];
   echo ' <tr><td>'.$sn.'</td><td>'.$row[4].'</td><td>'.$row[5].'</td><td>'.$row[6].'</td></tr>';
    ++$sn;
}
echo '<tr><th colspan="3">Total Unit</th><th>'.$sumUnit.'</th></tr>'
?>

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