@php $i = 1; @endphp

@forelse ($transactions as $t)
    <tr>
        <td class="text-center">{{ $i++ }}</td>
        <td class="text-center">{{ \Illuminate\Support\Carbon::parse($t->txn_date)->format('Y-m-d') }}</td>
        <td class="text-center">{{ optional($t->branch)->branch_name ?? '-' }}</td>
        <td class="text-center">{{ $t->product->product_code ?? '' }}</td>
        <td class="text-center">{{ $t->product->name ?? '' }}</td>
        <td class="text-center text-capitalize">{{ $t->type }}</td>
        <td class="text-center">{{ numberformat($t->qty_change) }}</td>
        <td class="text-center">{{ numberformat($t->old_qty) }}</td>
        <td class="text-center">{{ numberformat($t->new_qty) }}</td>
        <td class="text-center">{{ $t->user->name ?? '' }}</td>
        <td class="text-center">{{ $t->purchase_price !== null ? numberformat($t->purchase_price) : '-' }}</td>
        <td class="text-center">{{ $t->sale_price !== null ? numberformat($t->sale_price) : '-' }}</td>
        <td class="text-center">{{ $t->note ?? '' }}</td>
    </tr>
@empty
    <tr>
        <td colspan="13" class="text-center">No transactions found for the selected filters.</td>
    </tr>
@endforelse