@extends('garage.layouts.app')

@section('title', 'Inventory flow report')

@push('styles')
<style>
    .rif-hero {
        background: linear-gradient(135deg, #f0fdfa 0%, #ecfeff 45%, #f8fafc 100%);
        border: 1px solid #ccfbf1;
        border-radius: 14px;
        padding: 1rem 1.25rem;
        margin-bottom: 1rem;
    }
    .rif-hero h1 { font-size: 1.15rem; font-weight: 900; letter-spacing: -0.02em; margin: 0; }
    .rif-hero p { margin: .25rem 0 0; color: #64748b; font-size: .82rem; }
    .rif-kpi {
        background: #fff;
        border: 1px solid #e2e8f0;
        border-radius: 14px;
        box-shadow: 0 6px 22px rgba(15, 23, 42, 0.06);
        padding: .85rem 1rem;
        height: 100%;
    }
    .rif-kpi .lbl { font-size: .65rem; font-weight: 800; text-transform: uppercase; letter-spacing: .08em; color: #94a3b8; }
    .rif-kpi .val { font-size: 1.1rem; font-weight: 900; letter-spacing: -0.02em; color: #0f172a; margin-top: .2rem; }
    .rif-kpi .hint { font-size: .75rem; color: #64748b; margin-top: .2rem; }
    .rif-box {
        border: 1px solid #e2e8f0;
        border-radius: 14px;
        overflow: hidden;
        background: #fff;
        box-shadow: 0 10px 30px rgba(15, 23, 42, 0.08);
    }
    .rif-toolbar {
        padding: .75rem 1rem;
        background: linear-gradient(180deg, #fafafa 0%, #fff 100%);
        border-bottom: 1px solid #f1f5f9;
        display: flex;
        flex-wrap: wrap;
        gap: .5rem;
        align-items: center;
        justify-content: space-between;
    }
    .rif-search {
        min-width: 16rem;
        max-width: 32rem;
        flex: 1;
        border-radius: 12px;
        border: 1px solid #e2e8f0;
        padding: .45rem .65rem;
        font-size: .85rem;
        background: #fff;
    }
    .rif-search:focus { outline: none; border-color: #0d9488; box-shadow: 0 0 0 3px rgba(13,148,136,.12); }
    .rif-table thead th {
        position: sticky;
        top: 0;
        z-index: 2;
        background: #f8fafc;
        border-bottom: 1px solid #e2e8f0;
        font-size: .68rem;
        font-weight: 800;
        text-transform: uppercase;
        letter-spacing: .06em;
        color: #64748b;
    }
    .rif-table thead th .bi { font-size: .8rem; opacity: .65; }
    .rif-table thead th { padding-top: .45rem; padding-bottom: .45rem; }
    .rif-table tbody td { padding-top: .35rem; padding-bottom: .35rem; }
    .rif-table tbody tr:nth-child(odd) { background: rgba(248, 250, 252, 0.40); }
    .rif-table tbody tr:hover { background: rgba(240, 253, 250, 0.40); }
    .rif-sku { font-family: ui-monospace, 'Cascadia Code', monospace; font-size: .72rem; font-weight: 800; color: #0f766e; }
    .rif-part { font-weight: 600; color: #0f172a; font-size: .9rem; }
    .rif-badge {
        display: inline-flex;
        align-items: center;
        gap: .35rem;
        padding: .18rem .5rem;
        border-radius: 999px;
        font-size: .72rem;
        font-weight: 800;
        border: 1px solid #e2e8f0;
        background: #fff;
        white-space: nowrap;
    }
    .rif-b-ok { border-color: #a7f3d0; background: #ecfdf5; color: #047857; }
    .rif-b-warn { border-color: #fde68a; background: #fffbeb; color: #b45309; }
    .rif-b-bad { border-color: #fecaca; background: #fef2f2; color: #b91c1c; }
</style>
@endpush

@section('content')
<div class="container-fluid px-2 px-lg-3 py-3">
        @php
            $kpiReceived = 0;
            $kpiReturned = 0;
            $kpiSold = 0;
            $kpiSaleReturned = 0;
            $kpiOnHand = 0;
            foreach ($parts as $p) {
            $pid = (int) $p->id;
            $kpiReceived += (int) ($received[$pid] ?? 0);
            $kpiReturned += (int) ($returned[$pid] ?? 0);
            $kpiSold += (int) ($sold[$pid] ?? 0);
            $kpiSaleReturned += (int) ($saleReturned[$pid] ?? 0);
            $kpiOnHand += (int) ($p->stock_quantity ?? 0);
        }
    @endphp

    <div class="rif-hero d-flex flex-wrap align-items-start justify-content-between gap-2">
        <div>
            <h1><i class="bi bi-boxes me-2 text-primary"></i>Inventory flow</h1>
            <p>Purchase received − purchase return − net sale (completed sales − sale returns) vs on‑hand stock.</p>
        </div>
        <div class="d-flex gap-2">
            <a href="{{ route('garage.reports.index') }}" class="btn btn-sm btn-outline-secondary">All reports</a>
        </div>
    </div>

    <div class="row g-3 mb-3">
        <div class="col-md-3">
            <div class="rif-kpi">
                <div class="lbl">Received</div>
                <div class="val">{{ number_format($kpiReceived) }}</div>
                <div class="hint">Qty on received purchase bills</div>
            </div>
        </div>
        <div class="col-md-3 col-lg-2">
            <div class="rif-kpi">
                <div class="lbl">Purch. return</div>
                <div class="val text-danger">{{ number_format($kpiReturned) }}</div>
                <div class="hint">Posted purchase returns</div>
            </div>
        </div>
        <div class="col-md-3 col-lg-2">
            <div class="rif-kpi">
                <div class="lbl">Sold</div>
                <div class="val">{{ number_format($kpiSold) }}</div>
                <div class="hint">Completed sales</div>
            </div>
        </div>
        <div class="col-md-3 col-lg-2">
            <div class="rif-kpi">
                <div class="lbl">Sale return</div>
                <div class="val text-primary">{{ number_format($kpiSaleReturned) }}</div>
                <div class="hint">Posted sale returns (stock in)</div>
            </div>
        </div>
        <div class="col-md-3 col-lg-2">
            <div class="rif-kpi">
                <div class="lbl">On hand</div>
                <div class="val">{{ number_format($kpiOnHand) }}</div>
                <div class="hint">Current stock quantity</div>
            </div>
        </div>
    </div>

    <div class="rif-box">
        <form method="GET" action="{{ route('garage.reports.inventory-flow') }}" class="rif-toolbar">
            <div class="d-flex align-items-center gap-2 flex-wrap">
                <span class="badge rounded-pill" style="background:#ccfbf1;color:#0f766e;font-weight:800;">{{ number_format($parts->count()) }} parts</span>
                <span class="small text-muted">Type to filter by SKU / name / code</span>
            </div>
            <div class="d-flex align-items-center gap-2 flex-wrap" style="min-width: 18rem;">
                <input type="search" name="q" value="{{ $q }}" class="rif-search" placeholder="Search…">
                <button type="submit" class="btn btn-sm btn-primary">Search</button>
                <a href="{{ route('garage.reports.inventory-flow') }}" class="btn btn-sm btn-outline-secondary">Clear</a>
            </div>
        </form>

        <div class="table-responsive">
            <table class="table table-sm table-hover mb-0 align-middle rif-table">
                <thead>
                <tr>
                    <th><i class="bi bi-upc-scan me-1"></i>SKU</th>
                    <th><i class="bi bi-wrench-adjustable-circle me-1"></i>Part</th>
                    <th class="text-end">Received</th>
                    <th class="text-end">Purch. ret.</th>
                    <th class="text-end">Sold</th>
                    <th class="text-end">Sale ret.</th>
                    <th class="text-end">Net sold</th>
                    <th class="text-end">On hand</th>
                    <th class="text-end">Expected</th>
                </tr>
                </thead>
                <tbody>
                @forelse($parts as $p)
                    @php
                        $pid = (int) $p->id;
                        $receivedQty = (int) ($received[$pid] ?? 0);
                        $returnedQty = (int) ($returned[$pid] ?? 0);
                        $soldQty = (int) ($sold[$pid] ?? 0);
                        $saleReturnedQty = (int) ($saleReturned[$pid] ?? 0);
                        $netSoldQty = max(0, $soldQty - $saleReturnedQty);
                        $onHand = (int) ($p->stock_quantity ?? 0);
                        $expected = $receivedQty - $returnedQty - $netSoldQty;
                        $diff = $onHand - $expected;
                        $badgeClass = $onHand <= 0 ? 'rif-b-bad' : ($onHand <= 2 ? 'rif-b-warn' : 'rif-b-ok');
                    @endphp
                    <tr>
                        <td class="rif-sku">{{ $p->inventory_code ?? $p->code ?? '—' }}</td>
                        <td class="rif-part">{{ $p->name }}</td>
                        <td class="text-end">{{ number_format($receivedQty) }}</td>
                        <td class="text-end text-danger">{{ number_format($returnedQty) }}</td>
                        <td class="text-end">{{ number_format($soldQty) }}</td>
                        <td class="text-end text-primary">{{ number_format($saleReturnedQty) }}</td>
                        <td class="text-end fw-semibold">{{ number_format($netSoldQty) }}</td>
                        <td class="text-end">
                            <span class="rif-badge {{ $badgeClass }}">
                                <i class="bi bi-box-seam"></i>{{ number_format($onHand) }}
                            </span>
                        </td>
                        <td class="text-end">
                            @if($diff !== 0)
                                <span class="rif-badge rif-b-warn" title="On hand minus (received − returned − sold)">
                                    <i class="bi bi-exclamation-triangle"></i>{{ number_format($diff) }}
                                </span>
                            @else
                                <span class="rif-badge rif-b-ok"><i class="bi bi-check-lg"></i>{{ number_format($expected) }}</span>
                            @endif
                        </td>
                    </tr>
                @empty
                    <tr>
                        <td colspan="9" class="text-center text-muted py-4">No parts found.</td>
                    </tr>
                @endforelse
                </tbody>
            </table>
        </div>
    </div>

    <div class="small text-muted mt-2">
        Notes: Expected on hand = purchase received − purchase return − (sale qty − sale return qty). Sale returns restore stock (posted <code>garage_sale_returns</code>).
    </div>
</div>
@endsection