@extends('layouts.app')
@section('title', 'Payroll Reports')
@section('styles')
<style>
@media print { .no-print { display: none !important; } }
.report-meta{background:#f9f0fc;border-radius:8px;padding:10px 14px;font-size:12px;color:#5c1269;margin-bottom:14px}
</style>
@endsection
@section('content')

<div class="no-print mb-3"><a href="{{ route('payroll.index') }}" class="text-xs text-gray-500 hover:underline">← Back to Payroll</a></div>

{{-- Filter bar --}}
<div class="no-print bg-white rounded-xl border p-4 mb-4">
    <form method="GET" class="grid grid-cols-1 md:grid-cols-5 gap-3 items-end">
        <div class="md:col-span-2">
            <label class="form-label">Report Type</label>
            <select name="report" class="form-input" onchange="this.form.submit()">
                <option value="monthly_summary" @if($reportType==='monthly_summary') selected @endif>Monthly Summary</option>
                <option value="department_cost" @if($reportType==='department_cost') selected @endif>Department Cost</option>
                <option value="employee_history" @if($reportType==='employee_history') selected @endif>Employee History (annual)</option>
                <option value="statutory_summary" @if($reportType==='statutory_summary') selected @endif>Statutory Summary (annual)</option>
                <option value="employer_contributions" @if($reportType==='employer_contributions') selected @endif>Employer Contributions</option>
                <option value="payment_schedule" @if($reportType==='payment_schedule') selected @endif>Payment Schedule</option>
                <option value="bank_export" @if($reportType==='bank_export') selected @endif>Bank Payment Export (CSV)</option>
                <option value="remittance_by_body" @if($reportType==='remittance_by_body') selected @endif>Remittances by Body</option>
                <option value="ytd_earnings" @if($reportType==='ytd_earnings') selected @endif>YTD Earnings (per employee)</option>
            </select>
        </div>
        @if(in_array($reportType, ['monthly_summary','department_cost','employer_contributions','payment_schedule','bank_export']))
        <div>
            <label class="form-label">Month</label>
            <input type="month" name="month" value="{{ $month }}" class="form-input">
        </div>
        @endif
        @if(in_array($reportType, ['employee_history','statutory_summary','remittance_by_body','ytd_earnings']))
        <div>
            <label class="form-label">Year</label>
            <input type="number" name="year" value="{{ $year }}" min="2020" max="2099" class="form-input">
        </div>
        @endif
        @if($reportType==='employee_history')
        <div>
            <label class="form-label">Employee</label>
            <select name="staff_id" class="form-input">
                <option value="">— Select —</option>
                @foreach($allStaff as $s)
                <option value="{{ $s->id }}" @if(request('staff_id')==$s->id) selected @endif>{{ $s->full_name }} ({{ $s->employee_number }})</option>
                @endforeach
            </select>
        </div>
        @endif
        <div class="flex gap-2">
            <button type="submit" class="btn-primary text-xs">Generate</button>
            <button type="button" onclick="window.print()" class="btn-secondary text-xs">🖨 Print</button>
        </div>
    </form>
</div>

{{-- ═══════════ MONTHLY SUMMARY ═══════════ --}}
@if($reportType==='monthly_summary')
    @php $run = $data['run'] ?? null; $items = $data['items'] ?? collect(); @endphp
    @if(!$run)
    <div class="bg-white rounded-xl border p-8 text-center text-sm text-gray-400">No payroll run found for {{ \Carbon\Carbon::parse($month.'-01')->format('F Y') }}.</div>
    @else
    <div class="bg-white rounded-xl border overflow-hidden">
        <div class="p-5 border-b">
            <h2 class="text-lg font-bold">Monthly Payroll Summary — {{ $run->month_label }}</h2>
            <p class="text-xs text-gray-500">Run {{ $run->run_number }} · {{ $run->employee_count }} employees · Status: {{ ucfirst($run->status) }}</p>
        </div>
        <div class="overflow-x-auto">
        <table class="w-full text-xs">
            <thead class="bg-gray-50"><tr>
                <th class="table-header">Emp No.</th>
                <th class="table-header">Name</th>
                <th class="table-header">Department</th>
                <th class="table-header text-right">Gross</th>
                <th class="table-header text-right">PAYE</th>
                <th class="table-header text-right">SHIF</th>
                <th class="table-header text-right">NSSF</th>
                <th class="table-header text-right">AHL</th>
                <th class="table-header text-right">Other</th>
                <th class="table-header text-right">Net</th>
            </tr></thead>
            <tbody class="divide-y divide-gray-50">
                @foreach($items as $i)
                <tr><td class="table-cell">{{ $i->employee_number }}</td><td class="table-cell font-medium">{{ $i->full_name }}</td><td class="table-cell text-gray-500">{{ $i->department }}</td>
                    <td class="table-cell text-right">{{ number_format($i->gross_pay) }}</td>
                    <td class="table-cell text-right">{{ number_format($i->paye) }}</td>
                    <td class="table-cell text-right">{{ number_format($i->shif) }}</td>
                    <td class="table-cell text-right">{{ number_format($i->nssf_employee) }}</td>
                    <td class="table-cell text-right">{{ number_format($i->ahl_employee) }}</td>
                    <td class="table-cell text-right">{{ number_format($i->other_deductions) }}</td>
                    <td class="table-cell text-right font-semibold text-green-700">{{ number_format($i->net_pay) }}</td>
                </tr>
                @endforeach
            </tbody>
            <tfoot class="bg-purple-50 font-bold">
                <tr><td colspan="3" class="table-cell">TOTALS</td>
                    <td class="table-cell text-right">{{ number_format($run->total_gross) }}</td>
                    <td class="table-cell text-right">{{ number_format($run->total_paye) }}</td>
                    <td class="table-cell text-right">{{ number_format($run->total_shif) }}</td>
                    <td class="table-cell text-right">{{ number_format($run->total_nssf_employee) }}</td>
                    <td class="table-cell text-right">{{ number_format($run->total_ahl_employee) }}</td>
                    <td class="table-cell text-right">{{ number_format($run->total_other_deductions) }}</td>
                    <td class="table-cell text-right text-green-700">{{ number_format($run->total_net) }}</td>
                </tr>
            </tfoot>
        </table>
        </div>
    </div>
    @endif
@endif

{{-- ═══════════ DEPARTMENT COST ═══════════ --}}
@if($reportType==='department_cost')
    @php $run = $data['run'] ?? null; $rows = $data['rows'] ?? collect(); @endphp
    @if(!$run)
    <div class="bg-white rounded-xl border p-8 text-center text-sm text-gray-400">No payroll run found for {{ \Carbon\Carbon::parse($month.'-01')->format('F Y') }}.</div>
    @else
    <div class="bg-white rounded-xl border overflow-hidden">
        <div class="p-5 border-b"><h2 class="text-lg font-bold">Departmental Cost Breakdown — {{ $run->month_label }}</h2><p class="text-xs text-gray-500">Run {{ $run->run_number }}</p></div>
        <table class="w-full text-xs">
            <thead class="bg-gray-50"><tr>
                <th class="table-header">Department</th>
                <th class="table-header text-center">Headcount</th>
                <th class="table-header text-right">Gross Pay</th>
                <th class="table-header text-right">PAYE</th>
                <th class="table-header text-right">Net Pay</th>
                <th class="table-header text-right">Employer Cost</th>
                <th class="table-header text-right">% of Total</th>
            </tr></thead>
            <tbody class="divide-y divide-gray-50">
            @php $totalCost = $rows->sum('employer_cost') ?: 1; @endphp
            @foreach($rows as $r)
                <tr>
                    <td class="table-cell font-medium">{{ $r->department ?? 'Unassigned' }}</td>
                    <td class="table-cell text-center">{{ $r->headcount }}</td>
                    <td class="table-cell text-right">{{ number_format($r->gross) }}</td>
                    <td class="table-cell text-right">{{ number_format($r->paye) }}</td>
                    <td class="table-cell text-right">{{ number_format($r->net) }}</td>
                    <td class="table-cell text-right font-semibold" style="color:#5c1269">{{ number_format($r->employer_cost) }}</td>
                    <td class="table-cell text-right text-gray-500">{{ number_format($r->employer_cost / $totalCost * 100, 1) }}%</td>
                </tr>
            @endforeach
            </tbody>
            <tfoot class="bg-purple-50 font-bold">
                <tr><td class="table-cell">TOTAL</td>
                    <td class="table-cell text-center">{{ $rows->sum('headcount') }}</td>
                    <td class="table-cell text-right">{{ number_format($rows->sum('gross')) }}</td>
                    <td class="table-cell text-right">{{ number_format($rows->sum('paye')) }}</td>
                    <td class="table-cell text-right">{{ number_format($rows->sum('net')) }}</td>
                    <td class="table-cell text-right" style="color:#5c1269">{{ number_format($rows->sum('employer_cost')) }}</td>
                    <td class="table-cell text-right">100%</td>
                </tr>
            </tfoot>
        </table>
    </div>
    @endif
@endif

{{-- ═══════════ EMPLOYEE HISTORY ═══════════ --}}
@if($reportType==='employee_history')
    @php $staff = $data['staff'] ?? null; $items = $data['items'] ?? collect(); @endphp
    @if(!$staff)
    <div class="bg-white rounded-xl border p-8 text-center text-sm text-gray-400">Pick an employee to view their {{ $year }} payroll history.</div>
    @else
    <div class="bg-white rounded-xl border overflow-hidden">
        <div class="p-5 border-b"><h2 class="text-lg font-bold">{{ $staff->full_name }} — Annual Payroll History</h2><p class="text-xs text-gray-500">Employee {{ $staff->employee_number }} · Year {{ $year }} · {{ $items->count() }} months recorded</p></div>
        <table class="w-full text-xs">
            <thead class="bg-gray-50"><tr>
                <th class="table-header">Month</th>
                <th class="table-header">Run</th>
                <th class="table-header text-right">Gross</th>
                <th class="table-header text-right">Taxable</th>
                <th class="table-header text-right">PAYE</th>
                <th class="table-header text-right">SHIF</th>
                <th class="table-header text-right">NSSF</th>
                <th class="table-header text-right">AHL</th>
                <th class="table-header text-right">Net</th>
                <th class="table-header"></th>
            </tr></thead>
            <tbody class="divide-y divide-gray-50">
            @foreach($items as $i)
                <tr>
                    <td class="table-cell">{{ $i->run->month_label ?? '-' }}</td>
                    <td class="table-cell text-gray-500">{{ $i->run->run_number ?? '' }}</td>
                    <td class="table-cell text-right">{{ number_format($i->gross_pay) }}</td>
                    <td class="table-cell text-right">{{ number_format($i->taxable_pay) }}</td>
                    <td class="table-cell text-right">{{ number_format($i->paye) }}</td>
                    <td class="table-cell text-right">{{ number_format($i->shif) }}</td>
                    <td class="table-cell text-right">{{ number_format($i->nssf_employee) }}</td>
                    <td class="table-cell text-right">{{ number_format($i->ahl_employee) }}</td>
                    <td class="table-cell text-right font-semibold text-green-700">{{ number_format($i->net_pay) }}</td>
                    <td class="table-cell"><a href="{{ route('payroll.payslip', $i->id) }}" target="_blank" class="text-xs" style="color:#5c1269">Slip →</a></td>
                </tr>
            @endforeach
            </tbody>
            <tfoot class="bg-purple-50 font-bold">
                <tr><td colspan="2" class="table-cell">YTD TOTAL</td>
                    <td class="table-cell text-right">{{ number_format($items->sum('gross_pay')) }}</td>
                    <td class="table-cell text-right">{{ number_format($items->sum('taxable_pay')) }}</td>
                    <td class="table-cell text-right">{{ number_format($items->sum('paye')) }}</td>
                    <td class="table-cell text-right">{{ number_format($items->sum('shif')) }}</td>
                    <td class="table-cell text-right">{{ number_format($items->sum('nssf_employee')) }}</td>
                    <td class="table-cell text-right">{{ number_format($items->sum('ahl_employee')) }}</td>
                    <td class="table-cell text-right text-green-700">{{ number_format($items->sum('net_pay')) }}</td>
                    <td></td>
                </tr>
            </tfoot>
        </table>
    </div>
    @endif
@endif

{{-- ═══════════ STATUTORY SUMMARY ═══════════ --}}
@if($reportType==='statutory_summary')
    @php $rows = $data['rows'] ?? collect(); @endphp
    <div class="bg-white rounded-xl border overflow-hidden">
        <div class="p-5 border-b"><h2 class="text-lg font-bold">Annual Statutory Summary — {{ $year }}</h2><p class="text-xs text-gray-500">Per-month statutory amounts due. Use this to reconcile against KRA / SHA / NSSF returns.</p></div>
        <table class="w-full text-xs">
            <thead class="bg-gray-50"><tr>
                <th class="table-header">Month</th>
                <th class="table-header">Run</th>
                <th class="table-header text-right">PAYE</th>
                <th class="table-header text-right">SHIF</th>
                <th class="table-header text-right">NSSF (E+E)</th>
                <th class="table-header text-right">AHL (E+E)</th>
                <th class="table-header text-right">Total Statutory</th>
            </tr></thead>
            <tbody class="divide-y divide-gray-50">
            @foreach($rows as $r)
                @php
                    $nssf = $r->total_nssf_employee + $r->total_nssf_employer;
                    $ahl = $r->total_ahl_employee + $r->total_ahl_employer;
                    $tot = $r->total_paye + $r->total_shif + $nssf + $ahl;
                @endphp
                <tr>
                    <td class="table-cell font-medium">{{ $r->month_label }}</td>
                    <td class="table-cell text-gray-500">{{ $r->run_number }}</td>
                    <td class="table-cell text-right">{{ number_format($r->total_paye) }}</td>
                    <td class="table-cell text-right">{{ number_format($r->total_shif) }}</td>
                    <td class="table-cell text-right">{{ number_format($nssf) }}</td>
                    <td class="table-cell text-right">{{ number_format($ahl) }}</td>
                    <td class="table-cell text-right font-semibold">{{ number_format($tot) }}</td>
                </tr>
            @endforeach
            </tbody>
            <tfoot class="bg-purple-50 font-bold">
                <tr><td colspan="2" class="table-cell">TOTAL — {{ $year }}</td>
                    <td class="table-cell text-right">{{ number_format($rows->sum('total_paye')) }}</td>
                    <td class="table-cell text-right">{{ number_format($rows->sum('total_shif')) }}</td>
                    <td class="table-cell text-right">{{ number_format($rows->sum('total_nssf_employee') + $rows->sum('total_nssf_employer')) }}</td>
                    <td class="table-cell text-right">{{ number_format($rows->sum('total_ahl_employee') + $rows->sum('total_ahl_employer')) }}</td>
                    <td class="table-cell text-right">{{ number_format($rows->sum('total_paye') + $rows->sum('total_shif') + $rows->sum('total_nssf_employee') + $rows->sum('total_nssf_employer') + $rows->sum('total_ahl_employee') + $rows->sum('total_ahl_employer')) }}</td>
                </tr>
            </tfoot>
        </table>
    </div>
@endif

{{-- ═══════════ EMPLOYER CONTRIBUTIONS ═══════════ --}}
@if($reportType==='employer_contributions')
    @php $run = $data['run'] ?? null; @endphp
    @if(!$run)
    <div class="bg-white rounded-xl border p-8 text-center text-sm text-gray-400">No payroll run found for {{ \Carbon\Carbon::parse($month.'-01')->format('F Y') }}.</div>
    @else
    <div class="bg-white rounded-xl border p-6">
        <h2 class="text-lg font-bold mb-1">Employer Contributions — {{ $run->month_label }}</h2>
        <p class="text-xs text-gray-500 mb-4">Run {{ $run->run_number }} · The amounts the hospital pays on top of gross salaries.</p>
        <div class="grid grid-cols-1 md:grid-cols-3 gap-3">
            <div class="bg-purple-50 rounded-xl p-4">
                <p class="text-xs text-gray-500 uppercase font-semibold">NSSF Employer</p>
                <p class="text-2xl font-bold mt-1" style="color:#5c1269">{{ number_format($run->total_nssf_employer) }}</p>
            </div>
            <div class="bg-purple-50 rounded-xl p-4">
                <p class="text-xs text-gray-500 uppercase font-semibold">AHL Employer</p>
                <p class="text-2xl font-bold mt-1" style="color:#5c1269">{{ number_format($run->total_ahl_employer) }}</p>
            </div>
            <div class="bg-purple-50 rounded-xl p-4 border-2 border-purple-200">
                <p class="text-xs text-gray-500 uppercase font-semibold">Total Employer Burden</p>
                <p class="text-2xl font-bold mt-1" style="color:#5c1269">{{ number_format($run->total_nssf_employer + $run->total_ahl_employer) }}</p>
            </div>
        </div>
        <div class="mt-6 grid grid-cols-2 gap-4 text-sm">
            <div class="border rounded p-4">
                <p class="text-xs text-gray-500 uppercase font-semibold">Gross Salaries</p>
                <p class="text-xl font-bold mt-1">KES {{ number_format($run->total_gross) }}</p>
            </div>
            <div class="border-2 border-green-200 bg-green-50 rounded p-4">
                <p class="text-xs text-gray-500 uppercase font-semibold">Total Cost to Hospital</p>
                <p class="text-xl font-bold mt-1 text-green-700">KES {{ number_format($run->total_employer_cost) }}</p>
                <p class="text-xs text-gray-500 mt-1">Gross + Employer NSSF + Employer AHL</p>
            </div>
        </div>
    </div>
    @endif
@endif

{{-- ═══════════ PAYMENT SCHEDULE ═══════════ --}}
@if($reportType==='payment_schedule')
    @php $run = $data['run'] ?? null; $items = $data['items'] ?? collect(); @endphp
    @if(!$run)
    <div class="bg-white rounded-xl border p-8 text-center text-sm text-gray-400">No payroll run found for {{ \Carbon\Carbon::parse($month.'-01')->format('F Y') }}.</div>
    @else
    <div class="bg-white rounded-xl border overflow-hidden">
        <div class="p-5 border-b flex justify-between items-center">
            <div><h2 class="text-lg font-bold">Payment Schedule — {{ $run->month_label }}</h2><p class="text-xs text-gray-500">Run {{ $run->run_number }} · {{ $items->count() }} payments</p></div>
            <a href="{{ route('payroll.reports', ['report'=>'bank_export', 'month'=>$month]) }}" class="btn-success text-xs">⬇ Export Bank CSV</a>
        </div>
        <table class="w-full text-xs">
            <thead class="bg-gray-50"><tr>
                <th class="table-header">Emp No.</th>
                <th class="table-header">Name</th>
                <th class="table-header">Method</th>
                <th class="table-header">Bank / M-Pesa</th>
                <th class="table-header">Account / Phone</th>
                <th class="table-header text-right">Net Amount</th>
                <th class="table-header">Reference</th>
            </tr></thead>
            <tbody class="divide-y divide-gray-50">
                @foreach($items as $i)
                <tr>
                    <td class="table-cell">{{ $i->employee_number }}</td>
                    <td class="table-cell font-medium">{{ $i->full_name }}</td>
                    <td class="table-cell uppercase">{{ $i->payment_method }}</td>
                    <td class="table-cell">{{ $i->payment_method === 'mobile' ? 'M-PESA' : ($i->bank_name ?? '-') }}</td>
                    <td class="table-cell">{{ $i->payment_method === 'mobile' ? $i->mobile_payment_number : ($i->bank_account ?? '-') }}</td>
                    <td class="table-cell text-right font-semibold">{{ number_format($i->net_pay, 2) }}</td>
                    <td class="table-cell text-gray-500">{{ $run->run_number }}-{{ $i->employee_number }}</td>
                </tr>
                @endforeach
            </tbody>
            <tfoot class="bg-purple-50 font-bold">
                <tr><td colspan="5" class="table-cell">TOTAL</td><td class="table-cell text-right">{{ number_format($items->sum('net_pay'), 2) }}</td><td></td></tr>
            </tfoot>
        </table>
    </div>
    @endif
@endif

{{-- ═══════════ REMITTANCES BY BODY ═══════════ --}}
@if($reportType==='remittance_by_body')
    @php $rows = $data['rows'] ?? collect(); @endphp
    <div class="bg-white rounded-xl border overflow-hidden">
        <div class="p-5 border-b"><h2 class="text-lg font-bold">Remittances by Statutory Body — {{ $year }}</h2></div>
        <table class="w-full text-sm">
            <thead class="bg-gray-50"><tr>
                <th class="table-header">Body</th>
                <th class="table-header text-right">Total Due</th>
                <th class="table-header text-right">Paid</th>
                <th class="table-header text-right">Outstanding</th>
                <th class="table-header text-center">Late Payments</th>
            </tr></thead>
            <tbody class="divide-y divide-gray-50">
            @foreach($rows as $r)
                <tr>
                    <td class="table-cell font-medium">{{ $r->label }}</td>
                    <td class="table-cell text-right">{{ number_format($r->total_due) }}</td>
                    <td class="table-cell text-right text-green-700">{{ number_format($r->total_paid) }}</td>
                    <td class="table-cell text-right text-amber-700">{{ number_format($r->total_outstanding) }}</td>
                    <td class="table-cell text-center">@if($r->late_count > 0)<span class="badge badge-danger">{{ $r->late_count }}</span>@else <span class="text-gray-400">0</span>@endif</td>
                </tr>
            @endforeach
            </tbody>
        </table>
    </div>
@endif

{{-- ═══════════ YTD EARNINGS ═══════════ --}}
@if($reportType==='ytd_earnings')
    @php $rows = $data['rows'] ?? collect(); @endphp
    <div class="bg-white rounded-xl border overflow-hidden">
        <div class="p-5 border-b"><h2 class="text-lg font-bold">Year-to-Date Earnings per Employee — {{ $year }}</h2><p class="text-xs text-gray-500">Useful for KRA P9A forms, loan letters, and certificates of earnings.</p></div>
        <div class="overflow-x-auto">
        <table class="w-full text-xs">
            <thead class="bg-gray-50"><tr>
                <th class="table-header">Emp No.</th>
                <th class="table-header">Name</th>
                <th class="table-header text-center">Months</th>
                <th class="table-header text-right">YTD Gross</th>
                <th class="table-header text-right">YTD PAYE</th>
                <th class="table-header text-right">YTD SHIF</th>
                <th class="table-header text-right">YTD NSSF</th>
                <th class="table-header text-right">YTD AHL</th>
                <th class="table-header text-right">YTD Net</th>
            </tr></thead>
            <tbody class="divide-y divide-gray-50">
            @foreach($rows as $r)
                <tr>
                    <td class="table-cell">{{ $r->employee_number }}</td>
                    <td class="table-cell font-medium">{{ $r->full_name }}</td>
                    <td class="table-cell text-center">{{ $r->months_paid }}</td>
                    <td class="table-cell text-right">{{ number_format($r->ytd_gross) }}</td>
                    <td class="table-cell text-right">{{ number_format($r->ytd_paye) }}</td>
                    <td class="table-cell text-right">{{ number_format($r->ytd_shif) }}</td>
                    <td class="table-cell text-right">{{ number_format($r->ytd_nssf) }}</td>
                    <td class="table-cell text-right">{{ number_format($r->ytd_ahl) }}</td>
                    <td class="table-cell text-right font-semibold text-green-700">{{ number_format($r->ytd_net) }}</td>
                </tr>
            @endforeach
            </tbody>
            <tfoot class="bg-purple-50 font-bold">
                <tr><td colspan="3" class="table-cell">TOTAL</td>
                    <td class="table-cell text-right">{{ number_format($rows->sum('ytd_gross')) }}</td>
                    <td class="table-cell text-right">{{ number_format($rows->sum('ytd_paye')) }}</td>
                    <td class="table-cell text-right">{{ number_format($rows->sum('ytd_shif')) }}</td>
                    <td class="table-cell text-right">{{ number_format($rows->sum('ytd_nssf')) }}</td>
                    <td class="table-cell text-right">{{ number_format($rows->sum('ytd_ahl')) }}</td>
                    <td class="table-cell text-right text-green-700">{{ number_format($rows->sum('ytd_net')) }}</td>
                </tr>
            </tfoot>
        </table>
        </div>
    </div>
@endif

@endsection