@extends('layouts.portal')

@section('title', 'Commission Hierarchy Report')
@section('page_title', 'Commission Hierarchy Report')
@section('page_subtitle', 'L1, L2, L3 Agent Structure with Earnings')

@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">Commission Hierarchy Report</h1>
            <p class="text-gray-600 mt-1">Agent Network Structure (L1, L2, L3) with Commission Tracking</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">
                <i class="fas fa-arrow-left mr-2"></i>Back
            </a>
            <a href="{{ route('admin.reports.master.commission-hierarchy.export.excel', array_merge(request()->query(), [])) }}" class="px-4 py-2 bg-green-600 text-white rounded-lg hover:bg-green-700">
                <i class="fas fa-file-excel mr-2"></i>Export Excel
            </a>
            <a href="{{ route('admin.reports.master.commission-hierarchy.export.pdf', array_merge(request()->query(), [])) }}" class="px-4 py-2 bg-red-600 text-white rounded-lg hover:bg-red-700">
                <i class="fas fa-file-pdf mr-2"></i>Export PDF
            </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.commission-hierarchy') }}" 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/Agent Name/Email)</label>
                <input type="text" name="search" value="{{ $search }}" placeholder="Enter name or email..." 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">Agent Level</label>
                <select name="level" 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 Levels</option>
                    <option value="L1" {{ $level == 'L1' ? 'selected' : '' }}>L1 - Top Level</option>
                    <option value="L2" {{ $level == 'L2' ? 'selected' : '' }}>L2 - Second Level</option>
                    <option value="L3" {{ $level == 'L3' ? 'selected' : '' }}>L3 - Third Level</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.commission-hierarchy') }}" 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>

    <!-- Summary Cards -->
    <div class="grid grid-cols-1 md:grid-cols-4 gap-6 mb-8">
        <div class="bg-gradient-to-br from-blue-50 to-blue-100 rounded-lg shadow-md p-6 border-l-4 border-blue-600">
            <p class="text-gray-600 font-medium text-sm">Total Agents</p>
            <p class="text-3xl font-bold text-blue-600 mt-2">{{ collect($hierarchyDataPaginated)->count() + (($hierarchyDataPaginated->currentPage() - 1) * 15) }}</p>
        </div>
        <div class="bg-gradient-to-br from-green-50 to-green-100 rounded-lg shadow-md p-6 border-l-4 border-green-600">
            <p class="text-gray-600 font-medium text-sm">L1 Agents</p>
            <p class="text-3xl font-bold text-green-600 mt-2">{{ $hierarchyData->where('agent_level', 'L1')->count() }}</p>
        </div>
        <div class="bg-gradient-to-br from-purple-50 to-purple-100 rounded-lg shadow-md p-6 border-l-4 border-purple-600">
            <p class="text-gray-600 font-medium text-sm">L2 Agents</p>
            <p class="text-3xl font-bold text-purple-600 mt-2">{{ $hierarchyData->where('agent_level', 'L2')->count() }}</p>
        </div>
        <div class="bg-gradient-to-br from-orange-50 to-orange-100 rounded-lg shadow-md p-6 border-l-4 border-orange-600">
            <p class="text-gray-600 font-medium text-sm">L3 Agents</p>
            <p class="text-3xl font-bold text-orange-600 mt-2">{{ $hierarchyData->where('agent_level', 'L3')->count() }}</p>
        </div>
    </div>

    <!-- Hierarchy 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-900 text-white">
                        <th class="px-6 py-4 text-left font-semibold">Will ID</th>
                        <th class="px-6 py-4 text-left font-semibold">Client Name</th>
                        <th class="px-6 py-4 text-left font-semibold bg-blue-800">Direct Agent (Level)</th>
                        <th class="px-6 py-4 text-left font-semibold">Agent Email</th>
                        <th class="px-6 py-4 text-left font-semibold">Agent Phone</th>
                        <th class="px-6 py-4 text-left font-semibold bg-green-900">L1 Parent Agent</th>
                        <th class="px-6 py-4 text-left font-semibold bg-green-900">L2 Parent Agent</th>
                        <th class="px-6 py-4 text-right font-semibold bg-purple-900">L1 Comm (RM)</th>
                        <th class="px-6 py-4 text-right font-semibold bg-purple-900">L2 Comm (RM)</th>
                        <th class="px-6 py-4 text-right font-semibold bg-purple-900">L3 Comm (RM)</th>
                        <th class="px-6 py-4 text-right font-semibold bg-orange-900">Total Comm</th>
                        <th class="px-6 py-4 text-center font-semibold bg-teal-900">Status</th>
                        <th class="px-6 py-4 text-left font-semibold bg-teal-900">Will Date</th>
                    </tr>
                </thead>
                <tbody class="divide-y">
                    @forelse($hierarchyDataPaginated as $item)
                    <tr class="hover:bg-gray-50 transition-colors">
                        <td class="px-6 py-4 font-mono text-xs text-gray-600">{{ $item['will_id'] }}</td>
                        <td class="px-6 py-4 font-medium text-gray-900">{{ $item['client_name'] }}</td>
                        <td class="px-6 py-4 font-medium bg-blue-100 text-gray-900"><strong>{{ $item['direct_agent'] }}</strong></td>
                        <td class="px-6 py-4 text-gray-600 text-sm">{{ $item['agent_email'] }}</td>
                        <td class="px-6 py-4 text-gray-600">{{ $item['agent_phone'] }}</td>
                        <td class="px-6 py-4 bg-green-50 text-green-900 font-semibold">{{ $item['l1_parent_name'] }}</td>
                        <td class="px-6 py-4 bg-green-50 text-green-900 font-semibold">{{ $item['l2_parent_name'] }}</td>
                        <td class="px-6 py-4 text-right bg-purple-50 font-semibold {{ $item['l1_commission'] > 0 ? 'text-purple-900' : 'text-gray-600' }}">
                            <div>RM {{ number_format($item['l1_commission'], 2) }}</div>
                            <div class="text-xs text-gray-600">{{ $item['l1_receives_by'] }}</div>
                        </td>
                        <td class="px-6 py-4 text-right bg-purple-50 font-semibold {{ $item['l2_commission'] > 0 ? 'text-purple-900' : 'text-gray-600' }}">
                            <div>RM {{ number_format($item['l2_commission'], 2) }}</div>
                            <div class="text-xs text-gray-600">{{ $item['l2_receives_by'] }}</div>
                        </td>
                        <td class="px-6 py-4 text-right bg-purple-50 font-semibold {{ $item['l3_commission'] > 0 ? 'text-purple-900' : 'text-gray-600' }}">
                            <div>RM {{ number_format($item['l3_commission'], 2) }}</div>
                            <div class="text-xs text-gray-600">{{ $item['l3_receives_by'] }}</div>
                        </td>
                        <td class="px-6 py-4 text-right bg-orange-50 font-bold text-orange-900">
                            {{ $item['total_commission'] }}
                        </td>
                        <td class="px-6 py-4 text-center bg-teal-50">
                            <span class="inline-block px-3 py-1 bg-green-200 text-green-900 rounded-full text-xs font-semibold">
                                {{ $item['status'] }}
                            </span>
                        </td>
                        <td class="px-6 py-4 text-teal-900 font-semibold bg-teal-50 text-sm">{{ $item['created_date'] }}</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 commissions found
                        </td>
                    </tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>

    <!-- Pagination -->
    <div class="mt-6">
        {{ $hierarchyDataPaginated->links() }}
    </div>

    <!-- Hierarchy Breakdown -->
   
</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: 1400px;
        }
    }
</style>
@endsection