@if ($time_range != 2) @else @endif @if ($game_category) @endif @if ($break_by) @endif @php $bet_total = $win_total = $avg_bet_total = $real_bonus_used_total = $bonus_cost_total = $ggr_total = $rake_total = $bonus_win_total = 0; @endphp @foreach ($casino_players as $curency_name => $row) @if ($game_category) @endif @if ($break_by) @endif @php $bet_total += filter_var(strip_tags(convertAmountToEur($row->bet, $row->currency_id, $break_by ? $row->session_start : $date_range, true, true)), FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); $win_total += filter_var(strip_tags(convertAmountToEur($row->win, $row->currency_id, $break_by ? $row->session_start : $date_range, true, true)), FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); $ggr_total += filter_var(strip_tags(convertAmountToEur($row->GGR, $row->currency_id, $break_by ? $row->session_start : $date_range, true, true)), FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); $avg_bet_total += filter_var(strip_tags(convertAmountToEur($row->avg_bet, $row->currency_id, $break_by ? $row->session_start : $date_range, true, true)), FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); $real_bonus_used_total += filter_var(strip_tags(convertAmountToEur($row->real_bonus_used, $row->currency_id, $break_by ? $row->session_start : $date_range, true, true)), FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); $bonus_cost_total += filter_var(strip_tags(convertAmountToEur($row->bonus_cost, $row->currency_id, $break_by ? $row->session_start : $date_range, true, true)), FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); $rake_total += filter_var(strip_tags(convertAmountToEur($row->rake, $row->currency_id, $break_by ? $row->session_start : $date_range, true, true)), FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); $bonus_win_total += filter_var(strip_tags(convertAmountToEur($row->bonus_win, $row->currency_id, $break_by ? $row->session_start : $date_range, true, true)), FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); @endphp @endforeach @if ($break_by) @endif
{{ __('Aggregator ID') }} {{ __('External ID') }} {{ __('Partner Name') }} {{ __('Skin Name') }} {{ __('Username') }} {{ __('Affiliate') }} {{ __('Provider') }} {{ __('Rounds') }} {{ __('Original Currency') }} {{ __('Country') }} {{ __('Bet') }} {{ __('Win') }} {{ __('GGR') }} {{ __('AVG Bet') }} {{ __('Bonus BET') }} {{ __('Bonus WIN') }} {{ __('Bonus Cost') }} {{ __('Rake') }} {{ __('Last activity') }} {{ __('First activity') }} {{ __('Category') }} {{ strtoupper($break_by) }}
{{ $row->uid }} {{ $row->operator_id }} {{ $row->partner_name }} {{ !empty($row->skin_name) ? $row->skin_name : '' }} {{ $row->extern_username }} @if ($row->level) {{ __('VIP') }} @endif {{ $row->affiliate }} {{ $row->provider_name }} {{ $row->rounds }} {{ $row->currency_name }} {{ $row->country }} {!! convertAmountToEur($row->bet, $row->currency_id, $break_by ? $row->session_start : $date_range, true, true) !!} {!! convertAmountToEur($row->win, $row->currency_id, $break_by ? $row->session_start : $date_range, true, true) !!} {!! convertAmountToEur($row->GGR, $row->currency_id, $break_by ? $row->session_start : $date_range, true, true) !!} {!! convertAmountToEur($row->avg_bet, $row->currency_id, $break_by ? $row->session_start : $date_range, true, true) !!} {!! convertAmountToEur($row->real_bonus_used, $row->currency_id, $break_by ? $row->session_start : $date_range, true, true) !!} {!! convertAmountToEur($row->bonus_win, $row->currency_id, $break_by ? $row->session_start : $date_range, true, true) !!} {!! convertAmountToEur($row->bonus_cost, $row->currency_id, $break_by ? $row->session_start : $date_range, true, true) !!} {!! convertAmountToEur($row->rake, $row->currency_id, $break_by ? $row->session_start : $date_range, true, true) !!} {!! $row->last_activity !!}{!! $row->category_name !!} {{ $row->groupedby }}
@lang('Subtotal (:currency)', ['currency' => 'EUR']) {{ $casino_players->sum('rounds') }} €{{ $bet_total }} €{{ $win_total }} €{{ $ggr_total }} €{{ $avg_bet_total == 0 ? 0 : ($avg_bet_total / count($casino_players->whereNotNull('avg_bet')) > 0 ? $avg_bet_total / count($casino_players->whereNotNull('avg_bet')) : 0) }} €{{ $real_bonus_used_total }} €{{ $bonus_win_total }} €{{ $bonus_cost_total }} €{{ $rake_total }}