| Server IP : 172.64.80.1 / Your IP : 172.69.58.211 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/entranceform/ |
Upload File : |
<?php
ob_start();
session_start();
if ( isset($_SESSION['formNo'])) {
//die( $_SESSION['formNo']);
$mainBody = '
<!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 | 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'];
$admittedSQL = $db->query("select * from admitted where (formNo='$matNo' or formNo='$jambNo') and formNo<>'' and jambNo<>''");
$admittedSQL_num = $admittedSQL->rowCount();
$adm = $admittedSQL_num;
switch ($adm) {
case 1:
$admStatus = 'Admitted';
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 == 'utmeForm') {
$formType = 'National Diploma (FT) Screening';
} elseif ($formTypea == 'dptForm') {
$formType = 'National Diploma (Daily Part Time)';
} elseif ($formTypea == 'ptForm') {
$formType = 'National Diploma (Regular Part Time)';
}
if ($formTypea == 'utmeForm') {
$formHead = 'CANDIDATE\'S INFORMATION PAGE';
} else {
$formHead = 'CANDIDATE\'S INFORMATION 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 == 'utmeForm') or ($formTypea == 'hndForm')) {
$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 = $biodataResult_fetch['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>
<tr>
<td id="lab"><b>Sex</b></td>
<td> </td>
<td>' . $biodataResult_fetch['sex'] . '</td>
<td id="lab"><b>Marital Status</b></td>
<td> </td>
<td >' . $biodataResult_fetch['maritalStatus'] . '</td>
</tr>
<tr>
<td id="lab2"><b>Next of Kin</b></td>
<td> </td>
<td>' . $nameNOK . ',' . $addressNOK . '</td>
<td id="lab2"><strong>Admission Status</strong></td>
<td> </td>
<td colspan="2" style="color:blue; font-size:20px">' . $admStatus . '</td>
</tr>
<tr>
<td colspan="7" bgcolor="#CCCCCC" id="headingg"><b>O\' LEVEL RESULT</b></td>
</tr>
</table></td>
</tr>
<tr>
<td>
<table width="100%" cellpadding="0" cellspacing="3">
<tr>
<td colspan="5">
<table width="100%" cellspacing="5" cellpadding="3">';
$sql3 = "select * from preolevel where formNo='$matNo'";
$result3 = $db->query($sql3);
$num3 = $result3->rowCount();
$result3_fetch = $result3->fetch(PDO::FETCH_BOTH);
if ($num3 > 0) {
$k = $result3_fetch['olevel1'];
$olevel = explode(',', $k);
$count = count($olevel);
$k2 = $result3_fetch['olevel2'];
$olevel2 = explode(',', $k2);
$count2 = count($olevel2);
//echo mysql_result($result3,0,'olevel1')
$mainBody .= '
<tr>
<td><table width="100%" cellspacing="5" cellpadding="0">
<tr><td><b>Exam Type: </b></td><td>' . $result3_fetch['eType1'] . '</td></tr>
<tr><td><b>Exam Number: </b></td><td>' . $result3_fetch['examNo1'] . '</td></tr>
<tr><td><b>Exam Date: </b></td><td>' . $result3_fetch['eYear1'] . '</td></tr>
<tr><td colspan="2"><hr></td></tr>
';
for ($a = 0; $a < $count - 1; ++$a) {
$splitOlevel = explode('-', $olevel[$a]);
$mainBody .= '<tr><td>' . $splitOlevel[0] . '</td><td>' . $splitOlevel[1] . '</td>';
}
$mainBody .= '</td></tr>
</table></td>
<td><table width="100%" cellspacing="5" cellpadding="0">
<tr>
<td>';
if ($result3_fetch['examNo2'] != '') {
$mainBody .= '
<tr>
<td><table width="100%" cellspacing="5" cellpadding="0">
<tr><td><b>Exam Type: </b></td><td>' . $result3_fetch['eType2'] . '</td></tr>
<tr><td><b>Exam Number: </b></td><td>' . $result3_fetch['examNo2'] . '</td></tr>
<tr><td><b>Exam Date: </b></td><td>' . $result3_fetch['eYear2'] . '</td></tr>
<tr><td colspan="4"><hr></td></tr>
';
}
$mainBody .= '</td>
</tr>
<tr>
<td>';
if ($result3_fetch['noOfResult'] == 2) {
for ($a = 0; $a < $count2 - 1; ++$a) {
$splitOlevel2 = explode('-', $olevel2[$a]);
$mainBody .= '<tr><td>' . $splitOlevel2[0] . '</td><td>' . $splitOlevel2[1] . '</td></tr>';
}
// $mainBody.= '';
}
} else {
$mainBody .= '<h1><b>Update Your O\'Level</b></h1>';
}
$mainBody .= '</td>
</tr>
</table></td>
</tr>
</table>
</td>
</tr>';
if ($formTypea == 'hndForm') {
$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'];
} else {
$inst = 'Nil';
$ndMatNo = 'Nil';
$grade = 'Nil';
$gYear = 'Nil';
$itName = 'Nil';
$itAddress = '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>Grade</b></td>
<td> </td>
<td>' . $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 . '</td>
<td id="lab"><b>Address</b></td>
<td> </td>
<td>' . $itAddress . '</td>
</tr></table>';
}
//echo $formNo;
$sql_venue = $db->query("select * from venuetb where formNo='$formNo'");
$sql_venue_num = $sql_venue->rowCount();
if (($sql_venue_num > 0) and ($formTypea <> 'utmeForm')) {
$sql_venue_fetch = $sql_venue->fetch(PDO::FETCH_BOTH);
$dayID = $sql_venue_fetch['examDay'];
$venueID = $sql_venue_fetch['venue'];
$sessionID = $sql_venue_fetch['examSession'];
switch ($dayID) {
case 1:
$day = 'DAY 1 - (Tuesday, 12th December, 2017)';
break;
case 2:
$day = 'DAY 2 - (Wednesday, 13th December, 2017)';
break;
case 3:
$day = 'DAY 3 - (Monday, 18th December, 2017)';
break;
case 4:
$day = 'DAY 4 - (Tuesday, 19th December, 2017)';
break;
case 5:
$day = 'DAY 5 - (Wednesday, 20th December, 2017)';
break;
}
switch ($venueID) {
case 'South':
$venue = 'South Campus, ICT Center';
break;
case 'North':
$venue = 'North Campus, eace_edia Center';
break;
}
switch ($sessionID) {
case 1:
$sTime = 'Session 1 - (8:00 am - 1:00 pm)';
break;
case 2;
$sTime = 'Session 2 - (8:00 am - 1:00 pm)';
break;
case 3:
$sTime = 'Session 3 - (8:00 am - 1:00 pm)';
break;
case 4;
$sTime = 'Session 4- (12:00 Noon- 4:00 pm)';
break;
case 5:
$sTime = 'Session 5 - (12:00 Noon- 4:00 pm)';
break;
case 6;
$sTime = 'Session 6 - (12:00 Noon- 4:00 pm)';
break;
case 7;
$sTime = 'Session 7 - (12:00 Noon- 4:00 pm)';
break;
}
$mainBody .= '</table><table width="100%">
<tr>
<td colspan="8" bgcolor="#CCCCCC" id="headingg"><b>SCREENING TEST INFORMATION</b></td>
</tr>
<tr>
<td><b>Day:</b></td>
<td> </td>
<td>' . $day . '</td>
</tr>
<tr>
<td id="lab"><b>Venue:</b></td>
<td> </td>
<td>' . $venue . '</td>
</tr>
<tr>
<td id="lab"><b>Session/Time</b></td>
<td> </td>
<td>' . $sTime . '</td>
</tr><tr><td colspan="3"><hr></td></tr>';
}
$sql_score = $db->query("select * from cbtscore where formNo='$formNo'");
$sql_score_num = $sql_score->rowCount();
if ($sql_score_num > 0) {
$sql_score_fetch = $sql_score->fetch(PDO::FETCH_BOTH);
$score = $sql_score_fetch['score'];
$jambScoreReal = $jambScore / 8;
$jambScoreReal = round($jambScoreReal, 2);
$total = $jambScoreReal + $score;
if ($formTypea == "utmeForm") {
$mainBody .= '
<tr>
<td id="lab"><b>Post UTME Score (50) </b></td>
<td> </td>
<td>' . $score . '</td>
</tr>
<tr>
<td id="lab"><b>Jamb Score (400)</b></td>
<td> </td>
<td>' . $jambScore . '</td>
</tr>
<tr>
<td id="lab"><h2>Aggregate Score</h2> </td>
<td> </td>
<td><h2>' . $total . '%</h2></td>
</tr>
<tr>
<td id="lab" style="color: blue" colspan="8"><b> </b> Note: Aggregate Score = (Jamb Score/8) + Post UTME Score</h4></td>
</tr>
</table>';
}elseif ($formTypea == "hndForm") {
$oral=$db->query("select * from oralScore where formNo='$formNo' and display=1");
if ($oral->rowCount()==1){
$oral_fetch=$oral->fetch(PDO::FETCH_BOTH);
$oralScore=$oral_fetch['score'];
$total=$oralScore+$score;
}else{
$oralScore=0;
$total=$oralScore+$score;
}
$mainBody .= '
<tr>
<td id="lab"><b>CBT Score (70) </b></td>
<td> </td>
<td>' . round($score,2) . '</td>
</tr>
<tr>
<td id="lab"><b>Oral Interview Score (30)</b></td>
<td> </td>
<td>' . $oralScore . '</td>
</tr>
<tr>
<td id="lab"><h2>Aggregate Score</h2> </td>
<td> </td>
<td><h2>' . round($total,2) . '%</h2></td>
</tr>
<tr>
<td id="lab" style="color: blue" colspan="8"><b> </b> Note: Aggregate Score = CBT Score + Oral Interview Score</h4></td>
</tr>
</table>';
} elseif ($formTypea <> "hndForm") {
$mainBody .= '
<tr>
<td id="lab"><h2>Entrance Screening Result</h2> </td>
<td> </td>
<td><h2>' . $total .'%</h2></td>
</tr>
<tr>
<td id="lab" style="color: blue" colspan="8"><b> </b> <hr></h4></td>
</tr>
</table>';
}
} else{
$mainBody .= '<tr>
<td height="25" colspan="8" bgcolor="#CCCCCC" id="headingg"><b>NOTICE</b></td>
</tr>
<!-- <tr>
<td colspan="5" valign="top"><p>Original Certificate or Result Slip of SSCE, NECO or NABTEB ONLY will be accepted for the Screening.</p>
</td>
</tr>-->
<tr>
<td id="lab" colspan="8" style="font-size:15px">* Kindly come along to the examination venue with the printout of this slip.</td>
<td> </td>
</tr>';
}
$mainBody .= ' </table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>';
//echo $mainBody;
include("../mpdf/mpdf.php");
$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();
exit;
}else{
header('location:login.php?id=2');
//echo '<h2>An Error Occurred, Kindly re-login</h2>';
}
//echo $mainBody;
ob_end_flush();
?>