PHP User::whereHas方法代码示例

 /**
  * Removes the specified user from the specified role.
  *
  * @param int|string $roleId
  * @param int|string $userId
  *
  * @return \Illuminate\Http\RedirectResponse
  */
 public function destroy($roleId, $userId)
 {
     $this->authorize('admin.roles.users.destroy');
     $role = $this->role->findOrFail($roleId);
     $user = $role->users()->findOrFail($userId);
     // Retrieve the administrators name.
     $adminName = Role::getAdministratorName();
     // Retrieve all administrators.
     $administrators = $this->user->whereHas('roles', function ($query) use($adminName) {
         $query->whereName($adminName);
     })->get();
     $admin = Role::whereName($adminName)->first();
     // We need to verify that if the user is trying to remove all roles on themselves,
     // and they are the only administrator, that we throw an exception notifying them
     // that they can't do that. Though we want to allow the user to remove the
     // administrator role if more than one administrator exists.
     if ($user->hasRole($admin) && $user->id === auth()->user()->id && count($administrators) === 1) {
         flash()->setTimer(null)->error('Error!', "Unable to remove the administrator role from this user. You're the only administrator.");
         return redirect()->route('admin.roles.show', [$roleId]);
     }
     if ($role->users()->detach($user)) {
         flash()->success('Success!', 'Successfully removed user.');
         return redirect()->route('admin.roles.show', [$roleId]);
     }
     flash()->error('Error!', 'There was an issue removing this user. Please try again.');
     return redirect()->route('admin.roles.show', [$roleId]);
 }

 public function admins()
 {
     $admins = User::whereHas('roles', function ($q) {
         $q->where('name', 'web');
     })->get();
     return $admins;
 }

 /**
  * Returns a paginated list of all active talents
  *
  * @param null $tag
  * @param null $skill
  * @param null $location
  * @param null $orderBy
  * @param int $perPage
  * @param null $profession
  * @return \Illuminate\Pagination\Paginator
  */
 public function findActiveTalents($tag = null, $skill = null, $location = null, $orderBy = null, $perPage = 12, $profession = null)
 {
     $results = User::whereHas('profile', function ($q) use($tag, $skill, $location, $orderBy, $profession) {
         $q->where('published', '=', true);
         if ($location) {
             $q->where('location', '=', $location);
         }
         if ($tag) {
             $q->whereHas('tags', function ($q2) use($tag) {
                 $q2->where('tags.name', '=', $tag);
             });
         }
         if ($skill) {
             $q->whereHas('skill', function ($q) use($tag, $skill) {
                 $q->where('id', '=', $skill);
             });
         }
         if ($profession) {
             $q->where('profession_id', '=', $profession);
         }
     })->with('ratings')->with('profile');
     if ($orderBy) {
         $results->orderBy($orderBy);
     } else {
         $results->orderBy('id', 'DESC');
     }
     $paginatedResults = $results->paginate($perPage);
     if ($skill or $tag) {
         $paginatedResults->appends(['needs' => $skill, 'tag' => $tag]);
     }
     return $paginatedResults;
 }

 /**
  * Execute the job.
  *
  * @return bool
  */
 public function handle()
 {
     // Set the inquiry model data.
     $this->inquiry->user_id = auth()->id();
     $this->inquiry->uuid = uuid();
     $this->inquiry->category_id = $this->category->id;
     $this->inquiry->title = $this->request->input('title');
     $this->inquiry->description = $this->request->input('description');
     if ($this->category->manager === true) {
         // If the category requires manager approval, we'll retrieve the manager record.
         $manager = User::whereHas('roles', function (Builder $query) {
             $query->whereName('managers');
         })->findOrFail($this->request->input('manager'));
         $this->inquiry->manager_id = $manager->id;
         // We'll send the manager a notification.
         $notification = new Notification($manager, 'emails.inquiries.created', ['inquiry' => $this->inquiry], function (Message $message) use($manager) {
             $message->subject('A New Request Requires Your Approval');
             $message->to($manager->email);
         });
     }
     if ($this->inquiry->save()) {
         // If the inquiry was successfully created, we'll
         // send out the notification if one has been set.
         if (isset($notification)) {
             $this->dispatch($notification);
         }
         return true;
     }
     return false;
 }

 /**
  * Removes the specified user from the specified role.
  *
  * @param int|string $roleId
  * @param int|string $userId
  *
  * @throws CannotRemoveRolesException
  *
  * @return int
  */
 public function destroy($roleId, $userId)
 {
     $this->authorize('admin.roles.users.destroy');
     $role = $this->role->findOrFail($roleId);
     $user = $role->users()->findOrFail($userId);
     // Retrieve the administrators name.
     $adminName = Role::getAdministratorName();
     // Retrieve all administrators.
     $administrators = $this->user->whereHas('roles', function (Builder $builder) use($adminName) {
         $builder->whereName($adminName);
     })->get();
     $admin = Role::whereName($adminName)->first();
     // We need to verify that if the user is trying to remove all roles on themselves,
     // and they are the only administrator, that we throw an exception notifying them
     // that they can't do that. Though we want to allow the user to remove the
     // administrator role if more than one administrator exists.
     if ($user->hasRole($admin) && $user->getKey() === auth()->user()->getKey() && count($administrators) === 1) {
         throw new CannotRemoveRolesException("Unable to remove the administrator role from this user. You're the only administrator.");
     }
     return $role->users()->detach($user);
 }

 public function apiGetResearcher(Request $request, $keyword = null)
 {
     /* @var Role $researchers */
     $researchers = Role::where("key", "=", "researcher")->first();
     if ($keyword == null) {
         $users = $researchers->users()->get();
     } else {
         $users = User::whereHas("roles", function ($query) {
             $query->where('key', '=', 'researcher');
         })->where("firstname", "LIKE", "%{$keyword}%")->orWhere("lastname", "LIKE", "%{$keyword}%")->get();
     }
     return $users;
 }

 /**
  * Execute the job.
  *
  * @throws CannotRemoveRolesException
  *
  * @return bool
  */
 public function handle()
 {
     $this->user->name = $this->request->input('name', $this->user->name);
     $this->user->email = $this->request->input('email');
     $password = $this->request->input('password');
     // Verify before changing the users password that it's not empty.
     if (!empty($password)) {
         // If the user doesn't have a set password mutator,
         // we'll encrypt the password.
         if (!$this->user->hasSetMutator('password')) {
             $password = bcrypt($password);
         }
         $this->user->password = $password;
     }
     // Retrieve the administrators name.
     $adminName = Role::getAdministratorName();
     $roles = $this->request->input('roles', []);
     // Retrieve all administrator users.
     $administrators = $this->user->whereHas('roles', function (Builder $builder) use($adminName) {
         $builder->whereName($adminName);
     })->get();
     // Retrieve the administrator role.
     $admin = Role::whereName($adminName)->first();
     // We need to verify that if the user is trying to remove all roles on themselves,
     // and they are the only administrator, that we throw an exception notifying them
     // that they can't do that. Though we want to allow the user to remove the
     // administrator role if more than one administrator exists.
     if (count($roles) === 0 && $this->user->hasRole($admin) && $this->user->getKey() === auth()->user()->getKey() && count($administrators) === 1) {
         throw new CannotRemoveRolesException("Unable to remove the administrator role. You're the only administrator.");
     }
     if ($this->user->save()) {
         $this->user->roles()->sync($roles);
         return true;
     }
     return false;
 }

 public function findOrCreateByVk($data) : User
 {
     $user = User::whereHas('connections', function ($query) use($data) {
         $query->where('driver', 'vk');
         $query->whereRaw('cast(("socials".data->>\'id\') as varchar) = ?', [$data->id]);
     })->first();
     if (!empty($user)) {
         return $user;
     }
     $user = User::whereIn('username', [$data->nickname, $data->email])->first();
     if (!empty($user)) {
         $this->addConnection($user, 'vk', $data);
         return $user;
     }
     /** @var User $user */
     $user = User::create(['first_name' => $data->user['first_name'], 'last_name' => $data->user['last_name'], 'username' => $data->nickname ?? $data->email, 'avatar' => $data->avatar]);
     $this->addConnection($user, 'vk', $data);
     return $user;
 }

 /**
  * Bootstrap any application services.
  *
  * @return void
  */
 public function boot()
 {
     $author = User::whereHas('role', function ($q) {
         $q->where('slug', 'admin');
     })->first();
     $categories = Category::where('is_active', 1)->get();
     $postsRecents = Post::where('is_active', 1)->where('seen', 1)->orderBy('created_at', 'desc')->take(3)->get();
     $postsPopular = Post::where('is_active', 1)->where('seen', 1)->orderBy('nview', 'desc')->take(3)->get();
     $commentsRecents = Comment::where('seen', 1)->orderBy('created_at', 'desc')->take(3)->get();
     $tags = Tag::all();
     $INFO_SITE = Admin::first();
     view()->share('author', $author);
     view()->share('categories', $categories);
     view()->share('tags', $tags);
     view()->share('postsRecents', $postsRecents);
     view()->share('postsPopular', $postsPopular);
     view()->share('commentsRecents', $commentsRecents);
     view()->share('INFO_SITE', $INFO_SITE);
 }

 /**
  * 关联查询
  *
  *  article 为 User 模型 里面的 article() 方法
  *
  */
 public function queryRelation()
 {
     //select `username` from `tcc_users` where (select count(*) from `article` where `article`.`user_id` = `tcc_users`.`id`) > 5
     $user = User::has('article', '>', 5)->select('username')->get();
     debug($user);
     $user = User::whereHas('article', function ($query) {
         $query->where('content', 'like', '%content%');
     })->get();
     debug($user);
     return view('index');
 }

 public function getAllStats()
 {
     $users = User::whereHas('roles', function ($q) {
         $q->where('name', 'hacker');
     })->with('application', 'application.school')->get();
     $gender = array();
     $grad_year = array();
     $school = array();
     $completed = array(0, 0);
     foreach ($users as $user) {
         if ($user->application->completed) {
             if (!isset($gender[$user->application->gender])) {
                 $gender[$user->application->gender] = 1;
             } else {
                 $gender[$user->gender]++;
             }
             if (!isset($grad_year[$user->application->grad_year])) {
                 $grad_year[$user->application->grad_year] = 1;
             } else {
                 $grad_year[$user->application->grad_year]++;
             }
             if (!isset($school[$user->application->school])) {
                 $school[$user->application->school] = 1;
             } else {
                 $school[$user->application->school]++;
             }
             $completed[1]++;
         } else {
             $completed[0]++;
         }
     }
     var_dump($gender);
     var_dump($grad_year);
     // var_dump($school);
     var_dump($completed);
 }

 public function sortUser($slug)
 {
     $users = User::whereHas('role', function ($q) use($slug) {
         $q->where('slug', $slug);
     })->orderBy('seen', 'asc')->orderBy('created_at', 'desc')->paginate($this->itemPerPage);
     $roles = Role::all();
     $counts['total'] = User::count();
     foreach ($roles as $role) {
         $slug = $role->slug;
         $counts[$slug] = User::whereHas('role', function ($q) use($slug) {
             $q->whereSlug($slug);
         })->count();
     }
     return view('admin.users.index', compact('users', 'roles', 'counts'));
 }

 public function getDaftarGuruInstansi($instansiId = null)
 {
     if ($instansiId == null) {
         return '';
     }
     $data = ['guru' => User::whereHas('guru', function ($query) use($instansiId) {
         return $query->where('instansi_id', $instansiId);
     })->get()];
     return view('backend.pages.undangan.guru-instansi', $data);
 }

 /**
  * Returns a new form for the specified inquiry.
  *
  * @param Inquiry  $inquiry
  * @param Category $category
  *
  * @return \Orchestra\Contracts\Html\Builder
  */
 public function form(Inquiry $inquiry, Category $category)
 {
     return $this->form->of('inquiries', function (FormGrid $form) use($inquiry, $category) {
         if ($inquiry->exists) {
             $method = 'PATCH';
             $url = route('inquiries.update', [$inquiry->id]);
             $form->submit = 'Save';
         } else {
             $method = 'POST';
             $url = route('inquiries.store', [$category->id]);
             $form->submit = 'Create';
         }
         $form->attributes(compact('method', 'url'));
         $form->with($inquiry);
         $form->fieldset(function (Fieldset $fieldset) use($inquiry, $category) {
             $fieldset->control('input:text', 'title')->attributes(['placeholder' => 'Enter the title of your request.']);
             if ($category->manager) {
                 $fieldset->control('input:select', 'manager', function (Field $field) use($inquiry) {
                     $field->label = 'Manager';
                     $field->options = User::whereHas('roles', function (Builder $query) {
                         $query->whereName('Managers');
                     })->orderBy('name')->pluck('name', 'id');
                     $field->value = function (Inquiry $inquiry) {
                         return $inquiry->manager_id;
                     };
                     if ($inquiry->category_id) {
                         $field->attributes = ['disabled'];
                     }
                 });
             }
             $fieldset->control('input:textarea', 'description')->attributes(['placeholder' => 'Enter the description of your request.']);
         });
     });
 }