@extends('layouts.app')

@section('title', 'Reports')

@section('content')
<x-breadcrumb :items="[['label' => 'Reports']]" />

<x-page-header title="Procurement Reports" subtitle="Spend, PO, invoice and waste analytics." />

<div class="procure-filters">
    <form method="GET" action="{{ route('reports.index') }}" class="row align-items-end">
        <div class="col-md-3 mb-2">
            <label class="small text-muted">Report Type</label>
            <select name="type" class="form-control form-control-sm" style="border-radius:8px;">
                <option value="spend_by_supplier" @selected(($type ?? '') === 'spend_by_supplier')>Spend by Supplier</option>
                <option value="spend_by_category" @selected(($type ?? '') === 'spend_by_category')>Spend by Category</option>
                <option value="purchase_orders" @selected(($type ?? '') === 'purchase_orders')>Purchase Orders</option>
                <option value="invoices" @selected(($type ?? '') === 'invoices')>Invoices</option>
                <option value="waste" @selected(($type ?? '') === 'waste')>Waste Events</option>
            </select>
        </div>
        <div class="col-md-3 mb-2">
            <label class="small text-muted">From</label>
            <input type="date" name="date_from" class="form-control form-control-sm" value="{{ $dateFrom ?? '' }}" style="border-radius:8px;">
        </div>
        <div class="col-md-3 mb-2">
            <label class="small text-muted">To</label>
            <input type="date" name="date_to" class="form-control form-control-sm" value="{{ $dateTo ?? '' }}" style="border-radius:8px;">
        </div>
        <div class="col-md-3 mb-2">
            <button type="submit" class="procure-btn w-100"><i class="fas fa-chart-bar"></i> Run Report</button>
        </div>
    </form>
</div>

<div class="chart-card">
    <div class="chart-card-header">
        <h3 class="chart-card-title">{{ $report['title'] ?? 'Report' }}</h3>
        <span class="text-muted small">{{ $dateFrom ?? '' }} → {{ $dateTo ?? '' }}</span>
    </div>
    <div class="chart-card-body" style="overflow-x:auto;">
        @php $rows = $report['rows'] ?? collect(); @endphp

        @if($rows->isEmpty())
            <x-empty-state icon="fas fa-chart-bar" title="No data" message="No records found for the selected filters." />
        @elseif(($type ?? '') === 'spend_by_supplier')
            <table class="procure-table">
                <thead>
                    <tr>
                        <th>Supplier</th>
                        <th>PO Count</th>
                        <th>Total Spend</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($rows as $row)
                        <tr>
                            <td>{{ $row->supplier->name ?? '—' }}</td>
                            <td>{{ $row->po_count }}</td>
                            <td><strong>{{ number_format($row->total, 2) }}</strong></td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        @elseif(($type ?? '') === 'spend_by_category')
            <table class="procure-table">
                <thead>
                    <tr>
                        <th>Category</th>
                        <th>Total Spend</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($rows as $row)
                        <tr>
                            <td>{{ $row->category ?: 'Uncategorized' }}</td>
                            <td><strong>{{ number_format($row->total, 2) }}</strong></td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        @elseif(($type ?? '') === 'purchase_orders')
            <table class="procure-table">
                <thead>
                    <tr>
                        <th>PO Number</th>
                        <th>Supplier</th>
                        <th>Date</th>
                        <th>Amount</th>
                        <th>Status</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($rows as $po)
                        <tr>
                            <td><a href="{{ route('purchase-orders.show', $po) }}">{{ $po->po_number }}</a></td>
                            <td>{{ $po->supplier->name ?? '—' }}</td>
                            <td>{{ optional($po->order_date)->format('Y-m-d') }}</td>
                            <td>{{ number_format($po->total_amount, 2) }} {{ $po->currency }}</td>
                            <td><x-status-badge :status="$po->status" /></td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        @elseif(($type ?? '') === 'invoices')
            <table class="procure-table">
                <thead>
                    <tr>
                        <th>Invoice #</th>
                        <th>Supplier</th>
                        <th>Date</th>
                        <th>Amount</th>
                        <th>Status</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($rows as $inv)
                        <tr>
                            <td><a href="{{ route('invoices.show', $inv) }}">{{ $inv->invoice_number }}</a></td>
                            <td>{{ $inv->supplier->name ?? '—' }}</td>
                            <td>{{ optional($inv->invoice_date)->format('Y-m-d') }}</td>
                            <td>{{ number_format($inv->total_amount, 2) }} {{ $inv->currency }}</td>
                            <td><x-status-badge :status="$inv->status" /></td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        @else
            <table class="procure-table">
                <thead>
                    <tr>
                        <th>Item</th>
                        <th>Qty Wasted</th>
                        <th>Est. Value</th>
                        <th>Reason</th>
                        <th>Disposed At</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($rows as $waste)
                        <tr>
                            <td>{{ $waste->item->name_en ?? '—' }}</td>
                            <td>{{ $waste->quantity_wasted }}</td>
                            <td>{{ number_format($waste->estimated_value ?? 0, 2) }}</td>
                            <td>{{ $waste->reason ?? '—' }}</td>
                            <td>{{ optional($waste->disposed_at)->format('Y-m-d') }}</td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        @endif
    </div>
</div>
@endsection