@extends('layouts.layout-admin')

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

@section('header_title', 'Sales Report')
@section('header_subtitle', 'View sales report by date range')

@section('content')
    <div class="container-fluid">
        <!-- Date Filter -->
        <div class="card shadow mb-4">
            <div class="card-body">
                <form action="{{ route('admin.reports.sales') }}" method="GET" class="row g-3 align-items-end">
                    <div class="col-md-3">
                        <label class="form-label">Start Date</label>
                        <input type="date" name="start_date" class="form-control" value="{{ $startDate }}">
                    </div>
                    <div class="col-md-3">
                        <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">&nbsp;</label>
                        <button type="submit" class="btn btn-primary w-100">Filter</button>
                    </div>
                    <div class="col-md-3">
                        <label class="form-label">&nbsp;</label>
                        <div class="d-flex gap-1">
                            <a href="{{ route('admin.reports.sales', ['start_date' => now()->format('Y-m-d'), 'end_date' => now()->format('Y-m-d')]) }}"
                                class="btn btn-sm {{ $startDate === now()->format('Y-m-d') ? 'btn-success' : 'btn-outline-success' }} flex-fill">Hari Ini</a>
                            <a href="{{ route('admin.reports.sales', ['start_date' => now()->subDays(6)->format('Y-m-d'), 'end_date' => now()->format('Y-m-d')]) }}"
                                class="btn btn-sm btn-outline-success flex-fill">7 Hari</a>
                            <a href="{{ route('admin.reports.sales', ['start_date' => now()->startOfMonth()->format('Y-m-d'), 'end_date' => now()->format('Y-m-d')]) }}"
                                class="btn btn-sm {{ $startDate === now()->startOfMonth()->format('Y-m-d') ? 'btn-success' : 'btn-outline-success' }} flex-fill">Bulan Ini</a>
                        </div>
                    </div>
                </form>
            </div>
        </div>

        <!-- Summary Cards -->
        <div class="row mb-4">
            <div class="col-md-6">
                <div class="card shadow bg-primary text-white">
                    <div class="card-body">
                        <h5 class="card-title">Total Orders</h5>
                        <h2 class="mb-0">{{ $summary->total_orders ?? 0 }}</h2>
                    </div>
                </div>
            </div>
            <div class="col-md-6">
                <div class="card shadow bg-success text-white">
                    <div class="card-body">
                        <h5 class="card-title">Total Revenue</h5>
                        <h2 class="mb-0">Rp {{ number_format($summary->total_revenue ?? 0, 0, ',', '.') }}</h2>
                    </div>
                </div>
            </div>
        </div>

        <!-- Top Products -->
        <div class="card shadow mb-4">
            <div class="card-header">
                <h5 class="mb-0">Top 10 Products</h5>
            </div>
            <div class="card-body">
                <div class="table-responsive">
                    <table class="table table-hover">
                        <thead>
                            <tr>
                                <th>Product</th>
                                <th>Total Qty Sold</th>
                                <th>Total Sales</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($topProducts as $item)
                                <tr>
                                    <td>{{ $item->product->name ?? 'Deleted' }}</td>
                                    <td>{{ $item->total_qty }}</td>
                                    <td>Rp {{ number_format($item->total_sales, 0, ',', '.') }}</td>
                                </tr>
                            @empty
                                <tr>
                                    <td colspan="3" class="text-center py-4">
                                        <p class="text-muted">No products sold in this period</p>
                                    </td>
                                </tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        </div>

        <!-- Orders List -->
        <div class="card shadow">
            <div class="card-header">
                <h5 class="mb-0">Orders ({{ $startDate }} - {{ $endDate }})</h5>
            </div>
            <div class="card-body">
                <div class="table-responsive">
                    <table class="table table-hover">
                        <thead>
                            <tr>
                                <th>Order Code</th>
                                <th>Customer</th>
                                <th>Items</th>
                                <th>Total</th>
                                <th>Payment</th>
                                <th>Status</th>
                                <th>Date</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($orders as $order)
                                <tr>
                                    <td>{{ $order->order_code }}</td>
                                    <td>{{ $order->user->name }}</td>
                                    <td>
                                        @foreach ($order->items as $item)
                                            <div>{{ $item->product->name }} x {{ $item->quantity }}</div>
                                        @endforeach
                                    </td>
                                    <td>Rp {{ number_format($order->total_amount, 0, ',', '.') }}</td>
                                    <td>{{ $order->payment_method ?? '-' }}</td>
                                    <td><span class="badge bg-{{ $order->status_color }}">{{ $order->status }}</span></td>
                                    <td>{{ $order->created_at->format('d/m/Y H:i') }}</td>
                                </tr>
                            @empty
                                <tr>
                                    <td colspan="7" class="text-center py-4">
                                        <p class="text-muted">No orders found in this period</p>
                                    </td>
                                </tr>
                            @endforelse
                        </tbody>
                    </table>
                    <div class="mt-4">{{ $orders->links() }}</div>
                </div>
            </div>
        </div>
    </div>
@endsection