PHP Builder::has方法代码示例

 /**
  * Scope of sellers.
  *
  * @param \Illuminate\Database\Eloquent\Builder $query
  *
  * @return \Illuminate\Database\Eloquent\Builder
  */
 public function scopeSellers($query)
 {
     return $query->has('items');
 }

 /**
  * @param Builder $builder
  * @return Builder|static
  */
 public function scopeTranslated(Builder $builder)
 {
     return $builder->has('translations');
 }

 /**
  * Scope for a Model that doesn't have any tags.
  *
  * @param \Illuminate\Database\Eloquent\Builder $query
  *
  * @return \Illuminate\Database\Eloquent\Builder
  */
 public function scopeWithoutTags(Builder $query)
 {
     return $query->has('tags', '=', 0);
 }

 public function scopeWithAnyTags(Builder $query, $tags = [])
 {
     $tags = Util::buildTagArray($tags);
     if (empty($tags)) {
         return $query->has('tags');
     }
     $slug = array_map([S::class, 'slugify'], $tags);
     return $query->whereHas('tags', function ($q) use($slug) {
         $q->whereIn('slug', $slug);
     });
 }

 /**
  * Gets the roles with no users.
  *
  * @param \Illuminate\Database\Eloquent\Builder $query
  * @return \Illuminate\Database\Eloquent\Builder
  */
 public function scopeInactive($query)
 {
     return $query->has('users', '<', 1);
 }

 public function scopeActive(Builder $query)
 {
     $query->has('attributeOptions');
 }

 /**
  * Scope of categories with no children.
  *
  * @param \Illuminate\Database\Eloquent\Builder $query
  *
  * @return \Illuminate\Database\Eloquent\Builder
  */
 public function scopeLeaves($query)
 {
     return $query->has('children', 0);
 }

 public function apply(Builder $builder, Model $model)
 {
     $builder->has('article');
     $this->addWithDrafts($builder);
 }

 /**
  * @param Builder $model
  * @return mixed
  */
 public function applyToQuery($model)
 {
     return $model->has($this->relation, $this->operator, $this->count, $this->boolean, $this->callback);
 }

 /**
  * Query has relations.
  *
  * @param  \Illuminate\Database\Eloquent\Builder $query
  * @param  array                                 $hasRelations
  * @return \Illuminate\Database\Eloquent\Builder
  */
 protected function queryHasRelations($query, $hasRelations = [])
 {
     $hasRelations = $hasRelations ?: $this->hasRelations;
     foreach ($hasRelations as $relation => $operatorCount) {
         list($operator, $count) = $operatorCount;
         $query->has($relation, $operator, $count);
     }
     return $query;
 }

 /**
  * @param User $actor
  * @param Builder $query
  */
 public function find(User $actor, Builder $query)
 {
     // Hide discussions which have tags that the user is not allowed to see.
     $query->whereNotExists(function ($query) use($actor) {
         return $query->select(new Expression(1))->from('discussions_tags')->whereIn('tag_id', Tag::getIdsWhereCannot($actor, 'viewDiscussions'))->where('discussions.id', new Expression('discussion_id'));
     });
     // Hide discussions with no tags if the user doesn't have that global
     // permission.
     if (!$actor->hasPermission('viewDiscussions')) {
         $query->has('tags');
     }
 }

 /**
  * Scope a query to only include online players.
  *
  * @param  \Illuminate\Database\Eloquent\Builder  $query
  * @return \Illuminate\Database\Eloquent\Builder
  */
 public function scopeOnline($query)
 {
     return $query->has('playerOnline');
 }

 /**
  * @param Builder $query
  * @param UserInterface $user
  * @return Builder
  */
 public function scopeForUser(Builder $query, UserInterface $user = null)
 {
     if ($user === null && $this->user !== null) {
         $user = $this->user;
     }
     if ($user === null) {
         return $query->has('activities');
     }
     return $query->whereHas('activities', function ($q) use($user) {
         $q->where('user_id', '=', $user->getAuthIdentifier());
     });
 }

 /**
  * Query wether or not the relationship is empty of now.
  *
  * @param        $relation
  * @param string $operator
  * @param int    $count
  *
  * @return $this
  */
 public function has($relation, $operator = '>=', $count = 1)
 {
     $this->builder = $this->builder->has($relation, $operator, $count);
     return $this;
 }

 /**
  * @param \Illuminate\Database\Eloquent\Builder $query
  *
  * @return \Illuminate\Database\Eloquent\Builder|static
  */
 public function scopeTranslated(Builder $query)
 {
     return $query->has('translations');
 }