public function create() { $states = State::lists('name', 'id')->toArray(); $usuarios = User::with('state', 'diagnostics')->whereNotIn('id', [1])->orderBy('created_at', 'desc')->paginate(20); return view('admin.user.index')->with('states', $states)->with('usuarios', $usuarios); }
public function top_users_diagnostics() { $users = User::with('diagnostics')->get(); $users = $users->sortByDesc(function ($user) { return $user->diagnostics->count(); }); $users = $users->take(5); foreach ($users as $user) { $data[] = ['label' => "{$user->name} {$user->lastname}", 'value' => $user->diagnostics->count()]; } return response()->json($data); }