If request is not null语句in Eloquent

Question

如果请求存在，如何在查询中执行语句？示例：$request->type (如果为空，则到处搜索，如果不为，则仅检查到达的文件)

$flights = App\Flight::where('active', 1)
               ->orderBy('name', 'desc')
               ->if($requst->type = NULL) return all; else { ->where('type', $request->type)
               ->get();

感谢您的帮助！:)

Answer 1

您可以像这样拆分重新设计查询的代码

$flights = App\Flight::where('active', 1)
               ->orderBy('name', 'desc');
if($requst->type != NULL) {
    $flights = $flights->where('type', $request->type);
}
return $flights->get();