//后端 html表单
<form action="{{route('index')}}">
<input type="text" name="men" placeholder="人数">
<input type="text" name="abnormal" placeholder="异常人数">
<input type="text" name="mentwo" placeholder="人数2">
<input type="date" name="created_at" >
<input type="date" name="updated_at">
<input type="submit">
</form>
//接收数据
public function index(Request $request)
{
$men = $request->input('men');
$abnormal = $request->input('abnormal');
$mentwo = $request->input('mentwo');
$created_at = $request->input('created_at');
$updated_at = $request->input('updated_at');
//定义空数组
$append= [];
$data = Statistics::when($men, function ($query) use ($men, $append) {
$append[] = ['men', $men];
return $query->where('men', 'like', "%$men%");
})
->when($abnormal, function ($query) use ($abnormal,$append) {
$append[] = ['abnormal',$abnormal];
return $query->where('abnormal', 'like', "%$abnormal%");
})
->when($mentwo, function ($query) use ($mentwo, $append) {
$append[] = ['$mentwo', $mentwo];
return $query->where('mentwo', 'like', "%$mentwo%");
})
->when($created_at, function ($query) use ($created_at, $updated_at, $append{
$append[] = ['created_at', $created_at];
$append[] = ['updated_at', $updated_at];
return $query->whereDate('created_at', '>=', "$created_at")
->whereDate('updated_at', '<=', "$updated_at");
})
->get();
//返回页面
return view('index.index',compact('data'));
}
laravel8 使用when搜索
于 2022-06-09 19:37:04 首次发布