@extends("agentportal.layouts.layout")

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

@section("page_style")
<link rel="stylesheet" type="text/css" href="{{ url('dist/assets/plugins/custom/datatables/datatables.bundle.css') }}">
@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::Subheader-->
    <!--end::Subheader-->
    <!--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_DAILY_COMPANY_SUMMARY") !!}
                            </h3>
                            <div class="card-toolbar">
                                <!--begin::Button-->
                                <a href="{{ url('agentportal/summary') }}"class="btn btn-primary font-weight-bolder">{{ trans('message_lang.BTN_BACK') }}</a>
                                <!--end::Button-->
                            </div>
                        </div>
                        <!--begin::Form-->
                        <div class="card-body">
                            <ul class="nav nav-tabs" id="myTab" role="tablist">
                                @foreach ($agentCountries as $k => $agentCountry)
                                <li class="nav-item">
                                    <a class="nav-link @if ($k == key($agentCountries)) active @endif" id="{{ $agentCountry->sortname }}-tab" data-toggle="tab" href="#{{ $agentCountry->sortname }}" role="tab" aria-controls="{{ $agentCountry->sortname }}" aria-selected="true">
                                        {{ $agentCountry->name }}
                                    </a>
                                </li>
                                @endforeach
                            </ul>
                            <div class="tab-content" id="myTabContent">
                                @foreach ($agentCountries as $k => $agentCountry)
                                <div role="tabpanel" aria-labelledby="{{ $agentCountry->sortname }}-tab" id="{{ $agentCountry->sortname }}" class="tab-pane fade @if ($k == key($agentCountries)) active show @endif">
                                    <!--begin::Card-->
                                    <div class="card card-custom">
                                        <div class="card-header">
                                            <div class="card-title">
                                                <h3 class="card-label">{{ $agentCountry->name }}</h3>
                                            </div>
                                            <div class="card-toolbar">

                                            </div>
                                        </div>
                                        <div class="card-body">
                                            <form method="POST" action="{{ url('agentportal/reports/summary/company/csvExport') }}" name="form">
                                                @csrf
                                                <div class="form-group row justify-content-end">
                                                    <div class="col-md-3">
                                                        <input type="hidden" name="agent_country_id" value="{{ $agentCountry->id }}" id="agent_country_id{{ @$agentCountry->id }}" class="form-control custom-field">
                                                    </div>
                                                    <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_company_id{{ @$agentCountry->id }}">{!! trans("message_lang.LBL_COMPANY") !!} <span style="color:red;"></span></label><br/>
                                                        <select name="agent_company_id" id="agent_company_id{{ @$agentCountry->id }}" class="form-control custom-field">
                                                            <option value="">{!! trans("message_lang.PLACEHOLDER_SELECT") !!}</option>
                                                            @foreach ($agentCompanies[$k] as $key => $agentCompany)
                                                            <option value="{{ $key }}">{{ $agentCompany }}</option>
                                                            @endforeach
                                                        </select>
                                                    </div>
                                                    <div class="col-md-3">
                                                        <label class="" style="width: 100%;" for="duration{{ @$agentCountry->id }}">{!! trans('message_lang.LBL_DURATION') !!} <span style="color:red;"></span></label>
                                                        <select name="duration" id="duration{{ @$agentCountry->id }}" class="form-control custom-field">
                                                            <option value="1" selected>Today</option>
                                                            <option value="2">This Week</option>
                                                            <option value="3">This Month</option>
                                                            <option value="4">Previous Week</option>
                                                            <option value="5">Previous Month</option>
                                                            <option value="6">Custom Date</option>
                                                        </select>
                                                    </div>
                                                    <div class="col-md-3 customDate{{ @$agentCountry->id }}" style="display: none;">
                                                        <label for="from_date">{{ __('message_lang.LBL_FROM_DATE') }} <span style="color:red;">*</span></label>
                                                        <input class="form-control @error('from_date') is-invalid @enderror custom-field" readonly id="from_date{{ @$agentCountry->id }}" type="text" name="from_date" placeholder="{{ __('message_lang.LBL_FROM_DATE') }}" value="{{ app()->getLocale() == "fr" ? date('d-m-Y') : date('Y-m-d') }}">
                                                        @error('from_date')
                                                            <span class="invalid-feedback" role="alert">
                                                                <strong>{{ $message }}</strong>
                                                            </span>
                                                        @enderror
                                                    </div>
                                                    
                                                    <div class="col-md-3 customDate{{ @$agentCountry->id }}" style="display: none;">
                                                        <label for="to_date">{{ __('message_lang.LBL_TO_DATE') }} <span style="color:red;">*</span></label>
                                                        <input class="form-control @error('to_date') is-invalid @enderror custom-field" readonly id="to_date{{ @$agentCountry->id }}" type="text" name="to_date" placeholder="{{ __('message_lang.LBL_TO_DATE') }}">
                                                        @error('to_date')
                                                            <span class="invalid-feedback" role="alert">
                                                                <strong>{{ $message }}</strong>
                                                            </span>
                                                        @enderror
                                                    </div>
                                                    
                                                </div>
                                            </form>
                                            <!--begin: Datatable-->
                                            <table id="datatable{{ @$agentCountry->id }}" class="table table-bordered grid-table nowrap">
                                                <thead>
                                                    <tr>
                                                        <th>#</th>
                                                        <th>{!! trans("message_lang.LBL_DATE") !!}</th>
                                                        <th>{!! trans("message_lang.LBL_COMPANY") !!}</th>
                                                        <th>{!! trans("message_lang.LBL_PAYOUT_AMOUNT") !!}</th>
                                                        <th>{!! trans("message_lang.LBL_TRANSACTIONS") !!}</th>
                                                        <th>{!! trans("message_lang.LBL_ID") !!}</th>
                                                    </tr>
                                                </thead>
                                                <tfoot>
                                                    <tr>
                                                        <th colspan="3" style="text-align:right">{!! trans("message_lang.LBL_TOTAL") !!}:</th>
                                                        <th></th>
                                                        <th></th>
                                                        <th></th>
                                                        <th></th>
                                                    </tr>
                                                </tfoot>
                                            </table>
                                            <!--end: Datatable-->
                                        </div>
                                    </div>
                                    <!--end::Card-->
                                </div>
                                @endforeach
                            </div>
                        </div>

                        <div class="card-footer">

                        </div>
                        <!--end::Form-->
                    </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>
@endsection

@section("page_script")
@foreach ($agentCountries as $k => $agentCountry)
<script type="text/javascript">
    var datatable{{ @$agentCountry->id }};
    $(document).ready(function () {
        $('#from_date{{ @$agentCountry->id }}').datepicker({
            "format": "{{ app()->getLocale() == "fr" ? 'dd-mm-yyyy' : 'yyyy-mm-dd' }}",
            "keyboardNavigation": false,
            "orientation": 'bottom',
            "autoclose": true,
            "startDate": '-2y -1m',
            "endDate": new Date()
        });

        $('#from_date{{ @$agentCountry->id }}').datepicker({
            "format": "{{ app()->getLocale() == "fr" ? 'dd-mm-yyyy' : 'yyyy-mm-dd' }}",
            "keyboardNavigation": false,
            "orientation": 'bottom',
            "autoclose": true,
        }).on('change', function(e){
            var date = new Date($("#from_date{{ @$agentCountry->id }}").val());
            var d = date.getDate();
            var m = date.getMonth();
            var y = date.getFullYear();
            var minDate = new Date(y, m, d + 31);

            $('#to_date{{ @$agentCountry->id }}').datepicker('destroy').datepicker({
                "format": "{{ app()->getLocale() == "fr" ? 'dd-mm-yyyy' : 'yyyy-mm-dd' }}",
                "keyboardNavigation": false,
                "orientation": 'bottom',
                "autoclose": true,
                "startDate": $("#from_date{{ @$agentCountry->id }}").val(),
                "endDate":minDate
            }).on('change', function(e) {
                datatable{{ @$agentCountry->id }}.draw();
            }).datepicker('setDate', minDate);
        });

        $("#duration{{ @$agentCountry->id }}").on("change", function() {
            var duration = $(this).val();
            if(duration == "6") {
                $(".customDate{{ @$agentCountry->id }}").show();
            } else {
                $(".customDate{{ @$agentCountry->id }}").hide();
                datatable{{ @$agentCountry->id }}.draw();
            }
        });

        $('#from_date{{ @$agentCountry->id }}, #to_date{{ @$agentCountry->id }}').datepicker({
            "format": "{{ app()->getLocale() == "fr" ? 'dd-mm-yyyy' : 'yyyy-mm-dd' }}",
            "keyboardNavigation": false,
            "orientation": 'bottom',
            "autoclose": true,
            "startDate": '-2y -1m',
            "endDate": new Date()
        });

        $('#from_date{{ @$agentCountry->id }}').datepicker().on('change', function (selected) {
            datatable{{ @$agentCountry->id }}.draw(); // Refilter the table
            $('#to_date{{ @$agentCountry->id }}').datepicker('setStartDate', new Date(selected.date.valueOf()));
        });

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

        $('#agent_company_id{{ @$agentCountry->id }}').on('change', function() {
            datatable{{ @$agentCountry->id }}.draw(); // Refilter the table
        });

        if ($('#datatable{{ @$agentCountry->id }}').length > 0) {
            datatable{{ @$agentCountry->id }} = $('#datatable{{ @$agentCountry->id }}').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) {
                        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
                    usd = 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).toFixed(2).toLocaleString();

                    // Count over all pages
                    count = 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).toFixed(2).toLocaleString();

                    // Update footer
                    $(api.column(3).footer()).html(total);
                    $(api.column(4).footer()).html(usd);
                    $(api.column(5).footer()).html(count);
                },
                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') !!}",
                },
                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,
                lengthMenu: [[10, 50, 100, -1], [10, 50, 100, '{!! trans("message_lang.LBL_ALL") !!}']],
                aaSorting: [6, 'DESC'],
                ajax: {
                    url: "{{ url('agentportal/reports/summary/company/ajaxDatatable') }}",
                    type: "POST",
                    dataType: "json",
                    headers: {
                        'X-CSRF-TOKEN': "{{ csrf_token() }}"
                    },
                    data: function(data) {
                        data.from_date = $('#from_date{{ @$agentCountry->id }}').val();
                        data.to_date = $('#to_date{{ @$agentCountry->id }}').val();
                        data.agent_country_id = $('#agent_country_id{{ @$agentCountry->id }}').val();
                        data.agent_company_id = $('#agent_company_id{{ @$agentCountry->id }}').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: 'paid_at',
                        name: 'paid_at'
                    },
                    {
                        data: 'company',
                        name: 'company',
                        render: function(data, type, row) {
                            return '<a href="' + row.data.url + '">' + data + '</a>';
                        }
                    },
                    {
                        data: 'amount',
                        name: 'amount'
                    },
                    {
                        data: 'usd_amount',
                        name: 'usd_amount'
                    },
                    {
                        data: 'transactions',
                        name: 'transactions'
                    },
                    {
                        data: 'id',
                        name: 'id'
                    }
                ],
                // dom: 'lBfrtip',
                // dom: '<"row"<"col-sm-3"l><"col-sm-6"B><"col-sm-3"f>>' +
                //     '<"row"<"col-sm-12"tr>>' +
                //     '<"row"<"col-sm-5"i><"col-sm-7"p>>',
                // buttons: [
                //     {
                //         extend: 'csv',
                //         text: 'Export to CSV',
                //         filename: 'Daily Company Summary',
                //         className: 'datatableBtn',
                //         exportOptions: {
                //             columns: ':visible'
                //         }
                //     }
                // ]
            });
        }
    });
</script>
@endforeach
@endsection