@extends("agentportal.layouts.layout")

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

@section("page_style")
<link rel="stylesheet" type="text/css" href="{{ url('dist/assets/plugins/custom/datatables/datatables.bundle.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">
                <div class="col-lg-12">
                    <div class="card card-custom gutter-b">
                        <div class="card-header">
                            <div class="card-title">
                                <h3 class="card-label">
                                    {{ trans('message_lang.LBL_LOC_BAL_SUMMARY') }}
                                </h3>
                            </div>
                            <div style="float: right; padding:10px;">
                                <a href="{{ route('agentportal.summary-index') }}"class="btn btn-light btn-lg btn-block">{{ trans('message_lang.BTN_BACK') }}</a>
                            </div>
                        </div>
                        <div class="card-body">
                            <div class="">
                                <div class="example-preview">
                                    <form method="POST" action="{{ route('agentportal.summary-location-export') }}" enctype="multipart/form-data" >
                                        {{ csrf_field() }}
                                        <div class="row">
                                            <div class="form-group col-md-3"></div>
                                            <div class="form-group col-md-3" style="display: @hasanyrole('administrator|operation|customer service|finance back office|bussiness development|tresorerie') block @else none @endhasanyrole">
                                                <select name="country_code" id="agent_country_id" class="form-control custom-field" required>
                                                    <option value="">{!! trans("message_lang.PLACEHOLDER_SELECT_COUNTRY") !!}</option>
                                                    @foreach ($countries as $key => $country)
                                                    <option value="{{ $country->sortname }}">{{ $country->name }}</option>
                                                    @endforeach
                                                </select>
                                            </div>
                                            <div class="form-group col-md-3">
                                                <!-- <label for="to_date">{{ trans('message_lang.LBL_TO_DATE') }} <span style="color:red;"></span></label> -->
                                                <input class="form-control @error('to_date') is-invalid @enderror custom-field"  id="to_date" type="text" name="to_date" placeholder="{{ trans('message_lang.LBL_TO_DATE') }}" autocomplete="off" value="{{ date('Y-m-01') }}">
                                            </div>
                                            <div class="form-group col-md-3">
                                                    <button type="submit" class="btn btn-info font-weight-bolder w-100">
                                                        {{ trans('message_lang.LBL_EXPORT_TRANSACTIONS') }}
                                                    </button>
                                            </div>
                                        </div>
                                    </form>

                                    <div class="row">
                                        <div class="col-md-12">
                                            <!--begin: Datatable-->
                                            <table id="bal_table" class="table table-bordered grid-table nowrap">
                                                <thead>
                                                    <tr>
                                                        <th>#</th>
                                                        <th>{{ trans('message_lang.LBL_LOCATION_NAME') }}</th>
                                                        <th>{{ trans('message_lang.LBL_COUNTRY_NAME') }}</th>
                                                        <th>{{ trans('message_lang.LBL_BALANCE') }}</th>
                                                    </tr>
                                                </thead>
                                                <tfoot class="tfoot-total" style="display: none;">
                                                    <tr>
                                                        <th colspan="3" style="text-align:right">{!! trans("message_lang.LBL_TOTAL") !!}:</th>
                                                        <th></th>
                                                    </tr>
                                                </tfoot>
                                            </table>
                                            <!--end: Datatable-->
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </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>
    var list_bal_table;
    $(document).ready(function() {
        $('#to_date').datepicker({
            "format": "yyyy-mm-dd",
            "keyboardNavigation": false,
            "autoclose": true,
            "orientation": 'bottom'
        }).on('change', function(e) {
            $(this).closest("div").next("div").find(".hdn_to_date").val($(this).val());
            GenerateTable();
        });

        $('#agent_country_id').on('change', function() {
            GenerateTable();
        });

        GenerateTable();

        function GenerateTable()
        {
            if($.fn.dataTable.isDataTable(list_bal_table)) {
                list_bal_table.draw();
            } else {
                list_bal_table = $('#bal_table').DataTable(
                {
                    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') !!}",
                    },
                    "lengthMenu": [[10, 25, 50, 100, -1], [10, 25, 50, 100, '{!! trans("message_lang.LBL_ALL") !!}']],
                    "footerCallback": function ( row, data, start, end, display ) {
                        var api = this.api(), data;
                        var currency = data.length > 0 ? data[0].currency : '';
                        // 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;
                        };

                        var country_code = $('#agent_country_id').val();
                        if(country_code != '') {
                            $(".tfoot-total").show();
                            // Total over all pages
                            total = api
                                .column(3)
                                .data()
                                .reduce( function (a, b) {
                                    return intVal(a) + intVal(b);
                                }, 0 );

                            total = total.toLocaleString();
                            // Update footer

                            $( api.column( 3 ).footer() ).html(
                                total +' '+currency
                            );
                        } else {
                            $(".tfoot-total").hide();
                        }
                    },
                    processing: true,
                    serverSide: true,
                    "responsive": true,
                    'aaSorting': [ 1, 'ASC'],
                    "ajax":
                    {
                        "url": "{!! route('agentportal.summary-location') !!}",
                        "type": "POST",
                        "dataType": "json",
                        headers: {
                            'X-CSRF-TOKEN': "{{csrf_token()}}"
                        },
                        "data": function(data) {
                            //get values
                            var country_code = $('#agent_country_id').val();
                            var from_date = $('#from_date').val();
                            var to_date = $('#to_date').val();

                            //append to data
                            data.country_code = country_code;
                            data.from_date = from_date;
                            data.to_date = to_date;
                        },
                    },
                    "columnDefs": [
                        {
                            "targets": [0], //first column / numbering column
                            "orderable": false, //set not orderable
                        },
                        {
                            'targets': [ 0 ], /* column index  */
                            "searchable": false,
                        },
                    ],
                    columns: [
                        {
                            data: 'DT_RowIndex',
                            name: 'DT_RowIndex'
                        },

                        {
                            data: 'loc_name',
                            name: 'loc_name',
                        },
                        {
                            data: 'agent_countries.name',
                            name: 'agent_countries.name'
                        },
                        {
                            data: 'total_balance',
                            name: 'total_balance'
                        },
                    ]
                });
            }
        }

    });

</script>
@endsection