SubscribeController.php 2.1 KB

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