<?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();
$sq=0;
$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']);

//$sql="select * from 2022_first_semester_results where matricNo='$RegNumber'";
//
//$sql_exe=$db->query($sql);
//echo $RecKount=$sql_exe->rowCount();
//die("Will be back Soon");
if ($RecKount != 0){
    $Remark= $arrObj['Results'][0]['Remark'];
//    $sql_fetch=$sql_exe->fetch(PDO::FETCH_BOTH);
    $haystack = $Remark;
//    $haystack = $sql_fetch['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=90 or fresher=9)";
    $sla=$db->prepare($sl);
    $sla->execute([$matNo]);
    $sl_num=$sla->rowCount();
    if ($sl_num==1){
        $sq=90;
    }else{
        $sq=100;
    }
}

$sl_Exp="select formNo from realdata where matNo=? and status='EXPULSION'";
$sla_Exp=$db->prepare($sl_Exp);
$sla_Exp->execute([$matNo]);
$sl_Exp_num=$sla_Exp->rowCount();
if ($sl_Exp_num==1) {
    $sq = 901;
}
//echo $sq;
//die($sq);
$asp="OC";
//echo strpos($Remark,'OC');
if (strpos($Remark,$asp)!==false){
    $summerStatus_1=1;
}else{
    $summerStatus_1=0;
}
 $student_status_ID=$sq;
//die();
?>