video_server/app/Repositories/CommissionRulesRepository.php

<?php

namespace App\Repositories;

use App\Model\CommissionRulesModel;
use KZ2\Repositories\Model\Repository;

class CommissionRulesRepository extends Repository
{

    public function model()
    {
        return CommissionRulesModel::class;
    }

    /**
     * 获取等级内 最高返佣比
     *
     * @param $userLevel
     * @return \Hyperf\Utils\HigherOrderTapProxy|\Illuminate\Support\HigherOrderTapProxy|mixed|void
     */
    public function getLevelMaxRebateRatio($userLevel, $perfTotal)
    {
        $ruleData = CommissionRulesModel::where('grade', $userLevel)->orderBy('max_perf', 'desc')->get();

        $rebateRatio = 0;
        foreach ($ruleData as $val) {
            if ($perfTotal > $val['min_perf'] && $perfTotal <= $val['max_perf']) {
                $rebateRatio = $val['rebate_ratio'];
            }
        }
        return $rebateRatio * 100;
    }
}