@extends('layouts.app')
@section('title', 'Locum Reports')
@section('content')
{{-- Year Selector --}}
<div class="flex items-center gap-3 mb-4">
    <form method="GET" class="flex gap-2 items-center">
        <label class="form-label mb-0">Financial Year:</label>
        <select name="year" class="form-input text-xs w-24" onchange="this.form.submit()">
            @for($y = now()->year; $y >= 2020; $y--)<option value="{{ $y }}" {{ $year==$y?'selected':'' }}>{{ $y }}</option>@endfor
        </select>
    </form>
    <button onclick="printReport()" class="btn-secondary text-xs ml-auto">Print Annual Summary</button>
</div>

{{-- Annual Summary Table --}}
<div class="bg-white rounded-xl border border-gray-200 overflow-hidden mb-6" id="annual-report">
    <div class="px-5 py-3 border-b">
        <h3 class="text-sm font-bold text-gray-700">CLARA ROSA HOSPITAL | ANNUAL LOCUM EXPENDITURE SUMMARY</h3>
        <p class="text-xs text-gray-400">Financial Year: {{ $year }}</p>
    </div>
    <div class="overflow-x-auto">
    <table class="w-full">
        <thead class="bg-gray-50"><tr>
            <th class="table-header">Month</th>
            <th class="table-header text-right">No. of Locums</th>
            <th class="table-header text-right">Total Shifts</th>
            <th class="table-header text-right">Gross Pay (KES)</th>
            <th class="table-header text-right">WHT (KES)</th>
            <th class="table-header text-right">Other Deductions (KES)</th>
            <th class="table-header text-right">Net Pay (KES)</th>
        </tr></thead>
        <tbody class="divide-y divide-gray-50">
        @php $totals = ['locums'=>0,'shifts'=>0,'gross'=>0,'wht'=>0,'deductions'=>0,'net'=>0]; @endphp
        @foreach($annual as $row)
            @php
                $totals['locums'] += $row['locums'];
                $totals['shifts'] += $row['shifts'];
                $totals['gross'] += $row['gross'];
                $totals['wht'] += $row['wht'];
                $totals['deductions'] += $row['deductions'];
                $totals['net'] += $row['net'];
            @endphp
            <tr class="hover:bg-blue-50/30 {{ $row['locums'] > 0 ? '' : 'text-gray-300' }}">
                <td class="table-cell text-sm font-medium">{{ $row['month'] }}</td>
                <td class="table-cell text-xs text-right">{{ $row['locums'] ?: '-' }}</td>
                <td class="table-cell text-xs text-right">{{ $row['shifts'] ?: '-' }}</td>
                <td class="table-cell text-xs text-right">{{ $row['gross'] ? number_format($row['gross']) : '-' }}</td>
                <td class="table-cell text-xs text-right text-red-600">{{ $row['wht'] ? number_format($row['wht']) : '-' }}</td>
                <td class="table-cell text-xs text-right">{{ $row['deductions'] ? number_format($row['deductions']) : '-' }}</td>
                <td class="table-cell text-xs text-right font-semibold">{{ $row['net'] ? number_format($row['net']) : '-' }}</td>
            </tr>
        @endforeach
        </tbody>
        <tfoot class="bg-gray-100 font-bold">
            <tr>
                <td class="table-cell text-sm">ANNUAL TOTAL</td>
                <td class="table-cell text-xs text-right">{{ $totals['locums'] }}</td>
                <td class="table-cell text-xs text-right">{{ $totals['shifts'] }}</td>
                <td class="table-cell text-xs text-right">KES {{ number_format($totals['gross']) }}</td>
                <td class="table-cell text-xs text-right text-red-600">KES {{ number_format($totals['wht']) }}</td>
                <td class="table-cell text-xs text-right">KES {{ number_format($totals['deductions']) }}</td>
                <td class="table-cell text-xs text-right text-green-700">KES {{ number_format($totals['net']) }}</td>
            </tr>
        </tfoot>
    </table>
    </div>
</div>

{{-- Compliance Alerts --}}
<div class="grid grid-cols-1 md:grid-cols-3 gap-4">
    {{-- Expired Licenses --}}
    <div class="bg-white rounded-xl border border-gray-200 overflow-hidden">
        <div class="px-4 py-3 border-b bg-red-50"><h4 class="text-xs font-bold text-red-800 uppercase">Expired Licenses ({{ $expiredLicenses->count() }})</h4></div>
        @if($expiredLicenses->count())
        <div class="divide-y divide-gray-50">
            @foreach($expiredLicenses as $l)
            <div class="px-4 py-2.5 text-xs">
                <p class="font-medium">{{ $l->full_name }}</p>
                <p class="text-gray-400">{{ $l->license_no }} · Expired {{ $l->license_expiry->format('d M Y') }}</p>
            </div>
            @endforeach
        </div>
        @else <p class="px-4 py-6 text-xs text-gray-400 text-center">No expired licenses</p> @endif
    </div>

    {{-- Missing KRA PIN --}}
    <div class="bg-white rounded-xl border border-gray-200 overflow-hidden">
        <div class="px-4 py-3 border-b bg-amber-50"><h4 class="text-xs font-bold text-amber-800 uppercase">Missing KRA PIN ({{ $missingKra->count() }})</h4></div>
        @if($missingKra->count())
        <div class="divide-y divide-gray-50">
            @foreach($missingKra as $l)
            <div class="px-4 py-2.5 text-xs">
                <p class="font-medium">{{ $l->full_name }}</p>
                <p class="text-gray-400">{{ $l->role_designation }} · {{ $l->department->name ?? '' }}</p>
            </div>
            @endforeach
        </div>
        @else <p class="px-4 py-6 text-xs text-gray-400 text-center">All locums have KRA PINs</p> @endif
    </div>

    {{-- Unpaid Approved --}}
    <div class="bg-white rounded-xl border border-gray-200 overflow-hidden">
        <div class="px-4 py-3 border-b bg-blue-50"><h4 class="text-xs font-bold text-blue-800 uppercase">Unpaid Approved ({{ $unpaidApproved->count() }})</h4></div>
        @if($unpaidApproved->count())
        <div class="divide-y divide-gray-50">
            @foreach($unpaidApproved as $item)
            <div class="px-4 py-2.5 text-xs flex justify-between">
                <div>
                    <p class="font-medium">{{ $item->locum->full_name ?? '' }}</p>
                    <p class="text-gray-400">{{ $item->batch->month_name ?? '' }}</p>
                </div>
                <span class="font-bold text-green-700">KES {{ number_format($item->net_pay) }}</span>
            </div>
            @endforeach
        </div>
        @else <p class="px-4 py-6 text-xs text-gray-400 text-center">No unpaid approved items</p> @endif
    </div>
</div>
@endsection
@section('scripts')
<script>
function printReport(){
    const t = document.getElementById('annual-report');
    const w = window.open('','_blank','width=1000,height=700');
    w.document.write(`<!DOCTYPE html><html><head><title>Annual Locum Summary {{ $year }}</title>
    <style>*{font-family:Arial,sans-serif;margin:0;padding:0}body{padding:20px;font-size:12px}
    table{width:100%;border-collapse:collapse}th{background:#f3f4f6;text-align:left;padding:5px 6px;font-size:12px;font-weight:700;text-transform:uppercase;border:1px solid #ddd}
    td{padding:4px 6px;border:1px solid #ddd;font-size:12px}tfoot td{font-weight:700;background:#f3f4f6}
    .text-right{text-align:right}h3{font-size:14px;margin-bottom:4px}p{font-size:12px;color:#888;margin-bottom:10px}
    @media print{body{padding:10px}}</style></head><body>`);
    w.document.write(t.innerHTML);
    w.document.write('</body></html>');
    w.document.close();
    setTimeout(()=>w.print(), 300);
}
</script>
@endsection