@extends('layouts.admin')

@section('title', 'Sales Report')
@section('page_title', 'Sales Report')

@section('content')
<!-- Report Statistics -->
<div class="row mb-4">
    <div class="col-md-3 mb-3">
        <div class="card border-0 shadow-sm">
            <div class="card-body">
                <div class="stat-card">
                    <div class="stat-number">{{ $totals['orders'] }}</div>
                    <div class="stat-label">Total Orders</div>
                </div>
            </div>
        </div>
    </div>
    <div class="col-md-3 mb-3">
        <div class="card border-0 shadow-sm">
            <div class="card-body">
                <div class="stat-card" style="border-left-color: #27ae60;">
                    <div class="stat-number">{{ \App\Support\Currency::symbol() }}{{ number_format($totals['revenue'], 2) }}</div>
                    <div class="stat-label">Total Revenue</div>
                </div>
            </div>
        </div>
    </div>
    <div class="col-md-3 mb-3">
        <div class="card border-0 shadow-sm">
            <div class="card-body">
                <div class="stat-card" style="border-left-color: #3498db;">
                    <div class="stat-number">{{ $totals['items'] }}</div>
                    <div class="stat-label">Total Items</div>
                </div>
            </div>
        </div>
    </div>
    <div class="col-md-3 mb-3">
        <div class="card border-0 shadow-sm">
            <div class="card-body">
                <div class="stat-card" style="border-left-color: #f39c12;">
                    <div class="stat-number">{{ \App\Support\Currency::symbol() }}{{ number_format($totals['revenue'] > 0 ? $totals['revenue'] / $totals['orders'] : 0, 2) }}</div>
                    <div class="stat-label">Avg Order Value</div>
                </div>
            </div>
        </div>
    </div>
</div>

<!-- Filters -->
<div class="card border-0 shadow-sm mb-4">
    <div class="card-header bg-light border-bottom">
        <h6 class="mb-0">Filter Report</h6>
    </div>
    <div class="card-body">
        <form method="GET" action="{{ route('admin.reports.sales') }}" class="row g-3">
            <div class="col-md-4">
                <label class="form-label">Start Date</label>
                <input type="date" name="start_date" class="form-control" value="{{ $startDate }}">
            </div>
            <div class="col-md-4">
                <label class="form-label">End Date</label>
                <input type="date" name="end_date" class="form-control" value="{{ $endDate }}">
            </div>
            <div class="col-md-3">
                <label class="form-label">Status</label>
                <select name="status" class="form-select">
                    <option value="">All Statuses</option>
                    <option value="pending" @if($status == 'pending') selected @endif>Pending</option>
                    <option value="processing" @if($status == 'processing') selected @endif>Processing</option>
                    <option value="shipped" @if($status == 'shipped') selected @endif>Shipped</option>
                    <option value="delivered" @if($status == 'delivered') selected @endif>Delivered</option>
                    <option value="cancelled" @if($status == 'cancelled') selected @endif>Cancelled</option>
                    <option value="refunded" @if($status == 'refunded') selected @endif>Refunded</option>
                </select>
            </div>
            <div class="col-md-1 d-flex align-items-end">
                <button type="submit" class="btn btn-primary w-100">
                    <i class="bi bi-funnel"></i> Filter
                </button>
            </div>
            <div class="col-md-3">
                <a href="{{ route('admin.reports.sales') }}" class="btn btn-outline-secondary w-100">
                    <i class="bi bi-arrow-clockwise"></i> Reset
                </a>
            </div>
            <div class="col-md-3">
                <a href="{{ route('admin.reports.export', ['start_date' => $startDate, 'end_date' => $endDate, 'status' => $status]) }}" class="btn btn-success w-100">
                    <i class="bi bi-download"></i> Export CSV
                </a>
            </div>
        </form>
    </div>
</div>

<!-- Sales Table -->
<div class="card border-0 shadow-sm">
    <div class="card-body">
        <div class="table-responsive">
            <table class="table table-hover">
                <thead class="table-light">
                    <tr>
                        <th>Order #</th>
                        <th>Customer</th>
                        <th>Email</th>
                        <th>Payment Method</th>
                        <th>Items</th>
                        <th>Total</th>
                        <th>Status</th>
                        <th>Date</th>
                        <th>Actions</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($orders as $order)
                        @php
                            $paymentMethod = $order->transactions->first()?->paymentMethod?->name ?? 'N/A';
                        @endphp
                        <tr>
                            <td>
                                <strong>{{ $order->order_number }}</strong>
                            </td>
                            <td>{{ $order->user->name }}</td>
                            <td>
                                <small>{{ $order->user->email }}</small>
                            </td>
                            <td>
                                <span class="badge bg-info">{{ $paymentMethod }}</span>
                            </td>
                            <td>
                                <span class="badge bg-light text-dark">{{ $order->items->count() }}</span>
                            </td>
                            <td>
                                <strong>{{ \App\Support\Currency::symbol() }}{{ number_format($order->total, 2) }}</strong>
                            </td>
                            <td>
                                <span class="badge 
                                    @if($order->status == 'pending') bg-warning
                                    @elseif($order->status == 'processing') bg-info
                                    @elseif($order->status == 'shipped') bg-primary
                                    @elseif($order->status == 'delivered') bg-success
                                    @elseif($order->status == 'cancelled') bg-danger
                                    @elseif($order->status == 'refunded') bg-dark
                                    @endif
                                ">
                                    {{ ucfirst($order->status) }}
                                </span>
                            </td>
                            <td>{{ $order->created_at->format('M d, Y') }}</td>
                            <td>
                                <a href="{{ route('admin.orders.show', $order) }}" class="btn btn-sm btn-outline-info">
                                    <i class="bi bi-eye"></i> View
                                </a>
                            </td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="9" class="text-center text-muted py-4">No sales data found</td>
                        </tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>
</div>

<!-- Pagination -->
@if($orders->count())
    <div class="mt-4">
        <nav aria-label="Page navigation">
            <ul class="pagination justify-content-center">
                @if ($orders->onFirstPage())
                    <li class="page-item disabled">
                        <span class="page-link">Previous</span>
                    </li>
                @else
                    <li class="page-item">
                        <a class="page-link" href="{{ $orders->previousPageUrl() }}&start_date={{ $startDate }}&end_date={{ $endDate }}&status={{ $status }}">Previous</a>
                    </li>
                @endif

                @foreach ($orders->getUrlRange(1, $orders->lastPage()) as $page => $url)
                    @if ($page == $orders->currentPage())
                        <li class="page-item active" aria-current="page">
                            <span class="page-link">{{ $page }}</span>
                        </li>
                    @else
                        <li class="page-item">
                            <a class="page-link" href="{{ $url }}&start_date={{ $startDate }}&end_date={{ $endDate }}&status={{ $status }}">{{ $page }}</a>
                        </li>
                    @endif
                @endforeach

                @if ($orders->hasMorePages())
                    <li class="page-item">
                        <a class="page-link" href="{{ $orders->nextPageUrl() }}&start_date={{ $startDate }}&end_date={{ $endDate }}&status={{ $status }}">Next</a>
                    </li>
                @else
                    <li class="page-item disabled">
                        <span class="page-link">Next</span>
                    </li>
                @endif
            </ul>
        </nav>
    </div>
@endif
@endsection