@if (Auth::user()->hasRole('SuperAdmin')) @endif @if ($break_by) @endif @if (count($subtotals) > 0) @php $bet_total = $win_total = $avg_bet_total = $real_bonus_cost_total = $bonus_cost_total = $ggr_total = $rake_total = 0; if ($break_by) { $all = $subtotals->groupBy(['break_by', 'game_name'])->toArray(); } else { $all = $subtotals->groupBy('game_name')->toArray(); } @endphp @foreach ($all as $row) {{-- @dd($subtotals->groupBy('game_name')) --}} @if ($break_by) @php $total_converted_bet = $total_converted_win = $total_converted_avg_bet = $total_converted_bonus = $total_converted_real_bonus = $total_converted_ggr = $total_players = $total_rounds = $total_rtp = 0; $partners = $skins = $game_categories = []; @endphp @foreach ($row as $game_name => $game_data) @foreach ($game_data as $row2) @php $converted_bet = convertAmountToEur($row2['total_bet']*100, $row2['currency_id'], $break_by ? $row2['session_start'] : $date_range); $converted_win = convertAmountToEur($row2['total_win']*100, $row2['currency_id'], $break_by ? $row2['session_start'] : $date_range); $converted_avg_bet = convertAmountToEur($row2['avg_bet']*100, $row2['currency_id'], $break_by ? $row2['session_start'] : $date_range); $converted_ggr = convertAmountToEur($row2['GGR']*100, $row2['currency_id'], $break_by ? $row2['session_start'] : $date_range); $converted_bonus = convertAmountToEur($row2['bonus_cost']*100, $row2['currency_id'], $break_by ? $row2['session_start'] : $date_range); if (Auth::user()->hasRole('SuperAdmin')) { $converted_real_bonus = convertAmountToEur($row2['bonus']*100, $row2['currency_id'], $break_by ? $row2['session_start'] : $date_range); $total_converted_real_bonus += filter_var(strip_tags($converted_real_bonus), FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); } $total_converted_bet += filter_var(strip_tags($converted_bet), FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); $total_converted_win += filter_var(strip_tags($converted_win), FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); $total_converted_avg_bet += filter_var(strip_tags($converted_avg_bet), FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); $total_converted_ggr += filter_var(strip_tags($converted_ggr), FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); $total_converted_bonus += filter_var(strip_tags($converted_bonus), FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); foreach ($row2['partner_count'] as $partner) { $partners[] = $partner; } foreach ($row2['skin_count'] as $skin) { $skins[] = $skin; } if (isset($row2['category_name_array'])) { foreach ($row2['category_name_array'] as $category) { $game_categories[] = $category; } } elseif (isset($row2['category_name'])) { $game_categories[] = $row2['category_name']; } $total_players += $row2['total_players']; $total_rounds += $row2['total_rounds']; $total_rtp += $row2['rtp']; @endphp @endforeach @if (Auth::user()->hasRole('SuperAdmin')) @endif @endforeach @else @php $total_converted_bet = $total_converted_win = $total_converted_avg_bet = $total_converted_bonus = $total_converted_real_bonus = $total_converted_ggr = $total_players = $total_rounds = $total_rtp = 0; $partners; $partners = $skins = $game_categories = []; @endphp @foreach ($row as $row2) @php $converted_bet = convertAmountToEur($row2['total_bet']*100, $row2['currency_id'], $date_range, false); $converted_win = convertAmountToEur($row2['total_win']*100, $row2['currency_id'], $date_range, false); $converted_avg_bet = convertAmountToEur($row2['avg_bet']*100, $row2['currency_id'], $date_range, false); $converted_ggr = convertAmountToEur($row2['GGR']*100, $row2['currency_id'], $date_range, false); $converted_bonus = convertAmountToEur($row2['bonus_cost']*100, $row2['currency_id'], $date_range, false); if (Auth::user()->hasRole('SuperAdmin')) { $converted_real_bonus = convertAmountToEur($row2['bonus']*100, $row2['currency_id'], $date_range, false); $total_converted_real_bonus += filter_var(strip_tags($converted_real_bonus), FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); } $total_converted_bet += filter_var(strip_tags($converted_bet), FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); $total_converted_win += filter_var(strip_tags($converted_win), FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); $total_converted_avg_bet += filter_var(strip_tags($converted_avg_bet), FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); $total_converted_ggr += filter_var(strip_tags($converted_ggr), FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); $total_converted_bonus += filter_var(strip_tags($converted_bonus), FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); foreach ($row2['partner_count'] as $partner) { $partners[] = $partner; } foreach ($row2['skin_count'] as $skin) { $skins[] = $skin; } if (isset($row2['category_name_array'])) { foreach ($row2['category_name_array'] as $category) { $game_categories[] = $category; } } elseif (isset($row2['category_name'])) { $game_categories[] = $row2['category_name']; } $total_players += $row2['total_players']; $total_rounds += $row2['total_rounds']; $total_rtp += $row2['rtp']; @endphp @endforeach @if (Auth::user()->hasRole('SuperAdmin')) @endif @if ($break_by) @endif @endif @php $bet_total += $total_converted_bet; $win_total += $total_converted_win; $avg_bet_total += $total_converted_avg_bet; $bonus_cost_total += $total_converted_bonus; if (Auth::user()->hasRole('SuperAdmin')) { $real_bonus_cost_total += $total_converted_real_bonus; } $ggr_total += $total_converted_ggr; @endphp @endforeach @endif @if (Auth::user()->hasRole('SuperAdmin')) @endif @if ($break_by) @endif
{{ __('Game name') }} {{ __('Partner Name') }} {{ __('Skin') }} {{ __('Provider') }} {{ __('Slot') }} {{ __('Device') }} {{ __('Total players') }} {{ __('Rounds') }} {{ __('Bet') }} {{ __('Win') }} {{ __('Avg Bet') }} {{ __('Real bonus') }} {{ __('Bonus Cost') }} {{ __('GGR') }} {{ __('RTP') }} {{ __('Category') }} {{ strtoupper($break_by) }}
{{ $game_name }} @if (count(array_unique($partners)) > 0) @php $partners_count = count(array_unique($partners)); @endphp {{ $partners_count <= 1 ? $partners[0] : $partners_count . ' Partners' }} @else {{ '' }} @endif @if (count(array_unique($skins)) > 0) @php $skins_count = count(array_unique($skins)); @endphp {{ $skins_count <= 1 ? $skins[0] : $skins_count . ' Skins' }} @else {{ '' }} @endif {{ $game_data[0]['provider_name'] }} @if ($game_data[0]['is_slot'] == 1)

{{-- --}} @endif
{{ $game_data[0]['device'] }} {{ $total_players }} {{ $total_rounds }} €{{ $total_converted_bet != 0 ? number_format($total_converted_bet, 2, '.', '') : $total_converted_bet }} €{{ $total_converted_win != 0 ? number_format($total_converted_win, 2, '.', '') : $total_converted_win }} €{{ $total_converted_avg_bet != 0 ? number_format($total_converted_avg_bet, 2, '.', '') : $total_converted_avg_bet }} €{{ $total_converted_real_bonus != 0 ? number_format($total_converted_real_bonus, 2, '.', '') : $total_converted_real_bonus }} €{{ $total_converted_bonus != 0 ? number_format($total_converted_bonus, 2, '.', '') : $total_converted_bonus }} €{{ $total_converted_ggr != 0 ? number_format($total_converted_ggr, 2, '.', '') : $total_converted_ggr }} {{ $total_rtp }} @if (count(array_unique($game_categories)) > 0) @php $game_categories_count = count(array_unique($game_categories)); @endphp {{ $game_categories_count <= 1 ? $game_categories[0] : $game_categories_count . ' Categories' }} @else {{ '' }} @endif {{ $game_data[0]['break_by'] }}
{{ $row[0]['game_name'] }} @if (count(array_unique($partners)) > 0) @php $partners_count = count(array_unique($partners)); @endphp {{ $partners_count <= 1 ? $partners[0] : $partners_count . ' Partners' }} @else {{ '' }} @endif @if (count(array_unique($skins)) > 0) @php $skins_count = count(array_unique($skins)); @endphp {{ $skins_count <= 1 ? $skins[0] : $skins_count . ' Skins' }} @else {{ '' }} @endif {{ $row[0]['provider_name'] }} @if ($row[0]['is_slot'] == 1)

{{-- --}} @endif
{{ $row[0]['device'] }} {{ $total_players }} {{ $total_rounds }} €{{ $total_converted_bet != 0 ? number_format($total_converted_bet, 2, '.', '') : $total_converted_bet }} €{{ $total_converted_win != 0 ? number_format($total_converted_win, 2, '.', '') : $total_converted_win }} €{{ $total_converted_avg_bet != 0 ? number_format($total_converted_avg_bet, 2, '.', '') : $total_converted_avg_bet }} €{{ $total_converted_real_bonus != 0 ? number_format($total_converted_real_bonus, 2, '.', '') : $total_converted_real_bonus }} €{{ $total_converted_bonus != 0 ? number_format($total_converted_bonus, 2, '.', '') : $total_converted_bonus }} €{{ $total_converted_ggr != 0 ? number_format($total_converted_ggr, 2, '.', '') : $total_converted_ggr }} {{ $total_rtp }} @if (count(array_unique($game_categories)) > 0) @php $game_categories_count = count(array_unique($game_categories)); @endphp {{ $game_categories_count <= 1 ? $game_categories[0] : $game_categories_count . ' Categories' }} @else {{ '' }} @endif {{ $row2['break_by'] }}
@lang('Subtotal (:currency)', ['currency' => 'EUR']) {{ $subtotals->sum('total_players') }} {{ $subtotals->sum('total_rounds') }} €{{ $bet_total }} €{{ $win_total }} €{{ $avg_bet_total == 0 ? '0' : ($avg_bet_total / count($subtotals->whereNotNull('avg_bet')) >= 0 ? $avg_bet_total / count($subtotals->whereNotNull('avg_bet')) : '0') }} €{{ $real_bonus_cost_total }} €{{ $bonus_cost_total }} €{{ $ggr_total }}