本文整理汇总了PHP中Illuminate\Database\Eloquent\Builder::whereNested方法的典型用法代码示例。如果您正苦于以下问题:PHP Builder::whereNested方法的具体用法?PHP Builder::whereNested怎么用?PHP Builder::whereNested使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Illuminate\Database\Eloquent\Builder
的用法示例。
在下文中一共展示了Builder::whereNested方法的3个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: build
public function build(Builder $query)
{
$text = $this->title;
return $query->whereNested(function (QueryBuilder $query) use($text) {
return $query->where('title', 'like', "%{$text}%")->orWhere('description', 'like', "%{$text}%");
});
}
示例2: apply
/**
* @param \Illuminate\Database\Query\Builder|\Illuminate\Database\Eloquent\Builder $query
*
* @return void
*/
public function apply($query)
{
$query->where(function ($query) {
$logic = $this->logic === static::LOGIC_AND ? 'and' : 'or';
foreach ($this->criteria as $criteria) {
$query->whereNested(function ($query) use($criteria) {
$criteria->apply($query);
}, $logic);
}
});
}
示例3: buildWheres
/**
* @param Builder|QueryBuilder $queryBuilder
* @param array $wheres
* @param string $boolean
*/
protected function buildWheres($queryBuilder, array $wheres, $boolean = 'and')
{
foreach ($wheres as $whereField => $where) {
if (!isset($whereField) || !isset($where)) {
continue;
}
$whereField = strtolower($whereField);
// Nested OR where
// Example: 'or' => ['foo' => 'bar', 'x => 'y']
if ($whereField === 'or') {
$queryBuilder->whereNested(function ($queryBuilder) use($where) {
$this->buildWheres($queryBuilder, $where, 'or');
}, $boolean);
continue;
}
// Nested AND where
// Example: 'and' => ['foo' => 'bar', 'x => 'y']
if ($whereField === 'and') {
$queryBuilder->whereNested(function ($queryBuilder) use($where) {
$this->buildWheres($queryBuilder, $where, 'and');
}, $boolean);
continue;
}
// Operator is present on query
// Example: 'foo' => ['like' => '%bar%']
if (is_array($where)) {
foreach ($where as $whereOperator => $whereValue) {
$whereOperator = $this->parseOperator($whereOperator);
$this->buildWhere($queryBuilder, $whereField, $whereOperator, $whereValue, $boolean);
}
continue;
}
// Operator is omitted on query, assumes '='
// Example: 'foo' => 'bar'
$whereOperator = is_array($where) ? array_keys($where)[0] : '=';
$whereValue = is_array($where) ? $where[$whereOperator] : $where;
$whereOperator = $this->parseOperator($whereOperator);
$this->buildWhere($queryBuilder, $whereField, $whereOperator, $whereValue, $boolean);
}
}