| Server IP : 199.250.214.225 / Your IP : 18.116.50.119 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/grp.nicn.gov.ng/storage/framework/views/ |
Upload File : |
<!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>COURT OF APPEAL
...::...Payroll Report</title>
<link rel="stylesheet" href="<?php echo e(asset('assets/css/bootstrap.min.css')); ?>">
<style type="text/css">
.head-color tr td, .table .th-row td
{
color:#06c;
}
.table, .table tr td
{
border: 1px solid #06C;
color:#06c;
}
.pr
{
display:none;
}
@media print {
.table tr .bg
{
background:#0cf !important;
opacity:0.8 !important;
color:#FFF !important;
}
}
</style>
<style media="print">
.pr
{
display:block;
}
</style>
<script type="text/javascript" src="<?php echo e(asset('assets/js/number_to_word.js')); ?>">
</script>
</head>
<body>
<div align="center"><h2><div style="color:#06c;">COURT OF APPEAL
<br />
COUNCIL MEMBERS PAYROLL</div><br />
</h2>
</div>
<div style="width:90%; margin: auto;">
<table class="head-color" width="1802" border="0" cellpadding="0" cellspacing="0" style="font-size:18px" >
<span id="proccessingRequest" style="display:none; font-size:20px;" class="text-success"> <strong>Processing Please wait...</strong> </span>
<tr>
<td>Payroll P.V. No:</td>
<td><div align="left">Sheet No:</div></td>
</tr>
<tr>
<td colspan="2"><h3>MINISTRY/DEPARTMENT:
COURT OF APPEAL, ABUJA </h3></td>
</tr>
<tr>
<td width="1294">
<strong>MONTH ENDING: <?php if(session('schmonth')): ?>
<?php echo e(session('schmonth')); ?>
<?php endif; ?></strong><br/> </td>
<td width="508" align="rights">Date Printed: <?php echo e(date("l, F d, Y")); ?></td>
</tr>
<tr>
<td><strong>
<?php if(session('bank')): ?>
<?php echo e(session('bank')); ?>
<?php endif; ?>
</strong> </td>
<td> </td>
</tr>
</table>
<table class="table table-condense table-responsive" border="1" cellpadding="4" cellspacing="0">
<tr class="th-row">
<td width="44" rowspan="2" align="center" valign="middle"><strong>SN</strong></td>
<td width="44" rowspan="2" align="center" valign="middle"><strong>FileNo</strong></td>
<td width="44" rowspan="2" align="center" style="writing-mode: vertical-rl;"><strong>CHECKING</strong></td>
<td width="44" rowspan="2" align="center" style="writing-mode: vertical-rl;"><strong>AUDIT</strong></td>
<td width="271" rowspan="2" align="center" valign="middle"><strong>NAME</strong></td>
<td colspan="<?php echo e(isset($staffEarnElement) ? count($staffEarnElement) + 2 : 2); ?>" align="center" valign="top"><strong>EARNINGS</strong></td>
<td colspan="<?php echo e(isset($staffDeductionElement) ? count($staffDeductionElement) + 2 : 2); ?>" align="center" valign="top"><strong>DEDUCTIONS</strong></td>
<td width="70" rowspan="2" align="center" valign="middle"><strong>TOTAL DEDUCTION.</strong></td>
<td align="center" rowspan="2" valign="middle"><strong>ALLOWANCE</strong></td>
<td width="85" rowspan="2" align="center" valign="middle"><strong>NET PAY</td>
</tr>
<tr>
<td width="90" align="center" valign="middle"><strong>BASIC <br/> (CONSOLIDATED)</strong></td>
<?php if(isset($staffEarnElement) && $staffEarnElement): ?>
<?php $__currentLoopData = $staffEarnElement; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $elementEarn): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
<th align="center"><strong><?php echo e(strtoupper($elementEarn->description)); ?></strong></th>
<?php $totalEarnAmount[$elementEarn->CVID] = 0.0; ?>
<?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
<?php endif; ?>
<td width="80" align="center" valign="middle"><strong>GROSS<br/> EMOLUMENT</strong></td>
<td width="74" align="center" valign="middle"><strong>TAX</strong></td>
<td width="74" align="center" valign="middle"><strong>NHF</strong></td>
<?php if(isset($staffDeductionElement) && $staffDeductionElement): ?>
<?php $__currentLoopData = $staffDeductionElement; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $elementDeduct): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
<th align="center"><strong><?php echo e(strtoupper($elementDeduct->description)); ?></strong></th>
<?php $totalDeductAmount[$elementDeduct->CVID] = 0.0; ?>
<?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
<?php endif; ?>
</tr>
<?php
$bstotal = 0.00;
$hatotal = 0.00;
$trtotal = 0;
$furtotal = 0;
$taxtotal = 0;
$pectotal = 0;
$utitotal = 0;
$drtotal = 0;
$sertotal = 0;
$e_arrearstotal = 0;
$e_otherstotal = 0;
$pentotal = 0;
$nhftotal = 0;
$d_arrearstotal = 0;
$d_othertotal = 0;
$earntotal = 0;
$deducttotal = 0;
$netpaytotal = 0;
$uniontotal = 0;
$totalNetEmolu = 0;
$totalSot =0;
$k = 1;
$medAllowanceTotal = 0;
$cooptotal = 0;
$salAdvancetotal = 0;
$coopLoantotal =0;
$totalGross =0;
$totalAllow = 0;
?>
<?php $__currentLoopData = $payroll_detail; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $reports): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
<?php
$severance = DB::table('tblotherEarningDeduction')->where('CVID','=',25)->where('staffid','=', $reports->staffid)->where('year','=', $reports->year)->where('month','=', $reports->month)->first();
$furAll = DB::table('tblotherEarningDeduction')->where('CVID','=',23)->where('staffid','=', $reports->staffid)->where('year','=', $reports->year)->where('month','=', $reports->month)->first();
if($severance == '')
{
$ser = 0;
}
else
{
$ser = $severance->amount;
}
if($furAll == '')
{
$funiture = 0;
}
else
{
$funiture = $furAll->amount;
}
?>
<tr>
<td align="right" ><?php echo e($k++); ?></td>
<td align="right" ><?php echo e($reports->fileNo); ?></td>
<td align="right" >
<?php if(($reports->vstage == 3) && ($userRole->can_check == 1)): ?>
<?php if($reports->checking_verified == 1): ?>
<input type="checkbox" checked="checked" name="unCheckChecking" id="unCheckChecking"
data-staffId = <?php echo e($reports->staffid); ?>
data-month = <?php echo e($reports->month); ?>
data-yr = <?php echo e($reports->year); ?>
/>
<?php else: ?>
<input type="checkbox" name="checkingChecked" id="checkingChecked"
data-staffId = <?php echo e($reports->staffid); ?>
data-month = <?php echo e($reports->month); ?>
data-yr = <?php echo e($reports->year); ?>
>
<?php endif; ?>
<?php elseif($reports->checking_verified == 1): ?>
<span class="text-danger"><strong> ok </strong></span>
<?php endif; ?>
</td>
<td>
<?php if(($reports->vstage == 4) && ($userRole->can_audit == 1)): ?>
<?php if($reports->audit_verified == 1): ?>
<input type="checkbox" checked="checked" name="auditUnChecked" id="auditUnChecked"
data-staffId = <?php echo e($reports->staffid); ?>
data-month = <?php echo e($reports->month); ?>
data-yr = <?php echo e($reports->year); ?>
/>
<?php else: ?>
<input type="checkbox" name="auditChecked" id="auditChecked"
data-staffId = <?php echo e($reports->staffid); ?>
data-month = <?php echo e($reports->month); ?>
data-yr = <?php echo e($reports->year); ?>
>
<?php endif; ?>
<?php elseif($reports->audit_verified == 1): ?>
<span class="text-warning"><strong> ok </strong></span>
<?php endif; ?>
</td>
<td align="left" valign="middle" nowrap="nowrap"><a class="hidden-print" target ="_blank" href="<?php echo e(url("/con-pecard/getCard/$reports->staffid/$reports->year")); ?>"><?php echo e($reports->council_title); ?> <?php echo e($reports->name); ?></a> <span class="pr"><?php echo e($reports->council_title); ?> <?php echo e($reports->name); ?></span></td>
<td width="75" align="right"><?php $bstotal += $reports->Bs; ?> <?php echo e(number_format($reports->Bs, 2, '.', ',')); ?></td>
<?php $sumEarnAmount = 0.0; $sumDeductAmount = 0.0; $sumEarnGross = 0; ?>
<?php $__currentLoopData = $staffEarnElement; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $element): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
<?php
$getEarnAmount = $getStaffMonthEarnAmount[$reports->staffid][$element->CVID];
$sumEarnAmount = $getEarnAmount ? $getEarnAmount->staffEarnings : 0.0;
$sumEarnGross += $sumEarnAmount;
$totalEarnAmount[$element->CVID] += $sumEarnAmount;
?>
<td width="75" align="right"> <?php echo e(number_format($sumEarnAmount , 2, '.', ',')); ?></td>
<?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
<td width="66" align="right" class="bg" style="background:#0cf;opacity:0.8; color:#FFF;"><?php $totalGross += $reports->Bs + $reports->AEarn + $sumEarnGross;?><?php echo e(number_format($reports->Bs + $reports->AEarn + $sumEarnGross, 2, '.', ',')); ?></td>
<td width="52" align="right"><?php $taxtotal += $reports->TAX;?> <?php echo e(number_format($reports->TAX, 2, '.', ',')); ?></td>
<td width="52" align="right"><?php $nhftotal += $reports->NHF;?> <?php echo e(number_format($reports->NHF, 2, '.', ',')); ?></td>
<?php $__currentLoopData = $staffDeductionElement; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $elementDec): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
<?php
$getDeductAmount = $getStaffMonthDeductionAmount[$reports->staffid][$elementDec->CVID];
$sumDeductAmount = $getDeductAmount ? $getDeductAmount->staffDeductions : 0.0;
$totalDeductAmount[$elementDec->CVID] += $sumDeductAmount;
?>
<td width="85" align="right"><?php echo e(number_format($sumDeductAmount, 2, '.', ',')); ?></td>
<?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
<td width="82" align="right" class="bg" style="background:#0cf;opacity:0.8; color:#FFF;"><?php $deducttotal += $reports->TD;?> <strong> <?php echo e(number_format($reports->TD, 2, '.', ',')); ?></strong></td>
<td width="75" align="right"><?php $totalAllow += $reports->PEC; ?> <?php echo e(number_format($reports->PEC, 2, '.', ',')); ?></td>
<td width="82" align="right"><?php $totalNetEmolu += $reports->NetPay;?> <?php echo e(number_format($reports->NetPay, 2, '.', ',')); ?></td>
</tr>
<?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
<tr><td colspan="5" align="right"><strong>TOTAL</strong></td>
<td align="right"><strong><?php echo e(number_format($bstotal, 2, '.', ',')); ?></strong></td>
<?php $__currentLoopData = $staffEarnElement; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $element): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
<td width="66" align="right"><?php echo e(number_format($totalEarnAmount[$element->CVID] , 2, '.', ',')); ?></td>
<?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
<td align="right"><strong><?php echo e(number_format($totalGross, 2, '.', ',')); ?> </strong></td>
<td align="right"><strong><?php echo e(number_format($taxtotal, 2, '.', ',')); ?></strong></td>
<td align="right"><strong><?php echo e(number_format($nhftotal, 2, '.', ',')); ?></strong></td>
<?php $__currentLoopData = $staffDeductionElement; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $elementDec): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
<td width="85" align="right"><?php echo e(number_format($totalDeductAmount[$elementDec->CVID], 2, '.', ',')); ?></td>
<?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
<td align="right"><strong><?php echo e(number_format($deducttotal, 2, '.', ',')); ?></strong></td>
<td align="right"><strong><?php echo e(number_format($totalAllow, 2, '.', ',')); ?></strong></td>
<td align="right"><strong><?php echo e(number_format($totalNetEmolu, 2, '.', ',')); ?></strong></td>
</tr>
</table>
<div class="pull-right">
<p>------------------------------20-------------------------------------------</p>
<p class="text-right" style="margin-right:50px;">SIGNATURE</p>
<br/>
<p>---------------------------------------------------------------------------</p>
<p class="text-center">PAYING OFFICER STAMP</p>
</div>
<h2 class="hidden-print" style="margin-top:10px; color:green; margin-left:20px;">KEY</h2>
<!--Table Key -->
<!--<table class="table-condense table-responsive hidden-print" border="1" cellpadding="4" cellspacing="0" style="margin-left:20px;">
<tr>
<th scope="col">ABBREVIATION</th>
<th scope="col">MEANING</th>
</tr>
<tr>
<td>BS</td>
<td>Basic Salary</td>
</tr>
<tr>
<td>PEN</td>
<td>Pension</td>
</tr>
<tr>
<td>NHF</td>
<td>National Housing Fund</td>
</tr>
</table>-->
</div>
<!-- Table Key -->
<br>
<div style="margin-left:30px;">
<h2 class="hidden-print"> <a class="hidden-print" type="submit" class="btn btn-success btn-sm pull-right" href = "<?php echo e(url('/council-members/payroll-vc')); ?>">Back</a>
</h2>
<a href="/payroll-council-comments/<?php echo e($payroll_detail[0]->year); ?>/<?php echo e($payroll_detail[0]->month); ?>" class="btn btn-primary" style="margin-bottom: 10px;" type="button">
View Comment's
</a>
<div>
<input type="hidden" value="<?php echo e($bankName ?? ''); ?>" id="selectedBankName">
<div id="selBankName">
<?php if($payroll_detail): ?>
<?php if(($payroll_detail[0]->vstage == 0) && ($userRole->can_authorize_salary == 1)): ?>
<?php echo $__env->make('variationControl.includeSalaryCouncil', \Illuminate\Support\Arr::except(get_defined_vars(), ['__data', '__path']))->render(); ?>
<?php elseif(($payroll_detail[0]->vstage == 3) && ($userRole->can_check == 1)): ?>
<?php echo $__env->make('variationControl.includeCheckingCouncil', \Illuminate\Support\Arr::except(get_defined_vars(), ['__data', '__path']))->render(); ?>
<?php elseif(($payroll_detail[0]->vstage == 4) && ($userRole->can_audit == 1)): ?>
<?php echo $__env->make('variationControl.includeAuditCouncil', \Illuminate\Support\Arr::except(get_defined_vars(), ['__data', '__path']))->render(); ?>
<?php elseif(($payroll_detail[0]->vstage == 5 || $payroll_detail[0]->vstage == 6) && ($userRole->can_cpo == 1)): ?>
<?php echo $__env->make('variationControl.includeCpoCouncil', \Illuminate\Support\Arr::except(get_defined_vars(), ['__data', '__path']))->render(); ?>
<?php endif; ?>
<?php else: ?>
<?php echo e("No record"); ?>
<?php endif; ?>
</div>
</div>
</div>
</body>
<script src="<?php echo e(asset('/assets/js/jQuery-2.2.0.min.js')); ?>"></script>
<script src="<?php echo e(asset('/assets/js/bootstrap.min.js')); ?>"></script>
<script>
$(document).ready(function() {
var a = $('#selectedBankName').val()
if (a !== "") {
$("#selBankName").hide()
}
//set selected bank to zero because it prenvents jquery check box if you don't select bank
var a = 0
if(a = 0){
//for checking to check
$('#checkingChecked').each(function(){
$('input[name="checkingChecked"]').click(function(){
console.log($(this).attr('data-staffId'))
console.log($(this).attr('data-month'))
console.log($(this).attr('data-yr'))
console.log("clicked checkbox 1")
$('#proccessingRequest').show()
$.ajax({
type: "post",
url: "/checking-council/verified",
data: {
'checked' : 1,
'staffId' : $(this).attr('data-staffId'),
'month' : $(this).attr('data-month'),
'yr' : $(this).attr('data-yr'),
'_token': $('input[name=_token]').val()
},
dataType: "json",
success: function (response) {
console.log(response)
// location.reload(true)
$('#proccessingRequest').hide()
}
});
})
})
//for checking to uncheck
$('#unCheckChecking').each(function(){
$('input[name="unCheckChecking"]').click(function(){
console.log($(this).attr('data-staffId'))
console.log($(this).attr('data-month'))
console.log($(this).attr('data-yr'))
console.log("clicked uncheck box")
$('#proccessingRequest').show()
$.ajax({
type: "post",
url: "/checking-council/verified",
data: {
'checked' : 0,
'staffId' : $(this).attr('data-staffId'),
'month' : $(this).attr('data-month'),
'yr' : $(this).attr('data-yr'),
'_token': $('input[name=_token]').val()
},
dataType: "json",
success: function (response) {
console.log(response)
// location.reload(true)
$('#proccessingRequest').hide()
}
});
})
})
//for audit to check
$('#auditChecked').each(function(){
$('input[name="auditChecked"]').click(function(){
$('#proccessingRequest').show()
$.ajax({
type: "post",
url: "/audit-council/verified",
data: {
'checked' : 1,
'staffId' : $(this).attr('data-staffId'),
'month' : $(this).attr('data-month'),
'yr' : $(this).attr('data-yr'),
'_token': $('input[name=_token]').val()
},
dataType: "json",
success: function (response) {
// location.reload(true)
$('#proccessingRequest').hide()
}
});
})
})
//for audit to uncheck
$('#auditUnChecked').each(function(){
$('input[name="auditUnChecked"]').click(function(){
$('#proccessingRequest').show()
$.ajax({
type: "post",
url: "/audit-council/verified",
data: {
'checked' : 0,
'staffId' : $(this).attr('data-staffId'),
'month' : $(this).attr('data-month'),
'yr' : $(this).attr('data-yr'),
'_token': $('input[name=_token]').val()
},
dataType: "json",
success: function (response) {
// location.reload(true)
$('#proccessingRequest').hide()
}
});
})
})
}else{
//for checking to check
$('#checkingChecked').each(function(){
$('input[name="checkingChecked"]').click(function(){
console.log($(this).attr('data-staffId'))
console.log($(this).attr('data-month'))
console.log($(this).attr('data-yr'))
console.log("clicked checkbox 1")
$('#proccessingRequest').show()
$.ajax({
type: "post",
url: "/checking-council/verified",
data: {
'checked' : 1,
'staffId' : $(this).attr('data-staffId'),
'month' : $(this).attr('data-month'),
'yr' : $(this).attr('data-yr'),
'_token': $('input[name=_token]').val()
},
dataType: "json",
success: function (response) {
console.log(response)
// location.reload(true)
$('#proccessingRequest').hide()
}
});
})
})
$('#unCheckChecking').each(function(){
//for checking to uncheck
$('input[name="unCheckChecking"]').click(function(){
console.log($(this).attr('data-staffId'))
console.log($(this).attr('data-month'))
console.log($(this).attr('data-yr'))
console.log("clicked uncheck box")
$('#proccessingRequest').show()
$.ajax({
type: "post",
url: "/checking-council/verified",
data: {
'checked' : 0,
'staffId' : $(this).attr('data-staffId'),
'month' : $(this).attr('data-month'),
'yr' : $(this).attr('data-yr'),
'_token': $('input[name=_token]').val()
},
dataType: "json",
success: function (response) {
console.log(response)
// location.reload(true)
$('#proccessingRequest').hide()
}
});
})
})
//for audit to check
$('#auditChecked').each(function(){
$('input[name="auditChecked"]').click(function(){
$('#proccessingRequest').show()
$.ajax({
type: "post",
url: "/audit-council/verified",
data: {
'checked' : 1,
'staffId' : $(this).attr('data-staffId'),
'month' : $(this).attr('data-month'),
'yr' : $(this).attr('data-yr'),
'_token': $('input[name=_token]').val()
},
dataType: "json",
success: function (response) {
// location.reload(true)
$('#proccessingRequest').hide()
}
});
})
})
//for audit to uncheck
$('#auditUnChecked').each(function(){
$('input[name="auditUnChecked"]').click(function(){
$('#proccessingRequest').show()
$.ajax({
type: "post",
url: "/audit-council/verified",
data: {
'checked' : 0,
'staffId' : $(this).attr('data-staffId'),
'month' : $(this).attr('data-month'),
'yr' : $(this).attr('data-yr'),
'_token': $('input[name=_token]').val()
},
dataType: "json",
success: function (response) {
// location.reload(true)
$('#proccessingRequest').hide()
}
});
})
})
}
$(document).ready(function() {
$("#comments").click(function(e) {
e.preventDefault();
jQuery('#commentsModal').modal('show')
})
})
})
</script>
</html><?php /**PATH C:\xampp\htdocs\nicngrp\resources\views/variationControl/viewCouncilPayroll.blade.php ENDPATH**/ ?>