@extends('layouts.portal')

@section('title', 'Advanced Will Report')
@section('page_title', 'Advanced Will Report')
@section('page_subtitle', 'Complete Will Details with Versions and Payments')

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

@section('content')
<div class="max-w-7xl mx-auto px-6 py-8">
    <!-- Header -->
    <div class="flex items-center justify-between mb-8">
        <div>
            <h1 class="text-3xl font-bold text-gray-900">Advanced Will Report</h1>
            <p class="text-gray-600 mt-1">Total Wills: {{ $willsData->count() }}</p>
        </div>
        <a href="{{ route('admin.reports.master.index') }}" class="px-4 py-2 bg-gray-600 text-white rounded-lg hover:bg-gray-700">
            <i class="fas fa-arrow-left mr-2"></i>Back
        </a>
    </div>

    <!-- Wills Table -->
    <div class="bg-white rounded-lg shadow-md overflow-hidden">
        <div class="overflow-x-auto">
            <table class="w-full text-xs">
                <thead>
                    <tr class="bg-gray-900 text-white">
                        <th class="px-4 py-3 text-left font-semibold">Will ID</th>
                        <th class="px-4 py-3 text-left font-semibold">Client Name</th>
                        <th class="px-4 py-3 text-left font-semibold">Email</th>
                        
                        <th class="px-4 py-3 text-center font-semibold bg-blue-900">Will Type</th>
                        <th class="px-4 py-3 text-center font-semibold bg-blue-900">Status</th>
                        <th class="px-4 py-3 text-center font-semibold bg-blue-900">Version</th>
                        
                        <th class="px-4 py-3 text-left font-semibold bg-green-900">Created Date</th>
                        <th class="px-4 py-3 text-left font-semibold bg-green-900">Updated Date</th>
                        
                        <th class="px-4 py-3 text-center font-semibold bg-purple-900">Beneficiaries</th>
                        <th class="px-4 py-3 text-center font-semibold bg-purple-900">Liabilities</th>
                        
                        <th class="px-4 py-3 text-center font-semibold bg-orange-900">Paid by Client</th>
                        <th class="px-4 py-3 text-left font-semibold bg-orange-900">Payment Date</th>
                        <th class="px-4 py-3 text-right font-semibold bg-orange-900">Payment Amount</th>
                    </tr>
                </thead>
                <tbody class="divide-y">
                    @forelse($willsData as $will)
                    <tr class="hover:bg-gray-50 transition-colors">
                        <td class="px-4 py-3 font-mono font-bold text-blue-600">#{{ $will['id'] }}</td>
                        <td class="px-4 py-3 font-medium text-gray-900">{{ $will['client_name'] }}</td>
                        <td class="px-4 py-3 text-gray-600 text-xs">{{ $will['client_email'] }}</td>
                        
                        <td class="px-4 py-3 text-center bg-blue-50">
                            <span class="inline-block px-2 py-1 bg-blue-200 text-blue-900 rounded text-xs font-semibold">
                                {{ ucfirst($will['will_type']) }}
                            </span>
                        </td>
                        <td class="px-4 py-3 text-center bg-blue-50">
                            @php
                                $statusClass = match($will['status']) {
                                    'completed' => 'bg-green-200 text-green-900',
                                    'draft' => 'bg-yellow-200 text-yellow-900',
                                    'pending_approval' => 'bg-orange-200 text-orange-900',
                                    default => 'bg-gray-200 text-gray-900'
                                };
                            @endphp
                            <span class="inline-block px-2 py-1 {{ $statusClass }} rounded text-xs font-semibold">
                                {{ ucfirst(str_replace('_', ' ', $will['status'])) }}
                            </span>
                        </td>
                        <td class="px-4 py-3 text-center bg-blue-50 font-bold text-blue-900">{{ $will['version'] }}</td>
                        
                        <td class="px-4 py-3 bg-green-50 text-green-900 font-semibold text-xs">{{ $will['created_at'] }}</td>
                        <td class="px-4 py-3 bg-green-50 text-green-900 font-semibold text-xs">{{ $will['updated_at'] }}</td>
                        
                        <td class="px-4 py-3 text-center bg-purple-50">
                            <span class="inline-block px-2 py-1 bg-purple-200 text-purple-900 rounded-full text-xs font-semibold">
                                {{ $will['beneficiaries_count'] }}
                            </span>
                        </td>
                        <td class="px-4 py-3 text-center bg-purple-50">
                            <span class="inline-block px-2 py-1 bg-purple-200 text-purple-900 rounded-full text-xs font-semibold">
                                {{ $will['liabilities_count'] }}
                            </span>
                        </td>
                        
                        <td class="px-4 py-3 text-center bg-orange-50">
                            @if($will['paid_by_client'] === 'Yes ✓')
                                <span class="inline-block px-2 py-1 bg-green-200 text-green-900 rounded text-xs font-bold">✓ YES</span>
                            @else
                                <span class="inline-block px-2 py-1 bg-red-200 text-red-900 rounded text-xs font-bold">✗ NO</span>
                            @endif
                        </td>
                        <td class="px-4 py-3 bg-orange-50 text-orange-900 font-semibold text-xs">{{ $will['payment_date'] }}</td>
                        <td class="px-4 py-3 text-right bg-orange-50 font-bold text-orange-900">{{ $will['payment_amount'] }}</td>
                    </tr>
                    @empty
                    <tr>
                        <td colspan="13" class="px-6 py-12 text-center text-gray-500">
                            <i class="fas fa-inbox text-3xl mb-3 block opacity-50"></i>
                            No wills found
                        </td>
                    </tr>
                    @endforelse
                </tbody>
            </table>
        </div>

        <!-- Summary Footer -->
        <div class="bg-gray-50 border-t px-6 py-4">
            <div class="grid grid-cols-2 md:grid-cols-6 gap-4 text-sm">
                <div>
                    <p class="text-gray-600 font-medium">Total Wills</p>
                    <p class="text-2xl font-bold text-gray-900">{{ $willsData->count() }}</p>
                </div>
                <div>
                    <p class="text-gray-600 font-medium">Completed</p>
                    <p class="text-2xl font-bold text-green-600">{{ $willsData->where('status', 'completed')->count() }}</p>
                </div>
                <div>
                    <p class="text-gray-600 font-medium">Total Beneficiaries</p>
                    <p class="text-2xl font-bold text-purple-600">{{ $willsData->sum('beneficiaries_count') }}</p>
                </div>
                <div>
                    <p class="text-gray-600 font-medium">Total Liabilities</p>
                    <p class="text-2xl font-bold text-purple-600">{{ $willsData->sum('liabilities_count') }}</p>
                </div>
                <div>
                    <p class="text-gray-600 font-medium">Paid Wills</p>
                    <p class="text-2xl font-bold text-orange-600">{{ $willsData->filter(function($w) { return $w['paid_by_client'] === 'Yes ✓'; })->count() }}</p>
                </div>
                <div>
                    <p class="text-gray-600 font-medium">Pending Payment</p>
                    <p class="text-2xl font-bold text-red-600">{{ $willsData->filter(function($w) { return $w['paid_by_client'] === 'No'; })->count() }}</p>
                </div>
            </div>
        </div>
    </div>

    <!-- Color Legend -->
    <div class="mt-8 grid grid-cols-2 md:grid-cols-4 gap-4">
        <div class="bg-blue-50 border border-blue-200 rounded-lg p-3">
            <p class="text-xs font-semibold text-blue-900">📋 Will Info</p>
        </div>
        <div class="bg-green-50 border border-green-200 rounded-lg p-3">
            <p class="text-xs font-semibold text-green-900">📅 Dates</p>
        </div>
        <div class="bg-purple-50 border border-purple-200 rounded-lg p-3">
            <p class="text-xs font-semibold text-purple-900">👥 Beneficiaries & Liab.</p>
        </div>
        <div class="bg-orange-50 border border-orange-200 rounded-lg p-3">
            <p class="text-xs font-semibold text-orange-900">💳 Payment Status</p>
        </div>
    </div>
</div>

<style>
    .sidebar-item.active a {
        background-color: rgba(59, 130, 246, 0.1);
        border-left: 3px solid #3b82f6;
        padding-left: calc(0.5rem - 3px);
    }
    
    @media (max-width: 768px) {
        table {
            min-width: 1600px;
        }
    }
</style>
@endsection