@extends('layouts.app')

@section('title', 'Reports')

@section('content')
@php
    $cur = ($filters['currency'] ?? 'PHP') === 'PHP' ? '₱' : $filters['currency'] . ' ';
    $reports = [
        [
            'route' => 'reports.financial',
            'icon' => 'fas fa-chart-line',
            'color' => 'primary',
            'title' => 'Monthly Financial Report',
            'text' => 'Amount billed, collected, late fees and outstanding balance broken down month by month.',
        ],
        [
            'route' => 'reports.usage',
            'icon' => 'fas fa-droplet',
            'color' => 'info',
            'title' => 'Monthly Usage per Account',
            'text' => 'Water consumption for every client account, pivoted by month with averages and peaks.',
        ],
        [
            'route' => 'reports.payments',
            'icon' => 'fas fa-credit-card',
            'color' => 'success',
            'title' => 'Monthly Payments per Account',
            'text' => 'What each client paid each month, their last payment date and remaining balance.',
        ],
        [
            'route' => 'reports.client-details',
            'icon' => 'fas fa-list-ul',
            'color' => 'secondary',
            'title' => 'Client Billing & Payment Details',
            'text' => 'Line-by-line per account: meter reading, previous and current, bill number and date, payment date and every payment detail.',
        ],
        [
            'route' => 'reports.unpaid',
            'icon' => 'fas fa-file-invoice-dollar',
            'color' => 'warning',
            'title' => 'Unpaid Report',
            'text' => 'Every bill still carrying a balance, with aging buckets and days overdue.',
        ],
        [
            'route' => 'reports.disconnection',
            'icon' => 'fas fa-plug-circle-xmark',
            'color' => 'danger',
            'title' => 'Monthly Disconnection Report',
            'text' => 'Notices sent, disconnections, reconnections per month plus accounts currently at risk.',
        ],
    ];

    // NWRB filing is an admin-level document, not a day-to-day report.
    if (in_array(auth()->user()->role?->name, ['super_admin', 'company_admin', 'company_owner'])) {
        $reports[] = [
            'route' => 'reports.nwrb',
            'icon' => 'fas fa-file-contract',
            'color' => 'dark',
            'title' => 'NWRB Section 18 Data Sheet',
            'text' => 'Monthly + YTD financial and technical data sheet for the NWRB Annual Report, including non-revenue water.',
        ];
    }
@endphp

<div class="container-fluid">
    <div class="mb-4">
        <h2 class="mb-1"><i class="fas fa-chart-pie me-2"></i>Reports</h2>
        <p class="text-muted small mb-0">Financial, usage, collection and disconnection reporting</p>
    </div>

    @include('reports.partials.filter', ['route' => 'reports.index', 'showExport' => false])

    <!-- Headline figures for the selected range -->
    <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($summary['billed'], 2) }}</h4>
                    <small class="text-muted">{{ number_format($summary['bills']) }} bills &middot; {{ number_format($summary['units'], 2) }} cu.m</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">Collected</small>
                    <h4 class="mb-0 mt-2 text-success">{{ $cur }}{{ number_format($summary['collected'], 2) }}</h4>
                    <small class="text-muted">
                        {{ $summary['billed'] > 0 ? number_format($summary['collected'] / $summary['billed'] * 100, 1) : '0.0' }}% of billed
                    </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 (All Time)</small>
                    <h4 class="mb-0 mt-2 text-warning">{{ $cur }}{{ number_format($summary['outstanding'], 2) }}</h4>
                    <small class="text-muted">{{ number_format($summary['unpaid_accounts']) }} accounts owing</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">Disconnected</small>
                    <h4 class="mb-0 mt-2 text-danger">{{ number_format($summary['disconnected']) }}</h4>
                    <small class="text-muted">accounts currently cut off</small>
                </div>
            </div>
        </div>
    </div>

    <!-- Report list -->
    <div class="row">
        @foreach($reports as $report)
            <div class="col-lg-4 col-md-6 mb-4">
                <a href="{{ route($report['route'], request()->only(['period', 'start_date', 'end_date', 'company_id'])) }}"
                   class="text-decoration-none">
                    <div class="card h-100 shadow-sm">
                        <div class="card-body d-flex">
                            <div class="me-3">
                                <span class="d-inline-flex align-items-center justify-content-center rounded bg-{{ $report['color'] }} text-white"
                                      style="width:48px;height:48px;">
                                    <i class="{{ $report['icon'] }} fa-lg"></i>
                                </span>
                            </div>
                            <div>
                                <h6 class="mb-1 text-dark">{{ $report['title'] }}</h6>
                                <p class="text-muted small mb-0">{{ $report['text'] }}</p>
                            </div>
                        </div>
                    </div>
                </a>
            </div>
        @endforeach
    </div>
</div>
@endsection