From e7dd8b490661c994c414c0edc2da1854d9bcef82 Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期四, 05 十一月 2026 13:33:12 +0800
Subject: [PATCH] feat(excel): 优化Excel列宽与必填标记并支持巡检附件

---
 yudao-module-system/src/main/java/cn/iocoder/yudao/module/system/controller/admin/user/UserController.java |   51 ++++++++++++++++++++++++++++++++++++++++++++++-----
 1 files changed, 46 insertions(+), 5 deletions(-)

diff --git a/yudao-module-system/src/main/java/cn/iocoder/yudao/module/system/controller/admin/user/UserController.java b/yudao-module-system/src/main/java/cn/iocoder/yudao/module/system/controller/admin/user/UserController.java
index 7cb7d78..65a2ad6 100644
--- a/yudao-module-system/src/main/java/cn/iocoder/yudao/module/system/controller/admin/user/UserController.java
+++ b/yudao-module-system/src/main/java/cn/iocoder/yudao/module/system/controller/admin/user/UserController.java
@@ -14,7 +14,10 @@
 import cn.iocoder.yudao.module.system.dal.dataobject.user.AdminUserDO;
 import cn.iocoder.yudao.module.system.enums.common.SexEnum;
 import cn.iocoder.yudao.module.system.service.dept.DeptService;
+import cn.iocoder.yudao.module.system.service.permission.PermissionService;
+import cn.iocoder.yudao.module.system.service.permission.RoleService;
 import cn.iocoder.yudao.module.system.service.user.AdminUserService;
+import cn.iocoder.yudao.module.system.dal.dataobject.permission.RoleDO;
 import io.swagger.v3.oas.annotations.Operation;
 import io.swagger.v3.oas.annotations.Parameter;
 import io.swagger.v3.oas.annotations.Parameters;
@@ -33,11 +36,14 @@
 import java.util.Collections;
 import java.util.List;
 import java.util.Map;
+import java.util.Set;
 
 import static cn.iocoder.yudao.framework.apilog.core.enums.OperateTypeEnum.EXPORT;
 import static cn.iocoder.yudao.framework.common.pojo.CommonResult.success;
 import static cn.iocoder.yudao.framework.common.util.collection.CollectionUtils.convertList;
 import static cn.iocoder.yudao.framework.common.util.collection.CollectionUtils.convertSet;
+import static cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil.exception;
+import static cn.iocoder.yudao.module.system.enums.ErrorCodeConstants.USER_POST_NOT_EMPTY;
 
 @Tag(name = "绠$悊鍚庡彴 - 鐢ㄦ埛")
 @RestController
@@ -49,11 +55,19 @@
     private AdminUserService userService;
     @Resource
     private DeptService deptService;
+    @Resource
+    private RoleService roleService;
+    @Resource
+    private PermissionService permissionService;
 
     @PostMapping("/create")
     @Operation(summary = "鏂板鐢ㄦ埛")
     @PreAuthorize("@ss.hasPermission('system:user:create')")
     public CommonResult<Long> createUser(@Valid @RequestBody UserSaveReqVO reqVO) {
+        // 鏍¢獙宀椾綅蹇呭~
+        if (CollUtil.isEmpty(reqVO.getPostIds())) {
+            throw exception(USER_POST_NOT_EMPTY);
+        }
         Long id = userService.createUser(reqVO);
         return success(id);
     }
@@ -62,6 +76,10 @@
     @Operation(summary = "淇敼鐢ㄦ埛")
     @PreAuthorize("@ss.hasPermission('system:user:update')")
     public CommonResult<Boolean> updateUser(@Valid @RequestBody UserSaveReqVO reqVO) {
+        // 鏍¢獙宀椾綅蹇呭~
+        if (CollUtil.isEmpty(reqVO.getPostIds())) {
+            throw exception(USER_POST_NOT_EMPTY);
+        }
         userService.updateUser(reqVO);
         return success(true);
     }
@@ -102,7 +120,6 @@
 
     @GetMapping("/page")
     @Operation(summary = "鑾峰緱鐢ㄦ埛鍒嗛〉鍒楄〃")
-    @PreAuthorize("@ss.hasPermission('system:user:query')")
     public CommonResult<PageResult<UserRespVO>> getUserPage(@Valid UserPageReqVO pageReqVO) {
         // 鑾峰緱鐢ㄦ埛鍒嗛〉鍒楄〃
         PageResult<AdminUserDO> pageResult = userService.getUserPage(pageReqVO);
@@ -119,7 +136,6 @@
     @GetMapping("/list")
     @Operation(summary = "鑾峰緱鐢ㄦ埛璇︽儏鍒楄〃")
     @Parameter(name = "ids", description = "缂栧彿鍒楄〃", required = true, example = "[1024]")
-    @PreAuthorize("@ss.hasPermission('system:user:query')")
     public CommonResult<List<UserRespVO>> getUserList(@RequestParam("ids") List<Long> ids) {
         List<AdminUserDO> list = userService.getUserList(ids);
         if (CollUtil.isEmpty(list)) {
@@ -148,10 +164,35 @@
         return success(UserConvert.INSTANCE.convertSimpleList(list, deptMap));
     }
 
+    @GetMapping("/list-by-role-code")
+    @Operation(summary = "閫氳繃瑙掕壊鏍囪瘑鑾峰彇鐢ㄦ埛绮剧畝淇℃伅鍒楄〃", description = "鍙寘鍚嫢鏈夎繖浜涜鑹茬殑鐢ㄦ埛锛屼富瑕佺敤浜庡墠绔殑涓嬫媺閫夐」銆傛敮鎸侀�楀彿鍒嗛殧鐨勫涓鑹叉爣璇�")
+    @Parameter(name = "code", description = "瑙掕壊鏍囪瘑锛屾敮鎸佸涓紝閫楀彿鍒嗛殧", required = true, example = "admin,user")
+    public CommonResult<List<UserSimpleRespVO>> getSimpleUserListByRoleCode(
+            @RequestParam("code") String code) {
+        if (StrUtil.isBlank(code)) {
+            return success(Collections.emptyList());
+        }
+        List<String> codes = StrUtil.split(code, ",");
+        List<RoleDO> roles = roleService.getRoleListByCodes(codes);
+        if (CollUtil.isEmpty(roles)) {
+            return success(Collections.emptyList());
+        }
+        Set<Long> userIds = permissionService.getUserRoleIdListByRoleId(convertList(roles, RoleDO::getId));
+        if (CollUtil.isEmpty(userIds)) {
+            return success(Collections.emptyList());
+        }
+        List<AdminUserDO> list = userService.getUserList(userIds);
+        
+        // 鎷兼帴鏁版嵁
+        Map<Long, DeptDO> deptMap = deptService.getDeptMap(
+                convertList(list, AdminUserDO::getDeptId));
+        return success(UserConvert.INSTANCE.convertSimpleList(list, deptMap));
+    }
+
+
     @GetMapping("/get")
     @Operation(summary = "鑾峰緱鐢ㄦ埛璇︽儏")
     @Parameter(name = "id", description = "缂栧彿", required = true, example = "1024")
-    @PreAuthorize("@ss.hasPermission('system:user:query')")
     public CommonResult<UserRespVO> getUser(@RequestParam("id") Long id) {
         AdminUserDO user = userService.getUser(id);
         if (user == null) {
@@ -183,7 +224,7 @@
         // 鎵嬪姩鍒涘缓瀵煎嚭 demo
         List<UserImportExcelVO> list = Arrays.asList(
                 UserImportExcelVO.builder().username("yunai").deptId(1L).email("yunai@iocoder.cn").mobile("15601691300")
-                        .nickname("鑺嬮亾").status(CommonStatusEnum.ENABLE.getStatus()).sex(SexEnum.MALE.getSex()).build(),
+                        .nickname("瓒呯骇绠$悊鍛�").status(CommonStatusEnum.ENABLE.getStatus()).sex(SexEnum.MALE.getSex()).build(),
                 UserImportExcelVO.builder().username("yuanma").deptId(2L).email("yuanma@iocoder.cn").mobile("15601701300")
                         .nickname("婧愮爜").status(CommonStatusEnum.DISABLE.getStatus()).sex(SexEnum.FEMALE.getSex()).build()
         );
@@ -223,7 +264,7 @@
 
     @GetMapping("/list-by-nickname")
     @Operation(summary = "鎸夋樀绉版ā绯婃悳绱㈢敤鎴风簿绠�淇℃伅", description = "鐢ㄤ簬鍔犲ソ鍙嬬瓑鍦烘櫙锛涘厤閴存潈锛涘綋鍓嶄粎鎸夋樀绉板尮閰�")
-    @Parameter(name = "nickname", description = "鏄电О鍏抽敭璇�", required = true, example = "鑺嬮亾")
+    @Parameter(name = "nickname", description = "鏄电О鍏抽敭璇�", required = true, example = "瓒呯骇绠$悊鍛�")
     public CommonResult<List<UserSimpleRespVO>> getSimpleUserListByNickname(@RequestParam("nickname") String nickname) {
         if (StrUtil.isBlank(nickname)) {
             return success(Collections.emptyList());

--
Gitblit v1.9.3