@extends("SponsoredBanks.layouts.layout")

@section("title", trans('message_lang.LBL_PAID_TRANSACTIONS'))

@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::Entry-->
    <div class="d-flex flex-column-fluid">
        <!--begin::Container-->
        <div class="container">
            <!--begin::Card-->
            <div class="card card-custom">
                <div class="card-header">
                    <div class="card-title">
                        <h3 class="card-label">{!! trans('message_lang.LBL_PAID_TRANSACTIONS') !!}</h3>
                    </div>
                </div>
                <div class="card-body">
                    <form method="POST" action="{{ url('SponsoredBanks/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="" 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 ($agentLocationUser->id == auth()->guard('SponsoredBanks')->id()) selected @endif>{{ $agentLocationUser->full_name }}</option>
                                    @endforeach
                                </select>
                            </div> --}}

                            <div class="col-md-3">
                                <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('SponsoredBanks')->user()->agent_location_id == $key) selected @endif>{{ $agentLocation }}</option>
                                    @endforeach
                                </select>
                            </div>

                            <div class="col-md-3">
                                <label for="from_date">{{ __('message_lang.LBL_FROM_DATE') }} <span style="color:red;"></span></label>
                                <input type="text" name="from_date" placeholder="{{ __('message_lang.LBL_FROM_DATE') }}" value="{{ app()->getLocale() == "fr" ? date('d-m-Y') : date('Y-m-d') }}" id="from_date" class="form-control custom-field">
                            </div>

                            <div class="col-md-3">
                                <label for="to_date">{{ __('message_lang.LBL_TO_DATE') }} <span style="color:red;"></span></label>
                                <input type="text" name="to_date" placeholder="{{ __('message_lang.LBL_TO_DATE') }}" id="to_date" class="form-control custom-field">
                            </div>
                        </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_COMPANY') !!}</th>
                                <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>
                    </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 () {
        $('#agent_location_id').select2({
            allowClear: true,
            placeholder: "Select Location",
        });

        $('#from_date, #to_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().on('changeDate', function (selected) {
            datatable.draw(); // Refilter the table
            $('#to_date').datepicker('setStartDate', new Date(selected.date.valueOf()));
        });

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

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

        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: 10,
                aaSorting: [6, 'DESC'],
                buttons: [
                    'csv'
                ],
                ajax: {
                    url: "{{ url('SponsoredBanks/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.agent_location_id = $('#agent_location_id').val();
                        data.agent_location_user_id = $('#agent_location_user_id').val();
                    },
                },
                columnDefs: [
                    {
                        targets: [0], // first column & numbering column
                        orderable: false, // set not orderable
                    },
                    {
                        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'
                    }
                ],
            });
        }
    });
</script>
@endsection