getBoss方法只查询有效上级信息

yujian

2019-09-02 9eeda0d3049b71877c373c04d65533939b5582ef

getBoss方法只查询有效上级信息

 fanli/src/main/java/com/yeshi/fanli/mapping/ThreeSaleMapper.xml

@@ -61,13 +61,11 @@



    <select id="selectBoss"
        resultMap="com.yeshi.fanli.dao.mybatis.UserInfoMapper.BaseResultMap"
        parameterType="java.lang.Long">
        select
        u.*
        from yeshi_ec_threeSale s left join
        yeshi_ec_user u on u.id=s.boss_id where worker_id = #{0}
    <select id="selectBoss"    resultMap="com.yeshi.fanli.dao.mybatis.UserInfoMapper.BaseResultMap" parameterType="java.lang.Long">
        select u.* from yeshi_ec_threeSale s 
        left join yeshi_ec_user u on u.id=s.boss_id 
        where s.state = 1  AND s.worker_id = #{0}
        LIMIT 1
    </select>



 fanli/src/main/java/com/yeshi/fanli/service/impl/hongbao/ThreeSaleSerivceImpl.java

@@ -81,7 +81,6 @@
    private TaskExecutor executor;



    public UserInfo getBoss(final long uid) {

        //TODO 有bug

        return threeSaleMapper.selectBoss(uid);

    }