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);
 }