<?php
//session_start();
function HTTPConnect($url){
    $ch = curl_init();
    curl_setopt($ch, CURLOPT_URL , $url);
    curl_setopt($ch, CURLOPT_HEADER, 0);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
    //curl_setopt ( $ch, CURLOPT_CONNECTTIMEOUT, $timeout );
    //
    $response = curl_exec($ch);
    curl_close($ch);
    return $response;
}
die("am hereee");
$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);

$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);

//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();

  $PortalURL = "http://orchids-transactions.com/SMSMobile/orchids_call.php?";
    $parameters = $PortalURL."opCode=RESULT_CHECKING&RegNumber=$RegNumber&Session=$Session&Semester=$Semester&Category=$Category";
//die();

//die("am here");

//curl_setopt($curl, CURLOPT_FOLLOWLOCATION, true);
  $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);
     $remark=$_SESSION['remResult'] = $arrObj['Results'][0]['Remark'];

    $haystack = $remark;
    $needle   = "PROB";
    if( strpos( $haystack, $needle ) !== false) {
        $sq = 1;
    }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 "am here";
}else{
 $sl="select formNo from realdata where matNo=? and fresher=80";
    $sla=$db->prepare($sl);
    $sla->execute([$matNo]);
    $sl_num=$sla->rowCount();
    if ($sl_num==1){
        $sq=6;
    }
}
//echo $maxUnit;
//echo $sq;
//echo $remark;
//die($sq);
//===================================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();
if ($sq==1){
//    echo "am here";
//    die();
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;
}
//    echo $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);
//

}
 $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;
    }
}
//echo $haystack;
//die();

//die($maxUnit);
?>