input('user_id'); $email = $request->input('email'); $status = $request->input('status'); $query = UserSubscribe::with(['user:id,email']); if(isset($user_id)){ $query->whereUserId($user_id); } if(isset($email)){ $query->whereHas('user', static function($q) use ($email) { $q->where('email', 'like', '%'.$email.'%'); }); } if(isset($status)){ $query->whereStatus($status); } $view['subscribeList'] = $query->latest()->paginate(20)->appends($request->except('page')); return view('admin.subscribe.subscribeList', $view); } //订阅记录 public function subscribeLog(Request $request) { $id = $request->input('id'); $query = UserSubscribeLog::with('user:email'); if(isset($id)){ $query->whereUserSubscribeId($id); } $view['subscribeLog'] = $query->latest()->paginate(20)->appends($request->except('page')); return view('admin.subscribe.subscribeLog', $view); } // 设置用户的订阅的状态 public function setSubscribeStatus(Request $request): JsonResponse { $id = $request->input('id'); $status = $request->input('status', 0); if(empty($id)){ return Response::json(['status' => 'fail', 'message' => '操作异常']); } if($status){ UserSubscribe::find($id)->update(['status' => 1, 'ban_time' => null, 'ban_desc' => '']); }else{ UserSubscribe::find($id)->update(['status' => 0, 'ban_time' => time(), 'ban_desc' => '后台手动封禁']); } return Response::json(['status' => 'success', 'message' => '操作成功']); } }