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

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

<div class="flex items-center justify-between">
    <div>
        <h1 class="mb-1">Sales by Brand</h1>
        <p class="text-slate-400 text-sm">Jobs with a sale date, grouped by brand — with subtotals and grand total</p>
    </div>
    <a href="{{ route('reports.sales-by-brand.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.sales-by-brand') }}" class="card p-4">
    <div class="flex flex-wrap items-end gap-3">
        <div>
            <label class="block text-xs text-slate-500 mb-1">Sale 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">Sale 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.sales-by-brand') }}" class="btn btn-secondary">Reset</a>
        </div>
    </div>
</form>

@forelse($byBrand as $brandName => $jobs)
<div class="card overflow-hidden">
    <div class="px-5 py-3 border-b border-slate-700 flex items-center justify-between" style="background:#1a0a2e;">
        <div class="flex items-center gap-2">
            <i class="fas fa-tag text-purple-400"></i>
            <span class="font-semibold text-white">{{ $brandName ?: 'Unassigned' }}</span>
            <span class="text-slate-400 text-sm ml-2">({{ $jobs->count() }} sale{{ $jobs->count() !== 1 ? 's' : '' }})</span>
        </div>
        <span class="text-purple-300 font-semibold">${{ number_format($jobs->sum('job_value')) }}</span>
    </div>

    <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">
                    <th class="px-4 py-2 text-left">File #</th>
                    <th class="px-4 py-2 text-left">Sale Date</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">Consultant</th>
                    <th class="px-4 py-2 text-left">Designer</th>
                    <th class="px-4 py-2 text-left">Showroom</th>
                    <th class="px-4 py-2 text-right">Value</th>
                </tr>
            </thead>
            <tbody>
                @foreach($jobs as $job)
                <tr class="border-b border-slate-800 hover:bg-slate-800/30">
                    <td class="px-4 py-2 font-mono text-blue-300 text-xs">{{ $job->job_number }}</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-slate-200">{{ $job->contact?->full_name ?? '—' }}</td>
                    <td class="px-4 py-2 text-slate-400">{{ $job->site_suburb ?? $job->contact?->suburb ?? '—' }}</td>
                    <td class="px-4 py-2 text-slate-400">{{ $job->consultant?->name ?? '—' }}</td>
                    <td class="px-4 py-2 text-slate-400">{{ $job->designer?->name ?? '—' }}</td>
                    <td class="px-4 py-2 text-slate-400">{{$job->contact?->leads->first()?->showroom?->name ?? '—' }}</td>
                    <td class="px-4 py-2 text-right text-slate-200">${{ number_format($job->job_value ?? 0) }}</td>
                </tr>
                @endforeach
            </tbody>
        </table>
    </div>
</div>
@empty
<div class="card p-8 text-center text-slate-500">
    <i class="fas fa-tag text-3xl mb-3 block text-slate-600"></i>
    No sales found for the selected date range.
</div>
@endforelse

@if($byBrand->isNotEmpty())
<div class="card p-4 flex items-center justify-between" style="border:1px solid #7c3aed;">
    <span class="font-semibold text-white">Grand Total — {{ $byBrand->flatten()->count() }} record{{ $byBrand->flatten()->count() !== 1 ? 's' : '' }}</span>
    <span class="text-xl font-bold text-purple-300">${{ number_format($byBrand->flatten()->sum('job_value')) }}</span>
</div>
@endif

</div>
@endsection