用户新增根据行政区划获取系统用户接口

guoshilong

2024-03-13 d3e4b81d25bc075a4759b0babf113ad5329aa6d4

用户新增根据行政区划获取系统用户接口

 skjcmanager/skjcmanager-service/skjcmanager-user/src/main/java/cn/gistack/system/user/feign/UserClient.java

@@ -131,4 +131,10 @@
        return "共：<span style='color:red'>"+ list.size() + "</span>名用户，成功加密：<span style='color:red'>"+ count + "</span>名用户";
    }

    @Override
    @GetMapping(GET_SYS_USER_NUM)
    public int getSysUserNum(String adCode) {
        return service.getSysUserNum(adCode);
    }

}

 skjcmanager/skjcmanager-service/skjcmanager-user/src/main/java/cn/gistack/system/user/mapper/UserMapper.java

@@ -76,4 +76,6 @@

    List<User> getUserByPhoneIds(@Param("phoneIds") String phoneIds);


    int getSysUserNum(List<Long> deptIdList);
}

 skjcmanager/skjcmanager-service/skjcmanager-user/src/main/java/cn/gistack/system/user/mapper/UserMapper.xml

@@ -139,6 +139,30 @@
        SELECT * FROM BLADE_USER
        WHERE IS_DELETED = 0 AND PHONE LIKE CONCAT('%',#{phoneIds},'%')
    </select>
    <select id="getSysUserNum" resultType="java.lang.Integer">
            select count(*) from (
                select bu.id from blade_user bu
                where bu.is_deleted = 0
                <if test="deptIdList!=null and deptIdList.size()>0">
                    and id in (
                    SELECT
                    user_id
                    FROM
                    blade_user_dept
                    WHERE
                    dept_id IN
                    <foreach collection="deptIdList" index="index" item="item" open="(" separator="," close=")">
                        #{item}
                    </foreach>
                    )
                </if>
            )

    </select>






</mapper>

 skjcmanager/skjcmanager-service/skjcmanager-user/src/main/java/cn/gistack/system/user/service/IUserService.java

@@ -229,4 +229,10 @@

    List<User> getUserByPhoneIds(String phoneIds);

    /**
     * 根据行政区划获取系统用户人数
     * @param adCode
     * @return
     */
    int getSysUserNum(String adCode);
}

 skjcmanager/skjcmanager-service/skjcmanager-user/src/main/java/cn/gistack/system/user/service/impl/UserServiceImpl.java

@@ -550,4 +550,13 @@
    public List<User> getUserByPhoneIds(String phoneIds) {
        return baseMapper.getUserByPhoneIds(phoneIds);
    }

    @Override
    public int getSysUserNum(String adCode) {
        List<Long> deptIdList = new ArrayList<>();
            deptIdList = SysCache.getDeptChildIds(Long.parseLong(adCode));

        int number = baseMapper.getSysUserNum(deptIdList);
        return number;
    }
}