@extends('layout.erp.app')
@section('title', 'Order Report')
@section('style')


@endsection
@section('page')
    <div class="container">
        <div class="row">
            <div class="col-md-12">
                <div class="card">
                    <div class="card-body">


                        <h2 class="mb-4">Order Report</h2>

                        <form method="POST" action="{{ url('/order-report') }}">
                            @csrf
                            <div class="row mb-3">
                                <div class="col-md-3">
                                    <label for="start_date" class="form-label">Start Date</label>
                                    <input type="date" id="start_date" name="start_date" class="form-control"
                                        value="{{ old('start_date', $startDate ?? '') }}" required>
                                </div>
                                <div class="col-md-3">
                                    <label for="end_date" class="form-label">End Date</label>
                                    <input type="date" id="end_date" name="end_date" class="form-control"
                                        value="{{ old('end_date', $endDate ?? '') }}" required>
                                </div>
                                <div class="col-md-3">
                                    <label for="customer_id" class="form-label">Select Customer</label>
                                    <select id="customer_id" name="customer_id" class="form-control">
                                        <option value="">All Customers</option>
                                        @foreach ($customers as $customer)
                                            <option value="{{ $customer->id }}"
                                                {{ old('customer_id', $customerId ?? '') == $customer->id ? 'selected' : '' }}>
                                                {{ $customer->name }}
                                            </option>
                                        @endforeach
                                    </select>
                                </div>
                                <div class="col-md-3">
                                    <label for="status_id" class="form-label">Order Status</label>
                                    <select id="status_id" name="status_id" class="form-control">
                                        <option value="">All Statuses</option>
                                        @foreach ($statuses as $status)
                                            <option value="{{ $status->id }}"
                                                {{ old('status_id', $statusId ?? '') == $status->id ? 'selected' : '' }}>
                                                {{ $status->name }}
                                            </option>
                                        @endforeach
                                    </select>
                                </div>
                                <div class="col-md-3 d-flex align-items-end">
                                    <button type="submit" class="btn btn-primary">Generate Report</button>
                                </div>
                            </div>
                        </form>


                        @if (!empty($orders))
                            <table class="table table-bordered mt-4">
                                <thead>
                                    <tr>
                                        <th>Id</th>
                                        <th>Customer</th>
                                        <th>Order Total</th>
                                        <th>Discount</th>
                                        <th>Shipping Address</th>
                                        <th>Paid Amount</th>
                                        <th>Order Status</th>
                                        <th>Order Date</th>
                                        <th>Delivery Date</th>
                                        <th>Vat</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach ($orders as $order)
                                        <tr>
                                            <td>{{ $order->id }}</td>
                                            <td>{{ optional($order->customers)->name }}</td>
                                            <td>{{ $order->order_total }}</td>
                                            <td>{{ $order->discount }}</td>
                                            <td>{{ optional($order->customers)->address }}</td>
                                            <td>{{ $order->paid_amount }}</td>
                                            <td>{{ optional($order->statuse)->name }}</td>
                                            <td>{{ $order->order_date }}</td>
                                            <td>{{ $order->delivery_date }}</td>
                                            <td>{{ $order->vat }}</td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        @else
                            <p class="mt-4 text-center">No purchases found for the selected date range.</p>
                        @endif

                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection