@if (isset($second_range))
    <div class="col-8 offset-2 text-center mt-5">
        <h3 class="mt-5"><i class="fas fa-calendar-alt"></i> {{ $date_range }}</h3>
    </div>
@endif

<style>
    .bg-subtotal {
        background: #d2e9fd !important
    }
</style>

@if (count($subtotals) > 0)

    <div class="col-12 border-top mt-5 mb-3 border-bottom">
        <ul class="nav nav-pills mb-3 mt-3" id="pills-tab" role="tablist">
            @if ($subtotals->groupBy('currency_name')->count() > 1)
                <li class="nav-item">
                    <a class="nav-link active" id="grand-total-tab" data-toggle="pill"
                        href="#{{ $table_to_export }}-grand-total" role="tab" aria-controls="grand-total"
                        aria-selected="true">Grand total</a>
                </li>
            @endif
            @foreach ($subtotals->groupBy('currency_name') as $currencyName => $data)
                <li class="nav-item">
                    <a class="nav-link {{ $subtotals->groupBy('currency_name')->count() <= 1 ? 'active' : '' }}" id="{{ $currencyName }}-tab"
                        data-toggle="pill" href="#{{ $table_to_export }}-{{ $currencyName }}" role="tab"
                        aria-controls="{{ $currencyName }}" aria-selected="true">{{ $currencyName }}</a>
                </li>
            @endforeach
        </ul>
    </div>




    <div class="col-12">
        <div class="tab-content" id="pills-tabContent">

            @if ($group_by == 'perGame')
                @include('partial.tables.financial.games-report.grand-total-per-game')
            @else
                @include('partial.tables.financial.games-report.grand-total-per-skin')
            @endif

            @foreach ($subtotals->groupBy('currency_name') as $currencyName => $data)
                <div class="tab-pane fade show {{ count($subtotals) <= 1 ? 'active' : '' }} "
                    id="{{ $table_to_export }}-{{ $currencyName }}" role="tabpanel"
                    aria-labelledby="{{ $currencyName }}-tab">

                    <table class="table table-striped responsive js-data-table w-100"
                        id="casino-games-report-{{ $table_to_export }}-{{ $currencyName }}" width="100%">

                        <thead>
                            <tr>
                                @if ($group_by == 'perGame')
                                    <th>{{ __('Game name') }}</th>
                                @endif
                                <th>
                                    <a href="#">{{ __('Partner Name') }}</a>
                                </th>

                                <th>
                                    <a href="#">{{ __('Skin') }}</a>
                                </th>

                                <th>
                                    <a href="#">{{ __('Provider') }}</a>
                                </th>

                                @if ($group_by == 'perSkin')
                                    <th>{{ __('Game name') }}</th>
                                @endif
                                <th>{{ __('Slot') }}</th>

                                <th>{{ __('Device') }}</th>
                                <th>{{ __('Currency') }}</th>
                                <th>
                                    <a href="#">{{ __('Total players') }}</a>
                                </th>

                                <th>
                                    <a href="#">{{ __('Rounds') }}</a>
                                </th>

                                <th>
                                    <a href="#">{{ __('Bet') }}</a>
                                </th>

                                <th>
                                    <a href="#">{{ __('Win') }}</a>
                                </th>

                                <th>
                                    <a href="#">{{ __('Avg Bet') }}</a>
                                </th>

                                <th>
                                    <a href="#">{{ __('Bonus BET') }}</a>
                                </th>

                                <th>
                                    <a href="#">{{ __('Bonus WIN') }}</a>
                                </th>

                                <th>
                                    <a href="#">{{ __('Bonus Cost') }}</a>
                                </th>

                                <th>
                                    <a href="#">{{ __('GGR') }}</a>
                                </th>

                                @if (getenv('APP_MARKET') == 'it')
                                    <th>
                                        <a href="#">{{ __('Bingo Fee') }}</a>
                                    </th>
                                @endif

                                <th>{{ __('RTP') }}</th>

                                <th>{{ __('Category') }}</th>

                                @if ($break_by)
                                    <th>
                                        {{ strtoupper($break_by) }}
                                    </th>
                                @endif
                            </tr>
                        </thead>
                        <tbody>

                            @foreach ($data as $d)
                                <tr>
                                    @if ($group_by == 'perGame')
                                        <td>{{ $d['game_name'] }}</td>
                                    @endif

                                    @if ($group_by == 'perSkin')
                                        <td>{{ !empty($d['partner_name']) ? $d['partner_name'] : '' }}</td>
                                        <td>{{ !empty($d['skin_name']) ? $d['skin_name'] : '' }}</td>
                                    @else
                                        <td>
                                            @if (count($d['partner_count']) > 0)
                                                <span
                                                    title='{{ $d['partner_name'] }}'>{{ count($d['partner_count']) }}
                                                    {{ count($d['partner_count']) <= 1 ? 'Partner' : 'Partners' }}
                                                </span>
                                            @else
                                                {{ !empty($d['partner_name']) ? $d['partner_name'] : '' }}
                                            @endif
                                        </td>
                                        <td>
                                            @if (count($d['skin_count']) > 0)
                                                <span title='{{ $d['skin_name'] }}'>{{ count($d['skin_count']) }}
                                                    {{ count($d['skin_count']) <= 1 ? 'Skin' : 'Skins' }}
                                                </span>
                                            @else
                                                {{ !empty($d['skin_name']) ? $d['skin_name'] : '' }}
                                            @endif
                                        </td>
                                    @endif
                                    <td>{{ $d['provider_name'] }}</td>

                                    @if ($group_by == 'perSkin')
                                        <td>{{ $d['game_name'] }}</td>
                                    @endif
                                    <td>
                                        @if ($d['is_slot'] == 1)
                                            <h4>&check;</h4>
                                        @endif
                                    </td>
                                    <td>{{ $d['device'] }}</td>

                                    <td>{{ $d['currency_name'] }}</td>

                                    <td>{{ $d['total_players'] }}</td>

                                    <td>{{ $d['total_rounds'] }}</td>

                                    <td>{!! GetMoneyStr3($d['total_bet'], true, $d['currency_id'], true) !!}</td>

                                    <td>{!! GetMoneyStr3($d['total_win'], true, $d['currency_id'], true) !!}</td>

                                    <td>
                                        {!! GetMoneyStr3($d['avg_bet'], true, $d['currency_id'], true) !!}
                                    </td>

                                    <td>{!! GetMoneyStr3($d['bonus'], true, $d['currency_id'], true) !!}</td>

                                    <td>{!! GetMoneyStr3($d['bonus_win'], true, $d['currency_id'], true) !!}</td>

                                    <td>{!! GetMoneyStr3($d['bonus_cost'], true, $d['currency_id'], true) !!}</td>

                                    <td>{!! GetMoneyStr3($d['GGR'], true, $d['currency_id'], true) !!}</td>

                                    @if (getenv('APP_MARKET') == 'it')
                                        <td>{!! GetMoneyStr3($d['bingo_fee'], true, $d['currency_id'], true) !!}</td>
                                    @endif
                                    <td>
                                        {{ $d['rtp'] }}
                                    </td>

                                    @if (isset($d['category_name']))
                                        <td>
                                            {{ $d['category_name'] }}
                                        </td>
                                    @else
                                        <td>
                                            {{ $d['category_name_array'][0] }}
                                            @if (!empty($d['category_name_array']) && $d['category_name_array'] != null)
                                                <span class="text-info"
                                                    title="
                                    ">
                                                    @if (count($d['category_name_array']) != 0)
                                                        ({{ count($d['category_name_array']) }})
                                                    @endif
                                                </span>
                                            @endif
                                        </td>
                                    @endif

                                    @if ($break_by)
                                        <td>
                                            {{ $d['break_by'] }}
                                        </td>
                                    @endif
                                </tr>
                            @endforeach

                        </tbody>

                        <tfoot>
                            <tr style="height: 25px"></tr>
                            <tr class='bg-subtotal'>
                                <td>
                                    <strong>
                                        @lang('Subtotal(:currency)', ['currency' => $currencyName])
                                    </strong>
                                </td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>
                                <td></td>

                                <td>{{ $data->sum('total_players') }}</td>
                                <td>{{ $data->sum('total_rounds') }}</td>
                                <td>{!! GetMoneyStr3($data->sum('total_bet'), true, $data['0']['currency_id'], true) !!}</td>
                                <td>{!! GetMoneyStr3($data->sum('total_win'), true, $data['0']['currency_id'], true) !!}</td>
                                <td>
                                    {!! GetMoneyStr3(
                                        $data->sum('avg_bet') == 0 ? 0 : $data->sum('avg_bet') / count($data->whereNotNull('avg_bet')),
                                        true,
                                        $data['0']['currency_id'],
                                        true,
                                    ) !!}
                                </td>


                                <td>{!! GetMoneyStr3($data->sum('bonus'), true, $data['0']['currency_id'], true) !!}</td>
                                <td>{!! GetMoneyStr3($data->sum('bonus_win'), true, $data['0']['currency_id'], true) !!}</td>

                                <td>{!! GetMoneyStr3($data->sum('bonus_cost'), true, $data['0']['currency_id'], true) !!}</td>
                                <td>{!! GetMoneyStr3($data->sum('GGR'), true, $data['0']['currency_id'], true) !!}</td>

                                @if (getenv('APP_MARKET') == 'it')
                                    <td>{!! GetMoneyStr3($data->sum('bingo_fee'), true, $data['0']['currency_id'], true) !!}</td>
                                @endif
                                <td></td>
                                <td></td>
                                @if ($break_by)
                                    <td></td>
                                @endif
                            </tr>
                        </tfoot>
                    </table>
                    <button class="btn btn-primary float-left js-exportall"
                        table_to_export="{{ $table_to_export }}"
                        filename="{{ $currencyName }}-casino-games-report-{{ date('Y-m-d') }}">{{ __('Export all to CSV') }}</button>
                </div>
            @endforeach
        </div>
    </div>
@else
    <div class="col-12">
        {{ __('No results for selected params') }}
    </div>

@endif

<script>
    $('a[data-toggle="pill"]').on('shown.bs.tab', function(e) {
        $($.fn.dataTable.tables(true)).DataTable().columns.adjust();
    });
</script>