@extends('admin.layout.app')

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

@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">Sales Report</h2>
            </div>
        </div>

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

        <div class="row">
            <div class="col-12">
                <div class="card shadow-sm border-0 mt-4">
                    <div class="card-header bg-primary text-white">
                        <h5 class="mb-0 fw-bold">Orders Table</h5>
                    </div>
                    <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:12%;">Order Number</th>
                                        <th>Customer</th>
                                        <th style="width:10%;">Items</th>
                                        <th style="width:12%;">Total</th>
                                        <th style="width:10%;">Payment Method</th>
                                        <th style="width:12%;">Order Status</th>
                                        <th style="width:10%;">Date</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @forelse ($sales_reports as $key => $report)
                                        <tr>
                                            <td>{{ ($sales_reports->firstItem() ?? 0) + $key + 1 }}</td>
                                            <td>
                                                <strong class="text-primary">{{ $report->order_number }}</strong>
                                            </td>
                                            <td class="text-start">
                                                <strong>{{ $report->customer_name ?? 'N/A' }}</strong><br>
                                                <small class="text-muted">{{ $report->customer_email ?? 'N/A' }}</small>
                                            </td>
                                            <td>
                                                <span class="badge bg-secondary">{{ $report->items_count ?? 0 }} item(s)</span>
                                            </td>
                                            <td>
                                                <strong>₹{{ number_format($report->total_amount, 2) }}</strong>
                                            </td>
                                            <td>
                                                {{ ucfirst($report->payment_method ?? '-') }}
                                            </td>
                                            <td>
                                                @php
                                                    $statusColors = [
                                                        'pending' => 'warning',
                                                        'confirmed' => 'info',
                                                        'processing' => 'primary',
                                                        'shipped' => 'success',
                                                        'delivered' => 'success',
                                                        'cancelled' => 'danger'
                                                    ];
                                                    $color = $statusColors[$report->order_status] ?? 'secondary';
                                                @endphp
                                                <span class="badge bg-{{ $color }}">{{ ucfirst($report->order_status ?? '-') }}</span>
                                            </td>
                                            <td>
                                                <small>{{ \Carbon\Carbon::parse($report->created_at)->format('d M Y') }}</small><br>
                                                <small class="text-muted">{{ \Carbon\Carbon::parse($report->created_at)->format('h:i A') }}</small>
                                            </td>
                                        </tr>
                                    @empty
                                        <tr>
                                            <td colspan="8" class="text-center text-muted py-4">
                                                <i class="bi bi-inbox"></i> No sales records found.
                                            </td>
                                        </tr>
                                    @endforelse
                                </tbody>
                                @if($sales_reports->count())
                                    <tfoot class="table-light">
                                        <tr>
                                            <th colspan="4" class="text-end">Totals:</th>
                                            <th><strong>₹{{ number_format($totals['total_amount'] ?? 0, 2) }}</strong></th>
                                            <th colspan="3"></th>
                                        </tr>
                                    </tfoot>
                                @endif
                            </table>
                        </div>
                        @if($sales_reports instanceof \Illuminate\Pagination\LengthAwarePaginator && $sales_reports->hasPages())
                            <div class="d-flex justify-content-end mt-3">
                                {{ $sales_reports->links('pagination::bootstrap-4') }}
                            </div>
                        @endif
                    </div>
                </div>
            </div>
        </div>

    </div>
</div>
@endsection