{{-- Statistical reports by officer / station / county / region / national:
     cases, most prevalent offences, male / female, boys / girls, adults vs children, risk levels. Export to Excel. --}}
@extends('layouts.app')
@section('title', 'Probation Statistics - ICMIS')
@push('styles') @include('probation._styles') @endpush
@section('extraFilters')
    <div class="col-md-2"><label class="form-label small mb-0">Group by</label>
        <select name="by" class="form-select form-select-sm">@foreach(['station' => 'Station', 'county' => 'County', 'region' => 'Region', 'officer' => 'Officer'] as $k => $l)<option value="{{ $k }}" {{ $groupBy === $k ? 'selected' : '' }}>{{ $l }}</option>@endforeach</select></div>
    <div class="col-md-2"><label class="form-label small mb-0">Module</label>
        <select name="case_type" class="form-select form-select-sm"><option value="">All</option>@foreach($types as $k => $l)<option value="{{ $k }}" {{ request('case_type') === $k ? 'selected' : '' }}>{{ $l }}</option>@endforeach</select></div>
@endsection
@section('content')
@php
    $totals = ['cases' => 0, 'male' => 0, 'female' => 0, 'boys' => 0, 'girls' => 0, 'adults' => 0, 'children' => 0, 'high' => 0, 'medium' => 0, 'low' => 0];
    foreach ($table as $r) foreach ($totals as $k => $v) $totals[$k] += $r[$k];
    $maxOff = max(1, $offences->max() ?? 1);
@endphp
<div class="container-fluid">
    <div class="d-flex justify-content-between align-items-center mb-3 flex-wrap gap-2">
        <h2 class="fw-bold mb-0">Statistical Report</h2>
        <div class="d-flex gap-2 flex-wrap">
            <a href="{{ request()->fullUrlWithQuery(['export' => 'excel']) }}" class="btn btn-success btn-sm"><i class="fas fa-file-excel"></i> Export to Excel</a>
            <a href="{{ route('probation.assessment-report', request()->except('by', 'case_type')) }}" class="btn btn-outline-secondary btn-sm">Offender assessment report</a>
            <a href="{{ route('probation.conference-report', request()->except('by', 'case_type')) }}" class="btn btn-outline-secondary btn-sm">Case conference report</a>
            <a href="{{ route('probation.inspection-report', request()->except('by', 'case_type')) }}" class="btn btn-outline-secondary btn-sm">Supervisor inspection report</a>
        </div>
    </div>
    @include('probation.dashboard._filters')

    <div class="card pcard mb-3"><div class="card-body p-0"><div class="table-responsive">
        <table class="table table-sm table-bordered mb-0 small text-center align-middle">
            <thead class="table-light">
                <tr><th rowspan="2" class="text-start">{{ ucfirst($groupBy) }}</th><th rowspan="2">Cases</th><th colspan="2">Adults</th><th colspan="2">Children</th><th rowspan="2">Adults</th><th rowspan="2">Children</th><th colspan="3">Risk level</th></tr>
                <tr><th>Male</th><th>Female</th><th>Boys</th><th>Girls</th><th>High</th><th>Medium</th><th>Low</th></tr>
            </thead>
            <tbody>
            @forelse($table as $k => $r)
                <tr><td class="text-start">{{ $k }}</td><td class="fw-bold">{{ $r['cases'] }}</td><td>{{ $r['male'] }}</td><td>{{ $r['female'] }}</td><td>{{ $r['boys'] }}</td><td>{{ $r['girls'] }}</td>
                    <td>{{ $r['adults'] }}</td><td>{{ $r['children'] }}</td><td>{{ $r['high'] }}</td><td>{{ $r['medium'] }}</td><td>{{ $r['low'] }}</td></tr>
            @empty<tr><td colspan="11" class="text-muted py-3">No cases.</td></tr>@endforelse
            </tbody>
            <tfoot class="table-light fw-bold"><tr><td class="text-start">Total</td>@foreach($totals as $v)<td>{{ $v }}</td>@endforeach</tr></tfoot>
        </table>
    </div></div></div>

    <div class="row g-3">
        <div class="col-lg-6"><div class="card pcard"><div class="card-header">Most prevalent offences</div><div class="card-body">
            @forelse($offences as $o => $n)
                <div class="d-flex justify-content-between small"><span>{{ $o }}</span><strong>{{ $n }}</strong></div>
                <div class="progress mb-2" style="height:6px"><div class="progress-bar bg-danger" style="width:{{ round(100 * $n / $maxOff) }}%"></div></div>
            @empty<p class="text-muted small mb-0">No offences recorded.</p>@endforelse
        </div></div></div>
        <div class="col-lg-6"><div class="card pcard"><div class="card-header">Male / female · adults / children</div><div class="card-body">
            @php $sum = max(1, $totals['cases']); @endphp
            @foreach(['Male (adults)' => $totals['male'], 'Female (adults)' => $totals['female'], 'Boys' => $totals['boys'], 'Girls' => $totals['girls']] as $l => $v)
                <div class="d-flex justify-content-between small"><span>{{ $l }}</span><strong>{{ $v }} ({{ round(100 * $v / $sum) }}%)</strong></div>
                <div class="progress mb-2" style="height:6px"><div class="progress-bar" style="width:{{ round(100 * $v / $sum) }}%"></div></div>
            @endforeach
            <div class="form-text">Children = flagged as a child offender or under 18 at registration. Sex not recorded is not counted in these four bars.</div>
        </div></div></div>
    </div>
</div>
@endsection