@extends('layouts.portal')

@section('title', 'Commission Reports')
@section('page_title', 'Commission Reports')
@section('page_subtitle', 'Detailed commission tracking for agents and lawyers')

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

@section('content')
<div class="container-fluid">
    <div class="row">
        <div class="col-12">
            <h1>Commission Reports</h1>
            <p class="text-muted">Detailed commission tracking for agents and lawyers</p>
        </div>
    </div>

    <div class="row">
        <!-- Main Content -->
        <div class="col-12">

    <!-- Stats Cards -->
    <div class="row mb-4">
        <div class="col-md-2">
            <div class="card bg-primary text-white">
                <div class="card-body text-center">
                    <h5>{{ $stats['total_commissions'] }}</h5>
                    <small>Total Commissions</small>
                </div>
            </div>
        </div>
        <div class="col-md-2">
            <div class="card bg-success text-white">
                <div class="card-body text-center">
                    <h5>{{ $stats['paid_commissions'] }}</h5>
                    <small>Paid</small>
                </div>
            </div>
        </div>
        <div class="col-md-2">
            <div class="card bg-warning text-white">
                <div class="card-body text-center">
                    <h5>{{ $stats['pending_commissions'] }}</h5>
                    <small>Pending</small>
                </div>
            </div>
        </div>
        <div class="col-md-2">
            <div class="card bg-danger text-white">
                <div class="card-body text-center">
                    <h5>{{ $stats['cancelled_commissions'] }}</h5>
                    <small>Cancelled</small>
                </div>
            </div>
        </div>
        <div class="col-md-2">
            <div class="card bg-info text-white">
                <div class="card-body text-center">
                    <h5>${{ number_format($stats['total_amount'], 0) }}</h5>
                    <small>Total Amount</small>
                </div>
            </div>
        </div>
        <div class="col-md-2">
            <div class="card bg-secondary text-white">
                <div class="card-body text-center">
                    <h5>${{ number_format($stats['paid_amount'], 0) }}</h5>
                    <small>Paid Amount</small>
                </div>
            </div>
        </div>
    </div>

    <!-- Filters -->
    <div class="row mb-4">
        <div class="col-12">
            <div class="card">
                <div class="card-header">
                    <h5>Filters</h5>
                </div>
                <div class="card-body">
                    <form method="GET" action="{{ route('admin.reports.enhanced.commissions') }}">
                        <div class="row">
                            <div class="col-md-2">
                                <label for="user_id" class="form-label">User</label>
                                <select class="form-select form-select-sm" id="user_id" name="user_id">
                                    <option value="">All Users</option>
                                    @foreach($users as $user)
                                    <option value="{{ $user->id }}" {{ $filters['user_id'] == $user->id ? 'selected' : '' }}>
                                        {{ $user->first_name }} {{ $user->last_name }} ({{ ucfirst($user->role) }})
                                    </option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="col-md-2">
                                <label for="user_role" class="form-label">User Role</label>
                                <select class="form-select form-select-sm" id="user_role" name="user_role">
                                    <option value="">All Roles</option>
                                    <option value="agent" {{ $filters['user_role'] == 'agent' ? 'selected' : '' }}>Agent</option>
                                    <option value="lawyer" {{ $filters['user_role'] == 'lawyer' ? 'selected' : '' }}>Lawyer</option>
                                </select>
                            </div>
                            <div class="col-md-2">
                                <label for="status" class="form-label">Status</label>
                                <select class="form-select form-select-sm" id="status" name="status">
                                    <option value="">All Status</option>
                                    <option value="paid" {{ $filters['status'] == 'paid' ? 'selected' : '' }}>Paid</option>
                                    <option value="pending" {{ $filters['status'] == 'pending' ? 'selected' : '' }}>Pending</option>
                                    <option value="cancelled" {{ $filters['status'] == 'cancelled' ? 'selected' : '' }}>Cancelled</option>
                                </select>
                            </div>
                            <div class="col-md-2">
                                <label for="start_date" class="form-label">Start Date</label>
                                <x-date-picker
                    name="start_date"
                    value="{{ $filters["
                    class="form-control form-control-sm"
                />
                            </div>
                            <div class="col-md-2">
                                <label for="end_date" class="form-label">End Date</label>
                                <x-date-picker
                    name="end_date"
                    value="{{ $filters["
                    class="form-control form-control-sm"
                />
                            </div>
                            <div class="col-md-2">
                                <label class="form-label">&nbsp;</label><br>
                                <button type="submit" class="btn btn-primary btn-sm">Apply Filters</button>
                                <a href="{{ route('admin.reports.enhanced.commissions') }}" class="btn btn-secondary btn-sm">Clear</a>
                                <button type="button" class="btn btn-success btn-sm" onclick="exportCommissions()">
                                    <i class="fas fa-download"></i> Export Excel
                                </button>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>

    <!-- Commissions Table -->
    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-header">
                    <h5>Commission Details</h5>
                </div>
                <div class="card-body">
                    <div class="table-responsive">
                        <table class="table table-striped table-sm">
                            <thead>
                                <tr>
                                    <th>ID</th>
                                    <th>Date</th>
                                    <th>User</th>
                                    <th>Role</th>
                                    <th>Client</th>
                                    <th>Will ID</th>
                                    <th>Amount</th>
                                    <th>Status</th>
                                    <th>Commission Type</th>
                                    <th>Paid Date</th>
                                    <th>Created By</th>
                                    <th>Actions</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach($commissions as $commission)
                                <tr>
                                    <td>{{ $commission->id }}</td>
                                    <td>{{ $commission->created_at->format('M d, Y') }}</td>
                                    <td>
                                        @if($commission->user)
                                            <strong>{{ $commission->user->first_name }} {{ $commission->user->last_name }}</strong><br>
                                            <small class="text-muted">{{ $commission->user->email }}</small>
                                        @else
                                            N/A
                                        @endif
                                    </td>
                                    <td>
                                        @if($commission->user)
                                            <span class="badge bg-{{ $commission->user->role == 'agent' ? 'primary' : 'success' }}">
                                                {{ ucfirst($commission->user->role) }}
                                            </span>
                                        @else
                                            N/A
                                        @endif
                                    </td>
                                    <td>
                                        @if($commission->client)
                                            {{ $commission->client->first_name }} {{ $commission->client->last_name }}
                                        @else
                                            N/A
                                        @endif
                                    </td>
                                    <td>
                                        @if($commission->will)
                                            <a href="{{ route('admin.wills.show', $commission->will->id) }}">#{{ $commission->will->id }}</a>
                                        @else
                                            N/A
                                        @endif
                                    </td>
                                    <td>
                                        <strong>${{ number_format($commission->amount, 2) }}</strong>
                                    </td>
                                    <td>
                                        <span class="badge bg-{{ 
                                            $commission->status == 'paid' ? 'success' : 
                                            ($commission->status == 'pending' ? 'warning' : 'danger') 
                                        }}">
                                            {{ ucfirst($commission->status) }}
                                        </span>
                                    </td>
                                    <td>{{ ucfirst($commission->commission_type ?? 'Standard') }}</td>
                                    <td>{{ $commission->paid_at?->format('M d, Y') ?? 'N/A' }}</td>
                                    <td>
                                        @if($commission->creator)
                                            {{ $commission->creator->first_name }} {{ $commission->creator->last_name }}
                                        @else
                                            System
                                        @endif
                                    </td>
                                    <td>
                                        <div class="btn-group btn-group-sm">
                                            <button type="button" class="btn btn-outline-primary" onclick="viewCommission({{ $commission->id }})" title="View Details">
                                                <i class="fas fa-eye"></i>
                                            </button>
                                            @if($commission->status == 'pending')
                                            <a href="{{ route('admin.finance.commission.paid', $commission->id) }}" class="btn btn-outline-success" title="Mark Paid">
                                                <i class="fas fa-check"></i>
                                            </a>
                                            <a href="{{ route('admin.finance.commission.cancelled', $commission->id) }}" class="btn btn-outline-danger" title="Cancel">
                                                <i class="fas fa-times"></i>
                                            </a>
                                            @endif
                                        </div>
                                    </td>
                                </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                    
                    <!-- Pagination -->
                    <div class="d-flex justify-content-between align-items-center mt-3">
                        <div>
                            Showing {{ $commissions->firstItem() }} to {{ $commissions->lastItem() }} of {{ $commissions->total() }} entries
                        </div>
                        {{ $commissions->links() }}
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Commission Summary by Role -->
    <div class="row mt-4">
        <div class="col-md-6">
            <div class="card">
                <div class="card-header">
                    <h6>Agent Commission Summary</h6>
                </div>
                <div class="card-body">
                    @php
                        $agentStats = $commissions->filter(function($commission) {
                            return $commission->user && $commission->user->role === 'agent';
                        });
                    @endphp
                    <div class="row text-center">
                        <div class="col-md-4">
                            <h4 class="text-primary">{{ $agentStats->count() }}</h4>
                            <small>Total Commissions</small>
                        </div>
                        <div class="col-md-4">
                            <h4 class="text-success">${{ number_format($agentStats->where('status', 'paid')->sum('amount'), 0) }}</h4>
                            <small>Paid Amount</small>
                        </div>
                        <div class="col-md-4">
                            <h4 class="text-warning">${{ number_format($agentStats->where('status', 'pending')->sum('amount'), 0) }}</h4>
                            <small>Pending Amount</small>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        
        <div class="col-md-6">
            <div class="card">
                <div class="card-header">
                    <h6>Lawyer Commission Summary</h6>
                </div>
                <div class="card-body">
                    @php
                        $lawyerStats = $commissions->filter(function($commission) {
                            return $commission->user && $commission->user->role === 'lawyer';
                        });
                    @endphp
                    <div class="row text-center">
                        <div class="col-md-4">
                            <h4 class="text-info">{{ $lawyerStats->count() }}</h4>
                            <small>Total Commissions</small>
                        </div>
                        <div class="col-md-4">
                            <h4 class="text-success">${{ number_format($lawyerStats->where('status', 'paid')->sum('amount'), 0) }}</h4>
                            <small>Paid Amount</small>
                        </div>
                        <div class="col-md-4">
                            <h4 class="text-warning">${{ number_format($lawyerStats->where('status', 'pending')->sum('amount'), 0) }}</h4>
                            <small>Pending Amount</small>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection

@push('scripts')
<script>
    function exportCommissions() {
        const form = document.createElement('form');
        form.method = 'POST';
        form.action = '{{ route('admin.reports.enhanced.export.commissions') }}';
        
        // Add CSRF token
        const csrf = document.createElement('input');
        csrf.type = 'hidden';
        csrf.name = '_token';
        csrf.value = '{{ csrf_token() }}';
        form.appendChild(csrf);
        
        // Add filters
        const filters = ['user_id', 'user_role', 'status', 'start_date', 'end_date'];
        filters.forEach(filter => {
            const element = document.getElementById(filter);
            if (element && element.value) {
                const input = document.createElement('input');
                input.type = 'hidden';
                input.name = filter;
                input.value = element.value;
                form.appendChild(input);
            }
        });
        
        document.body.appendChild(form);
        form.submit();
        document.body.removeChild(form);
    }
    
    function viewCommission(id) {
        // Implement view commission modal
        alert('View commission details for ID: ' + id);
    }
</script>
@endpush

    </div>
</div>
@endsection