@extends('layouts.app')

@section('title', 'Client Billing & Payment Details')

@section('content')
@php
    $cur = ($filters['currency'] ?? 'PHP') === 'PHP' ? '₱' : $filters['currency'] . ' ';

    $billStatusColor = [
        'paid' => 'success',
        'partial' => 'info',
        'sent' => 'primary',
        'draft' => 'secondary',
        'overdue' => 'danger',
        'voided' => 'dark',
        'cancelled' => 'dark',
    ];
    $payStatusColor = [
        'completed' => 'success',
        'voided' => 'dark',
        'pending' => 'warning',
    ];
@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-list-ul me-2"></i>Client Billing &amp; Payment Details</h2>
        <p class="text-muted small mb-0">
            Every bill per account with its meter reading, and every payment received against it
        </p>
    </div>

    @include('reports.partials.filter', ['route' => 'reports.client-details', '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-primary">
                <div class="card-body">
                    <small class="text-muted text-uppercase fw-bold">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 &middot; {{ number_format($totals['accounts']) }} accounts
                    </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($totals['collected'], 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-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['balance'], 2) }}</h4>
                    <small class="text-muted">still owed on these 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-info">
                <div class="card-body">
                    <small class="text-muted text-uppercase fw-bold">Consumption</small>
                    <h4 class="mb-0 mt-2 text-info">{{ number_format($totals['units'], 2) }}</h4>
                    <small class="text-muted">cu.m billed in this range</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">Details by Account</h6>
            <small class="text-muted">{{ number_format($totals['accounts']) }} accounts, sorted by name</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">Bill / Invoice #</th>
                        <th>Bill Date</th>
                        <th>Due Date</th>
                        <th>Reading Date</th>
                        <th class="text-end">Previous</th>
                        <th class="text-end">Current</th>
                        <th class="text-end">Consumption</th>
                        <th class="text-end">Amount Due</th>
                        <th class="text-end">Late Fees</th>
                        <th>Bill Status</th>
                        <th>Payment Date</th>
                        <th class="text-end">Payment</th>
                        <th>Method</th>
                        <th>Reference #</th>
                        <th>SI # / Date</th>
                        <th>Received By</th>
                        <th>Payment Status</th>
                        <th class="text-end">Balance</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($paginated as $accountRows)
                        @php
                            $first = $accountRows->first();
                            $accountBilled = $accountRows->unique('billing_id')
                                ->whereNotIn('billing_status', ['voided', 'cancelled'])->sum('total_due');
                            $accountPaid = $accountRows->where('payment_status', 'completed')->sum('payment_amount');
                            $accountBalance = $accountRows->unique('billing_id')
                                ->whereNotIn('billing_status', ['voided', 'cancelled'])->sum('balance');
                        @endphp
                        <tr class="table-light">
                            <td class="report-sticky-col fw-bold" colspan="10">
                                {{ $first['client_name'] }}
                                <span class="text-muted fw-normal">&middot; {{ $first['account_number'] }}</span>
                            </td>
                            <td colspan="8" class="text-end small">
                                Billed <strong>{{ $cur }}{{ number_format($accountBilled, 2) }}</strong>
                                &middot; Paid <strong class="text-success">{{ $cur }}{{ number_format($accountPaid, 2) }}</strong>
                                &middot; Balance <strong class="{{ $accountBalance > 0 ? 'text-danger' : 'text-muted' }}">{{ $cur }}{{ number_format($accountBalance, 2) }}</strong>
                            </td>
                        </tr>
                        @foreach($accountRows as $row)
                            <tr>
                                <td class="report-sticky-col">
                                    <a href="{{ route('billings.show', $row['billing_id']) }}">{{ $row['billing_number'] }}</a>
                                </td>
                                <td><small>{{ $row['billing_date']?->format('M d, Y') ?? '—' }}</small></td>
                                <td><small>{{ $row['due_date']?->format('M d, Y') ?? '—' }}</small></td>
                                <td><small>{{ $row['reading_date']?->format('M d, Y') ?? '—' }}</small></td>
                                <td class="text-end">{{ number_format($row['previous_reading'], 2) }}</td>
                                <td class="text-end">{{ number_format($row['current_reading'], 2) }}</td>
                                <td class="text-end">{{ number_format($row['units_consumed'], 2) }}</td>
                                <td class="text-end">{{ $cur }}{{ number_format($row['total_due'], 2) }}</td>
                                <td class="text-end {{ $row['penalties'] > 0 ? 'text-danger' : 'text-muted' }}">
                                    {{ $row['penalties'] > 0 ? $cur . number_format($row['penalties'], 2) : '—' }}
                                </td>
                                <td>
                                    <span class="badge bg-{{ $billStatusColor[$row['billing_status']] ?? 'secondary' }}">
                                        {{ ucfirst($row['billing_status']) }}
                                    </span>
                                </td>
                                @if($row['payment_id'])
                                    <td><small>{{ $row['payment_date']?->format('M d, Y g:i A') ?? '—' }}</small></td>
                                    <td class="text-end fw-semibold {{ $row['payment_status'] === 'completed' ? 'text-success' : 'text-muted text-decoration-line-through' }}">
                                        {{ $cur }}{{ number_format($row['payment_amount'], 2) }}
                                    </td>
                                    <td><small>{{ ucfirst(str_replace('_', ' ', $row['payment_method'] ?? '—')) }}</small></td>
                                    <td><small>{{ $row['reference_number'] ?: '—' }}</small></td>
                                    <td>
                                        <small>
                                            {{ $row['sales_invoice_number'] ?: '—' }}
                                            @if($row['sales_invoice_date'])
                                                <br><span class="text-muted">{{ $row['sales_invoice_date']->format('M d, Y') }}</span>
                                            @endif
                                        </small>
                                    </td>
                                    <td><small>{{ $row['received_by'] ?: '—' }}</small></td>
                                    <td>
                                        <span class="badge bg-{{ $payStatusColor[$row['payment_status']] ?? 'secondary' }}">
                                            {{ ucfirst($row['payment_status']) }}
                                        </span>
                                    </td>
                                @else
                                    <td colspan="7" class="text-muted"><small>No payment recorded</small></td>
                                @endif
                                <td class="text-end {{ $row['balance'] > 0 ? 'text-danger fw-semibold' : 'text-muted' }}">
                                    {{ $row['balance'] > 0 ? $cur . number_format($row['balance'], 2) : '—' }}
                                </td>
                            </tr>
                        @endforeach
                    @empty
                        <tr>
                            <td colspan="18" class="text-center text-muted py-5">
                                No bills in this period.
                            </td>
                        </tr>
                    @endforelse
                </tbody>
                @if($rows->isNotEmpty())
                    <tfoot>
                        <tr>
                            <td class="report-sticky-col" colspan="7">All Accounts</td>
                            <td class="text-end">{{ $cur }}{{ number_format($totals['billed'], 2) }}</td>
                            <td colspan="3"></td>
                            <td class="text-end">{{ $cur }}{{ number_format($totals['collected'], 2) }}</td>
                            <td colspan="5"></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">
        Bills are selected by <strong>bill date</strong>; a payment made outside the range still appears against its
        bill. Late fee and disconnection notice records are charges, not collections, so they are shown in the
        <strong>Late Fees</strong> column rather than as payments. Voided and cancelled bills, and voided payments,
        are listed for audit but excluded from the totals. Use <strong>Export CSV</strong> for the full unpaginated
        list, one line per payment.
    </p>
</div>
@endsection