@extends('layouts.main')
@section('content')
    <section class="content" style="width: 100%;overflow-x: scroll">
        <table class="table table-striped" id="myTable">
            <thead>
                <tr>
                    <th>SN</th>
                    <th scope="col">User</th>
                    <th scope="col">Amount</th>
                    <th>Provider</th>
                    <th scope="col">game code</th>
                    <th scope="col">Balance Before</th>
                    <th scope="col">Balance After</th>
                </tr>
            </thead>
            <tbody>
                @foreach ($transactions as $transaction)
                    <tr>
                        <th scope="row">{{ $loop->iteration }}</th>
                        <th>{{ \App\Models\User::find($transaction->user_id)->username }}</th>
                        <td>{{ $transaction->amount }}</td>
                        <td>{{ \App\Models\Game::where('game_code', $transaction->game_code)->first()->provider ?? 'NA' }}</td>
                        <td>{{ \App\Models\Game::where('game_code', $transaction->game_code)->first()->game_name ?? 'NA' }}</td>
                        <td>{{ $transaction->balance_before }}</td>
                        <td>{{ $transaction->balance_after }}</td>
                    </tr>
                @endforeach
            </tbody>
        </table>
    </section>
@endsection