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.index', $view); } //订阅记录 public function subscribeLog(Request $request, $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.log', $view); } // 设置用户的订阅的状态 public function setSubscribeStatus(Request $request, $id): JsonResponse { if (empty($id)) { return Response::json(['status' => 'fail', 'message' => '操作异常']); } $subscribe = UserSubscribe::find($id); if ($subscribe->status) { $subscribe->update(['status' => 0, 'ban_time' => time(), 'ban_desc' => '后台手动封禁']); } else { $subscribe->update(['status' => 1, 'ban_time' => null, 'ban_desc' => '']); } return Response::json(['status' => 'success', 'message' => '操作成功']); } }