@extends('pdf.layout')

@section('content')
@php
    $m = fn ($v) => number_format((float) $v, 2);
    $pct = fn ($v) => $v === null ? '-' : (($v >= 0 ? '+' : '') . number_format($v, 1) . '%');
@endphp

<table class="kpis">
    <tr>
        <td><div class="kpi"><div class="label">Sales</div><div class="value">{{ $currency }} {{ $m($totalSales) }}</div><div class="note">{{ $totalTransactions }} transactions, {{ $pct($deltas['revenue']) }} {{ $comparisonLabel }}</div></div></td>
        <td><div class="kpi"><div class="label">Gross profit</div><div class="value">{{ $currency }} {{ $m($grossProfit) }}</div><div class="note">{{ $grossMargin }}% margin, {{ $pct($deltas['gross_profit']) }}</div></div></td>
        <td><div class="kpi"><div class="label">Net profit</div><div class="value {{ $netProfit < 0 ? 'neg' : '' }}">{{ $currency }} {{ $m($netProfit) }}</div><div class="note">{{ $netMargin }}% margin, {{ $pct($deltas['net_profit']) }}</div></div></td>
        <td><div class="kpi"><div class="label">Items sold</div><div class="value">{{ number_format($totalItemsSold) }}</div><div class="note">Stock turnover {{ number_format($inventoryTurnover, 2) }}x</div></div></td>
    </tr>
</table>

<h2>Income statement</h2>
<table class="data">
    <tr><th>Item</th><th class="r" style="width: 28%;">{{ $currency }}</th><th class="r" style="width: 14%;">% of sales</th></tr>
    <tr><td class="b">Sales</td><td class="r b">{{ $m($totalSales) }}</td><td class="r">100.0%</td></tr>
    <tr><td>Less: cost of goods sold</td><td class="r">({{ $m($costOfGoodsSold) }})</td><td class="r">{{ $totalSales > 0 ? number_format($costOfGoodsSold / $totalSales * 100, 1) : '0.0' }}%</td></tr>
    <tr class="total"><td>Gross profit</td><td class="r">{{ $m($grossProfit) }}</td><td class="r">{{ $grossMargin }}%</td></tr>
    <tr><td>Less: stock written off</td><td class="r">({{ $m($stockWrittenOff) }})</td><td></td></tr>
    @foreach($writeOffsByReason as $reason => $amount)
        <tr class="sub"><td style="padding-left: 16px;">{{ $reason }}</td><td class="r">{{ $m($amount) }}</td><td></td></tr>
    @endforeach
    <tr><td>Less: operating expenses</td><td class="r">({{ $m($operatingExpenses) }})</td><td></td></tr>
    @foreach($expensesByCategory as $category => $amount)
        <tr class="sub"><td style="padding-left: 16px;">{{ $category }}</td><td class="r">{{ $m($amount) }}</td><td></td></tr>
    @endforeach
    <tr class="total"><td>Net profit</td><td class="r {{ $netProfit < 0 ? 'neg' : '' }}">{{ $m($netProfit) }}</td><td class="r">{{ $netMargin }}%</td></tr>
</table>

<h2>Stock</h2>
<table class="data">
    <tr><th>Item</th><th class="r">At cost ({{ $currency }})</th><th class="r">At selling price ({{ $currency }})</th></tr>
    <tr><td>Stock at the start ({{ $fromDateLabel }})</td><td class="r">{{ $m($openingStockCost) }}</td><td class="r">{{ $m($openingStockRetail) }}</td></tr>
    <tr><td>+ Stock received (purchases, stock in, new products)</td><td class="r">{{ $m($stockReceived) }}</td><td></td></tr>
    <tr class="sub"><td style="padding-left: 16px;">of which purchases recorded</td><td class="r">{{ $m($totalPurchase) }}</td><td></td></tr>
    <tr class="sub"><td style="padding-left: 16px;">of which stock-in adjustments</td><td class="r">{{ $m($stockInByAdjustment) }}</td><td></td></tr>
    <tr><td>- Cost of goods sold</td><td class="r">{{ $m($costOfGoodsSold) }}</td><td></td></tr>
    <tr><td>- Stock written off</td><td class="r">{{ $m($stockWrittenOff) }}</td><td></td></tr>
    @if($otherStockChanges)
        <tr><td>Other changes (price updates, stock found, deleted sales)</td><td class="r">{{ $m($otherStockChanges) }}</td><td></td></tr>
    @endif
    <tr class="total"><td>Stock at the end ({{ $toDateLabel }}), {{ number_format($totalStockUnits) }} units</td><td class="r">{{ $m($closingStockCost) }}</td><td class="r">{{ $m($closingStockRetail) }}</td></tr>
</table>

<h2>Most profitable products</h2>
@if(count($topProducts))
<table class="data">
    <tr><th style="width: 4%;">#</th><th style="width: 44%;">Product</th><th class="r">Qty</th><th class="r">Sales ({{ $currency }})</th><th class="r">Profit ({{ $currency }})</th><th class="r">Margin</th></tr>
    @foreach($topProducts as $i => $p)
        <tr><td class="muted">{{ $i + 1 }}</td><td>{{ $p['name'] }}</td><td class="r">{{ rtrim(rtrim(number_format($p['qty'], 2), '0'), '.') }}</td><td class="r">{{ $m($p['revenue']) }}</td><td class="r">{{ $m($p['profit']) }}</td><td class="r">{{ $p['margin'] }}%</td></tr>
    @endforeach
</table>
@else
    <div class="empty">No sales in this period.</div>
@endif

@if(count($categoryMargins))
<h2>Categories</h2>
<table class="data">
    <tr><th>Category</th><th class="r">Sales ({{ $currency }})</th><th class="r">Profit ({{ $currency }})</th><th class="r">Margin</th></tr>
    @foreach($categoryMargins as $name => $c)
        <tr><td>{{ $name }}</td><td class="r">{{ $m($c['revenue']) }}</td><td class="r">{{ $m($c['profit']) }}</td><td class="r">{{ $c['margin'] }}%</td></tr>
    @endforeach
</table>
@endif

<h2>Slow-moving stock (not sold in 30 days)</h2>
@if($slowMovingProducts->count())
<table class="data">
    <tr><th>Product</th><th class="r">In stock</th><th class="r">Value at cost ({{ $currency }})</th></tr>
    @foreach($slowMovingProducts as $p)
        <tr><td>{{ $p->name }}</td><td class="r">{{ rtrim(rtrim(number_format((float) $p->current_stock, 2), '0'), '.') }}</td><td class="r">{{ $m((float) $p->current_stock * (float) $p->purchase_price) }}</td></tr>
    @endforeach
    <tr class="total"><td>Total tied up in slow-moving stock</td><td></td><td class="r">{{ $m($slowMovingValue) }}</td></tr>
</table>
@else
    <div class="empty">Everything in stock sold in the last 30 days.</div>
@endif

<h2>Last six months</h2>
<table class="data">
    <tr><th>Month</th><th class="r">Sales ({{ $currency }})</th><th class="r">Costs and expenses ({{ $currency }})</th><th class="r">Net profit ({{ $currency }})</th></tr>
    @foreach($seasonalityTrend as $month)
        <tr><td>{{ $month['month'] }}</td><td class="r">{{ $m($month['revenue']) }}</td><td class="r">{{ $m($month['expenses']) }}</td><td class="r {{ $month['net_profit'] < 0 ? 'neg' : '' }}">{{ $m($month['net_profit']) }}</td></tr>
    @endforeach
</table>
@endsection