has('created_at_start') && !$request->has('created_at_end') && !$request->has('class') && !$request->has('method') && !$request->has('description') && !$request->has("is_exception") ) { $logs = Log::query() ->with('user:id,name') ->orderBy('id', 'desc') ->paginate(50); return view('maintenance.log.index', ['logs' => $logs]); } //不传开始时间提示错误信息并返回 if (!$request->has('created_at_start')) { session()->flash('warning', '请选择开始时间'); return view('maintenance.log.index', ['logs' => null]); } $query = Log::query()->with('user:id,name'); if ($request->has('class')) { $query->where('class', 'like', $request['class'] . '%'); } if ($request->has('method')) { $query->where('method', 'like', $request['method'] . '%'); } if ($request->has('description')) { $str = $request->description; $str = trim($str, '\\'); $str = str_replace('\\', '\\\\', $str); $query->where('description', 'like', '%' . $str . '%'); } if ($request->has('created_at_start')) { $query->where('created_at', '>=', $request->created_at_start." 00:00:00"); } if ($request->has('created_at_end')) { $query->where('created_at', '<=', $request->created_at_end." 23:59:59"); } if ($request->has("is_exception")){ $query->where(function(Builder $query){ $query->where("method","like","ERROR%")->orWhere("method","like","EXCEPTION%"); }); } $query->orderByDesc('id'); $logs = $query->with('user:id,name')->paginate($request->paginate??50); return view('maintenance.log.index', ['logs' => $logs]); } /** * Display the specified resource. * * @param Log $log * @return Application|\Illuminate\Contracts\View\Factory|Response|\Illuminate\View\View */ public function show(Log $log) { $log->loadMissing('user:id,name'); return view('maintenance.log.show', ['log' => $log]); } public function syncRedisLogs() { LogService::syncRedisLogs(); return redirect('maintenance/log'); } }