@extends('layouts.app')
@section('title', 'Reports')
@section('content')
<div class="page-head"><div><div class="eyebrow">Reporting workspace</div><h1>Reports</h1><p>View governed workforce data and access standard organizational reports.</p></div><div class="report-tabs"><a class="active" href="#data">Data table</a><a href="#catalog">Report catalog</a></div></div>
<div class="grid four">
    <div class="card"><div class="card-label">Annual payroll exposure</div><div class="metric long mono">${{ number_format($analytics['annualPayroll']) }}</div><div class="trend">Active base salaries</div></div>
    <div class="card"><div class="card-label">Average base salary</div><div class="metric long mono">${{ number_format($analytics['averageSalary']) }}</div><div class="trend">Across active employees</div></div>
    <div class="card"><div class="card-label">Available leave</div><div class="metric">{{ number_format($analytics['availableLeave'],1) }}</div><div class="trend">Days across all leave ledgers</div></div>
    <div class="card"><div class="card-label">Archived documents</div><div class="metric">{{ $analytics['archivedDocuments'] }}</div><div class="trend">Private employee records</div></div>
</div>
<section class="panel section">
    <div class="section-title"><div><h2>Department workforce analysis</h2><p>Headcount and annual salary exposure by organization unit</p></div></div>
    <div class="table-wrap"><table class="data-table"><thead><tr><th>Department</th><th>Cost center</th><th>Headcount</th><th>Headcount plan</th><th>Open capacity</th><th class="right">Annual salaries</th><th class="right">Budget variance</th></tr></thead><tbody>@foreach($departmentSummary as $department)<tr><td><strong>{{ $department->name }}</strong></td><td class="mono muted">{{ $department->cost_center }}</td><td>{{ $department->employees_count }}</td><td>{{ $department->headcount_budget }}</td><td>{{ max($department->headcount_budget-$department->employees_count,0) }}</td><td class="right mono">${{ number_format($department->salary_total ?? 0) }}</td><td class="right mono">${{ number_format($department->annual_budget-($department->salary_total ?? 0)) }}</td></tr>@endforeach</tbody></table></div>
</section>
<section class="panel" id="data">
    <div class="section-title"><div><h2>▤ Workforce composition <span class="badge gray">{{ $employees->total() }} records</span></h2><p>A live, auditable view of the MySQL employee directory.</p></div><div style="display:flex;gap:8px;align-items:center"><span class="muted" data-selection-count>0 selected</span><button class="btn small">⇩ Export view</button></div></div>
    <form class="toolbar" method="get">
        <input class="input search" name="search" value="{{ $filters['search'] }}" placeholder="Search employee, role, department, manager...">
        <select class="select" name="department"><option value="">All departments</option>@foreach($departments as $item)<option value="{{ $item }}" @selected($filters['department']===$item)>{{ $item }}</option>@endforeach</select>
        <select class="select" name="status"><option value="">All statuses</option><option value="active" @selected($filters['status']==='active')>Active</option><option value="inactive" @selected($filters['status']==='inactive')>Inactive</option></select>
        <button class="btn" type="submit">Apply filters</button>
        <details class="column-picker"><summary class="btn">▥ Columns</summary><div class="column-menu">@foreach(['role'=>'Role','department'=>'Department','location'=>'Location','status'=>'Status','start'=>'Start date','manager'=>'Manager','salary'=>'Annual salary'] as $key=>$label)<label><span>{{ $label }}</span><input type="checkbox" data-column-toggle value="{{ $key }}" @checked(!in_array($key,['manager','salary']))></label>@endforeach</div></details>
    </form>
    <div class="table-wrap"><table class="data-table"><thead><tr><th><input type="checkbox" data-select-all></th>
        @php($sortLink=function($key) use($filters){return request()->fullUrlWithQuery(['sort'=>$key,'direction'=>$filters['sort']===$key&&$filters['direction']==='asc'?'desc':'asc','page'=>1]);})
        <th><a href="{{ $sortLink('name') }}">Employee ↕</a></th><th class="col-role"><a href="{{ $sortLink('role') }}">Role ↕</a></th><th class="col-department"><a href="{{ $sortLink('department') }}">Department ↕</a></th><th class="col-location">Location</th><th class="col-status"><a href="{{ $sortLink('status') }}">Status ↕</a></th><th class="col-start"><a href="{{ $sortLink('start_date') }}">Start date ↕</a></th><th class="col-manager hidden-column">Manager</th><th class="col-salary hidden-column right"><a href="{{ $sortLink('annual_salary') }}">Annual salary ↕</a></th></tr></thead><tbody>
        @forelse($employees as $employee)<tr><td><input type="checkbox" data-row-select></td><td><div class="person"><span class="avatar">{{ $employee->initials }}</span><div><strong>{{ $employee->name }}</strong><small>{{ $employee->email }}</small></div></div></td><td class="col-role">{{ $employee->role }}</td><td class="col-department">{{ $employee->department }}</td><td class="col-location muted">{{ $employee->location }}</td><td class="col-status"><span class="badge green">{{ $employee->status }}</span></td><td class="col-start">{{ $employee->start_date->format('Y-m-d') }}</td><td class="col-manager hidden-column">{{ $employee->manager }}</td><td class="col-salary hidden-column right mono">${{ number_format($employee->annual_salary,0) }}</td></tr>@empty<tr><td colspan="10" class="muted">No workforce records match the current filters.</td></tr>@endforelse
    </tbody></table></div><div class="table-footer"><span>Showing {{ $employees->firstItem() ?? 0 }}–{{ $employees->lastItem() ?? 0 }} of {{ $employees->total() }}</span><div class="pagination">@if($employees->onFirstPage())<span class="disabled">‹</span>@else<a href="{{ $employees->previousPageUrl() }}">‹</a>@endif<span>Page {{ $employees->currentPage() }} of {{ $employees->lastPage() }}</span>@if($employees->hasMorePages())<a href="{{ $employees->nextPageUrl() }}">›</a>@else<span class="disabled">›</span>@endif</div></div>
</section>
<section class="section" id="catalog"><div class="section-title" style="padding-left:0"><div><h2>Report catalog</h2><p>Approved report definitions and export formats</p></div></div><div class="grid four">@foreach($reports as $report)<article class="card catalog-card"><div class="card-label"><span class="badge">{{ $report['category'] }}</span><span>▤</span></div><h3>{{ $report['name'] }}</h3><p>{{ $report['description'] }}</p><div class="catalog-meta"><span>Last run: {{ $report['last_run'] }}</span><strong>{{ $report['format'] }}</strong></div><a class="btn" href="#data">View data</a></article>@endforeach</div></section>
@endsection