@extends('layouts.app')
@section('title', 'Reports')
@section('page_title', 'Procurement Reports')
@section('content')
<div class="grid grid-4">
    <div class="card stat"><div class="num">{{ $totalRequests }}</div><div class="label">Total Requests</div></div>
    <div class="card stat"><div class="num">C${{ number_format($requestValue,0) }}</div><div class="label">Estimated Request Value</div></div>
    <div class="card stat"><div class="num">C${{ number_format($poValue,0) }}</div><div class="label">PO Value</div></div>
    <div class="card stat"><div class="num">C${{ number_format($paidValue,0) }}</div><div class="label">Paid Value</div></div>
</div>
<div class="grid grid-3">
    <div class="card">
        <h3>Requests by Status</h3>
        <table><thead><tr><th>Status</th><th>Total</th></tr></thead><tbody>@foreach($requestsByStatus as $row)<tr><td><span class="badge {{ $statusClass($row->status) }}">{{ str_replace('_',' ', $row->status) }}</span></td><td>{{ $row->total }}</td></tr>@endforeach</tbody></table>
    </div>
    <div class="card">
        <h3>Purchase Orders by Status</h3>
        <table><thead><tr><th>Status</th><th>Total</th></tr></thead><tbody>@foreach($ordersByStatus as $row)<tr><td><span class="badge {{ $statusClass($row->status) }}">{{ str_replace('_',' ', $row->status) }}</span></td><td>{{ $row->total }}</td></tr>@endforeach</tbody></table>
    </div>
    <div class="card">
        <h3>Top Suppliers</h3>
        <table><thead><tr><th>Supplier</th><th>PO Value</th></tr></thead><tbody>@foreach($topSuppliers as $supplier)<tr><td>{{ $supplier->company_name }}</td><td>C${{ number_format($supplier->total_purchase_orders_value ?? 0,2) }}</td></tr>@endforeach</tbody></table>
    </div>
</div>
@endsection