@extends('layouts.app')
@section('title', 'Customer Advance Deposits Report')

@section('content')

<!-- Content Header (Page header) -->
<section class="content-header">
    <h1 class="tw-text-xl md:tw-text-3xl tw-font-bold tw-text-black">Customer Advance Deposits Report</h1>
</section>

<!-- Main content -->
<section class="content">
    @component('components.filters', ['title' => __('report.filters')])
        <div class="col-md-3">
            <div class="form-group">
                {!! Form::label('date_range', __('report.date_range') . ':') !!}
                {!! Form::text('date_range', null, ['placeholder' => __('lang_v1.select_a_date_range'), 'class' => 'form-control', 'id' => 'adv_dep_date_filter', 'readonly']); !!}
            </div>
        </div>
        <div class="col-md-3">
            <div class="form-group">
                {!! Form::label('adv_dep_location_id',  __('purchase.business_location') . ':') !!}
                {!! Form::select('adv_dep_location_id', $business_locations, null, ['class' => 'form-control select2', 'style' => 'width:100%', 'placeholder' => __('lang_v1.all')]); !!}
            </div>
        </div>
        <div class="col-md-3">
            <div class="form-group">
                {!! Form::label('adv_dep_customer_id',  __('contact.customer') . ':') !!}
                {!! Form::select('adv_dep_customer_id', $customers, null, ['class' => 'form-control select2', 'style' => 'width:100%', 'placeholder' => __('lang_v1.all')]); !!}
            </div>
        </div>
        <div class="col-md-3">
            <div class="form-group">
                {!! Form::label('adv_dep_payment_method',  __('lang_v1.payment_method') . ':') !!}
                {!! Form::select('adv_dep_payment_method', ['cash' => __('lang_v1.cash'), 'card' => __('lang_v1.card'), 'cheque' => __('lang_v1.cheque'), 'bank_transfer' => __('lang_v1.bank_transfer'), 'other' => __('lang_v1.other'), 'custom_pay_1' => __('lang_v1.custom_payment_1'), 'custom_pay_2' => __('lang_v1.custom_payment_2'), 'custom_pay_3' => __('lang_v1.custom_payment_3')], null, ['class' => 'form-control select2', 'style' => 'width:100%', 'placeholder' => __('lang_v1.all')]); !!}
            </div>
        </div>
    @endcomponent

    @component('components.widget', ['class' => 'box-primary'])
        <div class="table-responsive">
            <table class="table table-bordered table-striped" id="adv_dep_table">
                <thead>
                    <tr>
                        <th>Date</th>
                        <th>Location</th>
                        <th>Customer</th>
                        <th>Payment Method</th>
                        <th>Ref No</th>
                        <th>Note</th>
                        <th>Amount</th>
                    </tr>
                </thead>
                <tfoot>
                    <tr class="bg-gray font-17 text-center footer-total">
                        <td colspan="6"><strong>@lang('sale.total'):</strong></td>
                        <td class="display_currency footer_total_amount" data-currency_symbol="true"></td>
                    </tr>
                </tfoot>
            </table>
        </div>
    @endcomponent

</section>
<!-- /.content -->

@endsection

@section('javascript')
<script type="text/javascript">
    $(document).ready(function() {
        if($('#adv_dep_date_filter').length == 1) {
            $('#adv_dep_date_filter').daterangepicker(
                dateRangeSettings,
                function (start, end) {
                    $('#adv_dep_date_filter').val(start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format));
                    adv_dep_table.ajax.reload();
                }
            );
            $('#adv_dep_date_filter').on('cancel.daterangepicker', function(ev, picker) {
                $('#adv_dep_date_filter').val('');
                adv_dep_table.ajax.reload();
            });
        }

        adv_dep_table = $('#adv_dep_table').DataTable({
            processing: true,
            serverSide: true,
            ajax: {
                url: '/ls-reports/customer-advance-deposits',
                data: function(d) {
                    if($('#adv_dep_date_filter').val()) {
                        var start = $('#adv_dep_date_filter').data('daterangepicker').startDate.format('YYYY-MM-DD');
                        var end = $('#adv_dep_date_filter').data('daterangepicker').endDate.format('YYYY-MM-DD');
                        d.start_date = start;
                        d.end_date = end;
                    }
                    if($('#adv_dep_location_id').length) {
                        d.location_id = $('#adv_dep_location_id').val();
                    }
                    if($('#adv_dep_customer_id').length) {
                        d.customer_id = $('#adv_dep_customer_id').val();
                    }
                    if($('#adv_dep_payment_method').length) {
                        d.payment_method = $('#adv_dep_payment_method').val();
                    }
                }
            },
            columns: [
                { data: 'paid_on', name: 'transaction_payments.paid_on' },
                { data: 'location_name', name: 'location_name', searchable: false },
                { data: 'customer_name', name: 'contacts.name' },
                { data: 'method', name: 'transaction_payments.method' },
                { data: 'payment_ref_no', name: 'transaction_payments.payment_ref_no' },
                { data: 'note', name: 'transaction_payments.note' },
                { data: 'amount', name: 'transaction_payments.amount' }
            ],
            colReorder: true,
            fnDrawCallback: function(oSettings) {
                var total_amount = sum_table_col($('#adv_dep_table'), 'amount');
                $('#adv_dep_table .footer_total_amount').text(total_amount);
                __currency_convert_recursively($('#adv_dep_table'));
            }
        });

        $(document).on('change', '#adv_dep_location_id, #adv_dep_customer_id, #adv_dep_payment_method',  function() {
            adv_dep_table.ajax.reload();
        });
    });
</script>
@endsection