本文整理匯總了PHP中Illuminate\Database\Query\Builder::whereExists方法的典型用法代碼示例。如果您正苦於以下問題：PHP Builder::whereExists方法的具體用法？PHP Builder::whereExists怎麽用？PHP Builder::whereExists使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Illuminate\Database\Query\Builder的用法示例。
在下文中一共展示了Builder::whereExists方法的4個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: applyFilterConstraint
/**
* {@inheritdoc}
*/
public function applyFilterConstraint(QueryBuilder $builder, $data)
{
if (empty($data)) {
return;
}
$builder->whereExists(function ($q) use($data) {
$this->initNestedQuery($q, $this->parseData($data));
});
}示例2: whereExists
/**
* Add an exists clause to the query.
*
* @param \Closure $callback
* @param string $boolean
* @param bool $not
* @return $this
* @static
*/
public static function whereExists($callback, $boolean = 'and', $not = false)
{
return \Illuminate\Database\Query\Builder::whereExists($callback, $boolean, $not);
}示例3: scopeWithPermission
/**
* Select users which have the required permission
* @param \Illuminate\Database\Query\Builder $query
* @param string $permission Permission to check
*/
public function scopeWithPermission($query, $permission)
{
$query->whereExists(function ($query) use($permission) {
$query->select(DB::Raw('1'))->from('permission_role')->whereRaw('permission_role.role_id = users.role_id')->where('permission_role.permission_id', '=', function ($query) use($permission) {
$query->select('id')->from('permissions')->where('ime', '=', $permission);
});
});
}示例4: scopeWithUser
/**
*
* @param \Illuminate\Database\Query\Builder $query
* @param int $user_id
* @return \Illuminate\Database\Query\Builder
*/
public function scopeWithUser($query, $user_id)
{
return $query->whereExists(function ($query) use($user_id) {
$query->select(DB::Raw('1'))->from('predmet_user')->whereRaw('predmet_user.predmet_id = predmeti.id')->where('predmet_user.user_id', '=', $user_id);
});
}