| Server IP : 172.64.80.1 / Your IP : 172.69.17.154 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/entranceform/ |
Upload File : |
<?php
ob_start();
session_start();
$jambScore=0;
//$jambScoreReal=0;
$homeTown='0';
$score=0;
$mainBodyaa='';
$mainBody = '
';
if ( isset($_SESSION['formNo'])) {
//die( $_SESSION['formNo']);
$mainBody .= '
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>ePortal | Biodata</title>
<link href="css.css" rel="stylesheet" type="text/css" />
</head>
<body size="7" >
';
require_once('../connect.php');
$db = db_connect();
$matNo = $_SESSION['formNo'];
$deptID = $_SESSION['dept'];
$sqlDept = "select * from dept where sn='$deptID'";
$ResultDept = $db->query($sqlDept);
$sqlDept_fetct = $ResultDept->fetch(PDO::FETCH_BOTH);
$deptName = $sqlDept_fetct['dOption'];
$biodataSQL = "select * from stddata where formNo='$matNo' and formNo<>''";
$biodataResult = $db->query($biodataSQL);
$biodataNum = $biodataResult->rowCount();
$biodataResult_fetch = $biodataResult->fetch(PDO::FETCH_BOTH);
$formNo = $biodataResult_fetch['formNo'];
$formTypea = $biodataResult_fetch['level'];
// $adm = $biodataResult_fetch['admStatus'];
$jambNo = $biodataResult_fetch['jambNo'];
$uploadStatus1=$biodataResult_fetch['upload1'];
$uploadStatus3=$biodataResult_fetch['upload3'];
$admittedSQL = $db->query("select * from admitted where (formNo='$matNo' or formNo='$jambNo') and formNo<>'' and jambNo<>''");
$admittedSQL_num = $admittedSQL->rowCount();
$admittedSQL_fetch = $admittedSQL->fetch(PDO::FETCH_BOTH);
$kDept = $admittedSQL_fetch['course'];
$kMode = $admittedSQL_fetch['mode'];
$address = $admittedSQL_fetch['address'];
$homeTown = $admittedSQL_fetch['homeTown'];
$adm = $admittedSQL_num;
$adm = 100;
switch ($adm) {
case 1:
$admStatus = 'Admitted <br>( ' . $kDept . ' - <br>' . $kMode . ')';
break;
default:
$admStatus = 'Not Admitted Yet';
}
$sqlNOK = "select * from otherinfo where formNo='$formNo'";
$ResultNOK = $db->query($sqlNOK);
$sqlNOK_fetct = $ResultNOK->fetch(PDO::FETCH_BOTH);
$nameNOK = $sqlNOK_fetct['nName'];
$addressNOK = $sqlNOK_fetct['nAddress'];
$GSMNOK = $sqlNOK_fetct['nGsm'];
if ($formTypea == 'preForm') {
$formType = 'Pre National Diploma';
} elseif ($formTypea == 'hndForm') {
$formType = 'Higher National Diploma (Full Time)';
} elseif ($formTypea == 'hdptForm') {
$formType = 'Higher National Diploma (Daily Part Time)';
} elseif ($formTypea == 'utmeForm') {
$formType = 'National Diploma (FT) Screening';
} elseif ($formTypea == 'dptForm') {
$formType = 'National Diploma (Daily Part Time)';
} elseif ($formTypea == 'ptForm') {
$formType = 'National Diploma (Regular Part Time)';
} elseif ($formTypea == 'remForm') {
$formType = 'Remedial Course';
}
if ($formTypea == 'utmeForm') {
$formHead = 'CANDIDATE\'S SCREENING SLIP';
} else {
$formHead = 'CANDIDATE\'S SCREENING PAGE';
//$formHead='APPLICANT FORM';
}
$mainBody .= '
<table width="100%" align="center" cellpadding="3" cellspacing="5">
<tr>
<td><table width="100%" cellspacing="1" cellpadding="1">
<tr>
<td valign="top"><table width="100%" cellspacing="1" cellpadding="1">
<tr>
<td align="center" valign="top"><p><img src="../images/siwesHead.png" width="731" height="95" /><br />
</p></td>
</tr>
<tr>
<td align="center" bgcolor="#CCCCCC"><strong id="cen"><h2>' . $formHead . '</h2></strong></td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="100%" cellpadding="0" cellspacing="3">
<tr>
<td width="22%" colspan="1" id="lab"><b>Application No.</b></td>
<td width="1%"> </td>
<td colspan="3">' . $matNo . '</td>
<td width="31%" rowspan="4" colspan="2"><img src="../passportForm/' . $matNo . '.jpg" alt="" width="105" height="115" /></td>
</tr>
<tr>
<td colspan="1" id="lab"><b>Form Type</b></td>
<td> </td>
<td colspan="3"><strong>' . $formType . '</strong></td>
</tr>
<tr>
<td colspan="1" id="lab"><b>Full Name</b></td>
<td> </td>
<td colspan="3"><b><H4>' . strtoupper($biodataResult_fetch['surname'] . ' ' . $biodataResult_fetch['otherNames']) . '</H4></b></td>
</tr>
<tr>
<td colspan="1" id="lab"><b>Department</b></td>
<td> </td>
<td colspan="3">' . $biodataResult_fetch['dept'] . '</td>
</tr>
<tr>
<td colspan="1" id="lab"><b>Phone No.</b></td>
<td> </td>
<td colspan="3">' . $biodataResult_fetch['gsm'] . '</td>
</tr>';
if (($formTypea <> 'utmeForma') or ($formTypea <> 'hndForma') or ($formTypea <> 'hdptForma')) {
$jambScore = $biodataResult_fetch['jambScore'];
$mainBody .= ' <tr>
<td id="lab"><b>Jamb Reg. No.</b></td>
<td> </td>
<td width="26%">' . $biodataResult_fetch['jambNo'] . '</td>
<td width="18%" id="lab"><b>Jamb Score</b></td>
<td width="2%"> </td>
<td >' . $jambScore . '
</td>
</tr>';
}
$mainBody .= '
<tr>
<td id="lab"><b>E-Mail</b></td>
<td> </td>
<td width="26%">' . $biodataResult_fetch['email'] . '</td>
<td width="18%" id="lab"><b>Date of Birth</b></td>
<td width="2%"> </td>
<td >' . $biodataResult_fetch['dob'] . '
</td>
</tr>
<tr>
<td id="lab"><b>State</b></td>
<td> </td>
<td>' . $biodataResult_fetch['state'] . '</td>
<td id="lab"><b>LGA</b></td>
<td> </td>
<td >' . $biodataResult_fetch['lga'] . '</td>
</tr>
</table>
';
if (($formTypea == 'hndForm') or ($formTypea == 'hdptForm')) {
$sql_nd = $db->query("select * from ndresult where formNo='$formNo'");
$sql_nd_fetch = $sql_nd->fetch(PDO::FETCH_BOTH);
$sql_nd_count = $sql_nd->rowCount();
if ($sql_nd_count > 0) {
$inst = $sql_nd_fetch['inst'];
$ndMatNo = $sql_nd_fetch['rMatNo'];
$grade = $sql_nd_fetch['result'];
$gYear = $sql_nd_fetch['rYear'];
$itName = $sql_nd_fetch['itName'];
$itAddress = $sql_nd_fetch['itAddress'];
$itFrom = $sql_nd_fetch['itFrom'];
$itTo = $sql_nd_fetch['itTo'];
$ndCourse = $sql_nd_fetch['course'];
} else {
$inst = 'Nil';
$ndMatNo = 'Nil';
$grade = 'Nil';
$gYear = 'Nil';
$itName = 'Nil';
$itAddress = 'Nil';
$ndCourse = 'Nil';
}
$mainBody .= '
<tr>
<td colspan="8" bgcolor="#CCCCCC" id="headingg"><b>ND INFORMATION</b></td>
</tr>
<tr>
<td colspan="8"><table>
<tr><td><b>Institution</b></td>
<td> </td>
<td>' . $inst . '</td>
<td ><b>Matric No</b></td>
<td> </td>
<td>' . $ndMatNo . '</td>
</tr>
<tr>
<td id="lab"><b>Course & Grade</b></td>
<td> </td>
<td>' . $ndCourse . ' (' . $grade . ')</td>
<td id="lab"><b>Year of Graduated</b></td>
<td> </td>
<td>' . $gYear . '</td>
</tr>
<tr>
<td id="lab"><b>IT Placement</b></td>
<td> </td>
<td>' . $itName . ', ' . $itAddress . '</td>
<td id="lab"><b>IT Period</b></td>
<td> </td>
<td>' . $itFrom . ' - ' . $itTo . '</td>
</tr></table></td></tr></table></table>';
}
//echo "select * from olevel_screening where formNo='$formNo'";
$sql_score = $db->query("select * from olevel_screening where formNo='$formNo'");
$sql_score_num = $sql_score->rowCount();
// echo $formNo;
if ($sql_score_num > 0) {
$sql_score_fetch = $sql_score->fetch(PDO::FETCH_BOTH);
$score_subject = $sql_score_fetch['olevelResult'];
$score_grade = $sql_score_fetch['olevelGrades'];
$score_no = $sql_score_fetch['no_olevel'];
$subject = explode(',', $score_subject);
$grade = explode(',', $score_grade);
$jambPe = intVal($jambScore) / 400 * 60;
$olevelPe = round($grade[0] / 30 * 40, 2);
$aggr = round($jambPe + $olevelPe, 2);
// $jambScoreReal = $jambScore / 8;
// $jambScoreReal = round($jambScoreReal, 2);
// $total = $jambScoreReal + $score;
$score= $grade[0];
$mainBody .= '
<table border="1" cellpadding="5" cellspacing="0" width="80%" align="center">
<tr><td colspan="3" ><b>O\'Level Subject Summary </b></td></tr>
<tr><th>SN</th><th>Subjects/Grade</th><th>Points</th></tr>
<tr><td>1</td><td>' . $subject[1] . '</td><td>' . $grade[1] . '</td></tr>
<tr><td>2</td><td>' . $subject[2] . '</td><td>' . $grade[2] . '</td></tr>
<tr><td>3</td><td>' . $subject[3] . '</td><td>' . $grade[3] . '</td></tr>
<tr><td>4</td><td>' . $subject[4] . '</td><td>' . $grade[4] . '</td></tr>
<tr><td>5</td><td>' . $subject[5] . '</td><td>' . $grade[5] . '</td></tr>
<tr><td colspan="2">TOTAL</td><td>' . $score . '</td></tr>
</table>
<p>
<br>
<table border="1" cellpadding="5" cellspacing="0" width=80% align="center">';
if ($formTypea == "utmeForm") {
$qrValue = 'Name : ' . strtoupper($biodataResult_fetch['surname'] . ' ' . $biodataResult_fetch['otherNames']) . '<br>Course of Study :' . $biodataResult_fetch['dept'] . 'Programme :' . $biodataResult_fetch['level'] . ' Aggregate :' . $aggr . '%';
$mainBody .= '
<tr><td colspan="2" ><b>Screening and Result Summary</b></td></tr>
<tr><td>No of Subjects</td><td>' . $score_no . '</td></tr>
<tr><td>O\'level Total Grade Point</td><td>' . $grade[0] . '</td></tr>
<tr><td>UTME Score</td><td>' . $jambScore . '
<tr><td>O\'level Ratio (40%)</td><td>' . $olevelPe . '</td></tr>
<tr><td>UTME Ratio (60%)</td><td>' . $jambPe . '</td></tr>
<tr><td>Overall Total</td><td><h2>' . $aggr . '%</h2></td></tr>
<tr><td></td><td><h2><img src="https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl=' . $qrValue . '&choe=UTF-8" title="Link to Google.com" /></h2></td></tr>
</table>';
}elseif (($formTypea == "dptForm") or ($formTypea == "ptForm")) {
$aggrS= $grade[0]/30*100;
$aggrA = round($aggrS, 2);
$qrValue='Name : '.strtoupper($biodataResult_fetch['surname'] . ' ' . $biodataResult_fetch['otherNames']) .'<br>Course of Study :'.$biodataResult_fetch['dept'].'Programme :'.$biodataResult_fetch['level'].' Aggregate :'.$aggrA.'%';
$mainBody .= '
<tr><td colspan="2" ><b>Screening and Result Summary</b></td></tr>
<tr><td>No of Subjects</td><td>' . $score_no . '</td></tr>
<tr><td>O\'level Total Grade Point</td><td>' . $grade[0] . '</td></tr>
<tr><td>O\'level Ratio (100%)</td><td>' . $aggrS. '</td></tr>
<tr><td>Overall Total</td><td><h2>' . $aggrA . '%</h2></td></tr>
<tr><td></td><td><h2><img src="https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl='. $qrValue .'&choe=UTF-8" title="Link to Google.com" /></h2></td></tr>
</table>';
} elseif (($formTypea == "hndForm") or ($formTypea == "hdptForm")) {
$nd = $db->query("select * from ndresult where formNo='$formNo'");
if ($nd->rowCount() == 1) {
$nd_fetch = $nd->fetch(PDO::FETCH_BOTH);
$ndGrade = $nd_fetch['result'];
switch ($ndGrade) {
case 'Lower Credit':
$ndScore = 10;
break;
case 'Distinction':
$ndScore = 20;
break;
case 'Pass':
$ndScore = 5;
break;
case 'Upper Credit':
$ndScore = 15;
break;
default:
$ndScore = 0;
}
// $score=$score/70*80;
if ($oralScore > 0) {
$oralScore = $oralScore - $ndScore;
}
$score = $grade[0];
$total = $ndScore + $score + $oralScore;
} else {
$oralScore = 0;
$total = 0;
}
$ndScorePer=$ndScore/20*70;
// $olevelPeNow=$olevelPe/40*30;
$aggr = round($ndScorePer + $score, 2);
$qrValue='Name : '.strtoupper($biodataResult_fetch['surname'] . ' ' . $biodataResult_fetch['otherNames']) .'<br>Course of Study :'.$biodataResult_fetch['dept'].'Programme :'.$biodataResult_fetch['level'].' Aggregate :'.$aggr.'%';
$mainBody .= '
<tr><td colspan="2" ><b>Screening and Result Summary</b></td></tr>
<tr><td>O\'level Ratio (30%) </td><td>' . $score . '</td></tr>
<tr><td>National Diploma Ratio (70%) [ND_grade/20*70]</td><td>' . $ndScorePer . '</td></tr>
<tr><td>Aggregate</td><td><h2>' . $aggr . '%</h2></td></tr>
<tr><td></td><td><img src="https://chart.googleapis.com/chart?chs=100x100&cht=qr&chl='. $qrValue .'&choe=UTF-8" title="Link to Google.com" /></td></tr>';
}
}
$mainBody .= ' </table></td>
</tr>
</table>
</body>
</html>';
// $db->query("UPDATE `fedpoly`.`venuetb` SET `used` = '1' WHERE `venuetb`.`formNo` = '$formNo'");
// flush();
// if ($formNo=='22111031361'){
// echo $mainBody;
// }
//
$fff=$uploadStatus1+$uploadStatus2;
if (($uploadStatus1==0) and (($formTypea=='utmeForm') or ($formTypea=='dptForm'))){
die("<h2>Record Incomplete [No Upload for O/'level]</h2>");
die();
}
if ((($uploadStatus1==0) or ($uploadStatus3==0)) and (($formTypea=='hndForm') or ($formTypea=='hdptForm'))){
die("<h2>Record Incomplete [No Upload for ND]</h2>");
die();
}
// echo '<br>';
// echo $uploadStatus1.'<br>';
// echo $uploadStatus3.'<br>';
// echo $formTypea;
// die();
include("../mpdf/mpdf.php");
$filename='appScreening-'.$formNo.'.pdf';
$mpdf = new mPDF('c');
$mpdf->SetWatermarkImage('../images/logoBack.png');
$mpdf->showWatermarkImage = true;
$dat = date('l, M d, o, h:i:s a');
$customizedFooter = '<img src="../images/siwesfooter.png"><br><div align="right">' . $dat . '</div>';
$mpdf->WriteHTML($mainBody);
$mpdf->setFooter($customizedFooter);
// $mpdf->Output("c:a/","D");
$mpdf->Output($filename,'D');
// $mpdf->output();
exit;
// ob_end_flush();
}else{
header('location:login.php?id=2');
//echo '<h2>An Error Occurred, Kindly re-login</h2>';
ob_end_flush();
}
?>