@extends('layouts.app')
@php
    $heading = __('product.due_stock_takes');
@endphp

@section('title', $heading)

@section('content')
    @include('layouts.partials.breadcrumb', [
        'page_title' => __('product.manage_due_stock_takes'),
        'bread_crumbs' => [
            ['title' => __('user.dashboard'), 'url' => ''],
            ['title' => __('product.due_stock_takes'), 'url' => '']
        ]
    ])

    <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, 'getStockExpiryReport']), 'method' => 'get', 'id' => 'stock_report_filter_form' ]) !!}
                    <div class="row">
                                                @if(empty($only) || in_array('sell_list_filter_date_range', $only))


                            <div class="col-md-3">
                                <div class="form-group">
                                    {!! Form::label('sell_list_filter_date_range', __('report.date_range') . ':',['class'=>'form-label']) !!}
                                    {!! Form::text('sell_list_filter_date_range', null, ['placeholder' => __('app.select_a_date_range'), 'class' => 'form-control', 'readonly']); !!}
                                </div>
                            </div>
                        @endif
                        <div class="col-md-3">
                            <div class="form-group">
                                {!! Form::label('stock_take_frequency', __('product.stock_take_frequency') . ':',['class'=>'form-label']) !!}
                                {!! Form::text('stock_take_frequency', null, ['placeholder' => __('product.stock_take_frequency'), 'class' => 'form-control', 'min' => 0, 'step' => 1]); !!}
                            </div>
                        </div>

                    </div>
                    {!! Form::close() !!}
                @endcomponent
            </div>
        </div>
        <div class="row">
            <div class="col-12">
                <div class="box">
                    @component('components.widget', ['class' => 'box-body', 'title' => __('product.manage_due_stock_takes')])
                        <input type="hidden" id="stock_take_type" value="due">
                        <div class="table-responsive">
                            <table class="table table-striped dataTable ajax_view" style="width:100%" role="grid"  id="due_stock_table">
                                <thead>
                                <tr>
                                    <th>@lang('product.product_name')</th>
                                    <th>@lang('product.sku')</th>
                                    <th>@lang('product.current_stock')</th>
                                    <th>@lang('product.stock_take_frequency')</th>
                                    <th>@lang('product.last_stock_take_date')</th>
                                    <th>@lang('product.pending_stock_take_date')</th>
                                    <th>@lang('messages.action')</th>
                                </tr>
                                </thead>
                            </table>
                        </div>

                    @endcomponent
                </div>
                <!-- /.box -->
            </div>
        </div>
        <!-- /.row -->
    </section>
@stop
@section('javascript')
    @parent
    <script src="{{ asset('theme/assets/vendor_components/datatable/datatables.min.js?v=' . $asset_v) }}"></script>
    <script src="{{ asset('theme/js/pages/data-table.js?v=' . $asset_v) }}"></script>
    <script type="text/javascript">
        $(document).ready(function() {
            // Custom JS for this page (if needed)
            dateRangeSettings.startDate = moment();
            dateRangeSettings.endDate = moment();

            // Check if start_date and end_date are available in the URL query parameters
            const urlParams = new URLSearchParams(window.location.search);
            const startDateParam = urlParams.get('start_date');
            const endDateParam = urlParams.get('end_date');


            // If the parameters are available, set the date range picker values
            if (startDateParam && endDateParam) {
                const startDate = moment(startDateParam);  // Convert start_date to a moment object
                const endDate = moment(endDateParam);  // Convert end_date to a moment object

                // Ensure start_date is less than or equal to end_date
                if (startDate.isAfter(endDate)) {
                    // If start date is after end date, set the start date to be the same as the end date
                    endDate = startDate;
                }


                dateRangeSettings.startDate = startDate;
                dateRangeSettings.endDate = endDate;
                const today = moment(); // Get current date using moment()
                // Ensure end_date is not greater than the current date
                if (endDate.isAfter(today)) {
                    // If end_date is in the future, set it to today's date
                    dateRangeSettings.endDate = moment();
                }

                $('#sell_list_filter_date_range').daterangepicker(
                    dateRangeSettings,
                    function (start, end) {
                        $('#sell_list_filter_date_range').val(start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format));

                        sale_report_table.ajax.reload();
                    }
                );
            } else {
                // If no date parameters are available, default to today's date
                dateRangeSettings.startDate = moment();
                dateRangeSettings.endDate = moment();
                $('#sell_list_filter_date_range').daterangepicker(
                    dateRangeSettings,
                    function (start, end) {
                        $('#sell_list_filter_date_range').val(start.format(moment_date_format) + ' ~ ' + end.format(moment_date_format));

                        sale_report_table.ajax.reload();
                    }
                );
            }




            sale_report_table = $('#due_stock_table').DataTable({
                processing: true,
                serverSide: true,
                //bPaginate: true,
                //lengthMenu: [10, 25, 50, 100],
                //pageLength: 10,
                //pagingType: 'simple_numbers',
                //buttons: [],
                ajax: {
                    url: '{{ route('stocktakes.due') }}', // URL to your `dueForStockTake` function
                    data: function(d) {
                        // Add the date range filter parameters to the DataTable's AJAX request
                        if($('#sell_list_filter_date_range').val()) {
                            var start = $('#sell_list_filter_date_range').data('daterangepicker').startDate.format('YYYY-MM-DD');
                            var end = $('#sell_list_filter_date_range').data('daterangepicker').endDate.format('YYYY-MM-DD');
                            d.start_date = start;
                            d.end_date = end;
                        }
                        // Check for stock_take_frequency value and append it if it's a positive number
                        var stockTakeFrequency = $('#stock_take_frequency').val();
                        if (stockTakeFrequency && parseInt(stockTakeFrequency) > 0) {
                            d.stock_take_frequency = stockTakeFrequency;
                        }
                    }
                },
                columns: [
                    { data: 'name', title: '{{ __("product.product_name") }}', orderable: true, searchable: true },
                    { data: 'item_code', title: '{{ __("product.sku") }}', orderable: true, searchable: true },
                    { data: 'stock', title: '{{ __("product.current_stock") }}', orderable: true, searchable: true },
                    { data: 'frequency', title: '{{ __("product.stock_take_frequency") }}', orderable: true, searchable: true },
                    { data: 'last_stock_take_date', title: '{{ __("product.last_stock_take_date") }}', orderable: true, searchable: true },
                    { data: 'pending_stock_take_dates', title: '{{ __("product.pending_stock_take_date") }}', orderable: true, searchable: true },
                    { data: 'action', title: '{{ __("messages.action") }}', orderable: false, searchable: false }
                ],
                order: [[3, 'asc']], // Default ordering by next stock take date
                "fnDrawCallback": function (oSettings) {
                    __currency_convert_recursively($('#due_stock_table'));
                }
            });

            $(document).on('change', '#stock_take_frequency, #sell_list_filter_customer_id, #sell_list_filter_payment_status, #created_by, #sales_cmsn_agnt, #service_staffs',  function() {
                sale_report_table.ajax.reload();
            });
        });

        $(document).off('change', '#stocktake_location').on('change', '#stocktake_location', function() {
            let location_id = $(this).val();
            let product_id = $('input[name="product_id"]').val();

            $.ajax({
                url: "{{ route('stocktakes.details', ':id') }}".replace(':id', product_id),
                data: { location_id: location_id },
                success: function(result) {
                    $('#stocktake_product_details').html(result);
                }
            });
        });
    </script>
@endsection