<?php
//session_start();
//require_once('../connect.php');
//$db=db_connect();
$matno= $_SESSION['matNo'];
$levelID=$_SESSION['levelID'];
 $course= trim($_SESSION['course']);

//Get course ID
$res=$db->query("select * from dept where dOption='$course'");
$res_fetch=$res->fetch(PDO::FETCH_BOTH);
$n=$res->rowCount();

if ($n>0){
    $deptID=$_SESSION['deptID']=$res_fetch['sn'];
}
//get currect  Semester and session

$sql_current=$db->query("select * from current where sn=3");
$sql_current_fetch=$sql_current->fetch(PDO::FETCH_BOTH);
 $num_current=$sql_current->rowCount();

if ($num_current==1){
     $semester=$_SESSION['asemester']=$sql_current_fetch['asemester'];
     $asession=$_SESSION['asession']=$sql_current_fetch['asession'];

}

//get fresher status
$sdouble=$db->query("select * from ace_realdata where matNo='$matno' and fresher like '4%'");
$sdouble_fetch=$sdouble->fetch(PDO::FETCH_BOTH);
$rdouble=$sdouble->rowCount();
 $formNo=$sdouble_fetch['formNo'];
if ($rdouble==1){
     $matno=$sdouble_fetch['matNo'];
}
//Check amount already paid
    $hhh="select sum(amtPaid) as amtP from ace_remitaorder where `regNo`='$matno'  and transApproved='True' and (paymentType='School Fees' or paymentType='Additional School Fees') and `pay_session`='$asession'";
//die();
$query=$db->query($hhh);
   $q2_num=$query->rowCount();

//echo $matnoa="select sum(amtPaid) as amtP from remitaorder where `regNo`='$matno'  and transApproved='True' and (paymentType='School Fees' or paymentType='Additional School Fees')and status<>'Re-fund' and `pay_session`='$asession'";
$query_fetch=$query->fetch(PDO::FETCH_BOTH);
//echo $asession;
 $k= $query_fetch['amtP'];
if (($q2_num>0) and ($query_fetch['amtP']>0)) {
    $amtPaid = $query_fetch['amtP'];
//  echo "Payment Has Been Made, Proceed to Registration";
//check status repeater
}else{
    $amtPaid = 0;
}
//echo $amtPaid;
//check status repeater
$session_split=explode('/',$asession);
$session_gena=$session_split[0]-1;
$session_genb=$session_split[1]-1;
 $session_gen=$session_gena.'/'.$session_genb;
//$checkRemark="select * from rawcgpa where matNo='$matno' and `remark` LIKE 'REPE%' and asession='$session_gen' order by sn";
$checkRemark = "select * from summertable where matNo='$matNo' and `carryCourse` LIKE 'REPE%'";
$resultRemark=$db->query($checkRemark);

  $numRemark=$resultRemark->rowCount();

$specialFee=$_SESSION['specialFee'] = 0;
if (($numRemark>0) and  ! (($levelID==7) or ($levelID==9) or ($levelID==2)or ($levelID==4) )) {
    $remark = 'Repeater';
//    echo $numRemark;
//    echo $levelID;
    $_SESSION['repeater'] = $remark;
//    echo 'bbbbbb';
}elseif(($numRemark>0) and (($levelID==7) or ($levelID==9) or ($levelID==2)or ($levelID==4))){
    $remark = 'Normal';
    $_SESSION['repeater'] = 'Normal';
//    echo 'hrrrrrr';
}else{
//    $specialFee=$_SESSION['specialFee'] = 0;
     $checkFresher="select * from ace_admitted where formNo='$formNo'";
    $resultFresher=$db->query($checkFresher);
    $numFresher=$resultFresher->rowCount();
    if ($numFresher>0){
        $resultFresher_fetch=$resultFresher->fetch(PDO::FETCH_BOTH);
         $remark=$resultFresher_fetch['status'];
        $specialFee=$_SESSION['specialFee'] = $resultFresher_fetch['specialFee'];
    }else{
        $remark='Normal';
//        $specialFee=$_SESSION['specialFee'] =0.0;
//        echo 'herererrerere';
    }
}

$k=$db->query("select * from ace_realdata where matNo='$matno' and `status`='Deferment'");
$deferment=$k->rowCount();
if ($deferment=='1'){
    $remark='Repeater';
    $_SESSION['repeater']=$remark;
}
if ((($levelID == '6') or ($levelID == '7')or ($levelID == '2')or ($levelID == '6')) and ($remark == 'Repeater')) {
    $remark='Normal';
}

//End statuse
//$deptID=16;
//$levelID=4;
//$asession='2018/2019';
//$remark='Normal';
//$remark='Repeater';
//$remark='Ex-Student';

//echo $numFresher;
    $checkAmount="select * from ace_schoolfee where dept='$deptID' and level='$levelID' and status='$remark' and asession='$asession'" ;
$resultAmount=$db->query($checkAmount);
$numAmount=$resultAmount->rowCount();
$resultAmount_fetch=$resultAmount->fetch(PDO::FETCH_BOTH);
  $kAmt= $resultAmount_fetch['amount']+$specialFee;
//echo $kAmt;
//echo $amtPaid;
   $k_amount=$_SESSION['amount']=$_SESSION['amount1']=$kAmt-$amtPaid;
//die();
//echo $remark;
//echo $levelID;

//die($kAmt);

?>