SubscribeController.php 1.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778
  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. public function subscribeList(Request $request) {
  19. $user_id = $request->input('user_id');
  20. $email = $request->input('email');
  21. $status = $request->input('status');
  22. $query = UserSubscribe::with(['user:id,email']);
  23. if(isset($user_id)){
  24. $query->whereUserId($user_id);
  25. }
  26. if(isset($email)){
  27. $query->whereHas('user', static function($q) use ($email) {
  28. $q->where('email', 'like', '%'.$email.'%');
  29. });
  30. }
  31. if(isset($status)){
  32. $query->whereStatus($status);
  33. }
  34. $view['subscribeList'] = $query->latest()->paginate(20)->appends($request->except('page'));
  35. return view('admin.subscribe.subscribeList', $view);
  36. }
  37. //订阅记录
  38. public function subscribeLog(Request $request) {
  39. $id = $request->input('id');
  40. $query = UserSubscribeLog::with('user:email');
  41. if(isset($id)){
  42. $query->whereUserSubscribeId($id);
  43. }
  44. $view['subscribeLog'] = $query->latest()->paginate(20)->appends($request->except('page'));
  45. return view('admin.subscribe.subscribeLog', $view);
  46. }
  47. // 设置用户的订阅的状态
  48. public function setSubscribeStatus(Request $request): JsonResponse {
  49. $id = $request->input('id');
  50. $status = $request->input('status', 0);
  51. if(empty($id)){
  52. return Response::json(['status' => 'fail', 'message' => '操作异常']);
  53. }
  54. if($status){
  55. UserSubscribe::find($id)->update(['status' => 1, 'ban_time' => null, 'ban_desc' => '']);
  56. }else{
  57. UserSubscribe::find($id)->update(['status' => 0, 'ban_time' => time(), 'ban_desc' => '后台手动封禁']);
  58. }
  59. return Response::json(['status' => 'success', 'message' => '操作成功']);
  60. }
  61. }