@extends('layouts.admin')
@section('title', 'Cost & Profit — ' . $sale->invoice_no)

@section('content')
@php
  $rows = $sale->items->map(function ($i) use ($alloc) {
      $parts = $alloc[$i->id] ?? collect();
      $cost  = $parts->isEmpty()
          ? round((float) $i->quantity * (float) $i->unit_cost, 2)
          : round($parts->sum(fn ($a) => (float) $a->quantity * (float) $a->unit_cost), 2);
      $rev = round((float) $i->line_total, 2);          // before VAT
      return ['item' => $i, 'parts' => $parts, 'rev' => $rev, 'cost' => $cost, 'profit' => round($rev - $cost, 2)];
  });
  $totRev    = $rows->sum('rev');
  $totCost   = $rows->sum('cost');
  $totProfit = round($totRev - $totCost, 2);
  $margin    = $totRev > 0 ? round($totProfit / $totRev * 100, 1) : 0;
@endphp

<div class="flex items-center gap-2 text-sm text-slate-500">
  <a href="{{ route('admin.sales.index') }}" class="hover:text-brand-500">Sales</a><span>/</span>
  <a href="{{ route('admin.sales.show', $sale) }}" class="hover:text-brand-500">{{ $sale->invoice_no }}</a><span>/</span>
  <span class="text-slate-800 dark:text-slate-200 font-medium">Cost &amp; profit</span>
</div>

<div class="grid sm:grid-cols-2 xl:grid-cols-4 gap-5">
  @foreach ([
    ['Sales (before VAT)', 'AED ' . number_format($totRev, 2),    'text-sky-500'],
    ['Cost (FIFO)',        'AED ' . number_format($totCost, 2),   'text-amber-500'],
    ['Profit',             'AED ' . number_format($totProfit, 2), $totProfit >= 0 ? 'text-emerald-500' : 'text-red-500'],
    ['Margin',             $margin . '%',                         $totProfit >= 0 ? 'text-emerald-500' : 'text-red-500'],
  ] as [$l, $v, $c])
    <div class="p-6 rounded-2xl bg-white dark:bg-slate-900 border border-slate-200 dark:border-slate-800">
      <div class="text-sm text-slate-500">{{ $l }}</div>
      <div class="mt-2 text-2xl font-extrabold {{ $c }}">{{ $v }}</div>
    </div>
  @endforeach
</div>

@foreach ($rows as $r)
  @php $i = $r['item']; @endphp
  <div class="rounded-2xl bg-white dark:bg-slate-900 border border-slate-200 dark:border-slate-800 overflow-hidden">
    <div class="p-6 pb-3 flex flex-wrap items-start justify-between gap-3">
      <div>
        <div class="font-bold text-lg">{{ $i->product_name }}</div>
        <div class="text-xs text-slate-500">{{ $i->product_code }} · Sold {{ (float) $i->quantity }} {{ $i->unit }} at AED {{ number_format($i->unit_price, 2) }} (before VAT)</div>
      </div>
      <div class="text-right text-sm">
        <div>Sales <b>AED {{ number_format($r['rev'], 2) }}</b> · Cost <b>AED {{ number_format($r['cost'], 2) }}</b></div>
        <div class="{{ $r['profit'] >= 0 ? 'text-emerald-500' : 'text-red-500' }} font-bold">Profit AED {{ number_format($r['profit'], 2) }}</div>
      </div>
    </div>

    <div class="overflow-x-auto">
      <table class="w-full text-sm">
        <thead class="text-left text-xs uppercase text-slate-500 bg-slate-50 dark:bg-slate-800/50">
          <tr>
            <th class="px-6 py-3">Taken from stock lot</th>
            <th>Lot date</th>
            <th>Supplier</th>
            <th class="text-right">Qty taken</th>
            <th class="text-right">Cost / unit</th>
            <th class="px-6 text-right">Cost</th>
          </tr>
        </thead>
        <tbody class="divide-y divide-slate-100 dark:divide-slate-800">
          @forelse ($r['parts'] as $a)
            @php $b = $a->batch; @endphp
            <tr>
              <td class="px-6 py-3 font-semibold">
                @if ($b)
                  <a href="{{ route('admin.stock-layers.show', $b) }}" class="text-brand-600 dark:text-brand-400 hover:underline">
                    {{ $b->purchase?->reference ?? 'Opening stock' }}
                  </a>
                @else
                  <span class="text-amber-500">No lot (product cost used)</span>
                @endif
              </td>
              <td>{{ $b?->received_date?->format('d M Y') ?? '—' }}</td>
              <td>{{ $b?->purchase?->supplier?->name ?? '—' }}</td>
              <td class="text-right">{{ (float) $a->quantity }}</td>
              <td class="text-right">{{ number_format($a->unit_cost, 2) }}</td>
              <td class="px-6 text-right font-semibold">{{ number_format($a->quantity * $a->unit_cost, 2) }}</td>
            </tr>
          @empty
            <tr>
              <td class="px-6 py-3 text-slate-500" colspan="3">Sold before FIFO tracking — single cost recorded</td>
              <td class="text-right">{{ (float) $i->quantity }}</td>
              <td class="text-right">{{ number_format($i->unit_cost, 2) }}</td>
              <td class="px-6 text-right font-semibold">{{ number_format($r['cost'], 2) }}</td>
            </tr>
          @endforelse
        </tbody>
      </table>
    </div>
  </div>
@endforeach

<div><a href="{{ route('admin.sales.show', $sale) }}" class="h-11 px-6 inline-flex items-center rounded-xl border border-slate-300 dark:border-slate-700 font-semibold hover:bg-slate-100 dark:hover:bg-slate-800">← Back to sale</a></div>
@endsection