@extends('layouts.app')
@section('title', 'Completed Kitchens')
@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">Completed Kitchens</span>@endsection

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

<div class="flex items-center justify-between">
    <div>
        <h1 class="mb-1">Completed Kitchens</h1>
        <p class="text-slate-400 text-sm">All jobs in the Completion panel with delivery and completion dates</p>
    </div>
    <a href="{{ route('reports.completed-kitchens.pdf', request()->query()) }}"
       class="btn" style="background:#7c3aed;color:#ede9fe;">
        <i class="fas fa-file-pdf mr-2"></i>Download PDF
    </a>
</div>

<form method="GET" action="{{ route('reports.completed-kitchens') }}" class="card p-4">
    <div class="flex flex-wrap items-end gap-3">
        <div>
            <label class="block text-xs text-slate-500 mb-1">Completion 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">Completion 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.completed-kitchens') }}" class="btn btn-secondary">Reset</a>
        </div>
    </div>
</form>

@php
  $grandValue = 0;
  $grandDays  = [];
@endphp

@if($completions->count())
<div class="card overflow-hidden">
    <div class="overflow-x-auto">
        <table class="w-full text-sm">
            <thead>
                <tr class="text-xs text-slate-400 uppercase border-b border-slate-700" style="background:#0f172a;">
                    <th class="px-3 py-2 text-left">File/Cont</th>
                    <th class="px-3 py-2 text-right">Value</th>
                    <th class="px-3 py-2 text-left">Brand</th>
                    <th class="px-3 py-2 text-left">Customer</th>
                    <th class="px-3 py-2 text-left">Suburb</th>
                    <th class="px-3 py-2 text-left">Designer</th>
                    <th class="px-3 py-2 text-right">Cabs</th>
                    <th class="px-3 py-2 text-left">Delivered</th>
                    <th class="px-3 py-2 text-left">Completed</th>
                    <th class="px-3 py-2 text-left">Supervisor</th>
                    <th class="px-3 py-2 text-right">Comp. Days</th>
                </tr>
            </thead>
            <tbody>
                @foreach($completions as $c)
                @php
                    $job       = $c->job;
                    $delivery  = $job?->deliveries->sortByDesc('scheduled_date')->first();
                    $delivDate = $delivery?->scheduled_date ?? $delivery?->delivered_at;
                    $compDate  = $c->completion_date;
                    $compDays  = ($delivDate && $compDate)
                                 ? (int) \Carbon\Carbon::parse($delivDate)->diffInDays($compDate)
                                 : null;
                    $grandValue += $job?->job_value ?? 0;
                    if ($compDays !== null) $grandDays[] = $compDays;
                @endphp
                <tr class="border-b border-slate-800 hover:bg-slate-800/30">
                    <td class="px-3 py-2 font-mono text-blue-300 text-xs">{{ $job?->job_number ?? '—' }}</td>
                    <td class="px-3 py-2 text-right text-slate-200">${{ number_format($job?->job_value ?? 0) }}</td>
                    <td class="px-3 py-2 text-slate-300">{{ $job?->contact?->leads->first()?->brand?->name ?? '—' }}</td>
                    <td class="px-3 py-2 text-slate-200">{{ $job?->contact?->full_name ?? '—' }}</td>
                    <td class="px-3 py-2 text-slate-400">{{ $job?->site_suburb ?? '—' }}</td>
                    <td class="px-3 py-2 text-slate-400">{{ $job?->designer?->name ?? '—' }}</td>
                    <td class="px-3 py-2 text-right text-slate-400">{{ $c->snagging_items ?? 0 }}</td>
                    <td class="px-3 py-2 text-slate-300">{{ $delivDate ? \Carbon\Carbon::parse($delivDate)->format('d/m/Y') : '—' }}</td>
                    <td class="px-3 py-2 text-slate-300">{{ $compDate?->format('d/m/Y') ?? '—' }}</td>
                    <td class="px-3 py-2 text-slate-400">{{ $c->completedBy?->name ?? $job?->manager?->name ?? '—' }}</td>
                    <td class="px-3 py-2 text-right text-slate-400">{{ $compDays ?? '—' }}</td>
                </tr>
                @endforeach
            </tbody>
        </table>
    </div>
</div>

@php $avgDays = count($grandDays) > 0 ? round(array_sum($grandDays) / count($grandDays), 2) : null; @endphp

<div class="card p-4 flex flex-wrap items-center justify-between gap-4" style="border:1px solid #7c3aed;">
    <div>
        <span class="text-slate-400 text-sm">Total — {{ $completions->count() }} record{{ $completions->count() !== 1 ? 's' : '' }}</span>
        <span class="ml-4 text-xl font-bold text-purple-300">${{ number_format($grandValue) }}</span>
    </div>
    @if($avgDays !== null)
    <div class="text-sm text-slate-400">
        Avg. Days to Complete Kitchen: <span class="text-white font-semibold">{{ $avgDays }}</span>
    </div>
    @endif
</div>

@else
<div class="card p-8 text-center text-slate-500">
    <i class="fas fa-check-double text-3xl mb-3 block text-slate-600"></i>
    No completion records found for the selected date range.
</div>
@endif

</div>
@endsection