165, 186 => 860 ]; foreach ($map as $uid => $money) { $bill = [ 'uid' => $uid, 'link_id' => 0, 'pm' => 1, 'title' => $title, 'category' => 'now_money', 'type' => 'commission', 'number' => $money, 'balance' => 0, 'mark' => $title, 'create_time' => date('Y-m-d H:i:s'), 'status' => 1, 'commission_type' => CommonEnum::COMMISSION_TYPE['SYSTEM_SUBSIDY_COMMISSION']['code'], 'order_sn' => 0, 'tripartite' => 0, 'type_shop' => 0, 'mer_id' => 0, 'source' => 0, 'order_type' => 1, 'is_red_brokerage' => 0, 'gzc' => 3, 'take_time' => time(), 'district_id' => '', 'street_id' => '', 'month' => '', ]; $a = Db::name('user_bill')->insert($bill); $b = Db::name('user')->where('uid', $uid)->inc('brokerage_price', $money)->update(); } die; $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); } }