@extends("agentportal.layouts.layout")

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

@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

<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">
                            <h3 class="card-title">
                                {!! trans("message_lang.LBL_COMMISSION_SUMMARY") !!}
                            </h3>
                            <div class="card-toolbar">
                                <a href="{{ url()->previous() }}"class="btn btn-primary font-weight-bolder">{{ trans('message_lang.BTN_BACK') }}</a>
                            </div>
                        </div>
                        <div class="card-body">
                            <form method="POST" action="{{ url('agentportal/reports/bank-commission/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="sponsored_bank_id">{!! trans('message_lang.LBL_SPONSORED_BANKS') !!} <span style="color:red;"></span></label>
                                        <select name="sponsored_bank_id" id="sponsored_bank_id" class="form-control custom-field">
                                            <option value="">{!! trans('message_lang.PLACEHOLDER_SELECT') !!}</option>
                                            @foreach ($sponsoredBanks as $key => $bank)
                                                <option value="{{ $key }}">{{ $bank }}</option>
                                            @endforeach
                                        </select>
                                    </div>

                                    <div class="col-md-3">
                                        <label class="" style="width: 100%;" 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.STATUS_OPTION_ALL') !!}</option>
                                            <option value="0">{!! trans('message_lang.STATUS_OPTION_PAID') !!}</option>
                                            <option value="1">{!! trans('message_lang.STATUS_OPTION_SENT') !!}</option>
                                        </select>
                                    </div>

                                    <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>
                                        </select>
                                    </div>

                                    <div class="col-md-3">
                                        <label class="" style="width: 100%;" for="date">{!! trans('message_lang.LBL_DURATION') !!} <span style="color:red;"></span></label>
                                        <select name="date" id="date" 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="0">Custom Date</option>
                                        </select>
                                    </div>
                                </div>

                                <div class="form-group row justify-content-md-center">
                                    <div class="col-md-3 customDate" style="display: none;">
                                        <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 customDate" style="display: none;">
                                        <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>
                            </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") !!}</th>
                                        <th>{!! trans("message_lang.LBL_PICKUP_CODE") !!}</th>
                                        <th>{!! trans("message_lang.LBL_AMOUNT") !!}</th>
                                        <th>{!! trans("message_lang.LBL_COMMISSION") !!}</th>
                                        <th>{!! trans("message_lang.LBL_SENDING_FEES") !!}</th>
                                        <th>{!! trans("message_lang.LBL_TYPE") !!}</th>
                                        <th>{!! trans("message_lang.LBL_ID") !!}</th>
                                    </tr>
                                </thead>
                                <tfoot>
                                    <tr>
                                        <th colspan="4">{!! trans("message_lang.LBL_TOTAL") !!}:</th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                        <th></th>
                                    </tr>
                                </tfoot>
                            </table>
                            <!--end: Datatable-->
                        </div>
                    </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>
    <script src="{{ url('js/select2.min.js') }}"></script>
@endsection

@section("page_script")
    <script type="text/javascript">
        var datatable;
        $(document).ready(function () {
            $("#date").on("change", function() {
                var date1 = $(this).val();
                if(date1 == "0") {
                    $(".customDate").show();
                } else {
                    $(".customDate").hide();
                }
                datatable.draw(); // Refilter the table
            });

            $('#sponsored_bank_id').select2({
                allowClear: true,
                width: '100%',
                placeholder: "{!! trans('message_lang.LBL_SELECT_BANK') !!}",
            });

            $('#agent_location_id').select2({
                allowClear: true,
                width: '100%',
                placeholder: "{!! trans('message_lang.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('change', function (selected) {
                datatable.draw(); // Refilter the table
                $('#to_date').datepicker('setStartDate', new Date(selected.date.valueOf()));
            });

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

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

            $("#type").on("change", function() {
                datatable.draw();
            });

            $('#sponsored_bank_id').on('change', function() {
                var spBankId = $(this).val();

                var bankLocations = JSON.parse("{{$agentLocations}}".replace(/&quot;/g,'"'));
                var locations = bankLocations[spBankId];

                var html = '<option value="">Select Location</option>';
                $.each(locations, function (key, value) {
                    html += '<option value="'+key+'">'+value+'</option>';
                });
                $("#agent_location_id").html(html);

                datatable.draw(); // Refilter the table
            });

            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(4).data().reduce( function (a, b) {
                            a = (parseFloat(decimal(a)) || 0).toFixed(2);
                            b = (parseFloat(decimal(b)) || 0).toFixed(2);
                            return parseFloat(a) + parseFloat(b);
                        }, 0).toLocaleString();

                        // Commission over all pages
                        commission = api.column(5).data().reduce( function (a, b) {
                            a = (parseFloat(decimal(a)) || 0).toFixed(2);
                            b = (parseFloat(decimal(b)) || 0).toFixed(2);
                            return parseFloat(a) + parseFloat(b);
                        }, 0).toLocaleString();

                        // Update footer
                        $(api.column(4).footer()).html(total);
                        $(api.column(5).footer()).html(commission);
                    },
                    language: {
                        lengthMenu: "{!! trans('message_lang.DATATABLE_LBL_SHOW') !!} _MENU_ {!! trans('message_lang.DATATABLE_LBL_ENTRIES') !!}",
                        search: "{!! trans('message_lang.DATATABLE_LBL_SEARCH') !!}",
                        emptyTable: "{!! 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,
                    pageLength: 50,
                    ajax: {
                        url: "{{ url('agentportal/reports/bank-commission/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.date = $('#date').val();
                            data.type = $('#type').val();
                            data.sponsored_bank_id = $('#sponsored_bank_id').val();
                            data.agent_location_id = $('#agent_location_id').val();
                        },
                    },
                    columnDefs: [
                        {
                            targets: [0], // first column & numbering column
                            orderable: false, // set not orderable
                        },
                        {
                            targets: [8], // column index
                            visible: false,
                        }
                    ],
                    columns: [
                        {
                            data: 'DT_RowIndex',
                            name: 'DT_RowIndex'
                        },
                        {
                            data: 'paid_at',
                            name: 'paid_at'
                        },
                        {
                            data: 'location',
                            name: 'location'
                        },
                        {
                            data: 'pickup_code',
                            name: 'pickup_code'
                        },
                        {
                            data: 'amount',
                            name: 'amount'
                        },
                        {
                            data: 'commission_amount',
                            name: 'commission_amount'
                        },
                        {
                            data: 'sending_fee',
                            name: 'sending_fee'
                        },
                        {
                            data: 'type',
                            name: 'type'
                        },
                        {
                            data: 'id',
                            name: 'id'
                        }
                    ],
                });
            }
        });
    </script>
@endsection