@extends('layouts.app')
@section('title', __('lang_v1.sell_return_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">{{ __('lang_v1.sell_return_report') }}</h1>
    </section>

    <!-- Main content -->
    <section class="content">
        <div class="row">
            <div class="col-md-12">
                @component('components.filters', ['title' => __('report.filters')])
                    {!! Form::open([
                        'url' => action([\App\Http\Controllers\ReportController::class, 'getStockReport']),
                        'method' => 'get',
                        'id' => 'stock_report_filter_form',
                    ]) !!}
                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('user_filter', __('report.user') . ':') !!}
                            {!! Form::select('user_filter', $usersFilter, null, [
                                'class' => 'form-control select2',
                                'id' => 'user_filter',
                                'placeholder' => __('lang_v1.all'),
                                'style' => 'width:100%',
                            ]) !!}
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('search_product', __('lang_v1.search_product') . ':') !!}
                            <div class="input-group">
                                <span class="input-group-addon">
                                    <i class="fa fa-search"></i>
                                </span>
                                <input type="hidden" value="" id="variation_id">
                                {!! Form::text('search_product', null, [
                                    'class' => 'form-control',
                                    'id' => 'search_product',
                                    'placeholder' => __('lang_v1.search_product_placeholder'),
                                    'autofocus',
                                ]) !!}
                            </div>
                        </div>
                    </div>
                    <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',
                                    'placeholder' => __('messages.please_select'),
                                    'required',
                                    'style' => 'width:100%',
                                ]) !!}
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('product_sr_date_filter', __('report.date_range') . ':') !!}
                            {!! Form::text('date_range', null, [
                                'placeholder' => __('lang_v1.select_a_date_range'),
                                'class' => 'form-control',
                                'id' => 'product_sr_date_filter',
                                'readonly',
                            ]) !!}
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('location_id', __('purchase.business_location') . ':') !!}
                            {!! Form::select('location_id', $business_locations ?? [], null, [
                                'class' => 'form-control select2',
                                'placeholder' => __('messages.all'),
                                'style' => 'width:100%',
                                'id' => 'location_id',
                            ]) !!}
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-group">
                            {!! Form::label('category_id', __('category.category') . ':') !!}
                            {!! Form::select('category', $categories ?? [], null, [
                                'placeholder' => __('messages.all'),
                                'class' => 'form-control select2',
                                'style' => 'width:100%',
                                'id' => 'category_id',
                            ]) !!}
                        </div>
                    </div>

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


                    {!! Form::close() !!}
                @endcomponent
            </div>
        </div>

        <div class="row">
            <div class="col-md-12">
                @component('components.widget', ['class' => 'box-solid'])
                    <table class="table table-bordered table-striped" id="sell_return_report_table">
                        <thead>
                            <tr>
                                <th>@lang('sale.product')</th>

                                <th>@lang('product.sku')</th>

                                <th>@lang('sale.customer_name')</th>

                                <th>@lang('lang_v1.contact_id')</th>
                                <th>@lang('sale.invoice_no')</th>
                                <th>@lang('messages.date')</th>
                                <th>@lang('sale.qty')</th>

                                <th>@lang('sale.unit_price')</th>
                                <th>@lang('sale.price_inc_tax')</th>
                                <th>@lang('sale.total')</th>

                                <th>@lang('lang_v1.created_by')</th>
                            </tr>
                        </thead>
                        <tfoot>
                            <tr class="bg-gray font-17 footer-total text-center">
                                <td><strong>@lang('sale.total'):</strong></td>

                                <td></td>
                                <td></td>

                                <td></td>

                                <td></td>
                                <td></td>
                                <td></td>


                                <td></td>
                                <td></td>
                                <td><span class="display_currency" id="footer_subtotal" data-currency_symbol ="true"></span>
                                </td>
                                <td></td>
                            </tr>
                        </tfoot>
                    </table>
                @endcomponent
            </div>
        </div>
    </section>
    <!-- /.content -->


@endsection

@section('javascript')
    <script>
        $(document).ready(function() {
  $('#product_sr_date_filter').daterangepicker(
            $.extend(true, {}, dateRangeSettings, {
                startDate: moment(),  // Today start
                endDate: moment()     // Today end
            }),
            function(start, end) {
                $('#product_sr_date_filter').val(
                    start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format)
                );
             sell_return_report.ajax.reload();
            }
        );
        
        $('#product_sr_date_filter').on('cancel.daterangepicker', function(ev, picker) {
            $('#product_sr_date_filter').val('');
         sell_return_report.ajax.reload();
        });

        $('#start_time, #end_time').datetimepicker({
            format: moment_time_format,
            ignoreReadonly: true,
        }).on('dp.change', function(ev){
         sell_return_report.ajax.reload();
        });
            $(
                '#brand_id,#category_id,#location_id,select#customer_id,#variation_id,#user_filter'
            ).change(function() {
                sell_return_report.ajax.reload();

            });
            let sell_col = [{
                    data: 'product_name',
                    name: 'p.name'
                },
                {
                    data: 'sub_sku',
                    name: 'v.sub_sku'
                },

                {
                    data: 'customer',
                    name: 'c.name'
                },
                {
                    data: 'contact_id',
                    name: 'c.contact_id'
                },

                {
                    data: 'invoice_no',
                    name: 'transactions.invoice_no'
                },
                {
                    data: 'transaction_date',
                    name: 'transactions.transaction_date'
                },
                {
                    data: 'quantity',
                    name: 'transaction_sell_lines.quantity_returned'
                },
                {
                    data: 'unit_price',
                    name: 'transaction_sell_lines.unit_price_before_discount'
                },
                {
                    data: 'unit_sale_price',
                    name: 'transaction_sell_lines.unit_price_inc_tax'
                },
                {
                    data: 'subtotal',
                    name: 'subtotal',
                    searchable: false
                },
                {
                    data: 'created_by',
                    name: 'user.username'
                },
            ];
            sell_return_report = $('table#sell_return_report_table').DataTable({
                processing: true,
                serverSide: true,
                fixedHeader: false,
                aaSorting: [
                    [5, 'desc']
                ],
                ajax: {
                    url: '/reports/sell-return',
                    data: function(d) {


                        d.location_id = $('select#location_id').val();
                        d.category_id = $('select#category_id').val();
                        d.brand_id = $('select#brand_id').val();
                        d.user_id = $('select#user_filter').val();
                        var start = '';
                        var end = '';
                        var start_time = $('#start_time').val();
                        var end_time = $('#end_time').val();
                        if ($('#product_sr_date_filter').val()) {
                            start = $('input#product_sr_date_filter')
                                .data('daterangepicker')
                                .startDate.format('YYYY-MM-DD');
                            end = $('input#product_sr_date_filter')
                                .data('daterangepicker')
                                .endDate.format('YYYY-MM-DD');

                            start = moment(start + " " + start_time, "YYYY-MM-DD" + " " +
                                moment_time_format).format('YYYY-MM-DD HH:mm');
                            end = moment(end + " " + end_time, "YYYY-MM-DD" + " " + moment_time_format)
                                .format('YYYY-MM-DD HH:mm');
                        }
                        d.start_date = start;
                        d.end_date = end;

                        d.variation_id = $('#variation_id').val();
                        d.customer_id = $('select#customer_id').val();
                    },
                },
                columns: sell_col,
                fnDrawCallback: function(oSettings) {
                    $('#footer_subtotal').text(
                        sum_table_col($('#sell_return_report_table'), 'row_subtotal')
                    );
                    __currency_convert_recursively($(
                        '#sell_return_report_table'));
                },
            });
             if ($('#search_product').length > 0) {
        $('#search_product').autocomplete({
            source: function(request, response) {
                $.ajax({
                    url: '/purchases/get_products?check_enable_stock=false',
                    dataType: 'json',
                    data: {
                        term: request.term,
                    },
                    success: function(data) {
                        response(
                            $.map(data, function(v, i) {
                                if (v.variation_id) {
                                    return { label: v.text, value: v.variation_id };
                                }
                                return false;
                            })
                        );
                    },
                });
            },
            minLength: 2,
            select: function(event, ui) {
                $('#variation_id')
                    .val(ui.item.value)
                    .change();
                event.preventDefault();
                $(this).val(ui.item.label);
            },
            focus: function(event, ui) {
                event.preventDefault();
                $(this).val(ui.item.label);
            },
        });
    } $('#stock_report_filter_form #search_product').keyup(function() {
        if (
            $(this)
                .val()
                .trim() == ''
        ) {
            $('#stock_report_filter_form #variation_id')
                .val('')
                .change();
        }
    });
        });
    </script>
@endsection