Completed Kitchens

@if($from || $to)

Period: {{ $from ? \Carbon\Carbon::parse($from)->format('d M Y') : 'All' }} {{ ($from && $to) ? ' — ' : '' }} {{ $to ? \Carbon\Carbon::parse($to)->format('d M Y') : '' }}

@endif @php $grandValue = 0; $grandDays = []; @endphp @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 @endforeach

File/ Cont	Value	Brand	Customer	Suburb	Designer	Cabs	Delivered	Completed	Supervisor	Comp. Days
{{ $job?->job_number ?? '' }}	{{ number_format($job?->job_value ?? 0) }}	{{ $job?->contact?->leads->first()?->brand?->name ?? '—' }}	{{ $job?->contact ? strtoupper($job->contact->last_name ?? '') . (($job->contact->first_name ?? '') ? '/' . strtoupper($job->contact->first_name) : '') : '' }}	{{ strtoupper($job?->site_suburb ?? '') }}	{{ $job?->designer?->name ?? '' }}	{{ $c->snagging_items ?? 0 }}	{{ $delivDate ? \Carbon\Carbon::parse($delivDate)->format('d/m/Y') : '' }}	{{ $compDate?->format('d/m/Y') ?? '' }}	{{ $c->completedBy?->name ?? $job?->manager?->name ?? '' }}	{{ $compDays ?? '' }}

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

Sum

Average Days
to Complete Kitchen: {{ $avgDays }}

Summary for 'To Scheduling' = ({{ $completions->count() }} detail record{{ $completions->count() !== 1 ? 's' : '' }})

@if($avgDays !== null) @endif

Sum	{{ number_format($grandValue) }}	Average Days to Complete Kitchen: {{ $avgDays }}
Total	{{ number_format($grandValue) }}