本文整理汇总了PHP中Builder::whereNull方法的典型用法代码示例。如果您正苦于以下问题:PHP Builder::whereNull方法的具体用法?PHP Builder::whereNull怎么用?PHP Builder::whereNull使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Builder
的用法示例。
在下文中一共展示了Builder::whereNull方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: scopeIsAccessible
/**
* Select only those forums the user has access to.
* WARNING: Creates JOINs with the forum_threads and the forums table.
*
* @param Builder $query The Eloquent Builder object
* @param User $user User model or null if it's the current client
* @return Builder
*/
public function scopeIsAccessible($query, $user = null)
{
$query->select('forum_posts.*')->join('forum_threads', 'forum_posts.thread_id', '=', 'forum_threads.id')->join('forums', 'forum_threads.forum_id', '=', 'forums.id');
if (!$user) {
$user = user();
}
if ($user) {
$internal = $user->hasAccess('internal');
$teamIds = DB::table('team_user')->whereUserId($user->id)->lists('team_id');
$teamIds[] = -1;
// Add -1 as team ID so the SQL statements (`team_id` in (...)) always has valid syntax
return $query->where('internal', '<=', $internal)->where(function ($query) use($teamIds) {
$query->whereNull('team_id')->orWhereIn('team_id', $teamIds);
});
} else {
return $query->whereInternal(0)->whereNull('team_id');
}
}
示例2: 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->whereNull($model->getQualifiedDeletedAtColumn());
$this->extend($builder);
}