| Server IP : 199.250.214.225 / Your IP : 3.149.250.166 Web Server : Apache System : Linux vps64074.inmotionhosting.com 3.10.0-1160.105.1.vz7.214.3 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64 User : nicngo5 ( 1001) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /home/nicngo5/consolidated/ |
Upload File : |
<?php
require_once('business logic/classes/users.php');
//
$user = new User();
$uid = $_SESSION['uid'];
$access = $_SESSION['acc'];
//
if (!$user->get_session())
{
header("location:myown_mainpage.php?you are not login");
}
//
if (isset($_GET['q']) and $_GET['q'] == 'logout')
{
$user->user_logout();
header("location:myown_mainpage.php? you are log out");
}
if (isset($_SESSION['mth']) and isset($_SESSION['yr']) and isset($_SESSION['bank']) and isset($_SESSION['cadre']))
{
$mth = mysql_real_escape_string($_SESSION['mth']);
$yr = mysql_real_escape_string($_SESSION['yr']);
$cadre = mysql_real_escape_string($_SESSION['cadre']);
$bank = mysql_real_escape_string($_SESSION['bank']);
$bgroup = mysql_real_escape_string($_SESSION['bgroup']);
//$division = mysql_real_escape_string($_SESSION['division']);
}
//
?>
<!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" />
<link rel="shortcut icon" href="images/favicon.ico">
<title>National Industrial Court of Nigeria...::...Payroll</title>
<style type="text/css">
<!--
body {
background-image: url(images/nicn_bg.jpg);
}
body,td,th {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 16px;
}
.style1 {color: #006600}
-->
</style><body>
<div align="center"><h2><span class="style1">NATIONAL INDUSTRIAL COURT OF NIGERIA<br />
PAYROLL</span><br />
</h2>
</div>
<table width="1706" border="0" cellpadding="0" cellspacing="0" style="font-size:18px" >
<tr>
<td colspan="2">Payroll P.V. No:</td>
<td><div align="left">Sheet No:</div></td>
</tr>
<tr>
<td colspan="3"><h3>MINISTRY/DEPARTMENT: NATIONAL INDUSTRIAL COURT OF NIGERIA</h3></td>
</tr>
<tr>
<td width="726">
<strong>MONTH ENDING: <?php echo strtoupper($mth)." ".$yr ;?></strong><br/> </td>
<td width="521"> </td>
<td width="459" align="right"></h3>
<div align="left">Date Printed: <?php echo date("l, F d, Y"); ?></div></td>
</tr>
<tr>
<td colspan="2"><strong><?php echo $bank.' '.$bkgroup; ?></strong> </td>
<td> </td>
</tr>
</table>
<table width="2330" border="1" cellpadding="4" cellspacing="0">
<tr>
<td width="44" rowspan="2" align="center" valign="middle"><strong>FILE NO</strong></td>
<td width="116" rowspan="2" align="center" valign="middle"><strong>NAME</strong></td>
<td colspan="3" align="center" valign="top"><strong>EARNINGS</strong></td>
<td colspan="9" align="center" valign="top"><strong>DEDUCTIONS</strong></td>
<td width="118" rowspan="2" align="center" valign="middle"><strong>TOTAL DEDUCT.</strong></td>
<td width="127" rowspan="2" align="center" valign="middle"><strong>BASIC ALLOW.</strong></td>
<td width="114" rowspan="2" align="center" valign="middle"><strong>GROSS PAY</strong></td>
<td width="114" rowspan="2" align="center" valign="middle"><strong>NET BASIC SALARY</strong></td>
<td width="132" rowspan="2" align="center" valign="middle"><strong>TOTAL EMOL.</strong></td>
</tr>
<tr>
<td width="101" align="center" valign="middle"><strong>SALARY (BASIC)</strong></td>
<td width="133" align="center" valign="middle"><strong>ARREARS (BASIC)</strong></td>
<td width="163" align="center" valign="middle"><strong>GROSS EMOLU</strong></td>
<td width="178" align="center" valign="middle"><strong>TAX</strong></td>
<td width="178" align="center" valign="middle"><strong>MOTOR VEHICLE ADV.</strong></td>
<td width="89" align="center" valign="middle"><strong>PENSION</strong></td>
<td width="89" align="center" valign="middle"><strong>NICN COOP</strong></td>
<td width="82" align="center" valign="middle"><strong>RENT & WATER</strong></td>
<td width="55" align="center" valign="middle"><strong>LOAN</strong></td>
<td width="101" align="center" valign="middle"><strong>PERSONAL ASST.</strong></td>
<td width="102" align="center" valign="middle"><strong>JUDGES' CONTRIB.</strong></td>
<td width="102" align="center" valign="middle"><strong>NHF</strong></td>
</tr>
<?php
$sql1 = "select a.fileNo, title, surname, first_name, othernames, a.rank, basic_salary, arrears_basic, gross_emolument, utility, servant,
entertainment, personal_assistant,motor_maintain, hardship, newspaper, outfit, leave_b, arrears_allowance, tax, motorAdv, rent_water, nhf, loan,
personal_assistant_deduct, pension, nicncoop, j_contribution, total_allow, total_deduction, net_pay, gross_pay, totalEmolu from tbl_conpayment a
JOIN tblper b ON (a.fileNo = b.fileNo) WHERE (a.month = '$mth') and (a.year = '$yr') and (b.bank = '$bank') and (b.bankGroup='$bgroup') and a.rank = '$cadre' ";
$result = mysql_query($sql1) or die(mysql_error());//limit $eu, $limit
$bstotal = 0;
$abtotal = 0;
$cetotal = 0;
$utility = 0;
$dom_serv = 0;
$entertainment = 0;
$pa = 0;
$maint = 0;
$hardship = 0;
$newspaper = 0;
$outfit = 0;
$leave = 0;
$arr_all = 0;
$taxtotal = 0;
$motorAdvtotal = 0;
$rent_water = 0;
$nhftotal = 0;
$deduct_pa = 0;
$nhf = 0;
$to_all = 0;
$to_allow = 0;
$tdtotal = 0;
$gptotal = 0;
$nptotal = 0;
$tetotal = 0;
$nicncooptotal = 0;
$j_contribution = 0;
while($row = mysql_fetch_array($result))
{ ?>
<tr>
<td align="right"><?php echo $row['fileNo']; ?></td>
<td align="left" valign="middle" nowrap="nowrap"><?php echo $row['title']." ".$row['surname']." ".$row['first_name']." ".$row['othernames']; ?></td>
<td width="101" align="right"><?php $bstotal += $row['basic_salary']; echo number_format($row['basic_salary'], 2, '.', ','); ?></td>
<td align="right"><?php $abtotal += $row['arrears_basic']; echo number_format($row['arrears_basic'], 2, '.', ','); ?></td>
<td align="right"><?php $cetotal += $row['gross_emolument']; echo number_format($row['gross_emolument'], 2, '.', ','); ?></td>
<td width="178" align="right" valign="middle"><?php $taxtotal += $row['tax']; echo number_format($row['tax'], 2, '.', ','); ?></td>
<td width="178" align="right" valign="middle"><?php $motorAdvtotal += $row['motorAdv']; echo number_format($row['motorAdv'], 2, '.', ','); ?></td>
<td width="89" align="right" valign="middle"><?php $pensiontotal += $row['pension']; echo number_format($row['pension'], 2, '.', ','); ?></td>
<td width="89" align="right" valign="middle"><?php $nicncooptotal += $row['nicncoop']; echo number_format($row['nicncoop'], 2, '.', ','); ?></td>
<td width="82" align="right"><?php $rent_water += $row['rent_water']; echo number_format($row['rent_water'], 2, '.', ','); ?></td>
<td width="55" align="right"><?php $loan += $row['loan']; echo number_format($row['loan'], 2, '.', ','); ?></td>
<td width="101" align="right"><?php $deduct_pa += $row['personal_assistant_deduct'];
echo number_format($row['personal_assistant_deduct'], 2, '.', ','); ?></td>
<td align="right"><?php $j_contribution += $row['j_contribution'];
echo number_format($row['j_contribution'], 2, '.', ','); ?></td>
<td align="right"><?php $nhf += $row['nhf']; echo number_format($row['nhf'], 2, '.', ','); ?></td>
<td width="118" align="right"><?php $tdtotal += $row['total_deduction']; echo number_format($row['total_deduction'], 2, '.', ','); ?></td>
<td width="127" align="right"><?php $total_allow += $row['total_allow']; echo number_format($row['total_allow'], 2, '.', ','); ?></td>
<td width="114" align="right"><?php $gptotal += $row['gross_pay']; echo number_format($row['gross_pay'], 2, '.', ','); ?></td>
<td width="114" align="right"><?php $nptotal += $row['net_pay']; echo number_format($row['net_pay'], 2, '.', ','); ?></td>
<td width="132" align="right"><?php $tetotal += $row['totalEmolu']; echo number_format($row['totalEmolu'], 2, '.', ','); ?></td>
</tr>
<?php } ?>
<tr><td colspan="2" align="right"><strong>TOTAL</strong></td>
<td align="right"><strong><?php echo number_format($bstotal, 2, '.', ','); ?></strong></td>
<td align="right"><strong><?php echo number_format($abtotal, 2, '.', ','); ?></strong></td>
<td align="right"><strong><?php echo number_format($cetotal, 2, '.', ','); ?></strong></td>
<td align="right"><strong><?php echo number_format($taxtotal, 2, '.', ','); ?></strong></td>
<td align="right"><strong><?php echo number_format($motorAdvtotal, 2, '.', ','); ?></strong></td>
<td align="right"><strong><?php echo number_format($pensiontotal, 2, '.', ','); ?></strong></td>
<td align="right"><strong><?php echo number_format($nicncooptotal, 2, '.', ','); ?></strong></td>
<td align="right"><strong><?php echo number_format($rent_water, 2, '.', ','); ?></strong></td>
<td align="right"><strong><?php echo number_format($loan, 2, '.', ','); ?></strong></td>
<td align="right"><strong><?php echo number_format($deduct_pa, 2, '.', ','); ?></strong></td>
<td align="right"><strong><?php echo number_format($j_contribution, 2, '.', ','); ?></strong></td>
<td align="right"><strong><?php echo number_format($nhf, 2, '.', ','); ?></strong></td>
<td align="right"><strong><?php echo number_format($tdtotal, 2, '.', ','); ?></strong></td>
<td align="right"><strong><?php echo number_format($total_allow, 2, '.', ','); ?></strong></td>
<td align="right"><strong><?php echo number_format($gptotal, 2, '.', ','); ?></strong></td>
<td align="right"><strong><?php echo number_format($nptotal, 2, '.', ','); ?></strong></td>
<td align="right"><strong><?php echo number_format($tetotal, 2, '.', ','); ?></strong></td>
</tr>
</table>
</body>
</html>
<?php $user->close();?>