input('user_id'); $email = $request->input('email'); $status = $request->input('status'); $times = $request->input('times'); $starttime = $request->input('starttime'); $endtime = $request->input('endtime'); $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($times)){ $query->where('times','>',$times); } if (isset($starttime) && isset($endtime)) { $query->whereBetween('updated_at', [$starttime,$endtime]); } if (isset($status)) { $query->whereStatus($status); } return view('admin.subscribe.index', ['subscribeList' => $query->latest()->paginate(20)->appends($request->except('page'))]); } //订阅记录 public function subscribeLog($id) { $query = UserSubscribeLog::with('user:email'); if (isset($id)) { $query->whereUserSubscribeId($id); } $subscribeLogs = $query->latest()->paginate(20)->appends(\request('page')); foreach ($subscribeLogs as $log) { // 跳过上报多IP的 if ($log->request_ip) { $log->ipInfo = implode(' ', IP::getIPInfo($log->request_ip)); } } return view('admin.subscribe.log', ['subscribeLog' => $subscribeLogs]); } // 设置用户的订阅的状态 public function setSubscribeStatus(UserSubscribe $subscribe) { 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' => '操作成功']); } }