@extends('layouts.app')
@section('title', ($source ?? 'pms') === 'pcfms' ? 'PCFMS PC Pipeline Report' : 'PMS PC Pipeline Report')

@push('styles')
<link rel="stylesheet" href="{{ asset('css/dynamic-dashboard.css') }}?v={{ filemtime(public_path('css/dynamic-dashboard.css')) }}">
@endpush

@section('contents')
@php
    $reportSource = $source ?? ($report['source'] ?? 'pms');
    $isPmsReport = $reportSource === 'pms';
    $rows = $report['rows'] ?? [];
    $totals = $report['totals'] ?? [];
    $selectedYear = $report['budget_year'] ?? $selectedYear ?? '';
    $fmtCount = static fn ($n) => number_format((int) $n);
    $fmtMoney = static fn ($n) => number_format((float) $n, 1).' M';
    $bmsDash = static fn () => '—';
    $colCount = 13;
@endphp
<section class="content dd-dashboard dd-pc-pipeline-report">
    <div class="container-fluid">
        <div class="dd-portfolio-report__hero">
            <div>
                <a href="{{ route('dashboard') }}" class="dd-priority-page__back"><i class="fas fa-arrow-left"></i> Back to dashboard</a>
                <h1 class="dd-portfolio-report__title">
                    @if ($isPmsReport)
                        <span class="dd-dashboard-fix__badge dd-dashboard-fix__badge--pms">PMS</span>
                        PC Pipeline Report
                    @else
                        <span class="dd-dashboard-fix__badge dd-dashboard-fix__badge--pcfms">PCFMS</span>
                        PC Pipeline Report
                    @endif
                </h1>
                <p class="dd-portfolio-report__lead">
                    @if ($isPmsReport)
                        Department and sub-department breakdown of BPMS scheme inventory (New During the Year and Unapproved Carry Forward) and native PMS PC-I / PDWP pipeline metrics.
                    @else
                        Department and sub-department breakdown of imported PCFMS PC-I / PDWP pipeline metrics for the selected budget year.
                    @endif
                </p>
            </div>
            <div class="dd-portfolio-report__year-wrap">
                <label for="dd-pc-pipeline-report-year">Budget year</label>
                <select id="dd-pc-pipeline-report-year" class="form-control dd-attention-year-select">
                    @foreach ($budgetYears as $yearOption)
                        <option value="{{ $yearOption['id'] }}" @selected($yearOption['id'] === $selectedYear)>
                            {{ $yearOption['label'] }}
                        </option>
                    @endforeach
                </select>
            </div>
        </div>

        <div class="dd-pc-pipeline-report__panel">
            <div class="table-responsive">
                <table class="table table-sm table-bordered dd-pc-pipeline-report__table mb-0">
                    <thead>
                        <tr>
                            <th class="dd-pc-pipeline-report__col-dept">Department</th>
                            @if ($isPmsReport)
                                <th class="text-right">New Sch<br>During Year</th>
                                <th class="text-right">Unapproved<br>Carry Fwd</th>
                                <th class="text-right">Est<br>Cost</th>
                                <th class="text-right">Allocation</th>
                            @else
                                <th class="text-right">New Sch<br>During Year</th>
                                <th class="text-right">Unapproved<br>Carry Fwd</th>
                                <th class="text-right">Est<br>Cost</th>
                                <th class="text-right">Allocation</th>
                            @endif
                            <th class="text-right">PC-I</th>
                            <th class="text-right">Clr<br>PDWP</th>
                            <th class="text-right">Def<br>PDWP</th>
                            <th class="text-right">MoM<br>PDWP</th>
                            <th class="text-right">PDWP<br>Held</th>
                            <th class="text-right">Appr<br>PDWP</th>
                            <th class="text-right">MoM<br>Issued</th>
                            <th class="text-right">Advise</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse ($rows as $row)
                            <tr @class(['dd-pc-pipeline-report__dept-row' => ($row['row_type'] ?? '') === 'department', 'dd-pc-pipeline-report__sub-row' => ($row['row_type'] ?? '') === 'sub_department'])>
                                <td>{{ $row['label'] ?? '' }}</td>
                                @if ($isPmsReport)
                                    <td class="text-right text-monospace">{{ $fmtCount($row['new_schemes'] ?? 0) }}</td>
                                    <td class="text-right text-monospace">{{ $fmtCount($row['carry_forward'] ?? 0) }}</td>
                                    <td class="text-right text-monospace">{{ $fmtMoney($row['estimated_cost'] ?? 0) }}</td>
                                    <td class="text-right text-monospace">{{ $fmtMoney($row['allocation'] ?? 0) }}</td>
                                @else
                                    <td class="text-right text-muted">{{ $bmsDash() }}</td>
                                    <td class="text-right text-muted">{{ $bmsDash() }}</td>
                                    <td class="text-right text-muted">{{ $bmsDash() }}</td>
                                    <td class="text-right text-muted">{{ $bmsDash() }}</td>
                                @endif
                                <td class="text-right text-monospace">{{ $fmtCount($row['pc1_created'] ?? 0) }}</td>
                                <td class="text-right text-monospace">{{ $fmtCount($row['cleared_by_pdwp'] ?? 0) }}</td>
                                <td class="text-right text-monospace">{{ $fmtCount($row['deferred_by_pdwp'] ?? 0) }}</td>
                                <td class="text-right text-monospace">{{ $fmtCount($row['minutes_by_pdwp'] ?? 0) }}</td>
                                <td class="text-right text-monospace">{{ $fmtCount($row['pdwp_meeting_held'] ?? 0) }}</td>
                                <td class="text-right text-monospace">{{ $fmtCount($row['approved_by_pdwp'] ?? 0) }}</td>
                                <td class="text-right text-monospace">{{ $fmtCount($row['minutes_issued'] ?? 0) }}</td>
                                <td class="text-right text-monospace">{{ $fmtCount($row['advise_issued'] ?? 0) }}</td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="{{ $colCount }}" class="text-center text-muted py-4">No department data for this budget year.</td>
                            </tr>
                        @endforelse
                    </tbody>
                    @if ($rows !== [])
                        <tfoot>
                            <tr class="font-weight-bold bg-light">
                                <td>Total (departments)</td>
                                @if ($isPmsReport)
                                    <td class="text-right text-monospace">{{ $fmtCount($totals['new_schemes'] ?? 0) }}</td>
                                    <td class="text-right text-monospace">{{ $fmtCount($totals['carry_forward'] ?? 0) }}</td>
                                    <td class="text-right text-monospace">{{ $fmtMoney($totals['estimated_cost'] ?? 0) }}</td>
                                    <td class="text-right text-monospace">{{ $fmtMoney($totals['allocation'] ?? 0) }}</td>
                                @else
                                    <td class="text-right text-muted">{{ $bmsDash() }}</td>
                                    <td class="text-right text-muted">{{ $bmsDash() }}</td>
                                    <td class="text-right text-muted">{{ $bmsDash() }}</td>
                                    <td class="text-right text-muted">{{ $bmsDash() }}</td>
                                @endif
                                <td class="text-right text-monospace">{{ $fmtCount($totals['pc1_created'] ?? 0) }}</td>
                                <td class="text-right text-monospace">{{ $fmtCount($totals['cleared_by_pdwp'] ?? 0) }}</td>
                                <td class="text-right text-monospace">{{ $fmtCount($totals['deferred_by_pdwp'] ?? 0) }}</td>
                                <td class="text-right text-monospace">{{ $fmtCount($totals['minutes_by_pdwp'] ?? 0) }}</td>
                                <td class="text-right text-monospace">{{ $fmtCount($totals['pdwp_meeting_held'] ?? 0) }}</td>
                                <td class="text-right text-monospace">{{ $fmtCount($totals['approved_by_pdwp'] ?? 0) }}</td>
                                <td class="text-right text-monospace">{{ $fmtCount($totals['minutes_issued'] ?? 0) }}</td>
                                <td class="text-right text-monospace">{{ $fmtCount($totals['advise_issued'] ?? 0) }}</td>
                            </tr>
                        </tfoot>
                    @endif
                </table>
            </div>
        </div>
    </div>
</section>
@endsection

@push('scripts')
<script>
(function () {
    var yearSelect = document.getElementById('dd-pc-pipeline-report-year');
    if (!yearSelect) return;
    var baseUrl = @json(route('dashboard.pc-pipeline-report'));
    var source = @json($reportSource);
    yearSelect.addEventListener('change', function () {
        var year = yearSelect.value || '';
        var params = [];
        if (source) params.push('source=' + encodeURIComponent(source));
        if (year) params.push('year=' + encodeURIComponent(year));
        window.location.href = baseUrl + (params.length ? ('?' + params.join('&')) : '');
    });
})();
</script>
@endpush