当前位置: 首页>>代码示例>>PHP>>正文


PHP Builder::whereNotNull方法代码示例

本文整理汇总了PHP中Illuminate\Database\Eloquent\Builder::whereNotNull方法的典型用法代码示例。如果您正苦于以下问题:PHP Builder::whereNotNull方法的具体用法?PHP Builder::whereNotNull怎么用?PHP Builder::whereNotNull使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在Illuminate\Database\Eloquent\Builder的用法示例。


在下文中一共展示了Builder::whereNotNull方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: apply

 /**
  * Apply the scope to a given Eloquent query builder.
  *
  * @param  \Illuminate\Database\Eloquent\Builder  $builder
  * @return void
  */
 public function apply(Builder $builder)
 {
     $model = $builder->getModel();
     $builder->whereNotNull($model->getQualifiedActivatedAtColumn());
     $builder->macro('withDeactivated', function (Builder $builder) {
         $this->remove($builder);
         return $builder;
     });
     $builder->macro('onlyDeactivated', function (Builder $builder) {
         $model = $builder->getModel();
         $this->remove($builder);
         $builder->getQuery()->whereNotNull($model->getQualifiedActivatedAtColumn());
         return $builder;
     });
     $builder->macro('deactivate', function (Builder $builder) {
         $model = $builder->getModel();
         $builder->withDeactivated();
         return $builder->update([$model->getActivatedAtColumn() => null]);
     });
     $builder->macro('activate', function (Builder $builder) {
         $model = $this->getModel();
         $query = $model->newQuery()->where($model->getKeyName(), $model->getKey());
         $model->{$model->getActivatedAtColumn()} = $time = $model->freshTimestamp();
         $query->update([$model->getActivatedAtColumn() => $model->fromDateTime($time)]);
     });
 }
开发者ID:niclasleonbock,项目名称:eloquent-activatable,代码行数:32,代码来源:ActivatableScope.php

示例2: count

 /**
  * Returns the count for a countable parameter, given the query provided
  *
  * @param string                   $name
  * @param EloquentBuilder          $query
  * @param CountableFilterInterface $filter
  * @return array
  */
 public function count($name, $query, CountableFilterInterface $filter)
 {
     // if the columnname is not set, assume an id field based on a table name
     $columnName = empty($this->columnName) ? $name : $this->columnName;
     if (!$this->includeEmpty) {
         $query->whereNotNull($columnName);
     }
     return $query->select("{$columnName} AS {$this->columnAlias}", DB::raw("{$this->countRaw} AS {$this->countAlias}"))->groupBy($columnName)->pluck($this->countAlias, $this->columnAlias);
 }
开发者ID:czim,项目名称:laravel-filter,代码行数:17,代码来源:SimpleDistinctValue.php

示例3: scopeAttached

 /**
  * Modifies the query to only include files attached to an clippable.
  *
  * @param Builder $query
  * @return Builder
  */
 public function scopeAttached(Builder $query)
 {
     return $query->whereNotNull('clippable_id')->whereNotNull('clippable_type');
 }
开发者ID:atrauzzi,项目名称:phperclip,代码行数:10,代码来源:Clipping.php

示例4: scopeIsVerified

 /**
  * Scope verified subscribers.
  *
  * @param \Illuminate\Database\Eloquent\Builder $query
  *
  * @return \Illuminate\Database\Eloquent\Builder
  */
 public function scopeIsVerified(Builder $query)
 {
     return $query->whereNotNull('verified_at');
 }
开发者ID:uwm-appbrewery,项目名称:Cachet,代码行数:11,代码来源:Subscriber.php

示例5: scopeWithDueDate

 /**
  * Scope a query to only include the jobs that have a due date.
  *
  * @param \Illuminate\Database\Eloquent\Builder $query
  * @return \Illuminate\Database\Eloquent\Builder
  */
 public function scopeWithDueDate($query)
 {
     return $query->whereNotNull('job_cards_orig_oc_date')->orWhere('job_cards_new_oc_date', '<>', null);
 }
开发者ID:buys-fran,项目名称:mtech-mis,代码行数:10,代码来源:JobCard.php

示例6: scopeRegistered

 /**
  * Returns all the registered users.
  *
  * @param  \Illuminate\Database\Eloquent\Builder  $query
  * @return \Illuminate\Database\Eloquent\Builder
  */
 public function scopeRegistered(Builder $query)
 {
     return $query->whereNotNull('user_id')->with('user');
 }
开发者ID:umahatokula,项目名称:academia,代码行数:10,代码来源:Session.php

示例7: scopeNear

 /**
  * Get groups near a another address.
  *
  * @param Builder $q
  * @param Address $address
  * @param null    $miles
  *
  * @return $this
  */
 public function scopeNear(Builder $q, Address $address, $miles = null)
 {
     if (is_null($miles)) {
         $miles = Config::get('biblebowl.groups.nearby');
     }
     return $q->active()->with(['address' => function ($q) use($miles, $address) {
         $q->whereNotNull($address->getLatColumn())->whereNotNull($address->getLngColumn())->within($miles, 'miles', $address->latitude, $address->longitude);
     }]);
 }
开发者ID:BibleBowl,项目名称:account,代码行数:18,代码来源:Group.php

示例8: queryFilters

 /**
  * Query filters.
  *
  * @param  \Illuminate\Database\Eloquent\Builder $query
  * @return \Illuminate\Database\Eloquent\Builder
  */
 protected function queryFilters($query, $filters = [])
 {
     $filters = $filters ?: $this->filters;
     foreach ($filters as $key => $filter) {
         foreach ($filter as $operator => $values) {
             $values = is_array($values) ? $values : [$values];
             $operator = is_numeric($operator) ? '=' : $operator;
             if ($operator == '=') {
                 $query->whereIn($key, $values);
             } elseif ($operator == '!=') {
                 $query->whereNotIn($key, $values);
             } elseif ($operator == 'null') {
                 $query->whereNull($key);
             } elseif ($operator == 'not_null') {
                 $query->whereNotNull($key);
             } else {
                 $query->where($key, $operator, head($values));
             }
         }
     }
     return $query;
 }
开发者ID:sedp-mis,项目名称:base-repository,代码行数:28,代码来源:BaseRepositoryEloquent.php

示例9: whereNotNull

 /**
  * Add a whereNotNull to the query
  *
  * @param $field
  * @return mixed
  */
 public function whereNotNull($field)
 {
     $this->builder = $this->builder->whereNotNull($field);
     return $this;
 }
开发者ID:kodebyraaet,项目名称:pattern,代码行数:11,代码来源:BaseRepository.php

示例10: scopeInactive

 /**
  * Query scope for inactive groups.
  */
 public function scopeInactive(Builder $query)
 {
     return $query->whereNotNull($this->getInactiveColumn());
 }
开发者ID:BibleBowl,项目名称:account,代码行数:7,代码来源:CanDeactivate.php

示例11: apply

 /**
  * Apply the scope to a given Eloquent query builder.
  *
  * @param  \Illuminate\Database\Eloquent\Builder $builder
  * @param  \Illuminate\Database\Eloquent\Model $model
  * @return void
  */
 public function apply(Builder $builder, Model $model)
 {
     $builder->whereNotNull('published_at');
     $this->extend($builder);
 }
开发者ID:wunderfactory,项目名称:weinform,代码行数:12,代码来源:PublishedScope.php

示例12: setNotNull

 /**
  * NotNull
  *
  * @param $key
  * @param $value
  * @return $this
  */
 private function setNotNull($key, $value)
 {
     $this->query->whereNotNull($key, $value);
     return $this;
 }
开发者ID:aginev,项目名称:search-filters,代码行数:12,代码来源:Filter.php

示例13: scopeRead

 public function scopeRead(Builder $query)
 {
     $query->whereNotNull('read_at');
 }
开发者ID:gez-studio,项目名称:gez-mall,代码行数:4,代码来源:Notification.php

示例14: scopeLoggedInUsers

 /**
  * Returns all the registered users.
  *
  * @param  \Illuminate\Database\Eloquent\Builder $query
  * @return \Illuminate\Database\Eloquent\Builder
  */
 public function scopeLoggedInUsers($query)
 {
     return $query->whereNotNull('user_id')->with('user');
 }
开发者ID:linhntaim,项目名称:katniss,代码行数:10,代码来源:UserSession.php

示例15: apply

 /**
  * Applies parameter filtering for a given query
  *
  * @param string          $name
  * @param mixed           $value
  * @param EloquentBuilder $query
  * @param FilterInterface $filter
  * @return EloquentBuilder
  */
 public function apply($name, $value, $query, FilterInterface $filter)
 {
     $column = (!empty($this->table) ? $this->table . '.' : null) . (!empty($this->column) ? $this->column : $name);
     return $query->whereNotNull($column)->where($column, '!=', '');
 }
开发者ID:czim,项目名称:laravel-filter,代码行数:14,代码来源:NotEmpty.php


注:本文中的Illuminate\Database\Eloquent\Builder::whereNotNull方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。