{{-- resources/views/reports/invoice-aging.blade.php --}}
@extends('layouts.app')
@section('title', 'Invoice Aging')
@section('page_title', 'Invoice Aging Report')
@section('page_subtitle', 'Outstanding invoices by age')

@section('content')

@include('reports.partials.nav')

{{-- Total --}}
<div class="row g-3 mb-3">
    <div class="col-md-4">
        <div class="stat-card">
            <div class="stat-icon si-warning">
                <i class="bi bi-clock-history"></i>
            </div>
            <div>
                <div class="stat-value">
                    ${{ number_format($total, 0) }}
                </div>
                <div class="stat-label">Total Outstanding</div>
            </div>
        </div>
    </div>
    @foreach(['0_30' => 'si-warning', '61_90' => 'si-danger', 'over_90' => 'si-danger'] as $key => $icon)
        <div class="col-md-4">
            <div class="stat-card">
                <div class="stat-icon {{ $icon }}">
                    <i class="bi bi-exclamation-circle"></i>
                </div>
                <div>
                    <div class="stat-value">
                        ${{ number_format($buckets[$key]['total'], 0) }}
                    </div>
                    <div class="stat-label">{{ $buckets[$key]['label'] }}</div>
                </div>
            </div>
        </div>
    @endforeach
</div>

{{-- Buckets --}}
@foreach($buckets as $key => $bucket)
    @if($bucket['invoices']->count() > 0)
        <div class="card mb-3">
            <div class="card-header">
                <span class="card-title">
                    {{ $bucket['label'] }}
                    <span style="font-size:.75rem;font-weight:400;
                                 color:var(--muted);margin-left:6px;">
                        {{ $bucket['invoices']->count() }}
                        {{ Str::plural('invoice', $bucket['invoices']->count()) }}
                    </span>
                </span>
                <span style="font-weight:700;font-size:.88rem;
                             color:{{ $key === 'current' ? 'var(--success)' : 'var(--danger)' }};">
                    ${{ number_format($bucket['total'], 2) }}
                </span>
            </div>
            <div class="table-responsive">
                <table class="table">
                    <thead>
                        <tr>
                            <th>Invoice #</th>
                            <th>Guest / Company</th>
                            <th>Invoice Date</th>
                            <th>Due Date</th>
                            <th>Total</th>
                            <th>Balance</th>
                            <th></th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($bucket['invoices'] as $inv)
                            <tr>
                                <td style="font-size:.8rem;font-weight:600;
                                           color:var(--clay);">
                                    {{ $inv->invoice_number }}
                                </td>
                                <td style="font-size:.82rem;">
                                    @if($inv->guest)
                                        {{ $inv->guest->first_name }}
                                        {{ $inv->guest->last_name }}
                                    @elseif($inv->company)
                                        {{ $inv->company->name }}
                                    @else
                                        —
                                    @endif
                                </td>
                                <td style="font-size:.78rem;white-space:nowrap;">
                                    {{ $inv->invoice_date->format('d M Y') }}
                                </td>
                                <td style="font-size:.78rem;white-space:nowrap;
                                           {{ $key !== 'current' ? 'color:var(--danger);font-weight:600;' : '' }}">
                                    {{ $inv->due_date->format('d M Y') }}
                                    @if($key !== 'current')
                                        <br>
                                        <span style="font-size:.68rem;">
                                            {{ $inv->due_date->diffForHumans() }}
                                        </span>
                                    @endif
                                </td>
                                <td style="font-size:.8rem;font-weight:600;">
                                    {{ $inv->currency }}
                                    {{ number_format($inv->total_amount, 2) }}
                                </td>
                                <td style="font-size:.82rem;font-weight:700;
                                           color:var(--danger);">
                                    {{ $inv->currency }}
                                    {{ number_format($inv->balance_due, 2) }}
                                </td>
                                <td>
                                    <a href="{{ tenant_route('invoicing.invoices.show', ['invoice' => $inv->id]) }}"
                                       class="btn btn-xs btn-outline-secondary">
                                        View →
                                    </a>
                                </td>
                            </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    @endif
@endforeach

@if($total === 0.0 || $total === 0)
    <div class="card">
        <div class="card-body text-center py-5">
            <i class="bi bi-check-circle"
               style="font-size:2.5rem;color:var(--success)"></i>
            <p class="fw-semibold mt-3 mb-0">All invoices are settled!</p>
            <p class="text-muted" style="font-size:.8rem;">No outstanding balances.</p>
        </div>
    </div>
@endif

@endsection