@extends('layouts.portal')

@section('title', 'Financial Report')
@section('page_title', 'Financial Report')
@section('page_subtitle', 'Will and trust amounts, payments received, and outstanding balances')

@section('sidebar')
    @include('agent.partials.sidebar', ['active' => 'reports-financial'])
@endsection

@section('content')
<div class="max-w-7xl mx-auto">
    <div class="bg-white rounded-xl shadow-lg p-6 mb-6">
        <div class="flex justify-between items-center mb-6 flex-wrap gap-3">
            <div>
                <h1 class="text-3xl font-bold text-gray-900">Financial Report</h1>
                <p class="text-gray-600 mt-2">Payments received and outstanding balances per will</p>
            </div>
            <div class="flex gap-3">
                <a href="{{ route('agent.reports.hub') }}" class="bg-gray-100 hover:bg-gray-200 text-gray-700 px-4 py-3 rounded-lg font-medium inline-flex items-center no-print">
                    <i class="fas fa-arrow-left mr-2"></i>Reports
                </a>
                <button onclick="window.print()" class="bg-gradient-to-r from-[#772B10] to-[#8B3D15] text-white px-6 py-3 rounded-lg font-medium inline-flex items-center no-print">
                    <i class="fas fa-print mr-2"></i>Print
                </button>
                <a href="{{ route('agent.reports.financial.pdf', request()->query()) }}" class="bg-gradient-to-r from-red-500 to-red-600 text-white px-6 py-3 rounded-lg font-medium inline-flex items-center no-print">
                    <i class="fas fa-file-pdf mr-2"></i>PDF
                </a>
                <a href="{{ route('agent.reports.financial.excel', request()->query()) }}" class="bg-gradient-to-r from-green-500 to-green-600 text-white px-6 py-3 rounded-lg font-medium inline-flex items-center no-print">
                    <i class="fas fa-file-excel mr-2"></i>Excel
                </a>
            </div>
        </div>

        <div class="grid grid-cols-2 md:grid-cols-4 gap-4">
            <div class="bg-gradient-to-br from-[#772B10] to-[#8B3D15] rounded-lg p-4 text-white">
                <p class="text-white/80 text-sm font-medium">Total Will Amount</p>
                <h3 class="text-2xl font-bold mt-1">RM {{ number_format($stats['total_will_amount'], 2) }}</h3>
            </div>
            <div class="bg-gradient-to-br from-green-500 to-green-600 rounded-lg p-4 text-white">
                <p class="text-green-100 text-sm font-medium">Received</p>
                <h3 class="text-2xl font-bold mt-1">RM {{ number_format($stats['total_received'], 2) }}</h3>
            </div>
            <div class="bg-gradient-to-br from-red-500 to-red-600 rounded-lg p-4 text-white">
                <p class="text-red-100 text-sm font-medium">Outstanding</p>
                <h3 class="text-2xl font-bold mt-1">RM {{ number_format($stats['total_outstanding'], 2) }}</h3>
            </div>
            <div class="bg-gradient-to-br from-indigo-500 to-indigo-600 rounded-lg p-4 text-white">
                <p class="text-indigo-100 text-sm font-medium">Paid / Pending</p>
                <h3 class="text-2xl font-bold mt-1">{{ $stats['paid_count'] }} / {{ $stats['pending_count'] }}</h3>
            </div>
        </div>
    </div>

    <div class="bg-white rounded-xl shadow-lg p-6 mb-6 no-print">
        <form method="GET" class="grid grid-cols-1 md:grid-cols-2 lg:grid-cols-5 gap-3 items-end">
            <div>
                <label class="block text-xs font-semibold text-gray-700 mb-1.5">Payment Status</label>
                <select name="payment_status" class="w-full px-3 py-2 border border-gray-300 rounded-lg text-sm">
                    <option value="">All Status</option>
                    <option value="paid" {{ request('payment_status') === 'paid' ? 'selected' : '' }}>Paid</option>
                    <option value="partial" {{ request('payment_status') === 'partial' ? 'selected' : '' }}>Partial</option>
                    <option value="pending" {{ request('payment_status') === 'pending' ? 'selected' : '' }}>Pending</option>
                </select>
            </div>
            <div>
                <label class="block text-xs font-semibold text-gray-700 mb-1.5">Month</label>
                <input type="month" name="month" class="w-full px-3 py-2 border border-gray-300 rounded-lg text-sm" value="{{ request('month') }}">
            </div>
            <div>
                <label class="block text-xs font-semibold text-gray-700 mb-1.5">Year</label>
                <select name="year" class="w-full px-3 py-2 border border-gray-300 rounded-lg text-sm">
                    <option value="">All Years</option>
                    @for ($y = now()->year; $y >= now()->year - 5; $y--)
                        <option value="{{ $y }}" {{ request('year') == $y ? 'selected' : '' }}>{{ $y }}</option>
                    @endfor
                </select>
            </div>
            <div>
                <label class="block text-xs font-semibold text-gray-700 mb-1.5">Search</label>
                <input type="text" name="search" class="w-full px-3 py-2 border border-gray-300 rounded-lg text-sm" placeholder="Client name..." value="{{ request('search') }}">
            </div>
            <div>
                <button type="submit" class="bg-[#772B10] hover:bg-[#5A1F0D] text-white px-6 py-2 rounded-lg font-medium text-sm w-full">
                    <i class="fas fa-search mr-2"></i>Search
                </button>
            </div>
        </form>
    </div>

    <div class="bg-white rounded-xl shadow-lg overflow-hidden">
        <div class="overflow-x-auto">
            <table class="w-full text-sm">
                <thead class="bg-gray-50 border-b border-gray-200">
                    <tr>
                        <th class="px-3 py-3 text-left text-xs font-semibold text-gray-900">Client</th>
                        <th class="px-3 py-3 text-right text-xs font-semibold text-gray-900">Will Amount</th>
                        <th class="px-3 py-3 text-right text-xs font-semibold text-gray-900">Paid</th>
                        <th class="px-3 py-3 text-right text-xs font-semibold text-gray-900">Outstanding</th>
                        <th class="px-3 py-3 text-left text-xs font-semibold text-gray-900">Status</th>
                        <th class="px-3 py-3 text-left text-xs font-semibold text-gray-900">Last Payment</th>
                        <th class="px-3 py-3 text-left text-xs font-semibold text-gray-900">Method</th>
                        <th class="px-3 py-3 text-left text-xs font-semibold text-gray-900">Recorded By</th>
                        <th class="px-3 py-3 text-left text-xs font-semibold text-gray-900">Will Written</th>
                        <th class="px-3 py-3 text-center text-xs font-semibold text-gray-900 no-print">Invoices</th>
                    </tr>
                </thead>
                <tbody class="divide-y divide-gray-200">
                    @forelse($rows as $i => $row)
                        <tr class="hover:bg-gray-50 text-xs">
                            <td class="px-3 py-2 font-medium text-gray-900">{{ $row['client_name'] }}<br><span class="text-gray-400">{{ $row['doc_type'] }} #{{ $row['doc_id'] }}</span></td>
                            <td class="px-3 py-2 text-right">RM {{ number_format($row['will_amount'], 2) }}</td>
                            <td class="px-3 py-2 text-right text-green-700 font-semibold">RM {{ number_format($row['total_paid'], 2) }}</td>
                            <td class="px-3 py-2 text-right {{ $row['outstanding_balance'] > 0 ? 'text-red-700 font-semibold' : 'text-gray-400' }}">RM {{ number_format($row['outstanding_balance'], 2) }}</td>
                            <td class="px-3 py-2">
                                <span class="px-2 py-0.5 rounded text-xs font-semibold
                                    @if($row['payment_status'] === 'paid') bg-green-100 text-green-800
                                    @elseif($row['payment_status'] === 'partial') bg-yellow-100 text-yellow-800
                                    @else bg-red-100 text-red-800 @endif">
                                    {{ ucfirst($row['payment_status']) }}
                                </span>
                            </td>
                            <td class="px-3 py-2 text-gray-600">{{ $row['last_payment_date'] ? \Carbon\Carbon::parse($row['last_payment_date'])->format('M d, Y') : '—' }}</td>
                            <td class="px-3 py-2 text-gray-600">{{ $row['last_payment_method'] ?? '—' }}</td>
                            <td class="px-3 py-2 text-gray-600">{{ $row['recorded_by'] ?? '—' }}</td>
                            <td class="px-3 py-2 text-gray-600">{{ \Carbon\Carbon::parse($row['will_written_date'])->format('M d, Y') }}</td>
                            <td class="px-3 py-2 text-center no-print">
                                <button type="button" onclick="document.getElementById('inv-{{ $i }}').classList.toggle('hidden')" class="text-[#772B10] hover:underline">
                                    {{ count($row['invoices']) }} <i class="fas fa-chevron-down"></i>
                                </button>
                            </td>
                        </tr>
                        <tr id="inv-{{ $i }}" class="hidden bg-gray-50">
                            <td colspan="10" class="px-6 py-4">
                                @if(count($row['invoices']))
                                    <table class="w-full text-xs">
                                        <thead><tr class="text-gray-500">
                                            <th class="text-left pb-1">Invoice #</th><th class="text-right pb-1">Amount</th><th class="text-left pb-1">Status</th><th class="text-left pb-1">Invoice Date</th><th class="text-left pb-1">Paid Date</th><th class="text-left pb-1">Method</th>
                                        </tr></thead>
                                        <tbody>
                                        @foreach($row['invoices'] as $inv)
                                            <tr>
                                                <td class="py-1">{{ $inv['invoice_number'] }}</td>
                                                <td class="py-1 text-right">RM {{ number_format($inv['amount'], 2) }}</td>
                                                <td class="py-1">{{ ucfirst($inv['status']) }}</td>
                                                <td class="py-1">{{ $inv['invoice_date'] ? \Carbon\Carbon::parse($inv['invoice_date'])->format('M d, Y') : '—' }}</td>
                                                <td class="py-1">{{ $inv['paid_date'] ? \Carbon\Carbon::parse($inv['paid_date'])->format('M d, Y') : '—' }}</td>
                                                <td class="py-1">{{ $inv['payment_method'] ?? '—' }}</td>
                                            </tr>
                                        @endforeach
                                        </tbody>
                                    </table>
                                @else
                                    <p class="text-gray-400 text-xs">No invoices recorded for this will yet.</p>
                                @endif
                            </td>
                        </tr>
                    @empty
                        <tr><td colspan="10" class="px-6 py-12 text-center text-gray-500">No records found</td></tr>
                    @endforelse
                </tbody>
            </table>
        </div>
        @if($rows instanceof \Illuminate\Pagination\LengthAwarePaginator && $rows->hasPages())
            <div class="px-6 py-4 border-t border-gray-200 bg-gray-50 no-print">{{ $rows->links() }}</div>
        @endif
    </div>
</div>
<style>@media print { .no-print { display: none !important; } }</style>
@endsection