@extends('layouts.app')
@section('title', __('lang_v1.refund_report'))

@section('content')

<section class="content-header">
    <h1 class="tw-text-xl md:tw-text-3xl tw-font-bold tw-text-black">{{ __('lang_v1.refund_report') }}</h1>
</section>

<section class="content no-print">
    <div class="row">
        <div class="col-md-12">
            @component('components.filters', ['title' => __('report.filters')])
                {!! Form::open(['url' => '#', 'method' => 'get', 'id' => 'refund_report_form' ]) !!}
                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('customer_id', __('contact.customer') . ':') !!}
                            <div class="input-group">
                                <span class="input-group-addon">
                                    <i class="fa fa-user"></i>
                                </span>
                                {!! Form::select('customer_id', $customers, null, ['class' => 'form-control select2',  'style' => 'width:100%', 'placeholder' => __('messages.all')]); !!}
                            </div>
                        </div>
                    </div>

                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('location_id', __('purchase.business_location').':') !!}
                            <div class="input-group">
                                <span class="input-group-addon">
                                    <i class="fa fa-map-marker"></i>
                                </span>
                                {!! Form::select('location_id', $business_locations, null, ['class' => 'form-control select2',  'style' => 'width:100%', 'placeholder' => __('messages.all')]); !!}
                            </div>
                        </div>
                    </div>

                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('payment_method', __('lang_v1.payment_method').':') !!}
                            <div class="input-group">
                                <span class="input-group-addon">
                                    <i class="fas fa-money-bill-alt"></i>
                                </span>
                                {!! Form::select('payment_method', $payment_types, null, ['class' => 'form-control select2', 'placeholder' => __('messages.all'), 'style' => 'width:100%']); !!}
                            </div>
                        </div>
                    </div>

                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('payment_status', __('sale.payment_status').':') !!}
                            {!! Form::select('payment_status', ['' => __('messages.all'), 'paid' => __('lang_v1.paid'), 'partial' => __('lang_v1.partial'), 'due' => __('lang_v1.due')], null, ['class' => 'form-control select2', 'style' => 'width:100%']); !!}
                        </div>
                    </div>

                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('employee_id', __('report.user') . ':') !!}
                            {!! Form::select('employee_id', $users, null, ['class' => 'form-control select2', 'style' => 'width:100%', 'placeholder' => __('messages.all')]) !!}
                        </div>
                    </div>

                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('refund_date_filter', __('report.date_range') . ':') !!}
                            {!! Form::text('date_range', null, ['placeholder' => __('lang_v1.select_a_date_range'), 'class' => 'form-control', 'id' => 'refund_date_filter', 'readonly']); !!}
                        </div>
                    </div>
                {!! Form::close() !!}
            @endcomponent
        </div>
    </div>

    <div class="row">
        <div class="col-md-12">
            @component('components.widget', ['class' => 'box-primary'])
                <div class="table-responsive">
                    <table class="table table-bordered table-striped" id="refund_report_table">
                        <thead>
                            <tr>
                                <th>@lang('messages.action')</th>
                                <th>@lang('messages.date')</th>
                                <th>Refund No.</th>
                                <th>@lang('sale.invoice_no')</th>
                                <th>@lang('contact.customer')</th>
                                <th>@lang('report.user')</th>
                                <th>@lang('sale.location')</th>
                                <th>Return Value</th>
                                <th>Cash Refunded</th>
                                <th>Exchange Applied</th>
                                <th>Store Credit</th>
                                <th>Cash Refund Due</th>
                                <th>@lang('sale.payment_status')</th>
                                <th>@lang('lang_v1.payment_method')</th>
                            </tr>
                        </thead>
                        <tfoot>
                            <tr class="bg-gray font-17 footer-total text-center">
                                <td colspan="7"><strong>@lang('sale.total'):</strong></td>
                                <td><span class="display_currency" id="footer_return_value" data-currency_symbol ="true"></span></td>
                                <td><span class="display_currency" id="footer_cash_refunded" data-currency_symbol ="true"></span></td>
                                <td><span class="display_currency" id="footer_exchange_applied" data-currency_symbol ="true"></span></td>
                                <td><span class="display_currency" id="footer_store_credit" data-currency_symbol ="true"></span></td>
                                <td><span class="display_currency" id="footer_cash_refund_due" data-currency_symbol ="true"></span></td>
                                <td colspan="2"></td>
                            </tr>
                        </tfoot>
                    </table>
                </div>
            @endcomponent
        </div>
    </div>
</section>

<div class="modal fade view_modal" tabindex="-1" role="dialog" aria-labelledby="gridSystemModalLabel"></div>
<div class="modal fade payment_modal" tabindex="-1" role="dialog" aria-labelledby="gridSystemModalLabel"></div>

@endsection

@section('javascript')
<script src="{{ asset('js/report.js?v=' . $asset_v) }}"></script>
<script src="{{ asset('js/payment.js?v=' . $asset_v) }}"></script>
<script>
    $(document).ready(function() {
        // date range default: today
        var start = moment();
        var end = moment();
        $('#refund_date_filter').daterangepicker(
            $.extend(true, {}, dateRangeSettings, { startDate: start, endDate: end }),
            function(start, end) {
                $('#refund_date_filter').val(start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format));
                refund_report_table.ajax.reload();
            }
        );
        if ($('#refund_date_filter').data('daterangepicker')) {
            var picker = $('#refund_date_filter').data('daterangepicker');
            $('#refund_date_filter').val(picker.startDate.format(moment_date_format) + ' ~ ' + picker.endDate.format(moment_date_format));
        }
        $('#refund_date_filter').on('cancel.daterangepicker', function(ev, picker) {
            $(this).val('');
            refund_report_table.ajax.reload();
        });

        refund_report_table = $('#refund_report_table').DataTable({
            processing: true,
            serverSide: true,
            fixedHeader: false,
            aaSorting: [[1, 'desc']],
            ajax: {
                url: '/reports/refund-report',
                data: function(d) {
                    if ($('#refund_date_filter').val()) {
                        var drp = $('#refund_date_filter').data('daterangepicker');
                        d.start_date = drp.startDate.format('YYYY-MM-DD');
                        d.end_date = drp.endDate.format('YYYY-MM-DD');
                    }
                    d.location_id = $('#refund_report_form #location_id').val();
                    d.customer_id = $('#refund_report_form #customer_id').val();
                    d.payment_method = $('#refund_report_form #payment_method').val();
                    d.payment_status = $('#refund_report_form #payment_status').val();
                    d.employee_id = $('#refund_report_form #employee_id').val();
                }
            },
            columns: [
                { data: 'action', name: 'action', orderable: false, searchable: false },
                { data: 'transaction_date', name: 'transactions.transaction_date' },
                { data: 'refund_invoice_no', name: 'refund_invoice_no' },
                { data: 'invoice_no', name: 'invoice_no' },
                { data: 'customer', name: 'c.name', orderable: false },
                { data: 'added_by', name: 'u.first_name', orderable: false },
                { data: 'business_location', name: 'business_location' },
                { data: 'return_value', name: 'return_value', searchable: false },
                { data: 'cash_refunded', name: 'cash_refunded', searchable: false, orderable: false },
                { data: 'exchange_applied', name: 'exchange_applied', searchable: false, orderable: false },
                { data: 'store_credit_issued', name: 'store_credit_issued', searchable: false, orderable: false },
                { data: 'cash_refund_due', name: 'cash_refund_due', searchable: false, orderable: false },
                { data: 'payment_status', name: 'transactions.payment_status', orderable: false, searchable: false },
                { data: 'refund_methods', name: 'refund_methods', orderable: false, searchable: false },
            ],
            fnDrawCallback: function(oSettings) {
                __currency_convert_recursively($('#refund_report_table'));

                $('#footer_return_value').text(sum_table_col($('#refund_report_table'), 'return_value'));
                $('#footer_cash_refunded').text(sum_table_col($('#refund_report_table'), 'cash_refunded'));
                $('#footer_exchange_applied').text(sum_table_col($('#refund_report_table'), 'exchange_applied'));
                $('#footer_store_credit').text(sum_table_col($('#refund_report_table'), 'store_credit_issued'));
                $('#footer_cash_refund_due').text(sum_table_col($('#refund_report_table'), 'cash_refund_due'));
                __currency_convert_recursively($('#refund_report_table tfoot'));
            }
        });

        $('#refund_report_form').on('change', 'select', function() {
            refund_report_table.ajax.reload();
        });
    });
</script>
@endsection