@extends('layouts.app')

@section('title', 'Monthly Financial Report')

@section('content')
@php
    $cur = ($filters['currency'] ?? 'PHP') === 'PHP' ? '₱' : $filters['currency'] . ' ';
@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-chart-line me-2"></i>Monthly Financial Report</h2>
        <p class="text-muted small mb-0">Billed, collected and outstanding amounts per month</p>
    </div>

    @include('reports.partials.filter', ['route' => 'reports.financial'])

    <!-- 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 Billed</small>
                    <h4 class="mb-0 mt-2 text-primary">{{ $cur }}{{ number_format($totals['billed'], 2) }}</h4>
                    <small class="text-muted">{{ number_format($totals['bills']) }} bills issued</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">Total Collected</small>
                    <h4 class="mb-0 mt-2 text-success">{{ $cur }}{{ number_format($totals['collected'], 2) }}</h4>
                    <small class="text-muted">{{ number_format($totals['payments']) }} payments received</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">Outstanding</small>
                    <h4 class="mb-0 mt-2 text-warning">{{ $cur }}{{ number_format($totals['outstanding'], 2) }}</h4>
                    <small class="text-muted">unpaid on bills in this range</small>
                </div>
            </div>
        </div>
        <div class="col-md-3 col-sm-6 mb-3">
            <div class="card h-100 border-start border-4 border-info">
                <div class="card-body">
                    <small class="text-muted text-uppercase fw-bold">Collection Rate</small>
                    <h4 class="mb-0 mt-2 text-info">{{ number_format($totals['rate'], 1) }}%</h4>
                    <small class="text-muted">{{ $cur }}{{ number_format($totals['late_fees'], 2) }} late fees applied</small>
                </div>
            </div>
        </div>
    </div>

    <div class="card">
        <div class="card-header bg-white">
            <h6 class="mb-0">Monthly Breakdown</h6>
        </div>
        <div class="table-responsive">
            <table class="table table-hover table-sm mb-0 report-table">
                <thead class="table-light">
                    <tr>
                        <th>Month</th>
                        <th class="text-end">Bills</th>
                        <th class="text-end">Units (cu.m)</th>
                        <th class="text-end">Subtotal</th>
                        <th class="text-end">Tax</th>
                        <th class="text-end">Other</th>
                        <th class="text-end">Penalties</th>
                        <th class="text-end">Total Billed</th>
                        <th class="text-end">Collected</th>
                        <th class="text-end">Late Fees</th>
                        <th class="text-end">Outstanding</th>
                        <th class="text-end">Rate</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($rows as $row)
                        <tr>
                            <td class="fw-semibold">{{ $row['label'] }}</td>
                            <td class="text-end">{{ number_format($row['bills']) }}</td>
                            <td class="text-end">{{ number_format($row['units'], 2) }}</td>
                            <td class="text-end">{{ number_format($row['subtotal'], 2) }}</td>
                            <td class="text-end">{{ number_format($row['tax'], 2) }}</td>
                            <td class="text-end">{{ number_format($row['other_charges'], 2) }}</td>
                            <td class="text-end">{{ number_format($row['penalties'], 2) }}</td>
                            <td class="text-end fw-semibold">{{ $cur }}{{ number_format($row['billed'], 2) }}</td>
                            <td class="text-end text-success fw-semibold">{{ $cur }}{{ number_format($row['collected'], 2) }}</td>
                            <td class="text-end text-warning">{{ number_format($row['late_fees'], 2) }}</td>
                            <td class="text-end text-danger">{{ number_format($row['outstanding'], 2) }}</td>
                            <td class="text-end">
                                <span class="badge bg-{{ $row['rate'] >= 80 ? 'success' : ($row['rate'] >= 50 ? 'warning' : 'danger') }}">
                                    {{ number_format($row['rate'], 1) }}%
                                </span>
                            </td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="12" class="text-center text-muted py-5">No billing activity in this period.</td>
                        </tr>
                    @endforelse
                </tbody>
                @if($rows->isNotEmpty())
                    <tfoot>
                        <tr>
                            <td>Total</td>
                            <td class="text-end">{{ number_format($totals['bills']) }}</td>
                            <td class="text-end">{{ number_format($totals['units'], 2) }}</td>
                            <td class="text-end">{{ number_format($totals['subtotal'], 2) }}</td>
                            <td class="text-end">{{ number_format($totals['tax'], 2) }}</td>
                            <td class="text-end">{{ number_format($totals['other_charges'], 2) }}</td>
                            <td class="text-end">{{ number_format($totals['penalties'], 2) }}</td>
                            <td class="text-end">{{ $cur }}{{ number_format($totals['billed'], 2) }}</td>
                            <td class="text-end text-success">{{ $cur }}{{ number_format($totals['collected'], 2) }}</td>
                            <td class="text-end text-warning">{{ number_format($totals['late_fees'], 2) }}</td>
                            <td class="text-end text-danger">{{ number_format($totals['outstanding'], 2) }}</td>
                            <td class="text-end">{{ number_format($totals['rate'], 1) }}%</td>
                        </tr>
                    </tfoot>
                @endif
            </table>
        </div>
        <div class="card-footer bg-white">
            <small class="text-muted">
                <strong>Collected</strong> counts completed cash payments received within each month and excludes
                system-generated fee records; it may include payments for bills issued in earlier months, so the
                collection rate is an indicator rather than a per-bill settlement figure.
            </small>
        </div>
    </div>
</div>
@endsection