@extends('pdf._base')
@section('title', 'Statement of account — '.$user->name)
@section('body')
@include('pdf._letterhead', ['title' => 'STATEMENT', 'number' => $user->student_code, 'subtitle' => 'Statement of account · '.now()->format('d M Y')])
<div class="page" style="padding-top:18px">
  <table><tr>
    <td style="width:50%;padding-right:12px">
      <div class="lbl">Account holder</div>
      <div class="party-name">{{ $user->name }}</div>
      <div class="muted">{{ $user->email }}@if($user->phone) · {{ $user->phone }}@endif @if($user->student_code)<br>Student ID {{ $user->student_code }}@endif</div>
    </td>
    <td>
      <table class="meta">
        <tr><td class="k">Total billed</td><td class="v">{{ money2($totals['billed']) }}</td></tr>
        <tr><td class="k">Total paid</td><td class="v" style="color:#0B7A4B">{{ money2($totals['paid']) }}</td></tr>
        <tr><td class="k">Balance outstanding</td><td class="v" style="color:{{ $totals['balance'] > 0 ? '#B42318' : '#0B7A4B' }}">{{ money2($totals['balance']) }}</td></tr>
        @if($totals['overdue'] > 0)<tr><td class="k">Overdue</td><td class="v" style="color:#B42318">{{ money2($totals['overdue']) }}</td></tr>@endif
      </table>
    </td>
  </tr></table>

  <div class="section-h">Transactions</div>
  <table class="items" style="margin-top:0">
    <tr><th style="width:62px">Date</th><th style="width:118px">Reference</th><th>Description</th><th class="num" style="width:88px">Charges</th><th class="num" style="width:88px">Payments</th><th class="num" style="width:92px">Balance</th></tr>
    @php($bal = 0)
    @foreach($lines as $n => $l)
      @php($bal += $l['debit'] - $l['credit'])
      <tr class="{{ $n % 2 ? 'alt' : '' }}"><td class="nw">{{ $l['date']->format('d M Y') }}</td><td class="ink sb nw" style="font-size:8.6px">{{ $l['ref'] }}</td><td>{{ $l['desc'] }}</td><td class="num nw">{{ $l['debit'] ? money2($l['debit']) : '' }}</td><td class="num nw" style="color:#0B7A4B">{{ $l['credit'] ? money2($l['credit']) : '' }}</td><td class="num ink sb nw">{{ money2($bal) }}</td></tr>
    @endforeach
    @if(empty($lines))<tr><td colspan="6" class="c muted" style="padding:18px">No transactions yet.</td></tr>@endif
  </table>

  @foreach($plans as $plan)
    <div class="section-h">Upcoming installments · {{ $plan->code }}</div>
    <table class="items" style="margin-top:0">
      <tr><th>Installment</th><th>Due date</th><th class="num">Outstanding</th><th class="num">Status</th></tr>
      @foreach($plan->installments->filter(fn ($i) => $i->outstanding() > 0)->values() as $n => $x)
      <tr class="{{ $n % 2 ? 'alt' : '' }}"><td class="ink sb">{{ $x->label }}</td><td>{{ $x->due_date->format('d M Y') }}</td><td class="num ink sb">{{ money2($x->outstanding()) }}</td><td class="num"><span class="pill pill-{{ $x->status }}">{{ $x->statusLabel() }}</span></td></tr>
      @endforeach
    </table>
  @endforeach
  <div class="note" style="margin-top:16px">Please report any discrepancy within 7 days to {{ $brand['email'] }}. Payments made after {{ now()->format('d M Y, h:i A') }} are not reflected in this statement.</div>
</div>
@include('pdf._footer')
@endsection