@extends('layouts.app')

@section('title', 'Water Production')

@section('content')
<div class="container-fluid">
    <div class="row mb-4">
        <div class="col-12 d-flex justify-content-between align-items-center">
            <div>
                <h2 class="mb-1"><i class="fas fa-water me-2"></i>Water Production</h2>
                <p class="text-muted small mb-0">
                    Monthly volume produced or purchased per source — the basis for non-revenue water in the NWRB report
                </p>
            </div>
            <a href="{{ route('water-productions.create') }}" class="btn btn-primary">
                <i class="fas fa-plus me-1"></i> Record Production
            </a>
        </div>
    </div>

    @if(session('success'))
        <div class="alert alert-success alert-dismissible fade show">
            {{ session('success') }}
            <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
        </div>
    @endif

    <div class="card mb-4">
        <div class="card-body">
            <form method="GET" class="row g-3 align-items-end">
                <div class="col-md-3">
                    <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 $company)
                                <option value="{{ $company->id }}" @selected($companyId === $company->id)>{{ $company->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>
    </div>

    <!-- Year summary -->
    <div class="row mb-4">
        <div class="col-md-3 col-sm-6 mb-3">
            <div class="card h-100 border-start border-4 border-primary">
                <div class="card-body">
                    <small class="text-muted text-uppercase fw-bold">Total Supply {{ $year }}</small>
                    <h4 class="mb-0 mt-2 text-primary">{{ number_format($summary['supply'], 2) }}</h4>
                    <small class="text-muted">cu.m produced + purchased</small>
                </div>
            </div>
        </div>
        <div class="col-md-3 col-sm-6 mb-3">
            <div class="card h-100 border-start border-4 border-success">
                <div class="card-body">
                    <small class="text-muted text-uppercase fw-bold">Billed to Customers</small>
                    <h4 class="mb-0 mt-2 text-success">{{ number_format($summary['billed'], 2) }}</h4>
                    <small class="text-muted">cu.m on issued bills</small>
                </div>
            </div>
        </div>
        <div class="col-md-3 col-sm-6 mb-3">
            <div class="card h-100 border-start border-4 border-warning">
                <div class="card-body">
                    <small class="text-muted text-uppercase fw-bold">Non-Revenue Water</small>
                    <h4 class="mb-0 mt-2 text-warning">{{ number_format($summary['nrw'], 2) }}</h4>
                    <small class="text-muted">cu.m unaccounted for</small>
                </div>
            </div>
        </div>
        <div class="col-md-3 col-sm-6 mb-3">
            <div class="card h-100 border-start border-4 border-danger">
                <div class="card-body">
                    <small class="text-muted text-uppercase fw-bold">NRW Rate</small>
                    <h4 class="mb-0 mt-2 text-danger">{{ number_format($summary['nrw_rate'], 1) }}%</h4>
                    <small class="text-muted">{{ $summary['supply'] > 0 ? 'of total supply' : 'no production recorded' }}</small>
                </div>
            </div>
        </div>
    </div>

    <div class="card">
        <div class="card-header bg-white">
            <h6 class="mb-0">Production Records for {{ $year }}</h6>
        </div>
        <div class="table-responsive">
            <table class="table table-hover table-sm mb-0 align-middle">
                <thead class="table-light">
                    <tr>
                        <th>Month</th>
                        <th>Source</th>
                        @if($isSuperAdmin)<th>Company</th>@endif
                        <th class="text-end">Produced</th>
                        <th class="text-end">Purchased</th>
                        <th class="text-end">Total Supply</th>
                        <th class="text-end">Billed (month)</th>
                        <th class="text-end">NRW %</th>
                        <th>Recorded By</th>
                        <th class="text-end">Actions</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($records as $record)
                        @php
                            $key = $record->period->format('Y-m');
                            $monthSupply = $supplyByMonth[$key] ?? 0;
                            $monthBilled = (float) ($billed[$key] ?? 0);
                            $nrwRate = $monthSupply > 0 ? (($monthSupply - $monthBilled) / $monthSupply) * 100 : null;
                        @endphp
                        <tr>
                            <td class="fw-semibold">{{ $record->period->format('M Y') }}</td>
                            <td>{{ $record->source_name }}</td>
                            @if($isSuperAdmin)<td><small>{{ $record->company->name ?? '—' }}</small></td>@endif
                            <td class="text-end">{{ number_format($record->production_volume, 2) }}</td>
                            <td class="text-end">{{ number_format($record->purchased_volume, 2) }}</td>
                            <td class="text-end fw-semibold">{{ number_format($record->total_supply, 2) }}</td>
                            <td class="text-end">{{ number_format($monthBilled, 2) }}</td>
                            <td class="text-end">
                                @if($nrwRate === null)
                                    <span class="text-muted">—</span>
                                @else
                                    <span class="badge bg-{{ $nrwRate > 30 ? 'danger' : ($nrwRate > 20 ? 'warning' : 'success') }}">
                                        {{ number_format($nrwRate, 1) }}%
                                    </span>
                                @endif
                            </td>
                            <td><small class="text-muted">{{ $record->recordedByUser->name ?? '—' }}</small></td>
                            <td class="text-end text-nowrap">
                                <a href="{{ route('water-productions.edit', $record) }}" class="btn btn-sm btn-outline-primary">
                                    <i class="fas fa-pen"></i>
                                </a>
                                <form action="{{ route('water-productions.destroy', $record) }}" method="POST" class="d-inline"
                                      onsubmit="return confirm('Delete the {{ $record->period->format('M Y') }} record for {{ $record->source_name }}?');">
                                    @csrf @method('DELETE')
                                    <button class="btn btn-sm btn-outline-danger"><i class="fas fa-trash"></i></button>
                                </form>
                            </td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="{{ $isSuperAdmin ? 10 : 9 }}" class="text-center text-muted py-5">
                                No production recorded for {{ $year }}.
                                <a href="{{ route('water-productions.create') }}">Add the first month</a>
                                so non-revenue water can be reported.
                            </td>
                        </tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>

    <p class="text-muted small mt-2 mb-0">
        NRW is computed as <strong>(total supply − volume billed) ÷ total supply</strong> for the same month.
        Billed volume comes from the bills issued in that month, so record production for a month only once its
        billing run is complete for the figure to be meaningful.
    </p>
</div>
@endsection