@extends('layouts.app')
@section('title', 'Leads to Sales by Designer')
@section('breadcrumb')<a href="{{ route('reports.index') }}" class="hover:text-white">Reports</a> <i class="fas fa-chevron-right text-xs mx-1 text-slate-600"></i><span class="text-white">Leads by Designer</span>@endsection

@section('content')
<div class="space-y-5">

<div class="flex items-center justify-between">
    <div>
        <h1 class="mb-1">Leads to Sales by Designer</h1>
        <p class="text-slate-400 text-sm">Lead and sales breakdown grouped by assigned designer</p>
    </div>
    <a href="{{ route('reports.leads-by-designer.pdf', request()->query()) }}"
       class="btn" style="background:#7c3aed;color:#ede9fe;">
        <i class="fas fa-file-pdf mr-2"></i>Export PDF
    </a>
</div>

<form method="GET" action="{{ route('reports.leads-by-designer') }}" class="card p-4">
    <div class="flex flex-wrap items-end gap-3">
        <div>
            <label class="block text-xs text-slate-500 mb-1">Date From</label>
            <input type="date" name="from" value="{{ $from }}" class="input" style="width:150px;">
        </div>
        <div>
            <label class="block text-xs text-slate-500 mb-1">Date To</label>
            <input type="date" name="to" value="{{ $to }}" class="input" style="width:150px;">
        </div>
        <div class="flex gap-2">
            <button type="submit" class="btn btn-primary"><i class="fas fa-filter mr-2"></i>Apply</button>
            <a href="{{ route('reports.leads-by-designer') }}" class="btn btn-secondary">Reset</a>
        </div>
    </div>
</form>

@forelse($grouped as $designerName => $jobs)
<div class="card overflow-hidden">
    <div class="px-5 py-3 border-b border-slate-700" style="background:#0f172a;">
        <h3 class="text-purple-300 flex items-center gap-2">
            <i class="fas fa-pencil-ruler"></i>
            Designer: <span class="ml-1">{{ $designerName ?: 'Unassigned' }}</span>
            <span class="text-xs text-slate-400 font-normal ml-1">({{ $jobs->count() }} record{{ $jobs->count() !== 1 ? 's' : '' }})</span>
        </h3>
    </div>
    <table class="w-full text-sm">
        <thead>
            <tr class="text-xs text-slate-400 uppercase border-b border-slate-700">
                <th class="px-4 py-2 text-left">ID</th>
                <th class="px-4 py-2 text-left">Brand</th>
                <th class="px-4 py-2 text-left">Customer</th>
                <th class="px-4 py-2 text-left">Suburb</th>
                <th class="px-4 py-2 text-left">Showroom</th>
                <th class="px-4 py-2 text-left">Consultant</th>
                <th class="px-4 py-2 text-left">Lead Date</th>
                <th class="px-4 py-2 text-left">Sale Date</th>
                <th class="px-4 py-2 text-right">Value</th>
            </tr>
        </thead>
        <tbody>
            @foreach($jobs as $job)
            <tr class="table-row border-b border-slate-800">
                <td class="px-4 py-2 text-slate-300">{{ $job->job_number }}</td>
                <td class="px-4 py-2 text-slate-300">{{ $job->lead?->brand?->name ?? '—' }}</td>
                <td class="px-4 py-2 text-white font-medium">{{ $job->contact?->full_name ?? '—' }}</td>
                <td class="px-4 py-2 text-slate-300">{{ $job->site_suburb ?? '—' }}</td>
                <td class="px-4 py-2 text-slate-300">{{ $job->lead?->showroom?->name ?? '—' }}</td>
                <td class="px-4 py-2 text-slate-300">{{ $job->consultant?->name ?? '—' }}</td>
                <td class="px-4 py-2 text-slate-300">{{ $job->lead?->enquiry_date?->format('d/m/Y') ?? '—' }}</td>
                <td class="px-4 py-2 text-slate-300">{{ $job->sale_date?->format('d/m/Y') ?? '—' }}</td>
                <td class="px-4 py-2 text-right text-green-400">${{ number_format($job->job_value ?? 0) }}</td>
            </tr>
            @endforeach
            <tr class="bg-slate-800/50">
                <td colspan="8" class="px-4 py-2 text-xs text-slate-400 font-medium">Sum ({{ $jobs->count() }} records)</td>
                <td class="px-4 py-2 text-right text-white font-semibold">${{ number_format($jobs->sum('job_value')) }}</td>
            </tr>
        </tbody>
    </table>
</div>
@empty
<div class="card p-8 text-center text-slate-500">
    <i class="fas fa-pencil-ruler text-3xl mb-3 block"></i>
    No records found for the selected period.
</div>
@endforelse

</div>
@endsection