| Server IP : 172.64.80.1 / Your IP : 172.70.127.233 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();
session_start();
$matNo=$_SESSION['matNo'];
require_once('../../connect.php');
$db=db_connect();
$sql="select * from realdata where `matNo`='$matNo' and matNo in (select Matric_No from biometric_enrollment)";
$result=$db->query($sql);
$num=$result->rowCount();
if ($num>0){
$qry=$db->query("select * from remitaorder where regNo='$matNo'and paymentType='school Fees' and transApproved='True'");
echo $k=$qry->rowCount();
$qry1=$db->query("select * from scholar where matNo='$matNo'");
echo $k1=$qry1->rowCount();
if (($k>0) or ($k1==1)){
$qry_fetch=$result->fetch(PDO::FETCH_BOTH);
$dept=$qry_fetch['course'];
$sch=$db->query("select dSchool from dept where `dOption`='$dept' ");
$sch_fetch=$sch->fetch(PDO::FETCH_BOTH);
$school=$sch_fetch['dSchool'];
$dateEn=$db->query("select * from biometric_enrollment where `Matric_No`='$matNo' ");
$dateEn_fetch=$dateEn->fetch(PDO::FETCH_BOTH);
$dateEnroll=$dateEn_fetch['Date_Enrolled'];
$mode=$qry_fetch['mode'];
$dob=$qry_fetch['dob'];
$jambNo=$qry_fetch['jambNo'];
$name=$qry_fetch['names'];
$levelID=$qry_fetch['levelID'];
$type=$qry_fetch['mode'];
$sex=$qry_fetch['sex'];
$email=$qry_fetch['email'];
// $sex=
// $levelID= $_SESSION['levelID'];
$sqlLevel=$db->query("select * from leveltb where id='$levelID'");
$sqlLevel_fetch=$sqlLevel->fetch(PDO::FETCH_BOTH);
$numLevel=$sqlLevel->rowCount();
if ($numLevel>0){
$levelName= $sqlLevel_fetch['levelName'];
}else{
$levelName.= 'No Level Attached';
}
if ($levelID=='1'){
$progr='NATIONAL DIPLOMA';
$type='FULL TIME';
$k= 'ND - ';
$duration='Minimum 2 years, Maximum 4 years';
}elseif($levelID=='3'){
$progr='HIGHER NATIONAL DIPLOMA';
$type='FULL TIME';
$duration='Minimum 2 years, Maximum 4 years';
$k= 'HND - ';
}elseif($levelID=='5'){
$progr='NATIONAL DIPLOMA';
$type='PART TIME';
$k= 'ND - ';
$duration='Minimum 3 years, Maximum 6 years';
}elseif($levelID=='8'){
$progr='NATIONAL DIPLOMA';
$type='DAILY PART TIME';
$k= 'ND - ';
$duration='Minimum 2 years, Maximum 4 years';
}elseif($levelID=='10'){
$progr='BASIC SCIENCE';
$type='FULL TIME';
$k= '';
$duration='Minimum 1 years, Maximum 1 years';
}elseif($levelID=='11'){
$progr='HIGHER NATIONAL DIPLOMA';
$type='DAILY PART TIME';
$duration='Minimum 2 years, Maximum 4 years';
$k= 'HND - ';
}
//header and footer
$dateNow=date('l, M d, o, h:i:s a');
$total=0;
$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 | Biometric Clearance</title>
<link href="css.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div style="font-size: 16px" class="col-lg-8 col-lg-offset-2">';
$imageC='../../passport/Reg'.$matNo.'.jpg';
$w=date('o');
$f=strtoupper(substr($dept,0,3));
$sola=$jambNo;
$na=explode(' ',$name);
//$mainData.='<br>Dear '.$na[0].',<br><br>';
$mainData.='
<div align="center"><img src="../../images/siwesHead.png" width="800" height="95" /></div>';
$mainData.='<h3><div style="font-size: 14px; text-decoration: underline; text-align: center; background-color: #98a7b6" >BIOMETRIC ENROLLMENT CBT CLEARANCE FORM </div></h3>';
// $mainData.='<table align="center" width="80%" colspan="3"><tr><td><img style="" src="'.$imageC.'" width="100px" height="100px"></td></tr></table>';
//$mainData.='<table align="center" width="80%"><tr><td align="left"><b>UTME Reg. No.: </b><br><div style="text-align: center">'.$sola.'</div></td><td><div class="container"><div class="tag">Fed. Poly Ede</div><img src="'.$imageC.'" width="100px" height="100px"></div></td><td align="right"><b>Mode of Admission:</b> <br><div style="text-align: center">'.$type.'</div></td></tr></table>';
$qrValue='MatricNo :'.$matNo.'--FullName : '.$name.'--DateEnrolled :'.$dateEnroll;
$mainData.='<p></p><table border="0" cellspacing="0" width="100%" align="center" class="table-bordered" cellpadding="5">';
$mainData.='<tr><td colspan="2" align="center"><img style="" src="'.$imageC.'" width="100px" height="100px"></td></tr>
<tr><td width="20%">Matriculation No</td><td>'.strtoupper($matNo).'</td></tr>
<tr><td width="20%">Surname</td><td>'.strtoupper($na[0]).'</td></tr>
<tr><td> Other Name(s)</td><td>'.$na[1].' '.$na[2].'</td></tr>
<tr><td> Department</td><td>'.$dept.'</td></tr>
<tr><td> Level Name</td><td>'.$levelName.'</td></tr>
<tr><td> Gender</td><td>'.$sex.'</td></tr>
<tr><td> E-Mail</td><td>'.$email.'</td></tr>
<tr><td>Date of Birth</td><td>'.$dob.'</td></tr>
<tr><td>Date Enrolled</td><td>'.$dateEnroll.'</td></tr>
<tr><td colspan="2" align="center"><img src="https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl='. $qrValue .'&choe=UTF-8" title="Link to Google.com" /></td></tr>
</table>';
$mainData.='<div align="center"><img src="../../images/head_ict.png" width="150px" height="100px" /></div>';
// $mainData.="<hr width='20%'>";
// $mainData.='<div align="center"><br>ADISA Solagbade P.</div>';
// $mainData.='<div align="center"><br>Acting Head, ICT</div>';
// $mainData.="<br><i>For Registrar</i></div>";
}else{
echo 'Kindly Pay for School Fees';
}
}else{
echo 'Biometric Clearance not Available';
}
//echo $mainData;
//die();
include("../../mpdf/mpdf.php");
$filename='biometricClearance-'.$matNo.'.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($mainData);
$mpdf->setFooter($customizedFooter) ;
$mpdf->Output($filename,'D');
exit;
//echo $mainData;
//echo $mainData2;
ob_end_flush();
?>