@if($insights['grn_yearly']->isNotEmpty())
    <x-chm.form-section title="Deliveries by year" icon="bx bx-bar-chart-alt" class="mb-4" :collapsible="false">
        <div class="table-responsive">
            <table class="table table-sm align-middle mb-0">
                <thead><tr><th>Year</th><th>Deliveries</th><th>FAQ (kg)</th></tr></thead>
                <tbody>
                    @foreach($insights['grn_yearly'] as $row)
                        <tr>
                            <td>{{ $row->year }}</td>
                            <td>{{ number_format($row->deliveries) }}</td>
                            <td>{{ number_format($row->faq_kg ?? 0, 1) }}</td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        </div>
    </x-chm.form-section>
@endif

<x-chm.form-section title="Recent GRN / cherry deliveries" icon="bx bx-package" :collapsible="false">
    @if(Route::has('add.grn.form'))
        <p class="small mb-3"><a href="{{ $farmerLinks['add_grn'] }}">Add new GRN for this farmer →</a></p>
    @endif
    @if($insights['grns']->isEmpty())
        <p class="text-muted mb-0">No GRN records for this farmer yet.</p>
    @else
        <div class="table-responsive">
            <table class="table table-hover align-middle mb-0">
                <thead class="table-light">
                    <tr>
                        <th>GRN #</th>
                        <th>Date</th>
                        <th>Type</th>
                        <th>Bags</th>
                        <th>FAQ</th>
                        <th>Ungraded</th>
                        <th>Kiboko</th>
                        <th>MC</th>
                        <th>Out turn</th>
                        <th>Remarks</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($insights['grns'] as $grn)
                        <tr>
                            <td class="fw-semibold">
                                @if(Route::has('grn.preview'))
                                    <a href="{{ route('grn.preview', $grn->id) }}">{{ $grn->id }}</a>
                                @else
                                    {{ $grn->id }}
                                @endif
                                @if(Route::has('edit.grn.form'))
                                    <a href="{{ route('edit.grn.form', $grn->id) }}" class="text-muted small ms-1" title="Edit GRN"><i class="bx bx-edit"></i></a>
                                @endif
                            </td>
                            <td class="text-nowrap">{{ $grn->date_recorded ? \Carbon\Carbon::parse($grn->date_recorded)->format('M j, Y') : '—' }}</td>
                            <td>{{ $grn->coffee_type ?: '—' }}</td>
                            <td>{{ $grn->bags ?: '—' }}</td>
                            <td>{{ $grn->faq ?: '0' }}</td>
                            <td>{{ $grn->ungraded ?: '0' }}</td>
                            <td>{{ $grn->kiboko ?: '0' }}</td>
                            <td>{{ $grn->moisture_content ?: '—' }}</td>
                            <td>{{ $grn->out_turn ? (int) $grn->out_turn.'%' : '—' }}</td>
                            <td class="text-muted small">{{ $grn->quality_remarks ?: '—' }}</td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        </div>
    @endif
</x-chm.form-section>

@if($insights['coffee_purchases']->isNotEmpty())
    <x-chm.form-section title="Coffee purchases (accounting)" icon="bx bx-purchase-tag" class="mt-4" :collapsible="false">
        <div class="table-responsive">
            <table class="table table-sm align-middle mb-0">
                <thead><tr><th>Date</th><th>Reference</th><th>Weight</th><th>Price/unit</th><th>Notes</th></tr></thead>
                <tbody>
                    @foreach($insights['coffee_purchases'] as $purchase)
                        <tr>
                            <td class="text-nowrap">{{ $purchase->purchase_date?->format('M j, Y') ?? '—' }}</td>
                            <td>
                                @if(Route::has('coffee.purchases.show'))
                                    <a href="{{ route('coffee.purchases.show', $purchase->id) }}">{{ $purchase->reference ?: '#'.$purchase->id }}</a>
                                @else
                                    {{ $purchase->reference ?: '#'.$purchase->id }}
                                @endif
                            </td>
                            <td>{{ number_format($purchase->weight ?? 0, 1) }}</td>
                            <td>{{ number_format($purchase->price_per_unit ?? 0) }}</td>
                            <td class="text-muted small">{{ \Illuminate\Support\Str::limit($purchase->notes ?? '—', 40) }}</td>
                        </tr>
                    @endforeach
                </tbody>
            </table>
        </div>
    </x-chm.form-section>
@endif