@extends('layouts.portal')

@section('title', 'Will Creator Statistics')
@section('page_title', 'Will Creator Statistics')
@section('page_subtitle', 'Statistics on who created how many wills and performance metrics')

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

@section('content')
<div class="container-fluid">
    <div class="row">
        <div class="col-12">
            <h1>Will Creator Statistics</h1>
            <p class="text-muted">Statistics on who created how many wills and performance metrics</p>
        </div>
    </div>

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

    <!-- 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.will_creator_stats') }}">
                        <div class="row">
                            <div class="col-md-4">
                                <label for="start_date" class="form-label">Start Date</label>
                                <x-date-picker
                    name="start_date"
                    value="{{ $filters["
                    class="form-control"
                />
                            </div>
                            <div class="col-md-4">
                                <label for="end_date" class="form-label">End Date</label>
                                <x-date-picker
                    name="end_date"
                    value="{{ $filters["
                    class="form-control"
                />
                            </div>
                            <div class="col-md-4">
                                <label class="form-label">&nbsp;</label><br>
                                <button type="submit" class="btn btn-primary">Apply Filters</button>
                                <a href="{{ route('admin.reports.enhanced.will_creator_stats') }}" class="btn btn-secondary">Clear</a>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>

    <!-- Creator Statistics Table -->
    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-header">
                    <h5>Will Creator Performance</h5>
                </div>
                <div class="card-body">
                    <div class="table-responsive">
                        <table class="table table-striped">
                            <thead>
                                <tr>
                                    <th>Rank</th>
                                    <th>Creator Name</th>
                                    <th>Creator Type</th>
                                    <th>Role</th>
                                    <th>Email</th>
                                    <th>Wills Created</th>
                                    <th>Completed Wills</th>
                                    <th>Pending Wills</th>
                                    <th>Signed Wills</th>
                                    <th>Completion Rate</th>
                                    <th>First Will Date</th>
                                    <th>Last Will Date</th>
                                    <th>Actions</th>
                                </tr>
                            </thead>
                            <tbody>
                                @php
                                    $rank = 1;
                                @endphp
                                @foreach($creatorStats as $creator)
                                <tr>
                                    <td><strong>{{ $rank++ }}</strong></td>
                                    <td>
                                        @if($creator->creator)
                                            <strong>{{ $creator->creator->full_name ?? $creator->creator->name }}</strong>
                                        @else
                                            <strong>System/Unknown</strong>
                                        @endif
                                    </td>
                                    <td>
                                        <span class="badge bg-{{ 
                                            $creator->creator_type == 'client' ? 'primary' : 
                                            ($creator->creator_type == 'staff' ? 'success' : 'info') 
                                        }}">
                                            {{ ucfirst($creator->creator_type ?? 'N/A') }}
                                        </span>
                                    </td>
                                    <td>
                                        @if($creator->creator)
                                            <span class="badge bg-secondary">{{ ucfirst($creator->creator->role ?? 'N/A') }}</span>
                                        @else
                                            <span class="badge bg-secondary">System</span>
                                        @endif
                                    </td>
                                    <td>
                                        @if($creator->creator)
                                            {{ $creator->creator->email }}
                                        @else
                                            N/A
                                        @endif
                                    </td>
                                    <td>
                                        <span class="badge bg-primary">{{ $creator->will_count }}</span>
                                    </td>
                                    <td>
                                        @php
                                            $completedCount = \App\Models\Will::where('creator_type', $creator->creator_type)
                                                ->where('created_by', $creator->created_by)
                                                ->when(isset($filters['start_date']), function($query) use ($filters) {
                                                    $query->whereDate('created_at', '>=', $filters['start_date']);
                                                })
                                                ->when(isset($filters['end_date']), function($query) use ($filters) {
                                                    $query->whereDate('created_at', '<=', $filters['end_date']);
                                                })
                                                ->where('status', 'completed')
                                                ->count();
                                        @endphp
                                        <span class="badge bg-success">{{ $completedCount }}</span>
                                    </td>
                                    <td>
                                        @php
                                            $pendingCount = \App\Models\Will::where('creator_type', $creator->creator_type)
                                                ->where('created_by', $creator->created_by)
                                                ->when(isset($filters['start_date']), function($query) use ($filters) {
                                                    $query->whereDate('created_at', '>=', $filters['start_date']);
                                                })
                                                ->when(isset($filters['end_date']), function($query) use ($filters) {
                                                    $query->whereDate('created_at', '<=', $filters['end_date']);
                                                })
                                                ->where('status', 'pending')
                                                ->count();
                                        @endphp
                                        <span class="badge bg-warning">{{ $pendingCount }}</span>
                                    </td>
                                    <td>
                                        @php
                                            $signedCount = \App\Models\Will::where('creator_type', $creator->creator_type)
                                                ->where('created_by', $creator->created_by)
                                                ->when(isset($filters['start_date']), function($query) use ($filters) {
                                                    $query->whereDate('created_at', '>=', $filters['start_date']);
                                                })
                                                ->when(isset($filters['end_date']), function($query) use ($filters) {
                                                    $query->whereDate('created_at', '<=', $filters['end_date']);
                                                })
                                                ->whereNotNull('signed_at')
                                                ->count();
                                        @endphp
                                        <span class="badge bg-info">{{ $signedCount }}</span>
                                    </td>
                                    <td>
                                        @php
                                            $completionRate = $creator->will_count > 0 ? ($completedCount / $creator->will_count) * 100 : 0;
                                        @endphp
                                        <div class="progress" style="height: 20px;">
                                            <div class="progress-bar bg-success" role="progressbar" 
                                                 style="width: {{ $completionRate }}%">
                                                {{ number_format($completionRate, 1) }}%
                                            </div>
                                        </div>
                                    </td>
                                    <td>
                                        @php
                                            $firstWill = \App\Models\Will::where('creator_type', $creator->creator_type)
                                                ->where('created_by', $creator->created_by)
                                                ->when(isset($filters['start_date']), function($query) use ($filters) {
                                                    $query->whereDate('created_at', '>=', $filters['start_date']);
                                                })
                                                ->when(isset($filters['end_date']), function($query) use ($filters) {
                                                    $query->whereDate('created_at', '<=', $filters['end_date']);
                                                })
                                                ->orderBy('created_at', 'asc')
                                                ->first();
                                        @endphp
                                        {{ $firstWill?->created_at->format('M d, Y') ?? 'N/A' }}
                                    </td>
                                    <td>
                                        @php
                                            $lastWill = \App\Models\Will::where('creator_type', $creator->creator_type)
                                                ->where('created_by', $creator->created_by)
                                                ->when(isset($filters['start_date']), function($query) use ($filters) {
                                                    $query->whereDate('created_at', '>=', $filters['start_date']);
                                                })
                                                ->when(isset($filters['end_date']), function($query) use ($filters) {
                                                    $query->whereDate('created_at', '<=', $filters['end_date']);
                                                })
                                                ->orderBy('created_at', 'desc')
                                                ->first();
                                        @endphp
                                        {{ $lastWill?->created_at->format('M d, Y') ?? 'N/A' }}
                                    </td>
                                    <td>
                                        <div class="btn-group btn-group-sm">
                                            @if($creator->creator)
                                                <button type="button" class="btn btn-outline-primary" onclick="viewCreatorDetails('{{ $creator->creator_type }}', '{{ $creator->created_by }}')" title="View Details">
                                                    <i class="fas fa-eye"></i>
                                                </button>
                                                @if($creator->creator->role === 'staff')
                                                    <a href="{{ route('admin.staff.show', $creator->creator->id) }}" class="btn btn-outline-secondary" title="View Staff Profile">
                                                        <i class="fas fa-user"></i>
                                                    </a>
                                                @elseif($creator->creator->role === 'agent')
                                                    <a href="{{ route('admin.agents.show', $creator->creator->id) }}" class="btn btn-outline-secondary" title="View Agent Profile">
                                                        <i class="fas fa-user"></i>
                                                    </a>
                                                @elseif($creator->creator->role === 'lawyer')
                                                    <a href="{{ route('admin.lawyers.show', $creator->creator->id) }}" class="btn btn-outline-secondary" title="View Lawyer Profile">
                                                        <i class="fas fa-user"></i>
                                                    </a>
                                                @endif
                                            @endif
                                        </div>
                                    </td>
                                </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <!-- Summary Statistics -->
    <div class="row mt-4">
        <div class="col-md-3">
            <div class="card">
                <div class="card-header">
                    <h6>By Creator Type</h6>
                </div>
                <div class="card-body">
                    @php
                        $byType = $creatorStats->groupBy('creator_type');
                    @endphp
                    @foreach($byType as $type => $creators)
                    <div class="d-flex justify-content-between align-items-center mb-2">
                        <span>{{ ucfirst($type) }}</span>
                        <span class="badge bg-primary">{{ $creators->sum('will_count') }} wills</span>
                    </div>
                    @endforeach
                </div>
            </div>
        </div>

        <div class="col-md-3">
            <div class="card">
                <div class="card-header">
                    <h6>Top Performers</h6>
                </div>
                <div class="card-body">
                    @php
                        $topPerformers = $creatorStats->take(5);
                    @endphp
                    @foreach($topPerformers as $index => $creator)
                    <div class="d-flex justify-content-between align-items-center mb-2">
                        <small>{{ $creator->creator?->first_name ?? 'System' }}</small>
                        <span class="badge bg-success">{{ $creator->will_count }}</span>
                    </div>
                    @endforeach
                </div>
            </div>
        </div>

        <div class="col-md-3">
            <div class="card">
                <div class="card-header">
                    <h6>By Role</h6>
                </div>
                <div class="card-body">
                    @php
                        $byRole = $creatorStats->filter(function($creator) {
                            return $creator->creator && $creator->creator->role;
                        })->groupBy(function($creator) {
                            return $creator->creator->role;
                        });
                    @endphp
                    @foreach($byRole as $role => $creators)
                    <div class="d-flex justify-content-between align-items-center mb-2">
                        <span>{{ ucfirst($role) }}</span>
                        <span class="badge bg-info">{{ $creators->sum('will_count') }} wills</span>
                    </div>
                    @endforeach
                </div>
            </div>
        </div>

        <div class="col-md-3">
            <div class="card">
                <div class="card-header">
                    <h6>Statistics</h6>
                </div>
                <div class="card-body">
                    <div class="d-flex justify-content-between align-items-center mb-2">
                        <span>Total Creators</span>
                        <span class="badge bg-primary">{{ $creatorStats->count() }}</span>
                    </div>
                    <div class="d-flex justify-content-between align-items-center mb-2">
                        <span>Total Wills</span>
                        <span class="badge bg-success">{{ $creatorStats->sum('will_count') }}</span>
                    </div>
                    <div class="d-flex justify-content-between align-items-center mb-2">
                        <span>Avg Wills/Creator</span>
                        <span class="badge bg-info">{{ number_format($creatorStats->sum('will_count') / max($creatorStats->count(), 1), 1) }}</span>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection

@push('scripts')
<script>
    function viewCreatorDetails(creatorType, createdBy) {
        // Implement view creator details modal or redirect
        alert('View details for creator type: ' + creatorType + ', created by: ' + createdBy);
    }
</script>
@endpush

    </div>
</div>
@endsection