ÿØÿà JFIF ÿá Exif MM * ÿÛ C
Server IP : 199.250.214.225 / Your IP : 3.22.79.18 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