Laravel可选WHERE子句
问题描述:
有没有办法实现的可选凡在Laravel,这是我的查询Laravel可选WHERE子句
$people = \App\people::query()
-> select ('people.name', 'people.username', 'price', 'service','people.city', 'people.streetaddress', 'people.postalcode', DB::raw("GROUP_CONCAT(DATE_FORMAT(datetime, '%H:%i')) as times"))
-> groupBy('people')
-> leftjoin ('services' , 'people.id', '=', 'services.people_id')
-> leftjoin ('imagesforpeople' , 'people.id', '=', 'imagesforpeople.people_id')
-> whereDate ('datetime', '=', $request->get('date'))
-> whereTime ('datetime', '=', $request->get('time'))
-> get();
在这里,我想此行是可选的
-> whereTime ('datetime', '=', $request->get('time'))
因此,如果搜索不包含时间,它会完全忽略这一行的查询。
whereDate是必需的,但whereTime不是必需的。如果获得时间请求,它将查询时间,但如果未获取时间请求,它将忽略whereTime查询,并仅显示whereDate的结果。
如何在Laravel中实现此目标?
答
按https://laravel.com/docs/5.3/queries#conditional-clauses
->when($request->get('time'), function($query) use ($request) {
$query->whereTime('datetime', '=', $request->get('time'));
})
答
您可以使用'when'方法。阅读上在这里:https://laravel.com/docs/5.5/queries#conditional-clauses
$people = \App\people::query()
-> select ('people.name', 'people.username', 'price', 'service','people.city', 'people.streetaddress', 'people.postalcode', DB::raw("GROUP_CONCAT(DATE_FORMAT(datetime, '%H:%i')) as times"))
-> groupBy('people')
-> leftjoin ('services' , 'people.id', '=', 'services.people_id')
-> leftjoin ('imagesforpeople' , 'people.id', '=', 'imagesforpeople.people_id')
-> whereDate ('datetime', '=', $request->get('date'))
-> when($request->get('time'), function($query) use($request) {
$query->where('datetime', '=', $request->get('time')
})-> get();
+0
这可能是正确的方法,但你应该提供一个例子 – apokryfos
答
简单的事情是:
$peopleQuery = \App\people::query()
-> select ('people.name', 'people.username', 'price', 'service','people.city', 'people.streetaddress', 'people.postalcode', DB::raw("GROUP_CONCAT(DATE_FORMAT(datetime, '%H:%i')) as times"))
-> groupBy('people')
-> leftjoin ('services' , 'people.id', '=', 'services.people_id')
-> leftjoin ('imagesforpeople' , 'people.id', '=', 'imagesforpeople.people_id')
-> whereDate ('datetime', '=', $request->get('date'));
if ($request->has("time")) {
$peopleQuery->whereTime ('datetime', '=', $request->get('time'));
}
$people = $peopleQuery->get();
你可以把它分解成过滤HTTP:// laraveltnt。 com/conditional-eloquent-clause/ – prola