根据手机号ids查询用户

guoshilong

2023-05-09 f7524312494eb23b12d674acfa89012895e47aa3

根据手机号ids查询用户

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

@@ -98,7 +98,11 @@
        return R.data(UserWrapper.build().entityVO(detail));
    }


    @PostMapping("/getUserByPhoneIds")
    public R getUserByPhoneIds(String phoneIds){
        List<User> userList = userService.getUserByPhoneIds(phoneIds);
        return R.data(userList);
    }

    /**
     * 查询单条

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

@@ -70,4 +70,6 @@
     * @return
     */
    List<User> selectUserByPhoneOrAccount(@Param("tenantId")String tenantId, @Param("key")String key);

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

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

@@ -84,5 +84,9 @@
        and TENANT_ID = #{tenantId}
        and (ACCOUNT = #{key} or PHONE = #{key})
    </select>
    <select id="getUserByPhoneIds" resultType="cn.gistack.system.user.entity.User">
        SELECT * FROM BLADE_USER
        WHERE IS_DELETED = 0 AND PHONE LIKE CONCAT('%',#{phoneIds},'%')
    </select>

</mapper>

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

@@ -223,4 +223,6 @@
     * @return
     */
    List<User> userInfoByPhoneOrAccount(String tenantId, String key);

    List<User> getUserByPhoneIds(String phoneIds);
}

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

@@ -459,4 +459,9 @@
    public List<User> userInfoByPhoneOrAccount(String tenantId, String key) {
        return baseMapper.selectUserByPhoneOrAccount(tenantId,key);
    }

    @Override
    public List<User> getUserByPhoneIds(String phoneIds) {
        return baseMapper.getUserByPhoneIds(phoneIds);
    }
}