@extends('layout.mainlayout')
@section('content')
<div class="page-wrapper">
    <div class="content">
        <div class="page-header">
            <div class="page-title">
                <h4>Order Report</h4>
                <h6>Analyze order data</h6>
            </div>
        </div>

        <!-- Filter Section -->
        <div class="card">
            <div class="card-body">
                <form action="{{ route('admin.report.order') }}" method="GET" class="row g-3 align-items-end">
                    
                    <div class="col-md-2">
                        <label class="form-label">Order Number</label>
                        <input type="text" name="order_number" class="form-control" placeholder="Search..." value="{{ request('order_number') }}">
                    </div>

                    <div class="col-md-2">
                        <label class="form-label">Order Type</label>
                        <select name="order_type" class="form-select select">
                            <option value="">All Types</option>
                            <option value="DINE_IN" {{ request('order_type') == 'DINE_IN' ? 'selected' : '' }}>Dine In</option>
                            <option value="TAKEAWAY" {{ request('order_type') == 'TAKEAWAY' ? 'selected' : '' }}>Takeaway</option>
                            <option value="DELIVERY" {{ request('order_type') == 'DELIVERY' ? 'selected' : '' }}>Delivery</option>
                        </select>
                    </div>

                    <div class="col-md-2">
                        <label class="form-label">Order Status</label>
                        <select name="order_status" class="form-select select">
                            <option value="">All Statuses</option>
                            <option value="PENDING" {{ request('order_status') == 'PENDING' ? 'selected' : '' }}>Pending</option>
                            <option value="COOKING" {{ request('order_status') == 'COOKING' ? 'selected' : '' }}>Cooking</option>
                            <option value="READY" {{ request('order_status') == 'READY' ? 'selected' : '' }}>Ready</option>
                            <option value="COMPLETED" {{ request('order_status') == 'COMPLETED' ? 'selected' : '' }}>Completed</option>
                            <option value="CANCELLED" {{ request('order_status') == 'CANCELLED' ? 'selected' : '' }}>Cancelled</option>
                        </select>
                    </div>

                    <div class="col-md-2">
                        <label class="form-label">Payment</label>
                        <select name="payment_status" class="form-select select">
                            <option value="">All Payments</option>
                            <option value="UNPAID" {{ request('payment_status') == 'UNPAID' ? 'selected' : '' }}>Unpaid</option>
                            <option value="PARTIAL" {{ request('payment_status') == 'PARTIAL' ? 'selected' : '' }}>Partial</option>
                            <option value="PAID" {{ request('payment_status') == 'PAID' ? 'selected' : '' }}>Paid</option>
                        </select>
                    </div>

                    <div class="col-md-2">
                        <label class="form-label">From Date</label>
                        <input type="date" name="from_date" class="form-control" value="{{ request('from_date') }}">
                    </div>

                    <div class="col-md-2">
                        <label class="form-label">To Date</label>
                        <input type="date" name="to_date" class="form-control" value="{{ request('to_date') }}">
                    </div>

                    <div class="col-md-12 text-end mt-3">
                        <button type="submit" class="btn btn-primary me-2">
                            <i data-feather="filter"></i> Filter
                        </button>
                        <a href="{{ route('admin.report.order') }}" class="btn btn-secondary">Clear</a>
                    </div>
                </form>

                <hr class="my-4">

                <!-- Export Buttons -->
                <div class="d-flex justify-content-end mb-3 gap-2">
                    <form action="{{ route('admin.report.order.export') }}" method="POST" target="_blank">
                        @csrf
                        <input type="hidden" name="order_number" value="{{ request('order_number') }}">
                        <input type="hidden" name="order_type" value="{{ request('order_type') }}">
                        <input type="hidden" name="order_status" value="{{ request('order_status') }}">
                        <input type="hidden" name="payment_status" value="{{ request('payment_status') }}">
                        <input type="hidden" name="from_date" value="{{ request('from_date') }}">
                        <input type="hidden" name="to_date" value="{{ request('to_date') }}">
                        
                        <input type="hidden" name="export_type" value="pdf">
                        <button type="submit" class="btn btn-danger btn-sm">
                            <i data-feather="file-text"></i> Export PDF
                        </button>
                    </form>

                    <form action="{{ route('admin.report.order.export') }}" method="POST">
                        @csrf
                        <input type="hidden" name="order_number" value="{{ request('order_number') }}">
                        <input type="hidden" name="order_type" value="{{ request('order_type') }}">
                        <input type="hidden" name="order_status" value="{{ request('order_status') }}">
                        <input type="hidden" name="payment_status" value="{{ request('payment_status') }}">
                        <input type="hidden" name="from_date" value="{{ request('from_date') }}">
                        <input type="hidden" name="to_date" value="{{ request('to_date') }}">
                        
                        <input type="hidden" name="export_type" value="excel">
                        <button type="submit" class="btn btn-success btn-sm">
                            <i data-feather="grid"></i> Export Excel
                        </button>
                    </form>
                </div>

            </div>
        </div>

        <!-- Data Table -->
        <div class="card">
            <div class="card-body">
                <div class="table-responsive">
                    <table class="table datatable">
                        <thead>
                            <tr>
                                <th>Order #</th>
                                <th>Type</th>
                                <th>Total (Tsh)</th>
                                <th>Cashier</th>
                                <th>Status</th>
                                <th>Payment</th>
                                <th>Date</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($orders as $o)
                            <tr>
                                <td class="fw-semibold">{{ $o->order_number }}</td>
                                <td>{{ str_replace('_', ' ', $o->order_type) }}</td>
                                <td>{{ number_format($o->total_amount, 2) }}</td>
                                <td>{{ $o->cashier_name ?? 'N/A' }}</td>
                                <td>
                                    @if($o->order_status === 'COMPLETED')
                                        <span class="badges bg-lightgreen">Completed</span>
                                    @elseif($o->order_status === 'CANCELLED')
                                        <span class="badges bg-lightred">Cancelled</span>
                                    @elseif(in_array($o->order_status, ['COOKING', 'READY']))
                                        <span class="badges bg-lightyellow">{{ ucfirst(strtolower($o->order_status)) }}</span>
                                    @else
                                        <span class="badges bg-lightgray">Pending</span>
                                    @endif
                                </td>
                                <td>
                                    @if($o->payment_status === 'PAID')
                                        <span class="badges bg-lightgreen">Paid</span>
                                    @elseif($o->payment_status === 'PARTIAL')
                                        <span class="badges bg-lightyellow">Partial</span>
                                    @else
                                        <span class="badges bg-lightred">Unpaid</span>
                                    @endif
                                </td>
                                <td>{{ \Carbon\Carbon::parse($o->created_at)->format('d M Y, H:i') }}</td>
                            </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>

    </div>
</div>
@endsection