@extends('admin.admin_dashboard')
@section('admin')

<div class="page-content">
  <!-- Breadcrumb & PDF button -->
  <div class="page-breadcrumb d-flex flex-column flex-sm-row 
              align-items-center justify-content-between mb-3 p-3 
              bg-primary text-white rounded shadow-sm">
    <nav aria-label="breadcrumb">
      <ol class="breadcrumb mb-0 p-0">
        <li class="breadcrumb-item">
          <a href="{{ route('admin.dashboard') }}" class="text-white">
            <i class="bx bx-home-alt"></i>
          </a>
        </li>
        <li class="breadcrumb-item active text-white" aria-current="page">
          AP Aging Report
        </li>
      </ol>
    </nav>
    <a href="{{ route('ap.aging.pdf') }}" class="btn btn-light d-flex align-items-center">
      <i class="bx bx-file-pdf me-2"></i> Download PDF
    </a>
  </div>

  <div class="card shadow-sm border-0 rounded">
    <div class="card-body p-4">
      <div class="table-responsive">
        <table class="table table-hover table-striped table-bordered align-middle">
          <thead class="table-dark">
            <tr>
              <th>#</th>
              <th>Vendor</th>
              <th>Ref</th>
              <th>Due Date</th>
              <th class="text-end">Current</th>
              <th class="text-end">1–30</th>
              <th class="text-end">31–60</th>
              <th class="text-end">61–90</th>
              <th class="text-end">&gt;90</th>
              <th class="text-end">Total</th>
            </tr>
          </thead>
          <tbody>
            @php
              $tot = ['current'=>0,'b1'=>0,'b2'=>0,'b3'=>0,'b4'=>0,'total'=>0];
            @endphp

            @foreach($rows as $i => $r)
              @foreach(['current','b1','b2','b3','b4','total'] as $k)
                @php $tot[$k] += $r->$k; @endphp
              @endforeach
              <tr>
                <td>{{ $i+1 }}</td>
                <td>{{ $r->vendor }}</td>
                <td>{{ $r->reference }}</td>
                <td>{{ $r->due_date }}</td>
                <td class="text-end">{{ number_format($r->current,2) }}</td>
                <td class="text-end">{{ number_format($r->b1,2) }}</td>
                <td class="text-end">{{ number_format($r->b2,2) }}</td>
                <td class="text-end">{{ number_format($r->b3,2) }}</td>
                <td class="text-end">{{ number_format($r->b4,2) }}</td>
                <td class="text-end">{{ number_format($r->total,2) }}</td>
              </tr>
            @endforeach
          </tbody>
          <tfoot class="table-secondary fw-bold">
            <tr>
              <td colspan="4" class="text-end">Grand Total</td>
              <td class="text-end">{{ number_format($tot['current'],2) }}</td>
              <td class="text-end">{{ number_format($tot['b1'],2) }}</td>
              <td class="text-end">{{ number_format($tot['b2'],2) }}</td>
              <td class="text-end">{{ number_format($tot['b3'],2) }}</td>
              <td class="text-end">{{ number_format($tot['b4'],2) }}</td>
              <td class="text-end">{{ number_format($tot['total'],2) }}</td>
            </tr>
          </tfoot>
        </table>
      </div>
    </div>
  </div>
</div>

@endsection