<?php

$sq=0;
//echo $k="select sum(courseunit) as sumUnit from coursereg where matNo='$matNo' and semester='$asemester' and asession='$asession'";
$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'];
($sumUnit);
//echo $realMatNo;
echo $prefix=substr($matNo,0,2);
$sql=$db->query("select ndMaxUnit,hndMaxUnit,ndPTMaxUnit,feesSchool from dept where nd='$prefix' or hnd='$prefix'");
$sql_fetch=$sql->fetch(PDO::FETCH_BOTH);
$aspoa_p=$sql_fetch['feesSchool'];

//if ($sql_fetch['ndMaxUnit']>1) {
if (($levelID==1) or($levelID==2)or ($levelID==8)or ($levelID==9)or ($levelID==15)) {
 $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'];
}
//echo $rsession;
$rsession=$_SESSION['rsession'];
$session_split=explode('/',$rsession);
$session_gena=$session_split[0]-1;
$session_genb=$session_split[1]-1;
$session_gen=$session_gena.'/'.$session_genb;
//echo $rsemester;
if ($asemester=="Summer"){
    $sta="summer";
}else{
    $sta='Regular';
}
$rsemester= $_SESSION['rsemester'];
if ($rsemester=="First Semester"){
    $asem='First';
}
if ($rsemester=="Second Semester"){
    $asem='Second';
}
if ($rsemester=="Summer Semester"){
    $asem='Second';
}
//die($asemester);
$RegNumber = $matNo;
$Session = $rsession;
$Semester = $asem;
$Category = $sta;//"Regular"; // or Summer;
//
//echo "here";
 $subMatNo=substr($matNo,2,6);
//if ($subMatNo==201804){
//    $Session='2018/2019';
//}
//die();
//echo $matNo;
   $PortalURL = "http://orchids-transactions.com/SMSMobile/orchids_call.php?";
    $parameters = $PortalURL."opCode=RESULT_CHECKING&RegNumber=$realMatNo&Session=$Session&Semester=$Semester&Category=$Category";
//die();
//die("am here");
//curl_setopt($curl, CURLOPT_USERAGENT, "Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)");
if ($realMatNo=='CM20230101064'){
    echo $parameters;
    die();
}
//phpinfo();
//if(curl_exec($curl) === false) {
//    echo 'Curl error: ' . curl_error($curl);
//}
//curl_setopt($curl, CURLOPT_VERBOSE, true);
//
//curl_setopt($curl, CURLOPT_FOLLOWLOCATION, true);
//die("here I amooi");
  $jsondata = HTTPConnect($parameters);
//echo $jsondata;
//echo $levelID;

// Convert JSON string to Array
$arrObj = json_decode($jsondata,true); // Set second argument as TRUE
   $RecKount = count($arrObj['Results']);

if ($RecKount != 0) {

     $arrObj['Results'][0]['MatricNo'];
//    echo '<br>'.$arrObj['Results'][0]['CGPA'];

//=============================================

//    $sql_fetch=$sql->fetch(PDO::FETCH_BOTH);

//echo $sq;
    $max_course="select maxCourse from realdata where matNo='$matNo'";
    $max_course_exe=$db->query($max_course);
    if ($max_course_exe->rowCount()==1){
        $max_course_fetch=$max_course_exe->fetch(PDO::FETCH_BOTH);
        $k_check=$max_course_fetch['maxCourse'];
        if ($k_check>0){
            $maxUnit=$k_check;
        }
    }
    if (($levelID==1) or ($levelID==8)){
//        $maxUnit=30;
    }
//    echo "am here";
}else{
 $sl="select formNo from realdata where matNo=? and fresher=100";
    $sla=$db->prepare($sl);
    $sla->execute([$matNo]);
    $sl_num=$sla->rowCount();
    if ($sl_num==1){
        $sq=6;
    }
}
//die();
//===================================SIS RESULT==
//echo $summerStatus_1;
//die($haystack);

// $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();
//echo $sq;
$remark=$_SESSION['remResult'] = $arrObj['Results'][0]['Remark'];

$haystack = $remark;
$needle   = "PROB";
if( strpos( $haystack, $needle ) !== false) {
    $sq = 1;
//        echo "am here";
}else   if( strpos( $remark, 'Withdraw' ) !== false) {
    $sq=2;
}else     if( strpos( $remark, 'Repeat' ) !== false) {
    $sq=3;
}
else  if( strpos( $remark, 'Passed' ) !== false) {
    $sq=4;
}   else if( strpos( $remark, 'OC' ) !== false) {
    $sq=5;
}
//echo $sq;
if ($sq==1){
//    echo "am here";
//    die();
//    die($levelID);
switch ($levelID) {
    case 1:
        $maxUnit = 18;
        break;
    case 2:
        $maxUnit = 18;
        $aspoa_p=$sql_fetch['feesSchool'];
        if ($aspoa_p=='Science'){
            $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 = 18;
        $aspoa_p=$sql_fetch['feesSchool'];
        if ($aspoa_p=='Science'){
            $maxUnit=22;
        }
        break;
    case 10:
        $maxUnit = 1;
        break;
    case 11:
        $maxUnit = 18;
        break;
    case 12:
        $maxUnit = 18;
        break;
    case 15:
        $maxUnit = 18;
        break;
}
    $max_course="select maxCourse from realdata where matNo='$matNo'";
    $max_course_exe=$db->query($max_course);
    if ($max_course_exe->rowCount()==1){
        $max_course_fetch=$max_course_exe->fetch(PDO::FETCH_BOTH);
        $k_check=$max_course_fetch['maxCourse'];
        if ($k_check>0){
            $maxUnit=$k_check;
        }
    }
//    if (($levelID==1) or ($levelID==8)){
//        $maxUnit=30;
//    }
//echo $maxUnit;
//die($maxUnit);


}
//echo $aspoa_p;
//
//echo $haystack;
//die();

//die($aspoa_p);
//die($maxUnit);
?>