AffiliateController.php 3.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108
  1. <?php
  2. namespace App\Http\Controllers\Admin;
  3. use App\Http\Controllers\Controller;
  4. use App\Models\ReferralApply;
  5. use App\Models\ReferralLog;
  6. use Illuminate\Http\JsonResponse;
  7. use Illuminate\Http\Request;
  8. use Response;
  9. /**
  10. * 推广控制器
  11. *
  12. * Class AffiliateController
  13. *
  14. * @package App\Http\Controllers\Controller
  15. */
  16. class AffiliateController extends Controller
  17. {
  18. // 提现申请列表
  19. public function index(Request $request)
  20. {
  21. $email = $request->input('email');
  22. $status = $request->input('status');
  23. $query = ReferralApply::with('user:id,email');
  24. if (isset($email)) {
  25. $query->whereHas('user', static function ($q) use ($email) {
  26. $q->where('email', 'like', '%'.$email.'%');
  27. });
  28. }
  29. if ($status) {
  30. $query->whereStatus($status);
  31. }
  32. $view['applyList'] = $query->latest()->paginate(15)->appends($request->except('page'));
  33. return view('admin.aff.index', $view);
  34. }
  35. // 提现申请详情
  36. public function detail(Request $request, $id)
  37. {
  38. $view['basic'] = ReferralApply::with('user:id,email')->find($id);
  39. $view['commissions'] = [];
  40. if ($view['basic'] && $view['basic']->link_logs) {
  41. $view['commissions'] = ReferralLog::with(['invitee:id,email', 'order.goods:id,name'])
  42. ->whereIn('id', $view['basic']->link_logs)
  43. ->paginate(15)
  44. ->appends($request->except('page'));
  45. }
  46. return view('admin.aff.detail', $view);
  47. }
  48. // 设置提现申请状态
  49. public function setStatus(Request $request): JsonResponse
  50. {
  51. $id = $request->input('id');
  52. $status = (int) $request->input('status');
  53. $ret = ReferralApply::whereId($id)->update(['status' => $status]);
  54. if ($ret) {
  55. // 审核申请的时候将关联的
  56. $referralApply = ReferralApply::findOrFail($id);
  57. if ($referralApply && $status === 1) {
  58. ReferralLog::whereIn('id', $referralApply->link_logs)->update(['status' => 1]);
  59. } elseif ($referralApply && $status === 2) {
  60. ReferralLog::whereIn('id', $referralApply->link_logs)->update(['status' => 2]);
  61. }
  62. }
  63. return Response::json(['status' => 'success', 'message' => '操作成功']);
  64. }
  65. // 用户返利流水记录
  66. public function rebate(Request $request)
  67. {
  68. $invitee_email = $request->input('invitee_email');
  69. $inviter_email = $request->input('inviter_email');
  70. $status = $request->input('status');
  71. $query = ReferralLog::with(['invitee:id,email', 'inviter:id,email'])->orderBy('status')->latest();
  72. if (isset($invitee_email)) {
  73. $query->whereHas('invitee', static function ($q) use ($invitee_email) {
  74. $q->where('email', 'like', '%'.$invitee_email.'%');
  75. });
  76. }
  77. if (isset($inviter_email)) {
  78. $query->whereHas('inviter', static function ($q) use ($inviter_email) {
  79. $q->where('email', 'like', '%'.$inviter_email.'%');
  80. });
  81. }
  82. if (isset($status)) {
  83. $query->whereStatus($status);
  84. }
  85. $view['list'] = $query->paginate(15)->appends($request->except('page'));
  86. return view('admin.aff.rebate', $view);
  87. }
  88. }