all(); $query = Comment::query(); /*提问人过滤*/ if( isset($filter['user_id']) && $filter['user_id'] > 0 ){ $query->where('user_id','=',$filter['user_id']); } /*问题标题过滤*/ if( isset($filter['word']) && $filter['word'] ){ $query->where('content','like', '%'.$filter['word'].'%'); } /*提问时间过滤*/ if( isset($filter['date_range']) && $filter['date_range'] ){ $query->whereBetween('created_at',explode(" - ",$filter['date_range'])); } /*问题状态过滤*/ if( isset($filter['status']) && $filter['status'] > -1 ){ $query->where('status','=',$filter['status']); } $comments = $query->orderBy('created_at','desc')->paginate(20); return view("admin.comment.index")->with('comments',$comments)->with('filter',$filter); } /** * Show the form for creating a new resource. * * @return \Illuminate\Http\Response */ public function create() { // } /** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { // } /** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($id) { // } /** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { $comment = Comment::find($id); if(!$comment){ abort(404); } return view('admin.comment.edit')->with('comment',$comment); } /** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $id) { $comment = Comment::find($id); $comment->content = $request->input('content'); $comment->save(); return $this->success(route('admin.comment.index'),'评论修改成功'); } /*评论审核*/ public function verify(Request $request) { $commnetIds = $request->input('id'); Comment::whereIn('id',$commnetIds)->update(['status'=>1]); return $this->success(route('admin.comment.index').'?status=0','评论审核成功'); } /** *删除评论内容 * * @param int $id * @return \Illuminate\Http\Response */ public function destroy(Request $request) { Comment::destroy($request->input('id')); return $this->success(route('admin.comment.index'),'评论删除成功'); } }