@extends('layouts.portal')

@section('title', 'Clients Report')
@section('page_title', 'Clients Report')
@section('page_subtitle', 'Detailed client information with will status and payment details')

@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">Clients Report</h1>
            <p class="text-gray-600 mt-1">Total Clients: {{ $clients->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.clients-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.clients-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.clients') }}" class="grid grid-cols-1 md:grid-cols-4 gap-4">
            <div>
                <label class="block text-sm font-medium text-gray-700 mb-2">Search (Name/IC/Phone)</label>
                <input type="text" name="search" value="{{ $search }}" placeholder="Enter name, IC, or phone..." 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">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.clients') }}" 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>

    <!-- Clients Table -->
    <div class="bg-white rounded-lg shadow-md overflow-hidden">
        <div class="overflow-x-auto">
            <table class="w-full text-sm">
                <thead>
                    <tr class="bg-gray-100 border-b-2 border-gray-300">
                        <th class="px-4 py-3 text-left font-semibold text-gray-700">Client Name</th>
                        <th class="px-4 py-3 text-left font-semibold text-gray-700">Email</th>
                        <th class="px-4 py-3 text-left font-semibold text-gray-700">Phone</th>
                        <th class="px-4 py-3 text-left font-semibold text-gray-700">IC Number</th>
                        <th class="px-4 py-3 text-left font-semibold text-gray-700">Address</th>
                        <th class="px-4 py-3 text-left font-semibold text-gray-700">Created By</th>
                        <th class="px-4 py-3 text-center font-semibold text-gray-700">Will Type</th>
                        <th class="px-4 py-3 text-center font-semibold text-gray-700">Status</th>
                        <th class="px-4 py-3 text-center font-semibold text-gray-700">Versions</th>
                        <th class="px-4 py-3 text-left font-semibold text-gray-700">Last Version Date</th>
                        <th class="px-4 py-3 text-left font-semibold text-gray-700">Changed By</th>
                        <th class="px-4 py-3 text-right font-semibold text-gray-700">Subtotal</th>
                        <th class="px-4 py-3 text-right font-semibold text-gray-700">Discount</th>
                        <th class="px-4 py-3 text-right font-semibold text-gray-700">Tax</th>
                        <th class="px-4 py-3 text-right font-semibold text-gray-700">Total Invoice</th>
                        <th class="px-4 py-3 text-right font-semibold text-gray-700">Paid</th>
                        <th class="px-4 py-3 text-center font-semibold text-gray-700">Payment Status</th>
                        <th class="px-4 py-3 text-left font-semibold text-gray-700">Paid Date</th>
                    </tr>
                </thead>
                <tbody class="divide-y">
                    @forelse($clients as $client)
                        @if($client['wills']->isNotEmpty())
                            @foreach($client['wills'] as $willIndex => $will)
                            <tr class="hover:bg-gray-50 transition-colors">
                                @if($willIndex === 0)
                                <!-- Show client info only on first will row -->
                                <td class="px-4 py-3 font-bold text-gray-900" rowspan="{{ $client['wills']->count() }}">{{ $client['name'] }}</td>
                                <td class="px-4 py-3 text-gray-600" rowspan="{{ $client['wills']->count() }}">{{ $client['email'] }}</td>
                                <td class="px-4 py-3 text-gray-600" rowspan="{{ $client['wills']->count() }}">{{ $client['phone'] ?? 'N/A' }}</td>
                                <td class="px-4 py-3 text-gray-600 text-xs" rowspan="{{ $client['wills']->count() }}">{{ $client['ic_number'] ?? 'N/A' }}</td>
                                <td class="px-4 py-3 text-gray-600 text-xs" rowspan="{{ $client['wills']->count() }}">{{ $client['address'] }}</td>
                                <td class="px-4 py-3 text-gray-700 font-medium" rowspan="{{ $client['wills']->count() }}">{{ $client['created_by'] }} ({{ $client['created_by_role'] }})</td>
                                @endif
                                <!-- Will Details -->
                                <td class="px-4 py-3 text-center"><span class="inline-block px-2 py-1 bg-indigo-100 text-indigo-800 rounded text-xs font-semibold">{{ $will['type'] }}</span></td>
                                <td class="px-4 py-3 text-center">
                                    @if($will['status'] === 'completed')
                                        <span class="inline-block px-2 py-1 bg-green-100 text-green-800 rounded text-xs font-semibold">{{ ucfirst($will['status']) }}</span>
                                    @elseif($will['status'] === 'approved')
                                        <span class="inline-block px-2 py-1 bg-blue-100 text-blue-800 rounded text-xs font-semibold">{{ ucfirst($will['status']) }}</span>
                                    @elseif($will['status'] === 'pending')
                                        <span class="inline-block px-2 py-1 bg-yellow-100 text-yellow-800 rounded text-xs font-semibold">{{ ucfirst($will['status']) }}</span>
                                    @else
                                        <span class="inline-block px-2 py-1 bg-gray-100 text-gray-800 rounded text-xs font-semibold">{{ ucfirst($will['status']) }}</span>
                                    @endif
                                </td>
                                <td class="px-4 py-3 text-center"><span class="inline-block px-2 py-1 bg-purple-100 text-purple-800 rounded font-semibold text-xs">{{ $will['versions_count'] }}</span></td>
                                <td class="px-4 py-3 text-sm text-gray-700">@if($will['last_version_date']){{ $will['last_version_date']->format('d M Y H:i') }}@else—@endif</td>
                                <td class="px-4 py-3 text-sm text-gray-700">{{ $will['last_version_by'] }}</td>
                                <td class="px-4 py-3 text-right font-medium text-gray-900">RM {{ number_format($will['subtotal'] ?? 0, 2) }}</td>
                                <td class="px-4 py-3 text-right font-medium text-red-600">-RM {{ number_format($will['discount_amount'] ?? 0, 2) }}</td>
                                <td class="px-4 py-3 text-right font-medium text-blue-600">+RM {{ number_format($will['tax_amount'] ?? 0, 2) }}</td>
                                <td class="px-4 py-3 text-right font-bold text-gray-900">RM {{ number_format($will['total_invoiced'], 2) }}</td>
                                <td class="px-4 py-3 text-right font-medium text-green-600">RM {{ number_format($will['total_paid'], 2) }}</td>
                                <td class="px-4 py-3 text-center">
                                    @if($will['total_invoiced'] === 0)
                                    <span class="inline-block px-2 py-1 bg-gray-100 text-gray-800 rounded text-xs font-semibold">No Invoice</span>
                                    @elseif($will['is_paid'])
                                    <span class="inline-block px-2 py-1 bg-green-100 text-green-800 rounded text-xs font-semibold">✓ Paid</span>
                                    @else
                                    <span class="inline-block px-2 py-1 bg-red-100 text-red-800 rounded text-xs font-semibold">Pending</span>
                                    @endif
                                </td>
                                <td class="px-4 py-3 text-sm text-gray-700">@if($will['paid_date']){{ $will['paid_date']->format('d M Y H:i') }}@else—@endif</td>
                            </tr>
                            @endforeach
                        @else
                            <tr class="hover:bg-gray-50 transition-colors">
                            <td class="px-4 py-3 font-bold text-gray-900">{{ $client['name'] }}</td>
                            <td class="px-4 py-3 text-gray-600">{{ $client['email'] }}</td>
                            <td class="px-4 py-3 text-gray-600">{{ $client['phone'] ?? 'N/A' }}</td>
                            <td class="px-4 py-3 text-gray-600 text-xs">{{ $client['ic_number'] ?? 'N/A' }}</td>
                            <td class="px-4 py-3 text-gray-600 text-xs">{{ $client['address'] }}</td>
                            <td class="px-4 py-3 text-gray-700 font-medium">{{ $client['created_by'] }} ({{ $client['created_by_role'] }})</td>
                            <td colspan="12" class="px-4 py-3 text-center text-gray-500 italic">No wills created</td>
                        </tr>
                        @endif
                    @empty
                    <tr>
                        <td colspan="18" class="px-4 py-12 text-center text-gray-500">
                            <i class="fas fa-inbox text-3xl mb-3 block opacity-50"></i>
                            No clients 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-8 gap-4 text-sm">
                <div>
                    <p class="text-gray-600 font-medium">Total Clients</p>
                    <p class="text-2xl font-bold text-gray-900">{{ $clients->total() }}</p>
                </div>
                <div>
                    <p class="text-gray-600 font-medium">Total Wills</p>
                    <p class="text-2xl font-bold text-blue-600">{{ $clients->sum('wills_count') }}</p>
                </div>
                <div>
                    <p class="text-gray-600 font-medium">Total Subtotal</p>
                    <p class="text-lg font-bold text-gray-900">RM {{ number_format($clients->sum(fn($c) => $c['wills']->sum('subtotal')), 0) }}</p>
                </div>
                <div>
                    <p class="text-gray-600 font-medium">Total Discount</p>
                    <p class="text-lg font-bold text-red-600">-RM {{ number_format($clients->sum(fn($c) => $c['wills']->sum('discount_amount')), 0) }}</p>
                </div>
                <div>
                    <p class="text-gray-600 font-medium">Total Tax</p>
                    <p class="text-lg font-bold text-blue-600">+RM {{ number_format($clients->sum(fn($c) => $c['wills']->sum('tax_amount')), 0) }}</p>
                </div>
                <div>
                    <p class="text-gray-600 font-medium">Total Invoiced</p>
                    <p class="text-lg font-bold text-gray-900">RM {{ number_format($clients->sum(fn($c) => $c['wills']->sum('total_invoiced')), 0) }}</p>
                </div>
                <div>
                    <p class="text-gray-600 font-medium">Total Paid</p>
                    <p class="text-lg font-bold text-green-600">RM {{ number_format($clients->sum(fn($c) => $c['wills']->sum('total_paid')), 0) }}</p>
                </div>
                <div>
                    <p class="text-gray-600 font-medium">Pending</p>
                    <p class="text-lg font-bold text-red-600">RM {{ number_format($clients->sum(fn($c) => $c['wills']->sum('total_invoiced') - $c['wills']->sum('total_paid')), 0) }}</p>
                </div>
            </div>
        </div>

        <!-- Pagination -->
        <div class="bg-white border-t px-6 py-4">
            {{ $clients->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