@extends('layouts.master')
@section('title') Reports @endsection
@section('content')
@component('components.breadcrumb')
@slot('li_1') Management @endslot
@slot('title') Management Reports @endslot
@endcomponent

{{-- Filters --}}
<div class="card">
    <div class="card-body">
        <form method="GET" class="row g-2 align-items-end">
            <div class="col-sm-3">
                <label class="form-label mb-1">From</label>
                <input type="date" name="from" class="form-control" value="{{ $from }}">
            </div>
            <div class="col-sm-3">
                <label class="form-label mb-1">To</label>
                <input type="date" name="to" class="form-control" value="{{ $to }}">
            </div>
            <div class="col-sm-3">
                <label class="form-label mb-1">Group by</label>
                <select name="period" class="form-select">
                    <option value="day" @selected($period==='day')>Day</option>
                    <option value="month" @selected($period==='month')>Month</option>
                    <option value="year" @selected($period==='year')>Year</option>
                </select>
            </div>
            <div class="col-sm-3">
                <button class="btn btn-primary w-100"><i class="ri-filter-3-line align-bottom me-1"></i> Apply</button>
            </div>
        </form>
    </div>
</div>

{{-- KPIs --}}
<div class="row">
    @php
        $cards = [
            ['l'=>'Requisitions','v'=>number_format($kpis['total']),'i'=>'ri-file-list-3-line','b'=>'primary'],
            ['l'=>'Total Value (JMD)','v'=>number_format($kpis['value'],2),'i'=>'ri-money-dollar-circle-line','b'=>'success'],
            ['l'=>'Completion','v'=>$kpis['completion'].'%','i'=>'ri-checkbox-circle-line','b'=>'info'],
            ['l'=>'SLA On-Time','v'=>$kpis['sla_on_time'].'%','i'=>'ri-timer-flash-line','b'=>$kpis['sla_on_time']>=80?'success':'warning'],
            ['l'=>'Avg Cycle (days)','v'=>$kpis['avg_cycle'],'i'=>'ri-loader-2-line','b'=>'secondary'],
            ['l'=>'In Progress','v'=>number_format($kpis['in_progress']),'i'=>'ri-time-line','b'=>'warning'],
            ['l'=>'Satisfaction','v'=>$kpis['satisfaction'].'%','i'=>'ri-emotion-happy-line','b'=>'success'],
            ['l'=>'Cancelled','v'=>number_format($kpis['cancelled']),'i'=>'ri-close-circle-line','b'=>'danger'],
        ];
    @endphp
    @foreach($cards as $c)
    <div class="col-xl-3 col-md-6">
        <div class="card card-animate">
            <div class="card-body">
                <p class="text-uppercase fw-medium text-muted mb-3">{{ $c['l'] }}</p>
                <div class="d-flex align-items-end justify-content-between">
                    <h4 class="fs-22 fw-semibold mb-0">{{ $c['v'] }}</h4>
                    <div class="avatar-sm"><span class="avatar-title bg-{{ $c['b'] }}-subtle rounded fs-3"><i class="{{ $c['i'] }} text-{{ $c['b'] }}"></i></span></div>
                </div>
            </div>
        </div>
    </div>
    @endforeach
</div>

{{-- Totals by period --}}
<div class="card">
    <div class="card-header"><h5 class="card-title mb-0">Totals by {{ ucfirst($period) }}</h5></div>
    <div class="card-body">
        @php $maxVal = $byPeriod->max('value') ?: 1; @endphp
        <div class="table-responsive">
            <table class="table table-sm align-middle mb-0">
                <thead class="table-light"><tr><th>Period</th><th class="text-end">Requisitions</th><th class="text-end">Value (JMD)</th><th style="width:40%">Trend</th></tr></thead>
                <tbody>
                    @forelse($byPeriod as $p)
                    <tr>
                        <td class="fw-medium">{{ $p->period }}</td>
                        <td class="text-end">{{ number_format($p->count) }}</td>
                        <td class="text-end">{{ number_format($p->value,2) }}</td>
                        <td><div class="progress" style="height:8px"><div class="progress-bar bg-primary" style="width:{{ round(($p->value/$maxVal)*100) }}%"></div></div></td>
                    </tr>
                    @empty
                    <tr><td colspan="4" class="text-center text-muted py-3">No data in range.</td></tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>
</div>

<div class="row">
    {{-- Product details --}}
    <div class="col-xl-7">
        <div class="card">
            <div class="card-header"><h5 class="card-title mb-0">Top Products / Items</h5></div>
            <div class="card-body">
                <div class="table-responsive">
                    <table class="table table-hover table-sm align-middle mb-0">
                        <thead class="table-light"><tr><th>Product</th><th class="text-end">Reqs</th><th class="text-end">Qty</th><th class="text-end">Value (JMD)</th></tr></thead>
                        <tbody>
                            @forelse($products as $p)
                            <tr>
                                <td class="fw-medium">{{ $p->product ?? '—' }}</td>
                                <td class="text-end">{{ number_format($p->requisitions) }}</td>
                                <td class="text-end">{{ rtrim(rtrim(number_format($p->qty,2),'0'),'.') }}</td>
                                <td class="text-end">{{ number_format($p->value,2) }}</td>
                            </tr>
                            @empty
                            <tr><td colspan="4" class="text-center text-muted py-3">No product data.</td></tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>

    {{-- By status + suppliers --}}
    <div class="col-xl-5">
        <div class="card">
            <div class="card-header"><h5 class="card-title mb-0">By Status</h5></div>
            <div class="card-body">
                @forelse($byStatus as $status => $count)
                <div class="d-flex justify-content-between border-bottom py-1"><span>{{ ucwords(str_replace('_',' ',$status)) }}</span><span class="badge bg-light text-body">{{ $count }}</span></div>
                @empty<p class="text-muted mb-0">No data.</p>@endforelse
            </div>
        </div>
        <div class="card">
            <div class="card-header"><h5 class="card-title mb-0">Spend by Supplier (POs)</h5></div>
            <div class="card-body">
                <div class="table-responsive">
                    <table class="table table-sm align-middle mb-0">
                        <thead class="table-light"><tr><th>Supplier</th><th class="text-end">POs</th><th class="text-end">Value</th></tr></thead>
                        <tbody>
                            @forelse($bySupplier as $s)
                            <tr><td>{{ $s->name }}</td><td class="text-end">{{ $s->orders }}</td><td class="text-end">{{ number_format($s->value,2) }}</td></tr>
                            @empty<tr><td colspan="3" class="text-center text-muted py-3">No PO spend in range.</td></tr>@endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>

<div class="row">
    <div class="col-xl-7">
        <div class="card">
            <div class="card-header d-flex align-items-center">
                <h5 class="card-title mb-0 flex-grow-1">Budget Utilisation</h5>
                <span class="badge bg-light text-muted">{{ $fiscalYear }}</span>
            </div>
            <div class="card-body">
                <div class="table-responsive">
                    <table class="table table-sm align-middle mb-0">
                        <thead class="table-light"><tr><th>Cost Centre</th><th class="text-end">Allocation</th><th class="text-end">Committed</th><th class="text-end">Spent</th><th class="text-end">Balance</th><th style="width:110px">Util.</th></tr></thead>
                        <tbody>
                            @forelse($budgets as $b)
                            <tr>
                                <td><span class="fw-medium">{{ $b['code'] }}</span> <small class="text-muted">{{ $b['name'] }}</small></td>
                                <td class="text-end">{{ number_format($b['allocation'],2) }}</td>
                                <td class="text-end text-muted">{{ number_format($b['committed'],2) }}</td>
                                <td class="text-end text-muted">{{ number_format($b['spent'],2) }}</td>
                                <td class="text-end fw-medium {{ $b['balance'] < 0 ? 'text-danger' : '' }}">{{ number_format($b['balance'],2) }}</td>
                                <td>
                                    <div class="progress" style="height:14px" title="{{ $b['util'] }}%">
                                        <div class="progress-bar bg-{{ $b['util'] > 100 ? 'danger' : ($b['util'] > 85 ? 'warning' : 'success') }}" style="width: {{ min($b['util'],100) }}%">{{ $b['util'] }}%</div>
                                    </div>
                                </td>
                            </tr>
                            @empty<tr><td colspan="6" class="text-center text-muted py-3">No budgets set for {{ $fiscalYear }}.</td></tr>@endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
    <div class="col-xl-5">
        <div class="card">
            <div class="card-header"><h5 class="card-title mb-0">Rejections / Returns by Reason</h5></div>
            <div class="card-body">
                <div class="table-responsive">
                    <table class="table table-sm align-middle mb-0">
                        <thead class="table-light"><tr><th>Code</th><th>Reason</th><th class="text-end">Count</th></tr></thead>
                        <tbody>
                            @forelse($byReason as $r)
                            <tr><td><span class="badge bg-danger-subtle text-danger">{{ $r->code }}</span></td><td><small>{{ $r->label }}</small></td><td class="text-end">{{ $r->total }}</td></tr>
                            @empty<tr><td colspan="3" class="text-center text-muted py-3">No coded rejections in range.</td></tr>@endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
        <div class="card">
            <div class="card-header"><h5 class="card-title mb-0">Spend by Area (POs)</h5></div>
            <div class="card-body">
                <div class="table-responsive">
                    <table class="table table-sm align-middle mb-0">
                        <thead class="table-light"><tr><th>Area</th><th class="text-end">POs</th><th class="text-end">Value</th></tr></thead>
                        <tbody>
                            @forelse($byArea as $a)
                            <tr><td>{{ $a->name }}</td><td class="text-end">{{ $a->orders }}</td><td class="text-end">{{ number_format($a->value,2) }}</td></tr>
                            @empty<tr><td colspan="3" class="text-center text-muted py-3">No PO spend in range.</td></tr>@endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>

<div class="row">
    <div class="col-xl-4">
        <div class="card">
            <div class="card-header"><h5 class="card-title mb-0">Invoice Aging (unpaid)</h5></div>
            <div class="card-body">
                <div class="table-responsive">
                    <table class="table table-sm align-middle mb-0">
                        <thead class="table-light"><tr><th>Age (days)</th><th class="text-end">Count</th><th class="text-end">Value</th></tr></thead>
                        <tbody>
                            @foreach($agingBuckets as $bucket => $value)
                            <tr>
                                <td><span class="badge bg-{{ $bucket==='0-30'?'success':($bucket==='31-60'?'info':($bucket==='61-90'?'warning':'danger')) }}-subtle text-{{ $bucket==='0-30'?'success':($bucket==='31-60'?'info':($bucket==='61-90'?'warning':'danger')) }}">{{ $bucket }}</span></td>
                                <td class="text-end">{{ $agingCounts[$bucket] }}</td>
                                <td class="text-end">{{ number_format($value,2) }}</td>
                            </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
    <div class="col-xl-8">
        <div class="card">
            <div class="card-header"><h5 class="card-title mb-0">Outstanding Purchase Orders</h5></div>
            <div class="card-body">
                <div class="table-responsive">
                    <table class="table table-sm align-middle mb-0">
                        <thead class="table-light"><tr><th>PO</th><th>Supplier</th><th>Issued</th><th>Status</th><th class="text-end">Value</th></tr></thead>
                        <tbody>
                            @forelse($outstandingPos as $po)
                            <tr>
                                <td class="fw-medium">{{ $po->po_number }}</td>
                                <td><small>{{ $po->supplier?->name }}</small></td>
                                <td><small>{{ optional($po->issue_date)->format('d M Y') }}</small></td>
                                <td><span class="badge bg-secondary-subtle text-secondary">{{ ucwords(str_replace('_',' ',$po->status)) }}</span></td>
                                <td class="text-end">{{ number_format($po->total,2) }}</td>
                            </tr>
                            @empty<tr><td colspan="5" class="text-center text-muted py-3">No outstanding POs.</td></tr>@endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>

<div class="row">
    <div class="col-12">
        <div class="card">
            <div class="card-header d-flex align-items-center">
                <h5 class="card-title mb-0 flex-grow-1">Pending / Overdue Deliveries</h5>
                <span class="badge bg-danger-subtle text-danger">{{ $pendingDelivery->count() }} overdue</span>
            </div>
            <div class="card-body">
                <div class="table-responsive">
                    <table class="table table-sm align-middle mb-0">
                        <thead class="table-light"><tr><th>PO</th><th>Supplier</th><th>Expected</th><th class="text-end">Days Late</th><th>Status</th><th class="text-end">Value</th></tr></thead>
                        <tbody>
                            @forelse($pendingDelivery as $po)
                            @php $late = (int) \Illuminate\Support\Carbon::parse($po->expected_delivery_date)->diffInDays(now()); @endphp
                            <tr>
                                <td class="fw-medium">{{ $po->po_number }}</td>
                                <td><small>{{ $po->supplier?->name }}</small></td>
                                <td><small>{{ \Illuminate\Support\Carbon::parse($po->expected_delivery_date)->format('d M Y') }}</small></td>
                                <td class="text-end"><span class="badge bg-danger">{{ $late }}d</span></td>
                                <td><span class="badge bg-secondary-subtle text-secondary">{{ ucwords(str_replace('_',' ',$po->status)) }}</span></td>
                                <td class="text-end">{{ number_format($po->total,2) }}</td>
                            </tr>
                            @empty<tr><td colspan="6" class="text-center text-muted py-3">No overdue deliveries. 🎉</td></tr>@endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection