@extends('layouts.app')

@section('title', 'NWRB Section 18 Data Sheet')

@section('content')
@php
    $cur = $currency === 'PHP' ? '₱' : $currency . ' ';

    // Null means "not measured for this month" — shown blank, never as zero.
    $render = function ($value, $format) use ($cur) {
        if ($value === null) {
            return '—';
        }

        return match ($format) {
            'int' => number_format($value),
            'pct' => number_format($value, 1) . '%',
            'money' => $cur . number_format($value, 2),
            default => number_format($value, 2),
        };
    };
@endphp

<div class="container-fluid">
    <div class="mb-4">
        <a href="{{ route('reports.index') }}" class="btn btn-link btn-sm px-0 text-primary">
            <i class="fas fa-arrow-left me-1"></i> Back to Reports
        </a>
        <h2 class="mb-1"><i class="fas fa-file-contract me-2"></i>NWRB Section 18 — Financial &amp; Technical Data Sheet</h2>
        <p class="text-muted small mb-0">
            Monthly and year-to-date figures for the NWRB Annual Report attachment (due May 31)
        </p>
    </div>

    <div class="card mb-4">
        <div class="card-body">
            <form method="GET" class="row g-3 align-items-end">
                <div class="col-md-2">
                    <label class="form-label small text-muted text-uppercase fw-bold">Year</label>
                    <select name="year" class="form-select">
                        @foreach($years as $y)
                            <option value="{{ $y }}" @selected($year === $y)>{{ $y }}</option>
                        @endforeach
                    </select>
                </div>
                @if($isSuperAdmin)
                    <div class="col-md-4">
                        <label class="form-label small text-muted text-uppercase fw-bold">Company</label>
                        <select name="company_id" class="form-select">
                            <option value="">All Companies</option>
                            @foreach($companies as $c)
                                <option value="{{ $c->id }}" @selected($companyId === $c->id)>{{ $c->name }}</option>
                            @endforeach
                        </select>
                    </div>
                @endif
                <div class="col-md-2">
                    <button class="btn btn-primary w-100"><i class="fas fa-filter me-1"></i> Apply</button>
                </div>
            </form>

            <div class="d-flex justify-content-between align-items-center mt-3 pt-3 border-top">
                <small class="text-muted">
                    <i class="far fa-building me-1"></i>
                    {{ $company->name ?? 'All companies' }} &middot; calendar year {{ $year }}
                </small>
                <div class="d-flex gap-2">
                    <a href="{{ request()->fullUrlWithQuery(['export' => 'csv']) }}" class="btn btn-sm btn-outline-success">
                        <i class="fas fa-file-csv me-1"></i> Export CSV
                    </a>
                    <button type="button" onclick="window.print()" class="btn btn-sm btn-outline-secondary">
                        <i class="fas fa-print me-1"></i> Print
                    </button>
                </div>
            </div>
        </div>
    </div>

    @if(!$hasProduction)
        <div class="alert alert-warning d-flex align-items-start">
            <i class="fas fa-triangle-exclamation me-2 mt-1"></i>
            <div>
                <strong>No water production recorded for {{ $year }}.</strong>
                Non-revenue water — NWRB's headline KPI — cannot be computed without it.
                <a href="{{ route('water-productions.index', ['year' => $year]) }}" class="alert-link">Record monthly production</a>
                to complete this sheet.
            </div>
        </div>
    @endif

    @if($hasProduction && $missingProduction->isNotEmpty())
        <div class="alert alert-warning d-flex align-items-start">
            <i class="fas fa-triangle-exclamation me-2 mt-1"></i>
            <div>
                <strong>Production is missing for {{ $missingProduction->implode(', ') }}.</strong>
                Those months were billed but have no production recorded, so they are left blank and excluded from the
                year-to-date NRW figure — the YTD rate covers only the months that have both.
                <a href="{{ route('water-productions.index', ['year' => $year]) }}" class="alert-link">Fill in the gaps</a>
                before filing.
            </div>
        </div>
    @endif

    @if($unclassified > 0)
        <div class="alert alert-info d-flex align-items-start">
            <i class="fas fa-circle-info me-2 mt-1"></i>
            <div>
                <strong>{{ number_format($unclassified) }} connection(s) are unclassified.</strong>
                NWRB requires connections to be split into residential, commercial/industrial and public taps.
                Set the NWRB classification on each <a href="{{ route('tier-groups.index') }}" class="alert-link">tier group</a>
                and the clients in it will be counted correctly.
            </div>
        </div>
    @endif

    <div class="card">
        <div class="table-responsive">
            <table class="table table-sm table-hover mb-0 report-table">
                <thead class="table-light">
                    <tr>
                        <th class="report-sticky-col">Line Item</th>
                        @foreach($months as $label)
                            <th class="text-end">{{ $label }}</th>
                        @endforeach
                        <th class="text-end table-secondary">YTD</th>
                    </tr>
                </thead>
                <tbody>
                    @php $currentGroup = null; @endphp
                    @foreach($sheet as $row)
                        @if($row['group'] !== $currentGroup)
                            @php $currentGroup = $row['group']; @endphp
                            <tr class="table-light">
                                <td colspan="14" class="fw-bold text-uppercase small">{{ $currentGroup }}</td>
                            </tr>
                        @endif
                        <tr class="{{ ($row['strong'] ?? false) ? 'fw-semibold' : '' }}">
                            <td class="report-sticky-col ps-4">{{ $row['label'] }}</td>
                            @foreach(array_keys($months) as $key)
                                <td class="text-end">{{ $render($row['values'][$key], $row['format']) }}</td>
                            @endforeach
                            <td class="text-end table-secondary fw-semibold">
                                {{ $render($row['ytd_value'], $row['format']) }}
                            </td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        </div>
    </div>

    <div class="card mt-3">
        <div class="card-body">
            <h6 class="mb-2">Notes on this sheet</h6>
            <ul class="text-muted small mb-0">
                <li><strong>Active connections</strong> are counted as at each month end from the client's registration date, split by the NWRB classification on their tier group.</li>
                <li><strong>Non-revenue water</strong> = total supply (produced + purchased) − volume billed in the same month.</li>
                <li><strong>Collection efficiency</strong> = amount collected ÷ amount billed within the month. Collections often settle earlier months' bills, so treat it as an indicator.</li>
                <li><strong>Accounts receivable</strong> is reconstructed as billed-to-date minus collected-to-date; the system keeps no historical month-end snapshot.</li>
                <li>Expenses, income statement, balance sheet and assets in service are <strong>not</strong> produced here — they come from the company's books and must be audited and notarised before filing. See <code>NWRB_REPORTING.md</code>.</li>
            </ul>
        </div>
    </div>
</div>

<style>
    @media print {
        .aside-container, .topnavbar-wrapper, .footer-container,
        .card form, .btn, .alert { display: none !important; }
        .section-container { margin-left: 0 !important; width: 100% !important; }
        .table { font-size: 9px; }
    }
    .report-table thead th { white-space: nowrap; font-size: .72rem; text-transform: uppercase; }
    .report-table td, .report-table th { vertical-align: middle; white-space: nowrap; }
    .report-sticky-col { position: sticky; left: 0; background: #fff; z-index: 1; }
    .report-table tbody tr.table-light .report-sticky-col { background: #f8f9fa; }
</style>
@endsection