@extends('backend.layout.main') @section('content')
    <section class="forms">
        <div class="container-fluid">
            <div class="card">
                <div class="card-header mt-2">
                    <h3 class="text-center">{{ __('db.Payment Report') }}</h3>
                </div>

                <form action="{{ route('report.paymentByDate') }}" method="POST">
                    @csrf
                <div class="row mb-3 product-report-filter">
                    <div class="col-md-3 offset-md-2 mt-3">
                        <div class="form-group top-fields">
                            <label class="d-tc mt-2"><strong>{{ __('db.Choose Your Date') }}</strong> &nbsp;</label>
                            <div class="d-tc">
                                <div class="input-group">
                                    <input type="text" class="daterangepicker-field form-control"
                                        value="{{ $start_date }} To {{ $end_date }}" required />
                                    <input type="hidden" name="start_date" value="{{ $start_date }}">
                                    <input type="hidden" name="end_date" value="{{ $end_date }}">
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3 offset-md-2 mt-3">
                        <div class="form-group top-fields">
                            <label class="d-tc mt-2">
                                <strong>{{ __('db.Payment Method') }}</strong> &nbsp;
                            </label>

                            <select name="payment_method" class="form-control" style="width: 30%;">
                                <option value="">{{ __('db.All') }}</option>

                                <option value="Cash" {{ ($payment_method ?? '') == 'Cash' ? 'selected' : '' }}>Cash
                                </option>
                                <option value="Card" {{ ($payment_method ?? '') == 'Card' ? 'selected' : '' }}>Card
                                </option>
                                <option value="Credit Card"
                                    {{ ($payment_method ?? '') == 'Credit Card' ? 'selected' : '' }}>Credit Card</option>
                                <option value="Bank" {{ ($payment_method ?? '') == 'Bank' ? 'selected' : '' }}>Bank
                                </option>
                                <option value="Cheque" {{ ($payment_method ?? '') == 'Cheque' ? 'selected' : '' }}>Cheque
                                </option>
                                <option value="Moneipoint" {{ ($payment_method ?? '') == 'Moneipoint' ? 'selected' : '' }}>
                                    Moneipoint</option>
                                <option value="Pesapal" {{ ($payment_method ?? '') == 'Pesapal' ? 'selected' : '' }}>
                                    Pesapal</option>
                                <option value="Points" {{ ($payment_method ?? '') == 'Points' ? 'selected' : '' }}>Points
                                </option>
                            </select>
                        </div>
                    </div>
                </div>
                </form>
            </div>
        </div>
        <div id="table-container">
            @include('backend.report.partials.payment_table')
        </div>
    </section>
@endsection

@push('scripts')
    <script type="text/javascript">

        function initializePaymentTable() {
            $('#report-table').DataTable({
                "destroy": true,
                "order": [],
                'language': {
                    'lengthMenu': '_MENU_ {{ __('db.records per page') }}',
                    "info": '<small>{{ __('db.Showing') }} _START_ - _END_ (_TOTAL_)</small>',
                    "search": '{{ __('db.Search') }}',
                    'paginate': {
                        'previous': '<i class="dripicons-chevron-left"></i>',
                        'next': '<i class="dripicons-chevron-right"></i>'
                    }
                },
                'columnDefs': [{
                        "orderable": false,
                        'targets': 0
                    },
                    {
                        'render': function(data, type, row, meta) {
                            if (type === 'display') {
                                data =
                                    '<div class="checkbox"><input type="checkbox" class="dt-checkboxes"><label></label></div>';
                            }

                            return data;
                        },
                        'checkboxes': {
                            'selectRow': true,
                            'selectAllRender': '<div class="checkbox"><input type="checkbox" class="dt-checkboxes"><label></label></div>'
                        },
                        'targets': [0]
                    }
                ],
                'select': {
                    style: 'multi',
                    selector: 'td:first-child'
                },
                'lengthMenu': [
                    [10, 25, 50, -1],
                    [10, 25, 50, "All"]
                ],
                dom: '<"row"lfB>rtip',
                buttons: [{
                        extend: 'pdf',
                        text: '<i title="export to pdf" class="fa fa-file-pdf-o"></i>',
                        exportOptions: {
                            columns: ':visible:Not(.not-exported)',
                            rows: ':visible'
                        },
                        action: function(e, dt, button, config) {
                            datatable_sum(dt, true);
                            $.fn.dataTable.ext.buttons.pdfHtml5.action.call(this, e, dt, button, config);
                            datatable_sum(dt, false);
                        },
                        footer: true
                    },
                    {
                        extend: 'excel',
                        text: '<i title="export to excel" class="dripicons-document-new"></i>',
                        exportOptions: {
                            columns: ':visible:Not(.not-exported)',
                            rows: ':visible'
                        },
                        action: function(e, dt, button, config) {
                            datatable_sum(dt, true);
                            $.fn.dataTable.ext.buttons.excelHtml5.action.call(this, e, dt, button, config);
                            datatable_sum(dt, false);
                        },
                        footer: true
                    },
                    {
                        extend: 'csv',
                        text: '<i title="export to csv" class="fa fa-file-text-o"></i>',
                        exportOptions: {
                            columns: ':visible:Not(.not-exported)',
                            rows: ':visible'
                        },
                        action: function(e, dt, button, config) {
                            datatable_sum(dt, true);
                            $.fn.dataTable.ext.buttons.csvHtml5.action.call(this, e, dt, button, config);
                            datatable_sum(dt, false);
                        },
                        footer: true
                    },
                    {
                        extend: 'print',
                        text: '<i title="print" class="fa fa-print"></i>',
                        exportOptions: {
                            columns: ':visible:Not(.not-exported)',
                            rows: ':visible'
                        },
                        action: function(e, dt, button, config) {
                            datatable_sum(dt, true);
                            $.fn.dataTable.ext.buttons.print.action.call(this, e, dt, button, config);
                            datatable_sum(dt, false);
                        },
                        footer: true
                    },
                    {
                        extend: 'colvis',
                        text: '<i title="column visibility" class="fa fa-eye"></i>',
                        columns: ':gt(0)'
                    }
                ],
                drawCallback: function() {
                    var api = this.api();
                    datatable_sum(api, false);
                }
            });
        }
        
        initializePaymentTable();

        function reloadPaymentTable() {
            var formData = $('form').serialize();
            $.ajax({
                url: "{{ route('report.paymentByDate') }}",
                data: formData,
                method: 'POST',
                beforeSend: function () {
                    $('#table-container').html('<div class="text-center mt-4"><i class="fa fa-spin fa-spinner"></i> {{__("db.Loading")}}...</div>');
                },
                success: function (response) {
                    $('#table-container').html(response);
                    initializePaymentTable();
                }
            });
        }

        function datatable_sum(dt_selector, is_calling_first) {
            if (dt_selector.rows('.selected').any() && is_calling_first) {
                var rows = dt_selector.rows('.selected').indexes();

                $(dt_selector.column(6).footer()).html(dt_selector.cells(rows, 6, {
                    page: 'current'
                }).data().sum().toFixed({{ $general_setting->decimal }}));
            } else {
                $(dt_selector.column(6).footer()).html(dt_selector.column(6, {
                    page: 'current'
                }).data().sum().toFixed({{ $general_setting->decimal }}));
            }
        }

        // payment method change
        $('select[name="payment_method"]').on('change', function () {
            reloadPaymentTable();
        });

        // date range change
        $('.daterangepicker-field').on('apply.daterangepicker', function(ev, picker) {
            $('input[name="start_date"]').val(picker.startDate.format('YYYY-MM-DD'));
            $('input[name="end_date"]').val(picker.endDate.format('YYYY-MM-DD'));
            reloadPaymentTable();
        });

    </script>
@endpush