';
            echo  '错误:' . $e->getMessage() . PHP_EOL . ',文件:' . $e->getFile() . PHP_EOL . '行号:'. $e->getLine();
            DB::rollBack();
            return false;
        }
    }

    /**
     * 余额兑换积分奖励(加速释放)
     *
     * @param app\common\model\User $user 用户模型
     * @param float $exchange_qty 兑换数量
     */
    public static function exchangeReward($user, $exchange_qty)
    {
        $path = UserDAO::getParentsPathDesc($user, 20);
        //array_shift($path); //删除直推上级
        if (count($path) < 1) {
            return false;
        }
        DB::beginTransaction();
        foreach ($path as $key => $value) {
            $fact_ratio = 0;
            $current_generations = $key + 1; //因为key从0开始所以加1;
            $parent = Users::find($value);
            //取当前被触发用户的级别
            $parent_level = $parent->level->code;
            if ($parent_level <= 1) {
                //普通会员不享受动态奖
                continue;
            }
            //根据代数来决定比例
            $can_generations = $parent->level->generations['exchange'];
            if ($can_generations < $current_generations) {
                //当前被触发人级别不能拿超过自己级别对应的代数
                continue;
            }
            if ($parent_level == 2 && $current_generations == 1) {
                //直推奖：根据直推人数来决定比例
                $children_qty = Users::where('parent_id', $value)->count();
                $children_qty || $children_qty = 0;
                $exchange_recommend_ratio = Setting::getValueByKey('exchange_recommend_ratio');
                $exchange_recommend_ratio = empty($exchange_recommend_ratio) ? [] : unserialize($exchange_recommend_ratio);
                $fact_ratio = self::getDataByRangeValue($exchange_recommend_ratio, $children_qty);
            } else {
                $ratio = Setting::getValueByKey('exchange_generations_ratio'); //取每一代对应的比例
                $ratio = empty($ratio) ? [] : unserialize($ratio);
                $fact_ratio = self::getDataByRangeValue($ratio, $current_generations);
            }   
            $fact_reward_qty = round($exchange_qty * $fact_ratio / 100, 5);
            //奖励不能超过积分
            $before_integral = $parent->integral;
            $before_integral < $fact_reward_qty && $fact_reward_qty = $parent->integral;
            if ($fact_reward_qty == 0) {
                continue;
            }
            try {
                $result = release_user_integral($parent, $fact_reward_qty, AccountLog::BALANCE_EXCHANGE_INTEGRAL_REWARD, '余额兑换积分奖励:');
                if (!$result) {
                    throw new \Exception('释放积分到余额失败');
                }
            } catch (\Exception $e) {
                echo '
';
                echo  '错误:' . $e->getMessage() . PHP_EOL . ',文件:' . $e->getFile() . PHP_EOL . '行号:'. $e->getLine();
                DB::rollback();
                return false;
            }
        }
        DB::commit();
        return true;
    }

    /**
     * 余额增加奖励(转入加速释放)
     *
     * @param app\common\model\User $user 用户模型
     * @param float $add_qty 兑换数量
     * @return bool 成功返回真，否则假
     */
    public static function balanceAddReward($user, $add_qty)
    {
        $path = UserDAO::getParentsPathDesc($user, 20);
        if (count($path) < 1) {
            return false;
        }
        DB::beginTransaction();
        foreach ($path as $key => $value) {
            $fact_ratio = 0;
            $current_generations = $key + 1; //因为key从0开始所以加1;
            $parent = Users::find($value);
            //取当前被触发用户的级别
            $parent_level = $parent->level->code;
            if ($parent_level <= 1) {
                //普通会员不享受动态奖
                continue;
            } 
            $can_generations = $parent->level->generations['balance_add'];
            if ($can_generations < $current_generations) {
                //当前被触发人级别不能拿超过自己级别对应的代数
                continue;
            }
            if ($parent_level == 2 && $current_generations == 1) {
                //直推奖：根据直推人数来决定比例
                $children_qty = Users::where('parent_id', $value)->count();
                $children_qty || $children_qty = 0;
                $balanceadd_recommend_ratio = Setting::getValueByKey('balanceadd_recommend_ratio');
                $balanceadd_recommend_ratio = empty($balanceadd_recommend_ratio) ? [] : unserialize($balanceadd_recommend_ratio);
                $fact_ratio = self::getDataByRangeValue($balanceadd_recommend_ratio, $children_qty);
            } else {
                //根据代数来决定比例
                $ratio = Setting::getValueByKey('balanceadd_generations_ratio'); //取每一代对应的比例
                $ratio = empty($ratio) ? [] : unserialize($ratio);
                $fact_ratio = self::getDataByRangeValue($ratio, $current_generations);
            }
            $fact_reward_qty = round($add_qty * $fact_ratio / 100, 5);
            //奖励不能超过积分
            $before_integral = $parent->integral;
            $before_integral < $fact_reward_qty && $fact_reward_qty = $parent->integral;
            if ($fact_reward_qty == 0) {
                continue;
            }
            try {
                $result = release_user_integral($parent, $fact_reward_qty, AccountLog::TRANSFER_IN_PARENTS_REWARD_INTEGRAL, '余额转入奖励:');
                if (!$result) {
                    throw new \Exception('释放积分到余额失败');
                }
            } catch (\Exception $e) {
                echo '
';
                echo  '错误:' . $e->getMessage() . PHP_EOL . ',文件:' . $e->getFile() . PHP_EOL . '行号:'. $e->getLine();
                DB::rollback();
                return false;
            }
        }
        DB::commit();
        return true;
    }

    /**
     * 余额减少奖励(转出加速释放)
     *
     * @param app\common\model\User $user 用户模型
     * @param float $sub_qty 兑换数量
     * @return bool 成功返回真，否则假
     */
    public static function balanceSubReward($user, $sub_qty)
    {
        $parents = UserDAO::getParentsPathDesc($user, 15);//查询用户的指定代数的上级(根据parents_path信息),$qty 要取的上级代数,不传或传null则取全部
        if (count($parents) < 1) {
            return false;
        }
        $fact_ratio = Setting::getValueByKey('balance_sub_ratio');
        DB::beginTransaction();
        foreach ($parents as $key => $value) {
            $current_generations = $key + 1; //因为key从0开始所以加1;
            $parent = Users::find($value);
            //取当前被触发用户的级别
            $parent_level = $parent->level->code;
            $can_generations = $parent->level->generations['balance_sub'];
            if ($parent_level <= 1 || $can_generations < $current_generations) {
                //普通会员不享受动态奖
                continue;
            }
            $fact_reward_qty = round($sub_qty * $fact_ratio / 100, 5);
            if ($fact_reward_qty == 0) {
                continue;
            }
            try {
                $result = change_user_money($parent, 2, $fact_reward_qty, AccountLog::TRANSFER_OUT_PARENTS_REWARD_INTEGRAL, '余额减少上级奖励-增加积分');
                if ($result !== true) {
                    throw new \Exception('奖励积分失败(余额转出上级奖励)'. $result);
                }
            } catch (\Exception $e) {
                DB::rollback();
                return false;
            }
        }
        DB::commit();
        return true;
    }

    /**
     * 平级余额减少奖励积分(暂且只有转出)
     *
     * @param app\common\model\User $user 转出用户模型
     * @param float $qty 数量
     */
    public static function equalLevelReward($user, $qty)
    {
        $parents = UserDAO::getParentsPathDesc($user);
        if (count($parents) < 1) {
            return false;
        }
        $userlevel = $user->level->code;
        $fact_ratio = Setting::getValueByKey('equal_level_ratio');
        DB::beginTransaction();
        foreach ($parents as $key => $value) {
            $current_generations = $key + 1;
            //取当前被触发用户的级别
            $parent = Users::find($value);
            $parent_level = $parent->level->code;
            $can_generations = $parent->level->generations['equal_level'];
            if ($parent_level <= 1 || $can_generations < $current_generations || $userlevel != $parent_level) {
                //当前被触发人级别不能拿超过自己级别对应的代数,或者不是平级
                continue;
            }
            $fact_reward_qty = round($qty * $fact_ratio / 100, 4);
            try {
                $result = change_user_money($parent, 2, $fact_reward_qty, AccountLog::TRANSFER_OUT_EQUALLEVEL_REWARD_INTEGRAL, '余额减少平级奖励-增加积分');
                if ($result !== true) {
                    throw new \Exception('奖励积分失败(余额转出平级奖励):' . $result);
                }
            } catch (\Exception $e) {
                DB::rollback();
                return false;
            }
        }
        DB::commit();
        return true;
    }
}