@extends("agentportal.layouts.layout")

@section("title", $details->bank_name)

@section("page_style")
    <link rel="stylesheet" type="text/css" href="{{ url('dist/assets/plugins/custom/datatables/datatables.bundle.css') }}">
    <link rel="stylesheet" type="text/css" href="{{ url('css/select2.min.css') }}">
@endsection

@section("content")
<div class="content d-flex flex-column flex-column-fluid" id="kt_content">
    <!--begin::Entry-->
    <div class="d-flex flex-column-fluid">
        <!--begin::Container-->
        <div class="container">
            <div class="row sponsored-bank-container">
                <div class="col-lg-12">
                    <!--begin::Card-->
                    <div class="card card-custom gutter-b example1 example1-compact">
                        <div class="card-header">
                            <h3 class="card-title">
                                {{ $details->bank_code }} : {{ $details->bank_name }}
                            </h3>
                            <div class="card-toolbar">
                                @php
                                    $url = 'agentportal/sponsoring-banks';
                                @endphp
                                <a href="{{ url($url) }}" class="btn btn-primary font-weight-bolder">{{ trans('message_lang.BTN_BACK') }}</a>
                            </div>
                        </div>
                        <!--begin::Form-->
                        <div class="card-body">
                            <div class="example1">
                                <div class="example1-preview">
                                    <ul class="nav nav-tabs" id="myTab" role="tablist">
                                        <li class="nav-item">
                                            <a class="nav-link active" id="details-tab" data-toggle="tab" href="#details" role="tab" aria-controls="details" aria-selected="true">
                                                {!! trans("message_lang.LBL_DETAILS") !!}
                                            </a>
                                        </li>
                                        <li class="nav-item">
                                            <a class="nav-link" id="locations-tab" data-toggle="tab" href="#locations" role="tab" aria-controls="locations" aria-selected="false">
                                                {!! trans("message_lang.LBL_LOCATIONS") !!}
                                            </a>
                                        </li>
                                        <li class="nav-item">
                                            <a class="nav-link" id="paid-txns-tab" data-toggle="tab" href="#paid-txns" role="tab" aria-controls="paid-txns" aria-selected="false">
                                                {!! trans("message_lang.LBL_PAID_TRANSACTIONS") !!}
                                            </a>
                                        </li>
                                        <li class="nav-item">
                                            <a class="nav-link" id="sent-txns-tab" data-toggle="tab" href="#sent-txns" role="tab" aria-controls="sent-txns" aria-selected="false">
                                                {!! trans("message_lang.LBL_SENT_TXNS") !!}
                                            </a>
                                        </li>
                                        <li class="nav-item">
                                            <a class="nav-link" id="sent-txns-tab" data-toggle="tab" href="#users" role="tab" aria-controls="users" aria-selected="false">
                                                {!! trans("message_lang.LBL_USERS") !!}
                                            </a>
                                        </li>
                                        <li class="nav-item">
                                            <a class="nav-link" id="amount-limit-tab" data-toggle="tab" href="#amount-limit" role="tab" aria-controls="amount-limit" aria-selected="false">
                                                {{ __('message_lang.LBL_SET_TXN_LIMIT') }}
                                            </a>
                                        </li>
                                        {{-- <li class="nav-item">
                                            <a class="nav-link" id="account-tab" data-toggle="tab" href="#account" role="tab" aria-controls="account" aria-selected="false">
                                                {!! trans("message_lang.LBL_BALANCE") !!}
                                            </a>
                                        </li> --}}
                                    </ul>
                                    <div class="tab-content" id="myTabContent">
                                        <div role="tabpanel" aria-labelledby="details-tab" id="details" class="tab-pane fade active show">
                                            <!--begin::Card-->
                                            <div class="card card-custom">
                                                <div class="card-header">
                                                    <div class="card-title">
                                                        <h3 class="card-label">{!! trans("message_lang.SIDEBAR_LBL_SPONSORING_BANKS") !!}</h3>
                                                    </div>
                                                    <div class="card-toolbar">

                                                    </div>
                                                </div>
                                                <div class="card-body">
                                                    <div class="row">
                                                        <div class="col-md-8">
                                                            <table class="table table-sm table-borderless">
                                                                <tr>
                                                                    <td>{!! trans("message_lang.LBL_CODE") !!}:</td>
                                                                    <th>{{ _set_dash($details->bank_code) }}</th>
                                                                </tr>
                                                                <tr>
                                                                    <td>{!! trans("message_lang.LBL_NAME") !!}:</td>
                                                                    <th>{{ _set_dash($details->bank_name) }}</th>
                                                                </tr>
                                                                <tr>
                                                                    <td>{{ trans('message_lang.LBL_COUNTRY') }}:</td>
                                                                    <th>{{ _set_dash($details->country_code) }}</th>
                                                                </tr>
                                                                <tr>
                                                                    <td>{{ trans('message_lang.LBL_STATUS') }}:</td>
                                                                    <th>{{ (isset($details->status) && $details->status == 1) ? "Active" : "Inactive"  }}</th>
                                                                </tr>
                                                            </table>
                                                        </div>
                                                        <div class="col-md-4">
                                                            @if($details->bank_logo != '')
                                                                <div class="sender-logo text-center pb-2">
                                                                    <img onerror="this.onerror=null;this.src='{{ URL::to('/') }}/public/uploads/default/100_no_img.jpg';" src="{{ asset($details->bank_logo) }}" style="width: 50%; height:50%">
                                                                </div>
                                                            @else
                                                                <div class="sender-logo text-center pb-2"><img onerror="this.onerror=null;this.src='{{ URL::to('/') }}/public/uploads/default/100_no_img.jpg';" src="{{ URL::to('/') }}/public/uploads/default/100_no_img.jpg"></div>
                                                            @endif
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                            <!--end::Card-->
                                        </div>
                                        <div role="tabpanel" aria-labelledby="locations-tab" id="locations" class="tab-pane fade">
                                            <!--begin::Card-->
                                            <div class="card card-custom">
                                                <div class="card-header">
                                                    <div class="card-title">
                                                        <h3 class="card-label">{!! trans("message_lang.LBL_LOCATIONS") !!}</h3>
                                                    </div>
                                                    <div class="card-toolbar">
                                                        {{-- <a href="{{ url('agentportal/sponsoring-banks/'.base64_encode($details->id).'/updateLocations') }}" class="btn btn-primary font-weight-bolder">{{ trans('message_lang.LBL_UPDATE_LOCATION') }}</a> --}}
                                                    </div>
                                                    <input type="hidden" name="agent_country_id" id="agent_country_id" value="{{@$countryId ?? 0}}">
                                                </div>
                                                <div class="card-body">
                                                    <!--begin: Datatable-->
                                                    <table id="datatable2" class="table table-bordered grid-table nowrap">
                                                        <thead>
                                                            <tr>
                                                                <th>#</th>
                                                                <th>{!! trans("message_lang.LBL_CODE") !!}</th>
                                                                <th>{!! trans("message_lang.LBL_NAME") !!}</th>
                                                                <th>{!! trans("message_lang.LBL_PHONE") !!}</th>
                                                                <th>{!! trans("message_lang.LBL_BALANCE") !!}</th>
                                                                <th>{!! trans("message_lang.LBL_STATUS") !!}</th>
                                                                <th>{!! trans("message_lang.LBL_ACTION") !!}</th>
                                                            </tr>
                                                        </thead>
                                                        <tfoot>
                                                            <tr>
                                                                <th colspan="4" style="text-align:right">Total:</th>
                                                                <th></th>
                                                                <th></th>
                                                                <th></th>
                                                                <th></th>
                                                            </tr>
                                                        </tfoot>
                                                    </table>
                                                    <!--end: Datatable-->
                                                </div>
                                            </div>
                                            <!--end::Card-->
                                        </div>
                                        <div role="tabpanel" aria-labelledby="paid-txns-tab" id="paid-txns" class="tab-pane fade">
                                            <div class="card-body">
                                                <form method="POST" action="{{ url('agentportal/sponsoring-banks/payments/csvExport') }}" name="form">
                                                    @csrf
                                                    <div class="form-group row justify-content-end">
                                                        <div class="col-md-3">
                                                            <button type="submit" name="export" class="btn btn-primary font-weight-bolder float-right">{!! trans('message_lang.LBL_EXPORT_TO_CSV') !!}</button>
                                                        </div>
                                                    </div>
                                                    <div class="form-group row justify-content-md-center">
                                                        <div class="col-md-3">
                                                            <label class="" style="width: 100%;" for="agent_location_id">{!! trans('message_lang.LBL_LOCATION') !!} <span style="color:red;"></span></label>
                                                            <select name="agent_location_id" id="agent_location_id" class="form-control custom-field">
                                                                <option value="">{!! trans('message_lang.PLACEHOLDER_SELECT') !!}</option>
                                                                @foreach ($locations as $key => $location)
                                                                    <option value="{{ $key }}">{{ $location }}</option>
                                                                @endforeach
                                                            </select>
                                                        </div>

                                                        @include('agentportal.layouts.duration_filter')

                                                        <input type="hidden" name="agent_country_id" value="{{@$countryId ?? 0}}">
                                                        <input type="hidden" name="sponsored_banks" value="{{$details->id}}">
                                                        <input type="hidden" name="fromSponsoredBanks" id="fromSponsoredBanks" value="1">
                                                    </div>

                                                    <div class="form-group row justify-content-md-center">
                                                    </div>
                                                </form>
                                                <!--begin: Datatable-->
                                                <table id="datatable" class="table table-bordered grid-table nowrap">
                                                    <thead>
                                                        <tr>
                                                            <th>#</th>
                                                            <th>{!! trans('message_lang.LBL_PICKUP_CODE') !!}</th>
                                                            <th>{!! trans('message_lang.LBL_LOCATION') !!}</th>
                                                            <th>{!! trans('message_lang.LBL_COMPANY') !!}</th>
                                                            <th>{!! trans('message_lang.LBL_PAID_DATE') !!}</th>
                                                            <th>{!! trans('message_lang.LBL_AMOUNT') !!}</th>
                                                            <th>{!! trans('message_lang.LBL_PAID_BY') !!}</th>
                                                            <th>{!! trans('message_lang.LBL_ID') !!}</th>
                                                        </tr>
                                                    </thead>
                                                </table>
                                                <!--end: Datatable-->
                                            </div>
                                        </div>
                                        <div role="tabpanel" aria-labelledby="sent-txns-tab" id="sent-txns" class="tab-pane fade">
                                            <div class="card-body">
                                                <form class="" action="{{ url('agentportal/sponsoring-banks/send-money/csvExport') }}" method="post">
                                                    {{ csrf_field() }}
                                                    <div class="form-group row justify-content-end">
                                                        <div class="col-md-3">
                                                            <input type="hidden" name="hdn_sent_status" id="hdn_sent_status" value="">
                                                            <input type="hidden" name="hdn_sent_from_date" id="hdn_sent_from_date" value="">
                                                            <input type="hidden" name="hdn_sent_to_date" id="hdn_sent_to_date" value="">
                                                            <input type="hidden" name="hdn_sponsored_banks" id="hdn_sponsored_banks" value="{{ $details->id }}">
                                                            <input type="hidden" name="hdn_export_type" id="hdn_export_type" value="true">
                                                            <input type="hidden" name="fromSponsoredBanks" id="fromSponsoredBanks" value="1">
                                                            <button type="submit" name="export" class="btn btn-primary font-weight-bolder float-right">Export to CSV</button>
                                                        </div>
                                                    </div>

                                                    <div class="form-group row justify-content-md-center">
                                                        <div class="col-md-3">
                                                            <label class="" style="width: 100%;" for="agent_location_id3">{!! trans('message_lang.LBL_LOCATION') !!} <span style="color:red;"></span></label>
                                                            <select name="agent_location_id3" id="agent_location_id3" class="form-control custom-field">
                                                                <option value="">{!! trans('message_lang.PLACEHOLDER_SELECT') !!}</option>
                                                                @foreach ($locations as $key => $location)
                                                                    <option value="{{ $key }}">{{ $location }}</option>
                                                                @endforeach
                                                            </select>
                                                        </div>

                                                        <div class="col-md-3">
                                                            <label class="" style="width: 100%;" for="sent_status">{!! trans('message_lang.LBL_TXN_STATUS') !!} <span style="color:red;"></span></label>
                                                            <select name="sent_status[]" id="sent_status" class="form-control custom-field" multiple>
                                                                <option value="">{!! trans('message_lang.PLACEHOLDER_SELECT') !!}</option>
                                                                @foreach($smtxnStatus as $key => $value)
                                                                    <option value="{{ $value }}">{{ $txnStatuses[$key] }}</option>
                                                                @endforeach
                                                            </select>
                                                        </div>

                                                        <div class="col-md-3">
                                                            <label class="" style="width: 100%;" for="date3">{!! trans('message_lang.LBL_DURATION') !!} <span style="color:red;"></span></label>
                                                            <select name="date3" id="date3" class="form-control custom-field">
                                                                <option value="1">This Week</option>
                                                                <option value="2" selected>This Month</option>
                                                                <option value="3">Previous Week</option>
                                                                <option value="4">Previous Month</option>
                                                                <option value="5">Custom Date</option>
                                                            </select>
                                                        </div>
                                                    </div>

                                                    <div class="form-group row justify-content-md-center">
                                                        <div class="col-md-3 customDate3" style="display: none;">
                                                            <label for="sent_from_date">{{ __('message_lang.LBL_FROM_DATE') }} <span style="color:red;">*</span></label>
                                                            <input class="form-control @error('sent_from_date') is-invalid @enderror custom-field" id="sent_from_date" type="text" name="sent_from_date" placeholder="{{ __('message_lang.LBL_FROM_DATE') }}" value="{{ app()->getLocale() == "fr" ? date('d-m-Y') : date('Y-m-d') }}">
                                                            @error('sent_from_date')
                                                                <span class="invalid-feedback" role="alert">
                                                                    <strong>{{ $message }}</strong>
                                                                </span>
                                                            @enderror
                                                        </div>

                                                        <div class="col-md-3 customDate3" style="display: none;">
                                                            <label for="sent_to_date">{{ __('message_lang.LBL_TO_DATE') }} <span style="color:red;">*</span></label>
                                                            <input class="form-control @error('sent_to_date') is-invalid @enderror custom-field" id="sent_to_date" type="text" name="sent_to_date" placeholder="{{ __('message_lang.LBL_TO_DATE') }}">
                                                            @error('sent_to_date')
                                                                <span class="invalid-feedback" role="alert">
                                                                    <strong>{{ $message }}</strong>
                                                                </span>
                                                            @enderror
                                                        </div>
                                                    </div>
                                                </form>
                                                <!--begin: Datatable-->
                                                <table id="datatable3" class="table table-bordered grid-table nowrap">
                                                    <thead>
                                                        <tr>
                                                            <th>#</th>
                                                            <th>{{ trans('message_lang.LBL_REF_NO') }}</th>
                                                            <th>{{ trans('message_lang.LBL_DATE') }}</th>
                                                            <th>{{ trans('message_lang.LBL_LOCATION') }}</th>
                                                            <th>{{ trans('message_lang.LBL_AMOUNT') }}</th>
                                                            <th>{{ trans('message_lang.LBL_TXN_STATUS') }}</th>
                                                            <th>{{ trans('message_lang.LBL_TOTAL_AMOUNT') }}</th>
                                                            <th>{{ trans('message_lang.LBL_ID') }}</th>
                                                        </tr>
                                                    </thead>
                                                </table>
                                                <!--end: Datatable-->
                                            </div>
                                        </div>
                                        <div role="tabpanel" aria-labelledby="users-tab" id="users" class="tab-pane fade">
                                            <!--begin::Card-->
                                            <div class="card card-custom">
                                                <div class="card-header">
                                                    <div class="card-title">
                                                        <h3 class="card-label">{!! trans("message_lang.LBL_USERS") !!}</h3>
                                                    </div>
                                                    <div class="card-toolbar">
                                                        <!--begin::Button-->
                                                        <a href="{{ url('agentportal/sponsoring-banks/' . $details->id . '/users/create') }}" class="btn btn-primary font-weight-bolder">{!! trans("message_lang.BTN_ADD_NEW") !!}</a>
                                                        <!--end::Button-->
                                                    </div>
                                                </div>
                                                <div class="card-body">
                                                    <!--begin: Datatable-->
                                                    <table id="datatable4" class="table table-bordered grid-table nowrap">
                                                        <thead>
                                                            <tr>
                                                                <th>#</th>
                                                                <th>{!! trans("message_lang.LBL_NAME") !!}</th>
                                                                <th>{!! trans("message_lang.LBL_ROLE") !!}</th>
                                                                <th>{!! trans("message_lang.LBL_USERNAME") !!}</th>
                                                                <th>{!! trans("message_lang.LBL_EMAIL") !!}</th>
                                                                <th>{!! trans("message_lang.LBL_PHONE") !!}</th>
                                                                <th>{!! trans("message_lang.LBL_STATUS") !!}</th>
                                                                <th>{!! trans("message_lang.LBL_ACTION") !!}</th>
                                                            </tr>
                                                        </thead>
                                                    </table>
                                                    <!--end: Datatable-->
                                                </div>
                                            </div>
                                            <!--end::Card-->
                                        </div>
                                        <div role="tabpanel" aria-labelledby="amount-limit-tab" id="amount-limit" class="tab-pane fade">
                                            <br>
                                             <!--begin::Form-->
                                            <form method="post" action="{{url('agentportal/sponsoring-banks/updateLimits', $details->id) }}" />
                                                @csrf
                                                <div class="form-group">
                                                    <label class="" for="max_limit_send_txn_a_day">Maximum transaction limit for sending money per day</label>
                                                    <input min="0.01" step="0.01" onkeyup="if(this.value<0){this.value= this.value * -1}" class="form-control @error('max_limit_send_txn_a_day') is-invalid @enderror custom-field" id="max_limit_send_txn_a_day" name="max_limit_send_txn_a_day" value="{{ old('max_limit_send_txn_a_day', @$details->max_limit_send_txn_a_day) }}" type="number" placeholder="Maximum transaction limit for sending money per day" >
                                                    @error('max_limit_send_txn_a_day')
                                                        <span class="invalid-feedback" role="alert">
                                                            <strong>{{ $message }}</strong>
                                                        </span>
                                                    @enderror
                                                </div>
                                                <div class="form-group">
                                                    <label class="" for="max_limit_send_amount_single_txn">{{ __('message_lang.LBL_SEND_MONEY_MAX_AMOUNT_LIMIT_SINGLE_TXN') }}</label>
                                                    <input min="0.01" step="0.01" onkeyup="if(this.value<0){this.value= this.value * -1}" class="form-control @error('max_limit_send_amount_single_txn') is-invalid @enderror custom-field" id="max_limit_send_amount_single_txn" name="max_limit_send_amount_single_txn" value="{{ old('max_limit_send_amount_single_txn', @$details->max_limit_send_amount_single_txn) }}" type="number" placeholder="{{ __('message_lang.LBL_SEND_MONEY_MAX_AMOUNT_LIMIT_SINGLE_TXN') }}" >
                                                    @error('max_limit_send_amount_single_txn')
                                                        <span class="invalid-feedback" role="alert">
                                                            <strong>{{ $message }}</strong>
                                                        </span>
                                                    @enderror
                                                </div>
                                                <div class="form-group">
                                                    <label class="" for="max_limit_total_send_amount_1_day">{{ __('message_lang.LBL_SEND_MONEY_MAX_AMOUNT_LIMIT_1_DAY') }}</label>
                                                    <input min="0.01" step="0.01" onkeyup="if(this.value<0){this.value= this.value * -1}" class="form-control @error('max_limit_total_send_amount_1_day') is-invalid @enderror custom-field" id="max_limit_total_send_amount_1_day" name="max_limit_total_send_amount_1_day" value="{{ old('max_limit_total_send_amount_1_day', @$details->max_limit_total_send_amount_1_day) }}" type="number" placeholder="{{ __('message_lang.LBL_SEND_MONEY_MAX_AMOUNT_LIMIT_1_DAY') }}" >
                                                    @error('max_limit_total_send_amount_1_day')
                                                        <span class="invalid-feedback" role="alert">
                                                            <strong>{{ $message }}</strong>
                                                        </span>
                                                    @enderror
                                                </div>
                                                <div class="form-group">
                                                    <label class="" for="max_limit_total_send_amount_7_days">{{ __('message_lang.LBL_SEND_MONEY_MAX_AMOUNT_LIMIT_7_DAYS') }}</label>
                                                    <input min="0.01" step="0.01" onkeyup="if(this.value<0){this.value= this.value * -1}" class="form-control @error('max_limit_total_send_amount_7_days') is-invalid @enderror custom-field" id="max_limit_total_send_amount_7_days" name="max_limit_total_send_amount_7_days" value="{{ old('max_limit_total_send_amount_7_days', @$details->max_limit_total_send_amount_7_days) }}" type="number" placeholder="{{ __('message_lang.LBL_SEND_MONEY_MAX_AMOUNT_LIMIT_7_DAYS') }}" >
                                                    @error('max_limit_total_send_amount_7_days')
                                                        <span class="invalid-feedback" role="alert">
                                                            <strong>{{ $message }}</strong>
                                                        </span>
                                                    @enderror
                                                </div>
                                                <div class="form-group">
                                                    <label class="" for="max_limit_total_send_amount_30_days">{{ __('message_lang.LBL_SEND_MONEY_MAX_AMOUNT_LIMIT_30_DAYS') }}</label>
                                                    <input min="0.01" step="0.01" onkeyup="if(this.value<0){this.value= this.value * -1}" class="form-control @error('max_limit_total_send_amount_30_days') is-invalid @enderror custom-field" id="max_limit_total_send_amount_30_days" name="max_limit_total_send_amount_30_days" value="{{ old('max_limit_total_send_amount_30_days', @$details->max_limit_total_send_amount_30_days) }}" type="number" placeholder="{{ __('message_lang.LBL_SEND_MONEY_MAX_AMOUNT_LIMIT_30_DAYS') }}" >
                                                    @error('max_limit_total_send_amount_30_days')
                                                        <span class="invalid-feedback" role="alert">
                                                            <strong>{{ $message }}</strong>
                                                        </span>
                                                    @enderror
                                                </div>
                                                <div class="form-row">
                                                    <div class="col">
                                                        <button type="submit"  class="btn btn-primary btn-lg btn-block">{{ __('message_lang.LBL_UPDATE_LIMITS') }}</button>
                                                    </div>
                                                </div>
                                            </form>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>

                        <div class="card-footer">

                        </div>
                        <!--end::Form-->
                    </div>
                    <!--end::Card-->
                </div>
            </div>
        </div>
        <!--end::Container-->
    </div>
    <!--end::Entry-->
</div>
@endsection

@section("page_vendors")
    <script src="{{ url('dist/assets/plugins/custom/datatables/datatables.bundle.js') }}"></script>
@endsection

@section("page_script")
    <script type="text/javascript">
        var enable_location = "{!! Auth::guard('agentportal')->user()->hasAnyRole('tresorerie') !!}";
        var datatable;
        var datatable2;
        var datatable3;
        var datatable4;
        $(document).ready(function () {

            $('#agent_location_id, #agent_location_id3, #agent_location_id4').select2({
                allowClear: true,
                placeholder: "{!! trans('message_lang.PLACEHOLDER_SELECT_LOCATION') !!}",
            });

            $("#sent_status").select2({
                allowClear: true,
                placeholder: "All",
            });

            $("#duration").on("change", function() {
                var date1 = $(this).val();
                if(date1 == "6") {
                    $(".customDate").show();
                } else {
                    $(".customDate").hide();
                }
                datatable.draw(); // Refilter the table
            });

            $("#date2").on("change", function() {
                var date2 = $(this).val();
                if(date2 == "0") {
                    $(".customDate2").show();
                } else {
                    $(".customDate2").hide();
                }
                datatable2.draw(); // Refilter the table
            });

            $("#date3").on("change", function() {
                var date3 = $(this).val();
                if(date3 == "5") {
                    $(".customDate3").show();
                } else {
                    $(".customDate3").hide();
                }
                datatable3.draw(); // Refilter the table
            });

            $('#from_date, #sent_from_date').datepicker({
                "format": "{{ app()->getLocale() == "fr" ? 'dd-mm-yyyy' : 'yyyy-mm-dd' }}",
                "keyboardNavigation": false,
                "autoclose": true,
                "startDate": '-2y -1m',
                "endDate": new Date()
            });

            $('#from_date').datepicker({
                "format": "{{ app()->getLocale() == "fr" ? 'dd-mm-yyyy' : 'yyyy-mm-dd' }}",
                "keyboardNavigation": false,
                "autoclose": true,
            }).on('change', function(e){
                var date = new Date($("#from_date").val());
                var d = date.getDate();
                var m = date.getMonth();
                var y = date.getFullYear();
                var minDate = new Date(y, m, d + 31);

                $('#to_date').datepicker('destroy').datepicker({
                    "format": "{{ app()->getLocale() == "fr" ? 'dd-mm-yyyy' : 'yyyy-mm-dd' }}",
                    "keyboardNavigation": false,
                    "autoclose": true,
                    "startDate": $("#from_date").val(),
                    "endDate":minDate
                }).on('change', function(e) {
                    datatable.draw(); // Refilter the table
                }).datepicker('setDate', minDate);
            });

            $('#sent_from_date').datepicker({
                "format": "{{ app()->getLocale() == "fr" ? 'dd-mm-yyyy' : 'yyyy-mm-dd' }}",
                "keyboardNavigation": false,
                "autoclose": true,
            }).on('change', function(e){
                var date = new Date($("#sent_from_date").val());
                var d = date.getDate();
                var m = date.getMonth();
                var y = date.getFullYear();
                var minDate = new Date(y, m, d + 31);

                $('#sent_to_date').datepicker('destroy').datepicker({
                    "format": "{{ app()->getLocale() == "fr" ? 'dd-mm-yyyy' : 'yyyy-mm-dd' }}",
                    "keyboardNavigation": false,
                    "autoclose": true,
                    "startDate": $("#sent_from_date").val(),
                    "endDate":minDate
                }).on('change', function(e) {
                    datatable3.draw(); // Refilter the table
                }).datepicker('setDate', minDate);
            });

            $('#agent_location_id').on('change', function() {
                datatable.draw();
            });

            $('#agent_location_id3').on('change', function() {
                datatable3.draw();
            });

            $('#sent_status').change(function() {
                $("#hdn_sent_status").val($(this).val());
                datatable3.draw();
            });

            $('#account_from_date, #account_to_date').datepicker({
                "format": "{{ app()->getLocale() == "fr" ? 'dd-mm-yyyy' : 'yyyy-mm-dd' }}",
                "keyboardNavigation": false,
                "autoclose": true,
                "startDate": '-2y -1m',
                "endDate": new Date()
            });

            var sent_status      = $("#sent_status").val();
            var fromDate    = $("#sent_from_date").val();
            var toDate      = $("#sent_to_date").val();

            $("#hdn_sent_status").val(sent_status);
            $("#hdn_sent_from_date").val(fromDate);
            $("#hdn_sent_to_date").val(toDate);

            if ($('#datatable').length > 0) {
                datatable = $('#datatable').DataTable({
                    footerCallback: function (row, data, start, end, display) {
                        var api = this.api(), data;

                        // Remove the formatting to get integer data for summation
                        var decimal = i => i.toString().replace(/[\$,]/g, '');

                        // Total over all pages
                        total = api.column(3).data().reduce( function (a, b) {
                            let arr = b.split(' ');
                            b = 0;
                            if (arr[arr.length - 1] != 'USD') {
                                b = arr[0];
                            }
                            a = (parseFloat(decimal(a)) || 0).toFixed(2);
                            b = (parseFloat(decimal(b)) || 0).toFixed(2);
                            return parseFloat(a) + parseFloat(b);
                        }, 0).toFixed(2).toLocaleString();

                        // USD Total over all pages
                        usdTotal = api.column(3).data().reduce( function (a, b) {
                            let arr = b.split(' ');
                            b = 0;
                            if (arr[arr.length - 1] == 'USD') {
                                b = arr[0];
                            }
                            a = (parseFloat(decimal(a)) || 0).toFixed(2);
                            b = (parseFloat(decimal(b)) || 0).toFixed(2);
                            return parseFloat(a) + parseFloat(b);
                        }, 0).toFixed(2).toLocaleString();
                        if (parseFloat(usdTotal) > 0) {
                            total += ' & USD ' + usdTotal;
                        }

                        // Update footer
                        $(api.column(3).footer()).html(total);
                    },
                    language: {
                        lengthMenu: "{!! trans('message_lang.DATATABLE_LBL_SHOW') !!} _MENU_ {!! trans('message_lang.DATATABLE_LBL_ENTRIES') !!}",
                        search: "{!! trans('message_lang.DATATABLE_LBL_SEARCH') !!}"
                    },
                    processing: true,
                    serverSide: true,
                    responsive: true,
                    lengthMenu: [[10, 50, 100, -1], [10, 50, 100, 'All']],
                    pageLength: 50,
                    aaSorting: [7, 'DESC'],
                    ajax: {
                        url: "{{ url('agentportal/sponsoring-banks/payments/ajaxDatatable') }}",
                        type: "POST",
                        dataType: "json",
                        headers: {
                            'X-CSRF-TOKEN': "{{ csrf_token() }}"
                        },
                        data: function(data) {
                            data.from_date = $('#from_date').val();
                            data.to_date = $('#to_date').val();
                            data.duration = $('#duration').val();
                            data.agent_location_id = $('#agent_location_id').val();
                            data.agent_country_id = "{{@$countryId ?? 0}}";
                            data.sponsored_banks = "{{$details->id}}";
                        },
                    },
                    columnDefs: [
                        {
                            targets: [0], // first column & numbering column
                            orderable: false, // set not orderable
                        },
                        {
                            targets: [7], // column index
                            visible: false,
                        }
                    ],
                    columns: [
                        {
                            data: 'DT_RowIndex',
                            name: 'DT_RowIndex'
                        },
                        {
                            data: 'pickup_code',
                            name: 'pickup_code',
                            render: function(data, type, row) {
                                return '<a href="' + row.data.url + '">' + data + '</a>';
                            }
                        },
                        {
                            data: 'location_name',
                            name: 'location_name'
                        },
                        {
                            data: 'company',
                            name: 'company'
                        },
                        {
                            data: 'paid_at',
                            name: 'paid_at'
                        },
                        {
                            data: 'amount',
                            name: 'amount'
                        },
                        {
                            data: 'user',
                            name: 'user'
                        },
                        {
                            data: 'id',
                            name: 'id'
                        }
                    ],
                });
            }

            if ($('#datatable3').length > 0) {
                datatable3 = $('#datatable3').DataTable({
                    language: {
                        lengthMenu: "{!! trans('message_lang.DATATABLE_LBL_SHOW') !!} _MENU_ {!! trans('message_lang.DATATABLE_LBL_ENTRIES') !!}",
                        search: "{!! trans('message_lang.DATATABLE_LBL_SEARCH') !!}"
                    },
                    processing: true,
                    serverSide: true,
                    responsive: true,
                    pageLength: 50,
                    'aaSorting': [ 0, 'ASC'],
                    "ajax": {
                        "url": "{!! url('agentportal/sponsoring-banks/send-money/ajaxDatatable') !!}",
                        "type": "POST",
                        "dataType": "json",
                        headers: {
                            'X-CSRF-TOKEN': "{{csrf_token()}}"
                        },
                        "data": function(data) {
                            //get values
                            var sent_status = $("#sent_status").val();
                            var fromDate = $('#sent_from_date').val();
                            var toDate = $('#sent_to_date').val();

                            //append to data
                            data.status = sent_status;
                            data.fromDate = fromDate;
                            data.toDate = toDate;
                            data.duration = $('#date3').val();
                            data.agent_location_id = $("#agent_location_id3").val();
                            data.agent_country_id = "{{@$countryId ?? 0}}";
                            data.sponsored_banks = "{{$details->id}}";
                            data.fromSponsoredBanks = 1;
                        },
                    },
                    "columnDefs": [
                        {
                            "targets": [0, 5], //first column / numbering column
                            "orderable": false, //set not orderable
                        },
                        {
                            'targets': [ 0 ], /* column index  */
                            "searchable": false,
                        },
                        {
                            'targets': [ 7 ], /* column index  */
                            "visible": false,
                        }
                    ],
                    columns: [
                        {
                            data: 'DT_RowIndex',
                            name: 'DT_RowIndex'
                        },
                        {
                            data: 'reference_no',
                            name: 'reference_no'
                        },
                        {
                            data: 'created_at',
                            name: 'created_at'
                        },
                        {
                            data: 'agent_location_name',
                            name: 'agent_location_name'
                        },
                        {
                            data: 'sending_amount',
                            name: 'sending_amount'
                        },
                        {
                            data: 'status',
                            name: 'status'
                        },
                        {
                            data: 'payout_amount',
                            name: 'payout_amount'
                        },
                        {
                            data: 'id',
                            name: 'id'
                        }
                    ]
                });
            }

            if ($('#datatable2').length > 0) {
                datatable2 = $('#datatable2').DataTable({
                    "footerCallback": function ( row, data, start, end, display ) {
                        var api = this.api(), data;

                        // Remove the formatting to get integer data for summation
                        var intVal = function ( i ) {
                            return typeof i === 'string' ?
                                i.replace(/[\$,]/g, '')*1 :
                                typeof i === 'number' ?
                                    i : 0;
                        };

                        // Total over all pages
                        total_paid = api
                            .column( 4 )
                            .data()
                            .reduce( function (a, b) {
                                return intVal(a) + intVal(b);
                            }, 0 );

                        total_paid = total_paid.toLocaleString();

                        // Update footer
                        $( api.column( 4 ).footer() ).html(
                            total_paid
                        );
                    },
                    processing: true,
                    serverSide: true,
                    responsive: true,
                    lengthMenu: [[10, 50, 100, -1], [10, 50, 100, 'All']],
                    pageLength: 50,
                    aaSorting: [7, 'DESC'],
                    ajax: {
                        url: "{{ url('agentportal/sponsoring-banks/locations/ajaxDatatable') }}",
                        type: "POST",
                        dataType: "json",
                        headers: {
                            'X-CSRF-TOKEN': "{{ csrf_token() }}"
                        },
                        data: function(data) {
                            data.country_id = "{{@$countryId ?? 0}}";
                            data.sponsored_banks = "{{$details->id}}";
                            data.fromSponsoredBanks = 1;
                        }
                    },
                    columnDefs: [
                        {
                            targets: [0, 6], // first column & numbering column
                            orderable: false, // set not orderable
                        },
                        {
                            targets: [7], // column index
                            visible: false,
                        }
                    ],
                    columns: [
                        {
                            data: 'DT_RowIndex',
                            name: 'DT_RowIndex'
                        },
                        {
                            data: 'code',
                            name: 'code',
                            render: function(data, type, row) {
                                if(enable_location){
                                    return data;
                                } else {
                                    return '<a href="' + row.data.url + '?CU=1">' + data + '</a>';
                                }
                            }
                        },
                        {
                            data: 'name',
                            name: 'name'
                        },
                        {
                            data: 'phone',
                            name: 'phone'
                        },
                        {
                            data: 'balance',
                            name: 'balance'
                        },
                        {
                            data: 'status',
                            name: 'status'
                        },
                        {
                            data: 'bank_action',
                            name: 'bank_action'
                        },
                        {
                            data: 'id',
                            name: 'id'
                        }
                    ]
                });
            }

            if ($('#datatable4').length > 0) {
                datatable4 = $('#datatable4').DataTable({
                    processing: true,
                    serverSide: true,
                    responsive: true,
                    lengthMenu: [[10, 50, 100, -1], [10, 50, 100, 'All']],
                    pageLength: 10,
                    aaSorting: [8, 'DESC'],
                    ajax: {
                        url: "{{ url('agentportal/sponsoring-banks/' . $details->id . '/users/ajaxDatatable') }}",
                        type: "POST",
                        dataType: "json",
                        headers: {
                            'X-CSRF-TOKEN': "{{ csrf_token() }}"
                        },
                        data: {
                            //
                        }
                    },
                    columnDefs: [
                        {
                            targets: [0, 7], // first column & numbering column
                            orderable: false, // set not orderable
                        },
                        // {
                        //     targets: [3, 5, 8], // column index
                        //     searchable: false,
                        // },
                        {
                            targets: [8], // column index
                            visible: false,
                        }
                    ],
                    columns: [
                        {
                            data: 'DT_RowIndex',
                            name: 'DT_RowIndex'
                        },
                        {
                            data: 'name',
                            name: 'name'
                        },
                        {
                            data: 'role',
                            name: 'role'
                        },
                        {
                            data: 'username',
                            name: 'username'
                        },
                        {
                            data: 'email',
                            name: 'email'
                        },
                        {
                            data: 'phone',
                            name: 'phone'
                        },
                        {
                            data: 'status',
                            name: 'status'
                        },
                        {
                            data: 'action',
                            name: 'action'
                        },
                        {
                            data: 'id',
                            name: 'id'
                        }
                    ]
                });
            }
        });

        function change_status2(selector) {
            var status = $(selector).data("status");
            var id = $(selector).data("id");
            $.ajax({
                url: "{!! url('agentportal/sponsoring-banks/' . $details->id . '/users/ajaxChangeStatus') !!}",
                type: "POST",
                dataType: "json",
                headers: {
                    'X-CSRF-TOKEN': "{{ csrf_token() }}"
                },
                data: {
                    id: id,
                    status: status
                },
                success: function (response) {
                    if (response.status == "success") {
                        datatable4.draw();
                        toastr.success('{{ trans('message_lang.STATUS_CHANGED_SUCCESSFULLY') }}', 'Success');
                    } else {
                        toastr.error('{{ trans('message_lang.FAILED_TO_UPDATE_STATUS') }}', 'Error');
                    }
                }
            });
        }
    </script>
@endsection