@extends('layouts.app')
@section('title', 'Executive dashboard')
@section('heading', 'Executive dashboard')
@section('content')
@php $k = fn ($v) => number_format((float) $v); $i = $s['inventory']; $max = max(1, (float) collect($s['monthly'])->max(fn ($m) => (float) $m['revenue'])); @endphp
<form method="GET" class="grid gap-3 rounded-lg border border-line bg-panel p-4 sm:grid-cols-6" x-data="{ p: '{{ $preset }}' }">
 <div><label for="preset" class="mb-1 block text-xs font-medium">Period</label><select id="preset" name="preset" x-model="p" class="field">@foreach (['today' => 'Today', 'week' => 'This week', 'month' => 'This month', 'quarter' => 'This quarter', 'year' => 'This year', 'custom' => 'Custom dates'] as $v => $l)<option value="{{ $v }}">{{ $l }}</option>@endforeach</select></div>
 <div x-show="p === 'custom'" x-cloak><label for="from" class="mb-1 block text-xs font-medium">From</label><input id="from" type="date" name="from" value="{{ $from->toDateString() }}" class="field"></div>
 <div x-show="p === 'custom'" x-cloak><label for="to" class="mb-1 block text-xs font-medium">To</label><input id="to" type="date" name="to" value="{{ $to->toDateString() }}" class="field"></div>
 @if ($branches->count() > 1)<fieldset class="sm:col-span-2"><legend class="mb-1 text-xs font-medium">Branches</legend><div class="flex flex-wrap gap-3 text-sm">@foreach ($branches as $b)<label class="flex items-center gap-1"><input type="checkbox" name="branches[]" value="{{ $b->id }}" @checked(in_array($b->id, $selected)) class="rounded border-line">{{ $b->name }}</label>@endforeach</div></fieldset>@endif
 <div class="flex items-end gap-2"><button class="btn-primary">Show</button></div></form>
<div class="mt-3 flex flex-wrap items-center justify-between gap-2 text-sm"><p class="text-muted">{{ $from->format('d M Y') }} to {{ $to->format('d M Y') }} · updated <span id="at">{{ now()->format('H:i:s') }}</span> (refreshes every minute)</p>
@can('executive.export')<p class="flex gap-2"><a class="btn-quiet" href="{{ route('executive.excel', request()->query()) }}">{{ $export['excel'] ? 'Download Excel' : 'Download CSV' }}</a><a class="btn-quiet" href="{{ route('executive.pdf', request()->query()) }}" @unless ($export['pdf']) target="_blank" @endunless>{{ $export['pdf'] ? 'Download PDF' : 'Printable report' }}</a></p>@endcan</div>

<ul class="mt-4 grid grid-cols-2 gap-3 lg:grid-cols-4" id="kpis">
 <li class="rounded-lg border border-line bg-panel p-4"><p class="text-xs text-muted">Vehicles sold</p><p class="text-2xl font-bold" data-k="units">{{ $s['totals']['units'] }}</p><p class="text-xs text-muted">today <span data-k="today_units">{{ $s['today']['units'] }}</span></p></li>
 @if ($canSeeProfit)<li class="rounded-lg border border-line bg-panel p-4"><p class="text-xs text-muted">Gross profit (KSh)</p><p class="text-2xl font-bold {{ bccomp($s['totals']['gp'], '0', 2) < 0 ? 'text-stop' : '' }}" data-k="gp">{{ $k($s['totals']['gp']) }}</p><p class="text-xs text-muted">margin {{ $s['totals']['margin'] ?? '–' }}% · today <span data-k="today_gp">{{ $k($s['today']['gp']) }}</span></p></li>@endif
 <li class="rounded-lg border border-line bg-panel p-4"><p class="text-xs text-muted">Inventory turn (yearly)</p><p class="text-2xl font-bold" data-k="turn">{{ $i['turn_annual'] ?? '–' }}×</p><p class="text-xs text-muted">stock lasts about {{ $i['days_to_sell_stock'] ?? '–' }} days at this pace</p></li>
 <li class="rounded-lg border border-line bg-panel p-4"><p class="text-xs text-muted">Stock held (KSh)</p><p class="text-2xl font-bold" data-k="stock">{{ $k($i['value_now']) }}</p><p class="text-xs text-muted">{{ $i['units_now'] }} cars · {{ $i['aged_units'] }} over 90 days</p></li></ul>

@if ($canSeeProfit)<section class="mt-5 rounded-lg border border-line bg-panel p-4" aria-labelledby="m-h"><h2 id="m-h" class="text-sm font-semibold">Last 12 months: revenue (bar) and gross profit (figure)</h2>
 <svg viewBox="0 0 720 190" class="mt-3 w-full" role="img" aria-label="Monthly revenue and gross profit">@foreach ($s['monthly'] as $n => $m)@php $h = (float) $m['revenue'] / $max * 130; $x = 10 + $n * 58; @endphp<rect x="{{ $x }}" y="{{ 150 - $h }}" width="40" height="{{ max(1, $h) }}" fill="#1b7f57" rx="2"/><text x="{{ $x + 20 }}" y="168" text-anchor="middle" font-size="10" fill="#5b6b66">{{ $m['label'] }}</text><text x="{{ $x + 20 }}" y="{{ 144 - $h }}" text-anchor="middle" font-size="9" fill="{{ bccomp($m['gp'], '0', 2) < 0 ? '#b3261e' : '#17211e' }}">{{ $m['units'] ? number_format((float) $m['gp'] / 1000).'k' : '' }}</text>@endforeach</svg></section>@endif

<section class="mt-5" aria-labelledby="b-h"><h2 id="b-h" class="mb-2 text-sm font-semibold">By branch</h2><div class="overflow-x-auto rounded-lg border border-line bg-panel"><table class="min-w-full text-left text-sm"><caption class="sr-only">Branches</caption>
<thead class="border-b border-line bg-ground text-xs text-muted"><tr><th scope="col" class="px-3 py-2 font-medium">Branch</th><th scope="col" class="px-3 py-2 text-right font-medium">Sold</th>@if ($canSeeProfit)<th scope="col" class="px-3 py-2 text-right font-medium">Revenue</th><th scope="col" class="px-3 py-2 text-right font-medium">Gross profit</th><th scope="col" class="px-3 py-2 text-right font-medium">Margin</th>@endif<th scope="col" class="px-3 py-2 text-right font-medium">In stock</th><th scope="col" class="px-3 py-2 text-right font-medium">Stock value</th></tr></thead><tbody class="divide-y divide-line">
@foreach ($s['branches'] as $r)<tr><td class="px-3 py-2 font-medium">{{ $r['name'] }}</td><td class="px-3 py-2 text-right">{{ $r['units'] }}</td>@if ($canSeeProfit)<td class="px-3 py-2 text-right">{{ $k($r['revenue']) }}</td><td class="px-3 py-2 text-right">{{ $k($r['gp']) }}</td><td class="px-3 py-2 text-right">{{ $r['margin'] !== null ? $r['margin'].'%' : '–' }}</td>@endif<td class="px-3 py-2 text-right">{{ $r['stock_units'] }}</td><td class="px-3 py-2 text-right">{{ $k($r['stock_value']) }}</td></tr>@endforeach
<tr class="border-t-2 border-ink font-semibold"><td class="px-3 py-2">All branches</td><td class="px-3 py-2 text-right">{{ $s['totals']['units'] }}</td>@if ($canSeeProfit)<td class="px-3 py-2 text-right">{{ $k($s['totals']['revenue']) }}</td><td class="px-3 py-2 text-right">{{ $k($s['totals']['gp']) }}</td><td class="px-3 py-2 text-right">{{ $s['totals']['margin'] !== null ? $s['totals']['margin'].'%' : '–' }}</td>@endif<td class="px-3 py-2 text-right">{{ $i['units_now'] }}</td><td class="px-3 py-2 text-right">{{ $k($i['value_now']) }}</td></tr></tbody></table></div></section>

<div class="mt-5 grid gap-5 lg:grid-cols-2">
<section class="rounded-lg border border-line bg-panel p-4" aria-labelledby="i-h"><h2 id="i-h" class="text-sm font-semibold">Inventory</h2><dl class="mt-3 grid grid-cols-2 gap-3 text-sm">
 <div><dt class="text-xs text-muted">Turn this period</dt><dd class="font-medium">{{ $i['turn'] ?? '–' }}×</dd></div><div><dt class="text-xs text-muted">Average stock value</dt><dd class="font-medium">KSh {{ $k($i['average_value']) }}</dd></div>
 <div><dt class="text-xs text-muted">Average days to sell a car</dt><dd class="font-medium">{{ $i['avg_days_to_sell'] ?? '–' }}</dd></div><div><dt class="text-xs text-muted">Money tied up in cars over 90 days</dt><dd class="font-medium {{ $i['aged_units'] ? 'text-stop' : '' }}">KSh {{ $k($i['aged_value']) }}</dd></div></dl>
 <p class="mt-3 text-xs text-muted">Turn = cost of cars sold ÷ average stock value, using each car's landed cost. A higher number means cash is not sitting in the yard.</p></section>
<section class="rounded-lg border border-line bg-panel p-4" aria-labelledby="p-h"><h2 id="p-h" class="text-sm font-semibold">Pipeline and cash</h2><dl class="mt-3 grid grid-cols-2 gap-3 text-sm">
 <div><dt class="text-xs text-muted">Open deals</dt><dd class="font-medium">{{ $s['pipeline']['open_deals'] }} · KSh {{ $k($s['pipeline']['open_deal_value']) }}</dd></div><div><dt class="text-xs text-muted">Still to collect</dt><dd class="font-medium">KSh {{ $k($s['pipeline']['receivable']) }}</dd></div>
 @foreach ($s['pipeline']['leads'] as $stage => $n)<div><dt class="text-xs text-muted">Leads: {{ \App\Enums\LeadStage::from($stage)->label() }}</dt><dd class="font-medium">{{ $n }}</dd></div>@endforeach</dl></section></div>

@if ($canSeeProfit && count($s['leaders']))<section class="mt-5" aria-labelledby="l-h"><h2 id="l-h" class="mb-2 text-sm font-semibold">Top salespeople</h2><ol class="divide-y divide-line rounded-lg border border-line bg-panel text-sm">@foreach ($s['leaders'] as $l)<li class="flex justify-between px-3 py-2"><span>{{ $l['name'] }} · {{ $l['units'] }} sold</span><span class="font-medium">KSh {{ $k($l['gp']) }}</span></li>@endforeach</ol></section>@endif

@php $h = $s['health']; $problems = collect($h)->filter(); @endphp
<section class="mt-5" aria-labelledby="h-h"><h2 id="h-h" class="mb-2 text-sm font-semibold">Needs attention</h2>@if ($problems->isEmpty())<p class="rounded-lg border border-line bg-panel p-3 text-sm text-go">Nothing is waiting.</p>@else<ul class="grid gap-2 text-sm sm:grid-cols-2">
@foreach (['approvals_waiting' => ['Discounts waiting for approval', 'deals.approvals'], 'etims_problems' => ['KRA eTIMS invoices not accepted', 'etims.index'], 'mpesa_unmatched' => ['M-Pesa payments to match', 'mpesa.index'], 'refunds_due' => ['Online deposits to refund', 'reservations.admin'], 'appointments_new' => ['New service requests', 'appointments.index']] as $key => [$label, $route])@if (($h[$key] ?? 0) > 0)<li><a class="block rounded-lg border border-amber-300 bg-amber-50 p-3 font-medium text-amber-900 hover:shadow" href="{{ \Illuminate\Support\Facades\Route::has($route) ? route($route) : '#' }}">{{ $h[$key] }} · {{ $label }}</a></li>@endif @endforeach</ul>@endif</section>

<script>(function(){var q=location.search,u={{ Js::from(route('executive.data')) }}+q,n=function(v){return Number(v).toLocaleString('en-KE',{maximumFractionDigits:0})};
setInterval(function(){if(document.hidden)return;fetch(u,{headers:{Accept:'application/json'}}).then(function(r){return r.ok?r.json():null}).then(function(d){if(!d)return;var s=function(k,v){var e=document.querySelector('[data-k="'+k+'"]');if(e)e.textContent=v};
s('units',d.totals.units);s('today_units',d.today.units);s('gp',n(d.totals.gp));s('today_gp',n(d.today.gp));s('stock',n(d.inventory.value_now));s('turn',(d.inventory.turn_annual??'–')+'×');document.getElementById('at').textContent=d.at}).catch(function(){})},60000)})();</script>
<script src="https://cdn.jsdelivr.net/npm/alpinejs@3.14.1/dist/cdn.min.js" defer></script>
@endsection