本文实例讲述了laravel 框架结合关联查询 when()用法。分享给大家供大家参考，具体如下：
?
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
|
$name = $request->get('name'); //活动标题
$start_time = $request->get('start_time'); //活动开始时间
$user_name = $request->get('user_name'); //发布者
$limit = (int) $request->get('limit', 15);
$offset = (int) $request->get('offset', 0);
$data=ActiveJieSuan::with(['user' => function ($query) {$query->select('id','name');},
'active'=> function ($query) {$query->select('id','name','start');}])
->when($name, function ($query) use ($name) {
return $query->whereHas('active', function ($query) use ($name) {
return $query->where('name', 'like', '%'.$name.'%');
});
})
->when($user_name, function ($query) use ($user_name) {
return $query->whereHas('user', function ($query) use ($user_name) {
return $query->where('name', 'like', '%'.$user_name.'%');
});
})
->when($start_time, function ($query) use ($start_time) {
return $query->whereHas('active', function ($query) use ($start_time) {
return $query->where('start', '>=', $start_time);
});
})
->limit($limit)
->offset($offset)
->orderBy('id', 'desc')
->paginate()->toArray();
|
源代码路径： D:\\phpStudy\\WWW\\faceke\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Concerns\\BuildsQueries.php
?
|
1
2
3
4
5
6
7
|
public function when($value, $callback, $default = null)
{
if ($value) { return $callback($this, $value) ?: $this;
} elseif ($default) {
return $default($this, $value) ?: $this;
} return $this;
}
|
