video_server/app/Repositories/RebateOrderRepository.php

<?php

namespace App\Repositories;

use App\Model\RebateOrderMmdel;
use Hyperf\Database\Model\Builder;
use KZ2\Repositories\Model\Repository;

class RebateOrderRepository extends Repository
{

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

    /**
     * 获取用户业绩
     *
     * @param $userId
     * @return int|mixed|string|void
     */
    public function sumUserTotalPerf($userId)
    {
        $perfAmount = RebateOrderMmdel::where('uid', $userId)->sum('perf_amount');

        return (int)$perfAmount;
    }

    /**
     * 关联用户业绩求和
     *
     * @param $userId
     * @return int|mixed|string|void
     */
    public function userGradeRerf($userId)
    {
        $rebate = RebateOrderMmdel::selectRaw('rebate_level, ROUND(sum(perf_amount), 2) as perf_amount')->where('uid', $userId)->groupBy('rebate_level')->orderBy('rebate_level')->get();
        $res = [1 => 0, 2 => 0, 3 => 0, 4 => 0];
        if ($rebate->isNotEmpty()) {
            foreach ($rebate as $item) {
                $res[$item['rebate_level']] = $item['perf_amount'];
            }
        }

        return json_encode($res);
    }
}