php/app/controller/api/Test.php

<?php

namespace app\controller\api;
use app\common\dao\shared\SharedProsperityUserDao;
use app\common\model\shared\SharedProsperityUser;
use app\common\repositories\shared\SharedProsperityUserRepository;
use app\common\repositories\user\UserRepository;
use app\traits\GzcApiRequest;
use think\facade\Db;

class Test
{
    public function test()
    {

        $total = 8497.13;
        $map = [
            1=>0.3,
            2=>0.15,
            3=>0.03,
            4=>0.008,
        ];
        $groupMap = [
            1=>0.05,
            2=>0.1
        ];

        $users = Db::name('shared_prosperity_user')->group('partner_level')->field('partner_level,count(*) as num')->select()->toArray();

        $res = [];
        foreach ($users as $user) {
            if ($user['partner_level'] == 0 || $user['partner_level'] == 5) {
                continue;
            }
            $res[$user['partner_level']] = [
                'num' => $user['num'],
                'money' => $total * $map[$user['partner_level']] / $user['num']
            ];
        }

        $groupRes = [];
        $groupUsers = Db::name('shared_prosperity_group_user')->group('group_id')->field('group_id,count(*)as num')->select()->toArray();
        foreach ($groupUsers as $groupUser) {
            $groupRes[$groupUser['group_id']] = [
                'num' => $groupUser['num'],
                'money' => $total * $groupMap[$groupUser['group_id']] / $groupUser['num']
            ];
        }
        dd($res,$groupRes);


        // 18201226770 4858下的单  改成   13716268932 5064下单

        // 上下级关系正确

        // 订单所属已修改

        // 订单产生的共富奖励已修改

        // 佣金修改















        // 查询团队业绩
        // $ids = [
        //     1213
        // ];
        // $res = [];
        // foreach ($ids as $id) {
        //     /** @var SharedProsperityUserDao $dao */
        //     $dao = app()->make(SharedProsperityUserDao::class);
        //     $userIds = $dao->getAllSubordinateUserIds($id,true,5);
        //     /** @var SharedProsperityUser $model */
        //     $sum = SharedProsperityUser::getDB()
        //         ->whereIn('user_id', $userIds)
        //         ->sum('pv');
        //     $res[$id] = $sum;
        // }
        // dd($res);


        // /** @var SharedProsperityUserRepository $userRepository */
        // $userRepository = app()->make(SharedProsperityUserRepository::class);
        // $list = $userRepository->getUserTree(2393);
        // var_dump(json_encode($list));
        $field = request()->param('field');
        /** @var UserRepository $userRepository */
        $userRepository = app()->make(UserRepository::class);
        $list = $userRepository->getUserForTree($field,0);
        var_dump(json_encode($list));
        // return app('json')->success($list);
    }
}