@php
    use App\Models\DigitalAsset;
    use App\Models\PLGame;
    use App\Models\PLOther;
    use App\Models\UserWallet;
    use Illuminate\Support\Facades\Log;

    $wallets = UserWallet::with('digitalAsset')
                ->where('user_id', $adminUser->id)
                ->where('quantity', '>', 0)
                ->whereHas('digitalAsset')
                ->get();
    $externals = PLGame::select('id', 'name')->get();
    $others = PLOther::select('id', 'name')->get();
@endphp

<div class="tab-pane fade show active" id="tab-profit" role="tabpanel">
    <table id="pl-list" class="table table-bordered dt-responsive nowrap table-striped align-middle" style="width:100%">
        <thead>
        <tr>
            <th class="text-center">Id</th>
            <th class="text-center">Date</th>
            <th class="text-center">Name</th>
            <th class="text-center">Cash</th>            
            @foreach ($wallets as $item)
            <th class="text-center">{{ $item->digitalAsset->name }}</th>
            @endforeach
            @foreach ($externals as $item)
            <th class="text-center">{{ $item->name }}</th>
            @endforeach
            <th class="text-center">Ex.Total</th>
            @foreach ($others as $item)
            <th class="text-center">{{ $item->name }}</th>
            @endforeach
        </tr>
        </thead>
        <tbody>
        </tbody>
    </table>
</div>

<script>
    let wallets = @json($wallets ?? []);
    let externals = @json($externals ?? []);
    let others = @json($others ?? []);
    let adminID = {{ $adminUser->id }}
    let columns = [
        {data: 'id', name: 'id'},
        {data: 'date', name: 'date'},
        {data: 'name', name: 'name'},
        {data: 'cash', name: 'cash'},
    ];
    $(document).ready(function () {
        var csrfToken = $('meta[name="csrf_token"]').attr('content');
        for (let item of wallets) {
            columns.push({data: item.digital_asset.name, name: item.digital_asset.name})
        }

        for (let item of externals) {
            columns.push({data: item.name, name: item.name})
        }

        columns.push({data: 'ex.total', name: 'ex.total'})

        for (let item of others) {
            columns.push({data: item.name, name: item.name})
        }
        
        var table = $('#pl-list').DataTable({
            processing: true,
            serverSide: true,            
            searching: false,
            ajax: {
                url: '{{ route("profitandlosslist.get") }}',
                type: 'POST',
                headers: { 'X-CSRF-TOKEN': csrfToken },
                data: function (d) {
                    d.adminID = adminID
                }
            },
            columns,
            order: [[0, 'desc']],
        });
    })    
</script>