| Server IP : 199.250.214.225 / Your IP : 18.219.127.161 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
session_start();
//$con = mysqli_connect("localhost","root","","payroll3");
$con = mysqli_connect("localhost","nicngov_payroll","_nicn.payroll@","nicngov_payroll");
//define('DB_SERVER', 'localhost');//
//define('DB_USERNAME', 'sanfas93_payroll');//nicn
//define('DB_PASSWORD', '_nicn.payroll');//
//define('DB_DATABASE', 'sanfas93_payroll');//payroll
$fileno = $_GET['fno'];
$year = $_GET['year'];
$details = mysqli_query($con, "select * from tblper join tblbanklist on tblper.bank = tblbanklist.bank where tblper.fileno = $fileno ");
foreach ($details as $k) {
$grade = $k['grade'];
$step = $k['step'];
$bank = $k['bank'];
$AccNo = $k['AccNo'];
$surname = $k['surname'];
$firstname = $k['first_name'];
$othernames = $k['othernames'];
$rank = $k['rank'];
$appointment_date = $k['appointment_date'];
$dob = $k['dob'];
}
$arrears = mysqli_query($con, " select * from tblarrears where year = 2016 and fileno = 1002");
foreach ($arrears as $key) {
}
$arr = array();
$app = array();
foreach ($arrears as $key) {
if($key['type'] == 'new-appointment')
$app[] = $key['month'];
else
$arr[] = $key['month'];
}
$data['year'] = $year;
$data['arr'] = $arr;
$data['app'] = $app;
$query = mysqli_query($con, "select * from tblper join tbl_conpayment on tbl_conpayment.fileno = tblper.fileNo where tblper.fileNo='$fileno' and tbl_conpayment.year = '$year' ");
$result = array();
foreach ($query as $value)
{
$month = strtoupper($value['month']);
$result[$month]['basic_salary'] = $value['basic_salary'];
// var_dump($value);
$result[$month]['arrears_basic'] = $value['arrears_basic'];
$result[$month]['tax'] = $value['tax'];
//$result[$month]['pension'] = $value['pension'];
//$result[$month]['nhf'] = $value['nhf'];
//$result[$month]['unionDues'] = $value['unionDues'];
//$result[$month]['ugv'] = $value['ugv'];
$result[$month]['nicncoop'] = $value['nicncoop'];
$result[$month]['ctlslab'] = $value['ctlslab'];
//$result[$month]['ctlsFed'] = $value['ctlsFed'];
//$result[$month]['fedhousing'] = $value['fedhousing'];
$result[$month]['surcharge'] = $value['surcharge'];
//$result[$month]['bicycleAdv'] = $value['bicycleAdv'];
//$result[$month]['cumEmolu'] = $value['cumEmolu'];
$result[$month]['rent_water'] = $value['rent_water'];
$result[$month]['j_contribution'] = $value['j_contribution'];
$result[$month]['gross_emolument'] = $value['gross_emolument'];
$result[$month]['motorBasicAll'] = $value['motorAdv'];
//$result[$month]['phoneCharges'] = $value['phoneCharges'];
$result[$month]['pa_deduct'] = $value['personal_assistant_deduct'];
$result[$month]['totalDeduct'] = $value['total_deduction'];
$result[$month]['netpay'] = $value['net_pay'];
$result[$month]['grosspay'] = $value['gross_pay'];
$result[$month]['totalEmolu'] = $value['totalEmolu'];
//var_dump($result);
}
$fullmonth=array("JANUARY","FEBRUARY","MARCH","APRIL","MAY","JUNE","JULY", "AUGUST","SEPTEMBER","OCTOBER","NOVEMBER", "DECEMBER" );
$rowcount=0;
$empty=0.0;
for ($row = 0; $row <=11; $row++)
{
$currentmonth=$fullmonth[$row];
if (!isset($result[$currentmonth]['basic_salary']))
{
$result[$currentmonth]['basic_salary'] = $empty;
$result[$currentmonth]['arrears_basic'] = $empty;
$result[$currentmonth]['tax'] = $empty;
$result[$currentmonth]['pension'] = $empty;
$result[$currentmonth]['nhf'] = $empty;
$result[$currentmonth]['unionDues'] = $empty;
$result[$currentmonth]['ugv'] = $empty;
$result[$currentmonth]['nicncoop'] = $empty;
$result[$currentmonth]['ctlslab'] = $empty;
$result[$currentmonth]['ctlsFed'] = $empty;
$result[$currentmonth]['fedhousing'] = $empty;
$result[$currentmonth]['surcharge'] = $empty;
$result[$currentmonth]['bicycleAdv'] = $empty;
$result[$currentmonth]['cumEmolu'] = $empty;
$result[$currentmonth]['motorBasicAll'] = $empty;
$result[$currentmonth]['phoneCharges'] = $empty;
$result[$currentmonth]['pa_deduct'] = $empty;
$result[$currentmonth]['totalDeduct'] =$empty;
$result[$currentmonth]['netpay'] = $empty;
$result[$currentmonth]['grosspay'] = $empty;
$result[$currentmonth]['totalEmolu'] = $empty;
$result[$currentmonth]['gross_emolument'] = $empty;
$result[$currentmonth]['j_contribution'] = $empty;
$result[$currentmonth]['rent_water'] = $empty;
}
}
$data_result = $result;
?>
<!DOCTYPE html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>National Industrial Court of Nigeria</title>
<!-- Tell the browser to be responsive to screen width -->
<meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
<link rel="stylesheet" href="bootstrap.min.css">
<!-- AdminLTE Skins. Choose a skin from the css/skins
folder instead of downloading all of them to reduce the load. -->
<!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
<!--[if lt IE 9]>
<script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
<script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
<![endif]-->
<script> var murl = "{{ url('/')}}"; </script>
</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...::...PeCard Report</title>
<style type="text/css">
@media print
{
.no-print, .no-print *
{
display: none !important;
}
}
</style>
<body>
<div class="row">
<div class="col-md-12">
<div align="center"><h2 class="text-success text-center">FEDERAL GOVERNMENT OF NIGERIA<br />
</h2>
</div>
<h3 class=" text-center">MINISTRY/DEPARTMENT: NATIONAL INDUSTRIAL COURT OF NIGERIA </h3>
<?php
//$fileno = $details->fileNo;
?>
<table class="table" border="1" >
<tr>
<td>
<table class="table table-hover" border="1" cellpadding="0" cellspacing="0" >
<tr>
<td width="44%">Min/Dept<br />Control No</td>
<td width="56%">JR:1</td>
</tr>
<tr>
<td>File No</td>
<td> <?php echo $fileno; ?>
</td>
</tr>
<tr>
<td>Grade</td>
<td><?php echo $grade; ?></td>
</tr>
<tr>
<td>Step</td>
<td><?php echo $step; ?></td>
</tr>
<tr>
<td>Bank</td>
<td><?php $bank; ?> </td>
</tr>
<tr>
<td>Account No</td>
<td><?php echo $AccNo; ?> </td>
</tr>
<tr>
<td>Name</td>
<td><?php echo $surname ." ". $firstname; ?> </td>
</tr>
<tr>
<td>Rank</td>
<td>
<?php echo $rank; ?>
</td>
</tr>
<tr>
<td>Commenced</td>
<td> <?php echo date("d-m-Y", strtotime($appointment_date)) ?> </td>
</tr>
<tr>
<td>DOB</td>
<td><?php echo date("d-m-Y", strtotime($dob)); ?> </td>
</tr>
<tr>
<td>Children</td>
<td> </td>
</tr>
<tr>
<td>Residential Address</td>
<td valign="top"> </td>
</tr>
<tr>
<td>Leave Address</td>
<td> </td>
</tr>
<tr>
<td>Employee Type</td>
<td> Staff</td>
</tr>
<tr>
<td>Arrears this year</td>
<td>
</td>
</tr>
<tr>
<td>New appointment</td>
<td>
</td>
</tr>
</table>
</td>
<td >
<table width="100%" border="1" cellpadding="0" cellspacing="0">
<tr>
<td width="300"><strong>MONTH</strong></td>
<td width="100" align="center"><strong>JAN/<?php echo $year; ?></strong></td>
<td width="100" align="center"><strong>FEB/<?php echo $year; ?></strong></td>
<td width="100" align="center"><strong>MAR/<?php echo $year; ?></strong></td>
<td width="100" align="center"><strong>APR/<?php echo $year; ?></strong></td>
<td width="100" align="center"><strong>MAY/<?php echo $year; ?></strong></td>
<td width="100" align="center"><strong>JUN/<?php echo $year; ?></strong></td>
<td width="100" align="center"><strong>JUL/<?php echo $year; ?></strong></td>
<td width="100" align="center"><strong>AUG/<?php echo $year; ?></strong></td>
<td width="100" align="center"><strong>SEP/<?php echo $year; ?></strong></td>
<td width="100" align="center"><strong>OCT/<?php echo $year; ?></strong></td>
<td width="100" align="center"><strong>NOV/<?php echo $year; ?></strong></td>
<td width="100" align="center"><strong>DEC/<?php echo $year; ?></strong></td>
</tr>
<tr>
<td>Salary</td>
<td align="right"><?php echo number_format($result['JANUARY']['basic_salary'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['FEBRUARY']['basic_salary'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['MARCH']['basic_salary'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['APRIL']['basic_salary'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['MAY']['basic_salary'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['JUNE']['basic_salary'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['JULY']['basic_salary'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['AUGUST']['basic_salary'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['SEPTEMBER']['basic_salary'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['OCTOBER']['basic_salary'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['NOVEMBER']['basic_salary'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['DECEMBER']['basic_salary'], 2, '.', ','); ?>
</td>
</tr>
<tr>
<td>Acting Allowance</td>
<td align="right">
<?php $sum=0;
$sum=$result['JANUARY']['arrears_basic'];
echo number_format($sum, 2, '.', ',');
?>
</td>
<td align="right">
<?php $sum=0;
$sum=$result['FEBRUARY']['arrears_basic'];
echo number_format($sum, 2, '.', ',');
?>
</td>
<td align="right">
<?php $sum=0;
$sum=$result['MARCH']['arrears_basic'];
echo number_format($sum, 2, '.', ',');
?>
</td>
<td align="right">
<?php $sum=0;
$sum=$result['APRIL']['arrears_basic'];
echo number_format($sum, 2, '.', ',');
?>
</td>
<td align="right">
<?php $sum=0;
$sum=$result['MAY']['arrears_basic'];
echo number_format($sum, 2, '.', ',');
?>
</td>
<td align="right">
<?php $sum=0;
$sum=$result['JUNE']['arrears_basic'];
echo number_format($sum, 2, '.', ',');
?>
</td>
<td align="right">
<?php $sum=0;
$sum=$result['JULY']['arrears_basic'];
echo number_format($sum, 2, '.', ',');
?>
</td>
<td align="right">
<?php $sum=0;
$sum=$result['AUGUST']['arrears_basic'];
echo number_format($sum, 2, '.', ',');
?>
</td>
<td align="right">
<?php $sum=0;
$sum=$result['SEPTEMBER']['arrears_basic'];
echo number_format($sum, 2, '.', ',');
?>
</td>
<td align="right">
<?php $sum=0;
$sum=$result['OCTOBER']['arrears_basic'];
echo number_format($sum, 2, '.', ',');
?>
</td>
<td align="right">
<?php $sum=0;
$sum=$result['NOVEMBER']['arrears_basic'];
echo number_format($sum, 2, '.', ',');
?>
</td>
<td align="right">
<?php $sum=0;
$sum=$result['DECEMBER']['arrears_basic'];
echo number_format($sum, 2, '.', ',');
?>
</td>
</tr>
<tr>
<td>Gross Emolument for month</td>
<td align="right">
<?php echo number_format($result['JANUARY']['gross_emolument'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['FEBRUARY']['gross_emolument'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['MARCH']['gross_emolument'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['APRIL']['gross_emolument'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['MAY']['gross_emolument'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['JUNE']['gross_emolument'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['JULY']['gross_emolument'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['AUGUST']['gross_emolument'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['SEPTEMBER']['gross_emolument'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['OCTOBER']['gross_emolument'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['NOVEMBER']['gross_emolument'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['DECEMBER']['gross_emolument'], 2, '.', ','); ?>
</td>
</tr>
<!--
<tr>
<td>Cumulative Emolument</td>
<td align="right">
<?php echo number_format($result['JANUARY']['cumEmolu'], 2, '.', ','); ?>
</td>
<td align="right">
<?php
if($result['FEBRUARY']['cumEmolu']==0)
{
echo number_format(0, 2, '.', ',');
}
else
{
$sum=$result['JANUARY']['cumEmolu']+$result['FEBRUARY']['cumEmolu'];
echo number_format($sum, 2, '.', ',');
}
?>
</td>
<td align="right">
<?php
if($result['MARCH']['cumEmolu']==0)
{
echo number_format(0, 2, '.', ',');
}
else
{
$sum=$result['JANUARY']['cumEmolu']+$result['FEBRUARY']['cumEmolu']+$result['MARCH']['cumEmolu'];
echo number_format($sum, 2, '.', ',');
}
?>
</td>
<td align="right">
<?php
if($result['APRIL']['cumEmolu']==0)
{
echo number_format(0, 2, '.', ',');
}
else
{
$sum=$result['JANUARY']['cumEmolu']+$result['FEBRUARY']['cumEmolu']+$result['MARCH']['cumEmolu']+$result['APRIL']['cumEmolu'];
echo number_format($sum, 2, '.', ',');
}
?>
</td>
<td align="right">
<?php
if($result['MAY']['cumEmolu']==0)
{
echo number_format(0, 2, '.', ',');
}
else
{
$sum=$result['JANUARY']['cumEmolu']+$result['FEBRUARY']['cumEmolu']+$result['MARCH']['cumEmolu']+$result['APRIL']['cumEmolu']+$result['MAY']['cumEmolu'];
echo number_format($sum, 2, '.', ',');
}
?>
</td>
<td align="right">
<?php
if($result['JUNE']['cumEmolu']==0)
{
echo number_format(0, 2, '.', ',');
}
else
{
$sum=$result['JANUARY']['cumEmolu']+$result['FEBRUARY']['cumEmolu']+$result['MARCH']['cumEmolu']+$result['APRIL']['cumEmolu']+$result['MAY']['cumEmolu']+$result['JUNE']['cumEmolu'];
echo number_format($sum, 2, '.', ',');
}
?>
</td>
<td align="right">
<?php
if($result['JULY']['cumEmolu']==0)
{
echo number_format(0, 2, '.', ',');
}
else
{
$sum=$result['JANUARY']['cumEmolu']+$result['FEBRUARY']['cumEmolu']+$result['MARCH']['cumEmolu']+$result['APRIL']['cumEmolu']+$result['MAY']['cumEmolu']+$result['JUNE']['cumEmolu']+$result['JULY']['cumEmolu'];
echo number_format($sum, 2, '.', ',');
}
?>
</td>
<td align="right">
<?php
if($result['AUGUST']['cumEmolu']==0)
{
echo number_format(0, 2, '.', ',');
}
else
{
$sum=$result['JANUARY']['cumEmolu']+$result['FEBRUARY']['cumEmolu']+$result['MARCH']['cumEmolu']+$result['APRIL']['cumEmolu']+$result['MAY']['cumEmolu']+$result['JUNE']['cumEmolu']+$result['JULY']['cumEmolu']+$result['AUGUST']['cumEmolu'];
echo number_format($sum, 2, '.', ',');
}
?>
</td>
<td align="right">
<?php
if($result['SEPTEMBER']['cumEmolu']==0)
{
echo number_format(0, 2, '.', ',');
}
else
{
$sum=$result['JANUARY']['cumEmolu']+$result['FEBRUARY']['cumEmolu']+$result['MARCH']['cumEmolu']+$result['APRIL']['cumEmolu']+$result['MAY']['cumEmolu']+$result['JUNE']['cumEmolu']+$result['JULY']['cumEmolu']+$result['AUGUST']['cumEmolu']+$result['SEPTEMBER']['cumEmolu'];
echo number_format($sum, 2, '.', ',');
}
?>
</td>
<td align="right">
<?php
if($result['OCTOBER']['cumEmolu']==0)
{
echo number_format(0, 2, '.', ',');
}
else
{
$sum=$result['JANUARY']['cumEmolu']+$result['FEBRUARY']['cumEmolu']+$result['MARCH']['cumEmolu']+$result['APRIL']['cumEmolu']+$result['MAY']['cumEmolu']+$result['JUNE']['cumEmolu']+$result['JULY']['cumEmolu']+$result['AUGUST']['cumEmolu']+$result['SEPTEMBER']['cumEmolu']+$result['OCTOBER']['cumEmolu'];
echo number_format($sum, 2, '.', ',');
}
?>
</td>
<td align="right">
<?php
if($result['NOVEMBER']['cumEmolu']==0)
{
echo number_format(0, 2, '.', ',');
}
else
{
$sum=$result['JANUARY']['cumEmolu']+$result['FEBRUARY']['cumEmolu']+$result['MARCH']['cumEmolu']+$result['APRIL']['cumEmolu']+$result['MAY']['cumEmolu']+$result['JUNE']['cumEmolu']+$result['JULY']['cumEmolu']+$result['AUGUST']['cumEmolu']+$result['SEPTEMBER']['cumEmolu']+$result['OCTOBER']['cumEmolu']+$result['NOVEMBER']['cumEmolu'];
echo number_format($sum, 2, '.', ',');
}
?>
</td>
<td align="right">
<?php
if($result['DECEMBER']['cumEmolu']==0)
{
echo number_format(0, 2, '.', ',');
}
else
{
$sum=$result['JANUARY']['cumEmolu']+$result['FEBRUARY']['cumEmolu']+$result['MARCH']['cumEmolu']+$result['APRIL']['cumEmolu']+$result['MAY']['cumEmolu']+$result['JUNE']['cumEmolu']+$result['JULY']['cumEmolu']+$result['AUGUST']['cumEmolu']+$result['SEPTEMBER']['cumEmolu']+$result['OCTOBER']['cumEmolu']+$result['NOVEMBER']['cumEmolu']+$result['DECEMBER']['cumEmolu'];
echo number_format($sum, 2, '.', ',');
}
?>
</td>
</tr>-->
<tr>
<td>Tax due to date</td>
<td align="right">
<?php
$sum=$result['JANUARY']['tax'];
echo number_format($sum, 2, '.', ',');
?>
</td>
<td align="right">
<?php
if($result['FEBRUARY']['tax']==0)
{
echo number_format(0, 2, '.', ',');
}
else
{
$sum=$result['JANUARY']['tax']+$result['FEBRUARY']['tax'];
echo number_format($sum, 2, '.', ',');
}
?>
</td>
<td align="right">
<?php
if($result['MARCH']['tax']==0)
{
echo number_format(0, 2, '.', ',');
}
else
{
$sum = $result['JANUARY']['tax']+$result['FEBRUARY']['tax']+$result['MARCH']['tax'];
echo number_format($sum, 2, '.', ',');
}
?>
</td>
<td align="right">
<?php
if($result['APRIL']['tax']==0)
{
echo number_format(0, 2, '.', ',');
}
else
{
$sum=$result['JANUARY']['tax']+$result['FEBRUARY']['tax']+$result['MARCH']['tax']+$result['APRIL']['tax'];
echo number_format($sum, 2, '.', ',');
}
?>
</td>
<td align="right">
<?php
if($result['MAY']['tax']==0)
{
echo number_format(0, 2, '.', ',');
}
else
{
$sum=$result['JANUARY']['tax']+$result['FEBRUARY']['tax']+$result['MARCH']['tax']+$result['MAY']['tax'];
echo number_format($sum, 2, '.', ',');
}
?>
</td>
<td align="right">
<?php
if($result['JUNE']['tax']==0)
{
echo number_format(0, 2, '.', ',');
}
else
{
$sum=$result['JANUARY']['tax']+$result['FEBRUARY']['tax']+$result['MARCH']['tax']+$result['APRIL']['tax']+$result['MAY']['tax']+$result['JUNE']['tax'];
echo number_format($sum, 2, '.', ',');
}
?>
</td>
<td align="right">
<?php
if($result['JULY']['tax']==0)
{
echo number_format(0, 2, '.', ',');
}
else
{
$sum=$result['JANUARY']['tax']+$result['FEBRUARY']['tax']+$result['MARCH']['tax']+$result['APRIL']['tax']+$result['MAY']['tax']+$result['JUNE']['tax']+$result['JULY']['tax'];
echo number_format($sum, 2, '.', ',');
}
?>
</td>
<td align="right">
<?php
if($result['AUGUST']['tax']==0)
{
echo number_format(0, 2, '.', ',');
}
else
{
$sum=$result['JANUARY']['tax']+$result['FEBRUARY']['tax']+$result['MARCH']['tax']+$result['APRIL']['tax']+$result['MAY']['tax']+$result['JUNE']['tax']+$result['JULY']['tax']+$result['AUGUST']['tax'];
echo number_format($sum, 2, '.', ',');
}
?>
</td>
<td align="right">
<?php
if($result['SEPTEMBER']['tax']==0)
{
echo number_format(0, 2, '.', ',');
}
else
{
$sum=$result['JANUARY']['tax']+$result['FEBRUARY']['tax']+$result['MARCH']['tax']+$result['APRIL']['tax']+$result['MAY']['tax']+$result['JUNE']['tax']+$result['JULY']['tax']+$result['AUGUST']['tax']+$result['SEPTEMBER']['tax'];
echo number_format($sum, 2, '.', ',');
}
?>
</td>
<td align="right">
<?php
if($result['OCTOBER']['tax']==0)
{
echo number_format(0, 2, '.', ',');
}
else
{
$sum=$result['JANUARY']['tax']+$result['FEBRUARY']['tax']+$result['MARCH']['tax']+$result['APRIL']['tax']+$result['MAY']['tax']+$result['JUNE']['tax']+$result['JULY']['tax']+$result['AUGUST']['tax']+$result['SEPTEMBER']['tax']+$result['OCTOBER']['tax'];
echo number_format($sum, 2, '.', ',');
}
?>
</td>
<td align="right">
<?php
if($result['NOVEMBER']['tax']==0)
{
echo number_format(0, 2, '.', ',');
}
else
{
$sum=$result['JANUARY']['tax']+$result['FEBRUARY']['tax']+$result['MARCH']['tax']+$result['APRIL']['tax']+$result['MAY']['tax']+$result['JUNE']['tax']+$result['JULY']['tax']+$result['AUGUST']['tax']+$result['SEPTEMBER']['tax']+$result['OCTOBER']['tax']+$result['NOVEMBER']['tax'];
echo number_format($sum, 2, '.', ',');
}
?>
</td>
<td align="right">
<?php
if($result['DECEMBER']['tax']==0)
{
echo number_format(0, 2, '.', ',');
}
else
{
$sum=$result['JANUARY']['tax']+$result['FEBRUARY']['tax']+$result['MARCH']['tax']+$result['APRIL']['tax']+$result['MAY']['tax']+$result['JUNE']['tax']+$result['JULY']['tax']+$result['AUGUST']['tax']+$result['SEPTEMBER']['tax']+$result['OCTOBER']['tax']+$result['NOVEMBER']['tax']+$result['DECEMBER']['tax'];
echo number_format($sum, 2, '.', ',');
}
?>
</td>
</tr>
<tr>
<td>Tax this month</td>
<td align="right">
<?php echo number_format($result['JANUARY']['tax'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['FEBRUARY']['tax'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['MARCH']['tax'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['APRIL']['tax'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['MAY']['tax'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['JUNE']['tax'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['JULY']['tax'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['AUGUST']['tax'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['SEPTEMBER']['tax'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['OCTOBER']['tax'], 2, '.', ','); ?>
</td>
<td align="right">
<?php number_format($result['NOVEMBER']['tax'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['DECEMBER']['tax'], 2, '.', ','); ?>
</td>
</tr>
<tr>
<td>Nicn Coop</td>
<td align="right"> <?php echo number_format($result['JANUARY']['nicncoop'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['FEBRUARY']['nicncoop'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['MARCH']['nicncoop'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['APRIL']['nicncoop'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['MAY']['nicncoop'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['JUNE']['nicncoop'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['JULY']['nicncoop'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['AUGUST']['nicncoop'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['SEPTEMBER']['nicncoop'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['OCTOBER']['nicncoop'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['NOVEMBER']['nicncoop'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['DECEMBER']['nicncoop'], 2, '.', ','); ?>
</td>
</tr>
<tr>
<td>Personal Assistant Deduction</td>
<td align="right"> <?php echo number_format($result['JANUARY']['pa_deduct'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['FEBRUARY']['pa_deduct'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['MARCH']['pa_deduct'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['APRIL']['pa_deduct'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['MAY']['pa_deduct'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['JUNE']['pa_deduct'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['JULY']['pa_deduct'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['AUGUST']['pa_deduct'], 2, '.', ','); ?>
<td align="right"> <?php echo number_format($result['SEPTEMBER']['pa_deduct'], 2, '.', ',');?>
</td>
<td align="right"> <?php echo number_format($result['OCTOBER']['pa_deduct'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['NOVEMBER']['pa_deduct'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['DECEMBER']['pa_deduct'], 2, '.', ','); ?>
</td>
</tr>
<tr>
<td>Rent and Water</td>
<td align="right"> <?php echo number_format($result['JANUARY']['rent_water'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['FEBRUARY']['rent_water'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['MARCH']['rent_water'], 2, '.', ','); ?>
</td>
<td align="right"> <?php number_format($result['APRIL']['rent_water'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['MAY']['rent_water'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['JUNE']['rent_water'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['JULY']['rent_water'], 2, '.', ','); ?>
</td>
<td align="right"> <?php number_format($result['AUGUST']['rent_water'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['SEPTEMBER']['rent_water'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['OCTOBER']['rent_water'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['NOVEMBER']['rent_water'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['DECEMBER']['rent_water'], 2, '.', ','); ?>
</td>
</tr>
<tr>
<td>CTLS Labour</td>
<td align="right"> <?php echo number_format($result['JANUARY']['ctlslab'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['FEBRUARY']['ctlslab'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['MARCH']['ctlslab'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['APRIL']['ctlslab'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['MAY']['ctlslab'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['JUNE']['ctlslab'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['JULY']['ctlslab'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['AUGUST']['ctlslab'], 2, '.', ','); ?>
<td align="right"> <?php echo number_format($result['SEPTEMBER']['ctlslab'], 2, '.', ',');?>
</td>
<td align="right"> <?php echo number_format($result['OCTOBER']['ctlslab'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['NOVEMBER']['ctlslab'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['DECEMBER']['ctlslab'], 2, '.', ','); ?>
</td>
</tr>
<tr>
<td>Surcharge</td>
<td align="right"> <?php echo number_format($result['JANUARY']['surcharge'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['FEBRUARY']['surcharge'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['MARCH']['surcharge'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['APRIL']['surcharge'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['MAY']['surcharge'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['JUNE']['surcharge'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['JULY']['surcharge'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['AUGUST']['surcharge'], 2, '.', ','); ?>
<td align="right"> <?php echo number_format($result['SEPTEMBER']['surcharge'], 2, '.', ',');?>
</td>
<td align="right"> <?php echo number_format($result['OCTOBER']['surcharge'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['NOVEMBER']['surcharge'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['DECEMBER']['surcharge'], 2, '.', ','); ?>
</td>
</tr>
<tr>
<td>Judges Contributions</td>
<td align="right"> <?php echo number_format($result['JANUARY']['j_contribution'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['FEBRUARY']['j_contribution'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['MARCH']['j_contribution'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['APRIL']['j_contribution'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['MAY']['j_contribution'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['JUNE']['j_contribution'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['JULY']['j_contribution'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['AUGUST']['j_contribution'], 2, '.', ','); ?>
<td align="right"> <?php echo number_format($result['SEPTEMBER']['j_contribution'], 2, '.', ',');?>
</td>
<td align="right"> <?php echo number_format($result['OCTOBER']['j_contribution'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['NOVEMBER']['j_contribution'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['DECEMBER']['j_contribution'], 2, '.', ','); ?>
</td>
</tr>
<tr>
<td>Total Deductions</td>
<td align="right"><?php echo number_format($result['JANUARY']['totalDeduct'], 2, '.', ','); ?>
</td>
<td align="right"><?php echo number_format($result['FEBRUARY']['totalDeduct'], 2, '.', ','); ?>
</td>
<td align="right"><?php echo number_format($result['MARCH']['totalDeduct'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['APRIL']['totalDeduct'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['MAY']['totalDeduct'], 2, '.', ','); ?>
</td>
<td align="right"><?php echo number_format($result['JUNE']['totalDeduct'], 2, '.', ','); ?>
</td>
<td align="right"><?php echo number_format($result['JULY']['totalDeduct'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['AUGUST']['totalDeduct'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['SEPTEMBER']['totalDeduct'], 2, '.', ',');?>
</td>
<td align="right"><?php echo number_format($result['OCTOBER']['totalDeduct'], 2, '.', ',');?>
</td>
<td align="right"><?php echo number_format($result['NOVEMBER']['totalDeduct'], 2, '.', ',');?>
</td>
<td align="right"><?php echo number_format($result['DECEMBER']['totalDeduct'], 2, '.', ',');?>
</tr>
<tr>
<td>Net Pay</td>
<td align="right"><?php echo number_format($result['JANUARY']['netpay'], 2, '.', ',');?>
</td>
<td align="right"><?php echo number_format($result['FEBRUARY']['netpay'], 2, '.', ','); ?>
</td>
<td align="right"><?php echo number_format($result['MARCH']['netpay'], 2, '.', ',');?>
</td>
<td align="right"><?php echo number_format($result['APRIL']['netpay'], 2, '.', ','); ?>
</td>
<td align="right"><?php echo number_format($result['MAY']['netpay'], 2, '.', ','); ?>
</td>
<td align="right"><?php echo number_format($result['JUNE']['netpay'], 2, '.', ','); ?>
</td>
<td align="right"><?php echo number_format($result['JULY']['netpay'], 2, '.', ','); ?>
</td>
<td align="right"><?php echo number_format($result['AUGUST']['netpay'], 2, '.', ','); ?>
</td>
<td align="right"><?php echo number_format($result['SEPTEMBER']['netpay'], 2, '.', ',');?>
</td>
<td align="right"><?php echo number_format($result['OCTOBER']['netpay'], 2, '.', ','); ?>
</td>
<td align="right"><?php echo number_format($result['NOVEMBER']['netpay'], 2, '.', ','); ?>
</td>
<td align="right"><?php echo number_format($result['DECEMBER']['netpay'], 2, '.', ',');?>
</td>
</tr>
<tr>
<td>Basic Allowance</td>
<td align="right"><?php echo number_format($result['JANUARY']['motorBasicAll'], 2, '.', ',');?>
</td>
<td align="right">
<?php echo number_format($result['FEBRUARY']['motorBasicAll'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['MARCH']['motorBasicAll'], 2, '.', ',');?>
</td>
<td align="right"><?php echo number_format($result['APRIL']['motorBasicAll'], 2, '.', ','); ?>
</td>
<td align="right">
<?php echo number_format($result['MAY']['motorBasicAll'], 2, '.', ','); ?>
</td>
<td align="right"><?php echo number_format($result['JUNE']['motorBasicAll'], 2, '.', ',');?>
</td>
<td align="right">
<?php echo number_format($result['JULY']['motorBasicAll'], 2, '.', ','); ?>
</td>
<td align="right"><?php echo number_format($result['AUGUST']['motorBasicAll'], 2, '.', ','); ?>
</td>
<td align="right"><?php echo number_format($result['SEPTEMBER']['motorBasicAll'], 2, '.', ','); ?>
</td>
<td align="right"><?php echo number_format($result['OCTOBER']['motorBasicAll'], 2, '.', ','); ?>
</td>
<td align="right"><?php echo number_format($result['NOVEMBER']['motorBasicAll'], 2, '.', ','); ?>
</td>
<td align="right"><?php echo number_format($result['DECEMBER']['motorBasicAll'], 2, '.', ','); ?>
</td>
</tr>
<tr>
<td>Gross Pay</td>
<td align="right">
<?php echo number_format($result['JANUARY']['grosspay'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['FEBRUARY']['grosspay'], 2, '.', ','); ?>
</td>
<td align="right"><?php echo number_format($result['MARCH']['grosspay'], 2, '.', ',');?>
</td>
<td align="right"><?php echo number_format($result['APRIL']['grosspay'], 2, '.', ',');?>
</td>
<td align="right"><?php echo number_format($result['MAY']['grosspay'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['JUNE']['grosspay'], 2, '.', ',');?>
</td>
<td align="right"><?php echo number_format($result['JULY']['grosspay'], 2, '.', ','); ?>
</td>
<td align="right"><?php echo number_format($result['AUGUST']['grosspay'], 2, '.', ',');?>
</td>
<td align="right"> <?php echo number_format($result['SEPTEMBER']['grosspay'], 2, '.', ','); ?>
</td>
<td align="right"><?php echo number_format($result['OCTOBER']['grosspay'], 2, '.', ',');?>
</td>
<td align="right"><?php echo number_format($result['NOVEMBER']['grosspay'], 2, '.', ',');?>
</td>
<td align="right"><?php echo number_format($result['DECEMBER']['grosspay'], 2, '.', ','); ?>
</td>
</tr>
<tr>
<td>Total net Emoluments</td>
<td align="right"><?php echo number_format($result['JANUARY']['totalEmolu'], 2, '.', ','); ?>
</td>
<td align="right"><?php echo number_format($result['FEBRUARY']['totalEmolu'], 2, '.', ','); ?>
</td>
<td align="right"> <?php echo number_format($result['MARCH']['totalEmolu'], 2, '.', ',')?>
</td>
<td align="right"><?php echo number_format($result['APRIL']['totalEmolu'], 2, '.', ','); ?>
</td>
<td align="right"><?php echo number_format($result['MAY']['totalEmolu'], 2, '.', ','); ?>
</td>
<td align="right"><?php echo number_format($result['JUNE']['totalEmolu'], 2, '.', ','); ?>
</td>
<td align="right"><?php echo number_format($result['JULY']['totalEmolu'], 2, '.', ','); ?>
</td>
<td align="right"><?php echo number_format($result['AUGUST']['totalEmolu'], 2, '.', ','); ?>
</td>
<td align="right"><?php echo number_format($result['SEPTEMBER']['totalEmolu'], 2, '.', ','); ?>
</td>
<td align="right"><?php echo number_format($result['OCTOBER']['totalEmolu'], 2, '.', ','); ?>
</td>
<td align="right"><?php echo number_format($result['NOVEMBER']['totalEmolu'], 2, '.', ',');?>
</td>
<td align="right"><?php echo number_format($result['DECEMBER']['totalEmolu'], 2, '.', ',');?>
</td>
</tr>
</table></td>
</tr>
</table>
<div class="row">
<div class="col-md-11 col-md-offset-1">
</div>
</div>
<div >
</div>
</div>
</div>
</body>
</html>