@extends('layouts.portal')

@section('title', 'Wills Report')
@section('page_title', 'Wills Report')
@section('page_subtitle', 'Comprehensive will information and statistics')

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

@section('content')
<div class="max-w-full mx-auto px-6 py-8">
    <!-- Header with Export Button -->
    <div class="flex items-center justify-between mb-8">
        <div>
            <h1 class="text-3xl font-bold text-gray-900">Wills Report</h1>
            <p class="text-gray-600 mt-1">Total Wills: {{ $wills->total() }}</p>
        </div>
        <div class="flex gap-3">
            <a href="{{ route('admin.reports.master.index') }}" class="px-4 py-2 bg-gray-600 text-white rounded-lg hover:bg-gray-700 transition-colors">
                <i class="fas fa-arrow-left mr-2"></i>Back
            </a>
            <a href="{{ route('admin.reports.master.wills-export-pdf', array_merge(request()->query(), [])) }}" class="px-4 py-2 bg-red-600 text-white rounded-lg hover:bg-red-700 transition-colors">
                <i class="fas fa-file-pdf mr-2"></i>Export PDF
            </a>
            <a href="{{ route('admin.reports.master.wills-export', array_merge(request()->query(), [])) }}" class="px-4 py-2 bg-green-600 text-white rounded-lg hover:bg-green-700 transition-colors">
                <i class="fas fa-download mr-2"></i>Export Excel
            </a>
        </div>
    </div>

    <!-- Filters Section -->
    <div class="bg-white rounded-lg shadow-md p-6 mb-8">
        <form method="GET" action="{{ route('admin.reports.master.wills') }}" class="grid grid-cols-1 md:grid-cols-5 gap-4">
            <div>
                <label class="block text-sm font-medium text-gray-700 mb-2">Search (Client Name/IC)</label>
                <input type="text" name="search" value="{{ $search }}" placeholder="Enter name or IC..." class="w-full px-3 py-2 border border-gray-300 rounded-lg focus:outline-none focus:ring-2 focus:ring-blue-500">
            </div>
            <div>
                <label class="block text-sm font-medium text-gray-700 mb-2">Status</label>
                <select name="status" class="w-full px-3 py-2 border border-gray-300 rounded-lg focus:outline-none focus:ring-2 focus:ring-blue-500">
                    <option value="">All Statuses</option>
                    <option value="draft" {{ $status == 'draft' ? 'selected' : '' }}>Draft</option>
                    <option value="completed" {{ $status == 'completed' ? 'selected' : '' }}>Completed</option>
                    <option value="pending_approval" {{ $status == 'pending_approval' ? 'selected' : '' }}>Pending Approval</option>
                </select>
            </div>
            <div>
                <label class="block text-sm font-medium text-gray-700 mb-2">Month</label>
                <select name="month" class="w-full px-3 py-2 border border-gray-300 rounded-lg focus:outline-none focus:ring-2 focus:ring-blue-500">
                    <option value="">All Months</option>
                    <option value="1" {{ $month == 1 ? 'selected' : '' }}>January</option>
                    <option value="2" {{ $month == 2 ? 'selected' : '' }}>February</option>
                    <option value="3" {{ $month == 3 ? 'selected' : '' }}>March</option>
                    <option value="4" {{ $month == 4 ? 'selected' : '' }}>April</option>
                    <option value="5" {{ $month == 5 ? 'selected' : '' }}>May</option>
                    <option value="6" {{ $month == 6 ? 'selected' : '' }}>June</option>
                    <option value="7" {{ $month == 7 ? 'selected' : '' }}>July</option>
                    <option value="8" {{ $month == 8 ? 'selected' : '' }}>August</option>
                    <option value="9" {{ $month == 9 ? 'selected' : '' }}>September</option>
                    <option value="10" {{ $month == 10 ? 'selected' : '' }}>October</option>
                    <option value="11" {{ $month == 11 ? 'selected' : '' }}>November</option>
                    <option value="12" {{ $month == 12 ? 'selected' : '' }}>December</option>
                </select>
            </div>
            <div>
                <label class="block text-sm font-medium text-gray-700 mb-2">Year</label>
                <select name="year" class="w-full px-3 py-2 border border-gray-300 rounded-lg focus:outline-none focus:ring-2 focus:ring-blue-500">
                    <option value="">All Years</option>
                    @foreach($years as $y)
                    <option value="{{ $y }}" {{ $year == $y ? 'selected' : '' }}>{{ $y }}</option>
                    @endforeach
                </select>
            </div>
            <div class="flex items-end gap-2">
                <button type="submit" class="flex-1 px-4 py-2 bg-blue-600 text-white rounded-lg hover:bg-blue-700 transition-colors">
                    <i class="fas fa-search mr-2"></i>Filter
                </button>
                <a href="{{ route('admin.reports.master.wills') }}" class="px-4 py-2 bg-gray-400 text-white rounded-lg hover:bg-gray-500 transition-colors">
                    <i class="fas fa-redo mr-2"></i>Reset
                </a>
            </div>
        </form>
    </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-100 border-b-2 border-gray-300">
                        <th class="px-3 py-3 text-left font-semibold text-gray-700 whitespace-nowrap">Doc Type</th>
                        <th class="px-3 py-3 text-left font-semibold text-gray-700 whitespace-nowrap">Will ID</th>
                        <th class="px-3 py-3 text-left font-semibold text-gray-700 whitespace-nowrap">Client Name</th>
                        <th class="px-3 py-3 text-left font-semibold text-gray-700 whitespace-nowrap">Client IC</th>
                        <th class="px-3 py-3 text-left font-semibold text-gray-700 whitespace-nowrap">Will Type</th>
                        <th class="px-3 py-3 text-center font-semibold text-gray-700 whitespace-nowrap">Status</th>
                        <th class="px-3 py-3 text-center font-semibold text-gray-700 whitespace-nowrap">Created Date</th>
                        <th class="px-3 py-3 text-center font-semibold text-gray-700 whitespace-nowrap">Created By</th>
                        <th class="px-3 py-3 text-center font-semibold text-gray-700 whitespace-nowrap">Version</th>
                        <th class="px-3 py-3 text-center font-semibold text-gray-700 whitespace-nowrap">Version Date</th>
                        <th class="px-3 py-3 text-center font-semibold text-gray-700 whitespace-nowrap">Version Edited By</th>
                        <th class="px-3 py-3 text-center font-semibold text-gray-700 whitespace-nowrap">Invoice Raised</th>
                        <th class="px-3 py-3 text-center font-semibold text-gray-700 whitespace-nowrap">Invoice Date</th>
                        <th class="px-3 py-3 text-right font-semibold text-gray-700 whitespace-nowrap">Subtotal (RM)</th>
                        <th class="px-3 py-3 text-right font-semibold text-gray-700 whitespace-nowrap">Tax (RM)</th>
                        <th class="px-3 py-3 text-right font-semibold text-gray-700 whitespace-nowrap">Discount (RM)</th>
                        <th class="px-3 py-3 text-right font-semibold text-gray-700 whitespace-nowrap bg-blue-50">Total (RM)</th>
                        <th class="px-3 py-3 text-right font-semibold text-gray-700 whitespace-nowrap">L1 Commission (RM)</th>
                        <th class="px-3 py-3 text-right font-semibold text-gray-700 whitespace-nowrap">L2 Commission (RM)</th>
                        <th class="px-3 py-3 text-right font-semibold text-gray-700 whitespace-nowrap">L3 Commission (RM)</th>
                        <th class="px-3 py-3 text-right font-semibold text-gray-700 whitespace-nowrap bg-red-50">Total Commission (RM)</th>
                        <th class="px-3 py-3 text-right font-semibold text-gray-700 whitespace-nowrap">Lawyer Commission (RM)</th>
                        <th class="px-3 py-3 text-center font-semibold text-gray-700 whitespace-nowrap">Creator Role</th>
                        <th class="px-3 py-3 text-right font-semibold text-gray-700 whitespace-nowrap bg-green-50">Net Profit (RM)</th>
                        <th class="px-3 py-3 text-right font-semibold text-gray-700 whitespace-nowrap">Edit Request Profit (RM)</th>
                        <th class="px-3 py-3 text-center font-semibold text-gray-700 whitespace-nowrap">Edit Payment Date</th>
                        <th class="px-3 py-3 text-left font-semibold text-gray-700 whitespace-nowrap">Sections Edited</th>
                        <th class="px-3 py-3 text-right font-semibold text-gray-700 whitespace-nowrap bg-yellow-50">Total Profit (RM)</th>
                        <th class="px-3 py-3 text-center font-semibold text-gray-700 whitespace-nowrap">Admin Approved</th>
                        <th class="px-3 py-3 text-center font-semibold text-gray-700 whitespace-nowrap">Approval Date</th>
                        <th class="px-3 py-3 text-left font-semibold text-gray-700 whitespace-nowrap">Witness Names</th>
                    </tr>
                </thead>
                <tbody class="divide-y">
                    @forelse($wills as $will)
                    <tr class="hover:bg-gray-50 transition-colors">
                        <td class="px-3 py-3 text-center">
                            <span class="inline-block px-2 py-1 {{ $will['document_type'] === 'Will' ? 'bg-purple-100 text-purple-800' : 'bg-violet-100 text-violet-800' }} rounded text-xs font-semibold">{{ $will['document_type'] }}</span>
                        </td>
                        <td class="px-3 py-3 font-mono text-xs text-gray-600">{{ $will['id'] }}</td>
                        <td class="px-3 py-3 font-medium text-gray-900">{{ $will['client_name'] }}</td>
                        <td class="px-3 py-3 text-gray-600">{{ $will['client_ic'] }}</td>
                        <td class="px-3 py-3 text-gray-600">{{ ucfirst(str_replace('_', ' ', $will['will_type'])) }}</td>
                        <td class="px-3 py-3 text-center">
                            @php
                            $statusClass = match($will['status']) {
                                'completed' => 'bg-green-100 text-green-800',
                                'draft' => 'bg-yellow-100 text-yellow-800',
                                'pending_approval' => 'bg-orange-100 text-orange-800',
                                default => 'bg-gray-100 text-gray-800'
                            };
                            @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-3 py-3 text-center text-gray-600">{{ is_string($will['created_at']) ? $will['created_at'] : $will['created_at']->format('d M Y') }}</td>
                        <td class="px-3 py-3 text-center text-gray-600">{{ $will['created_by_name'] }}</td>
                        <td class="px-3 py-3 text-center font-bold text-blue-600">v{{ $will['version'] }}</td>
                        <td class="px-3 py-3 text-center text-gray-600">{{ is_string($will['version_date']) ? $will['version_date'] : $will['version_date']->format('d M Y H:i') }}</td>
                        <td class="px-3 py-3 text-center text-sm">
                            <div class="flex flex-col gap-1">
                                <span class="font-medium text-gray-900">{{ $will['version_edited_by'] }}</span>
                                <span class="px-2 py-1 inline-block rounded text-xs font-semibold {{ match($will['version_edited_by_role']) {
                                    'Client' => 'bg-green-100 text-green-800',
                                    'Agent' => 'bg-blue-100 text-blue-800',
                                    'Lawyer' => 'bg-purple-100 text-purple-800',
                                    'Admin' => 'bg-red-100 text-red-800',
                                    'Staff' => 'bg-yellow-100 text-yellow-800',
                                    default => 'bg-gray-100 text-gray-800'
                                } }}">{{ $will['version_edited_by_role'] }}</span>
                            </div>
                        </td>
                        <td class="px-3 py-3 text-center">
                            <span class="inline-block px-2 py-1 {{ $will['invoice_raised'] === 'Yes' ? 'bg-green-100 text-green-800' : 'bg-gray-100 text-gray-800' }} rounded text-xs font-semibold">{{ $will['invoice_raised'] }}</span>
                        </td>
                        <td class="px-3 py-3 text-center text-gray-600">{{ $will['invoice_date'] ? (is_string($will['invoice_date']) ? $will['invoice_date'] : $will['invoice_date']->format('d M Y')) : '-' }}</td>
                        <td class="px-3 py-3 text-right text-gray-900 font-semibold">{{ number_format($will['subtotal'], 2) }}</td>
                        <td class="px-3 py-3 text-right text-gray-900 font-semibold {{ $will['tax'] > 0 ? 'text-blue-600' : 'text-gray-600' }}">{{ number_format($will['tax'], 2) }}</td>
                        <td class="px-3 py-3 text-right text-gray-900 font-semibold {{ $will['discount'] > 0 ? 'text-orange-600' : 'text-gray-600' }}">{{ number_format($will['discount'], 2) }}</td>
                        <td class="px-3 py-3 text-right font-bold text-green-600 bg-blue-50">{{ number_format($will['invoice_amount'], 2) }}</td>
                        <td class="px-3 py-3 text-right font-semibold {{ $will['l1_commission'] > 0 ? 'text-red-600' : 'text-gray-600' }}">{{ number_format($will['l1_commission'], 2) }}</td>
                        <td class="px-3 py-3 text-right font-semibold {{ $will['l2_commission'] > 0 ? 'text-red-600' : 'text-gray-600' }}">{{ number_format($will['l2_commission'], 2) }}</td>
                        <td class="px-3 py-3 text-right font-semibold {{ $will['l3_commission'] > 0 ? 'text-red-600' : 'text-gray-600' }}">{{ number_format($will['l3_commission'], 2) }}</td>
                        <td class="px-3 py-3 text-right font-bold text-red-700 bg-red-50">{{ number_format($will['total_commission'], 2) }}</td>
                        <td class="px-3 py-3 text-right font-semibold {{ $will['lawyer_commission'] > 0 ? 'text-purple-600' : 'text-gray-600' }}">{{ number_format($will['lawyer_commission'], 2) }}</td>
                        <td class="px-3 py-3 text-center">
                            @php
                            $roleClass = match($will['created_by_role']) {
                                'agent' => 'bg-blue-100 text-blue-800',
                                'lawyer' => 'bg-purple-100 text-purple-800',
                                default => 'bg-gray-100 text-gray-800'
                            };
                            @endphp
                            <span class="inline-block px-2 py-1 {{ $roleClass }} rounded text-xs font-semibold">{{ ucfirst($will['created_by_role']) }}</span>
                        </td>
                        <td class="px-3 py-3 text-right font-bold {{ $will['will_profit'] >= 0 ? 'text-green-600' : 'text-red-600' }} bg-green-50">
                                    {{ number_format($will['will_profit'], 2) }}
                                    <span class="text-xs text-gray-500 block">({{ number_format($will['invoice_amount'], 2) }} - {{ number_format($will['total_commission'], 2) }})</span>
                                </td>
                        <td class="px-3 py-3 text-right font-bold {{ $will['edit_request_profit'] >= 0 ? 'text-blue-600' : 'text-gray-600' }}">{{ number_format($will['edit_request_profit'], 2) }}</td>
                        <td class="px-3 py-3 text-center text-gray-600">{{ $will['edit_request_payment_date'] ? (is_string($will['edit_request_payment_date']) ? $will['edit_request_payment_date'] : $will['edit_request_payment_date']->format('d M Y H:i')) : '-' }}</td>
                        <td class="px-3 py-3 text-left text-xs">
                            @if(count($will['edited_sections']) > 0)
                            <span class="inline-flex flex-wrap gap-1">
                                @foreach($will['edited_sections'] as $section)
                                <span class="px-2 py-1 bg-blue-100 text-blue-800 rounded text-xs font-semibold whitespace-nowrap">{{ ucfirst(str_replace('_', ' ', $section)) }}</span>
                                @endforeach
                            </span>
                            @else
                            <span class="text-gray-400">-</span>
                            @endif
                        </td>
                        <td class="px-3 py-3 text-right font-bold {{ $will['total_profit'] >= 0 ? 'text-green-600' : 'text-red-600' }} bg-yellow-50">
                                    {{ number_format($will['total_profit'], 2) }}
                                    <span class="text-xs text-gray-500 block">({{ number_format($will['will_profit'], 2) }} + {{ number_format($will['edit_request_profit'], 2) }})</span>
                                </td>
                        <td class="px-3 py-3 text-center">
                            <span class="inline-block px-2 py-1 {{ $will['admin_approved'] === 'Yes' ? 'bg-green-100 text-green-800' : 'bg-gray-100 text-gray-800' }} rounded text-xs font-semibold">{{ $will['admin_approved'] }}</span>
                        </td>
                        <td class="px-3 py-3 text-center text-gray-600">{{ $will['approval_date'] ? (is_string($will['approval_date']) ? $will['approval_date'] : $will['approval_date']->format('d M Y H:i')) : '-' }}</td>
                        <td class="px-3 py-3 text-gray-600 text-xs">{{ $will['witness_names'] ?: '-' }}</td>
                    </tr>
                    @empty
                    <tr>
                        <td colspan="30" 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 or trusts found
                        </td>
                    </tr>
                    @endforelse
                </tbody>
            </table>
        </div>

        <!-- Pagination -->
        <div class="bg-white border-t px-6 py-4">
            {{ $wills->links('pagination::tailwind') }}
        </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);
    }
</style>
@endsection