SubscribeController.php 1.8 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667
  1. <?php
  2. namespace App\Http\Controllers\Admin;
  3. use App\Http\Controllers\Controller;
  4. use App\Models\UserSubscribe;
  5. use App\Models\UserSubscribeLog;
  6. use Illuminate\Http\Request;
  7. use Response;
  8. /**
  9. * 订阅控制器.
  10. *
  11. * Class SubscribeController
  12. */
  13. class SubscribeController extends Controller
  14. {
  15. // 订阅码列表
  16. public function index(Request $request)
  17. {
  18. $user_id = $request->input('user_id');
  19. $email = $request->input('email');
  20. $status = $request->input('status');
  21. $query = UserSubscribe::with(['user:id,email']);
  22. if (isset($user_id)) {
  23. $query->whereUserId($user_id);
  24. }
  25. if (isset($email)) {
  26. $query->whereHas('user', static function ($q) use ($email) {
  27. $q->where('email', 'like', '%'.$email.'%');
  28. });
  29. }
  30. if (isset($status)) {
  31. $query->whereStatus($status);
  32. }
  33. return view('admin.subscribe.index', ['subscribeList' => $query->latest()->paginate(20)->appends($request->except('page'))]);
  34. }
  35. //订阅记录
  36. public function subscribeLog($id)
  37. {
  38. $query = UserSubscribeLog::with('user:email');
  39. if (isset($id)) {
  40. $query->whereUserSubscribeId($id);
  41. }
  42. return view('admin.subscribe.log', ['subscribeLog' => $query->latest()->paginate(20)->appends(\request('page'))]);
  43. }
  44. // 设置用户的订阅的状态
  45. public function setSubscribeStatus(UserSubscribe $subscribe)
  46. {
  47. if ($subscribe->status) {
  48. $subscribe->update(['status' => 0, 'ban_time' => time(), 'ban_desc' => '后台手动封禁']);
  49. } else {
  50. $subscribe->update(['status' => 1, 'ban_time' => null, 'ban_desc' => '']);
  51. }
  52. return Response::json(['status' => 'success', 'message' => '操作成功']);
  53. }
  54. }