<?php
//$matNo=$username;
//session_start();
$Remark='';
 $rsemester=$_SESSION['rsemester']='second semester';
 $rsession=$_SESSION['rsession'];
//echo $rsemester;
//die($rsemester);
require_once('../connect.php');
$db=db_connect();
//require_once('../../result_connect.php');

$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();
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;
$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){
//    echo $arrObj['Results'][0]['MatricNo'];
//    echo '<br>'.$arrObj['Results'][0]['CGPA'];



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

//    $sql_fetch=$sql->fetch(PDO::FETCH_BOTH);
//$Level = $arrObj['Results'][0]['Level'];
//$FullNames = $arrObj['Results'][0]['FullNames'];
//$CosCode = $arrObj['Results'][0]['SubjectCodes'];
//$dept=$arrObj['Results'][0]['CosCode'];
//
//echo $sql="select * from dept where mis_code='$dept'";
//$sql_ex=$db->query($sql);
//$sql_count=$sql_ex->rowCount();
//if ($sql_count==1){
//$sql_fetch=$sql_ex->fetch(PDO::FETCH_BOTH);
//$dept= $sql_fetch['dOption'];
//}else{
//$dept=$dept;
//}



//================================================== split
//$SubjectCodes = $arrObj['Results'][0]['SubjectCodes'];
//$SubjectCodes_split=explode(',',$SubjectCodes);
//$count=count($SubjectCodes_split);
//$SubjectCodes_split[5];
//
//$SubjectNames = $arrObj['Results'][0]['SubjectNames'];
//$SubjectNames_split=explode('_',$SubjectNames);
//
//$SubjectUnits = $arrObj['Results'][0]['SubjectUnits'];
//$SubjectUnits_split=explode(',',$SubjectUnits);
//
//$Scores = $arrObj['Results'][0]['Scores'];
//$Scores_split=explode(',',$Scores);
//
//$Grades = $arrObj['Results'][0]['Grades'];
//$Grades_split=explode(',',$Grades);
//
//$Points = $arrObj['Results'][0]['Points'];
//$Points_split=explode(',',$Points);
////=======================================end slipt
//
//$prevTNU = $arrObj['Results'][0]['prevTNU'];
//$prevTCP= $arrObj['Results'][0]['prevTCP'];
//$prevCGPA= $arrObj['Results'][0]['prevCGPA'];
//$presTNU = $arrObj['Results'][0]['presTNU'];
//$presTCP= $arrObj['Results'][0]['presTCP'];
//$presGPA= $arrObj['Results'][0]['presGPA'];
//$cumTNU = $arrObj['Results'][0]['cumTNU'];
//$cumTCP=$arrObj['Results'][0]['cumTCP'];
//$CGPA=$arrObj['Results'][0]['CGPA'];
//$cumOUT =$arrObj['Results'][0]['cumOUT'];
//$cumTUP= $arrObj['Results'][0]['cumTUP'];
$Remark= $arrObj['Results'][0]['Remark'];
//$refNumber = $arrObj['Results'][0]['RefNumber'];
//$Supress = $arrObj['Results'][0]['Supress'];
//$ProgCode = $arrObj['Results'][0]['ProgCode'];
//$courseUnitTotal = 0;
// }
}
//echo $Remark;
$asp="OC";
//echo strpos($Remark,'OC');
if (strpos($Remark,$asp)!==false){
    $summerStatus_1=1;
}else{
    $summerStatus_1=0;
}
//echo $summerStatus_1;
?>