@extends('backend.layout.main') @section('content')

<section class="forms">
    <div class="container-fluid">
        <div class="card">
            <div class="card-header">
                <h4 class="text-center">{{ __('db.Supplier Due Report') }}</h4>
            </div>
            <div class="card-body">
                {!! Form::open(['route' => 'report.supplierDueByDate', 'method' => 'post']) !!}
                    <div class="row mb-3">
                        <!-- Date Range -->
                        <div class="col-md-6">
                            <div class="form-group">
                                <label><strong>{{ __('db.Choose Your Date') }}</strong></label>
                                <div class="input-group">
                                    <input type="text" class="daterangepicker-field form-control"
                                        value="{{ $start_date }} To {{ $end_date }}" required />
                                    <input type="hidden" name="start_date" value="{{ $start_date }}" />
                                    <input type="hidden" name="end_date" value="{{ $end_date }}" />
                                </div>
                            </div>
                        </div>

                        <!-- Supplier Filter -->
                        <div class="col-md-6">
                            <div class="form-group">
                                <label><strong>{{ __('db.Supplier') }}</strong></label>
                                <select name="supplier_id" class="form-control selectpicker"
                                        data-live-search="true">
                                    <option value="">{{ __('All Suppliers') }}</option>
                                    @foreach($lims_supplier_list as $supplier)
                                        <option value="{{ $supplier->id }}"
                                            {{ (old('supplier_id', $supplier_id ?? '') == $supplier->id) ? 'selected' : '' }}>
                                            {{ $supplier->name }}
                                        </option>
                                    @endforeach
                                </select>
                            </div>
                        </div>
                    </div>

                    <!-- Submit Button -->
                    <div class="row">
                        <div class="col text-center">
                            <button class="btn btn-primary" type="submit">{{ __('db.submit') }}</button>
                        </div>
                    </div>
                {!! Form::close() !!}
            </div>
        </div>
    </div>
    <div class="table-responsive mb-4">
        <table id="report-table" class="table table-hover">
            <thead>
                <tr>
                    <th class="not-exported"></th>
                    <th>{{__('db.date')}}</th>
                    <th>{{__('db.reference')}}</th>
                    <th>{{__('db.Supplier Details')}}</th>
                    <th>{{__('db.grand total')}}</th>
                    <th>{{__('db.Returned Amount')}}</th>
                    <th>{{__('db.Paid')}}</th>
                    <th>{{__('db.Due')}}</th>
                </tr>
            </thead>
            <tbody>
                @foreach($lims_purchase_data as $key => $purchase_data)
                    @if($purchase_data->supplier_id)