<?php

//session_start();
$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 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)) {
 $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";

 $PortalURL = "http://orchids-transactions.com/SMSMobile/orchids_call.php?";
   $parameters = $PortalURL."opCode=RESULT_CHECKING&RegNumber=$RegNumber&Session=$Session&Semester=$Semester&Category=$Category";
//die();
//curl_setopt($curl, CURLOPT_FOLLOWLOCATION, true);
  $jsondata = HTTPConnect($parameters);
//echo $jsondata;
//echo $levelID;
//die("am here");
// 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;
//        die($haystack);
    }else{
        $sq=0;
//
    }
}
//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();
if ($sq==1){
//    echo "am here";
//    die();
switch ($levelID) {
    case 1:
        $maxUnit = 18;
        break;
    case 2:
        $maxUnit = 18;
        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;
        break;
    case 10:
        $maxUnit = 1;
        break;
}
//echo $maxUnit;
//die($maxUnit);
}

?>