修改关于包机组查询全部加入当当前用户uid>100时查询包机组，小于时（内置用户）则查询全部

whyclxw

2025-04-19 0784ab45a75fa0000579a2cab3ba0c31cab1cf4c

修改关于包机组查询全部加入当当前用户uid>100时查询包机组，小于时（内置用户）则查询全部

 src/main/java/com/whyc/service/BaojigroupService.java

@@ -142,7 +142,9 @@
        //查询当前人所在包机组
        QueryWrapper wrapper=new QueryWrapper();
        wrapper.select("baoji_id");
        wrapper.eq("uid",uid);
        if(uid>100){
            wrapper.eq("uid",uid);
        }
        List<BaojigroupUsr> usrList=bjUsrmapper.selectList(wrapper);
        if(usrList.size()==0){
            return new Response().setII(1,null,null,"当前用户未加入包机组");

 src/main/resources/mapper/BaojigroupLockMapper.xml

@@ -20,23 +20,30 @@
    <select id="getHomeStationAndLock" resultType="com.whyc.pojo.plus_user.BaojigroupLock">
        select distinct tb_baojigroup_lock.station_id,tb_baojigroup_lock.lock_id
        from plus_user.tb_baojigroup_lock,plus_user.tb_baojigroup_usr
        where
            tb_baojigroup_lock.baoji_id=tb_baojigroup_usr.baoji_id
          and tb_baojigroup_usr.uid=#{uid}
       <where>
           tb_baojigroup_lock.baoji_id=tb_baojigroup_usr.baoji_id
           <if test="uid>100">
               and tb_baojigroup_usr.uid=#{uid}
           </if>
       </where>
    </select>
    <select id="getLockIdByUid" resultType="java.lang.Integer">
        select distinct tb_baojigroup_lock.lock_id
        from plus_user.tb_baojigroup_lock,plus_user.tb_baojigroup_usr
        where
        <where>
            tb_baojigroup_lock.baoji_id=tb_baojigroup_usr.baoji_id
          and tb_baojigroup_usr.uid=#{uid}
        <if test="uid>100">
            and tb_baojigroup_usr.uid=#{uid}
        </if>
        </where>
    </select>
    <select id="getLocIdByStationidAndBjId" resultType="java.lang.Integer">
        select distinct tb_baojigroup_lock.lock_id
        from plus_user.tb_baojigroup_lock
        where
        <where>
            tb_baojigroup_lock.baoji_id=#{baojiId}
          and tb_baojigroup_lock.station_id=#{stationId}
        </where>
    </select>
    <select id="getLockList" resultType="com.whyc.pojo.plus_inf.LockInf">
        select distinct l.lock_id,l.lock_name,l.station_id,s.station_name

 src/main/resources/mapper/PermitGroupUserMapper.xml

@@ -18,8 +18,12 @@
    <select id="getItemList" resultType="java.lang.String">
        select  tb_user_permitgroup.permit_item_name
        from plus_user.tb_user_permitgroup,plus_user.tb_user_permitgroup_data
        where tb_user_permitgroup.permit_group_id=tb_user_permitgroup_data.permit_group_id
        and tb_user_permitgroup_data.uid=#{uid}
        <where>
         tb_user_permitgroup.permit_group_id=tb_user_permitgroup_data.permit_group_id
        <if test="uid>100">
            and tb_user_permitgroup_data.uid=#{uid}
        </if>
        and tb_user_permitgroup.permit_item_value=1
        </where>
    </select>
</mapper>