@extends('layouts.portal')
@section('title', 'Analytics')
@section('subtitle', 'Revenue, enrollments, exam results, sales pipeline and attendance for the last '.$span.' months.')
@section('actions')
  <form method="get" class="filters" style="margin:0" aria-label="Reporting period">
    <label class="sr-only" for="months">Reporting period</label>
    <select class="select" id="months" name="months" data-autosubmit>
      @foreach([3 => 'Last 3 months', 6 => 'Last 6 months', 12 => 'Last 12 months', 24 => 'Last 24 months'] as $v => $l)<option value="{{ $v }}" @selected($span === $v)>{{ $l }}</option>@endforeach
    </select>
    <noscript><button class="btn btn-secondary btn-sm" type="submit">Apply</button></noscript>
  </form>
@endsection

@section('content')
@php
  $series = fn (array $values) => collect($labels)->map(fn ($l, $i) => ['label' => $l, 'value' => $values[$i] ?? 0])->all();
  $periodRevenue = array_sum($revenueSeries);
  $periodEnrol = array_sum($enrollSeries);
  $funnelOrder = ['new' => 'New', 'contacted' => 'Contacted', 'qualified' => 'Qualified', 'converted' => 'Converted', 'lost' => 'Lost'];
  $funnelTotal = max(1, array_sum($leadFunnel));
  $methodLabel = fn ($m) => ucwords(str_replace('_', ' ', (string) ($m ?: 'other')));
  $attTotal = array_sum($attStatus);
  $attOverall = $attTotal - ($attStatus['excused'] ?? 0) > 0 ? round((($attStatus['present'] ?? 0) + ($attStatus['late'] ?? 0)) / ($attTotal - ($attStatus['excused'] ?? 0)) * 100, 1) : null;
@endphp

<div class="kpis ad-kpis">
  <div class="card kpi violet"><span class="ico"><x-icon name="trending-up" :size="22"/></span><span>Revenue, {{ $span }} months</span><b>{{ money($periodRevenue) }}</b><small>{{ money($totals['revenue']) }} collected all time</small></div>
  <div class="card kpi green"><span class="ico"><x-icon name="clipboard-check" :size="22"/></span><span>New enrollments</span><b>{{ number_format($periodEnrol) }}</b><small>in the last {{ $span }} months</small></div>
  <div class="card kpi"><span class="ico"><x-icon name="users" :size="22"/></span><span>Learners</span><b>{{ number_format($totals['learners']) }}</b><small>{{ number_format(array_sum($learnerSeries)) }} joined in this period</small></div>
  <div class="card kpi amber"><span class="ico"><x-icon name="award" :size="22"/></span><span>Certificates issued</span><b>{{ number_format($totals['credentials']) }}</b><small>{{ number_format($totals['attempts']) }} exam attempts finished</small></div>
</div>

<div class="ad-two">
  <section class="panel">
    <div class="panel-head"><h2>Revenue by month</h2><span class="xs muted">Confirmed payments</span></div>
    <div class="panel-body">@include('partials.charts.bars', ['data' => $series($revenueSeries), 'height' => 220, 'format' => 'money', 'title' => 'Confirmed revenue per month', 'values' => false])</div>
  </section>
  <section class="panel">
    <div class="panel-head"><h2>Enrollments by month</h2><span class="xs muted">All statuses</span></div>
    <div class="panel-body">@include('partials.charts.line', ['data' => $series($enrollSeries), 'height' => 220, 'format' => 'int', 'title' => 'New enrollments per month'])</div>
  </section>
  <section class="panel">
    <div class="panel-head"><h2>New learner accounts</h2></div>
    <div class="panel-body">@include('partials.charts.line', ['data' => $series($learnerSeries), 'height' => 170, 'format' => 'int', 'title' => 'New learner accounts per month'])</div>
  </section>
  <section class="panel">
    <div class="panel-head"><h2>Certificates issued</h2></div>
    <div class="panel-body">@include('partials.charts.bars', ['data' => $series($credSeries), 'height' => 170, 'format' => 'int', 'title' => 'Certificates issued per month', 'values' => false])</div>
  </section>
</div>

<div class="ad-two">
  <section class="panel">
    <div class="panel-head"><h2>Courses by enrollment</h2><a class="small" href="{{ route('admin.courses.index') }}">All courses</a></div>
    @php $topMax = max(1, (int) $topCourses->max('enrollments_total')); @endphp
    @forelse($topCourses as $c)
      <div class="list-row ad-bar-row">
        <div class="grow" style="min-width:0"><a href="{{ route('admin.courses.edit', $c) }}"><b>{{ $c->title }}</b></a><div class="xs muted">{{ $c->enrollments_count }} {{ \Illuminate\Support\Str::plural('batch', $c->enrollments_count) }}</div></div>
        <div class="ad-bar-track" aria-hidden="true"><div class="progress"><i style="width:{{ round($c->enrollments_total / $topMax * 100) }}%"></i></div></div>
        <b class="ad-bar-num">{{ $c->enrollments_total }}</b>
      </div>
    @empty
      <x-empty icon="book-open" title="No courses yet"/>
    @endforelse
  </section>

  <section class="panel">
    <div class="panel-head"><h2>Exam pass rates</h2><a class="small" href="{{ route('admin.exams.index') }}">All exams</a></div>
    @forelse($exams as $e)
      <div class="list-row ad-bar-row">
        <div class="grow" style="min-width:0"><a href="{{ route('admin.exams.show', $e) }}"><b>{{ $e->title }}</b></a><div class="xs muted">{{ $e->finished }} {{ \Illuminate\Support\Str::plural('attempt', $e->finished) }} · average score {{ $e->avg }}% · pass mark {{ $e->pass_percent }}%</div></div>
        <div class="ad-bar-track" aria-hidden="true"><div class="progress {{ $e->pass_rate >= 70 ? 'green' : ($e->pass_rate >= 40 ? 'amber' : 'red') }}"><i style="width:{{ $e->pass_rate }}%"></i></div></div>
        <b class="ad-bar-num">{{ $e->pass_rate }}%</b>
      </div>
    @empty
      <x-empty icon="clipboard-check" title="No finished exam attempts yet" text="Pass rates appear once learners submit their first attempts."/>
    @endforelse
  </section>
</div>

<div class="ad-two">
  <section class="panel">
    <div class="panel-head"><h2>Lead funnel</h2><a class="small" href="{{ route('admin.leads.index') }}">Open pipeline</a></div>
    @if(array_sum($leadFunnel) === 0)
      <x-empty icon="inbox" title="No enquiries yet" text="Website enquiries and quote requests will flow through here."/>
    @else
      @foreach($funnelOrder as $key => $label)
        @php $c = $leadFunnel[$key] ?? 0; $tone = $key === 'converted' ? 'green' : ($key === 'lost' ? 'red' : ''); @endphp
        <div class="list-row ad-bar-row">
          <div style="width:96px;flex-shrink:0"><b>{{ $label }}</b></div>
          <div class="ad-bar-track grow" aria-hidden="true"><div class="progress {{ $tone }}"><i style="width:{{ round($c / $funnelTotal * 100) }}%"></i></div></div>
          <b class="ad-bar-num">{{ $c }}</b>
          <span class="xs muted" style="width:38px;text-align:right">{{ round($c / $funnelTotal * 100) }}%</span>
        </div>
      @endforeach
    @endif
  </section>

  <section class="panel">
    <div class="panel-head"><h2>Payment methods</h2><span class="xs muted">By amount collected</span></div>
    <div class="panel-body">
      @include('partials.charts.donut', ['data' => $methods->map(fn ($m) => ['label' => $methodLabel($m->method), 'note' => $m->c.' '.\Illuminate\Support\Str::plural('payment', $m->c), 'value' => (float) $m->s])->all(), 'format' => 'money', 'size' => 150, 'title' => 'Collected revenue by payment method', 'center' => 'collected', 'empty' => 'No confirmed payments yet.'])
    </div>
  </section>
</div>

<section class="panel">
  <div class="panel-head">
    <h2>Attendance</h2>
    <span class="xs muted">Present and late count as attended; excused classes are ignored</span>
  </div>
  <div class="panel-body ad-att-grid">
    <div>
      <div class="ad-att-hero"><b>{{ $attOverall !== null ? $attOverall.'%' : 'n/a' }}</b><span class="muted small">overall attendance across {{ number_format($attTotal) }} register entries</span></div>
      @include('partials.charts.donut', ['data' => [
        ['label' => 'Present', 'value' => $attStatus['present'] ?? 0, 'color' => '#12b981'],
        ['label' => 'Late', 'value' => $attStatus['late'] ?? 0, 'color' => '#f59e0b'],
        ['label' => 'Absent', 'value' => $attStatus['absent'] ?? 0, 'color' => '#e11d48'],
        ['label' => 'Excused', 'value' => $attStatus['excused'] ?? 0, 'color' => '#94a3b8'],
      ], 'size' => 130, 'title' => 'Attendance status split', 'center' => 'entries', 'empty' => 'No registers have been taken yet.'])
    </div>
    <div>
      @if($attBatches->isEmpty())
        <x-empty icon="user-check" title="No attendance recorded yet" text="Averages appear after the first class register is saved."/>
      @else
      <div class="table-wrap">
        <table class="table ad-table">
          <thead><tr><th style="min-width:210px">Batch</th><th class="num">Classes</th><th class="num">Learners</th><th style="min-width:160px">Average attendance</th><th class="num">Below min.</th></tr></thead>
          <tbody>
          @foreach($attBatches as $r)
            <tr>
              <td><a href="{{ route('admin.attendance.batch', $r['batch']) }}"><b>{{ $r['batch']->course?->title }}</b></a><div class="xs muted mono">{{ $r['batch']->batch_code }}</div></td>
              <td class="num">{{ $r['sessions'] }}</td>
              <td class="num">{{ $r['learners'] }}</td>
              <td><div class="row gap-1" style="flex-wrap:nowrap"><div class="progress {{ $r['avg'] >= $r['batch']->minAttendance() ? 'green' : 'amber' }}" style="flex:1"><i style="width:{{ min(100, $r['avg']) }}%"></i></div><b class="small nowrap">{{ rtrim(rtrim(number_format($r['avg'], 1), '0'), '.') }}%</b></div></td>
              <td class="num">@if($r['low'])<span class="pill pill-red">{{ $r['low'] }}</span>@else<span class="muted">0</span>@endif</td>
            </tr>
          @endforeach
          </tbody>
        </table>
      </div>
      @endif
    </div>
  </div>
</section>
@endsection