<?php
$student_status_ID=0;
$Remark='';
 $rsemester=$_SESSION['rsemester'];
 $rsession=$_SESSION['rsession'];
require_once('../connect.php');
$db=db_connect();

$y=explode('/',$rsession);
 $year=$y[0];
//die();

$s=explode(' ',$rsemester);
$semester=$s[0] . '_' . $s[1];
if ($rsemester=="Summer"){
    $sta="summer";
}else{
    $sta='Regular';
}
 $tableName=strtolower($year.'_'.$rsemester.'_results');
//die();
//echo php_ini_loaded_file();
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;
}
// get these variable from url
$RegNumber =  $_SESSION['matNo'];
$Session = $rsession;
$subMatNo=substr($matNo,2,6);

$Semester = $s[0];
$Category = $sta;//"Regular"; // or Summer;
//
$PortalURL = "http://orchids-transactions.com/SMSMobile/orchids_call.php?";
 $parameters = $PortalURL."opCode=RESULT_CHECKING&RegNumber=$RegNumber&Session=$Session&Semester=$Semester&Category=$Category";
$jsondata = HTTPConnect($parameters);
//echo $jsondata;

// Convert JSON string to Array
$arrObj = json_decode($jsondata,true); // Set second argument as TRUE
$RecKount = count($arrObj['Results']);
if ($RecKount != 0){
    $haystack = $Remark;
    $needle   = "PROB";
    if( strpos( $haystack, 'PROB' ) !== false) {
        $sq = 1;
    }elseif( strpos( $Remark, 'WITHDRAW' ) !== false) {
        $sq=2;
    }elseif( strpos( $Remark, 'REPEAT' ) !== false) {
        $sq=3;
    }elseif( strpos( $Remark, "PASSED" ) !== false) {
        $sq=4;
    }elseif( strpos( $Remark, 'OC' ) !== false) {
        $sq=5;
    }
}else{
    $sl="select formNo from realdata where matNo=? and (fresher=80 or fresher=8)";
    $sla=$db->prepare($sl);
    $sla->execute([$matNo]);
    $sl_num=$sla->rowCount();
    if ($sl_num==1){
        $sq=80;
    }else{
        $sq=100;
    }

}
$asp="OC";
//echo strpos($Remark,'OC');
if (strpos($Remark,$asp)!==false){
    $summerStatus_1=1;
}else{
    $summerStatus_1=0;
}
$student_status_ID=$sq;
?>