@extends('layouts.app')

@section('title', 'Purchases Report')

@section('content')
@php
    $qty = fn ($value) => rtrim(rtrim(number_format((float) $value, 2), '0'), '.');
    $periods = ['' => 'This month', 'today' => 'Today', 'yesterday' => 'Yesterday', 'this_week' => 'This week',
        'last_month' => 'Last month', 'this_year' => 'This year', 'all' => 'All time'];
    $customDates = request()->hasAny(['from', 'to']) && !request()->filled('period');
    $activePeriod = $customDates ? null : request('period', '');
    $periodText = $activePeriod === 'all' ? 'all time'
        : ($from->isSameDay($to) ? 'on ' . $from->format('l, d M Y') : 'from ' . $from->format('d M Y') . ' to ' . $to->format('d M Y'));
    $filtered = request()->hasAny(['supplier_id', 'product', 'batch_no', 'reference', 'payment_status', 'source'])
        && collect(request()->only(['supplier_id', 'product', 'batch_no', 'reference', 'payment_status', 'source']))->filter()->isNotEmpty();
    $sourceTone = ['purchase' => 'primary', 'opening_stock' => 'info', 'bulk_products' => 'info', 'stock_adjustment' => 'success', 'bulk_stock' => 'success'];
@endphp
<div class="container-fluid">
    <div class="d-flex justify-content-between align-items-start mb-3 flex-wrap gap-2">
        <div>
            <h4 class="fw-bold mb-1">Purchases</h4>
            <p class="text-muted small mb-0">All stock received {{ $periodText }}: purchases, opening stock of new products and stock adjustments.</p>
        </div>
        <div class="d-flex gap-2 flex-wrap">
            <x-report-buttons />
            <a href="{{ route('reports.purchases.export', request()->query()) }}" class="btn btn-outline-success btn-sm">
                <i class="bi bi-file-earmark-spreadsheet me-1"></i> CSV
            </a>
        </div>
    </div>

    <!-- Quick periods -->
    <div class="pr-periods mb-3" role="group" aria-label="Period">
        @foreach($periods as $key => $label)
            <a href="{{ route('reports.purchases', array_filter(['period' => $key] + request()->except(['period', 'from', 'to', 'page']))) }}"
               class="btn btn-sm {{ $activePeriod === $key ? 'btn-primary' : 'btn-outline-secondary' }}">{{ $label }}</a>
        @endforeach
    </div>

    <!-- Filters -->
    <form method="GET" action="{{ route('reports.purchases') }}" class="pr-card mb-4">
        <div class="row g-2 align-items-end">
            <div class="col-6 col-md-2">
                <label class="form-label small fw-semibold mb-1" for="from">From</label>
                <input type="date" name="from" id="from" class="form-control form-control-sm" value="{{ $activePeriod === 'all' ? '' : $from->toDateString() }}">
            </div>
            <div class="col-6 col-md-2">
                <label class="form-label small fw-semibold mb-1" for="to">To</label>
                <input type="date" name="to" id="to" class="form-control form-control-sm" value="{{ $to->toDateString() }}">
            </div>
            <div class="col-6 col-md-2">
                <label class="form-label small fw-semibold mb-1" for="source">Source</label>
                <select name="source" id="source" class="form-select form-select-sm">
                    <option value="">All</option>
                    @foreach($sources as $value => $label)
                        <option value="{{ $value }}" @selected(request('source') === $value)>{{ $label }}</option>
                    @endforeach
                </select>
            </div>
            <div class="col-6 col-md-2">
                <label class="form-label small fw-semibold mb-1" for="supplier_id">Supplier</label>
                <select name="supplier_id" id="supplier_id" class="form-select form-select-sm">
                    <option value="">All</option>
                    @foreach($suppliers as $supplier)
                        <option value="{{ $supplier->id }}" @selected(request('supplier_id') == $supplier->id)>{{ $supplier->name }}</option>
                    @endforeach
                </select>
            </div>
            <div class="col-6 col-md-2">
                <label class="form-label small fw-semibold mb-1" for="product">Product</label>
                <input type="text" name="product" id="product" class="form-control form-control-sm" value="{{ request('product') }}">
            </div>
            <div class="col-6 col-md-1">
                <label class="form-label small fw-semibold mb-1" for="batch_no">Batch</label>
                <input type="text" name="batch_no" id="batch_no" class="form-control form-control-sm text-uppercase" value="{{ request('batch_no') }}">
            </div>
            <div class="col-12 col-md-1 d-flex gap-1">
                <button type="submit" class="btn btn-primary btn-sm flex-fill" title="Apply"><i class="bi bi-funnel"></i></button>
                <a href="{{ route('reports.purchases') }}" class="btn btn-outline-secondary btn-sm" title="Clear filters"><i class="bi bi-x-lg"></i></a>
            </div>
        </div>
    </form>

    <!-- Headline -->
    <div class="row g-3 mb-4">
        @foreach([
            ['Money spent', formatCurrency($totals->cost), number_format($totals->purchases) . ' ' . ($totals->purchases == 1 ? 'entry' : 'entries'), 'bi-wallet2', 'danger'],
            ['Value at selling price', formatCurrency($totals->sales_value), 'if all of it is sold', 'bi-cash-coin', 'primary'],
            ['Expected profit', formatCurrency($totals->profit), $totals->margin !== null ? $totals->margin . '% of the selling value' : 'nothing received', 'bi-graph-up-arrow', $totals->profit >= 0 ? 'success' : 'danger'],
            ['Units received', $qty($totals->quantity), number_format($totals->products) . ' ' . ($totals->products == 1 ? 'product' : 'products'), 'bi-box-seam', 'secondary'],
        ] as [$label, $value, $hint, $icon, $tone])
            <div class="col-6 col-xl-3">
                <div class="pr-card pr-stat h-100">
                    <span class="pr-icon bg-{{ $tone }}-subtle text-{{ $tone }}"><i class="bi {{ $icon }}"></i></span>
                    <div>
                        <div class="small text-muted">{{ $label }}</div>
                        <div class="fs-5 fw-bold text-{{ $tone === 'secondary' ? 'body' : $tone }}">{{ $value }}</div>
                        <div class="small text-muted">{{ $hint }}</div>
                    </div>
                </div>
            </div>
        @endforeach
    </div>

    @if($bySource->count() > 1 || $bySupplier->count() > 1)
        <div class="row g-3 mb-4">
            @if($bySource->count() > 1)
                <div class="col-lg-6">
                    <div class="pr-card h-100">
                        <h6 class="fw-bold mb-2">Where the stock came from</h6>
                        @foreach($bySource as $row)
                            @php $share = $totals->cost > 0 ? $row->cost / $totals->cost * 100 : 0; @endphp
                            <div class="mb-2">
                                <div class="d-flex justify-content-between small">
                                    <a href="{{ route('reports.purchases', ['source' => $row->source] + request()->except(['source', 'page'])) }}" class="text-decoration-none fw-semibold">{{ $sources[$row->source] ?? 'Purchase' }}</a>
                                    <span><strong>{{ formatCurrency($row->cost) }}</strong> <span class="text-muted">· sells for {{ formatCurrency($row->sales_value) }}</span></span>
                                </div>
                                <div class="progress" style="height: 6px;" role="presentation">
                                    <div class="progress-bar bg-{{ $sourceTone[$row->source] ?? 'primary' }}" style="width: {{ round($share, 1) }}%"></div>
                                </div>
                            </div>
                        @endforeach
                    </div>
                </div>
            @endif
            @if($bySupplier->count() > 1)
                <div class="col-lg-6">
                    <div class="pr-card h-100">
                        <h6 class="fw-bold mb-2">By supplier</h6>
                        <table class="table table-sm mb-0">
                            <tbody>
                            @foreach($bySupplier as $row)
                                <tr>
                                    <td>{{ $row->supplier ?? 'No supplier' }}</td>
                                    <td class="text-end text-muted small">{{ $qty($row->quantity) }} units</td>
                                    <td class="text-end fw-semibold">{{ formatCurrency($row->cost) }}</td>
                                </tr>
                            @endforeach
                            </tbody>
                        </table>
                    </div>
                </div>
            @endif
        </div>
    @endif

    <!-- Items -->
    <div class="pr-card p-0">
        @if($items->isEmpty())
            <div class="text-center text-muted py-5">
                <i class="bi bi-truck fs-1 d-block mb-2"></i>
                Nothing received {{ $periodText }}{{ $filtered ? ' matching the filters' : '' }}.
                @if($activePeriod !== 'all')
                    <div class="mt-2"><a href="{{ route('reports.purchases', ['period' => 'all'] + request()->except(['period', 'from', 'to', 'page'])) }}">Show all time</a></div>
                @endif
            </div>
        @else
            <div class="table-responsive">
                <table class="table table-hover align-middle mb-0">
                    <thead class="table-light small">
                        <tr>
                            <th>Date</th><th>Product</th><th>Source</th><th>Batch</th>
                            <th class="text-end">Qty</th><th class="text-end">Unit cost</th><th class="text-end">Cost</th><th class="text-end">Sells for</th><th>By</th>
                        </tr>
                    </thead>
                    <tbody>
                    @foreach($items as $item)
                        @php
                            $expiry = $item->expiry_date ?? $item->exp_date;
                            $source = $item->purchase?->source ?? 'purchase';
                        @endphp
                        <tr>
                            <td class="text-nowrap small">{{ $item->purchase?->purchase_date?->format('d M Y') }}</td>
                            <td>
                                @if($item->product)
                                    <a href="{{ route('products.show', $item->product) }}" class="text-decoration-none fw-semibold">{{ $item->product->name }}</a>
                                @else
                                    Deleted product
                                @endif
                                <div class="small text-muted">
                                    <a href="{{ route('purchases.show', $item->purchase_id) }}" class="text-muted">{{ $item->purchase?->reference_no }}</a>{{ $item->purchase?->supplier ? ' · ' . $item->purchase->supplier->name : '' }}
                                </div>
                            </td>
                            <td><span class="badge bg-{{ $sourceTone[$source] ?? 'primary' }}-subtle text-{{ $sourceTone[$source] ?? 'primary' }} border">{{ $sources[$source] ?? 'Purchase' }}</span></td>
                            <td class="small">{{ $item->batch_no ?? '-' }}@if($expiry)<div class="text-muted">exp {{ \Carbon\Carbon::parse($expiry)->format('d M Y') }}</div>@endif</td>
                            <td class="text-end">{{ $qty($item->quantity) }}</td>
                            <td class="text-end">{{ formatCurrency($item->unit_cost) }}</td>
                            <td class="text-end fw-semibold">{{ formatCurrency($item->line_total) }}</td>
                            <td class="text-end text-success">{{ formatCurrency((float) $item->quantity * (float) $item->selling_price) }}</td>
                            <td class="small text-muted">{{ $item->purchase?->user?->name ?? '-' }}</td>
                        </tr>
                    @endforeach
                    </tbody>
                    <tfoot class="table-light fw-bold">
                        <tr>
                            <td colspan="4">Total {{ $items->total() > $items->count() ? '(all pages)' : '' }}</td>
                            <td class="text-end">{{ $qty($totals->quantity) }}</td>
                            <td></td>
                            <td class="text-end">{{ formatCurrency($totals->cost) }}</td>
                            <td class="text-end text-success">{{ formatCurrency($totals->sales_value) }}</td>
                            <td></td>
                        </tr>
                    </tfoot>
                </table>
            </div>
            @if($items->hasPages())<div class="p-3">{{ $items->links() }}</div>@endif
        @endif
    </div>
</div>

<style>
    .pr-card { background: #fff; border-radius: 14px; box-shadow: 0 1px 3px rgba(15, 23, 42, .08); padding: 1rem 1.1rem; }
    .pr-periods { display: flex; flex-wrap: wrap; gap: .4rem; }
    .pr-stat { display: flex; gap: .8rem; align-items: flex-start; }
    .pr-icon { width: 42px; height: 42px; border-radius: 12px; display: grid; place-items: center; font-size: 1.2rem; flex-shrink: 0; }
</style>
@endsection