pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoBa/BaUserMapper.java
@@ -2,7 +2,7 @@ import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.dy.pipIrrGlobal.pojoBa.BaUser; import com.dy.pipIrrGlobal.pojoPr.PrController; import com.dy.pipIrrGlobal.voBa.VoSimpleUser; import com.dy.pipIrrGlobal.voBa.VoUserInfo; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; @@ -138,4 +138,10 @@ * @return */ List<String> getPhones(); /** * 获取简单用户数据列表,数据列表查询条件中使用 * @return */ List<VoSimpleUser> getSimpleUsers(); } pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/voBa/VoSimpleUser.java
New file @@ -0,0 +1,28 @@ package com.dy.pipIrrGlobal.voBa; import com.alibaba.fastjson2.annotation.JSONField; import com.alibaba.fastjson2.writer.ObjectWriterImplToString; import lombok.Data; /** * @author ZhuBaoMin * @date 2024-09-19 13:54 * @LastEditTime 2024-09-19 13:54 * @Description 简单用户视图:用户ID、用户名 */ @Data public class VoSimpleUser { private static final long serialVersionUID = 202409191355001L; /** * 用户ID */ @JSONField(serializeUsing= ObjectWriterImplToString.class) private Long userId; /** * 用户名 */ private String userName; } pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaUserMapper.xml
@@ -276,8 +276,8 @@ name AS userName, disabled AS stateId, (CASE WHEN disabled = 0 THEN "正常" WHEN disabled = 1 THEN "已禁用" WHEN disabled = 0 THEN '正常' WHEN disabled = 1 THEN '已禁用' END) AS stateName, CAST(blockId AS char) AS blockId, (SELECT name FROM ba_block WHERE id = user.blockId) AS blockName @@ -310,8 +310,8 @@ name AS userName, disabled AS stateId, (CASE WHEN disabled = 0 THEN "正常" WHEN disabled = 1 THEN "已禁用" WHEN disabled = 0 THEN '正常' WHEN disabled = 1 THEN '已禁用' END) AS stateName, CAST(blockId AS char) AS blockId, (SELECT name FROM ba_block WHERE id = user.blockId) AS blockName @@ -370,4 +370,13 @@ <select id="getPhones" resultType="java.lang.String"> SELECT phone FROM ba_user WHERE deleted = 0 and disabled = 0 </select> <!--获取简单用户数据列表--> <select id="getSimpleUsers" resultType="com.dy.pipIrrGlobal.voBa.VoSimpleUser"> SELECT id AS userId, name AS userName FROM ba_user WHERE disabled = 0 AND deleted = 0 </select> </mapper> pipIrr-platform/pipIrr-web/pipIrr-web-base/src/main/java/com/dy/pipIrrBase/user/UserCtrl.java
@@ -12,6 +12,7 @@ import com.dy.pipIrrBase.result.SystemResultCode; import com.dy.pipIrrGlobal.pojoBa.BaUser; import com.dy.pipIrrGlobal.util.Constant; import com.dy.pipIrrGlobal.voBa.VoSimpleUser; import com.dy.pipIrrGlobal.voBa.VoUserInfo; import com.mysql.cj.util.StringUtils; import io.swagger.v3.oas.annotations.Operation; @@ -514,4 +515,19 @@ return BaseResponseUtils.buildException(e.getMessage()); } } /** * 获取简单用户数据列表,数据列表查询条件中使用 * @return */ @GetMapping(path = "simple_users") @SsoAop() public BaseResponse<List<VoSimpleUser>> getSimpleUsers(){ try { return BaseResponseUtils.buildSuccess(sv.getSimpleUsers()); } catch (Exception e) { log.error("查询简单用户信息异常", e); return BaseResponseUtils.buildException(e.getMessage()); } } } pipIrr-platform/pipIrr-web/pipIrr-web-base/src/main/java/com/dy/pipIrrBase/user/UserSv.java
@@ -11,6 +11,7 @@ import com.dy.pipIrrGlobal.pojoBa.BaRolePermissions; import com.dy.pipIrrGlobal.pojoBa.BaUser; import com.dy.pipIrrGlobal.pojoBa.BaUserRole; import com.dy.pipIrrGlobal.voBa.VoSimpleUser; import com.dy.pipIrrGlobal.voBa.VoUserInfo; import lombok.extern.slf4j.Slf4j; import org.apache.dubbo.common.utils.PojoUtils; @@ -257,8 +258,14 @@ voUserInfo.setRoleIds(list_roleIds); voUserInfo.setRoleNames(list_roleNames); voUserInfo.setPermissions(array_permission); return voUserInfo; } /** * 获取简单用户数据列表,数据列表查询条件中使用 * @return */ public List<VoSimpleUser> getSimpleUsers() { return dao.getSimpleUsers(); } }