Opening Balance |
Promo |
Cash |
{{-- --}} |
|---|---|---|---|
| Deposit |
0
|
{{ \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 ?? '');
}
if(request()->has('segment_id')){
$segment = \App\Models\Segment::query()->find(request()->get('segment_id'));
$players = collect(\Illuminate\Support\Facades\DB::select(\Illuminate\Support\Facades\DB::raw($segment->query)))->pluck('id');
$query->whereIn('player_id',$players);
}
})->where('status' , 'success')->sum('amount') }}
|
|
| Withdrawal |
0
|
{{ \App\Models\Withdraw::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 ?? '');
}
if(request()->has('segment_id')){
$segment = \App\Models\Segment::query()->find(request()->get('segment_id'));
$players = collect(\Illuminate\Support\Facades\DB::select(\Illuminate\Support\Facades\DB::raw($segment->query)))->pluck('id');
$query->whereIn('player_id',$players);
}
})->where('status' , 'success')->sum('amount') }}
|
|
| Campaigns |
{{ number_format(\App\Models\Campain::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 ?? '');
} else {
$query->where('end_date' , '<=' , \Carbon\Carbon::today());
}
})->sum('reward')) }}
|
0
|
|
| Adjustment |
thfgnjtf
|
htfr
|
|
| Games Report (Bets) |
{{ 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_bonus_bet')) }}
|
{{ 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')) }}
|
|
| Games Report (GGR) |
{{ 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_bonus_bet')) }}
|
{{ 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')) }}
|
|
| Bonus Redeems |
{{ 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 ?? '');
}
if(request()->has('segment_id')){
$segment = \App\Models\Segment::query()->find(request()->get('segment_id'));
$players = collect(\Illuminate\Support\Facades\DB::select(\Illuminate\Support\Facades\DB::raw($segment->query)))->pluck('id');
$query->whereIn('player_id',$players);
}
})->where('status' , 'active')->sum('amount')) }}
|
-{{ 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 ?? '');
}
if(request()->has('segment_id')){
$segment = \App\Models\Segment::query()->find(request()->get('segment_id'));
$players = collect(\Illuminate\Support\Facades\DB::select(\Illuminate\Support\Facades\DB::raw($segment->query)))->pluck('id');
$query->whereIn('player_id',$players);
}
})->where('status' , 'active')->sum('amount')) }}
|