| Server IP : 172.64.80.1 / Your IP : 172.71.120.136 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/ |
Upload File : |
<?php
//die("The Page will be available Soon");
ob_start();
session_start();
$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 | Library Form</title>
<link href="css.css" rel="stylesheet" type="text/css" />
</head>
<body>';
$matNo=$_SESSION['matNo'];
require_once('../../connect.php');
$db=db_connect();
$asession=$_SESSION['asession']='2022/2023';
$scholar = $db->query("select * from scholar where matNo='$matNo' and asession='$asession'");
$scholar_count = $scholar->rowCount();
$sqlBank="select * from remitaorder_2022_2023 where regNo='$matNo'and paymenttype='School Fees'";
$resultBank=$db->query($sqlBank);
$countBank=$resultBank->rowCount();
$countBank=1;
if (($countBank>0) or ($scholar_count==1)){
$biodataSQL="select * from realdata where matNo='$matNo'";
$biodataResult=$db->query($biodataSQL);
$biodataNum=$biodataResult->rowCount();
$biodataResult_fetch=$biodataResult->fetch(PDO::FETCH_BOTH);
$formNo=$biodataResult_fetch['formNo'];
$asession=$_SESSION['asession'];
$asemester=$_SESSION['asemester']='First Semester';
$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" /></p></td>
</tr>
<tr>
<td align="center" bgcolor="#CCCCCC"><strong id="cen"> LIBRARY ACCESS FORM</strong></td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="100%" cellspacing="5" cellpadding="1">
<tr>
<td colspan="7" align="center" id="lab"><em>Note: This form will be required each time you want to make use of the school library.</em></td>
</tr>
<tr>
<td colspan="1">Matric No.</td>
<td > </td>
<td>'.$matNo.'</td>
<td colspan="4" rowspan="4" align="center"><img src="../../passport/Reg'. $matNo.'.jpg" alt="" width="115" height="125" /></td>
</tr>
<tr>
<td colspan="1" id="lab"> Reg No.</td>
<td colspan="1"> </td>
<td colspan="1">'. $biodataResult_fetch['formNo'].'</td>
</tr>
<tr>
<td colspan="1" id="lab">Name</td>
<td> </td>
<td colspan="1"><b><H3>'. strtoupper($_SESSION['names']).'</H3></b></td>
</tr>
<tr>
<td colspan="1" id="lab">Session</td>
<td> </td>
<td colspan="1">'. $asession.'</td>
</tr>
<tr>
<td colspan="1" id="lab">Semester</td>
<td> </td>
<td colspan="1">'.$asemester.'</td>
</tr>
<tr>
<td >Department</td>
<td> </td>
<td>'.$_SESSION['course'].'</td>
<td> </td>
<td >Level</td>
<td > </td>
<td>
';
$dept=$_SESSION['course'];
$hod="select signs,fullName from dept where dOption='$dept'";
$hodexe=$db->query($hod);
if($hodexe->rowCount()==1){
$hodfetch=$hodexe->fetch(PDO::FETCH_BOTH);
$hods=$hodfetch['signs'];
$hodSign='<img src="hodSign/'. $hods.'" alt="" width="85" height="45" />';
$hodSign='<img src="hodSign/'. $hods.'" alt="" width="85" height="45" />';
$libSign='<img src="hodSign/librarianSample.png" alt="" width="85" height="45" />';
$hodName=$hodfetch['fullName'];
}
$levelID= $_SESSION['levelID']=1;
$sqlLevel=$db->query("select * from leveltb where id='$levelID'");
$numLevel=$sqlLevel->rowCount();
$sqlLevel_fetch=$sqlLevel->fetch(PDO::FETCH_BOTH);
$class=$biodataResult_fetch['class'];
if ($class<>''){
$dddd='<h4 style="color: red;">['.$class.']</h4>';
}else{
$dddd='';
}
if ($numLevel>0){
$mainBody.='ND 1';
}else{
$mainBody.='No Level Attached';
}
$mainBody.='</td>
</tr>
<tr>
<td id="lab">Date of Birth</td>
<td> </td>
<td>'. $biodataResult_fetch['dob'].'</td>
<td> </td>
<td id="lab">Phone No.</td>
<td> </td>
<td>'.$biodataResult_fetch['gsm'].'</td>
</tr>
<tr>
<td id="lab">Sex</td>
<td> </td>
<td>'. $biodataResult_fetch['sex'].'</td>
<td> </td>
<td id="lab">State</td>
<td> </td>
<td>'. $biodataResult_fetch['state'].'</td>
</tr>
<tr>
<td id="lab">L.G.A.</td>
<td> </td>
<td>'.$biodataResult_fetch['lga'].'</td>
<td> </td>
<td id="lab">E-Mail</td>
<td> </td>
<td>'. $biodataResult_fetch['email'].'</td>
</tr>
<tr>
<td id="lab">Address</td>
<td> </td>
<td>'. $biodataResult_fetch['address'].'</td>
<td > </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="4" ><p>Student\'s Signature: <img src="../../signature/Reg'. $matNo.'.jpg" width="140px" height="80px" /></p></td>
<td colspan=3>H.O.D\'s Comment &Sign.:'.$hodSign.'</p></td>
</tr>
<tr>
<td colspan="7" bgcolor="#666666" id="headingg">LIBRARY ACCESS CERTIFICATE( '.$_SESSION['asession'].' SESSION)</td>
</tr>
</table></td>
</tr>
<tr>
<td>
<table width="100%" cellspacing="5" cellpadding="3">
<tr>
<td colspan="7" ><table width="100%" cellspacing="5" cellpadding="3">
<tr>
<td><em><strong>Circulation Librarian</strong></em></td>
</tr>
<tr>
<td colspan="3"><b>Officer Name:</b> Mr. Onuah, E. A.</td> <td colspan="4">Signature:'.$libSign.'</td>
</tr>
<tr>
<td colspan="7" align="right"><hr /></td>
</tr>
<tr>
<td colspan="7" align="right">www.federalpolyede.edu.ng - '. date('d M, o').'</td>
</tr>
</table></td>
</tr>
<tr>
<td colspan="7" align="center" bgcolor="#FFFFFF"><hr style="border-bottom-style:dashed" /></td>
</tr>
<tr>
<td colspan="7" bgcolor="#666666" id="headingg">CLASS ATTENDANCE CLEARANCE ( '. $_SESSION['asession'].' SESSION)</td>
</tr>
<tr>
<td colspan="5" ><p>This is to certify that <b>'. strtoupper($_SESSION['names']).'</b> of '.$_SESSION['course']. '-
';
/*$levelID= $_SESSION['levelID'];
$sqlLevel=$db->query("select * from leveltb where id='$levelID'");
$sqlLevel_fetch
$numLevel=$sqlLevel->rowCount();
*/
if ($numLevel>0){
$mainBody.=$sqlLevel_fetch['levelName'];
}else{
$mainBody.='No Level Attached';
}
$mainBody.='
with Registration Number '. $matNo.' has completed all registration and is hereby certified to attend classes.</p>
</td><td rowspan="5" colspan="2"><img src="../../passport/Reg'.$matNo.'.jpg" alt="" width="115" height="125" /></td></tr>
<tr><td colspan="7">
<table width="100%" cellspacing="5" cellpadding="3">
<tr>
<td colspan="4">SCHOOL OFFICER</td>
</tr>
<tr>
<td colspan="2">Name: ____________________ </td>
<td colspan="2"><b>Sign and Stamp: </b>'.date('d M, o').'</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td colspan="5"><table width="100%" cellspacing="5" cellpadding="3">
<tr>
<td align="right"><hr /></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
';
}else{
$mainBody.=header('location:../remitaschoolfee.php');
}
$mainBody.='
</body>
</html>';
if ($matNo=='MK2022010S2641'){
echo $mainBody;
die();
}
$filename='libClearance-'.$matNo.'.pdf';
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($filename,'D');
exit;
ob_end_flush();
?>