@extends('layouts.app')

@section('title', 'Monthly Payments per Account')

@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-credit-card me-2"></i>Monthly Payments per Account</h2>
        <p class="text-muted small mb-0">Payments received from each client account, broken down by month</p>
    </div>

    @include('reports.partials.filter', ['route' => 'reports.payments', 'showSearch' => true])

    <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-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['total_paid'], 2) }}</h4>
                    <small class="text-muted">{{ number_format($totals['payments']) }} payments</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">Paying Accounts</small>
                    <h4 class="mb-0 mt-2 text-primary">{{ number_format($rows->count()) }}</h4>
                    <small class="text-muted">accounts paid 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">Average per Account</small>
                    <h4 class="mb-0 mt-2 text-info">
                        {{ $cur }}{{ $rows->count() > 0 ? number_format($totals['total_paid'] / $rows->count(), 2) : '0.00' }}
                    </h4>
                    <small class="text-muted">for the whole 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-warning">
                <div class="card-body">
                    <small class="text-muted text-uppercase fw-bold">Balance Still Owed</small>
                    <h4 class="mb-0 mt-2 text-warning">{{ $cur }}{{ number_format($totals['balance'], 2) }}</h4>
                    <small class="text-muted">by these same accounts</small>
                </div>
            </div>
        </div>
    </div>

    <div class="card">
        <div class="card-header bg-white d-flex justify-content-between align-items-center">
            <h6 class="mb-0">Payments by Account</h6>
            <small class="text-muted">Sorted by highest total paid</small>
        </div>
        <div class="table-responsive">
            <table class="table table-hover table-sm mb-0 report-table">
                <thead class="table-light">
                    <tr>
                        <th class="report-sticky-col">Account</th>
                        @foreach($months as $label)
                            <th class="text-end">{{ $label }}</th>
                        @endforeach
                        <th class="text-end">Payments</th>
                        <th class="text-end">Total Paid</th>
                        <th>Last Payment</th>
                        <th class="text-end">Balance</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($paginated as $row)
                        <tr>
                            <td class="report-sticky-col">
                                <div class="fw-semibold">{{ $row['client_name'] }}</div>
                                <small class="text-muted">{{ $row['account_number'] }}</small>
                            </td>
                            @foreach(array_keys($months) as $key)
                                <td class="text-end {{ $row['months'][$key] > 0 ? '' : 'text-muted' }}">
                                    {{ $row['months'][$key] > 0 ? number_format($row['months'][$key], 2) : '—' }}
                                </td>
                            @endforeach
                            <td class="text-end">{{ number_format($row['payments']) }}</td>
                            <td class="text-end fw-semibold text-success">{{ $cur }}{{ number_format($row['total_paid'], 2) }}</td>
                            <td>
                                <small>{{ $row['last_payment'] ? \Illuminate\Support\Carbon::parse($row['last_payment'])->format('M d, Y') : '—' }}</small>
                            </td>
                            <td class="text-end {{ $row['balance'] > 0 ? 'text-danger fw-semibold' : 'text-muted' }}">
                                {{ $row['balance'] > 0 ? $cur . number_format($row['balance'], 2) : '—' }}
                            </td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="{{ count($months) + 5 }}" class="text-center text-muted py-5">
                                No payments received in this period.
                            </td>
                        </tr>
                    @endforelse
                </tbody>
                @if($rows->isNotEmpty())
                    <tfoot>
                        <tr>
                            <td class="report-sticky-col">All Accounts</td>
                            @foreach(array_keys($months) as $key)
                                <td class="text-end">{{ number_format($totals['months'][$key], 2) }}</td>
                            @endforeach
                            <td class="text-end">{{ number_format($totals['payments']) }}</td>
                            <td class="text-end">{{ $cur }}{{ number_format($totals['total_paid'], 2) }}</td>
                            <td>—</td>
                            <td class="text-end">{{ $cur }}{{ number_format($totals['balance'], 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">
        Only completed cash payments are counted; system-generated late fee and disconnection notice records are
        excluded. <strong>Balance</strong> is the account's current outstanding amount across all bills, not just
        this date range.
    </p>
</div>
@endsection