@extends('admin.body.adminmaster') @section('admin') @php date_default_timezone_set("Asia/Calcutta"); //India time (GMT+5:30) $date= date('Y-m-d'); $users = DB::select("SELECT (SELECT COUNT(id) FROM users) as totaluser, (SELECT COUNT(id) FROM game_setting) as totalgames, (SELECT COUNT(id) FROM colour_bet) as totalbet, (SELECT COUNT(id) FROM feedback) as totalfeedback, COALESCE ( (SELECT SUM(amount) FROM user_payin WHERE status=1),0)as totaldeposit, COALESCE ((SELECT SUM(amount) FROM withdraw_history WHERE withdraw_history.status = 2 AND withdraw_history.date LIKE '$date%'),0)as tamount, COALESCE ((SELECT SUM(amount) FROM withdraw_history WHERE withdraw_history.status = 2 ),0)as totalwithdraw, COALESCE((SELECT SUM(amount) FROM user_payin WHERE status = '1' AND user_payin.created_at LIKE '$date%'), 0) as tdeposit, SUM(commission) as commissions, COALESCE( (SELECT (today_turnover) FROM users WHERE id = 2 AND users.created_at LIKE '$date'),0 )as todayturnover, COUNT(id) as users, SUM(turnover) as total_turnover FROM users;") @endphp
{{$users[0]->totaluser}}
Total Player
{{$users[0]->totalgames}}
Total Games
{{$users[0]->total_turnover}}
Total Turnover
{{$users[0]->todayturnover}}
Today Turnover
{{$users[0]->commissions}}
Total Commission
{{$users[0]->totaldeposit}}
Total Deposit
{{$users[0]->tdeposit}}
Today Deposit
{{$users[0]->totalwithdraw}}
Total Withdrawl
{{$users[0]->tamount}}
Today Withdrawl
{{$users[0]->totalfeedback}}
FeedBack