@extends('layouts.app')

@section('title', 'Monthly Disconnection 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-plug-circle-xmark me-2"></i>Monthly Disconnection Report</h2>
        <p class="text-muted small mb-0">Notices, disconnections and reconnections per month, plus accounts at risk</p>
    </div>

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

    <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-warning">
                <div class="card-body">
                    <small class="text-muted text-uppercase fw-bold">Notices Sent</small>
                    <h4 class="mb-0 mt-2 text-warning">{{ number_format($totals['notices']) }}</h4>
                    <small class="text-muted">{{ number_format($current['notice_sent']) }} bills on notice now</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">Disconnections</small>
                    <h4 class="mb-0 mt-2 text-danger">{{ number_format($totals['disconnections']) }}</h4>
                    <small class="text-muted">{{ number_format($current['disconnected_clients']) }} accounts cut off now</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">Reconnections</small>
                    <h4 class="mb-0 mt-2 text-success">{{ number_format($totals['reconnections']) }}</h4>
                    <small class="text-muted">{{ $cur }}{{ number_format($totals['reconnection_fees'], 2) }} collected</small>
                </div>
            </div>
        </div>
        <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">Amount at Risk</small>
                    <h4 class="mb-0 mt-2 text-primary">{{ $cur }}{{ number_format($current['at_risk_amount'], 2) }}</h4>
                    <small class="text-muted">{{ number_format($current['eligible']) }} bills past cut-off date</small>
                </div>
            </div>
        </div>
    </div>

    <div class="card mb-4">
        <div class="card-header bg-white">
            <h6 class="mb-0">Monthly Disconnection Activity</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">Notices Sent</th>
                        <th class="text-end">Disconnections</th>
                        <th class="text-end">Reconnections</th>
                        <th class="text-end">Reconnection Fees</th>
                        <th class="text-end">Late Fees Applied</th>
                        <th class="text-end">Late Fee Amount</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($rows as $row)
                        <tr>
                            <td class="fw-semibold">{{ $row['label'] }}</td>
                            <td class="text-end">{{ number_format($row['notices']) }}</td>
                            <td class="text-end text-danger">{{ number_format($row['disconnections']) }}</td>
                            <td class="text-end text-success">{{ number_format($row['reconnections']) }}</td>
                            <td class="text-end">{{ $cur }}{{ number_format($row['reconnection_fees'], 2) }}</td>
                            <td class="text-end">{{ number_format($row['late_fee_count']) }}</td>
                            <td class="text-end text-warning">{{ $cur }}{{ number_format($row['late_fees'], 2) }}</td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="7" class="text-center text-muted py-5">No disconnection activity in this period.</td>
                        </tr>
                    @endforelse
                </tbody>
                @if($rows->isNotEmpty())
                    <tfoot>
                        <tr>
                            <td>Total</td>
                            <td class="text-end">{{ number_format($totals['notices']) }}</td>
                            <td class="text-end">{{ number_format($totals['disconnections']) }}</td>
                            <td class="text-end">{{ number_format($totals['reconnections']) }}</td>
                            <td class="text-end">{{ $cur }}{{ number_format($totals['reconnection_fees'], 2) }}</td>
                            <td class="text-end">{{ number_format($totals['late_fee_count']) }}</td>
                            <td class="text-end">{{ $cur }}{{ number_format($totals['late_fees'], 2) }}</td>
                        </tr>
                    </tfoot>
                @endif
            </table>
        </div>
    </div>

    <div class="card">
        <div class="card-header bg-white d-flex justify-content-between align-items-center">
            <h6 class="mb-0">Accounts for Disconnection</h6>
            <small class="text-muted">Unpaid past due date and not yet disconnected &middot; oldest first</small>
        </div>
        <div class="table-responsive">
            <table class="table table-hover table-sm mb-0 report-table">
                <thead class="table-light">
                    <tr>
                        <th>Bill #</th>
                        <th>Account</th>
                        <th>Due Date</th>
                        <th>Cut-off Date</th>
                        <th class="text-end">Days Overdue</th>
                        <th class="text-end">Balance</th>
                        <th>Notice</th>
                        <th>For Disconnection</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($paginated as $row)
                        <tr class="{{ $row['eligible'] ? 'table-danger' : '' }}">
                            <td>{{ $row['billing_number'] }}</td>
                            <td>
                                <div class="fw-semibold">{{ $row['client_name'] }}</div>
                                <small class="text-muted">{{ $row['account_number'] }}</small>
                            </td>
                            <td><small>{{ $row['due_date']?->format('M d, Y') ?? '—' }}</small></td>
                            <td><small>{{ $row['disconnection_date']?->format('M d, Y') ?? '—' }}</small></td>
                            <td class="text-end">{{ number_format($row['days_overdue']) }}</td>
                            <td class="text-end fw-semibold text-danger">{{ $cur }}{{ number_format($row['balance'], 2) }}</td>
                            <td>
                                @if($row['disconnection_status'] === 'notice_sent')
                                    <span class="badge bg-warning text-dark">Sent</span>
                                @else
                                    <span class="badge bg-light text-muted">Not sent</span>
                                @endif
                            </td>
                            <td>
                                @if($row['eligible'])
                                    <span class="badge bg-danger">Due for cut-off</span>
                                @else
                                    <span class="badge bg-secondary">Within grace period</span>
                                @endif
                            </td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="8" class="text-center text-muted py-5">No accounts are pending disconnection.</td>
                        </tr>
                    @endforelse
                </tbody>
                @if($atRisk->isNotEmpty())
                    <tfoot>
                        <tr>
                            <td colspan="5">Total ({{ number_format($atRisk->count()) }} bills)</td>
                            <td class="text-end">{{ $cur }}{{ number_format($atRisk->sum('balance'), 2) }}</td>
                            <td colspan="2"></td>
                        </tr>
                    </tfoot>
                @endif
            </table>
        </div>
        @if($paginated->hasPages())
            <div class="card-footer bg-white">
                {{ $paginated->links('pagination::bootstrap-5') }}
            </div>
        @endif
    </div>
    <p class="text-muted small mt-2 mb-0">
        The monthly table is driven by the disconnection events recorded against each account; the accounts list
        reflects the current state and ignores the date filter. Cut-off dates follow the company's disconnection
        settings (fixed date or days after due date). The CSV export covers the monthly activity table.
        @if(in_array(auth()->user()->role?->name, ['super_admin', 'company_admin', 'company_owner']))
            Actions live in <a href="{{ route('disconnections.index') }}">Disconnection Management</a>.
        @endif
    </p>
</div>
@endsection