{{--Opening Balance--}} |
{{--
Promo | --}}
Total |
{{-- --}} |
|---|---|---|---|
| Registrations |
{{ number_format(\App\Models\Player::query()
->where(function($query){
if(request()->has('start_date')){
$query->where('created_at' , '>=' , request()->start_date ?? '');
}
if(request()->has('end_date')){
$query->where('created_at' , '<=' , request()->end_date ?? '');
}
})->count()) }}
|
||
| Active Players |
{{ number_format(\App\Models\Player::query()->where('status','Active')->where(function($query){
if(request()->has('start_date')){
$query->where('created_at' , '>=' , request()->start_date ?? '');
}
if(request()->has('end_date')){
$query->where('created_at' , '<=' , request()->end_date ?? '');
}
})->count()) }}
|
||
| Unique Depositors |
{{ number_format(\App\Models\Deposit::query()->where(function($query){
if(request()->has('start_date')){
$query->where('created_at' , '>=' , request()->start_date ?? '');
}
if(request()->has('end_date')){
$query->where('created_at' , '<=' , request()->end_date ?? '');
}
})->groupBy('player_id')->get()->count()) }}
|
||
| Adjustment |
thfgnjtf
|
htfr
|
|
| Games Played |
{{ number_format(\App\Models\GamePlayed::query()
->where(function($query){
if(request()->has('start_date')){
$query->where('created_at' , '>=' , request()->start_date ?? '');
}
if(request()->has('end_date')){
$query->where('created_at' , '<=' , request()->end_date ?? '');
}
})->count()) }}
|
{{--
{{ number_format(\App\Models\GamePlayed::query()
->where(function($query){
if(request()->has('start_date')){
$query->where('created_at' , '>=' , request()->start_date ?? '');
}
if(request()->has('end_date')){
$query->where('created_at' , '<=' , request()->end_date ?? '');
}
})->sum('input_bet')) }}
|
--}}
|
| Access Per Desktop |
{{ number_format(\App\Models\PlayerLogin::query()
->where(function($query){
if(request()->has('start_date')){
$query->where('created_at' , '>=' , request()->start_date ?? '');
}
if(request()->has('end_date')){
$query->where('created_at' , '<=' , request()->end_date ?? '');
}
})->where('device','desktop')->count()) }}
|
{{--
{{ number_format(\App\Models\GamePlayed::query()
->where(function($query){
if(request()->has('start_date')){
$query->where('created_at' , '>=' , request()->start_date ?? '');
}
if(request()->has('end_date')){
$query->where('created_at' , '<=' , request()->end_date ?? '');
}
})->sum('output_bet')) }}
|
--}}
|
| Access Per Mobile Device |
{{ number_format(\App\Models\PlayerLogin::query()
->where(function($query){
if(request()->has('start_date')){
$query->where('created_at' , '>=' , request()->start_date ?? '');
}
if(request()->has('end_date')){
$query->where('created_at' , '<=' , request()->end_date ?? '');
}
})->where('device','mobile')->count()) }}
|
{{--
-{{ number_format(\App\Models\Bonous::query()
->where(function($query){
if(request()->has('start_date')){
$query->where('created_at' , '>=' , request()->start_date ?? '');
}
if(request()->has('end_date')){
$query->where('created_at' , '<=' , request()->end_date ?? '');
}
})->where('status' , 'active')->sum('amount')) }}
|
--}}