@extends("agentportal.layouts.layout")

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

@section("page_style")
<link rel="stylesheet" type="text/css" href="{{ url('dist/assets/plugins/custom/datatables/datatables.bundle.css') }}">
@endsection

@section("content")
@php
    $company_acc_code = $request->company_acc_code?base64_decode($request->company_acc_code):'';
@endphp
<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_COMPANY_ACC_STATEMENTS') }}
                            </h3>
                            <div class="card-toolbar">
                                <!--begin::Button-->
                                <div style="float: right; padding:10px;">
                                    <a href="{{ route('agentportal.summary-country-company-wire-transfer', ['company_acc_code' => base64_encode($company_acc_code)]) }}"class="btn btn-warning">{{ trans('message_lang.BTN_WIRE_TRANSFER') }}</a>
                                    <a href="{{ route('agentportal.summary-country-company-adjustment', ['company_acc_code' => base64_encode($company_acc_code)]) }}"class="btn btn-info">{{ trans('message_lang.BTN_ADJUSTMENT') }}</a>
                                    <a href="{{ route('agentportal.summary-country-company') }}"class="btn btn-secondary">{{ trans('message_lang.BTN_BACK') }}</a>
                                </div>

                                <!--end::Button-->
                            </div>
                        </div>
                        <!--begin::Form-->
                        <div class="card-body">
                            <div class="form-group row justify-content-md-center">
                                <div class="col-md-6">
                                    <p>
                                        <span>{{ trans('message_lang.LBL_COUNTRY') }}:</span>
                                        <span class="text-danger">{{ $companyAccountDetails->getCountry->name }}</span>
                                    </p>
                                    <p>
                                        <span>{{ trans('message_lang.LBL_COMPANY_ACC_NAME') }}:</span>
                                        <span class="text-danger">{{ $companyAccountDetails->account_name}} {{ "(".$companyAccountDetails->account_code.")" }}</span>
                                    </p>
                                </div>
                                <div class="col-md-3">
                                    <label for="from_date">{{ trans('message_lang.LBL_FROM_DATE') }} <span style="color:red;"></span></label>
                                    <input type="text" name="from_date" placeholder="{{ trans('message_lang.LBL_FROM_DATE') }}" id="from_date" class="form-control custom-field" value="{{ date('Y-m-01') }}">
                                </div>
                                <div class="col-md-3">
                                    <label for="to_date">{{ trans('message_lang.LBL_TO_DATE') }} <span style="color:red;"></span></label>
                                    <input type="text" name="to_date" placeholder="{{ trans('message_lang.LBL_TO_DATE') }}" id="to_date" class="form-control custom-field">
                                </div>
                            </div>
                            <!--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_TXN_TYPE') }}</th>
                                        <th>{{ trans('message_lang.LBL_REFERENCE') }}</th>
                                        <th>{{ trans('message_lang.LBL_CREDIT') }}</th>
                                        <th>{{ trans('message_lang.LBL_USD_CREDIT') }}</th>
                                        <th>{{ trans('message_lang.LBL_DEBIT') }}</th>
                                        <th>{{ trans('message_lang.LBL_USD_DEBIT') }}</th>
                                        <th>{{ trans('message_lang.LBL_BALANCE') }}</th>
                                        <th>{{ trans('message_lang.LBL_USD_BALANCE') }}</th>
                                        <th>{{ trans('message_lang.LBL_RATE') }}</th>
                                        <th>id</th>
                                        <th>{{ trans('message_lang.LBL_COMMENTS') }}</th>
                                    </tr>
                                </thead>
                            </table>
                            <!--end: Datatable-->
                        </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")
<script type="text/javascript">
    var datatable;
    $(document).ready(function () {
        $('#from_date, #to_date').datepicker({
            "format": "yyyy-mm-dd",
            "keyboardNavigation": false,
            "autoclose": true,
            "startDate": '-2y -1m',
            "endDate": new Date(),
            "todayBtn": true,
            "todayHighlight": true,
        });

        $('#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
        });

        if ($('#datatable').length > 0) {
            datatable = $('#datatable').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") !!}']],
                processing: true,
                serverSide: true,
                responsive: true,
                aaSorting: [11, 'DESC'],
                ajax: {
                    url: "{{ route('agentportal.summary-country-company-statement', ['company_acc_code' => $request->company_acc_code]) }}",
                    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();
                    },
                },
                columnDefs: [
                    {
                        targets: [0], // first column & numbering column
                        orderable: false, // set not orderable
                    },
                    // {
                    //     targets: [3, 5, 8], // column index
                    //     searchable: false,
                    // },
                    {
                        targets: [11], // column index
                        visible: false,
                    }
                ],
                columns: [
                    {
                        data: 'DT_RowIndex',
                        name: 'DT_RowIndex'
                    },
                    {
                        data: 'date',
                        name: 'date'
                    },
                    {
                        data: 'transaction_type',
                        name: 'transaction_type'
                    },
                    {
                        data: 'reference',
                        name: 'reference'
                    },
                    {
                        data: 'credit_amount',
                        name: 'credit_amount'
                    },
                    {
                        data: 'usd_credit_amount',
                        name: 'usd_credit_amount'
                    },
                    {
                        data: 'debit_amount',
                        name: 'debit_amount'
                    },
                    {
                        data: 'usd_debit_amount',
                        name: 'usd_debit_amount'
                    },
                    {
                        data: 'balance',
                        name: 'balance'
                    },
                    {
                        data: 'usd_balance',
                        name: 'usd_balance'
                    },
                    {
                        data: 'settlement_rate',
                        name: 'settlement_rate'
                    },
                    {
                        data: 'id',
                        name: 'id'
                    },
                    {
                        data: 'comment',
                        name: 'comment'
                    }
                ],
                // 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: 'Account Statements',
                        className: 'datatableBtn',
                        exportOptions: {
                            columns: ':visible:not(:last-child)'
                        }
                    }
                ]
            });
        }
    });
</script>
@endsection