| Server IP : 199.250.214.225 / Your IP : 18.118.121.54 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/fundscopied/resources/views/nicnModuleViews/epaymentShedule/NOT-USE-staff/ |
Upload File : |
@extends('layouts.layout')
@section('pageTitle')
{{strtoupper("E-PAYMENT : Update all Beneficiary Details")}}
@endsection
@section('content')
<div class="box-body">
<div class="row">
<div class="col-md-12">
@if (count($errors) > 0)
<div class="alert alert-danger alert-dismissible" role="alert">
<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span>
</button>
<strong>Error!</strong>
@foreach ($errors->all() as $error)
<p>{{ $error }}</p>
@endforeach
</div>
@endif
@if(session('msg'))
<div class="alert alert-success alert-dismissible" role="alert">
<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span>
</button>
<strong>Success!</strong>
{{ session('msg') }}
</div>
@endif
@if(session('err'))
<div class="alert alert-warning alert-dismissible" role="alert">
<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span>
</button>
<strong>No Beneficiary Selected !</strong>
{{ session('err') }}
</div>
@endif
</div>
</div><!-- /.col -->
</div><!-- /.row -->
<form method="post" action="{{ url('staff/report/e-payment-schedule') }}">
{{ csrf_field() }}
<div class="col-sm-12" style="background: #f9f9f9; padding: 10px;">SELECT APPROPRIATE ACCOUNT TO REPORT</div>
<div align="center" class="row" style="margin-right: 10px; margin-top: -10px;">
<div class="col-md-3">
<input type="checkbox" name="headBanner" value="1" style="width: 30px; height: 30px;">
<span class="text-success">Remove Head Banner on E-payment Report</span>
</div>
<div class="col-md-3">
<input type="radio" name="account" value="personnel" style="width: 30px; height: 30px;">
<span class="text-success"><big>PERSONNEL ACCT/NO : <b>2004656203</b></big></span>
</div>
<div class="col-md-3">
<input type="radio" name="account" value="recurrent" style="width: 30px; height: 30px;">
<span class="text-success"><big>RECURRENT ACCT/NO : <b>2004325299</b></big></span>
</div>
<div class="col-md-3">
<input type="radio" name="account" value="capital" style="width: 30px; height: 30px;">
<span class="text-success"><big>CAPITAL ACCT/NO : <b>0020170542011</b></big></span>
</div>
</div>
<hr />
<div class="box-body">
<div align="center" class="alert" style="font-size: 20px; background: #f9f9f9;">
<strong>{{strtoupper('Select Report to be Generated')}}</strong>
</div>
<input type="text" id="myInput" class="form-control" onkeyup="myFunction()" placeholder="Search by Beneficiary/Name..." title="Type in a Beneficiary or name">
<br />
<div align="center">
<button type="submit" class="btn btn-success"> Generate E-payment <i class="fa fa-book"></i> </button>
</div>
<div align="right">Total Record: {{count($staffList)}}</div>
<hr>
<div style="max-height: 450px; overflow-y: auto;"><!--style="max-height: 450px; overflow-y: auto;"-->
<table id="myTable" class="table table-hover table-striped table-responsive table-condensed table-bordered input-sm">
<thead>
<tr>
<th>S/N</th>
<th><input type="checkbox" tabindex="1" name="globalCheckbox" id="globalCheckbox"></th>
<th>{{strtoupper("Beneficiary's Name")}}</th>
<th>{{strtoupper("Bank Name")}}</th>
<th>{{strtoupper('Account No')}}</th>
<th>{{strtoupper('Sort Code')}}</th>
<th>{{strtoupper('Amount')}} ₦</th>
<th>
<div>{{strtoupper('Description')}}
<!--<input type="text" name="newDescription" placeholder="Change Description">-->
</div>
</th>
<th>{{strtoupper('Date')}}</th>
</tr>
</thead>
<tbody>
@php
$key = 1;
$countNull = 1;
@endphp
@foreach ($staffList as $getList)
@php
if($getList != '')
{
$fullDetails = DB::connection('mysql2')->table('tblper')
->join('tblbank','tblbank.bankID','=','tblper.bankID')
->join('tblbanklist','tblbanklist.bankID','=','tblper.bankID')
->where('tblper.fileNo', '=', $getList->fileNo)
->first();
}
@endphp
<tr>
<td>
{{$key ++}}
</td>
<td>
<input type="checkbox" name="beneficiaryStaff[]" id="{{$getList->id}}" value="{{$getList->id}}" class="checkBox">
</td>
<td>
<a href="#" data-toggle="modal" data-target="#editByCPO{{$getList->id}}">
@if($getList->fullname != null)
{{$getList->fullname}}
@else
@if($fullDetails != null)
{{$fullDetails->surname .' '. $fullDetails->first_name .' '. $fullDetails->othernames}}
@else
{{$getList->fullname}}
@endif
@endif
</a>
</td>
<td>
<a href="#" data-toggle="modal" data-target="#editByCPO{{$getList->id}}">
@if($getList->bankname != null)
{{$getList->bankname}}
@else
@if($fullDetails != null)
{{$fullDetails->bank_abbr}}
@else
{{$getList->bankname}}
@endif
@endif
</a>
</td>
<td>
<a href="#" data-toggle="modal" data-target="#editByCPO{{$getList->id}}">
@if($getList->accountno != null)
{{$getList->accountno}}
@else
@if($fullDetails != null)
{{$fullDetails->AccNo}}
@else
{{$getList->accountno}}
@endif
@endif
</a>
</td>
<td>
<a href="#" data-toggle="modal" data-target="#editByCPO{{$getList->id}}">
@if($getList->sortcode != null)
{{$getList->sortcode}}
@else
@if($fullDetails != null)
{{$fullDetails->sort_code }}
@else
{{$getList->sortcode}}
@endif
@endif
</a>
</td>
<td>
<a href="#" data-toggle="modal" data-target="#editByCPO{{$getList->id}}">
@if($fullDetails != null)
{{number_format(($getList->amount), 2, '.', ',')}}
@else
{{number_format(($getList->amount), 2, '.', ',')}}
@endif
</a>
</td>
<td>
<a href="#" data-toggle="modal" data-target="#editByCPO{{$getList->id}}">
@if($getList->descriptioncpo != null)
{{$getList->descriptioncpo}}
@else
{{$getList->description}}
@endif
</a>
</td>
<td>
@if($fullDetails != null)
{{$getList->date}}
@else
{{$getList->date}}
@endif
</td>
</tr>
@endforeach
</tbody>
</table>
</div>
<br />
<p>
<div class="row">
<div align="left" class="col-xs-6">
<strong>Authorized Signatory</strong>
<table class="table table-condensed table-responsive">
<tr>
<td align="left"> Name:- </td>
<td align="left">
<select name="firstAuthorized" style="border: 0; border-style: none; color: blue;">
<option value="">Select</option>
<option value=""></option>
@foreach($allRecords as $list)
<option value="{{$list ->signatoryID}}">{{$list->fullname}}</option>
@endforeach
</select>
</td>
</tr>
</table>
<strong>Authorized Signatory</strong>
<table class="table table-condensed table-responsive">
<tr>
<td align="left"> Name:- </td>
<td align="left">
<select name="secondAuthorized" style="border: 0; border-style: none; color: blue;">
<option value="">Select</option>
<option value=""></option>
@foreach($allRecords as $list)
<option value="{{$list ->signatoryID}}">{{$list->fullname}}</option>
@endforeach
</select>
</td>
</tr>
</table>
</div>
<div align="left" class="col-xs-6">
<strong>Submited For Confirmation By</strong>
<table class="table table-condensed table-responsive">
<tr>
<td align="left"> Name:- </td>
<td align="left">
<select name="submitedForConfirmationBy" style="border: 0; border-style: none; color: blue;">
<option value="">Select</option>
<option value=""></option>
@foreach($allRecords as $list)
<option value="{{$list ->signatoryID}}">{{$list->fullname}}</option>
@endforeach
</select>
</td>
</tr>
</table>
<strong>Confirmed Before Me</strong>
<table class="table table-condensed table-responsive">
<tr>
<td align="left"> Name:- </td>
<td align="left">
<select name="confirmedBeforeMe" style="border: 0; border-style: none; color: blue;">
<option value="">Select</option>
<option value=""></option>
@foreach($allRecords as $list)
<option value="{{$list ->signatoryID}}">{{$list->fullname}}</option>
@endforeach
</select>
</td>
</tr>
</table>
</div>
</div>
<div align="center">
<button type="submit" class="btn btn-success"> Generate E-payment <i class="fa fa-book"></i> </button>
</div>
</p>
</form>
<hr />
@if(Entrust::hasRole('CPO') or (Entrust::hasRole('super admin')))
<form method="post" action="{{url('/recurrent/staff/add-to-list/voucher')}}">
{{ csrf_field() }}
<table class="table table-striped table-bordered table-condensed table-responsive">
<td>
<div> {{$key ++}}</div>
</td>
<!--<td>-->
<input type="hidden" name="fileNo" class="form-control" readonly disabled style="border: none; width: 60px;">
<!--</td>-->
<td colspan="2">
<input type="text" name="fullName" class="form-control" style="border: none;" placeholder="Full Name">
</td>
<td colspan="2">
<input type="text" name="bankName" class="form-control" style="border: none;" placeholder="Bank Name">
</td>
<td>
<input type="text" name="accountNo" class="form-control" style="border: none;" placeholder="Account No.">
</td>
<td>
<input type="text" name="sortCode" class="form-control" style="border: none;" placeholder="Sort Code">
</td>
<td>
<input type="text" name="designation" class="form-control" style="border: none;" placeholder="Designation">
</td>
<td width="120 hidden" style="display: none;">
<div class="row">
<div class="col-xs-6">
<input type="text" name="grade" class="form-control" placeholder="GL">
</div>
<div class="col-xs-6">
<input type="text" name="step" class="form-control" placeholder="ST">
</div>
</div>
</td>
<td>
<input type="text" name="division" class="form-control" style="border: none;" placeholder="Division">
</td>
<td>
<input type="text" name="amount" class="form-control" style="border: none; width: 80px;" placeholder="Amount">
</td>
<td>
<button class="btn btn-success btn-sm add-more hidden-print" type="submit" title="Save and Add to List"><i class="glyphicon glyphicon-plus"></i></button>
<input type="hidden" name="voucherID" value="{{$AddMore->transactionID}}">
<input type="hidden" name="economicCode" value="{{$AddMore->economiccode}}">
</td>
</table>
</form>
@endif
<br />
<div align="right" class="hidden-print">Total Record: {{ count($staffList) }}</div>
<hr >
<hr />
@php
$key = 1;
$countNull = 1;
@endphp
@foreach ($staffList as $getList)
@php
if($getList != '')
{
$fullDetails = DB::connection('mysql2')->table('tblper')
->join('tblbank','tblbank.bankID','=','tblper.bankID')
->join('tblbanklist','tblbanklist.bankID','=','tblper.bankID')
->where('tblper.fileNo', '=', $getList->fileNo)
->first();
}
@endphp
<!--EDIT BY CPO-->
<div class="modal fade" id="editByCPO{{$getList->id}}" role="dialog" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header" style="background: gray; color: white; border: 1px solid white;">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true"></button>
<h4 class="modal-title"> Edit Voucher</h4>
</div>
<div class="modal-body col-sm-12" style="padding: 10px;">
Edit details for this voucher
<hr />
<div class="row" style="background: #ddd; margin: 5px 10px; padding: 5px;">
<div class="col-md-6">
Beneficiary
<input type="text" name="beneficiary" id="beneficiary{{$getList->id}}" class="form-control" value="@if($getList->fullname != null){{$getList->fullname}}@else @if($fullDetails != null){{$fullDetails->surname .' '. $fullDetails->first_name .' '. $fullDetails->othernames}} @else {{$getList->fullname}} @endif @endif">
</div>
<div class="col-md-6">
Description
<textarea name="description" id="description{{$getList->id}}" class="form-control">@if($getList->descriptioncpo != null){{$getList->descriptioncpo}} @else {{$getList->description}} @endif</textarea>
</div>
</div>
<div class="row" style="background: #ddd; margin: 5px 10px; padding: 5px;">
<div class="col-md-6">
Bank Name
<input type="text" name="bankName" id="bankName{{$getList->id}}" class="form-control" value="@if($getList->bankname != null){{$getList->bankname}}@else @if($fullDetails != null){{$fullDetails->bank}}@else {{$getList->bankname}} @endif @endif">
</div>
<div class="col-md-6">
Account Number
<input type="text" name="accountNumber" id="accountNumber{{$getList->id}}" class="form-control" value="@if($getList->accountno != null){{$getList->accountno}} @else @if($fullDetails != null){{$fullDetails->AccNo}}@else{{$getList->accountno}}@endif @endif">
</div>
</div>
<div class="row" style="background: #ddd; margin: 5px 10px; padding: 5px;">
<div class="col-md-6">
Sort Code
<input type="text" name="sortCode" id="sortCode{{$getList->id}}" class="form-control" value="@if($getList->sortcode != null){{$getList->sortcode}}@else @if($fullDetails != null){{$fullDetails->sort_code }}@else{{$getList->sortcode}}@endif @endif">
</div>
<div class="col-md-6">
Amount
<input type="text" name="staffAmount" id="staffAmount{{$getList->id}}" class="form-control" value="{{$getList->amount}}">
</div>
</div>
</div>
<div class="modal-footer">
<input type="button" name="editBankDetailsButton" class="editBankDetailsButton btn btn-success" value="Update Bank Details" id="{{$getList->id}}">
<button type="button" class="btn btn-default" data-dismiss="modal">Cancel</button>
</div>
<input type="hidden" name="transactionID" id="transactionID{{$getList->id}}" value="{{$getList->transactionID}}">
</div>
</div>
</div>
<!-- //EDIT BY CPO -->
@endforeach
</div>
@endsection
@section('styles')
<!--<style type="text/css">
.table td{
border: #9f9f9f solid 1px !important;
}
.table th{
border: #9f9f9f solid 1px !important;
}-->
<!--</style>-->
@stop
@section('scripts')
<script src="{{asset('assets/js/jquery-ui.min.js')}}"></script>
<script type="text/javascript">
//SELECT/DESELECT ALL CHECKBOX
$(document).ready(function () {
$('#globalCheckbox').click(function(){
if($(this).prop("checked")) {
$(".checkBox").prop("checked", true);
} else {
$(".checkBox").prop("checked", false);
}
});
});
//EDIT STAFF BANK DETAILS BY CPO
$(document).ready(function() {
$(".editBankDetailsButton").click(function () {
var id = this.id;
var bankName = $('#bankName'+id).val();
var accountNumber = $('#accountNumber'+id).val();
var sortCode = $('#sortCode'+id).val();
var staffAmount = $('#staffAmount'+id).val();
var description = $('#description'+id).val();
var beneficiary = $('#beneficiary'+id).val();
var transactionID = $('#transactionID'+id).val();
$.ajax({
url: murl + '/update/staff-e-payment-details-JSON',
type: "post",
data: {'id': id,'transactionID': transactionID, 'beneficiary': beneficiary, 'description': description, 'bankName': bankName, 'accountNumber': accountNumber, 'sortCode': sortCode, 'staffAmount': staffAmount, '_token': $('input[name=_token]').val()},
success: function(data){
location.reload();
}
})
});
});
//CPO
//Table search and pagination
function myFunction() {
// Declare variables
var input, filter, table, tr, td, i;
input = document.getElementById("myInput");
filter = input.value.toUpperCase();
table = document.getElementById("myTable");
tr = table.getElementsByTagName("tr");
// Loop through all table rows, and hide those who don't match the search query
for (i = 0; i < tr.length; i++) {
td = tr[i].getElementsByTagName("td")[2];
if (td) {
if (td.innerHTML.toUpperCase().indexOf(filter) > -1) {
tr[i].style.display = "";
} else {
tr[i].style.display = "none";
}
}
}
}
//ends here
</script>
@endsection