| 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/admissionProcess/ |
Upload File : |
<?php
/**
* Created by PhpStorm.
* User: aspoaSoftTech
* Date: 7/22/2020
* Time: 9:16 PM
*/
require_once('../connect.php');
$reportHead='National Diploma (Daily Part Time)';
$db=db_connect();
$sql=$db->query("select * from vw_formsales_dept_level where level='dptForm' group by dept");
//$reportHead="ND Full Time";
$mainPage='
<html>
<head>
<title>Application Report Head</title>
</head>
<body>
<center><img src="../images/siwesHead.png" align="center">
<h2 align="center">REPORT OF 2020/2021 APPLICATION FORM SOLD</h2><table width="80%" align="center">';
$mainPage.='<tr><td>Date Printed: <b>'.date('l, M d, o, h:i:s a').'</b><br></td></tr>';
$mainPage.='<tr><td>Report Title: <b>'.$reportHead.'</b></td></tr></table>';
$mainPage.= '<p></p><div class="row">
<div class="col-lg-12" >
<div class="panel panel-info">
<div class="panel-heading">
</div>
<!-- /.panel-heading -->
<div>
<div >
<table align="center" width="80%" border="1" cellpadding="3" cellspacing="0" >
<thead>
<tr >
<th>S/N</th>
<th>Department</th>
<th>Population</th>
</tr>
</thead>
<tbody>';
$i=0;
$total=0;
while ($row=$sql->fetch(PDO::FETCH_BOTH)){
$r=$i+1;
$dept=$row['dept'];
$population= $row['pop'];
$numb=$row['level'];
if (($dept=='Science Laboratory Technology') and ($numb=='dptForm')){
$population= $row['pop']-2;
}
$total=$total+$population;
$mainPage.='<tr class="odd gradeX">
<td>'.$r.'</td>
<td>'.$dept.'</td>
<td>'.$population.'</td>';
++$i;
}
$mainPage.='</tr>
<tr><th colspan="2" align="center">Total</th><th align="left">'.$total.'</th></tr>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div><p></p>
<table width="80%" align="center"><tr><td>______________________</td></tr>
<tr><td>Admission Officer</td></tr></table>';
//echo $mainPage;
//die();
//$mainPage='ooo';
include("../mpdf/mpdf.php");
$mpdf=new mPDF('c');
$mpdf->SetWatermarkImage('../images/logoBack.png');
$mpdf->showWatermarkImage = true;
$customizedFooter='<img src="../images/siwesfooter.png"><br><div align="right">'. $dat.'</div>';
$mpdf->WriteHTML($mainPage);
$mpdf->setFooter($customizedFooter) ;
$mpdf->Output();
exit;
?>