From 68317d44b233f28150336bbf3aa3a32400552437 Mon Sep 17 00:00:00 2001
From: xiaoyi <908147524@qq.com>
Date: 星期一, 02 十一月 2026 11:02:08 +0800
Subject: [PATCH] fix(excel): 导入模板日期改为文本显示，修复显示为 Excel 序列号
---
yudao-module-hrm/src/main/java/cn/iocoder/yudao/module/hrm/controller/admin/employee/HrmEmployeeController.java | 64 ++++++++++++++++++++++++++++---
1 files changed, 57 insertions(+), 7 deletions(-)
diff --git a/yudao-module-hrm/src/main/java/cn/iocoder/yudao/module/hrm/controller/admin/employee/HrmEmployeeController.java b/yudao-module-hrm/src/main/java/cn/iocoder/yudao/module/hrm/controller/admin/employee/HrmEmployeeController.java
index 827ca30..3684571 100644
--- a/yudao-module-hrm/src/main/java/cn/iocoder/yudao/module/hrm/controller/admin/employee/HrmEmployeeController.java
+++ b/yudao-module-hrm/src/main/java/cn/iocoder/yudao/module/hrm/controller/admin/employee/HrmEmployeeController.java
@@ -9,6 +9,9 @@
import cn.iocoder.yudao.framework.common.pojo.PageResult;
import cn.iocoder.yudao.framework.common.util.object.BeanUtils;
import cn.iocoder.yudao.framework.excel.core.util.ExcelUtils;
+import cn.iocoder.yudao.module.hrm.controller.admin.employee.vo.HrmEmployeeImportExcelVO;
+import cn.iocoder.yudao.module.hrm.controller.admin.employee.vo.HrmEmployeeImportReqVO;
+import cn.iocoder.yudao.module.hrm.controller.admin.employee.vo.HrmEmployeeImportRespVO;
import cn.iocoder.yudao.module.hrm.controller.admin.employee.vo.HrmEmployeePageReqVO;
import cn.iocoder.yudao.module.hrm.controller.admin.employee.vo.HrmEmployeeRespVO;
import cn.iocoder.yudao.module.hrm.controller.admin.employee.vo.HrmEmployeeSaveReqVO;
@@ -32,6 +35,7 @@
import org.springframework.web.bind.annotation.*;
import java.io.IOException;
+import java.time.LocalDate;
import java.util.*;
import java.util.stream.Collectors;
@@ -111,10 +115,12 @@
Map<Long, DeptRespDTO> deptMap = CollUtil.isEmpty(deptIds) ? Collections.emptyMap() : deptApi.getDeptMap(deptIds);
// 2. 鎵归噺鑾峰彇宀椾綅淇℃伅
- Set<Long> postIds = employeeList.stream()
- .map(HrmEmployeeDO::getPostId)
- .filter(Objects::nonNull)
- .collect(Collectors.toSet());
+ Set<Long> postIds = new HashSet<>();
+ for (HrmEmployeeDO employee : employeeList) {
+ if (StrUtil.isNotBlank(employee.getPostIds())) {
+ postIds.addAll(JSONUtil.toList(employee.getPostIds(), Long.class));
+ }
+ }
Map<Long, PostRespDTO> postMap = CollUtil.isEmpty(postIds) ? Collections.emptyMap() : postApi.getPostMap(postIds);
// 3. 鏀堕泦鎵�鏈夎鑹睮D
@@ -139,9 +145,16 @@
respVO.setDeptName(deptMap.get(employee.getDeptId()).getName());
}
- // 濉厖宀椾綅鍚嶇О
- if (employee.getPostId() != null && postMap.containsKey(employee.getPostId())) {
- respVO.setPostName(postMap.get(employee.getPostId()).getName());
+ // 濉厖宀椾綅淇℃伅
+ if (StrUtil.isNotBlank(employee.getPostIds())) {
+ List<Long> employeePostIds = JSONUtil.toList(employee.getPostIds(), Long.class);
+ respVO.setPostIds(employeePostIds);
+ if (CollUtil.isNotEmpty(employeePostIds)) {
+ respVO.setPostNames(employeePostIds.stream()
+ .filter(postMap::containsKey)
+ .map(id -> postMap.get(id).getName())
+ .collect(Collectors.joining(",")));
+ }
}
// 瑙ｆ瀽 roleIds 骞跺～鍏呰鑹插悕绉�
@@ -184,4 +197,41 @@
ExcelUtils.write(response, "鍛樺伐淇℃伅.xls", "鏁版嵁", HrmEmployeeRespVO.class, list);
}
+ @GetMapping("/import-template")
+ @Operation(summary = "涓嬭浇鍛樺伐瀵煎叆妯℃澘")
+ @PreAuthorize("@ss.hasPermission('hrm:employee:import')")
+ public void importTemplate(HttpServletResponse response) throws IOException {
+ // 绀轰緥鐨勯儴闂�/宀椾綅/瑙掕壊鍙栧綋鍓嶇郴缁熺湡瀹炴暟鎹紝閬垮厤鐓ф妱 demo 閲岀殑銆岀爺鍙戦儴銆嶅鑷村尮閰嶅け璐�
+ String sampleDept = "璇峰～鍐欓儴闂ㄥ悕绉�";
+ try {
+ var depts = deptApi.getDeptList();
+ if (depts != null && !depts.isEmpty()) {
+ sampleDept = depts.get(0).getName();
+ }
+ } catch (Exception ignored) {
+ // 鍙栦笉鍒板氨淇濈暀鍗犱綅鏂囨锛屼笉褰卞搷妯℃澘涓嬭浇
+ }
+ // 宀椾綅鏈彁渚涚畝鏄撳垪琛� API锛岀ず渚嬬敤鍗犱綅鏂囨
+ String samplePost = "璇峰～鍐欏矖浣嶅悕绉帮紙澶氫釜鐢ㄨ嫳鏂囬�楀彿鍒嗛殧锛�";
+
+ List<HrmEmployeeImportExcelVO> list = Arrays.asList(
+ HrmEmployeeImportExcelVO.builder().name("寮犱笁").gender(1).phone("13800138000")
+ .deptName(sampleDept).postName(samplePost).roleNames("鏅�氳鑹�")
+ .hireDate(LocalDate.of(2020, 3, 1)).employeeStatus(1)
+ .idCard("320102199001150011").birthday(LocalDate.of(1990, 1, 15))
+ .nation("姹夋棌").marriageStatus("宸插").age(36).education("鏈").politicalStatus("涓叡鍏氬憳")
+ .email("zhangsan@example.com").remark("绀轰緥鏁版嵁锛屽鍏ュ墠璇锋浛鎹�").build()
+ );
+ ExcelUtils.writeTemplate(response, "鍛樺伐瀵煎叆妯℃澘.xls", "鍛樺伐鍒楄〃", HrmEmployeeImportExcelVO.class, list);
+ }
+
+ @PostMapping("/import")
+ @Operation(summary = "瀵煎叆鍛樺伐")
+ @PreAuthorize("@ss.hasPermission('hrm:employee:import')")
+ public CommonResult<HrmEmployeeImportRespVO> importExcel(@Valid HrmEmployeeImportReqVO importReqVO)
+ throws Exception {
+ List<HrmEmployeeImportExcelVO> list = ExcelUtils.read(importReqVO.getFile(), HrmEmployeeImportExcelVO.class);
+ return success(employeeService.importEmployeeList(list, importReqVO));
+ }
+
}
\ No newline at end of file
--
Gitblit v1.9.3