@extends("agentportal.layouts.layout")

@section("title", ($routename == 'payment') ? trans('message_lang.LBL_PAID_TRANSACTIONS') : trans('message_lang.LBL_PAID_REPAYMENTS'))

@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') }}">
<style type="text/css">
    .select2-container--default .select2-selection--single {
        min-height: 38px;
        max-height: 38px;
    }
</style>
@endsection

@section("content")
<div class="content d-flex flex-column flex-column-fluid" id="kt_content">
    <!--begin::Subheader-->
    <!-- <div class="subheader py-2 py-lg-4 subheader-solid" id="kt_subheader">
    </div> -->
    <!--end::Subheader-->
    <!--begin::Entry-->
    <div class="d-flex flex-column-fluid">
        <!--begin::Container-->
        <div class="container">
            @if (session('notValidCodes'))
            <h5 class="">{!! trans('message_lang.LBL_INVALID_PICKUP_CODE') !!}: <span class="badge badge-danger">{{ implode(', ', session('notValidCodes')) }}</span>
            </h5>
            @endif

            @if (session('duplicateCodes'))
            <h5 class="">{!! trans("message_lang.LBL_ALREADY_IMPORTED_PICKUP_CODE") !!}: <span class="badge badge-warning">{{ implode(', ', session('duplicateCodes')) }}</span>
            </h5>
            @endif

            <!--begin::Card-->
            <div class="card card-custom">
                <div class="card-header">
                    <div class="card-title">
                        <h3 class="card-label">{!! ($routename == 'payment') ? trans('message_lang.LBL_PAID_TRANSACTIONS') : trans('message_lang.LBL_PAID_REPAYMENTS') !!}</h3>
                    </div>

                    @if(Auth::guard('agentportal')->user()->hasAnyRole('main teller|teller|supervisor'))
                        <div class="card-toolbar">
                            <!--begin::Button-->
                            @if($routename == 'payment')
                            <a href="{{ url('agentportal/payments/create') }}" class="btn btn-primary font-weight-bolder">{!! trans('message_lang.LBL_PAY_NEW') !!}</a>
                            @else
                            <a href="{{ url('agentportal/payments/create-repayment') }}" class="btn btn-primary font-weight-bolder">{!! trans('message_lang.LBL_REPAYMENT_REQUEST') !!}</a>
                            @endif

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

                            @if(isset(auth()->guard('agentportal')->user()->agentLocation) && isset(auth()->guard('agentportal')->user()->agentLocation->country_id) && isset(auth()->guard('agentportal')->user()->agentLocation->country_id) && auth()->guard('agentportal')->user()->agentLocation->country_id == 8)
                            @else
                                <a href="{{ url('agentportal/payment-requests/create') }}" class="btn btn-info font-weight-bolder">{!! trans('message_lang.LBL_SUBMIT_PAID_NEW') !!}</a>
                            @endif
                            <!--end::Button-->
                        </div>
                    @endif
                </div>
                <div class="card-body">
                    <form method="POST" action="{{ url('agentportal/payments/csvExport') }}" name="form">
                        @csrf
                        <div class="form-group row justify-content-end">
                            <div class="col-md-3">
                                <input type="hidden" name="type" value="{{$routename}}">
                                <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">
                            @if ($routename == 'payment')
                            <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 }}">{{ $agentCompany->name }}</option>
                                    @endforeach
                                </select>
                            </div>
                            @endif

                            <div class="col-md-3" style="display: @hasanyrole('location administrator|main teller|location back office') block @else none @endhasanyrole">
                                <label class="" for="agent_location_user_id">{!! trans('message_lang.LBL_PAID_BY') !!} <span style="color:red;"></span></label>
                                <select name="agent_location_user_id" id="agent_location_user_id" class="form-control custom-field">
                                    <option value="">{!! trans('message_lang.PLACEHOLDER_SELECT') !!}</option>
                                    @foreach ($agentLocationUsers as $key => $agentLocationUser)
                                    <option value="{{ $agentLocationUser->id }}" @if (auth()->guard('agentportal')->user()->hasAnyRole('main teller|location back office') && $agentLocationUser->id == auth()->guard('agentportal')->id()) selected @endif>{{ $agentLocationUser->full_name }}</option>
                                    @endforeach
                                </select>
                            </div>

                            <div class="col-md-3" style="display: @hasanyrole('location administrator|main teller|location back office') block @else none @endhasanyrole">
                                <label class="" for="agent_location_id">{!! trans("message_lang.LBL_SUB_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 }}" @if (auth()->guard('agentportal')->user()->hasAnyRole('main teller|location back office') && auth()->guard('agentportal')->user()->agent_location_id == $key) selected @endif>{{ $agentLocation }}</option>
                                    @endforeach
                                </select>
                            </div>
                            @if(isset(auth()->guard('agentportal')->user()->agentLocation) && isset(auth()->guard('agentportal')->user()->agentLocation->country_id) && auth()->guard('agentportal')->user()->agentLocation->country_id != 8)
                                <div class="col-md-3">
                                    <label class="" for="is_reconciled">{!! trans('message_lang.LBL_RECONCILATION_STATUS') !!} <span style="color:red;"></span></label>
                                    <div class="form-check">
                                        <label class="form-check-label">
                                            <input type="checkbox" name="is_reconciled" id="is_reconciled" class="form-check-input" value="1">{!! trans('message_lang.LBL_RECONCILED') !!}
                                        </label>
                                    </div>
                                </div>
                            @endif
                        </div>

                        <div class="form-group row justify-content-md-center">
                            @include('agentportal.layouts.duration_filter')
                        </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_COMPANY') !!}</th>
                                @if(isset(auth()->guard('agentportal')->user()->agentLocation) && isset(auth()->guard('agentportal')->user()->agentLocation->country_id) && auth()->guard('agentportal')->user()->agentLocation->country_id != 8)
                                    <th>{!! trans('message_lang.LBL_AMOUNT') !!}</th>
                                    <th>{!! trans('message_lang.LBL_STATUS') !!}</th>
                                    <th>{!! trans('message_lang.LBL_AMOUNT_BY_USER') !!}</th>
                                @endif
                                <th>{!! trans('message_lang.LBL_PAID_DATE') !!}</th>
                                <th>{!! trans('message_lang.LBL_PAID_BY') !!}</th>
                                <th>{!! trans('message_lang.LBL_NOTES') !!}</th>
                                <th>{!! trans('message_lang.LBL_ID') !!}</th>
                            </tr>
                        </thead>
                        @if(isset(auth()->guard('agentportal')->user()->agentLocation) && isset(auth()->guard('agentportal')->user()->agentLocation->country_id) && auth()->guard('agentportal')->user()->agentLocation->country_id != 8)
                        <tfoot>
                            <tr>
                                <th>{!! trans('message_lang.LBL_TOTAL') !!}:</th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                            </tr>
                        </tfoot>
                        @endif
                    </table>
                    <!--end: Datatable-->
                </div>
            </div>
            <!--end::Card-->
        </div>
        <!--end::Container-->
    </div>
    <!--end::Entry-->
</div>
@endsection

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

@section("page_script")
<script type="text/javascript">
    var datatable;
    $(document).ready(function () {
        var is_sengal = "{!! isset(auth()->guard('agentportal')->user()->agentLocation) && isset(auth()->guard('agentportal')->user()->agentLocation->country_id) && auth()->guard('agentportal')->user()->agentLocation->country_id != 8 ? 'false' : 'true' !!}";
        $('#agent_location_id').select2({
            // allowClear: true,
            placeholder: "Select Location",
        });

        $('#from_date').datepicker({
            "format": "{{ app()->getLocale() == "fr" ? 'dd-mm-yyyy' : 'yyyy-mm-dd' }}",
            "keyboardNavigation": false,
            "autoclose": true,
            "startDate": '-2y -1m',
            "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);
        });

        $('#to_date').on('change', function (selected) {
            datatable.draw(); // Refilter the table
        });

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

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

        if ($('#datatable').length > 0) {
            if(is_sengal == "true") {
                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') !!}",
                        mptyTable: "{!! trans('message_lang.DATATABLE_LBL_NO_DATA_AVAILABLE') !!}",
                        info: "{!! trans('message_lang.DATATABLE_LBL_SHOWING_INFO') !!} _START_ {!! trans('message_lang.DATATABLE_LBL_TO') !!} _END_ {!! trans('message_lang.DATATABLE_LBL_OF') !!} _TOTAL_ {!! trans('message_lang.DATATABLE_LBL_ENTRIES') !!}",
                        infoEmpty: "{!! trans('message_lang.DATATABLE_LBL_SHOWING_INFO') !!} 0 {!! trans('message_lang.DATATABLE_LBL_TO') !!} 0 {!! trans('message_lang.DATATABLE_LBL_OF') !!} 0 {!! trans('message_lang.DATATABLE_LBL_ENTRIES') !!}",
                        infoFiltered:"({!! trans('message_lang.DATATABLE_FILTERED_FROM') !!} _MAX_ {!! trans('message_lang.DATATABLE_TOTAL_ENTRIES') !!})",
                        zeroRecords: "{!! trans('message_lang.DATATABLE_NO_MATCHING_RECORD_FOUND') !!}",
                    },
                    processing: true,
                    serverSide: true,
                    responsive: true,
                    lengthMenu: [[10, 50, 100, -1], [10, 50, 100, '{!! trans("message_lang.LBL_ALL") !!}']],
                    pageLength: 10,
                    aaSorting: [6, 'DESC'],
                    ajax: {
                        url: "{{ url('agentportal/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.is_reconciled = $('#is_reconciled').is(':checked') ? 1 : 0;
                            data.agent_company_id = $('#agent_company_id').val();
                            data.agent_location_id = $('#agent_location_id').val();
                            data.agent_location_user_id = $('#agent_location_user_id').val();
                            data.type = '{!! $routename !!}';
                            data.duration = $("#duration").val();
                        },
                    },
                    columnDefs: [
                        {
                            targets: [0], // first column & numbering column
                            orderable: false, // set not orderable
                        },
                        // {
                        //     targets: [3, 5, 8], // column index
                        //     searchable: false,
                        // },
                        {
                            targets: [6], // 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: 'company',
                            name: 'company'
                        },
                        {
                            data: 'paid_at',
                            name: 'paid_at'
                        },
                        {
                            data: 'user',
                            name: 'user'
                        },
                        {
                            data: 'notes',
                            name: 'notes'
                        },
                        {
                            data: 'id',
                            name: 'id'
                        }
                    ],
                });
            }else{
                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') !!}",
                        mptyTable: "{!! trans('message_lang.DATATABLE_LBL_NO_DATA_AVAILABLE') !!}",
                        info: "{!! trans('message_lang.DATATABLE_LBL_SHOWING_INFO') !!} _START_ {!! trans('message_lang.DATATABLE_LBL_TO') !!} _END_ {!! trans('message_lang.DATATABLE_LBL_OF') !!} _TOTAL_ {!! trans('message_lang.DATATABLE_LBL_ENTRIES') !!}",
                        infoEmpty: "{!! trans('message_lang.DATATABLE_LBL_SHOWING_INFO') !!} 0 {!! trans('message_lang.DATATABLE_LBL_TO') !!} 0 {!! trans('message_lang.DATATABLE_LBL_OF') !!} 0 {!! trans('message_lang.DATATABLE_LBL_ENTRIES') !!}",
                        infoFiltered:"({!! trans('message_lang.DATATABLE_FILTERED_FROM') !!} _MAX_ {!! trans('message_lang.DATATABLE_TOTAL_ENTRIES') !!})",
                        zeroRecords: "{!! trans('message_lang.DATATABLE_NO_MATCHING_RECORD_FOUND') !!}",
                    },
                    processing: true,
                    serverSide: true,
                    responsive: true,
                    lengthMenu: [[10, 50, 100, -1], [10, 50, 100, '{!! trans("message_lang.LBL_ALL") !!}']],
                    pageLength: 10,
                    aaSorting: [9, 'DESC'],
                    ajax: {
                        url: "{{ url('agentportal/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.is_reconciled = $('#is_reconciled').is(':checked') ? 1 : 0;
                            data.agent_company_id = $('#agent_company_id').val();
                            data.agent_location_id = $('#agent_location_id').val();
                            data.agent_location_user_id = $('#agent_location_user_id').val();
                            data.type = '{!! $routename !!}';
                            data.duration = $("#duration").val();
                        },
                    },
                    columnDefs: [
                        {
                            targets: [0], // first column & numbering column
                            orderable: false, // set not orderable
                        },
                        // {
                        //     targets: [3, 5, 8], // column index
                        //     searchable: false,
                        // },
                        {
                            targets: [9], // 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: 'company',
                            name: 'company'
                        },
                        {
                            data: 'amount',
                            name: 'amount'
                        },
                        {
                            data: 'status',
                            name: 'status'
                        },
                        {
                            data: 'mamount',
                            name: 'mamount'
                        },
                        {
                            data: 'paid_at',
                            name: 'paid_at'
                        },
                        {
                            data: 'user',
                            name: 'user'
                        },
                        {
                            data: 'notes',
                            name: 'notes'
                        },
                        {
                            data: 'id',
                            name: 'id'
                        }
                    ],
                });
            }
        }
    });
</script>
@endsection