{{-- Phase 3e: Retrievals with Reason Code + Response Due Date --}}
<div class="project-box p-3 mb-3">
    <h6 class="mb-3 fw-semibold">Retrievals</h6>
    <div class="table-responsive project-table">
        <table class="table table-bordered mb-0">
            <thead>
            <tr>
                <th>Retrieval Date</th>
                <th>Transaction Date</th>
                <th>Cardholder Name</th>
                <th>Amount</th>
                <th>Reason Code</th>
                <th>Response Due Date</th>
                <th>Currency</th>
                <th>Reference #</th>
                <th>Status</th>
            </tr>
            </thead>
            <tbody>
            @forelse($retrievals as $row)
                @php
                    $dueDate = $row->response_due_date ? \Carbon\Carbon::parse($row->response_due_date) : null;
                    $dueSoon = $dueDate && $dueDate->isFuture() && $dueDate->diffInDays(now()) <= 3;
                    $overdue = $dueDate && $dueDate->isPast();
                @endphp
                <tr>
                    <td>{{ $row->retrieval_date ? \App\Helpers\Helper::showdate($row->retrieval_date, false) : '—' }}</td>
                    <td>{{ $row->transaction_date ? \App\Helpers\Helper::showdate($row->transaction_date, false) : '—' }}</td>
                    <td>{{ $row->cardholder_name ?? '—' }}</td>
                    <td>${{ number_format($row->amount ?? 0, 2) }}</td>
                    <td>{{ $row->reason_code ?? '—' }}</td>
                    <td>
                        @if($dueDate)
                            <span class="@if($overdue) text-danger fw-semibold @elseif($dueSoon) text-warning fw-semibold @endif">
                                {{ $dueDate->format('m/d/Y') }}
                                @if($overdue) <i class="bx bx-error-circle ms-1" title="Overdue"></i>
                                @elseif($dueSoon) <i class="bx bx-time ms-1 text-warning" title="Due soon"></i>
                                @endif
                            </span>
                        @else
                            —
                        @endif
                    </td>
                    <td>{{ $row->currency_code ?? '—' }}</td>
                    <td>{{ $row->transaction_id ?? '—' }}</td>
                    <td>
                        @php($status = $row->retrieval_status_text ?? 'Open')
                        @if($status === 'Responded')
                            <span class="badge bg-success">{{ $status }}</span>
                        @elseif($status === 'Expired')
                            <span class="badge bg-danger">{{ $status }}</span>
                        @else
                            <span class="badge bg-warning text-dark">{{ $status }}</span>
                        @endif
                    </td>
                </tr>
            @empty
                <tr><td colspan="9" class="text-center py-4">There are no results in this table.</td></tr>
            @endforelse
            </tbody>
        </table>
    </div>
</div>