@extends('layout')

@section('page_title', 'Reports')

@section('content')
  <div class="header-actions">
    <h2>Business Reports</h2>
    <div class="spacer"></div>
    <a class="btn btn-secondary" href="{{ route('admin.dashboard') }}">Back to Dashboard</a>
  </div>

  <div class="grid">
    <div class="card stat-card variant-slate" style="grid-column: span 3;">
      <div class="stat-title">Customers</div>
      <div class="stat-value">{{ $metrics['customers_total'] }}</div>
    </div>
    <div class="card stat-card variant-blue" style="grid-column: span 3;">
      <div class="stat-title">Agreements</div>
      <div class="stat-value">{{ $metrics['agreements_total'] }}</div>
    </div>
    <div class="card stat-card variant-green" style="grid-column: span 3;">
      <div class="stat-title">Payments (Paid)</div>
      <div class="stat-value">{{ $metrics['payments_paid_count'] }}</div>
      <div class="text-muted">Amount: {{ $currency }}{{ number_format($metrics['paid_amount_sum'], 2) }}</div>
    </div>
    <div class="card stat-card variant-amber" style="grid-column: span 3;">
      <div class="stat-title">Payments (Pending)</div>
      <div class="stat-value">{{ $metrics['payments_unpaid_count'] }}</div>
      <div class="text-muted">Outstanding: {{ $currency }}{{ number_format($metrics['outstanding_amount_sum'], 2) }}</div>
    </div>
  </div>

  <div class="grid" style="margin-top: 24px;">
    <div class="card" style="grid-column: span 6;">
      <div class="card-header"><h3>Recent Payments</h3></div>
      @if($recentPayments->isEmpty())
        <p class="text-muted">No payment activity yet.</p>
      @else
        <div class="table-responsive">
          <table class="table table-striped">
            <thead>
              <tr>
                <th>Agreement</th>
                <th>Customer</th>
                <th>Product</th>
                <th>Due Date</th>
                <th>Amount</th>
                <th>Status</th>
              </tr>
            </thead>
            <tbody>
              @foreach($recentPayments as $p)
                <tr>
                  <td>#{{ $p->agreement_id }}</td>
                  <td>{{ optional($p->agreement->customer)->name ?? '—' }}</td>
                  <td>{{ optional($p->agreement->product)->name ?? '—' }}</td>
                  <td>{{ optional($p->due_date)->format('M d, Y') }}</td>
                  <td>{{ $currency }}{{ number_format($p->amount, 2) }}</td>
                  <td>{{ $p->paid_at ? 'Paid' : 'Pending' }}</td>
                </tr>
              @endforeach
            </tbody>
          </table>
        </div>
      @endif
    </div>

    <div class="card" style="grid-column: span 6;">
      <div class="card-header"><h3>Recent Instalments</h3></div>
      @if($recentAgreements->isEmpty())
        <p class="text-muted">No agreements created yet.</p>
      @else
        <div class="table-responsive">
          <table class="table table-striped">
            <thead>
              <tr>
                <th>ID</th>
                <th>Customer</th>
                <th>Product</th>
                <th>Total</th>
                <th>Instalments</th>
                <th>Status</th>
              </tr>
            </thead>
            <tbody>
              @foreach($recentAgreements as $a)
                <tr>
                  <td>{{ $a->id }}</td>
                  <td>{{ optional($a->customer)->name ?? $a->customer_name }}</td>
                  <td>{{ optional($a->product)->name ?? '—' }}</td>
                  <td>{{ number_format($a->total_amount, 2) }}</td>
                  <td>{{ $a->instalments_count }}</td>
                  <td>{{ $a->status }}</td>
                </tr>
              @endforeach
            </tbody>
          </table>
        </div>
      @endif
    </div>
  </div>
@endsection