DB::statement("SET SQL_MODE = false");
$user = User::select('user_type', 'is_blocked', 'status', 'is_delete', DB::raw("count(created_at) as total,
DATE(created_at) as date"))
->where('status', 'active')
->where('is_blocked', 'unblock')
->where('is_delete', '0')
->where('user_type', 'user')
->whereDate('created_at', $date)
->groupBy('date')
Comments
Post a Comment
If you any doubt of any topic then you can comment me.