@extends('layouts.app')
@section('title', 'Reports')
@section('page', 'reports')
@section('content')
@php
  $max = max(1, collect($revenue)->max('amount'));
  $maxClient = max(1, $byClient->max('amount') ?? 1);
  $maxDays = max(1, $approvalDays->max('days') ?? 1);
  $maxW = max(1, collect($weeks)->max('count'));
  $change = $prev > 0 ? round(($collected - $prev) / $prev * 100) : null;
  $range = request('range', '6m');
@endphp
<div class="page-head">
  <div><h1>Reports</h1><p>Revenue, delivery and client responsiveness across the agency.</p></div>
  <div class="actions"><select class="input" style="width:auto" aria-label="Date range" onchange="location.href='?range='+this.value"><option value="6m" @selected($range === '6m')>Last 6 months</option><option value="quarter" @selected($range === 'quarter')>This quarter</option><option value="year" @selected($range === 'year')>This year</option><option value="last_year" @selected($range === 'last_year')>Last year</option></select><a class="btn" href="{{ route('admin.invoices.export') }}"><i data-icon="download"></i>Export</a></div>
</div>
<section class="stats">
  <div class="stat"><div class="label">Revenue collected</div><div class="value tnum">AED {{ money_k($collected) }}</div><div class="sub {{ $change === null ? '' : ($change >= 0 ? 'up' : 'down') }}">{{ $change === null ? 'No earlier period to compare' : abs($change).'% '.($change >= 0 ? 'more' : 'less').' than last period' }}</div></div>
  <div class="stat"><div class="label">Projects delivered</div><div class="value">{{ $delivered }}</div><div class="sub up">{{ $onTime }}% of milestones on time</div></div>
  <div class="stat"><div class="label">Client approval time</div><div class="value">{{ $avgApproval }} days</div><div class="sub">From sharing to decision</div></div>
  <div class="stat"><div class="label">Average days to pay</div><div class="value">{{ plural($daysToPay, 'day') }}</div><div class="sub">From issue to payment</div></div>
</section>
<div class="grid g-2">
  <section class="panel"><div class="panel-head"><div><h2>Revenue collected</h2><p>AED, by month</p></div></div><div class="panel-body"><div class="bars">@foreach ($revenue as $r)<div class="b {{ $loop->last ? 'cur' : '' }}"><em>{{ money_k($r['amount']) }}</em><span style="height:{{ max(2, round($r['amount'] / $max * 100)) }}%"></span><small>{{ $r['label'] }}</small></div>@endforeach</div></div></section>
  <section class="panel"><div class="panel-head"><div><h2>Revenue by client</h2><p>Selected period</p></div><a href="{{ route('admin.clients.index') }}">Clients</a></div><div class="panel-body hbars">
    @forelse ($byClient->take(6) as $c)<div class="hbar"><span>{{ $c['name'] }}</span><div class="track"><span style="width:{{ round($c['amount'] / $maxClient * 100) }}%"></span></div><b>AED {{ money_k($c['amount']) }}</b></div>@empty<p class="small muted">No payments in this period.</p>@endforelse
  </div></section>
  <section class="panel"><div class="panel-head"><div><h2>Average approval time</h2><p>Days from sharing to client decision</p></div><a href="{{ route('admin.approvals.index') }}">Approvals</a></div><div class="panel-body hbars">
    @forelse ($approvalDays as $c)<div class="hbar"><span>{{ $c['name'] }}</span><div class="track"><span style="width:{{ round($c['days'] / $maxDays * 100) }}%"></span></div><b>{{ $c['days'] }} days</b></div>@empty<p class="small muted">No decisions yet.</p>@endforelse
  </div></section>
  <section class="panel"><div class="panel-head"><div><h2>Delivery by project manager</h2><p>Milestones hit on time</p></div><a href="{{ route('admin.team.index') }}">Team</a></div>
    <div class="table-wrap"><table class="table"><thead><tr><th>Manager</th><th>Projects</th><th>On time</th><th class="right">Late</th></tr></thead><tbody>
      @foreach ($managers as $m)
      <tr><td><a class="cell-main" href="{{ route('admin.team.show', $m['user']) }}">{{ av($m['user'], 'sm') }}<strong>{{ $m['user']->name }}</strong></a></td><td>{{ $m['projects'] }}</td><td><div class="prog-row"><div class="progress {{ $m['on_time'] >= 80 ? 'green' : 'amber' }}"><span style="width:{{ $m['on_time'] }}%"></span></div><b>{{ $m['on_time'] }}%</b></div></td><td class="right">{{ $m['late'] }}</td></tr>
      @endforeach
    </tbody></table></div></section>
  <section class="panel"><div class="panel-head"><div><h2>{{ agency()->assistant?->name ?? 'Desk Assistant' }} questions</h2><p>Per week, last 4 weeks</p></div><a href="{{ route('admin.assistant.conversations') }}">Conversations</a></div><div class="panel-body"><div class="bars" style="height:160px">@foreach ($weeks as $w)<div class="b {{ $loop->last ? 'cur' : '' }}"><em>{{ $w['count'] }}</em><span style="height:{{ max(2, round($w['count'] / $maxW * 100)) }}%;background:var(--citrine)"></span><small>{{ $w['label'] }}</small></div>@endforeach</div></div></section>
  <section class="panel"><div class="panel-head"><div><h2>What clients ask about</h2><p>Share of assistant questions</p></div><a href="{{ route('admin.knowledge') }}">Knowledge Hub</a></div><div class="panel-body hbars">
    @php $maxT = max(1, $topicCounts->max()); @endphp
    @foreach ($topicCounts as $label => $n)<div class="hbar"><span>{{ $label }}</span><div class="track"><span class="cit" style="width:{{ round($n / $maxT * 100) }}%"></span></div><b>{{ round($n / $totalQ * 100) }}%</b></div>@endforeach
  </div></section>
</div>
@endsection