@extends('layouts.app')
@section('title', __('Sales Report'))

@section('content')

<!-- Content Header (Page header) -->
<section class="content-header">
    <h1>{{ __('Sales Return Report')}}</h1>
</section>

<!-- Main content -->
<section class="content">
    <div class="row">
        <div class="col-md-12">
            <div class="box box-primary" id="accordion">
              <div class="box-header with-border">
                <h3 class="box-title">
                  <a data-toggle="collapse" data-parent="#accordion" href="#collapseFilter">
                    <i class="fa fa-filter" aria-hidden="true"></i> @lang('report.filters')
                  </a>
                </h3>
              </div>
              <div id="collapseFilter" class="panel-collapse active collapse in" aria-expanded="true">
                <div class="box-body">
                  {!! Form::open(['url' => action('ReportController@getStockReport'), 'method' => 'get', 'id' => 'sales_representative_filter_form' ]) !!}
                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('sr_id',  __('report.user') . ':') !!}
                            {!! Form::select('sr_id', $users, null, ['class' => 'form-control select2', 'style' => 'width:100%', 'placeholder' => __('report.all_users')]); !!}
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('sr_business_id',  __('business.business_location') . ':') !!}
                            {!! Form::select('sr_business_id', $business_locations, null, ['class' => 'form-control select2', 'style' => 'width:100%']); !!}
                        </div>
                    </div>

                    <div class="col-md-3">
                        <div class="form-group">

                            {!! Form::label('sr_date_filter', __('report.date_range') . ':') !!}
                            {!! Form::text('date_range', null, ['placeholder' => __('lang_v1.select_a_date_range'), 'class' => 'form-control', 'id' => 'sr_date_filter', 'readonly']); !!}
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('method', __('Return Type') . ':') !!}
                            <select name="return_type" id="return_type" class="form-control mousetrap">
                                <option value="">Select Type</option>
                                <option value="exchange">Exchange</option>
                                <option value="refound">Refund</option>
                                <option value="other">Other</option>
                            </select>
                        </div>
                    </div>

                    {!! Form::close() !!}
                </div>
              </div>
            </div>
        </div>
    </div>
    <div class="box box-primary" id="accordion">
        <div class="box-body">
            <div class="row">
                <div class="col-md-12">
                    <div class="table-responsive">
                        <table class="table table-bordered table-striped ajax_view" id="sell_table">
                            <thead>
                                <tr>
                                    <th>@lang('messages.date')</th>
                                    <th>@lang('sale.invoice_no')</th>
                                    <th>@lang('Return Type')</th>
                                    <th>@lang('sale.customer_name')</th>
                                    <th class="hide"></th>
                                    <th>Sale Person</th>
                                    <th>@lang('sale.location')</th>
                                    <th>@lang('sale.payment_status')</th>
                                    <th>@lang('sale.total_amount')</th>
                                    <th>@lang('sale.total_paid')</th>
                                    <th>@lang('sale.total_remaining')</th>
                                </tr>
                            </thead>
                            <tfoot>
                                <tr class="bg-gray font-17 footer-total text-center">
                                    <td colspan="7"><strong>@lang('sale.total'):</strong></td>
                                    <td id="footer_payment_status_count"></td>
                                    <td><span class="display_currency" id="footer_sale_total" data-currency_symbol ="true"></span></td>
                                    <td><span class="display_currency" id="footer_total_paid" data-currency_symbol ="true"></span></td>
                                    <td><span class="display_currency" id="footer_total_remaining" data-currency_symbol ="true"></span></td>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</section>
<!-- /.content -->
<div class="modal fade view_register" tabindex="-1" role="dialog" 
    aria-labelledby="gridSystemModalLabel">
</div>

@endsection
@section('javascript')
<script>
    $(document).ready(function () {
        $('input#sr_date_filter').daterangepicker(dateRangeSettings,
            function (start, end) {
                $('input#sr_date_filter').val(start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format));
            }
        );
        $('input#sr_date_filter').on('apply.daterangepicker', function (ev, picker) {
            $(this).val(picker.startDate.format(moment_date_format) + ' ~ ' + picker.endDate.format(moment_date_format));
        });

        $('input#sr_date_filter').on('cancel.daterangepicker', function (ev, picker) {
            $(this).val('');
        });

        sell_table = $('#sell_table').DataTable({
            processing: true,
            serverSide: true,
            aaSorting: [[0, 'desc']],
            "ajax": {
                "url": "/reports/sale-return-report",
                "data": function ( d ) {
                    var start = $('#sr_date_filter').data('daterangepicker').startDate.format('YYYY-MM-DD');
                    var end = $('#sr_date_filter').data('daterangepicker').endDate.format('YYYY-MM-DD');
                    d.start_date = start;
                    d.end_date = end;
                    d.location_id = $('#sr_business_id').val();
                    d.user_id = $('#sr_id').val();
                    d.return_type = $('#return_type').val();
                }
            },
            columnDefs: [ {
                "targets": 10,
                "orderable": false,
                "searchable": false
            } ],
            columns: [
                { data: 'transaction_date', name: 'transaction_date'  },
                { data: 'invoice_no', name: 'invoice_no'},
                { data: 'return_type', name: 'return_type'  },
                { data: 'name', name: 'contacts.name'},
                { data: 'mobile', name: 'contacts.mobile', searchable : true, visible: false},
                { data: 'sale', name: 'users.first_name'},
                { data: 'business_location', name: 'bl.name'},
                { data: 'payment_status', name: 'payment_status'},
                { data: 'final_total', name: 'final_total'},
                { data: 'total_paid', name: 'total_paid', searchable : false},
                { data: 'total_remaining', name: 'total_remaining'},
            ],
            "fnDrawCallback": function (oSettings) {

                $('#footer_sale_total').text(sum_table_col($('#sell_table'), 'final-total'));
                
                $('#footer_total_paid').text(sum_table_col($('#sell_table'), 'total-paid'));

                $('#footer_total_remaining').text(sum_table_col($('#sell_table'), 'total-remaining'));

                $('#footer_payment_status_count').html(__sum_status_html($('#sell_table'), 'payment-status-label'));

                __currency_convert_recursively($('#sell_table'));
            },
            createdRow: function( row, data, dataIndex ) {
                $( row ).find('td:eq(4)').attr('class', 'clickable_td');
            }
        });

        $('#sr_date_filter, #sr_business_id,#sr_id, #return_type').change(function () {
            sell_table.ajax.reload();
        });
    });
</script>
@endsection