@extends('layouts.app')
@section('title', 'Reports')
@section('content')
    <p class="eyebrow">Operational reporting</p><h1>Reports</h1><p>Projects, workload, support and payments within your permissions. Dates use {{ config('app.timezone') }}.</p>
    <form method="GET" class="row g-3 align-items-end mb-4"><div class="col-md-3"><label for="from">From</label><input type="date" id="from" name="from" value="{{ $filters['from'] }}" required></div><div class="col-md-3"><label for="to">To (inclusive)</label><input type="date" id="to" name="to" value="{{ $filters['to'] }}" required></div><div class="col-md-4"><label for="market_id">Market</label><select id="market_id" name="market_id"><option value="">All markets</option>@foreach($markets as $market)<option value="{{ $market->id }}" @selected((string) ($filters['market_id'] ?? '') === (string) $market->id)>{{ $market->name }}</option>@endforeach</select></div><div class="col-md-2"><button type="submit" class="btn btn-primary">Run report</button></div></form>
    <nav class="d-flex flex-wrap gap-3 mb-4" aria-label="Report exports"><a href="{{ route('reports.export', ['type' => 'projects', ...$filters]) }}">Export projects CSV</a><a href="{{ route('reports.export', ['type' => 'tickets', ...$filters]) }}">Export tickets CSV</a>@if(auth()->user()->hasPermissionTo('finance.view'))<a href="{{ route('reports.export', ['type' => 'payments', ...$filters]) }}">Export payments CSV</a>@endif</nav>
    <section class="row g-3 mb-4" aria-label="Operational metrics">@foreach(['Projects created in period' => $projectCount, 'Overdue production targets' => $overdueCount, 'Completed in period' => $completedCount, 'QC returns in period' => $qcReturns + $finalQcReturns] as $label => $count)<div class="col-6 col-lg-3"><article class="card"><span class="metric-label">{{ $label }}</span><span class="metric">{{ $count }}</span></article></div>@endforeach</section>
    <p class="small">Project stages, workload and correction counts describe the current state of projects created in the selected period. Completion totals and average turnaround use projects completed in the period, including earlier submissions.</p>
    <div class="row g-4 mb-4"><div class="col-lg-6"><section class="card h-100"><h2>Projects by stage</h2>@forelse($byStatus as $stage)<div class="mt-3"><div class="d-flex justify-content-between gap-3"><label for="stage-{{ $stage->status }}" class="small m-0">{{ App\Models\Project::STATUSES[$stage->status] }}</label><strong>{{ $stage->total }}</strong></div><progress id="stage-{{ $stage->status }}" class="report-progress" value="{{ $stage->total }}" max="{{ max(1, $projectCount) }}">{{ $stage->total }}</progress></div>@empty<p class="mt-3">No authorized projects in this period.</p>@endforelse</section></div><div class="col-lg-6"><section class="card h-100"><h2>Market & turnaround</h2><ul class="mt-3">@forelse($byMarket as $group)<li>{{ $group->market->name }}: {{ $group->total }}</li>@empty<li>No market totals.</li>@endforelse</ul><p class="mb-0">Average submission-to-completion: <strong>{{ $turnaroundDays !== null ? number_format($turnaroundDays, 2).' days' : 'No completed projects' }}</strong></p><p class="small mt-3 mb-0">Regular QC returns: {{ $qcReturns }} &middot; Final QC returns: {{ $finalQcReturns }}</p></section></div></div>
    <section class="card mb-4"><h2>Employee workload</h2><div class="table-responsive mt-3"><table class="table"><thead><tr><th>Employee</th><th>Active projects</th><th>Overdue</th><th>Corrections</th><th>QC returned</th></tr></thead><tbody>@forelse($workload as $employee)<tr><td>{{ $employee->name }}</td><td>{{ $employee->active_projects }}</td><td>{{ $employee->overdue_projects }}</td><td>{{ $employee->correction_projects }}</td><td>{{ $employee->qc_returned_projects }}</td></tr>@empty<tr><td colspan="5">No active assignments in this report scope.</td></tr>@endforelse</tbody></table></div></section>
    <div class="row g-4 mb-4"><div class="col-lg-5"><section class="card h-100"><h2>Revision cycles</h2><ul class="mt-3">@forelse($corrections as $cycle)<li>{{ ucfirst(str_replace('_', ' ', $cycle->status)) }}: {{ $cycle->total }}</li>@empty<li>No correction cycles.</li>@endforelse</ul><p class="small mb-0">Oldest open cycle created: {{ $oldestCorrection ? Illuminate\Support\Carbon::parse($oldestCorrection)->format('d M Y H:i') : 'None' }}</p></section></div><div class="col-lg-7"><section class="card h-100"><h2>Support performance</h2><p class="mt-3">{{ $ticketCount }} tickets opened in period &middot; {{ $overdueTickets }} currently overdue &middot; {{ $escalatedTickets }} active escalations</p><div class="row"><div class="col-md-6"><h3 class="fs-6">By stage</h3><ul>@forelse($ticketsByStatus as $group)<li>{{ App\Models\Ticket::STATUSES[$group->status] }}: {{ $group->total }}</li>@empty<li>No tickets.</li>@endforelse</ul></div><div class="col-md-6"><h3 class="fs-6">By category</h3><ul>@foreach($ticketsByCategory as $group)<li>{{ $group->category->name }}: {{ $group->total }}</li>@endforeach</ul></div></div></section></div></div>
    @if(auth()->user()->hasPermissionTo('finance.view'))<section class="card mb-4"><h2>Verified payments & outstanding balances</h2><p class="small mt-2">Received totals use payment dates in the selected period. Refunds use settlement dates; net receipts are received less refunded. Outstanding balances use accepted quotations created in the period, less all verified payments to date; credit notes offset refunded amounts. Currencies and precisions are kept separate.</p><div class="table-responsive"><table class="table"><thead><tr><th>Currency</th><th>Payments</th><th>Received</th><th>Refunded</th><th>Net receipts</th><th>Outstanding</th></tr></thead><tbody>@forelse($finance as $group)<tr><td>{{ $group['currency'] }}</td><td>{{ $group['payments'] }}</td><td>{{ App\Support\Money::format($group['received'], $group['precision']) }}</td><td>{{ App\Support\Money::format($group['refunded'] ?? 0, $group['precision']) }}</td><td>{{ App\Support\Money::format($group['received'] - ($group['refunded'] ?? 0), $group['precision']) }}</td><td>{{ App\Support\Money::format($group['outstanding'], $group['precision']) }}</td></tr>@empty<tr><td colspan="6">No verified payments, refunds or accepted quotations in this period.</td></tr>@endforelse</tbody></table></div></section>@endif
    <section class="card p-0 overflow-hidden"><h2 class="p-4 mb-0">Projects in report</h2><div class="table-responsive"><table class="table mb-0"><thead><tr><th>Project</th><th>Market</th><th>Team</th><th>Stage</th></tr></thead><tbody>@forelse($projects as $project)<tr><td><a href="{{ route('projects.show', $project) }}">{{ $project->title }}</a></td><td>{{ $project->market->name }}</td><td>{{ $project->team?->name ?: 'Unallocated' }}</td><td>{{ App\Models\Project::STATUSES[$project->status] }}</td></tr>@empty<tr><td colspan="4" class="p-4">No authorized projects match this report.</td></tr>@endforelse</tbody></table></div></section><div class="mt-4">{{ $projects->links() }}</div>
@endsection