@extends('admin.layout.app')

@section('content')
<div class="app-content">
    <div class="container-fluid">
        <div class="row mb-3">
            <div class="col-12 d-flex flex-wrap justify-content-between align-items-center">
                <h2 class="mb-0 fw-bold">School Orders</h2>
            </div>
        </div>

        @if (session('success'))
            <div class="alert alert-success">
                {{ session('success') }}
            </div>
        @endif

        <div class="row mb-3">
            <div class="col-12">
                <form method="GET" action="{{ route('admin.student-orders.index') }}" class="row g-2 align-items-end">
                    <div class="col-12 col-md-4">
                        <label class="form-label mb-1">School</label>
                        <select name="school_id" class="form-select">
                            <option value="">All Schools</option>
                            @foreach(($schools ?? collect()) as $school)
                                <option value="{{ $school->id }}" {{ (string)request('school_id') === (string)$school->id ? 'selected' : '' }}>
                                    {{ $school->name }}
                                </option>
                            @endforeach
                        </select>
                    </div>
                    <div class="col-12 col-md-auto">
                        <button type="submit" class="btn btn-primary">Filter</button>
                        <a href="{{ route('admin.student-orders.index') }}" class="btn btn-outline-secondary">Reset</a>
                    </div>
                </form>
            </div>
        </div>

        <div class="row">
            <div class="col-12">
                <div class="card shadow-sm border-0">
                    <div class="card-body">
                        <div class="table-responsive">
                            <table class="table table-bordered align-middle text-center mb-0">
                                <thead class="table-light">
                                    <tr>
                                        <th style="width:5%;">#</th>
                                        <th style="width:10%;">Student ID</th>
                                        <th style="width:15%;">Student Name</th>
                                        <th style="width:15%;">School</th>
                                        <th style="width:12%;">Order Date</th>
                                        <th>Total Items</th>
                                        <th style="width:15%;">Action</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @forelse ($orders as $key => $order)
                                        <tr>
                                            <td>{{ $orders->firstItem() + $key }}</td>
                                            <td>{{ $order->student ? $order->student->student_id : 'N/A' }}</td>
                                            <td>{{ $order->student ? $order->student->student_name : 'N/A' }}</td>
                                            <td>{{ $order->school ? $order->school->name : ($order->student && $order->student->school ? $order->student->school->name : 'N/A') }}</td>
                                            <td>{{ $order->created_at ? $order->created_at->format('Y-m-d') : '' }}</td>
                                          
                                            <td>{{ $order->orderItems->count() }}</td>
                                            <td>
                                            
                                                <a href="{{ route('admin.student-orders.invoice', $order->id) }}" class="btn btn-sm btn-outline-info me-1" title="Invoice">
                                                    <i class="bi bi-receipt"></i> Invoice
                                                </a>
                                               
                                            </td>
                                        </tr>
                                    @empty
                                        <tr>
                                            <td colspan="8" class="text-center text-muted py-4">
                                                <i class="bi bi-info-circle"></i> No school orders found.
                                            </td>
                                        </tr>
                                    @endforelse
                                </tbody>
                            </table>
                        </div>
                        @if(method_exists($orders, 'links'))
                            <div class="d-flex justify-content-end mt-3">
                                {{ $orders->links('pagination::bootstrap-4') }}
                            </div>
                        @endif
                    </div>
                </div>
            </div>
        </div>

    </div>
</div>
@endsection