lachang/app/console/model/user/CommissionSteps.php

<?php
// +----------------------------------------------------------------------
// | 萤火商城系统 [ 致力于通过产品和服务，帮助商家高效化开拓市场 ]
// +----------------------------------------------------------------------
// | Copyright (c) 2017~2021 https://www.yiovo.com All rights reserved.
// +----------------------------------------------------------------------
// | Licensed 这不是一个自由软件，不允许对程序代码以任何形式任何目的的再发行
// +----------------------------------------------------------------------
// | Author: 萤火科技 <admin@yiovo.com>
// +----------------------------------------------------------------------
declare (strict_types = 1);

namespace app\console\model\user;

use app\common\model\user\CommissionSteps as CommissionsStepsModel;

/**
 * 待结算分佣明细模型
 * Class Store
 * @package app\store\model
 */
class CommissionSteps extends CommissionsStepsModel
{
    /**
     * 根据销售额获取奖励金比例
     * @param $shopId
     * @param $role
     * @param $saleVolume
     * @return int|mixed
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     */
    public static function getShopRoleSteps($shopId,$role,$saleVolume){
        $data =  self::where('shop_id',$shopId)->where('role',$role)->order('sale_amount','desc')
            ->field('sale_amount,bonus_ratio,step')->select();
        $bonusRatios =  $data?$data->toArray():[];
        $bonusRate = ['bonus_ratio'=>0,'bonus_ladder'=>0];
        if (count($bonusRatios)){
            foreach ($bonusRatios as $ratio){
                if($saleVolume >= $ratio['sale_amount']){
                    $bonusRate =  ['bonus_ratio'=>$ratio['bonus_ratio'],'bonus_ladder'=>$ratio['step']];
                    break;
                }
            }
        }
        return  $bonusRate;
    }

}