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

@section('content')
@php
    $logoPath    = \App\Models\AppSetting::get('company_logo');
    $companyName = \App\Models\AppSetting::get('company_name','Degabriele Kitchens');
@endphp

<div class="space-y-5">
    {{-- Filter --}}
    <div class="card p-5">
        <form method="GET" class="flex items-end gap-4 flex-wrap">
            <div class="flex-1 min-w-48">
                <label class="text-sm text-slate-400 mb-1 block">Select Quote</label>
                <select name="quote_id" class="input" onchange="this.form.submit()">
                    <option value="">-- Select a Quote --</option>
                    @foreach($quotes as $q)
                    <option value="{{ $q->id }}" {{ (isset($quote) && $quote->id==$q->id) ? 'selected' : '' }}>
                        {{ $q->quote_number }} — {{ $q->contact?->full_name ?? 'No client' }} {{ $q->job?->job_number ? '('.$q->job->job_number.')' : '' }}
                    </option>
                    @endforeach
                </select>
            </div>
            @if(isset($quote))
            <div class="flex gap-2">
                <button type="button" onclick="window.print()" class="btn btn-secondary"><i class="fas fa-print mr-2"></i>Print</button>
                <a href="{{ route('quotes.show', $quote) }}" class="btn btn-secondary"><i class="fas fa-arrow-left mr-2"></i>Back to Quote</a>
            </div>
            @endif
        </form>
    </div>

    @if(isset($quote))
    {{-- Report Content (printable) --}}
    <div class="card p-8 print-area" id="printArea">
        {{-- Header --}}
        <div class="flex items-start justify-between mb-6">
            <div>
                @if($logoPath && \Illuminate\Support\Facades\Storage::disk('public')->exists($logoPath))
                <img src="{{ asset('storage/'.$logoPath) }}" alt="Logo" style="max-height:60px;max-width:180px;" class="mb-3">
                @endif
                <h1 class="text-2xl font-bold text-white">Gross Profit Report</h1>
            </div>
            <div class="text-right text-sm text-slate-400 space-y-1">
                <div><span class="text-slate-500">Client:</span> <span class="text-white font-medium">{{ $quote->contact?->full_name ?? '—' }}</span></div>
                <div><span class="text-slate-500">Job No:</span> <span class="text-white">{{ $quote->job?->job_number ?? '—' }}</span></div>
                <div><span class="text-slate-500">Quote:</span> <span class="text-white">{{ $quote->quote_number }}</span></div>
                <div><span class="text-slate-500">Date:</span> <span class="text-white">{{ now()->format('d/m/Y') }}</span></div>
            </div>
        </div>

        {{-- KPI Summary Row --}}
        <div class="grid grid-cols-4 gap-4 mb-8">
            <div class="stat-card text-center">
                <div class="text-xs text-slate-500 mb-1">Total W/Sale (Cost)</div>
                <div class="text-xl font-bold text-slate-300">${{ number_format($totalWsale,2) }}</div>
            </div>
            <div class="stat-card text-center">
                <div class="text-xs text-slate-500 mb-1">Total Retail (Revenue)</div>
                <div class="text-xl font-bold text-white">${{ number_format($totalRetail,2) }}</div>
            </div>
            <div class="stat-card text-center">
                <div class="text-xs text-slate-500 mb-1">Gross Profit</div>
                <div class="text-xl font-bold {{ $grossProfit>=0?'text-green-400':'text-red-400' }}">${{ number_format($grossProfit,2) }}</div>
            </div>
            <div class="stat-card text-center">
                <div class="text-xs text-slate-500 mb-1">Gross Margin</div>
                <div class="text-xl font-bold {{ $marginPct>=0?'text-blue-400':'text-red-400' }}">{{ $marginPct }}%</div>
            </div>
        </div>

        {{-- Material type sections --}}
        @foreach($typeRows as $row)
        <div class="mb-8">
            <h2 class="text-lg font-bold text-white border-b-2 border-slate-600 pb-2 mb-3">{{ $row['type_name'] }}</h2>
            <div class="overflow-x-auto">
            <table class="w-full text-sm">
                <thead>
                    <tr class="text-xs text-slate-500 border-b border-slate-700">
                        <th class="text-left py-2 pr-3">Description</th>
                        <th class="text-left py-2 pr-3">Item Code</th>
                        <th class="text-left py-2 pr-3">Units</th>
                        <th class="text-right py-2 pr-3">Qty</th>
                        <th class="text-right py-2 pr-3">W/Sale</th>
                        <th class="text-right py-2 pr-3">Retail</th>
                        <th class="text-right py-2 pr-3">Total W/Sale</th>
                        <th class="text-right py-2">Total Retail</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($row['items'] as $item)
                    <tr class="border-b border-slate-800">
                        <td class="py-2 pr-3 text-white">{{ $item->description }}</td>
                        <td class="py-2 pr-3 text-slate-400 font-mono text-xs">{{ $item->item_code }}</td>
                        <td class="py-2 pr-3 text-slate-400">{{ $item->unit }}</td>
                        <td class="py-2 pr-3 text-right text-slate-300">{{ number_format($item->qty,2) }}</td>
                        <td class="py-2 pr-3 text-right text-slate-400">${{ number_format($item->wsale_price??0,2) }}</td>
                        <td class="py-2 pr-3 text-right text-slate-300">${{ number_format($item->retail_price??$item->unit_price??0,2) }}</td>
                        <td class="py-2 pr-3 text-right text-slate-400">${{ number_format($item->total_wsale??0,2) }}</td>
                        <td class="py-2 text-right text-green-400">${{ number_format($item->total_retail??$item->total??0,2) }}</td>
                    </tr>
                    @endforeach
                    <tr class="border-t border-slate-600 font-bold">
                        <td colspan="6" class="py-2 text-right text-slate-400 text-xs uppercase">{{ $row['type_name'] }} Totals</td>
                        <td class="py-2 text-right text-slate-300">${{ number_format($row['total_wsale'],2) }}</td>
                        <td class="py-2 text-right text-green-400">${{ number_format($row['total_retail'],2) }}</td>
                    </tr>
                    <tr class="font-bold">
                        <td colspan="7" class="py-1 text-right text-xs text-slate-500">Gross Profit ({{ $row['type_name'] }})</td>
                        <td class="py-1 text-right text-sm {{ $row['gross_profit']>=0?'text-blue-400':'text-red-400' }}">${{ number_format($row['gross_profit'],2) }} ({{ $row['margin_pct'] }}%)</td>
                    </tr>
                </tbody>
            </table>
            </div>
        </div>
        @endforeach

        {{-- Grand Total Summary --}}
        <div class="border-t-2 border-slate-600 pt-6 mt-4">
            <h2 class="text-lg font-bold text-white mb-4">Grand Totals</h2>
            <div class="max-w-sm ml-auto space-y-2">
                <div class="flex justify-between text-sm"><span class="text-slate-400">Total W/Sale (Cost)</span><span class="text-slate-300 font-medium">${{ number_format($totalWsale,2) }}</span></div>
                <div class="flex justify-between text-sm"><span class="text-slate-400">Total Retail</span><span class="text-white font-medium">${{ number_format($totalRetail,2) }}</span></div>
                <div class="flex justify-between text-sm border-t border-slate-700 pt-2">
                    <span class="text-blue-400 font-bold">Gross Profit</span>
                    <span class="font-bold {{ $grossProfit>=0?'text-blue-400':'text-red-400' }}">${{ number_format($grossProfit,2) }}</span>
                </div>
                <div class="flex justify-between text-sm"><span class="text-slate-400">Gross Margin</span><span class="{{ $marginPct>=0?'text-green-400':'text-red-400' }} font-bold">{{ $marginPct }}%</span></div>
                <div class="flex justify-between text-sm border-t border-slate-700 pt-2">
                    <span class="text-slate-400">GST (10%)</span><span class="text-white">${{ number_format($totalRetail*0.10,2) }}</span>
                </div>
                <div class="flex justify-between text-base font-bold border-t border-slate-700 pt-2">
                    <span class="text-white">Total incl. GST</span>
                    <span class="text-green-400">${{ number_format($totalRetail*1.10,2) }}</span>
                </div>
            </div>
        </div>
    </div>
    @else
    <div class="card p-10 text-center text-slate-500">
        <i class="fas fa-chart-bar text-4xl mb-3 block"></i>
        <p>Select a quote above to generate the gross profit report.</p>
    </div>
    @endif
</div>

<style>
@media print {
    .sidebar, header, .breadcrumb, form, button, .btn, .space-y-5 > .card:first-child { display: none !important; }
    body { background: white !important; color: black !important; }
    .print-area { box-shadow: none !important; border: none !important; background: white !important; color: black !important; }
    .text-white, .text-slate-300, .text-slate-400, .text-slate-500 { color: #333 !important; }
    .text-green-400 { color: #166534 !important; }
    .text-blue-400 { color: #1d4ed8 !important; }
}
</style>
@endsection