| Server IP : 172.64.80.1 / Your IP : 172.70.131.125 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_main/ |
Upload File : |
<?php
ob_start();
ini_set('memory_limit', '256M');
$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 | Admission List</title>
</head>
<body>
<fieldset>
<table width="90%" align="center" cellpadding="3" cellspacing="5">
<tr>
<td align="center" valign="top"><img src="../images/siwesHead.png"/></td>
</tr>
</table>';
require_once('../connect.php');
$db=db_connect();
extract($_POST);
$dept=$_POST['dept'];
//echo $courseCode;
$sqlE=$db->query("select * from dept where sn='$dept'");
$sqlE_fetch=$sqlE->fetch(PDO::FETCH_BOTH);
$deptE=$sqlE_fetch['dOption'];
$school=$sqlE_fetch['dSchool'];
if (($level=='3') or ($level=='4')){
$prefix=$sqlE_fetch['hnd'];
}else{
$prefix=$sqlE_fetch['nd'];
}
//echo '<b>Department: </b>'.$deptE;
$sqlLevel=$db->query("select * from leveltb where id='$level'");
$levelLevel_fetch=$sqlLevel->fetch(PDO::FETCH_BOTH);
$levelName=$levelLevel_fetch['levelName'];
$sql="select *,(select names from realdata where matNo=b.matNo) as names from coursereg b where matNo in (select regNo from remitaorder where paymentType='School Fees' and transApproved='True') and courseCode='$courseCode' and levelID='$level' and matNo like '$prefix%'order by matNo";
$result=$db->query($sql);
$num=$result->rowCount();
$i=1;
$mainData.='
</p><tr><td>
<table width="80%" align="center" cellpadding="0" cellspacing="2">
<tr>
<td align="center"><b>SCHOOL OF '. strtoupper($_POST['school']).' </b></td>
</tr>
<tr>
<td align="center"><b>DEPARTMENT OF '.strtoupper($deptE).'</b></td>
</tr>
</table>
<table width="80%" align="center" cellpadding="0" cellspacing="2">
<tr>
<td align="center">';
$sqlCurrent=$db->query("select * from current");
$sqlCurrent_fetch=$sqlCurrent->fetch(PDO::FETCH_BOTH);
$mainData.= '<b style="font-style: italic">SCORE SHEET FOR '.strtoupper($sqlCurrent_fetch['asemester'].' '.$sqlCurrent_fetch['asession'].' '.'SESSION '.$levelName).'</b>
</td>
</tr>
</table>
<table width="100%" cellspacing="2" cellpadding="0">
<tr>
<td width="11%">Course Code:</td>
<td width="4%"> </td>
<td width="37%">'.strtoupper($courseCode).'</td>
<td width="10%">Title:</td>
<td width="41%">';
$q=$db->query("select * from coursepool where courseCode='$courseCode' and dept='$deptE'");
$q_fetch=$q->fetch(PDO::FETCH_BOTH);
$numQ=$q->rowCount();
if ($numQ>0){
$title=$q_fetch['courseTitle'];
$unit=$q_fetch['courseUnit'];
}
$mainData.=strtoupper($title).'
</td>
</tr>
<tr>
<td>Unit:</td>
<td> </td>
<td>'. strtoupper($unit).'</td>
<td>Examiner:</td>
<td>__________________________________________</td>
</tr>
</table>
<table width="100%" border="1" align="center" cellpadding="5" cellspacing="0">
<tr bgcolor="#0099CC">
<td rowspan="2"><em><strong>SN</strong></em></td>
<td rowspan="2"><em><strong>Matr. No.</strong></em></td>
<td rowspan="2"><em><strong>Name</strong></em></td>
<td colspan="3" align="center"><em><strong>C.A.</strong></em></td>
<td rowspan="2"><em><strong>Prac.</strong></em></td>
<td rowspan="2" ><em><strong>Total<br> C.A.</strong></em></td>
<td rowspan="2"><em><strong>Exam</strong></em></td>
<td rowspan="2" align="center"><em><strong>Total (%)<br>100%</strong></em></td>
</tr>
<tr bgcolor="#0099CC">
<td><strong><em> 1 </em></strong></td>
<td><strong><em> 2 </em></strong></td>
<td><strong><em> 3 </em></strong></td>
</tr>
';
while ($row=$result->fetch(PDO::FETCH_BOTH)){
if ($i%2==0){
$mainData.='<tr> ';
}else{
$mainData.='<tr bgcolor="#FFFFFF">';
}
$mainData.='
<td >'. $i.'</td>
<td style="font-size: 12px">'. $row['matNo'].'</td>
<td style="font-size: 12px" >'. strtoupper($row['names']).'</td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr> ';
++$i;
}
$mainData.='
<tr>
<td colspan="10" valign="top"><p><b>Total Record =
'. $num.'
</b></p>
<table width="100%" cellspacing="4" cellpadding="0">
<tr>
<td ><em>No. of Scripts Marked:</em></td>
<td >___________________________</td>
<td ><em>Date:</em></td>
<td >_________________________</td>
</tr>
<tr>
<td><em>No of Script Submitted:</em></td>
<td>___________________________</td>
<td><em>Date of Submittion:</em></td>
<td>_________________________</td>
</tr>
<tr>
<td><em>Lecturer\'s Name and Sign:</em></td>
<td>___________________________</td>
</tr>
<tr>
<td><em>H.O.D.\'s Signature:</em></td>
<td>___________________________</td>
<td><em>Date:</em></td>
<td>_________________________</td>
</tr>
</table></td>
</tr>
</table>
</fieldset></td>
</tr>
</table>
</body>
</html>';
//echo $mainData;
include("../mpdf/mpdf.php");
$filename='scoreSheet-'.$deptE.'-'.$levelName.'.pdf';
$mpdf=new mPDF('c');
$mpdf->AddPage('P','','','','',5,5,5,5,5,5);
$mpdf->SetWatermarkImage('../images/logoBack.png');
$mpdf->showWatermarkImage = true;
$mpdf->WriteHTML($mainData);
$mpdf->Output($filename,'D');
//$mpdf->Output();
ob_end_flush();
exit;