@extends('pdf.layout')

@section('content')
@php
    $n = fn ($v) => rtrim(rtrim(number_format((float) $v, 2), '0'), '.') ?: '0';
    $m = fn ($v) => number_format((float) $v, 2);
@endphp

<table class="kpis">
    <tr>
        <td><div class="kpi"><div class="label">Current stock</div><div class="value">{{ $n($product->current_stock) }} {{ $product->unit->short_name ?? '' }}</div><div class="note">Alert at {{ $n($product->alertLevel()) }}</div></div></td>
        <td><div class="kpi"><div class="label">Sold</div><div class="value">{{ $n($salesTotals->qty) }}</div><div class="note">MWK {{ $m($salesTotals->amount) }} in {{ $salesTotals->count }} sale(s)</div></div></td>
        <td><div class="kpi"><div class="label">Purchased / stock in</div><div class="value">{{ $n($purchaseTotals->qty) }}</div><div class="note">MWK {{ $m($purchaseTotals->amount) }}</div></div></td>
        <td><div class="kpi"><div class="label">Prices</div><div class="value">MWK {{ $m($product->selling_price) }}</div><div class="note">Cost MWK {{ $m($product->purchase_price) }}</div></div></td>
    </tr>
</table>
<p class="small muted" style="margin: 0;">
    {{ $product->category->name ?? 'No category' }}{{ $product->brand ? ' - ' . $product->brand->name : '' }}{{ $product->supplier ? ' - Supplier: ' . $product->supplier->name : '' }}
</p>

<h2>Sales ({{ $sales->total() }})</h2>
@if($sales->count())
<table class="data">
    <thead><tr><th>Date</th><th>Invoice</th><th>Customer</th><th>Payment</th><th class="r">Qty</th><th class="r">Price</th><th class="r">Amount (MWK)</th><th>Sold by</th></tr></thead>
    <tbody>
        @foreach($sales as $item)
            <tr>
                <td class="nowrap">{{ \Carbon\Carbon::parse($item->sold_at)->format('d M Y H:i') }}</td>
                <td class="nowrap">{{ $item->sale->invoice_no ?? '-' }}@if($item->sale?->is_edited) <span class="badge badge-amber">edited</span>@endif</td>
                <td>{{ $item->sale->customer_name ?? 'Walk-in' }}</td>
                <td>{{ ucwords(str_replace('_', ' ', $item->sale->payment_method ?? '-')) }}</td>
                <td class="r">{{ $n($item->quantity) }}</td>
                <td class="r">{{ $m($item->price) }}</td>
                <td class="r">{{ $m($item->subtotal) }}</td>
                <td>{{ ($item->sale?->user ?? $item->sale?->register?->user)->name ?? '-' }}</td>
            </tr>
        @endforeach
        <tr class="total"><td colspan="4">Total</td><td class="r">{{ $n($salesTotals->qty) }}</td><td></td><td class="r">{{ $m($salesTotals->amount) }}</td><td></td></tr>
    </tbody>
</table>
@else
    <div class="empty">No sales in this period.</div>
@endif

<h2>Purchases and stock in ({{ $purchases->total() }})</h2>
@if($purchases->count())
<table class="data">
    <thead><tr><th>Date</th><th>Reference</th><th>Supplier</th><th>Status</th><th class="r">Qty</th><th class="r">Unit cost</th><th class="r">Total (MWK)</th><th>Expiry</th><th>By</th></tr></thead>
    <tbody>
        @foreach($purchases as $row)
            <tr>
                <td class="nowrap">{{ $row->date->format('d M Y') }}</td>
                <td>{{ $row->reference }}</td>
                <td>{{ $row->supplier }}</td>
                <td>{{ ucfirst($row->status) }}</td>
                <td class="r">{{ $n($row->quantity) }}</td>
                <td class="r">{{ $m($row->unit_cost) }}</td>
                <td class="r">{{ $m($row->line_total) }}</td>
                <td class="nowrap">{{ $row->expiry ? \Carbon\Carbon::parse($row->expiry)->format('d M Y') : '-' }}</td>
                <td>{{ $row->user }}</td>
            </tr>
        @endforeach
        <tr class="total"><td colspan="4">Total</td><td class="r">{{ $n($purchaseTotals->qty) }}</td><td></td><td class="r">{{ $m($purchaseTotals->amount) }}</td><td colspan="2"></td></tr>
    </tbody>
</table>
@else
    <div class="empty">No purchases or stock in this period.</div>
@endif

<h2>Stock adjustments ({{ $adjustments->total() }})</h2>
@if($adjustments->count())
<table class="data">
    <thead><tr><th>Date</th><th>Type</th><th class="r">Change</th><th class="r">Stock before / after</th><th>Price change</th><th>Reason</th><th>By</th></tr></thead>
    <tbody>
        @foreach($adjustments as $a)
            <tr>
                <td class="nowrap">{{ $a->created_at->format('d M Y H:i') }}</td>
                <td><span class="badge {{ $a->adjustment_type === 'add' ? 'badge-green' : 'badge-red' }}">{{ $a->adjustment_type_text }}</span></td>
                <td class="r b {{ $a->adjustment_type === 'add' ? 'pos' : 'neg' }}">{{ $a->quantity_change }}</td>
                <td class="r">{{ $n($a->previous_quantity) }} &rarr; {{ $n($a->new_quantity) }}</td>
                <td>{{ $a->previous_price != $a->new_price ? $m($a->previous_price) . ' -> ' . $m($a->new_price) : '-' }}</td>
                <td>{{ $a->reason }}</td>
                <td>{{ $a->user->name ?? '-' }}</td>
            </tr>
        @endforeach
    </tbody>
</table>
@else
    <div class="empty">No stock adjustments in this period.</div>
@endif

<h2>Stock at each register opening and closing ({{ $registers->total() }})</h2>
@if($registers->count())
<table class="data">
    <thead><tr><th>Day</th><th>Register</th><th>Opened</th><th class="r">Stock at opening</th><th>Closed</th><th class="r">Stock at closing</th><th class="r">Change</th></tr></thead>
    <tbody>
        @foreach($registers as $register)
            @php
                $open = $register->stock_opening;
                $close = $register->stock_closing;
                $change = $open && $close ? (float) $close['qty'] - (float) $open['qty'] : null;
            @endphp
            <tr>
                <td class="nowrap">{{ $register->opened_at->format('D d M Y') }}</td>
                <td>#{{ $register->id }} <span class="muted">{{ $register->user->name ?? '' }}</span></td>
                <td>{{ $register->opened_at->format('H:i') }}</td>
                <td class="r">{{ $open ? $n($open['qty']) . ($open['estimated'] ? ' est.' : '') : '-' }}</td>
                <td>{{ $register->closed_at?->format('H:i') ?? 'open' }}</td>
                <td class="r">{{ $close ? $n($close['qty']) . ($close['estimated'] ? ' est.' : '') : '-' }}</td>
                <td class="r {{ $change < 0 ? 'neg' : '' }}">{{ $change === null ? '-' : (($change > 0 ? '+' : '') . $n($change)) }}</td>
            </tr>
        @endforeach
    </tbody>
</table>
<p class="small muted">"est." = worked out from the stock history (no snapshot was taken for that register).</p>
@else
    <div class="empty">No registers in this period.</div>
@endif
@endsection