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\JsonResponse;
use Illuminate\Http\Request;
use Response;

/**
 * 推广控制器
 *
 * Class AffiliateController
 *
 * @package App\Http\Controllers\Controller
 */
class AffiliateController extends Controller
{

    // 提现申请列表
    public function affiliateList(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);
        }

        $view['applyList'] = $query->latest()->paginate(15)->appends(
            $request->except('page')
        );

        return view('admin.affiliate.affiliateList', $view);
    }

    // 提现申请详情
    public function affiliateDetail(Request $request)
    {
        $view['basic']       = ReferralApply::with('user:id,email')->find(
            $request->input('id')
        );
        $view['commissions'] = [];
        if ($view['basic'] && $view['basic']->link_logs) {
            $view['commissions'] = ReferralLog::with(
                ['invitee:id,email', 'order.goods:id,name']
            )
                                              ->whereIn(
                                                  'id',
                                                  $view['basic']->link_logs
                                              )
                                              ->paginate(15)
                                              ->appends(
                                                  $request->except('page')
                                              );
        }

        return view('admin.affiliate.affiliateDetail', $view);
    }

    // 设置提现申请状态
    public function setAffiliateStatus(Request $request): JsonResponse
    {
        $id     = $request->input('id');
        $status = $request->input('status');

        $ret = ReferralApply::whereId($id)->update(['status' => $status]);
        if ($ret) {
            // 审核申请的时候将关联的
            $referralApply = ReferralApply::findOrFail($id);
            if ($referralApply && $status == 1) {
                ReferralLog::whereIn('id', $referralApply->link_logs)->update(
                    ['status' => 1]
                );
            } elseif ($referralApply && $status == 2) {
                ReferralLog::whereIn('id', $referralApply->link_logs)->update(
                    ['status' => 2]
                );
            }
        }

        return Response::json(['status' => 'success', 'message' => '操作成功']);
    }

    // 用户返利流水记录
    public function userRebateList(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);
        }

        $view['list'] = $query->paginate(15)->appends($request->except('page'));

        return view('admin.affiliate.userRebateList', $view);
    }

}