@extends('layouts.portal')

@section('title', 'Will Report')
@section('page_title', 'Will Report')
@section('page_subtitle', 'Every will and trust, its progress, and the agents earning commission on it')

@section('sidebar')
    @include('agent.partials.sidebar', ['active' => 'reports-wills'])
@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">Will Report</h1>
                <p class="text-gray-600 mt-2">Type, version, writer, approval, commission by level, and full timeline 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.wills.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.wills.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 Documents</p>
                <h3 class="text-3xl font-bold mt-1">{{ $stats['total_wills'] }}</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">Approved</p>
                <h3 class="text-3xl font-bold mt-1">{{ $stats['approved_wills'] }}</h3>
            </div>
            <div class="bg-gradient-to-br from-amber-500 to-amber-600 rounded-lg p-4 text-white">
                <p class="text-amber-100 text-sm font-medium">Pending</p>
                <h3 class="text-3xl font-bold mt-1">{{ $stats['pending_wills'] }}</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">Total Commission</p>
                <h3 class="text-3xl font-bold mt-1">RM {{ number_format($stats['total_commission'], 2) }}</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">Will Status</label>
                <select name="will_status" class="w-full px-3 py-2 border border-gray-300 rounded-lg text-sm">
                    <option value="">All Status</option>
                    @foreach(['draft','under_review','approved','completed','rejected'] as $s)
                        <option value="{{ $s }}" {{ request('will_status') === $s ? 'selected' : '' }}>{{ ucfirst($s) }}</option>
                    @endforeach
                </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 or IC..." 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-left text-xs font-semibold text-gray-900">IC</th>
                        <th class="px-3 py-3 text-left text-xs font-semibold text-gray-900">Document</th>
                        <th class="px-3 py-3 text-left text-xs font-semibold text-gray-900">Type</th>
                        <th class="px-3 py-3 text-center text-xs font-semibold text-gray-900">Ver</th>
                        <th class="px-3 py-3 text-left text-xs font-semibold text-gray-900">Writer</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">Approved</th>
                        <th class="px-3 py-3 text-left text-xs font-semibold text-gray-900">L1</th>
                        <th class="px-3 py-3 text-left text-xs font-semibold text-gray-900">L2</th>
                        <th class="px-3 py-3 text-left text-xs font-semibold text-gray-900">L3</th>
                        <th class="px-3 py-3 text-center text-xs font-semibold text-gray-900 no-print">Details</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-gray-600">{{ $row['ic_number'] }}</td>
                            <td class="px-3 py-2">
                                <span class="px-2 py-0.5 rounded text-xs font-semibold {{ $row['doc_type'] === 'Trust' ? 'bg-indigo-100 text-indigo-800' : 'bg-blue-100 text-blue-800' }}">{{ $row['doc_type'] }}</span>
                            </td>
                            <td class="px-3 py-2 text-gray-600">{{ ucfirst($row['doc_subtype'] ?? '-') }}</td>
                            <td class="px-3 py-2 text-center font-semibold">{{ $row['version'] }}</td>
                            <td class="px-3 py-2 text-gray-600">{{ $row['will_writer'] }}<br><span class="text-gray-400">{{ ucfirst($row['will_writer_role']) }}</span></td>
                            <td class="px-3 py-2">
                                <span class="px-2 py-0.5 rounded text-xs font-semibold
                                    @if(in_array($row['status'], ['approved','completed','stored'])) bg-green-100 text-green-800
                                    @elseif(in_array($row['status'], ['under_review','pending_approval'])) bg-yellow-100 text-yellow-800
                                    @elseif($row['status'] === 'rejected') bg-red-100 text-red-800
                                    @else bg-gray-100 text-gray-800 @endif">
                                    {{ ucfirst(str_replace('_',' ',$row['status'] ?? '-')) }}
                                </span>
                            </td>
                            <td class="px-3 py-2 text-gray-600">
                                @if($row['approved_at'])
                                    {{ \Carbon\Carbon::parse($row['approved_at'])->format('M d, Y') }}<br>
                                    <span class="text-gray-400">{{ $row['approved_by'] ?? '-' }}</span>
                                @else
                                    <span class="text-gray-400">Pending</span>
                                @endif
                            </td>
                            @foreach(['l1','l2','l3'] as $level)
                                <td class="px-3 py-2">
                                    @if($row[$level]['agent_name'])
                                        {{ $row[$level]['agent_name'] }}<br>
                                        <span class="font-semibold">RM {{ number_format($row[$level]['amount'], 2) }}</span>
                                        <span class="px-1 py-0.5 rounded {{ $row[$level]['status'] === 'paid' ? 'bg-green-100 text-green-800' : 'bg-yellow-100 text-yellow-800' }}">{{ ucfirst($row[$level]['status'] ?? '') }}</span>
                                    @else
                                        <span class="text-gray-400">&mdash;</span>
                                    @endif
                                </td>
                            @endforeach
                            <td class="px-3 py-2 text-center no-print">
                                <button type="button" onclick="document.getElementById('detail-{{ $i }}').classList.toggle('hidden')" class="text-[#772B10] hover:underline">
                                    <i class="fas fa-eye"></i>
                                </button>
                            </td>
                        </tr>
                        <tr id="detail-{{ $i }}" class="hidden bg-gray-50">
                            <td colspan="12" class="px-6 py-4">
                                <div class="grid grid-cols-1 md:grid-cols-2 gap-6 text-xs">
                                    <div>
                                        <p class="font-semibold text-gray-700 mb-2"><i class="fas fa-history mr-1"></i>Timeline</p>
                                        @forelse($row['timeline'] as $event)
                                            <p class="text-gray-600">{{ $event['label'] }} &mdash; {{ \Carbon\Carbon::parse($event['date'])->format('d M Y, h:i A') }}</p>
                                        @empty
                                            <p class="text-gray-400">No timeline events recorded.</p>
                                        @endforelse
                                    </div>
                                    <div>
                                        <p class="font-semibold text-gray-700 mb-2"><i class="fas fa-calendar-check mr-1"></i>Client Appointments</p>
                                        @forelse($row['appointments'] as $appt)
                                            <p class="text-gray-600">{{ \Carbon\Carbon::parse($appt['appointment_date'])->format('d M Y, h:i A') }} &mdash; {{ ucfirst($appt['status']) }}</p>
                                        @empty
                                            <p class="text-gray-400">No appointments on record for this client.</p>
                                        @endforelse
                                    </div>
                                </div>
                            </td>
                        </tr>
                    @empty
                        <tr><td colspan="12" class="px-6 py-12 text-center text-gray-500">No wills 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