@php use Carbon\Carbon;
$sumTotalAmount = 0;
@endphp

@forelse ($invoices as $id => $invoice)
    @php
        $invoiceDate = $invoice->date ? Carbon::parse($invoice->date) : null;
        $totalAmount = optional($invoice->order)->total_amount ?? 0;
        $sumTotalAmount += $totalAmount;
        $latestPromise = $invoice->promises->sortByDesc('promise_date')->first();
    @endphp
    <tr data-id="{{ $invoice->id }}">
        <td>{{ $loop->iteration }}</td>
        <td><a href="{{ $invoice->order != NULL ? route('admin.order.campany-wise', $invoice->order->user_id) : '#' }}">{{ optional($invoice->order)->user->company ??  'N/A' }}</a></td>
        <td>{{$invoice->invoice_no}}</td>
        <td><a href="{{ route('admin.invoice.create', $invoice->order_id) }}">{{ $invoiceDate ? $invoiceDate->format('d-m-Y') : 'N/A' }}</a></td>
        
        <td>{{ $invoiceDate ? $invoiceDate->format('d-m-Y') : 'N/A' }}</td>
         <td class="text-end">{{ $totalAmount ? number_format($totalAmount, 2) : 'N/A' }}</td>
        <td>
            @if($invoice->promises->count() > 0)
                <button class="badge bg-primary view-promises-btn btn" data-invoice-id="{{ $invoice->id }}">{{ $invoice->promises->count() }} Promises</button>
                <br>
                <small>Latest:
                    {{ $latestPromise ? Carbon::parse($latestPromise->promise_date)->format('d M Y') : 'N/A' }}</small>
            @else
                <span class="text-muted">No Promises</span>
            @endif
        </td>
        <td>
            <span class="badge bg-{{ $invoice->order?->payment_status === 'paid' ? 'success' : 'warning' }}">
                {{ $invoice->order?->payment_status ?? 'N/A' }}
            </span>
        </td>
        <td>
            <button class="btn btn-outline-success btn-sm add-promise-btn" data-invoice-id="{{ $invoice->id }}"
                data-order-id="{{ $invoice->order_id }}"
                data-latest-promise="{{ $latestPromise ? Carbon::parse($latestPromise->promise_date)->format('Y-m-d') : '' }}">
                <i class="bi bi-plus-circle"></i>
            </button>
        </td>
    </tr>
@empty
    <tr>
        <td colspan="8" class="text-center py-4">
            <i class="fas fa-file-invoice fa-2x text-muted mb-2"></i>
            <p class="text-muted">No invoices found</p>
        </td>
    </tr>
@endforelse