@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 ($data as $k => $row) @if($game_category) @endif @if ($break_by) @endif @php $bet_total += filter_var(strip_tags(convertAmountToEur($row->bet * 100, $row->currency_id, $break_by ? $row->session_start : $date_range, false, true)), FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); $win_total += filter_var(strip_tags(convertAmountToEur($row->win * 100, $row->currency_id, $break_by ? $row->session_start : $date_range, false, true)), FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); $ggr_total += filter_var(strip_tags(convertAmountToEur($row->GGR * 100, $row->currency_id, $break_by ? $row->session_start : $date_range, false, true)), FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); $avg_bet_total += filter_var(strip_tags(convertAmountToEur($row->avg_bet * 100, $row->currency_id, $break_by ? $row->session_start : $date_range, false, true)), FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); $real_bonus_used_total += filter_var(strip_tags(convertAmountToEur($row->real_bonus_used * 100, $row->currency_id, $break_by ? $row->session_start : $date_range, false, true)), FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); $bonus_win_total += filter_var(strip_tags(convertAmountToEur($row->bonus_win * 100, $row->currency_id, $break_by ? $row->session_start : $date_range, false, true)), FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); $bonus_cost_total += filter_var(strip_tags(convertAmountToEur($row->bonus_cost * 100, $row->currency_id, $break_by ? $row->session_start : $date_range, false, true)), FILTER_SANITIZE_NUMBER_FLOAT, FILTER_FLAG_ALLOW_FRACTION); $rake_total += filter_var(strip_tags(convertAmountToEur($row->rake * 100, $row->currency_id, $break_by ? $row->session_start : $date_range, false, 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') }}	{{ __('Registration date') }}	{{ __('Category') }}	{{ strtoupper($break_by) }}
{{ $row->uid ?? '' }}	{{ $row->operator_id ?? '' }}	{{ !empty($row->partner_name) ? $row->partner_name : "" }}	{{ !empty($row->skin_name) ? $row->skin_name : "" }}	{{ $row->extern_username ?? '' }}	@if ($row->level) {{ $row->level }} @endif	{{ $row->affiliate ?? '' }}	{{ $row->provider_name ?? ''}}	{{ $row->rounds ?? '' }}	{{ $row->currency_name ?? ''}}	{{ $row->country ?? '' }}	{!! convertAmountToEur($row->bet * 100, $row->currency_id, $break_by ? $row->session_start : $date_range, false, true) !!}	{!! convertAmountToEur($row->win * 100, $row->currency_id, $break_by ? $row->session_start : $date_range, false, true) !!}	{!! convertAmountToEur($row->GGR * 100, $row->currency_id, $break_by ? $row->session_start : $date_range, false, true) !!}	{!! convertAmountToEur($row->avg_bet * 100, $row->currency_id, $break_by ? $row->session_start : $date_range, false, true) !!}	{!! convertAmountToEur($row->real_bonus_used * 100, $row->currency_id, $break_by ? $row->session_start : $date_range, false, true) !!}	{!! convertAmountToEur($row->bonus_win * 100, $row->currency_id, $break_by ? $row->session_start : $date_range, false, true) !!}	{!! convertAmountToEur($row->bonus_cost * 100, $row->currency_id, $break_by ? $row->session_start : $date_range, false, true) !!}	{!! convertAmountToEur($row->rake * 100, $row->currency_id, $break_by ? $row->session_start : $date_range, false, true) !!}	{!! $row->last_activity ?? '' !!}	{{ $row->registration_date ?? '' }}	{!! $row->category_name !!}	{{ $row->groupedby }}
@lang('Subtotal (:currency)', ['currency' => 'EUR'])								{{ $data->sum('rounds') }}			{{ $bet_total }}	{{ $win_total }}	{{ $ggr_total }}	{{ $avg_bet_total == 0 ? 0 : ($avg_bet_total / count($data->whereNotNull('avg_bet')) > 0 ? $avg_bet_total / count($data->whereNotNull('avg_bet')) : 0) }}	{{ $real_bonus_used_total }}	{{ $bonus_win_total }}	{{ $bonus_cost_total }}	{{ $rake_total }}