@extends('layouts.portal')
@section('title', 'Finance overview')
@section('subtitle', 'Invoiced, collected, outstanding and overdue — with installments, revenue mix and learner balances.')
@section('actions')
  <a class="btn btn-secondary" href="{{ route('admin.finance.balances') }}"><x-icon name="download" :size="16"/> Export balances (CSV)</a>
  <a class="btn btn-primary" href="{{ route('admin.plans.create') }}"><x-icon name="plus" :size="16"/> New payment plan</a>
@endsection
@section('content')
<form class="filters" method="get" aria-label="Period">
  <label class="small muted" for="f-from">From</label><input class="input" style="max-width:170px" type="date" id="f-from" name="from" value="{{ $from->toDateString() }}">
  <label class="small muted" for="f-to">To</label><input class="input" style="max-width:170px" type="date" id="f-to" name="to" value="{{ $to->toDateString() }}">
  <button class="btn btn-secondary" type="submit">Apply</button>
  <a class="btn btn-ghost" href="{{ route('admin.finance.index') }}">Last 12 months</a>
</form>

<div class="op-kpis">
  <div class="op-kpi dark"><span>Total invoiced</span><b>{{ money($kpis['invoiced']) }}</b><small>{{ $from->format('d M Y') }} – {{ $to->format('d M Y') }}</small></div>
  <div class="op-kpi green"><span>Total collected</span><b>{{ money($kpis['collected']) }}</b><small>{{ $kpis['collection_rate'] !== null ? $kpis['collection_rate'].'% collection rate' : 'verified payments' }}</small></div>
  <div class="op-kpi amber"><span>Outstanding</span><b>{{ money($kpis['outstanding']) }}</b><small>open invoices, all time</small></div>
  <div class="op-kpi red"><span>Overdue</span><b>{{ money($kpis['overdue']) }}</b><small>past due installments &amp; invoices</small></div>
  <div class="op-kpi"><span>Due in 30 days</span><b>{{ money($kpis['upcoming_30']) }}</b><small>upcoming installments</small></div>
  <div class="op-kpi violet"><span>Active plans</span><b>{{ number_format($kpis['plans_active']) }}</b><small>installment plans running</small></div>
  <div class="op-kpi"><span>Waived</span><b>{{ money($kpis['waived']) }}</b><small>authorised waivers in period</small></div>
  <div class="op-kpi"><span>Refunded</span><b>{{ money($kpis['refunded']) }}</b><small>reversed payments in period</small></div>
</div>

<div class="op-grid-2">
  <section class="panel"><div class="panel-head"><h2>Revenue by month</h2><span class="ac-hint">collected</span></div>
    <div class="panel-body">@include('partials.charts.bars', ['data' => $byMonth, 'height' => 210, 'format' => 'money', 'title' => 'Revenue by month'])</div></section>
  <section class="panel"><div class="panel-head"><h2>Revenue by course</h2><span class="ac-hint">top 10</span></div>
    <div class="panel-body">@include('partials.charts.donut', ['data' => $byCourse, 'size' => 160, 'format' => 'money', 'title' => 'Revenue by course', 'center' => 'Collected'])</div></section>
</div>

<div class="op-grid-2 mt-3">
  <section class="panel"><div class="panel-head"><h2>Installment status</h2><a class="ac-hint" href="{{ route('admin.plans.index') }}">All plans →</a></div>
    <div class="table-wrap" style="border:0;box-shadow:none"><table class="table ac-t">
      <thead><tr><th>Status</th><th class="num">Installments</th><th class="num">Amount</th><th class="num">Outstanding</th></tr></thead>
      <tbody>
      @forelse(collect(\App\Models\Installment::STATUSES)->keys()->filter(fn ($k) => isset($instStatus[$k])) as $k)
        <tr><td><x-pill :status="$k"/></td><td class="num">{{ $instStatus[$k]['count'] }}</td><td class="num ac-money">{{ money2($instStatus[$k]['amount']) }}</td><td class="num ac-money">{{ money2($instStatus[$k]['outstanding']) }}</td></tr>
      @empty
        <tr><td colspan="4" class="op-empty">No installment plans yet.</td></tr>
      @endforelse
      </tbody></table></div></section>
  <section class="panel"><div class="panel-head"><h2>Payment methods</h2><span class="ac-hint">collected in period</span></div>
    <div class="panel-body">@include('partials.charts.donut', ['data' => $methods, 'size' => 150, 'format' => 'money', 'title' => 'Payment methods', 'center' => 'Methods'])</div></section>
</div>

<div class="op-stack mt-3">
  <section class="panel"><div class="panel-head"><h2>Overdue installments</h2><span class="op-chip red">{{ $overdue->count() }}</span></div>
    @include('admin.finance._inst', ['rows' => $overdue, 'empty' => 'Nothing is overdue — great collection!'])</section>
  <section class="panel"><div class="panel-head"><h2>Upcoming payments</h2><span class="op-chip blue">next 10</span></div>
    @include('admin.finance._inst', ['rows' => $upcoming, 'empty' => 'No upcoming installments.'])</section>
</div>

<section class="panel mt-3"><div class="panel-head"><h2>Revenue by batch</h2><span class="ac-hint">collected in period</span></div>
  <div class="table-wrap" style="border:0;box-shadow:none"><table class="table ac-t">
    <thead><tr><th>Batch</th><th>Course</th><th class="num">Paying learners</th><th class="num">Collected</th></tr></thead>
    <tbody>
    @forelse($byBatch as $b)
      <tr><td><a class="ac-num" href="{{ route('admin.batches.show', $b->id) }}">{{ $b->batch_code }}</a></td><td>{{ $b->title }}</td><td class="num">{{ $b->learners }}</td><td class="num ac-money">{{ money2($b->collected) }}</td></tr>
    @empty
      <tr><td colspan="4" class="op-empty">No batch revenue in this period.</td></tr>
    @endforelse
    </tbody></table></div></section>

<section class="panel mt-3"><div class="panel-head"><h2>Student balances</h2><a class="ac-hint" href="{{ route('admin.finance.balances') }}">Download all (CSV)</a></div>
  <div class="table-wrap" style="border:0;box-shadow:none"><table class="table ac-t">
    <thead><tr><th>Learner</th><th>Plan</th><th class="num">Total</th><th class="num">Paid</th><th class="num">Remaining</th><th class="num">Overdue</th><th>Next due</th><th class="actions"></th></tr></thead>
    <tbody>
    @forelse($balances as $r)
      @php($p = $r['plan'])
      <tr class="{{ $r['overdue'] > 0 ? 'ac-overdue' : '' }}">
        <td><b>{{ $p->customer_name }}</b><span class="ac-sub">{{ $p->course?->title }}</span></td>
        <td><a class="ac-num" href="{{ route('admin.plans.show', $p) }}">{{ $p->code }}</a></td>
        <td class="num ac-money">{{ money2($p->total) }}</td>
        <td class="num ac-money">{{ money2($p->paidAmount()) }}</td>
        <td class="num ac-money">{{ money2($r['remaining']) }}</td>
        <td class="num ac-money {{ $r['overdue'] > 0 ? 'ac-late' : 'muted' }}">{{ money2($r['overdue']) }}</td>
        <td>@if($r['next']){{ $r['next']->due_date->format('d M Y') }}<span class="ac-sub">{{ money2($r['next']->outstanding()) }}</span>@else — @endif</td>
        <td class="actions"><a class="icon-btn" href="{{ route('admin.plans.show', $p) }}" aria-label="Open plan"><x-icon name="eye" :size="16"/></a></td>
      </tr>
    @empty
      <tr><td colspan="8" class="op-empty">No active payment plans.</td></tr>
    @endforelse
    </tbody></table></div></section>
@endsection