| Server IP : 199.250.214.225 / Your IP : 18.188.56.179 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/resources/views/grossSum/ |
Upload File : |
@extends('layouts.layout')
@section('pageTitle')
@endsection
@section('content')
<div class="box box-default" style="border-top: none;">
<div style="margin: 10px 20px;"> <big><b>{{strtoupper('Gross Pay and staff tax Summary ')}}</b></big> <span class="pull-right" style="margin-right: 30px;">Printed On: {{date('D M, Y')}}.</span> @if(session('err'))
<div class="alert alert-warning alert-dismissible hidden-print" role="alert">
<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span> </button>
<strong>Error!</strong> {{ session('err') }} </div>
@endif </div>
<div class="box-body">
<div class="row">
<div class="col-md-12">
<h3>YEAR: {{$year}}</h3>
<table class="table table-striped table-condensed table-bordered">
<thead>
<th>File Number</th>
<th>Full Name</th>
<th>Current Designation</th>
<th>Grade</th>
<th>Step</th>
<th>Total Gross Pay</th>
<th>Annual NHF</th>
<th>Annual Pension</th>
<th>Annual Tax</th>
<th>Remarks (Month/year)</th>
</thead>
<tbody>
@php $key = 1; @endphp
@foreach ($sum as $list)
@php
$d = DB::table('tblpayment')->where('year','=',$year)->where('fileNo','=',$list->fileNo)->orderBy('date','ASC')->first();
$staff = DB::table('tblper')->where('fileNo','=',$list->fileNo)->first();
$basic = DB::table('basicsalary')->where('grade','=',$d->grade)->where('step','=',$d->step)->where('employee_type','=',$staff->employee_type)->select('amount')->first();
$pec = DB::table('basicsalary')->where('grade','=',$d->grade)->where('step','=',$d->step)->where('employee_type','=',$staff->employee_type)->select('peculiar')->first();
$basic12 = $basic->amount * $list->taxmonth;
$pec12 = $pec->peculiar * $list->taxmonth;
$grosspay = $basic12 + $pec12;
@endphp
<tr>
<td>{{$list->fileNo}}</td>
<td>{{$list->name}}</td>
<td>{{$list->Designation}}</td>
<td>{{$d->grade}}</td>
<td>{{$d->step}}</td>
<td>{{number_format($grosspay , 2, '.', ',')}}</td>
<td>{{number_format($list->totalnhf , 2, '.', ',')}}</td>
<td>{{number_format($list->totalpen , 2, '.', ',')}}</td>
<td>{{number_format($list->totaltax , 2, '.', ',')}}</td>
<td>{{$list->taxmonth}} month(s)</td>
</tr>
@endforeach
</tbody>
</table>
<div class=""></div>
</div>
</div>
<!-- /.col -->
</div>
<!-- /.row -->
</div>
@endsection
@section('scripts')
<script src="{{asset('assets/js/jquery-ui.min.js')}}"></script>
<!-- autocomplete js-->
<script src="{{ asset('assets/js/jquery.autocomplete.min.js') }}" ></script>
<script src="{{ asset('assets/js/my-hr.js') }}" type="text/javascript"></script>
<script type="text/javascript">
$(function() {
$('#searchName').attr("disabled", true);
$("#autocomplete").autocomplete({
serviceUrl: murl + '/open-file-registry/searchclosed',
minLength: 2,
onSelect: function (suggestion) {
$('#ownername').val(suggestion.data);
$('#searchName').attr("disabled", false);
//showAll();
}
});
});
</script>
@endsection
@section('stypes')
<style type="text/css">
@import url(https://fonts.googleapis.com/css?family=Open+Sans);
body{
background: #f2f2f2;
font-family: 'Open Sans', sans-serif;
}
.search {
width: 100%;
position: relative;
}
.searchTerm {
float: left;
width: 100%;
border: 3px solid #00B4CC;
padding: 5px;
height: 20px;
border-radius: 5px;
outline: none;
color: #9DBFAF;
}
.searchTerm:focus{
color: #00B4CC;
}
.searchButton {
position: absolute;
right: -50px;
width: 40px;
height: 36px;
border: 1px solid #00B4CC;
background: #00B4CC;
text-align: center;
color: #fff;
border-radius: 5px;
cursor: pointer;
font-size: 20px;
}
/*Resize the wrap to see the search bar change!*/
.wrap{
width: 30%;
position: absolute;
top: 50%;
left: 50%;
transform: translate(-50%, -50%);
}
</style>
@stop
@section('styles')
<link rel="stylesheet" type="text/css" href="{{asset('assets/css/custom-style.css')}}">
@endsection
@section('styles')
<style>
.textbox {
border: 1px;
background-color: #33AD0A;
outline:0;
height:25px;
width: 275px;
}
$('.autocomplete-suggestions').css({
color: '#0f3'
});
.autocomplete-suggestions{
color:#fff;
font-size: 13px;
}
</style>
@endsection