@extends("agentportal.layouts.layout")

@section("title", trans('message_lang.LBL_SENDING_COMPANY_BALANCE_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_SENDING_COMPANY_BALANCE_SUMMARY') }}
                                </h3>
                            </div>
                            <div style="float: right; padding:10px;">
                                <a href="{{ route('agentportal.summary-country-company-settlement-amount') }}"class="btn btn-primary">{{ trans('message_lang.BTN_UPDATE_SETTLEMENT_AMOUNT') }}</a>
                                <a href="{{ route('agentportal.summary-country-company-wire-transfer') }}"class="btn btn-warning">{{ trans('message_lang.BTN_WIRE_TRANSFER') }}</a>
                                <a href="{{ route('agentportal.summary-country-company-adjustment') }}"class="btn btn-info">{{ trans('message_lang.BTN_ADJUSTMENT') }}</a>
                                <a href="{{ route('agentportal.summary-index') }}"class="btn btn-secondary">{{ trans('message_lang.BTN_BACK') }}</a>
                            </div>
                        </div>
                        <div class="card-body">
                            <div class="">
                                <div class="example-preview">
                                    <ul class="nav nav-tabs" id="myTab" role="tablist">
                                        @foreach ($countries as $k => $agentCountry)
                                            <li class="nav-item">
                                                <a class="nav-link @if ($k == key($countries)) active @endif" id="{{ $agentCountry->sortname }}_bal-tab" data-toggle="tab" href="#{{ $agentCountry->sortname }}_bal" role="tab" aria-controls="{{ $agentCountry->sortname }}_bal" aria-selected="true">
                                                    {{ $agentCountry->name }}
                                                </a>
                                            </li>
                                        @endforeach
                                    </ul>
                                    <div class="tab-content" id="myTabContent">
                                        @foreach ($countries as $k => $agentCountry)
                                            <div class="tab-pane fade @if ($k == key($countries)) active show @endif" id="{{ $agentCountry->sortname }}_bal" role="tabpanel" aria-labelledby="{{ $agentCountry->sortname }}_bal-tab">
                                                <div class="row">
                                                    <div class="form-group col-md-3"></div>
                                                    <div class="form-group col-md-3"></div>
                                                    <div class="form-group col-md-3">
                                                        <!-- <label for="{{ $agentCountry->sortname }}_to_date">{{ trans('message_lang.LBL_TO_DATE') }} <span style="color:red;"></span></label> -->
                                                        <input class="form-control @error('{{ $agentCountry->sortname }}_to_date') is-invalid @enderror custom-field" id="{{ $agentCountry->sortname }}_to_date" type="text" name="{{ $agentCountry->sortname }}_to_date" placeholder="{{ trans('message_lang.LBL_TO_DATE') }}" autocomplete="off">
                                                    </div>
                                                    <div class="form-group col-md-3">
                                                        <form method="POST" action="{{ route('agentportal.summary-country-company-export') }}" enctype="multipart/form-data" >
                                                            {{ csrf_field() }}
                                                            <button type="submit" class="btn btn-info font-weight-bolder w-100">
                                                                {{ trans('message_lang.LBL_EXPORT_TRANSACTIONS') }}
                                                            </button>
                                                            <input type="hidden" name="hdn_to_date" value="" class="hdn_to_date">
                                                            <input type="hidden" name="hdn_country_code" value="{{ $agentCountry->sortname }}" class="hdn_country_code">
                                                        </form>
                                                    </div>
                                                </div>

                                                <div class="row">
                                                    <div class="col-md-12">
                                                        <!--begin: Datatable-->
                                                        <table id="bal_{{ $agentCountry->sortname }}_table" class="table table-bordered grid-table nowrap">
                                                            <thead>
                                                                <tr>
                                                                    <th>#</th>
                                                                    <th>{{ trans('message_lang.LBL_COMPANY_ACC_NAME') }}</th>
                                                                    <th>{{ trans('message_lang.LBL_BALANCE') }}</th>
                                                                    <th>{{ trans('message_lang.LBL_BALANCE') }}</th>
                                                                </tr>
                                                            </thead>
                                                            <tfoot>
                                                                <tr>
                                                                    <th colspan="2" style="text-align:right">{!! trans("message_lang.LBL_TOTAL") !!}:</th>
                                                                    <th></th>
                                                                    <th></th>
                                                                </tr>
                                                            </tfoot>
                                                        </table>
                                                        <!--end: Datatable-->
                                                    </div>
                                                </div>
                                            </div>
                                        @endforeach
                                    </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")
@foreach ($countries as $k => $agentCountry)
<script>
    var datatable{{ @$agentCountry->sortname }};
    $(document).ready(function() {

        $('#{{ @$agentCountry->sortname }}_to_date').datepicker({
            "format": "yyyy-mm-dd",
            "keyboardNavigation": false,
            "autoclose": true,
            "orientation": 'bottom'
        }).on('change', function(e) {
            $(this).closest("div").parent("div").find(".hdn_to_date").val($(this).val());
            datatable{{ @$agentCountry->sortname }}.draw();
        });

        if ($('#bal_{{ @$agentCountry->sortname }}_table').length > 0)
        {
            datatable{{ @$agentCountry->sortname }} = $('#bal_{{ @$agentCountry->sortname }}_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": [[-1, 10, 25, 50, 100], ["All", 10, 25, 50, 100]],
                "footerCallback": function ( row, data, start, end, display ) {
                    var api = this.api(), data;

                    // 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;
                    };

                    // 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( 2 ).footer() ).html(
                        total +' {{ @$agentCountry->currency }}'
                    );
                },
                processing: true,
                serverSide: true,
                "responsive": true,
                'aaSorting': [ 1, 'ASC'],
                "ajax":
                {
                    "url": "{!! route('agentportal.summary-country-company') !!}",
                    "type": "POST",
                    "dataType": "json",
                    headers: {
                        'X-CSRF-TOKEN': "{{csrf_token()}}"
                    },
                    "data": function(data) {
                        //get values
                        var country_code = "{{ @$agentCountry->sortname }}";
                        var fromDate = $('#{{ @$agentCountry->sortname }}_from_date').val();
                        var toDate = $('#{{ @$agentCountry->sortname }}_to_date').val();

                        //append to data
                        data.country_code = country_code;
                        data.fromDate = fromDate;
                        data.toDate = toDate;
                    },
                },
                "columnDefs": [
                    {
                        "targets": [0], //first column / numbering column
                        "orderable": false, //set not orderable
                    },
                    {
                        'targets': [ 0 ], /* column index  */
                        "searchable": false,
                    },
                    {
                        'targets': [ 3 ], /* column index  */
                        "visible": false,
                    }
                ],
                columns: [
                    {
                        data: 'DT_RowIndex',
                        name: 'DT_RowIndex'
                    },
                    {
                        data: 'company_acc_name',
                        name: 'company_acc_name',
                        render:function(data, type, row) {
                            return "<a href='"+ base_url+"/agentportal/summary/country/company/"+btoa(row.account_code) +"/statement' >" + row.company_acc_name + "</a>"
                        }
                    },
                    {
                        data: 'total_balance',
                        name: 'total_balance'
                    },
                    {
                        data: 'balance_sum',
                        name: 'balance_sum'
                    }
                ]
            });
        }

    });
</script>
@endforeach
@endsection