@extends('layouts.app') @section('title', 'Corporate / SACCO Dashboard') @section('content')

Corporate / SACCO Dashboard

Pool performance, premiums collected and utilization tracking across all corporate schemes

+ New Scheme Eligibility Check
{{-- Filters --}}
@if(request()->hasAny(['month', 'from', 'to'])) Clear @endif
@if(!$account)

No corporate schemes yet

Create your first SACCO or corporate scheme to start enrolling members and tracking premiums.

+ Register a Scheme
@else {{-- Scheme banner --}} @php $rb = $metrics['risk_band']; $bandColor = ['Green' => 'bg-green-100 text-green-800', 'Amber' => 'bg-amber-100 text-amber-800', 'Red' => 'bg-red-100 text-red-800', 'Critical' => 'bg-red-600 text-white'][$rb]; $bandBar = ['Green' => 'bg-green-500', 'Amber' => 'bg-amber-500', 'Red' => 'bg-red-500', 'Critical' => 'bg-red-700'][$rb]; @endphp

{{ $account->code }}

{{ $account->scheme_status }} @if($account->isPilotActive()) Pilot Active @endif

{{ $account->name }}

Claims / Utilization Ratio

{{ $metrics['claims_ratio'] }}% {{ $rb }}
{{-- Top stat row --}}

Enrolled Members

{{ $metrics['total_enrolled'] }}

{{ $metrics['active_members'] }} active · {{ $metrics['dependants'] }} dep.

Premiums Expected

KES {{ number_format($metrics['premiums_expected']) }}

{{ \Illuminate\Support\Carbon::createFromFormat('Y-m', $month)->format('F Y') }}

Premiums Collected

KES {{ number_format($metrics['premiums_collected']) }}

{{ $metrics['collection_rate'] }}% collection rate

Utilization

KES {{ number_format($metrics['total_utilization']) }}

{{ $metrics['visit_count'] }} encounters

Pool Balance

KES {{ number_format($metrics['pool_balance']) }}

{{ $metrics['pool_balance'] < 0 ? 'Deficit' : 'Surplus' }}

{{-- Compliance breakdown row --}}

Active

{{ $metrics['active_members'] }}

In Grace Period

{{ $metrics['grace_members'] }}

Suspended

{{ $metrics['suspended_members'] }}

Avg Utilization / Member

KES {{ number_format($metrics['avg_per_member']) }}

{{-- Top utilizers --}}

Top 10 Utilizers

By corporate-pool spend in {{ \Illuminate\Support\Carbon::createFromFormat('Y-m', $month)->format('F Y') }}

@forelse($topUtilizers as $u) @empty @endforelse
Member MRN Visits Total
{{ $u['patient_name'] }}
{{ $u['member_no'] }}
{{ $u['mrn'] }} {{ $u['visits'] }} {{ number_format($u['total']) }}
No utilization in this period yet.
{{-- By department --}}

Utilization by Department

Where the pool is being spent

@php $maxDept = collect($byDept)->max('total') ?: 1; @endphp @forelse($byDept as $d)
{{ $d['department'] }} {{ $d['bills'] }} bills · KES {{ number_format($d['total']) }}
@empty

No department utilization recorded.

@endforelse
{{-- Overdue premiums --}} @if(count($overdue))

Members with Overdue Premiums — {{ count($overdue) }} member(s)

@foreach(array_slice($overdue, 0, 20) as $o) @endforeach
Member MRN Billing Month Due Date Outstanding Days Overdue
{{ trim(($o['patient']?->first_name ?? '').' '.($o['patient']?->last_name ?? '')) }}
{{ $o['member']->member_number }}
{{ $o['patient']?->mrn }} {{ $o['collection']->billing_month }} {{ $o['collection']->due_date?->format('d M Y') }} {{ number_format($o['collection']->amount_expected - $o['collection']->amount_paid) }} {{ $o['days_overdue'] }}d
@endif {{-- Pilot summary if pilot is configured --}} @if(count($snapshots))

3-Month Pilot Tracking

{{ $account->pilot_start_date?->format('d M Y') }} → {{ $account->pilot_end_date?->format('d M Y') }}

@foreach($snapshots as $s) @php $sc = ['Green' => 'badge-success', 'Amber' => 'badge-warning', 'Red' => 'badge-danger', 'Critical' => 'badge-danger'][$s['risk_band']]; @endphp @endforeach
Month Premiums Collected Utilization Pool Balance Claims Ratio Risk Band
{{ $s['month'] }} KES {{ number_format($s['premiums_collected']) }} KES {{ number_format($s['utilization']) }} KES {{ number_format($s['pool_balance']) }} {{ $s['claims_ratio'] }}% {{ $s['risk_band'] }}
@endif @endif @endsection