| Server IP : 199.250.214.225 / Your IP : 18.117.229.181 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/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['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']);
//$division = mysql_real_escape_string($_SESSION['division']);
$bgroup = mysql_real_escape_string($_SESSION['bgroup']);
}
//
?>
<!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 Summary Voucher</title>
<style type="text/css">
<!--
body,td,th {
font-size: 15px;
font-family: Verdana, Geneva, sans-serif;
}
body {
background-image: url(images/nicn_bg.jpg);
}
.style2 {color: #003300}
-->
</style>
<script type="text/javascript" src="js/number_to_word.js">
</script>
<body onload="lookup(); gross();">
<div align="center"><strong><span class="style2"><h3><br />
<br />
<br />
NATIONAL INDUSTRIAL COURT OF NIGERIA PAYROLL SUMMARY VOUCHER <?php echo $dv;?> DIVISION</h3></span>
</strong></div>
<br />
<?php
$sql = "select b.basic_salary, b.arrears_basic, b.gross_emolument, tax, utility, servant, entertainment, personal_assistant,
motor_maintain, hardship, newspaper, outfit, leave_b, arrears_allowance, tax,motorAdv,nicncoop, rent_water, loan, pension, nhf, j_contribution, personal_assistant_deduct, pension, b.total_allow, b.total_deduction, b.gross_pay, b.net_pay, b.totalEmolu from tblper a, tbl_conpayment b WHERE a.fileNo = b.fileNo and month = '$mth' and year = '$yr' and bank = '$bank' and a.bankGroup = '$bgroup' and b.rank='$cadre' ";
$result = mysql_query($sql) or die(mysql_error());
$bs = 0;
$arrearsB = 0;
$cumEmolu = 0;
$tax =0;
$pension=0;
$nhf=0;
$rent_water = 0;
$loan = 0;
$pa_deduct = 0;
$totalDeduct=0;
$motorBasic=0;
$grosspay=0;
$netpay=0;
$totalEmolu=0;
$motorAdv= 0;
$j_contribution = 0;
while($rows = mysql_fetch_array($result))
{
$bs += $rows['basic_salary'];
$arrearsB += $rows['arrears_basic'];
$cumEmolu += $rows['gross_emolument'];
$tax += $rows['tax'];
$pension += $rows['pension'];
$nicncoop += $rows['nicncoop'];
$rent_water += $rows['rent_water'];
$loan += $rows['loan'];
$motorAdv += $rows['motorAdv'];
$pa_deduct += $rows['personal_assistant_deduct'];
$j_contribution += $rows['j_contribution'];
$nhf += $rows['nhf'];
$totalDeduct += $rows['total_deduction'];
$motorBasic += $rows['total_allow'];
$grosspay += $rows['gross_pay'];
$netpay += $rows['net_pay'];
$totalEmolu += $rows['totalEmolu'];
}
$sum = $rows['tax']+$rows['pension']+$rows['nhf']+$rows['unionDues']+$rows['ugv']+$rows['nicncoop']+$rows['ctlsLab'];
$sum += $rows['ctlsFed']+$rows['motorAdv']+$rows['bicycleAdv'];
?>
<div align="left"><strong><?php echo $bank." ".$bankGroup; ?></strong></div><div align="right">
<p>MONTH ENDING: <?php echo strtoupper($mth)." ".$yr ;?></p>
<table width="1933" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="118" align="center" valign="middle"><strong>BASIC SALARY</strong></td>
<td width="120" align="center" valign="middle"><strong>ARREARS (BASIC)</strong></td>
<td width="136" align="center" valign="middle"><strong>GROSS EMOLU</strong></td>
<td width="107" align="center" valign="middle"><strong>TAX THIS MONTH</strong></td>
<td width="107" align="center" valign="middle"><strong>MOTOR VEHICLE ADV.</strong></td>
<td width="108" align="center" valign="middle"><strong>PENSION</strong></td>
<td width="108" align="center" valign="middle"><strong>NICN COOP</strong></td>
<td width="101" align="center" valign="middle"><strong>RENT & WATER</strong></td>
<td width="99" align="center" valign="middle"><strong>LOAN</strong></td>
<td width="112" align="center" valign="middle"><strong>PERSONAL ASST.</strong></td>
<td width="81" align="center" valign="middle"><strong>JUDGES' CONTRIB.</strong></td>
<td width="81" align="center" valign="middle"><strong>NHF</strong></td>
<td width="112" align="center" valign="middle"><strong>TOTAL DEDUCTION</strong></td>
<td width="120" align="center" valign="middle"><strong>MOTOR BASIC ALLW</strong></td>
<td width="99" align="center" valign="middle"><strong>GROSS PAY</strong></td>
<td width="102" align="center" valign="middle"><strong>NET PAY</strong></td>
<td width="124" align="center"><strong>TOTAL NET EMOLU </strong></td>
<td width="60"><strong>PAY ROLL NO.</strong></td>
</tr>
<tr>
<td><div align="right"><strong><?php echo number_format($bs, 2, '.', ','); ?></strong></div></td>
<td><div align="right"><strong><?php echo number_format($arrearsB, 2, '.', ','); ?></strong></div></td>
<td><div align="right"><strong><?php echo number_format($cumEmolu, 2, '.', ','); ?></strong></div></td>
<td><div align="right"><strong><?php echo number_format($tax, 2, '.', ','); ?></strong></div></td>
<td><div align="right"><strong><?php echo number_format($motorAdv, 2, '.', ','); ?></strong></div></td>
<td><div align="right"><strong><?php echo number_format($pension, 2, '.', ','); ?></strong></div></td>
<td><div align="right"><strong><?php echo number_format($nicncoop, 2, '.', ','); ?></strong></div></td>
<td><div align="right"><strong><?php echo number_format($rent_water, 2, '.', ','); ?></strong></div></td>
<td><div align="right"><strong><?php echo number_format($loan, 2, '.', ','); ?></strong></div></td>
<td><div align="right"><strong><?php echo number_format($pa_deduct, 2, '.', ','); ?></strong></div></td>
<td align="right"><strong><?php echo number_format($j_contribution, 2, '.', ','); ?></strong></td>
<td><div align="right"><strong><?php echo number_format($nhf, 2, '.', ','); ?></strong></div></td>
<td><div align="right"><strong>
<?php
//$addDeduct =$bicycleAdv + $motorAdv + $ctlsFed + $ctlsLab + $nicncoop + $ugv + $unionDues + $nhf + $pension + $tax;
// $totalDeduct += 6;
$addDeduct =$bicycleAdv + $motorAdv + $ctlsFed + $ctlsLab + $nicncoop + $ugv + $unionDues + $nhf + $pension + $tax;
echo number_format($totalDeduct, 2, '.', ','); ?>
</strong></div></td>
<td><div align="right"><strong><?php echo number_format($motorBasic, 2, '.', ','); ?></strong></div></td>
<td><div align="right"><strong><?php
$grosspay = $cumEmolu + $motorBasic;
echo number_format($grosspay, 2, '.', ','); ?></strong></div></td>
<td><div align="right"><strong><?php echo number_format($netpay, 2, '.', ','); ?></strong></div></td>
<td><div align="right"><strong><?php
//$totalEmolu = 6990899.53 - $totalDeduct;
echo number_format($totalEmolu, 2, '.', ','); ?></strong></div></td>
<td> </td>
</tr>
</table>
<p> </p>
</div>
<br />
<table width="1400" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="left" valign="top"></td>
<td width="700" rowspan="3" align="right" valign="top">
<div align="left" style="width:500px">
<p align="center"><strong>PAYMENT AUTHORISATION</strong></p>
<p align="left">I HEREBY CERTIFY THAT the above is a correct statement of the amount payable to the person named on
Min./Dept.
Payroll sheet Nos........................................................... for the month ending</p>
<p align="left"> <?php echo strtoupper($mth)." ".$yr ;?> </p>
<p align="left">That their employment at the rate of salary shown was duly authorised by
....................................................................................................... the amount of Gross payment per voucher in word:
<script type="text/javascript">
var amount1 = "";
var amount1 = "<?php echo number_format($grosspay, 2, '.', '') ; ?>";
var money1 = amount1.split('.');
function gross()
{
var words;
var naira = money1[0];
var kobo = money1[1];
var word1 = toWords(naira)+" naira";
var word2 = ", "+toWords(kobo)+" kobo";
if(kobo != "00")
words = word1+word2;
else
words = word1;
document.getElementById('result2').innerHTML = words.toUpperCase();
}
</script>
<span id="result2"></span>
</p>
<p align="left"> may be paid under the Heads and items shown
....................................................................................Signature
...................................................................................Title
...................................................................20.............. </p>
<p align="center" class="style1">TO BE SIGNED BY DULY AUTHORISED OFFICER </p>
</div>
<p align="left"> </p>
<p align="left"> </p>
<p align="left"> </p>
<p align="left"> </p>
<p align="left"> </p>
<p align="left"> </p>
<p align="left"><strong>AMOUNT OF CHEQUE PAYABLE:
<img src="images/naira.jpg" /> <?php echo number_format($totalEmolu, 2, '.', ','); ?></strong></p>
<p align="left">AMOUNT IN WORDS</p>
<p align="left">
<script type="text/javascript">
var amount = "";
var amount = "<?php echo number_format($totalEmolu, 2, '.', '') ; ?>";
var money = amount.split('.');
function lookup()
{
var words;
var naira = money[0];
var kobo = money[1];
var word1 = toWords(naira)+" naira";
var word2 = ", "+toWords(kobo)+" kobo";
if(kobo != "00")
words = word1+word2;
else
words = word1;
document.getElementById('result').innerHTML = words.toUpperCase();
}
</script>
<span id="result"></span>
</p></td>
</tr>
<tr>
<td align="center" valign="top"><strong>PAYMENT VOUCHER EMOLUMENTS </strong></td>
</tr>
<tr>
<td align="center" valign="top">
<table width="560" border="0" align="left" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
<td><div align="center"><strong>AMOUNT</strong> <strong><img src="images/naira.jpg" /></strong></div></td>
</tr>
<tr>
<td width="394">GROSS EMOLUMENTS FOR THE MONTH <?php echo strtoupper($mth)." ".$yr ;?></td>
<td width="166"><div align="right"><?php echo number_format($cumEmolu, 2, '.', ','); ?></div></td>
</tr>
<tr>
<td>BASIC ALLOWANCES PER VOUCHER <?php echo strtoupper($mth)." ".$yr ;?></td>
<td><div align="right"><?php echo number_format($motorBasic, 2, '.', ','); ?></div></td>
</tr>
<tr>
<td>GROSS PAYMENT PER VOUCHER </td>
<td><div align="right"><?php
$grosspay = $cumEmolu + $motorBasic;
//6990899.53
echo number_format($grosspay, 2, '.', ','); ?></div></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="2" align="left" bordercolor="#FFFFFF"><table width="688" cellpadding="0" cellspacing="0" border="1" align="left">
<tr>
<td width="233"><strong>Recoveries from Officers</strong></td>
<td width="152"> </td>
<td width="295"><div align="center"><strong>Subhead</strong></div></td>
</tr>
<tr>
<td>INCOME TAX: Federal</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>INCOME TAX: Northern Region</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>INCOME TAX: Western Region</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td align="left">INCOME TAX: Eastern Region</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>TAX</td>
<td><div align="right"><?php echo number_format($tax, 2, '.', ','); ?></div></td>
<td align="center" valign="middle">41040101</td>
</tr>
<tr>
<td>PENSION</td>
<td><div align="right"><?php echo number_format($pension, 2, '.', ','); ?> </div></td>
<td align="center" valign="middle">41040202</td>
</tr>
<tr>
<td>RENT & WATER</td>
<td><div align="right"><?php echo number_format($rent_water, 2, '.', ','); ?></div></td>
<td align="center" valign="middle">41040206</td>
</tr>
<tr>
<td>LOAN</td>
<td><div align="right"><?php echo number_format($loan, 2, '.', ','); ?></div></td>
<td align="center" valign="middle">41040203</td>
</tr>
<tr>
<td>PERSONAL ASSISTANT</td>
<td><div align="right"><?php echo number_format($pa_deduct, 2, '.', ','); ?></div></td>
<td align="center" valign="middle">12020704</td>
</tr>
<tr>
<td>NHF</td>
<td><div align="right"><?php echo number_format($nhf, 2, '.', ','); ?></div></td>
<td align="center" valign="middle">41040206</td>
</tr>
<tr>
<td>MOTOR VEHICLE ADVANCE</td>
<td><div align="right"><?php echo number_format($motorAdv, 2, '.', ','); ?></div></td>
<td align="center" valign="middle">12021001</td>
</tr>
<tr>
<td>NICN COOP</td>
<td><div align="right"><?php echo number_format($nicncoop, 2, '.', ','); ?></div></td>
<td align="center" valign="middle">41040205</td>
</tr>
<tr>
<td>JUDGES' CONTRIBUTION</td>
<td><div align="right"><?php echo number_format($j_contribution, 2, '.', ','); ?></div></td>
<td align="center" valign="middle"> </td>
</tr>
<tr>
<td> </td>
<td><div align="right"></div></td>
<td align="center" valign="middle"> </td>
</tr>
<tr>
<td> </td>
<td><div align="right"></div></td>
<td align="center" valign="middle"> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td align="center" valign="middle"> </td>
</tr>
<tr>
<td>MISCELLANOUS A</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>MISCELLANOUS B</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>MISCELLANOUS C</td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>TOTAL RECOVERIES ON VOUCHER</td>
<td><div align="right"><strong><img src="images/naira.jpg" />
<?php
$addDeduct = $pa_deduct + $rent_water + $loan + $nhf + $pension + $tax + $motorAdv + $nicncoop + $j_contribution;
echo number_format( $addDeduct, 2, '.', ','); ?>
</strong></div></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
<table width="400" border="0">
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
</table>
<table width="553" border="1" align="left" cellpadding="0" cellspacing="0">
<tr>
<td width="138"><div align="center">DETAIL</div></td>
<td width="96"><div align="center">SIGNATURE</div></td>
<td width="205"><div align="center">NAME IN BLOCK LETTER</div></td>
<td width="111"><div align="center">DATE</div></td>
</tr>
<tr>
<td>Prepared by</td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Checked by</td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Entered in Vote Book</td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Passed by</td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Paid by</td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table> </td>
</tr>
</table> </td>
</tr>
</table>
</body>
</html>
<?php $user->close();?>