<?php
$sqlCourse=$db->query("select sum(courseunit) as sumUnit from coursereg where matNo='$matNo' and semester='$asemester' and asession='$asession'");
$sumUnit_fetch=$sqlCourse->fetch(PDO::FETCH_BOTH);
$sumUnit=$sumUnit_fetch['sumUnit'];
//die($sumUnit);

$prefix=substr($matNo,0,3);
$sql=$db->query("select ndMaxUnit,hndMaxUnit,ndPTMaxUnit from dept where nd='$prefix' or hnd='$prefix'");
$sql_fetch=$sql->fetch(PDO::FETCH_BOTH);
//if ($sql_fetch['ndMaxUnit']>1) {
$levelID;
if (($levelID==1) or($levelID==2)or ($levelID==8)or ($levelID==9)) {
    $maxUnit = $sql_fetch['ndMaxUnit'];
}else if (($levelID==5) or($levelID==6)or ($levelID==7)) {
    $maxUnit = $sql_fetch['ndPTMaxUnit'];
}else if (($levelID==3) or($levelID==4)or ($levelID==11)or ($levelID==12)) {
    $maxUnit = $sql_fetch['hndMaxUnit'];
}

$session_split=explode('/',$asession);
$session_gena=$session_split[0]-1;
$session_genb=$session_split[1]-1;
$session_gen=$session_gena.'/'.$session_genb;

//echo $asemestera='%'.$asemester. '%';
//$dbh = new PDO("mysql:host=localhost;dbname=fpe_result", "root", "");

// $result_table=$_SESSION['result_table'];
// $ff="select * from ".$result_table." where MatricNo='$matNo' and remark like 'Prob%'";
// $ff="select * from summertable where matNo='$matNo' and carryCourse like 'Prob%'";
$ff="select * from summertable where matNo='$matNo' and carryCourse like 'Prob%'";
//die();
// $sq=$db->query("select * from rawcgpa where matNo='$matNo' and remark like 'Prob%' and asession='$session_gen' and `level`  like '%Second%'")->rowCount();
$sq=$db->query($ff)->rowCount();
if ($sq==1){
    switch ($levelID) {
        case 1:
            $maxUnit = 18;
            break;
        case 2:
            $maxUnit = 22;
            break;
        case 3:
            $maxUnit = 18;
            break;
        case 4:
            $maxUnit = 18;
            break;
        case 5:
            $maxUnit = 15;
            break;
        case 6:
            $maxUnit = 15;
            break;
        case 7:
            $maxUnit = 15;
            break;
        case 8:
            $maxUnit = 18;
            break;
        case 9:
            $maxUnit = 22;
            break;
        case 10:
            $maxUnit = 1;
            break;
    }


}
//die($maxUnit);
?>