@extends('layouts.app')
@section('title', 'Profit & loss')

@section('content')
@php
    $change = fn ($c, $p) => abs($p) < 0.005 ? null : round(($c - $p) / abs($p) * 100, 1);
    $delta = function ($c, $p, $cost = false) use ($change) {
        $d = $change($c, $p);
        if ($d === null) return '<span class="text-muted">—</span>';
        $dir = abs($d) < 0.05 ? 'flat' : ($d > 0 ? 'up' : 'down');
        $icon = $dir === 'up' ? 'arrow-up-right' : ($dir === 'down' ? 'arrow-down-right' : 'dash');
        return '<span class="'.($cost ? 'invert' : '').'"><span class="delta '.$dir.'"><i class="bi bi-'.$icon.'"></i>'.number_format(abs($d), 1).'%</span></span>';
    };
    $net = $cash['received'] - $cash['vendors'] - $cash['expenses'];
    $rows = [
        ['Sales, net of discounts', $revenue, $prev['revenue'], false, 'fw-normal'],
        ['Less: vendor purchases & job work', -$purchases, -$prev['purchases'], true, 'fw-normal'],
        ['Gross profit', $grossProfit, $prev['grossProfit'], false, 'fw-bold'],
    ];
@endphp
<x-page-header title="Profit & loss" :subtitle="$from->format('d M Y').' – '.$to->format('d M Y').' · compared with '.$prevFrom->format('d M').' – '.$prevTo->format('d M Y')">
    <button class="btn btn-ghost d-print-none" type="button" onclick="window.print()"><i class="bi bi-printer" aria-hidden="true"></i> Print</button>
</x-page-header>
@include('reports._range')

<div class="row g-3 mb-3 stagger">
    <div class="col-6 col-xl-3"><div class="card card-body py-3"><div class="stat-label">Sales (net)</div><div class="stat-value">{{ money($revenue) }}</div><div class="mt-1">{!! $delta($revenue, $prev['revenue']) !!}</div></div></div>
    <div class="col-6 col-xl-3"><div class="card card-body py-3"><div class="stat-label">Gross profit</div><div class="stat-value {{ $grossProfit < 0 ? 'text-danger' : '' }}">{{ money($grossProfit) }}</div><div class="mt-1">{!! $delta($grossProfit, $prev['grossProfit']) !!}</div></div></div>
    <div class="col-6 col-xl-3"><div class="card card-body py-3"><div class="stat-label">Expenses</div><div class="stat-value">{{ money($totalExpenses) }}</div><div class="mt-1">{!! $delta($totalExpenses, $prev['totalExpenses'], true) !!}</div></div></div>
    <div class="col-6 col-xl-3"><div class="card card-body hero-card py-3"><div class="stat-label">Net profit</div><div class="stat-value">{{ money($netProfit) }}</div><div class="mt-1 small" style="color:rgba(255,255,255,.8)">Previous: {{ money($prev['netProfit']) }}</div></div></div>
</div>

<div class="card mb-3">
    <div class="card-header"><span class="card-title">This period vs previous</span></div>
    <div class="card-body"><div class="chart-box h-sm"><canvas data-chart='@json($chart, JSON_HEX_APOS | JSON_HEX_AMP)' role="img" aria-label="Bar chart comparing sales, purchases, expenses and net profit with the previous period"></canvas></div></div>
</div>

<div class="row g-3">
    <div class="col-lg-7">
        <div class="card">
            <div class="card-header"><span class="card-title">Profit & loss statement</span><span class="card-sub">Based on order and bill dates · {{ $orderCount }} orders</span></div>
            <div class="table-wrap">
                <table class="table table-modern align-middle mb-0">
                    <thead><tr><th>&nbsp;</th><th class="num">This period</th><th class="num d-none d-sm-table-cell">Previous</th><th class="num">Change</th></tr></thead>
                    <tbody>
                    @foreach ($rows as [$label, $a, $b, $cost, $weight])
                        <tr class="{{ $weight === 'fw-bold' ? 'table-active' : '' }}"><td class="cell-wrap {{ $weight }}">{{ $label }}</td><td class="num {{ $weight }} {{ $a < 0 && $weight === 'fw-bold' ? 'text-danger' : '' }}">{{ money($a) }}</td><td class="num text-muted d-none d-sm-table-cell">{{ money($b) }}</td><td class="num">{!! $delta($a, $b) !!}</td></tr>
                    @endforeach
                        <tr><td colspan="4" class="text-muted small pt-3 text-uppercase fw-semibold" style="letter-spacing:.06em">Operating expenses</td></tr>
                    @forelse ($expensesByCategory as $row)
                        @php($pv = (float) ($prev['expensesByCategory']->firstWhere('expense_category_id', $row->expense_category_id)->total ?? 0))
                        <tr><td class="ps-4 cell-wrap">{{ $row->category->name }}</td><td class="num">−{{ money($row->total) }}</td><td class="num text-muted d-none d-sm-table-cell">−{{ money($pv) }}</td><td class="num">{!! $delta((float) $row->total, $pv, true) !!}</td></tr>
                    @empty
                        <tr><td class="ps-4 text-muted">No expenses in this period</td><td class="num">{{ money(0) }}</td><td class="num text-muted d-none d-sm-table-cell">{{ money(0) }}</td><td></td></tr>
                    @endforelse
                        <tr><td>Total expenses</td><td class="num">−{{ money($totalExpenses) }}</td><td class="num text-muted d-none d-sm-table-cell">−{{ money($prev['totalExpenses']) }}</td><td class="num">{!! $delta($totalExpenses, $prev['totalExpenses'], true) !!}</td></tr>
                        <tr class="table-active"><td class="fw-bold">Net profit</td><td class="num fw-bold {{ $netProfit < 0 ? 'text-danger' : 'text-success' }}">{{ money($netProfit) }}</td><td class="num text-muted d-none d-sm-table-cell">{{ money($prev['netProfit']) }}</td><td class="num">{!! $delta($netProfit, $prev['netProfit']) !!}</td></tr>
                    </tbody>
                </table>
            </div>
            <div class="card-footer">{{ config('erp.tax_label') }} collected on these orders ({{ money($taxCollected) }}) is excluded — it is owed to the government, not income.</div>
        </div>
    </div>
    <div class="col-lg-5">
        <div class="card">
            <div class="card-header"><span class="card-title">Cash summary</span><span class="card-sub">Money actually moved</span></div>
            <div class="table-wrap">
                <table class="table table-modern align-middle mb-0">
                    <tbody>
                        <tr><td>Received from clients</td><td class="num money-in fw-semibold">{{ money($cash['received']) }}</td></tr>
                        <tr><td>Paid to vendors</td><td class="num">−{{ money($cash['vendors']) }}</td></tr>
                        <tr><td>Operating expenses paid</td><td class="num">−{{ money($cash['expenses']) }}</td></tr>
                        <tr class="table-active"><td class="fw-bold">Net cash flow</td><td class="num fw-bold {{ $net < 0 ? 'text-danger' : 'text-success' }}">{{ money($net) }}</td></tr>
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>
@endsection