| Server IP : 172.64.80.1 / Your IP : 108.162.242.76 Web Server : Apache System : Linux mail.federalpolyede.edu.ng 5.10.0-32-amd64 #1 SMP Debian 5.10.223-1 (2024-08-10) x86_64 User : federalpolyede.edu.ng_idh35skikv ( 10000) PHP Version : 7.4.33 Disable Function : opcache_get_status MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /var/www/vhosts/federalpolyede.edu.ng/httpdocs_backup/admin_student/print/ |
Upload File : |
<?php
ob_start();
extract($_POST);
$matNo=$username;
//die($matNo);
if (!isset($username)){
header('location:' . '../studentLoginNow.php?id=1');
}
require_once('../../connect.php');
$db=db_connect();
//require_once('../../result_connect.php');
$y=explode('/',$asession);
$year=$y[0];
$s=explode(' ',$asemester);
$semester=$s[0] . '_' . $s[1];
if ($asemester=="Summer"){
$sta="summer";
}else{
$sta='Regular';
}
$tableName=strtolower($year.'_'.$semester.'_results');
//$rdb=rdb_connect();
//echo $query="select * from ".$tableName." where MatricNo='$matNo'";
//$sql=$rdb->query($query);
//$num=$sql->rowCount();
//==============================================
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 = $matNo;
$Session = $asession;
$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;
//die();
// 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'];
$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;
// }
} else {
// die($RecKount);
header('location:' . '../studentLoginNow.php?id=1');
}
//echo "am here";
$mainData='
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>ePortal | Semester Result</title>
<style type="text/css">
#cen {
text-align: center;
font-style: italic;
font-size: 12px;
}
#cen2 {
text-align: center;
font-size: 18px;
font-weight: bold;
}
</style>
</head>
<body>
<table width="80%" align="center" cellpadding="3" cellspacing="5">
<tr>
<td><table width="100%" cellspacing="5" cellpadding="3">
<tr>
<td align="center" colspan="6"><img src="../../images/siwesHead.png" width="741" height="95" /></td>
</tr>
<tr>
<td bgcolor="#3F76B9" id="cen2" colspan="6" >SEMESTER RESULT</td>
</tr>
<tr>
<td id="cen2" colspan="6"><strong>'.strtoupper($ProgCode).' '.$Level.' '.strtoupper($asemester). ' '.$asession.' ACADEMIC SESSION</strong></td>
</tr>
<tr>
<td ><table width="100%" align="left" cellpadding="3" cellspacing="5">
<tr>
<td>NAME</td>
<td><strong>'.$FullNames.'</strong></td><td rowspan="3"><img src="../../passport/Reg'. $matNo.'.jpg" alt="" width="115" height="125" /></td>
</tr>
<tr>
<td>MATRIC NUMBER</td>
<td><strong>'.$matNo.'</strong></td>
</tr>
<tr>
<td>DEPARTMENT</td>
<td><strong>'. $dept.'</strong></td>
</tr>
</table></td>
</tr>
<tr>
<td id="cen">This result DOES NOT serves as replacement for the notification of result or academic transcript being issued by the institution.</td>
</tr>
<tr>
<td><table width="100%" border="1" cellpadding="3" cellspacing="0">
<tr>
<td><strong>SN</strong></td>
<td><strong>CODE</strong></td>
<td><strong>TITLE</strong></td>
<td><strong>UNIT</strong></td>
<td><strong>SCORE</strong></td>
<td><strong>C. POINT</strong></td>
</tr>';
// $sq=$db->query("select distinct(courseCode),score,cpoint,grade from rawscore where matNo='$matNo' and grade<>'--' and level like '%$asemester%'and asession='$asession'");
//$sq_fetch=$sq->fetch(PDO::FETCH_BOTH);
// $nu=$sq->rowCount();
//echo $asession;
$i=1;
$dept1=0;
/*echo $dept;
if ($dept=='SURVEYING AND GEOINFORMATICS') {
$dept='SURVEYING AND GEO-INFORMATICS';
}elseif($dept=='SLT - BIOCHEMISTRY OPTION'){
$dept='BIOCHEMISTRY';
}elseif($dept=='SLT - MICROBIOLOGY OPTION'){
$dept='MICROBIOLOGY';
}elseif($dept=='BUSINESS STUDIES'){
$dept='Business Administration and Mgt.';
}
else{
$dept1 = explode('-', $dept);
if (count($dept1) > 1) {
$dept = trim($dept1[1]);
} else {
$dept = trim($dept1[0]);
}
}
*/
$cpointTotal=0;
// while ($row=$sq->fetch(PDO::FETCH_BOTH)){
for ($kk=0;$kk<$count;++$kk){
$courseCode = $SubjectCodes_split[$kk];
// $res=$db->query("select * from coursepool where coursecode='$courseCode' and dept='$dept'");
// $nus=$res->rowCount();
// $res_fetch=$res->fetch(PDO::FETCH_BOTH);
// if ($nus>0){
$courseTitle=$SubjectNames_split[$kk];
$courseUnit=$SubjectUnits_split[$kk];
// }else{
// $courseTitle="";
// $courseUnit="";
// }
if($Supress<>''){
$score= '***';
$cpoint='***';
$grade='***';
$gpa='***';
$cgpa='***';
$CGPA= '***';
$presGPA='***';
$Remark='***';
}else {
$score = $Scores_split[$kk];
$cpoint = $Points_split[$kk];
$grade = $Grades_split[$kk];
}
$mainData.='
<tr>
<td>'. $i.'</td>
<td>'. $courseCode.'</td>
<td>'. $courseTitle.'</td>
<td>'.$courseUnit; $courseUnitTotal+=$courseUnit; $mainData.='</td>
<td>'. $score.'</td>
<td>'. $cpoint; $cpointTotal+=$cpoint;$mainData.='</td>
</tr>';
++$i;
}
$mainData.='
<tr>
<td colspan="3" align="right"><strong>TOTAL</strong></td>
<td><strong>'. $courseUnitTotal.'</strong></td>
<td> </td>
<td><strong>'.$cpointTotal.'</strong></td>
</tr>
<tr>
<td colspan="3" align="right"> </td>
<td> </td>
<td><strong>GPA:'. $presGPA.'</strong></td>
<td><strong>CGPA:'. $CGPA.'</strong></td>
</tr>
</table>
<p>REMARK: <strong>'. $Remark.'-'.$Supress.'</strong></p>
<p>GPA: Grade Point Aggregate</p>
<p>CGPA: Cummulative Grade Point Aggregate</p></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>';
//echo $mainData;
//
$dat=date('l, M d, o, h:i:s a');
$customizedFooter='<img src="../../images/siwesfooter.png"><br><div align="right">'. $dat.'</div>';
//echo $mainData;
//die();
$filename='semResult-'.$matNo.'.pdf';
include("../../mpdf/mpdf.php");
$mpdf=new mPDF('c');
$mpdf->SetWatermarkImage('../../images/logoBack.png');
$mpdf->showWatermarkImage = true;
$mpdf->WriteHTML($mainData);
$mpdf->setFooter($customizedFooter) ;
//$mpdf->Output();
$mpdf->Output($filename,'D');
exit;
ob_end_flush();
?>