| Server IP : 199.250.214.225 / Your IP : 18.118.205.21 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/ |
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 -->
<form method="post" action="{{url('/report/e-payment')}}">
{{ csrf_field() }}
<div class="row">
<div class="col-md-6">
@include('layouts._searchByDatePatialView')
</div>
</div>
</form>
<hr>
</div><!-- /.row -->
<form method="post" action="{{ url('/report/e-payment-schedule') }}">
{{ csrf_field() }}
<div align="center" class="col-sm-12" style="background: #f9f9f9; padding: 10px;">SELECT APPROPRIATE ACCOUNT DETAILS</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 align="center">
<button type="submit" class="btn btn-success"> Generate E-Payment <i class="fa fa-book"></i> </button>
</div>
<div class="box-body">
<div align="center" class="alert" style="font-size: 20px; background: #f9f9f9;">
<strong>{{strtoupper('Select Beneficiary')}}</strong>
</div>
<hr>
<input type="text" id="myInput" class="form-control" onkeyup="myFunction()" placeholder="Search by Beneficiary/Name..." title="Type in a Beneficiary or name">
<br />
@if($companyList)
<div style="height: 600px; 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")}}</th>
<th>{{strtoupper("Account No.")}}</th>
<th>{{strtoupper('Sort Code')}}</th>
<th>{{strtoupper('Voucher TYpe')}}</th>
<th>{{strtoupper('Amount')}} ₦</th>
<th>
<div>{{strtoupper('Description')}}
<!--<input type="text" name="newDescription" placeholder="Change Description">-->
</div>
</th>
<th>{{strtoupper('Status')}}</th>
<th>{{strtoupper('Date')}}</th>
</tr>
</thead>
<tbody>
@php $key = 1; $countNull = 1; @endphp
@foreach ($companyList as $bl)
@if($bl->companyID == 0 or $bl->companyID == '')
@php
$getStaff = DB::table('transaction_voucher_staff')
->where('transactionID', '=', $bl->transactionID)
->first();
if($getStaff != '')
{
$list3 = DB::connection('mysql2')->table('tblper')
->join('tblbank','tblbank.bankID','=','tblper.bankID')
->join('tblbanklist','tblbanklist.bankID','=','tblper.bankID')
->where('tblper.fileNo', '=', $getStaff->fileNo)
->first();
}
@endphp
@endif
<tr>
<td>
{{$key ++}}
</td>
<td>
<input type="checkbox" tabindex="1" name="beneficiaryCompany[]" id="{{$bl->transactionID}}" value="{{$bl->transactionID}}" class="checkBox">
</td>
<td>@if(!DB::table('transaction_voucher_staff')->where('transactionID', $bl->transactionID)->first() or DB::table('transaction_voucher_staff')->where('transactionID', $bl->transactionID)->count() == 1)
<a href="#" data-toggle="modal" data-target="#editByCPO{{$bl->transactionID}}">
@endif
@if($bl->companyID != 0)
{{$bl->companyname}}
@else
@if(($getStaff))
{{$getStaff->fullname}}
@if($getStaff->fullname == '')
{{$bl->payee}}
@endif
@else
{{$bl->payee}}
@endif
@endif
</a>
</td>
<td>
@if(!DB::table('transaction_voucher_staff')->where('transactionID', $bl->transactionID)->first() or DB::table('transaction_voucher_staff')->where('transactionID', $bl->transactionID)->count() == 1)
<a href="#" data-toggle="modal" data-target="#editByCPO{{$bl->transactionID}}">
@endif
@if($bl->companyname != '')
{{$bl->bank}}
@else
@if($getStaff !='')
@if($getStaff->bankname != '')
{{$getStaff->bankname}}
@else
@if(($list3 != ''))
{{$list3->bank_abbr}}
@endif
@endif
@else
{{$bl->bankname}}
@endif
@endif
</a>
</td>
<td>
@if(!DB::table('transaction_voucher_staff')->where('transactionID', $bl->transactionID)->first() or DB::table('transaction_voucher_staff')->where('transactionID', $bl->transactionID)->count() == 1)
<a href="#" data-toggle="modal" data-target="#editByCPO{{$bl->transactionID}}">
@endif
@if($bl->companyname != '')
{{$bl->accountnumber}}
@else
@if($getStaff !='')
@if($getStaff->accountno != '')
{{$getStaff->accountno}}
@else
@if(($list3 != ''))
{{$list3->AccNo}}
@endif
@endif
@else
{{$bl->accountno}}
@endif
@endif
</a>
</td>
<td>
@if(!DB::table('transaction_voucher_staff')->where('transactionID', $bl->transactionID)->first() or DB::table('transaction_voucher_staff')->where('transactionID', $bl->transactionID)->count() == 1)
<a href="#" data-toggle="modal" data-target="#editByCPO{{$bl->transactionID}}">
@endif
@if($bl->companyname != '')
{{$bl->sortcode }}
@else
@if($getStaff !='')
@if($getStaff->sortcode != '')
{{$getStaff->sortcode}}
@else
@if($list3 != '')
{{$list3->sort_code}}
@endif
@endif
@else
{{$bl->bankcode}}
@endif
@endif
</a>
</td>
<td>
@if(!DB::table('transaction_voucher_staff')->where('transactionID', $bl->transactionID)->first() or DB::table('transaction_voucher_staff')->where('transactionID', $bl->transactionID)->count() == 1)
<a href="#" data-toggle="modal" data-target="#editByCPO{{$bl->transactionID}}">
@endif
{{$bl->departmentname}}
</a>
</td>
<td>
@if(!DB::table('transaction_voucher_staff')->where('transactionID', $bl->transactionID)->first() or DB::table('transaction_voucher_staff')->where('transactionID', $bl->transactionID)->count() == 1)
<a href="#" data-toggle="modal" data-target="#editByCPO{{$bl->transactionID}}">
@endif
{{number_format(($bl->amount), 2, '.', ',')}}
</a>
</td>
<td>
@if(!DB::table('transaction_voucher_staff')->where('transactionID', $bl->transactionID)->first() or DB::table('transaction_voucher_staff')->where('transactionID', $bl->transactionID)->count() == 1)
<a href="#" data-toggle="modal" data-target="#editByCPO{{$bl->transactionID}}">
@endif
@if($bl->descriptioncpo == '')
{{$bl->description}}
@else
{{$bl->descriptioncpo}}
@endif
</a>
</td>
<td class="text-success">{{$bl->approval_status}}</td>
<td>
{{$bl->date}}
<span class="hidden-print">
<br />
@if(DB::table('transaction_voucher_staff')->where('transactionID', $bl->transactionID)->first() or DB::table('transaction_voucher_staff')->where('transactionID', $bl->transactionID)->count() == 1)
<a href="{{url('/staff/report/e-payment/'.$bl->transactionID)}}" class="btn btn-success btn-sm">View More</a>
@endif
</span>
</td>
</tr>
@endforeach
</tbody>
</table>
</div>
<div align="right">
Showing {{($companyList->currentpage()-1)*$companyList->perpage()+1}}
to {{$companyList->currentpage()*$companyList->perpage()}}
of {{$companyList->total()}} entries
</div>
<div class="hidden-print">{{ $companyList->links() }}</div>
@endif
<hr >
</form>
<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="confirmed->join('tblbank','tblbank.bankID','=','tblper.bankID')
->join('tblbanklist','tblbanklist.bankID','=','tblper.bankID')BeforeMe" 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>
</p>
<hr />
<div align="center">
<button type="submit" class="btn btn-success"> Generate E-Payment <i class="fa fa-book"></i> </button>
</div>
</div>
</form>
@foreach ($companyList as $bl)
@if($bl->companyID == 0 or $bl->companyID == '')
@php
$getStaff = DB::table('transaction_voucher_staff')
->where('transactionID', '=', $bl->transactionID)
->first();
if($getStaff != '')
{
$list3 = DB::connection('mysql2')->table('tblper')
->join('tblbank','tblbank.bankID','=','tblper.bankID')
->join('tblbanklist','tblbanklist.bankID','=','tblper.bankID')
->where('tblper.fileNo', '=', $getStaff->fileNo)
->first();
}
@endphp
@endif
@if(!DB::table('transaction_voucher_staff')->where('transactionID', $bl->transactionID)->first() or DB::table('transaction_voucher_staff')->where('transactionID', $bl->transactionID)->count() == 1)
<!--EDIT BY CPO-->
<div class="modal fade" id="editByCPO{{$bl->transactionID}}" 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">
Full Name
<input type="hidden" name="companyID" id="companyID{{$bl->transactionID}}" value="{{$bl->companyID}}">
<input type="text" name="beneficiary" id="beneficiary{{$bl->transactionID}}" class="form-control" value="@if($bl->companyID != 0){{$bl->companyname}}@else @if(($getStaff)){{$getStaff->fullname}}@if($getStaff->fullname == ''){{$bl->payee}}@endif @else{{$bl->payee}}@endif @endif">
</div>
<div class="col-md-6">
Description
<textarea name="description" id="description{{$bl->transactionID}}" class="form-control">@if($bl->descriptioncpo == ''){{$bl->description}} @else {{$bl->descriptioncpo}} @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{{$bl->transactionID}}" class="form-control" value="@if($bl->companyname != ''){{$bl->bank}}@else @if($getStaff !='')@if($getStaff->bankname != ''){{$getStaff->bankname}}@else @if(($list3 != '')){{$list3->bank_abbr}}@endif @endif @else{{$bl->bankname}}@endif @endif">
</div>
<div class="col-md-6">
Account Number
<input type="text" name="accountNumber" id="accountNumber{{$bl->transactionID}}" class="form-control" value="@if($bl->companyname != ''){{$bl->accountnumber}}@else @if($getStaff !='')@if($getStaff->accountno != ''){{$getStaff->accountno}}@else @if(($list3 != '')){{$list3->AccNo}}@endif @endif @else {{$bl->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{{$bl->transactionID}}" class="form-control" value="@if($bl->companyname != ''){{$bl->sortcode }}@else @if($getStaff !='')@if($getStaff->sortcode != ''){{$getStaff->sortcode}}@else @if($list3 != ''){{$list3->sort_code}}@endif @endif @else{{$bl->bankcode}}@endif @endif">
</div>
<div class="col-md-6">
Amount
<input type="text" name="staffAmount" id="staffAmount{{$bl->transactionID}}" class="form-control" value="{{$bl->amount}}">
</div>
</div>
</div>
<div class="modal-footer">
<input type="button" name="editBankDetailsButton" class="editBankDetailsButton btn btn-success" value="Update Bank Details" id="{{$bl->transactionID}}">
<button type="button" class="btn btn-default" data-dismiss="modal">Cancel</button>
</div>
<input type="hidden" name="recordID" value="{{$bl->transactionID}}">
</div>
</div>
</div>
<!-- //EDIT BY CPO -->
@endif
@endforeach
@endsection
@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 companyID = $('#companyID'+id).val();
$.ajax({
url: murl + '/update/e-payment-details-JSON',
type: "post",
data: {'id': id, 'companyID': companyID, '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>
@include ('layouts._searchByDatePatialCpo')
@stop
@section('styles')
<style type="text/css">
/*.table td{
border: #9f9f9f solid 1px !important;
}
.table th{
border: #9f9f9f solid 1px !important;
}
*/
</style>
<!-- Include Required Prerequisites -->
<link rel="stylesheet" type="text/css" href="//cdn.jsdelivr.net/bootstrap/3/css/bootstrap.css" />
<!-- Include Date Range Picker -->
<link rel="stylesheet" type="text/css" href="//cdn.jsdelivr.net/bootstrap.daterangepicker/2/daterangepicker.css" />
@stop