@extends("agentportal.layouts.layout")

@section("title", trans("message_lang.LBL_ACC_STATEMENTS"))

@section("page_style")
<link rel="stylesheet" type="text/css" href="{{ url('css/select2.min.css') }}">
<style type="text/css">
    .select2-container--default .select2-selection--single {
        min-height: 38px;
        max-height: 38px;
    }
    .card.card-custom > .card-header.align-center {
    align-items: center;
}
.perPage label {
    display: flex;
    align-items: center;
    justify-content: flex-start;
    flex-wrap: wrap;
}
.perPage label select{width: auto;margin: 0 5px}
.pagination {
    display: flex;
    justify-content: space-between;
}
.card-header.align-center h4{margin-bottom: 0;}
.card-header.align-center label{margin-bottom: 0}
</style>
@endsection

<div id="loading"  style="display:none;">
    <div id="image-loader">
        <img  src="{{ url('img/loading.gif')}}" alt="Loading..." />
    </div>
</div>
@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">
                <div class="col-lg-12">
                    <!--begin::Card-->
                    <div class="card card-custom gutter-b example1 example1-compact">
                        <div class="card-header align-center">
                            <h3 class="card-title">
                                {!! trans("message_lang.LBL_ACC_STATEMENTS") !!}
                            </h3>
                            @hasanyrole('location administrator|main teller')
                            <h4>
                                @if(isset(auth()->guard('agentportal')->user()->agentLocation) && auth()->guard('agentportal')->user()->agentLocation->parent_id == 0)
                                    <label>Balance : {!! number_format(auth()->guard('agentportal')->user()->agentLocation->balance,2) !!}  {!! auth()->guard('agentportal')->user()->agentLocation->currency !!}</label>
                                @endif
                            </h4>
                            @endhasanyrole
                            <div class="card-toolbar">
                                <!--begin::Button-->
                                @hasanyrole('administrator|operation|compliance|finance back office|tresorerie')
                                    @if (request('location_id'))
                                        <span style="display: none;" id="show-country-filter">false</span>

                                        <a href="{{ url('agentportal/summary/location/' . request('location_id') . '/repayment') }}" class="btn btn-warning font-weight-bolder">{!! trans("message_lang.BTN_REPAYMENT") !!}</a>

                                        <div class="subheader-separator subheader-separator-ver mt-2 mb-2 mr-4 bg-gray-200"></div>

                                        <a href="{{ url('agentportal/summary/location/' . request('location_id') . '/adjustment') }}" class="btn btn-success font-weight-bolder">{!! trans("message_lang.BTN_ADJUSTMENT") !!}</a>

                                        <div class="subheader-separator subheader-separator-ver mt-2 mb-2 mr-4 bg-gray-200"></div>

                                        <a href="{{ route('agentportal.summary-location') }}"class="btn btn-primary font-weight-bolder">{{ trans('message_lang.BTN_BACK') }}</a>
                                    @else
                                        <span style="display: none;" id="show-country-filter">true</span>

                                        <a href="{{ url('agentportal/accounts/prefund') }}" class="btn btn-primary font-weight-bolder">Prefund</a>

                                        <div class="subheader-separator subheader-separator-ver mt-2 mb-2 mr-4 bg-gray-200"></div>

                                        @hasanyrole('administrator|finance back office')
                                        <a href="{{ url('agentportal/accounts/topup') }}" class="btn btn-primary font-weight-bolder">Agent Deposit</a>

                                        <div class="subheader-separator subheader-separator-ver mt-2 mb-2 mr-4 bg-gray-200"></div>

                                        <a href="{{ url('agentportal/accounts/edit') }}" class="btn btn-success font-weight-bolder">{!! trans("message_lang.BTN_ADJUSTMENT") !!}</a>

                                        <div class="subheader-separator subheader-separator-ver mt-2 mb-2 mr-4 bg-gray-200"></div>
                                        @endhasanyrole

                                        <a href="{{ url('agentportal/accounts/create') }}" class="btn btn-warning font-weight-bolder">{!! trans("message_lang.BTN_REPAYMENT") !!}</a>

                                        <div class="subheader-separator subheader-separator-ver mt-2 mb-2 mr-4 bg-gray-200"></div>

                                        <a href="{{ url('agentportal/expenses') }}" class="btn btn-danger font-weight-bolder">{!! trans("message_lang.BTN_EXPENSES") !!}</a>

                                        <div class="subheader-separator subheader-separator-ver mt-2 mb-2 mr-4 bg-gray-200"></div>

                                        <a href="{{ url('agentportal/accounts/refund-send-transactions') }}" onclick="return confirm('{!! trans("message_lang.CONF_SEND_TRANSACTION_RETURN") !!}')" class="btn btn-info font-weight-bolder">{!! trans("message_lang.BTN_REFUND_SEND_TRANSACTION") !!}</a>
                                    @endif
                                @else
                                    <span style="display: none;" id="show-country-filter">false</span>

                                    @hasanyrole('main teller|supervisor|teller')
                                    @if (auth()->guard('agentportal')->user()->agentLocation->enable_agent_topup == true && (auth()->guard('agentportal')->user()->agentLocation->parent_id == 0 || auth()->guard('agentportal')->user()->agentLocation->network->enable_agent_topup == true))
                                    <a href="{{ url('agentportal/accounts/topup-agent') }}" class="btn btn-primary font-weight-bolder">Agent Topup</a>
                                    <div class="subheader-separator subheader-separator-ver mt-2 mb-2 mr-4 bg-gray-200"></div>
                                    @endif
                                    @endhasanyrole

                                    <a href="{{ url('agentportal/dashboard') }}" class="btn btn-primary font-weight-bolder">{{ trans('message_lang.BTN_BACK') }}</a>
                                @endhasanyrole
                                @hasanyrole('administrator|tresorerie')
                                    <div class="subheader-separator subheader-separator-ver mt-2 mb-2 mr-4 bg-gray-200"></div>

                                    <a href="{{ url('agentportal/accounts/bulk_repayment') }}" class="btn btn-warning font-weight-bolder">{!! trans("message_lang.BTN_BULK_REPAYMENT") !!}</a>
                                @endhasanyrole

                                <!--end::Button-->
                            </div>
                        </div>
                        <!--begin::Form-->
                        <div class="card-body">
                            <form method="POST" action="{{ url('agentportal/accounts/statement') }}" name="form" id="filterForm">
                                @csrf
                                <input type="hidden" name="page" id="page" value="1">
                                <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-left">
                                    <div class="col-md-3">
                                        <label class="" for="search_field">{!! trans("message_lang.LBL_SEARCH_FIELD") !!} <span style="color:red;"></span></label>
                                        <select name="search_field" id="search_field" class="form-control custom-field">
                                            <option value="">{!! trans("message_lang.PLACEHOLDER_SELECT") !!}</option>
                                            <option value="reference" {{ $request->has('search_field') && $request->search_field == "reference" ? 'selected' : '' }}>Reference</option>
                                        </select>
                                    </div>
                                    <div class="col-md-3">
                                        <label class="" for="search_key">{!! trans("message_lang.LBL_SEARCH_KEY") !!} <span style="color:red;"></span></label>
                                        <input type="text" name="search_key" class="form-control custom-field" value="{!! $request->has('search_key') ? $request->search_key : "" !!}">
                                    </div>
                                </div>
                                <div class="form-group row justify-content-md-left">
                                    <div class="col-md-3" style="display: @if(count($agentCountries) > 0) block @else none @endif;">
                                            @if(count($agentCountries) > 1)
                                                <label class="" for="agent_country_id">{!! trans("message_lang.LBL_COUNTRY") !!} <span style="color:red;"></span></label>
                                            @endif
                                            <select name="agent_country_id" id="agent_country_id" class="form-control custom-field">
                                            <option value="">{!! trans("message_lang.PLACEHOLDER_SELECT") !!}</option>
                                            @foreach ($agentCountries as $key => $agentCountry)
                                            <option value="{{ $key }}" {{ $request->has('agent_country_id') && $request->agent_country_id == $key ? 'selected' : '' }} @hasanyrole('operation|compliance|finance back office') @if (auth()->guard('agentportal')->user()->country_id == $key) selected @endif @endhasanyrole @if ($key == $agentNetworkCountryId) selected @endif>{{ $agentCountry }}</option>
                                            @endforeach
                                        </select>
                                    </div>
                                    @hasanyrole('administrator|operation|compliance|finance back office|tresorerie')
                                    <div class="col-md-3">
                                        <label class="" 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 ($agentLocations as $key => $agentLocation)
                                            <option value="{{ $key }}" {{ $request->has('agent_location_id') && $request->agent_location_id == $key ? 'selected' : '' }} @if ($key == $agentNetworkId) selected @endif>{{ $agentLocation }}</option>
                                            @endforeach
                                        </select>
                                    </div>
                                    @else
                                    <input type="hidden" name="agent_location_id" id="agent_location_id" value="{!! $agent_location_id !!}">
                                    @endhasanyrole

                                    <div class="col-md-3">
                                        <label class="" for="agent_company_id">{!! trans("message_lang.LBL_COMPANY") !!} <span style="color:red;"></span></label>
                                        <select name="agent_company_id" id="agent_company_id" class="form-control custom-field">
                                            <option value="">{!! trans("message_lang.PLACEHOLDER_SELECT") !!}</option>
                                            @foreach ($agentCompanies as $key => $agentCompany)
                                            <option value="{{ $agentCompany->id }}" {{ $request->has('agent_company_id') && $request->agent_company_id == $agentCompany->id ? 'selected' : '' }}>{{ $agentCompany->code }}</option>
                                            @endforeach
                                        </select>
                                    </div>

                                    <div class="col-md-3">
                                        <label class="" for="type">{!! trans("message_lang.LBL_TYPE") !!} <span style="color:red;"></span></label>
                                        <select name="type" id="type" class="form-control custom-field">
                                            <option value="">{!! trans("message_lang.PLACEHOLDER_SELECT") !!}</option>
                                            @foreach ($types as $key => $type)
                                            <option value="{{ $key }}" {{ $request->has('type') && $request->type == $key ? 'selected' : '' }}>{{ ucfirst($type) }}</option>
                                            @endforeach
                                        </select>
                                    </div>
                                </div>
                                <div class="form-group row justify-content-md-left">
                                    @include('agentportal.layouts.date_filter_v1')
                                </div>
                                <div class="form-group row justify-content-md-center">
                                    <a href="{{ url('agentportal/usd-accounts') }}" id="usd_accounts" class="btn btn-info font-weight-bolder" style="display: none;">{!! trans("message_lang.LBL_USD_STATEMENT") !!}</a>

                                    <div class="subheader-separator subheader-separator-ver mt-2 mb-2 mr-4 bg-gray-200"></div>

                                    <button type="submit" class="btn btn-primary" id="apply-filter-paid" data-count="0">{!! trans("message_lang.BTN_SEARCH") !!}</button>

                                    <div class="subheader-separator subheader-separator-ver mt-2 mb-2 mr-4 bg-gray-200"></div>

                                    <a href="{!! route('agentportal.accounts.statement') !!}" class="btn btn-secondary" id="apply-filter-clear-paid">{!! trans("message_lang.BTN_CLEAR_SEARCH") !!}</a>
                                </div>
                                @if($accounts)
                                    <div class="perPage">
                                        <label>
                                            <div class="show">{!! trans('message_lang.DATATABLE_LBL_SHOW') !!}</div>
                                            <select name="per_page" id="perPage" class="custom-select custom-select-sm form-control form-control-sm">
                                                <option value="10" {!! $request->has('per_page') && $request->per_page == "10" ? 'selected' : '' !!} {!! !$request->has('per_page') ? 'selected' : '' !!}>10</option>
                                                <option value="50" {!! $request->has('per_page') && $request->per_page == "50" ? 'selected' : '' !!}>50</option>
                                                <option value="100" {!! $request->has('per_page') && $request->per_page == "100" ? 'selected' : '' !!}>100</option>
                                                <option value="{!! $accounts->total() !!}" {!! $request->has('per_page') && $request->per_page == $accounts->total() ? 'selected' : '' !!}>All</option>
                                            </select>
                                            <div class="entries">{!! trans('message_lang.DATATABLE_LBL_ENTRIES') !!}</div>
                                        </label>
                                    </div>
                                @endif
                            </form>
                            <!--begin: Datatable-->

                            <table id="datatable" class="table table-bordered grid-table nowrap">
                                <thead>
                                    <tr>
                                        <th>#</th>
                                        <th>{!! trans("message_lang.LBL_DATE") !!}</th>
                                        <th>{!! trans("message_lang.LBL_LOCATION_CODE") !!}</th>
                                        <th>{!! trans("message_lang.LBL_LOCATION") !!}</th>
                                        <th>{!! trans("message_lang.LBL_TXN_TYPE") !!}</th>
                                        <th>{!! trans("message_lang.LBL_REFERENCE") !!}</th>
                                        <th>{!! trans("message_lang.LBL_PAID_AT") !!}</th>
                                        <th>{!! trans("message_lang.LBL_COMPANY") !!}</th>
                                        <th>{!! trans("message_lang.LBL_CREDIT") !!}</th>
                                        <th>{!! trans("message_lang.LBL_DEBIT") !!}</th>
                                        <th>{!! trans("message_lang.LBL_BALANCE") !!}</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @forelse ($accounts as $key => $account)
                                        <tr>
                                            <td>{!! $key + 1 !!}</td>
                                            <td>{!! format_date_tz($account->created_at) !!}</td>
                                            <td>{!! (isset($account->agent_location_code) && $account->agent_location_code != '') ? $account->agent_location_code : "-" !!}</td>
                                            <td>{!! (isset($account->agent_location_name) && $account->agent_location_name != '') ? $account->agent_location_name : "-" !!}</td>
                                            <td>@if(Auth::guard('agentportal')->user()->hasAnyRole('finance back office|administrator|operation|compliance|customer service|finance back office|bussiness development|tresorerie') && in_array($account->transaction_type, ['repayment', 'adjustment', 'expense','topup']))
                                                    @if($request->has('fromSponsoredBanks') && $request->fromSponsoredBanks == 1)
                                                        <a href="{!! url('agentportal/accounts/show/' . base64_encode($account->id)) !!} ?CU=1">{!! isset($types[$account->transaction_type]) ? $types[$account->transaction_type] : "" !!}</a>
                                                    @else
                                                        <a href="{!! url('agentportal/accounts/show/' . base64_encode($account->id)) !!}">{!! isset($types[$account->transaction_type]) ? $types[$account->transaction_type] : "" !!}</a>
                                                    @endif
                                                @else
                                                    {!! isset($types[$account->transaction_type]) ? $types[$account->transaction_type] : "" !!}
                                                @endif
                                            </td>
                                            <td>@if($account->transaction_type == 'paid' && $account->agent_paid_transaction_id > 0)
                                                    @if($account->agent_transaction_id != '')
                                                        @if($request->has('fromSponsoredBanks') && $request->fromSponsoredBanks == 1)
                                                            <a href="{!! url('agentportal/payments/show/' . base64_encode(@$account->agent_transaction_id)) !!}?CU=1">{!! $account->reference  !!}</a>
                                                        @else
                                                            <a href="{!! url('agentportal/payments/show/' . base64_encode(@$account->agent_transaction_id))  !!}?return=accounts">{!! $account->reference  !!}</a>
                                                        @endif
                                                    @else
                                                        {!! $account->reference !!}
                                                    @endif
                                                @elseif($account->transaction_type == 'sent' && $account->agent_paid_transaction_id == 0)
                                                    @if($account->send_money_transaction_id != '')
                                                        @if($request->has('fromSponsoredBanks') && $request->fromSponsoredBanks == 1)
                                                            <a href="{!! url('agentportal/send-money/show/' . base64_encode(@$account->send_money_transaction_id)) !!}?CU=1">{!! $account->reference  !!}</a>
                                                        @else
                                                            <a href="{!! url('agentportal/send-money/show/' . base64_encode(@$account->send_money_transaction_id)) !!}?return=accounts">{!! $account->reference  !!}</a>
                                                        @endif
                                                    @else
                                                        {!! $account->reference !!}
                                                    @endif
                                                @else
                                                    {!! $account->reference !!}
                                                @endif
                                            </td>
                                            <td>{!! isset($account->paid_at) ? format_date_tz($account->paid_at) : '-' !!}</td>
                                            <td>{!! $account->agent_company_code !!}</td>
                                            <td>{!! $account->credit_amount > 0 ? '<span style="color: red;">' . number_format($account->credit_amount, 2) . '</span>' : '' !!}</td>
                                            <td>{!! $account->debit_amount > 0 ? '<span style="color: green;">' . number_format($account->debit_amount, 2) . '</span>' : '' !!}</td>
                                            <td><!!>{!! number_format($account->balance, 2) !!}</b></td>
                                        </tr>
                                    @empty
                                        <tr>
                                            <td valign="top" colspan="10" style="text-align: center">{!! trans('message_lang.DATATABLE_LBL_NO_DATA_AVAILABLE') !!}</td>
                                        </tr>
                                    @endforelse
                                </tbody>
                            </table>
                            <!--end: Datatable-->
                        </div>
                        <div class="card-footer">
                            @if($accounts)
                            <div class="pagination">
                                <div class="left-info">
                                    <span>
                                        {!! trans('message_lang.DATATABLE_LBL_SHOWING_INFO') !!} {!! $accounts->firstItem() !!} {!! trans('message_lang.DATATABLE_LBL_TO') !!} {!! $accounts->lastItem() !!} {!! trans('message_lang.DATATABLE_LBL_OF') !!} {!! $accounts->total() !!} {!! trans('message_lang.DATATABLE_LBL_ENTRIES') !!}
                                    </span>
                                </div>
                                <div class="right-info">
                                    {!! $accounts->appends(request()->query())->links() !!}
                                </div>
                            </div>
                            @endif
                        </div>
                        <!--end::Form-->
                    </div>
                    <!--end::Card-->
                </div>
            </div>
        </div>
        <!--end::Container-->
    </div>
    <!--end::Entry-->
</div>
@endsection

@section("page_vendors")
<script src="{{ url('js/select2.min.js') }}"></script>
@endsection

@section("page_script")
<script type="text/javascript">
    var datatable;
    $(document).ready(function () {
        var anyRole = $("#show-country-filter").html();
        if(anyRole == "true") {
            $("#apply-filter-paid").attr("disabled", true);
        } else {
           $("#apply-filter-paid").attr("disabled", false);
        }

        if($('#agent_location_id').is("select")) {
            $('#agent_location_id').select2({
                allowClear: true,
                placeholder: `{!! trans("message_lang.PLACEHOLDER_SELECT_LOCATION") !!}`,
            });
        }

        $('#from_date').datepicker({
            "format": "{{ app()->getLocale() == "fr" ? 'dd-mm-yyyy' : 'yyyy-mm-dd' }}",
            "keyboardNavigation": false,
            "autoclose": true,
            "endDate": new Date()
        }).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
            }).datepicker('setDate', minDate);
        });

        $("#duration").on("change", function() {
            var duration = $(this).val();
            if(duration == "6") {
                $(".customDate").show();
            } else {
                $(".customDate").hide();
            }
        });

        $('#agent_country_id').on('change', function() {
            $("#loading").show();
            var country_id = $(this).val();
            var agent_location_id = "{!! $request->agent_location_id?? '' !!}";

            if(anyRole == "true") {
                if(country_id != "") {
                    $("#apply-filter-paid").attr("disabled", false);
                } else {
                    $("#apply-filter-paid").attr("disabled", "disabled");
                }
            }

            $.ajax({
                url: "{{ url('agentportal/accounts/ajaxNetwork') }}",
                type: "POST",
                headers: {
                    'X-CSRF-TOKEN': "{{ csrf_token() }}"
                },
                data: {
                    country_id: country_id,
                    agent_location_id: agent_location_id
                },
                success: function (response) {
                    $('#agent_location_id').html(response);
                    $("#loading").hide();
                }
            });
        }).change();

        $('#agent_location_id').on('change', function() {
            $("#loading").show();
            $('#usd_accounts').hide();
            var location_id = $(this).val();
            $.ajax({
                url: "{{ url('agentportal/usd-accounts/ajaxNetworkUSD') }}",
                type: "POST",
                headers: {
                    'X-CSRF-TOKEN': "{{ csrf_token() }}"
                },
                data: {
                    location_id: location_id
                },
                success: function (response) {
                    if (response) {
                        $('#usd_accounts').attr('href', response);
                        $('#usd_accounts').show();
                    }
                    $("#loading").hide();
                }
            });
        });

        jQuery(document).on("click",".page-link",function(e){
            e.preventDefault();
            const params = new URL(jQuery(this).attr('href')).searchParams;
            jQuery("#page").val(params.get('page'));
            jQuery("#filterForm").submit();
        });

        jQuery("#perPage").on("change",function(){
            jQuery("#filterForm").submit();
        });
    });
</script>
@endsection