@extends("SponsoredBanks.layouts.layout")

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

@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::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 align-center">
                            <h3 class="card-title">
                                {!! trans("message_lang.LBL_ACC_STATEMENTS") !!}
                            </h3>
                            <div class="card-toolbar">
                                <!--begin::Button-->
                                <a href="{{ url('SponsoredBanks/dashboard') }}" class="btn btn-primary font-weight-bolder">{{ trans('message_lang.BTN_BACK') }}</a>
                                <!--end::Button-->
                            </div>
                        </div>
                        <!--begin::Form-->
                        <div class="card-body">
                            <form method="POST" action="{{ url('SponsoredBanks/accounts/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="" 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>
                                            @foreach ($agentLocations as $key => $agentLocation)
                                            <option value="{{ $key }} {!! $key == $agentLocationId ? "selected" : ""  !!}">{{ $agentLocation }}</option>
                                            @endforeach
                                        </select>
                                    </div>
                                    <div class="col-md-3">
                                        <label class="" 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.PLACEHOLDER_SELECT") !!}</option>
                                            @foreach ($types as $key => $type)
                                                <option value="{{ $key }}">{{ ucfirst($type) }}</option>
                                            @endforeach
                                        </select>
                                    </div>
                                    @include('agentportal.layouts.duration_filter')
                                </div>
                                <div class="form-group row justify-content-md-center">
                                    <div class="subheader-separator subheader-separator-ver mt-2 mb-2 mr-4 bg-gray-200"></div>

                                    <button type="button" class="btn btn-primary" id="apply-filter-paid" data-count="0">{!! trans("message_lang.BTN_SEARCH") !!}</button>

                                    <div class="subheader-separator subheader-separator-ver mt-2 mb-2 mr-4 bg-gray-200"></div>

                                    <button type="button" class="btn btn-secondary" id="apply-filter-clear-paid">{!! trans("message_lang.BTN_CLEAR_SEARCH") !!}</button>
                                </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_TXN_TYPE") !!}</th>
                                        <th>{!! trans("message_lang.LBL_REFERENCE") !!}</th>
                                        <th>{!! trans("message_lang.LBL_PAID_AT") !!}</th>
                                        <th>{!! trans("message_lang.LBL_CREDIT") !!}</th>
                                        <th>{!! trans("message_lang.LBL_DEBIT") !!}</th>
                                        <th>{!! trans("message_lang.LBL_BALANCE") !!}</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').datepicker({
            "format": "{{ app()->getLocale() == "fr" ? 'dd-mm-yyyy' : 'yyyy-mm-dd' }}",
            "keyboardNavigation": false,
            "autoclose": true,
            "startDate": '-2y -1m',
            "endDate": new Date()
        });

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

            $('#to_date').datepicker('destroy').datepicker({
                "format": "{{ app()->getLocale() == "fr" ? 'dd-mm-yyyy' : 'yyyy-mm-dd' }}",
                "keyboardNavigation": false,
                "autoclose": true,
                "startDate": $("#from_date").val(),
                "endDate":minDate
            }).datepicker('setDate', minDate);
        });

        $("#duration").on("change", function() {
            var duration = $(this).val();
            if(duration == "6") {
                $(".customDate").show();
            } else {
                $(".customDate").hide();
            }
        });


        $(document).on("click", "#apply-filter-paid", function() {
            var count = $(this).data("count") || 0;
            if(count > 0) {
                datatable.draw();
            } else {
                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') !!}"
                    },
                    processing: true,
                    serverSide: true,
                    responsive: true,
                    lengthMenu: [[10, 50, 100, -1], [10, 50, 100, 'All']],
                    pageLength: 10,
                    aaSorting: [9, 'DESC'],
                    ajax: {
                        url: "{{ url('SponsoredBanks/accounts/ajaxDatatable') }}",
                        type: "POST",
                        dataType: "json",
                        headers: {
                            'X-CSRF-TOKEN': "{{ csrf_token() }}"
                        },
                        data: function(data) {
                            data.account_from_date = $('#from_date').val();
                            data.account_to_date = $('#to_date').val();
                            data.agent_location_id = $("#agent_location_id").val();
                            data.type = $('#type').val();
                            data.duration = $("#duration").val();
                        },
                        error: function (xhr, error, code) {
                            $("#loading").hide();
                        },
                    },
                    columnDefs: [
                        {
                            targets: [0], // first column & numbering column
                            orderable: false, // set not orderable
                        },
                        {
                            targets: [9], // column index
                            visible: false,
                        }
                    ],
                    columns: [
                        {
                            data: 'DT_RowIndex',
                            name: 'DT_RowIndex'
                        },
                        {
                            data: 'date',
                            name: 'date'
                        },
                        {
                            data: 'agent_location_name',
                            name: 'agent_location_name'
                        },
                        {
                            data: 'transaction_type',
                            name: 'transaction_type'
                        },
                        {
                            data: 'reference',
                            name: 'reference'
                        },
                        {
                            data: 'paid_at',
                            name: 'paid_at'
                        },
                        {
                            data: 'credit_amount',
                            name: 'credit_amount'
                        },
                        {
                            data: 'debit_amount',
                            name: 'debit_amount'
                        },
                        {
                            data: 'balance',
                            name: 'balance'
                        },
                        {
                            data: 'id',
                            name: 'id'
                        }
                    ],
                }).on( 'preDraw', function () {
                    $("#loading").show();
                } ).on("draw", function() {
                    $("#loading").hide();
                });
            }
            $(this).data("count", ++count);
        });

        $(document).on("click", "#apply-filter-clear-paid", function() {
            window.location.reload();
        });

        $("#apply-filter-paid").trigger("click");
    });
</script>
@endsection