@extends('layouts.master') @section('title') LT-99 :: DASHBOARD @endsection @php $me = Auth::user(); if ($me->isAssist()) { $me = $me->upline; } $myMembers = $me->downlines()->where(['user_type' => 1])->whereNull(['position', 'store_id']); $allMembers = $myMembers->count(); $newDepositRequest = \App\DepositRequest::where('status', 0)->whereIn('deposit_requests.user_id', function ($q) use ($me) { $q->selectRaw('id')->from('users')->where('advisor_id', $me->id); })->count(); $newWithdrawRequest = \App\WithdrawRequest::where('status', 0)->whereIn('withdraw_requests.user_id', function ($q) use ($me) { $q->selectRaw('id')->from('users')->where('advisor_id', $me->id); })->count(); $newMembers = $myMembers->whereDate('created_at', date('Y-m-d'))->count(); @endphp @section('content')