{{-- resources/views/accounting/ar/aging.blade.php --}}
@extends('admin.admin_dashboard')
@section('admin')

<div class="page-content">
  {{-- Breadcrumb & PDF export --}}
  <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">
          AR Aging Report
        </li>
      </ol>
    </nav>

    @if(Auth::user() && Auth::user()->can('reports.export'))
      <a href="{{ route('ar.aging.pdf') }}" 
         class="btn btn-light d-flex align-items-center">
        <i class="bx bx-file-pdf me-2"></i> Download PDF
      </a>
    @endif
  </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>Party</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)
              @php
                $tot['current'] += $r->current;
                $tot['b1']      += $r->b1;
                $tot['b2']      += $r->b2;
                $tot['b3']      += $r->b3;
                $tot['b4']      += $r->b4;
                $tot['total']   += $r->total;
              @endphp
              <tr>
                <td>{{ $i + 1 }}</td>
                <td>{{ $r->party }}</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 fw-bold">{{ 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