neiyou_user_web/app/Http/Controllers/Admin/AffiliateController.php

<?php

namespace App\Http\Controllers\Admin;

use App\Http\Controllers\Controller;
use App\Models\ReferralApply;
use App\Models\ReferralLog;
use Illuminate\Http\Request;
 
class AffiliateController extends Controller
{
    // 提现申请列表
    public function index(Request $request)
    {
        $email = $request->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'))]);
    }
}