@extends('backend.layout.app')

@section('content')
<div class="page-content">
    <div class="row">
        <div class="col-md-12">

            <div class="card">
                <div class="card-header bg-white d-flex justify-content-between align-items-center">
                    <h4 class="mb-0">Book Orders</h4>
                </div>

                <div class="card-body border-bottom bg-light">
                    <form action="{{ route('admin.orders.book_orders') }}" method="GET">
                        <div class="row g-3 align-items-end">
                            <div class="col-md-4">
                                <label class="form-label fw-bold text-muted small">Search</label>
                                <input type="text" name="search" class="form-control" placeholder="Order No, Name, Email..." value="{{ request('search') }}">
                            </div>
                            <div class="col-md-2">
                                <label class="form-label fw-bold text-muted small">Payment Status</label>
                                <select name="payment_status" class="form-select">
                                    <option value="">All Statuses</option>
                                    <option value="paid" {{ request('payment_status') == 'paid' ? 'selected' : '' }}>Paid</option>
                                    <option value="pending" {{ request('payment_status') == 'pending' ? 'selected' : '' }}>Pending</option>
                                    <option value="failed" {{ request('payment_status') == 'failed' ? 'selected' : '' }}>Failed</option>
                                </select>
                            </div>
                            <div class="col-md-2">
                                <label class="form-label fw-bold text-muted small">Order Status</label>
                                <select name="order_status" class="form-select">
                                    <option value="">All Statuses</option>
                                    <option value="pending" {{ request('order_status') == 'pending' ? 'selected' : '' }}>Pending</option>
                                    <option value="processing" {{ request('order_status') == 'processing' ? 'selected' : '' }}>Processing</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 fw-bold text-muted small">Date</label>
                                <input type="date" name="date" class="form-control" value="{{ request('date') }}">
                            </div>
                            <div class="col-md-2 d-flex gap-2">
                                <button type="submit" class="btn btn-primary w-100"><i class="bi bi-funnel"></i> Filter</button>
                                @if(request()->anyFilled(['search', 'payment_status', 'order_status', 'date']))
                                    <a href="{{ route('admin.orders.book_orders') }}" class="btn btn-secondary"><i class="bi bi-x"></i></a>
                                @endif
                            </div>
                        </div>
                    </form>
                </div>

                <div class="card-body">
                    <div class="table-responsive">
                        <table class="table table-striped my-table2 dataTable no-footer">
                            <thead class="thead-dark">
                                <tr>
                                    <th>#</th>
                                    <th>Transaction ID</th>
                                    <th>Order No</th>
                                    <th>Student</th>
                                    <th style="max-width: 250px">Course</th>
                                    <th>Total Amount</th>
                                    <th>Discount</th>
                                    <th>Final Amount</th>
                                    <th>Paid Amount</th>
                                    <th>Payment Method</th>
                                    <th>Payment Status</th>
                                    <th>Date</th>
                                    <th class="text-center">Action</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse ($orders as $order)
                                    <tr id="parentTr_{{ $order->id }}">
                                        <td>{{ $loop->iteration }}</td>
                                 
                                        <td>{{ $order->payments->first()?->transaction_id ?? 'N/A' }}</td>

                                        <td><strong>{{ $order->order_no }}</strong></td>

                                        <td>
                                            {{ $order->user->name ?? '-' }} <br>
                                            <small class="text-muted">{{ $order->user->email ?? '' }}</small>
                                        </td>

                                        <td style="max-width: 230px" class="text-wrap">
                                            {{ $order->enrollments->first()->course->title ?? '-' }}
                                        </td>

                                        <td>৳{{ number_format($order->subtotal, 2) }}</td>
                                        <td>৳{{ number_format($order->discount, 2) }}</td>
                                        <td>৳{{ number_format($order->total, 2) }}</td>
                                        <td>৳{{ number_format($order->payments()->where('status', 'paid')->sum('amount'), 2) }}</td>

                                        <td>{{ $order->payments->first()?->gateway ?? 'N/A' }}</td>

                                        <td>
                                            @php
                                                $status = $order->payment_status ?? 'pending';
                                                $statusClass = match($status) {
                                                    'paid' => 'bg-success',
                                                    'pending' => 'bg-warning text-dark',
                                                    'failed' => 'bg-danger',
                                                    'refunded' => 'bg-secondary',
                                                    'cancelled' => 'bg-dark',
                                                    default => 'bg-light text-muted'
                                                };
                                            @endphp
                                            <span class="badge {{ $statusClass }}">
                                                {{ ucfirst($status) }}
                                            </span>
                                        </td>

                                        <td>{{ $order->created_at->format('d M, Y') }}</td>

                                        <td class="text-center">
                                            <div class="action-btn-group">
                                                <a href="{{ route('admin.orders.show', $order->id) }}" 
                                                   class="action-btn action-btn-view" title="View Details">
                                                    <i class="bi bi-eye"></i>
                                                </a>
                                                <a href="{{ route('admin.orders.invoice', $order->order_no) }}" 
                                                   target="_blank"
                                                   class="action-btn action-btn-document" title="Print Invoice">
                                                    <i class="bi bi-printer"></i>
                                                </a>
                                                <a href="{{ route('admin.orders.edit', $order->id) }}" 
                                                   class="action-btn action-btn-edit" title="Edit Order">
                                                    <i class="bi bi-pencil-square"></i>
                                                </a>
                                                <a href="javascript:void(0)" 
                                                   class="action-btn action-btn-danger deleteButton"
                                                   data-parentid="parentTr_{{ $order->id }}"
                                                   data-url="{{ route('admin.orders.destroy', $order->id) }}"
                                                   title="Delete Order">
                                                   <i class="bi bi-trash3-fill"></i>
                                                </a>
                                            </div>
                                        </td>
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="12" class="text-center text-muted">No orders found</td>
                                    </tr>
                                @endforelse
                            </tbody>
                        </table>
                    </div>
                    <div class="d-flex justify-content-end mt-3">
                        {{ $orders->links() }}
                    </div>
                </div>

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