| Server IP : 172.64.80.1 / Your IP : 172.70.50.62 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
session_start();
$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 | Acceptance Receipt</title>
<link href="css.css" rel="stylesheet" type="text/css" />
</head>
<body><div style="font-size: 16px">';
$matNo=$_SESSION['formNo'];
$len=strlen($matNo);
require_once('../../connect.php');
$db=db_connect();
$biodataSQL="select * from admitted_22_23 where formNo='$matNo' or jambNo='$matNo'";
$biodataResult=$db->query($biodataSQL);
$biodataNum=$biodataResult->rowCount();
$biodataResult_fecth=$biodataResult->fetch(PDO::FETCH_BOTH);
$formNo=$biodataResult_fecth['formNo'];
$sessionSQL="select * from current where sn=2";
$sessionResult=$db->query($sessionSQL);
$sessionResult_fetch=$sessionResult->fetch(PDO::FETCH_BOTH);
$asession=$sessionResult_fetch['asession']='2022/2023';
$asemester=$sessionResult_fetch['asemester']='First Semester';
$mainData.='
<table width="80%" 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="800" height="95" /></p></td>
</tr>
<tr>
<td align="center" bgcolor="#CCCCCC"><strong id="cen"><h2>ACCEPTANCE FEE RECEIPT</h2></strong></td>
</tr>
</table></td>
</tr>
<tr>
<td><table width="100%" cellspacing="5" cellpadding="3">
<tr>
<td colspan="1" id="lab">Jamb Reg No./Form No.</td>
<td > </td>
<td colspan="3">';
if ($len=='10'){
$mainData.=$biodataResult_fecth['formNo'];
}else{
$mainData.=$biodataResult_fecth['formNo'];
}
$mainData.='</td>
</tr>
<tr>
<td colspan="1" id="lab">Name</td>
<td> </td>
<td colspan="3"><b><H3>'. strtoupper($_SESSION['names']).'</H3></b></td>
</tr>
<tr>
<td colspan="1" id="lab">Session</td>
<td> </td>
<td colspan="3">2022/2023</td>
</tr>
<tr>
<td colspan="1" id="lab">Semester</td>
<td> </td>
<td colspan="4">First Semester</td>
</tr>
<tr>
<td id="lab">Department</td>
<td> </td>
<td >'.$_SESSION['course'].'</td>
<td id="lab">Level</td>
<td > </td>
<td >';
$levelID= $_SESSION['levelID'];
$sqlLevel=$db->query("select * from leveltb where id='$levelID'");
$numLevel=$sqlLevel->rowCount();
$sqlLevel_fetch=$sqlLevel->fetch(PDO::FETCH_BOTH);
if ($numLevel>0){
$mainData.= $sqlLevel_fetch['levelName'];
}else{
$mainData.= "No Level Attached";
}
$mainData.= '
</td>
</tr>
<tr>
<td colspan="6" id="lab"> </td>
</tr>
</table></td>
</tr>
<tr>
<td>
<table width="100%" cellspacing="5" cellpadding="3">
<tr>
<td colspan="5" bgcolor="#999999" id="headingg">PAYMENT DETAILS</td>
</tr>
<tr>
<td colspan="5">
<table width="100%" cellspacing="5" cellpadding="3">
<tr>
<td><table width="100%" border="1" cellpadding="3" cellspacing="0">
';
$sqlBank="select * from remitaorder_2020_2021 where regNo='$matNo' and (paymentType='Acceptance Fee' or paymentType='Admission Slip') and transApproved='True'";
$resultBank=$db->query($sqlBank);
$countBank=$resultBank->rowCount();
// $resultBank_fetch=$resultBank->fetch(PDO::FETCH_BOTH);
if ($countBank>0){
$mainData.='
<tr>
<td id="heeee">Payment Details</td>
</tr>
<tr>
<td><table width="100%" border="1" cellpadding="3" cellspacing="0">
<tr>
<td><strong>Receipt Number</strong></td>
<td><strong>Remita Retrieval Reference</strong></td>
<td><strong>Date Paid</strong></td>
<td><strong>Payment Type</strong></td>
<td><strong>Amount Paid</strong></td>
</tr>';
while ($row=$resultBank->fetch(PDO::FETCH_BOTH)){
$total=$total+ $row['amtPaid'];
// $qrValue='https://www.federalpolyede.edu.ng/qrCheck.php?ID='.$row['orderID'];
$mainData.='<tr>
<td>'. $row['orderID'].'</td>
<td>'.$row['remitaRRR'].'</td>
<td>'.$row['dateCreated'].'</td>
<td>'.$row['paymentType'].'</td>
<td>N'.$row['amtPaid'].'</td>
</tr>';
$qrValue='https://login.remita.net/remita/onepage/invoice.spa?rrr='.$row['remitaRRR'];
if ($row['paymentType']=='Acceptance Fee'){
$qrValue='https://login.remita.net/remita/onepage/invoice.spa?rrr='.$row['remitaRRR'];
$mainData.='<tr>
<td>'. $row['orderID'].'</td>
<td>'.$row['remitaRRR'].'</td>
<td>'.$row['dateCreated'].'</td>
<td>Portal Charges</td>
<td>N500.00</td>
</tr>';
}
}
// echo $total=$total+ $resultBank_fetch['amtPaid'];
$total=$total+500;
$mainData.='
<tr><td colspan="4" align="right"><h3>Total</h3></td>
<td><h3>N'.$total.'</h3></td></tr>
</table></td>
</tr>';
}else{
$mainData.= ' <tr>
<td> </td>
<td id="errr"><h3>Payment has not been made</h3></td>
</tr>';
}
//$qrValue=' Name->'.$_SESSION['names'].' Session->'.'2021/2022'.' Course->'.$_SESSION['course'].' MatricNo->'.$matNo.' Amount Paid->'.$total;
$mainData.= '
</table></td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="5" bgcolor="#000000" id="headingg2">Proceed to the Students Account Unit of the Bursary Department for confirmation of your payment.</td>
</tr>
<tr>
<td colspan="5" bgcolor="#FFFFFF" id="headingg2"> </td>
</tr>
</table></td>
</tr>
<tr>
<td bgcolor="#666666" id="headingg">FOR OFFICIAL USE ONLY
<tr>
<td colspan="5"><table width="100%" cellspacing="5" cellpadding="3">
<tr>
<td> </td>
<td id="sch"> </td>
</tr>
<tr>
<td>Account Officer:: ______________________</td>
<td rowspan="2"><img src="https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl='. $qrValue .'&choe=UTF-8" title="Link to Google.com" /></td>
</tr>
<tr>
<td>Sign./ Date & Stamp: _________________</td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="2" align="right"><hr />'.$dateNow.'</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
</div>
</body>
</html>';
//echo $mainData;
//die();
$filename='accptFee-'.$formNo.'.pdf';
include("../../mpdf/mpdf.php");
$mpdf=new mPDF('c');
$mpdf->SetWatermarkImage('../../images/logoBack.png');
$mpdf->showWatermarkImage = true;
$mpdf->WriteHTML($mainData);
$mpdf->Output($filename,'D');
exit;