@extends('layouts.app')

@section('title', 'Client Details')

@section('content')
<div class="container-fluid">
    <div class="row mb-4">
        <div class="col-md-8">
            <h2><i class="bi bi-person"></i> {{ $client->name }}</h2>
            <small class="text-muted">Account: {{ $client->account_number }}</small>
        </div>
        <div class="col-md-4 text-end">
            <a href="{{ route('clients.edit', $client) }}" class="btn btn-warning btn-sm">
                <i class="bi bi-pencil"></i> Edit
            </a>
            @if(Auth::user()->hasCompanyAdminAccess() || Auth::user()->isSuperAdmin())
            <form action="{{ route('clients.destroy', $client) }}" method="POST" style="display: inline;">
                @csrf
                @method('DELETE')
                <button type="submit" class="btn btn-danger btn-sm" onclick="return confirm('Are you sure?')">
                    <i class="bi bi-trash"></i> Delete
                </button>
            </form>
            @endif
        </div>
    </div>

    <div class="row">
        <div class="col-md-4 mb-3">
            <div class="card">
                <div class="card-body text-center">
                    <h6 class="card-title text-muted">Status</h6>
                    <h4>
                        <span class="badge bg-{{ $client->status === 'active' ? 'success' : ($client->status === 'inactive' ? 'warning' : 'danger') }}">
                            {{ ucfirst($client->status) }}
                        </span>
                    </h4>
                </div>
            </div>
        </div>

        <div class="col-md-4 mb-3">
            <div class="card">
                <div class="card-body text-center">
                    <h6 class="card-title text-muted">Outstanding Balance</h6>
                    <h4 class="text-danger">₱{{ number_format($client->outstanding_balance, 2) }}</h4>
                </div>
            </div>
        </div>

        <div class="col-md-4 mb-3">
            <div class="card">
                <div class="card-body text-center">
                    <h6 class="card-title text-muted">Member Since</h6>
                    <h4>
                        @if($client->registered_at)
                            @if($client->registered_at instanceof \DateTime)
                                {{ $client->registered_at->format('M d, Y') }}
                            @else
                                {{ \Carbon\Carbon::parse($client->registered_at)->format('M d, Y') }}
                            @endif
                        @else
                            N/A
                        @endif
                    </h4>
                </div>
            </div>
        </div>
    </div>

    <div class="row">
        <div class="col-md-6 mb-3">
            <div class="card">
                <div class="card-header bg-light">
                    <h6 class="mb-0"><i class="bi bi-info-circle"></i> Contact Information</h6>
                </div>
                <div class="card-body">
                    <div class="mb-3">
                        <small class="text-muted">Email</small>
                        <p class="mb-0">{{ $client->email ?? 'Not provided' }}</p>
                    </div>
                    <div class="mb-3">
                        <small class="text-muted">Phone</small>
                        <p class="mb-0">{{ $client->phone ?? 'Not provided' }}</p>
                    </div>
                    <div class="mb-3">
                        <small class="text-muted">Address</small>
                        <p class="mb-0">{{ $client->full_address ?: 'Not provided' }}</p>
                    </div>
                </div>
            </div>
        </div>

        <div class="col-md-6 mb-3">
            <div class="card">
                <div class="card-header bg-light">
                    <h6 class="mb-0"><i class="bi bi-geo-alt"></i> Location</h6>
                </div>
                <div class="card-body">
                    <div class="mb-3">
                        <small class="text-muted">Barangay</small>
                        <p class="mb-0">{{ $client->barangay ?? 'Not provided' }}</p>
                    </div>
                    <div class="mb-3">
                        <small class="text-muted">City / Municipality</small>
                        <p class="mb-0">{{ $client->city ?? 'Not provided' }}</p>
                    </div>
                    <div class="mb-3">
                        <small class="text-muted">Province</small>
                        <p class="mb-0">{{ $client->province ?? 'Not provided' }}</p>
                    </div>
                    <div class="mb-3">
                        <small class="text-muted">Zip Code</small>
                        <p class="mb-0">{{ $client->zip_code ?? 'Not provided' }}</p>
                    </div>
                </div>
            </div>
        </div>

        <div class="col-md-6 mb-3">
            <div class="card">
                <div class="card-header bg-light d-flex justify-content-between align-items-center">
                    <h6 class="mb-0"><i class="bi bi-speedometer2"></i> Meter Information</h6>
                    <a href="{{ route('meter-readings.create') }}?client_id={{ $client->id }}" class="btn btn-sm btn-success">
                        <i class="bi bi-plus-lg"></i> Add Reading
                    </a>
                </div>
                <div class="card-body">
                    <div class="mb-3">
                        <small class="text-muted">Meter Number</small>
                        <p class="mb-0">{{ $client->meter_number ?? 'Not provided' }}</p>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <div class="card mb-3">
        <div class="card-header bg-light">
            <h6 class="mb-0"><i class="bi bi-file-earmark-text"></i> Recent Billings</h6>
        </div>
        <div class="table-responsive">
            <table class="table table-sm table-hover mb-0">
                <thead class="table-light">
                    <tr>
                        <th>Billing Number</th>
                        <th>Date</th>
                        <th>Amount Due</th>
                        <th>Status</th>
                        <th>Action</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($client->billings()->latest()->take(5)->get() as $billing)
                        <tr>
                            <td>{{ $billing->billing_number }}</td>
                            <td>{{ $billing->billing_date->format('M d, Y') }}</td>
                            <td>₱{{ number_format($billing->total_amount_due, 2) }}</td>
                            <td>
                                <span class="badge bg-{{ $billing->status === 'paid' ? 'success' : ($billing->status === 'sent' ? 'info' : ($billing->status === 'overdue' ? 'danger' : 'secondary')) }}">
                                    {{ ucfirst($billing->status) }}
                                </span>
                            </td>
                            <td>
                                <a href="{{ route('billings.show', $billing) }}" class="btn btn-sm btn-outline-primary">View</a>
                            </td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="5" class="text-center text-muted py-3">No billings yet</td>
                        </tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>

    <!-- Overdue Billings Section -->
    <div class="card mb-3">
        <div class="card-header bg-light d-flex justify-content-between align-items-center">
            <h6 class="mb-0"><i class="fas fa-exclamation-circle text-danger"></i> Overdue Billings</h6>
            @php
                $overdueCount = $client->billings()
                    ->where('status', '!=', 'paid')
                    ->where('due_date', '<', now())
                    ->where('balance', '>', 0)
                    ->count();
            @endphp
            @if($overdueCount > 0)
                <span class="badge bg-danger">{{ $overdueCount }}</span>
            @endif
        </div>
        <div class="table-responsive">
            <table class="table table-sm table-hover mb-0">
                <thead class="table-light">
                    <tr>
                        <th>Billing #</th>
                        <th>Due Date</th>
                        <th>Days Overdue</th>
                        <th>Amount</th>
                        <th>Balance</th>
                        <th>Disconnection Status</th>
                        <th>Action</th>
                    </tr>
                </thead>
                <tbody>
                    @php
                        $overdueBills = $client->billings()
                            ->where('status', '!=', 'paid')
                            ->where('due_date', '<', now())
                            ->where('balance', '>', 0)
                            ->orderBy('due_date')
                            ->get();
                    @endphp
                    @forelse($overdueBills as $billing)
                        <tr>
                            <td><strong>{{ $billing->billing_number }}</strong></td>
                            <td>{{ $billing->due_date->format('M d, Y') }}</td>
                            <td>
                                @php $daysOverdue = (int) abs($billing->due_date->diffInDays(now())); @endphp
                                <span class="badge bg-{{ $daysOverdue > 30 ? 'danger' : 'warning' }}">{{ $daysOverdue }} days</span>
                            </td>
                            <td>₱{{ number_format($billing->total_amount_due, 2) }}</td>
                            <td class="text-danger font-weight-bold">₱{{ number_format($billing->balance, 2) }}</td>
                            <td>
                                @php $discStatus = $billing->disconnection_status ?? 'none'; @endphp
                                <span class="badge bg-{{ $discStatus === 'disconnected' ? 'danger' : ($discStatus === 'notice_sent' ? 'warning' : 'success') }}">
                                    {{ ucfirst(str_replace('_', ' ', $discStatus)) }}
                                </span>
                            </td>
                            <td>
                                <a href="{{ route('billings.show', $billing) }}" class="btn btn-sm btn-outline-primary">View</a>
                            </td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="7" class="text-center text-muted py-3">No overdue billings</td>
                        </tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>

    <!-- Late Payments Section -->
    <div class="card mb-3">
        <div class="card-header bg-light d-flex justify-content-between align-items-center">
            <h6 class="mb-0"><i class="fas fa-hourglass-end text-warning"></i> Late Fees &amp; Notices Charged</h6>
            @php
                $latePaymentCount = \App\Models\BillingCharge::where('client_id', $client->id)
                    ->lateFees()->where('status', '!=', 'voided')->count();
            @endphp
            @if($latePaymentCount > 0)
                <span class="badge bg-warning">{{ $latePaymentCount }}</span>
            @endif
        </div>
        <div class="table-responsive">
            <table class="table table-sm table-hover mb-0">
                <thead class="table-light">
                    <tr>
                        <th>Date</th>
                        <th>Billing #</th>
                        <th>Charge Type</th>
                        <th>Amount</th>
                        <th>Status</th>
                        <th>Notes</th>
                    </tr>
                </thead>
                <tbody>
                    @php
                        // Fees and notices charged onto this client's billings —
                        // amounts owed, not money received.
                        $latePayments = \App\Models\BillingCharge::where('client_id', $client->id)
                            ->with('billing')
                            ->orderBy('created_at', 'desc')
                            ->take(10)
                            ->get();
                    @endphp
                    @forelse($latePayments as $payment)
                        <tr>
                            <td>{{ $payment->created_at->format('M d, Y') }}</td>
                            <td><code>{{ $payment->billing?->billing_number ?? 'N/A' }}</code></td>
                            <td>
                                <span class="badge bg-{{ $payment->type === 'late_fee' ? 'warning' : ($payment->type === 'disconnection' ? 'danger' : 'info') }}">
                                    {{ ucfirst(str_replace('_', ' ', $payment->type)) }}
                                </span>
                            </td>
                            <td class="font-weight-bold">₱{{ number_format($payment->amount, 2) }}</td>
                            <td>
                                <span class="badge bg-{{ $payment->status === 'added' ? 'warning' : 'dark' }}">
                                    {{ ucfirst($payment->status) }}
                                </span>
                            </td>
                            <td><small>{{ $payment->notes ?? '-' }}</small></td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="6" class="text-center text-muted py-3">No late fees or notices charged</td>
                        </tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>

    <div class="card mb-3">
        <div class="card-header bg-light">
            <h6 class="mb-0"><i class="bi bi-graph-up"></i> Meter Readings</h6>
        </div>
        <div class="table-responsive">
            <table class="table table-sm table-hover mb-0">
                <thead class="table-light">
                    <tr>
                        <th>Reading Date</th>
                        <th>Value</th>
                        <th>Units Consumed</th>
                        <th>Status</th>
                        <th>Action</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($client->meterReadings()->latest('reading_date')->take(5)->get() as $reading)
                        <tr>
                            <td>{{ $reading->reading_date->format('M d, Y') }}</td>
                            <td>{{ $reading->reading_value }} cu.m</td>
                            <td>{{ $reading->units_consumed ?? '—' }} cu.m</td>
                            <td>
                                <span class="badge bg-{{ $reading->status === 'approved' ? 'success' : ($reading->status === 'rejected' ? 'danger' : 'warning') }}">
                                    {{ ucfirst($reading->status) }}
                                </span>
                            </td>
                            <td>
                                <a href="{{ route('meter-readings.show', $reading) }}" class="btn btn-sm btn-outline-primary">View</a>
                            </td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="5" class="text-center text-muted py-3">No meter readings yet</td>
                        </tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>

    <div class="card">
        <div class="card-header bg-light">
            <h6 class="mb-0"><i class="bi bi-credit-card"></i> Recent Payments (Statement of Account)</h6>
        </div>
        <div class="table-responsive">
            <table class="table table-sm table-hover mb-0">
                <thead class="table-light">
                    <tr>
                        <th>Reference</th>
                        <th>Date</th>
                        <th>Amount</th>
                        <th>Type</th>
                        <th>Method</th>
                        <th>Status</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($client->payments()->latest()->take(10)->get() as $payment)
                        <tr>
                            <td>{{ $payment->reference_number ?? '—' }}</td>
                            <td>{{ $payment->payment_date->format('M d, Y') }}</td>
                            <td>₱{{ number_format($payment->amount, 2) }}</td>
                            <td>
                                @php
                                    $typeLabels = [
                                        'billing' => 'Billing',
                                        'installation' => 'Installation',
                                        'reconnection' => 'Reconnection',
                                        'late_fee' => 'Late Fee',
                                        'deposit' => 'Deposit',
                                        'other' => 'Other'
                                    ];
                                    $typeColors = [
                                        'billing' => 'primary',
                                        'installation' => 'success',
                                        'reconnection' => 'warning',
                                        'late_fee' => 'danger',
                                        'deposit' => 'info',
                                        'other' => 'secondary'
                                    ];
                                    $paymentType = $payment->payment_type ?? 'billing';
                                    $label = $typeLabels[$paymentType] ?? ucfirst(str_replace('_', ' ', $paymentType));
                                    $color = $typeColors[$paymentType] ?? 'secondary';
                                @endphp
                                <span class="badge bg-{{ $color }}">{{ $label }}</span>
                            </td>
                            <td>{{ ucfirst(str_replace('_', ' ', $payment->payment_method)) }}</td>
                            <td>
                                <span class="badge bg-{{ $payment->status === 'added' ? 'warning' : 'dark' }}">
                                    {{ ucfirst($payment->status) }}
                                </span>
                            </td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="6" class="text-center text-muted py-3">No payments recorded yet</td>
                        </tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>
</div>
@endsection