input('email'); $status = $request->input('status'); $query = ReferralApply::with('user:id,email'); if (isset($email)) { $query->whereHas('user', static function ($q) use ($email) { $q->where('email', 'like', '%'.$email.'%'); }); } if ($status) { $query->whereStatus($status); } return view('admin.aff.index', ['applyList' => $query->latest()->paginate(15)->appends($request->except('page'))]); } // 提现申请详情 public function detail(Request $request, ReferralApply $aff) { return view('admin.aff.detail', [ 'referral' => $aff->load('user:id,email'), 'commissions' => $aff->referral_logs()->with(['invitee:id,email', 'order.goods:id,name'])->paginate()->appends($request->except('page')), ]); } // 设置提现申请状态 public function status(Request $request) { header('Access-Control-Allow-Origin: *'); header('Access-Control-Allow-Headers: Origin, X-Requested-With, Content-Type, Accept'); //$status = (int) $request->validate(['status' => 'required|numeric']); $status = $request->input('status'); $id = $request->input('id'); $query = ReferralApply::query(); //return response()->json(['status' => 'success', 'message' => $status]); //return response()->json(['status' => 'update', 'message' => ]); if ($query->where('id',$id )->update(['status' => $status])) { // 审核申请的时候将关联的 if ($status == 1 || $status == 2) { $nod = $query->where('id',$id )->get(); foreach ($nod as $nn) { $nn->referral_logs()->update(['status' => $status]); } } } return response()->json(['status' => 'success', 'message' => 'success']); } // 用户返利流水记录 public function rebate(Request $request) { $invitee_email = $request->input('invitee_email'); $inviter_email = $request->input('inviter_email'); $status = $request->input('status'); $query = ReferralLog::with(['invitee:id,email', 'inviter:id,email'])->orderBy('status')->latest(); if (isset($invitee_email)) { $query->whereHas('invitee', static function ($q) use ($invitee_email) { $q->where('email', 'like', '%'.$invitee_email.'%'); }); } if (isset($inviter_email)) { $query->whereHas('inviter', static function ($q) use ($inviter_email) { $q->where('email', 'like', '%'.$inviter_email.'%'); }); } if (isset($status)) { $query->whereStatus($status); } return view('admin.aff.rebate', ['referralLogs' => $query->paginate(15)->appends($request->except('page'))]); } }