From aa6487d1279f4c8fa36d52b1399944203849eb00 Mon Sep 17 00:00:00 2001
From: zhuo <2089219845@qq.com>
Date: 星期一, 24 二月 2025 10:04:00 +0800
Subject: [PATCH] 人员培训计划移植
---
cnas-personnel/src/main/java/com/ruoyi/personnel/service/impl/PersonBasicInfoServiceImpl.java | 676 ++++++++++++++++++++++++++++----------------------------
1 files changed, 340 insertions(+), 336 deletions(-)
diff --git a/cnas-personnel/src/main/java/com/ruoyi/personnel/service/impl/PersonBasicInfoServiceImpl.java b/cnas-personnel/src/main/java/com/ruoyi/personnel/service/impl/PersonBasicInfoServiceImpl.java
index 7d0e695..0ae552c 100644
--- a/cnas-personnel/src/main/java/com/ruoyi/personnel/service/impl/PersonBasicInfoServiceImpl.java
+++ b/cnas-personnel/src/main/java/com/ruoyi/personnel/service/impl/PersonBasicInfoServiceImpl.java
@@ -1,336 +1,340 @@
-//package com.ruoyi.personnel.service.impl;
-//
-//import com.alibaba.excel.EasyExcel;
-//import com.alibaba.excel.ExcelWriter;
-//import com.alibaba.excel.write.metadata.WriteSheet;
-//import com.alibaba.excel.write.style.column.LongestMatchColumnWidthStyleStrategy;
-//import com.alibaba.fastjson2.JSON;
-//import com.alibaba.fastjson2.JSONObject;
-//import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
-//import com.baomidou.mybatisplus.core.metadata.IPage;
-//import com.baomidou.mybatisplus.core.toolkit.ObjectUtils;
-//import com.baomidou.mybatisplus.core.toolkit.Wrappers;
-//import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
-//import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
-//import com.ruoyi.common.core.domain.entity.DepartmentDto;
-//import com.ruoyi.common.core.domain.entity.DepartmentLims;
-//import com.ruoyi.common.core.domain.entity.User;
-//import com.ruoyi.common.utils.QueryWrappers;
-//import com.ruoyi.framework.exception.ErrorException;
-//import com.ruoyi.personnel.dto.PersonBasicInfoDto;
-//import com.ruoyi.personnel.dto.UserPageDto;
-//import com.ruoyi.personnel.mapper.AnnexMapper;
-//import com.ruoyi.personnel.mapper.PersonBasicInfoFileMapper;
-//import com.ruoyi.personnel.mapper.PersonBasicInfoMapper;
-//import com.ruoyi.personnel.mapper.PersonBasicInfoWorkMapper;
-//import com.ruoyi.personnel.pojo.Annex;
-//import com.ruoyi.personnel.pojo.PersonBasicInfo;
-//import com.ruoyi.personnel.pojo.PersonBasicInfoFile;
-//import com.ruoyi.personnel.pojo.PersonBasicInfoWork;
-//import com.ruoyi.personnel.service.PersonBasicInfoService;
-//import com.ruoyi.system.mapper.DepartmentLimsMapper;
-//import com.ruoyi.system.mapper.UserMapper;
-//import org.apache.poi.xwpf.usermodel.XWPFTable;
-//import org.openxmlformats.schemas.wordprocessingml.x2006.main.STMerge;
-//import org.springframework.beans.BeanUtils;
-//import org.springframework.beans.factory.annotation.Autowired;
-//import org.springframework.beans.factory.annotation.Value;
-//import org.springframework.stereotype.Service;
-//import org.springframework.transaction.annotation.Transactional;
-//import org.springframework.web.multipart.MultipartFile;
-//
-//import javax.annotation.Resource;
-//import javax.servlet.http.HttpServletResponse;
-//import java.io.File;
-//import java.io.IOException;
-//import java.io.InputStream;
-//import java.io.OutputStream;
-//import java.net.URLEncoder;
-//import java.time.LocalDateTime;
-//import java.time.format.DateTimeFormatter;
-//import java.util.*;
-//import java.util.stream.Collectors;
-//
-///**
-// * <p>
-// * 鏈嶅姟瀹炵幇绫�
-// * </p>
-// *
-// * @author 姹熻嫃榈烽洀缃戠粶绉戞妧鏈夐檺鍏徃
-// * @since 2024-08-30 09:19:57
-// */
-//
-//@Service
-//@Transactional(rollbackFor = Exception.class)
-//public class PersonBasicInfoServiceImpl extends ServiceImpl<PersonBasicInfoMapper, PersonBasicInfo> implements PersonBasicInfoService {
-//
-// @Autowired
-// private DepartmentLimsMapper departmentMapper;
-// @Value("${file.path}")
-// private String imgUrl;
-// @Value("${wordUrl}")
-// private String wordUrl;
-// @Resource
-// private UserMapper userMapper;
-// @Resource
-// private AnnexMapper annexMapper;
-// @Resource
-// private PersonBasicInfoFileMapper personBasicInfoFileMapper;
-// @Resource
-// private PersonBasicInfoWorkMapper personBasicInfoWorkMapper;
-//
-// @Override
-// public List<DepartmentDto> selectCNSAPersonTree() {
-// List<DepartmentDto> departments = departmentMapper.selectDepartment();
-// List<DepartmentDto> limsUser = baseMapper.selectLimsUser();
-// departments.addAll(limsUser);
-// //鑾峰彇鐖惰妭鐐�
-// return departments.stream().filter(m -> m.getFatherId() == null).peek(
-// (m) -> m.setChildren(getChildren(m, departments))
-// ).collect(Collectors.toList());
-// }
-//
-// @Override
-// public Map<String,Object> getCNASPersonnelInfo(Integer userId) {
-// Map<String, Object> map = new HashMap<>();
-// Map<Integer,List<DepartmentLims>> childrenMap = new HashMap<>();
-// List<DepartmentLims> deptS = departmentMapper.selectList(null);
-// for (DepartmentLims dept : deptS) {
-// if(!Objects.isNull(dept.getFatherId())) {
-// if(!childrenMap.containsKey(dept.getFatherId())) {
-// childrenMap.put(dept.getFatherId(),new ArrayList<>());
-// }
-// childrenMap.get(dept.getFatherId()).add(dept);
-// }
-// }
-// // 鐖惰妭鐐�
-// List<DepartmentLims> deptF = new ArrayList<>();
-// for (DepartmentLims dept : deptS) {
-// if(Objects.isNull(dept.getFatherId())) {
-// deptF.add(buildTree(dept,childrenMap));
-// }
-// }
-// map.put("department",deptF);
-// map.put("PersonBasicInfoDto",baseMapper.getCNASPersonnelInfo(userId));
-// map.put("annexList",annexMapper.selectList(new LambdaQueryWrapper<Annex>().eq(Annex::getUserId,userId)));
-// return map;
-// }
-//
-// private DepartmentLims buildTree(DepartmentLims departmentLims, Map<Integer,List<DepartmentLims>> childrenMap) {
-// if(childrenMap.containsKey(departmentLims.getId())) {
-// departmentLims.setChildren(childrenMap.get(departmentLims.getId()));
-// for (DepartmentLims departmentLims1 : departmentLims.getChildren()) {
-// buildTree(departmentLims1,childrenMap);
-// }
-// }
-// return departmentLims;
-// }
-//
-// @Override
-// public void saveCNASPersonnelInfo(PersonBasicInfoDto personBasicInfoDto) {
-// User user = new User();
-// user.setId(personBasicInfoDto.getUserId());
-// user.setAccount(personBasicInfoDto.getAccount());
-// user.setName(personBasicInfoDto.getName());
-// user.setNameEn(personBasicInfoDto.getNameEn());
-// user.setAge(personBasicInfoDto.getAge());
-// user.setPhone(personBasicInfoDto.getPhone());
-// user.setEmail(personBasicInfoDto.getEmail());
-// user.setSignatureUrl(personBasicInfoDto.getSignatureUrl());
-// user.setPictureUrl(personBasicInfoDto.getPictureUrl());
-// user.setDepartLimsId(personBasicInfoDto.getDepartLimsId());
-// userMapper.updateById(user);
-// PersonBasicInfo personBasicInfo = JSONObject.parseObject(JSON.toJSONString(personBasicInfoDto), PersonBasicInfo.class);
-// PersonBasicInfo one = baseMapper.selectOne(new LambdaQueryWrapper<PersonBasicInfo>()
-// .eq(PersonBasicInfo::getUserId, personBasicInfoDto.getUserId()));
-// if(Objects.isNull(one)) {
-// baseMapper.insert(personBasicInfo);
-// }else {
-// baseMapper.updateById(personBasicInfo);
-// }
-// }
-//
-// @Override
-// public IPage<Map<String, Object>> basicInformationOfPersonnelSelectPage(Page page, String name, Integer departmentId) {
-// return baseMapper.selectPersonBasecInfoAndUser(page, name, departmentId);
-// }
-//
-// @Override
-// public void exportPersonBasicInfo(UserPageDto userPageDto, HttpServletResponse response) throws Exception {
-// ArrayList<PersonBasicInfoDto> data = new ArrayList<>();
-// List<User> list = userMapper.selectUserDtoPageList(new Page(-1, -1), QueryWrappers.queryWrappers(userPageDto)).getRecords();
-// for (User user : list) {
-// PersonBasicInfoDto personBasicInfoDto = new PersonBasicInfoDto();
-// PersonBasicInfo personBasicInfo = baseMapper.selectOne(Wrappers.<PersonBasicInfo>lambdaQuery().eq(PersonBasicInfo::getUserId, user.getId()));
-// if (ObjectUtils.isNotEmpty(personBasicInfo)) {
-// BeanUtils.copyProperties(personBasicInfo, personBasicInfoDto);
-// }
-// personBasicInfoDto.setName(user.getName());
-// personBasicInfoDto.setAccount(user.getAccount());
-// personBasicInfoDto.setPhone(ObjectUtils.isNotEmpty(user.getPhone()) ? user.getPhone() : " ");
-// data.add(personBasicInfoDto);
-// }
-// response.setContentType("application/vnd.ms-excel");
-// response.setCharacterEncoding("UTF-8");
-// String fileName = URLEncoder.encode("浜哄憳鍩烘湰淇℃伅鍒楄〃瀵煎嚭", "UTF-8");
-// response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx");
-// try {
-// // 鏂板缓ExcelWriter
-// ExcelWriter excelWriter = EasyExcel.write(response.getOutputStream()).registerWriteHandler(new LongestMatchColumnWidthStyleStrategy()).build();
-// WriteSheet mainSheet = EasyExcel.writerSheet(0, "浜哄憳鍩烘湰淇℃伅瀵煎嚭").head(PersonBasicInfoDto.class).build();
-// excelWriter.write(data, mainSheet);
-// // 鍏抽棴娴�
-// excelWriter.finish();
-// } catch (IOException e) {
-// throw new RuntimeException("瀵煎嚭澶辫触");
-// }
-// }
-//
-// @Override
-// public String exportPersonBasicInfoById(Integer id, HttpServletResponse response) {
-// Map<String, Object> userMap = baseMapper.selectexportPersonBasic(id);
-// User user = userMapper.selectById(id);
-// PersonBasicInfo personBasicInfo = baseMapper.selectOne(Wrappers.<PersonBasicInfo>lambdaQuery().eq(PersonBasicInfo::getUserId, user.getId()));
-// if (ObjectUtils.isEmpty(personBasicInfo)){
-// throw new ErrorException("璇ョ敤鎴风殑鍩烘湰淇℃伅娌℃湁褰曞叆,鏆傛棤娉曞鍑�");
-// }
-// // 璇佷欢
-// List<Annex> annexList = annexMapper.selectList(Wrappers.<Annex>lambdaQuery()
-// .eq(Annex::getUserId, id));
-// // 宸ヤ綔缁忓巻
-// List<PersonBasicInfoWork> personBasicInfoWorks = personBasicInfoWorkMapper.selectList(Wrappers.<PersonBasicInfoWork>lambdaQuery()
-// .eq(PersonBasicInfoWork::getUserId, id));
-//
-// List<PersonBasicInfoWorkDto> workList = personBasicInfoWorks.stream().map(basicInfoWork -> {
-// PersonBasicInfoWorkDto personBasicInfoWorkDto = new PersonBasicInfoWorkDto();
-// personBasicInfoWorkDto.setWorkExperience(basicInfoWork.getWorkExperience());
-// personBasicInfoWorkDto.setFill("涓昏宸ヤ綔缁忓巻\nMain work experience鈭�1");
-// return personBasicInfoWorkDto;
-// }).collect(Collectors.toList());
-//
-// // 妫�鏌ュ垪琛ㄩ暱搴﹀苟濉厖绌哄璞�
-// while (annexList.size() < 10) {
-// annexList.add(new Annex());
-// }
-//
-// // 妫�鏌ュ垪琛ㄩ暱搴﹀苟濉厖绌哄璞�
-// while (workList.size() < 4) {
-// workList.add(new PersonBasicInfoWorkDto());
-// }
-//
-// // 鑾峰彇璺緞
-// InputStream inputStream = this.getClass().getResourceAsStream("/static/person-basic-info.docx");
-// Configure configure = Configure.builder()
-// .bind("annexList", new HackLoopTableRenderPolicy())
-// .bind("workList", new HackLoopTableRenderPolicy())
-// .build();
-// XWPFTemplate template = XWPFTemplate.compile(inputStream, configure).render(
-// new HashMap<String, Object>() {{
-// put("user", userMap);
-// put("annexList", annexList);
-// put("workList", workList);
-// }});
-//
-// try {
-// response.setContentType("application/msword");
-// String fileName = URLEncoder.encode(
-// userMap.get("name") + "浜哄憳妗ｆ", "UTF-8");
-// response.setHeader("Content-disposition",
-// "attachment;filename=" + fileName + ".docx");
-// OutputStream os = response.getOutputStream();
-// template.write(os);
-// os.flush();
-// os.close();
-// } catch (Exception e) {
-// e.printStackTrace();
-// throw new RuntimeException("瀵煎嚭澶辫触");
-// }
-//
-// return null;
-// }
-//
-// /**
-// * 浜哄憳鍩硅鍩烘湰淇℃伅闄勪欢鏂板
-// * @param userId
-// * @param file
-// * @return
-// */
-// @Override
-// public boolean uploadBasicInfoFile(Integer userId, MultipartFile file) {
-// if (userId == null) {
-// throw new ErrorException("缂哄皯浜哄憳id");
-// }
-//
-// String urlString;
-// String pathName;
-// String path;
-// String filename = file.getOriginalFilename();
-// String contentType = file.getContentType();
-// PersonBasicInfoFile personBasicInfoFile = new PersonBasicInfoFile();
-// personBasicInfoFile.setUserId(userId);
-// personBasicInfoFile.setFileName(filename);
-// if (contentType != null && contentType.startsWith("image/")) {
-// // 鏄浘鐗�
-// path = imgUrl;
-// personBasicInfoFile.setType(1);
-// } else {
-// // 鏄枃浠�
-// path = wordUrl;
-// personBasicInfoFile.setType(2);
-// }
-// try {
-// File realpath = new File(path);
-// if (!realpath.exists()) {
-// realpath.mkdirs();
-// }
-// pathName = LocalDateTime.now().format(DateTimeFormatter.ofPattern("yyMMddHHmmss")) + "_" + file.getOriginalFilename();
-// urlString = realpath + "/" + pathName;
-// file.transferTo(new File(urlString));
-// personBasicInfoFile.setFileUrl(pathName);
-// personBasicInfoFileMapper.insert(personBasicInfoFile);
-// return true;
-// } catch (Exception e) {
-// e.printStackTrace();
-// System.err.println("闄勪欢涓婁紶閿欒");
-// return false;
-// }
-// }
-//
-// /**
-// * 閫掑綊鏌ヨ瀛愯妭鐐�
-// * @param root 鏍硅妭鐐�
-// * @param all 鎵�鏈夎妭鐐�
-// * @return 鏍硅妭鐐逛俊鎭�
-// */
-// private List<DepartmentDto> getChildren(DepartmentDto root, List<DepartmentDto> all) {
-// if (ObjectUtils.isNotEmpty(root.getId())) {
-// return all.stream().filter(m -> Objects.equals(m.getFatherId(), root.getId())).peek(
-// (m) -> m.setChildren(getChildren(m, all))
-// ).collect(Collectors.toList());
-// } else {
-// return Collections.emptyList();
-// }
-// }
-//
-// // 姘村钩鍚堝苟鍗曞厓鏍�
-// private static void mergeCellsHorizontally(XWPFTable table, int row, int fromCol, int toCol) {
-// for (int i = fromCol; i <= toCol; i++) {
-// if (i == fromCol) {
-// table.getRow(row).getCell(i).getCTTc().addNewTcPr().addNewHMerge().setVal(STMerge.RESTART);
-// } else {
-// table.getRow(row).getCell(i).getCTTc().addNewTcPr().addNewHMerge().setVal(STMerge.CONTINUE);
-// }
-// }
-// }
-//
-// // 鍨傜洿鍚堝苟鍗曞厓鏍�
-// private static void mergeCellsVertically(XWPFTable table, int col, int fromRow, int toRow) {
-// for (int i = fromRow; i <= toRow; i++) {
-// if (i == fromRow) {
-// table.getRow(i).getCell(col).getCTTc().addNewTcPr().addNewVMerge().setVal(STMerge.RESTART);
-// } else {
-// table.getRow(i).getCell(col).getCTTc().addNewTcPr().addNewVMerge().setVal(STMerge.CONTINUE);
-// }
-// }
-// }
-//}
+package com.ruoyi.personnel.service.impl;
+
+import com.alibaba.excel.EasyExcel;
+import com.alibaba.excel.ExcelWriter;
+import com.alibaba.excel.write.metadata.WriteSheet;
+import com.alibaba.excel.write.style.column.LongestMatchColumnWidthStyleStrategy;
+import com.alibaba.fastjson2.JSON;
+import com.alibaba.fastjson2.JSONObject;
+import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.core.toolkit.ObjectUtils;
+import com.baomidou.mybatisplus.core.toolkit.Wrappers;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.deepoove.poi.XWPFTemplate;
+import com.deepoove.poi.config.Configure;
+import com.ruoyi.common.core.domain.entity.DepartmentDto;
+import com.ruoyi.common.core.domain.entity.DepartmentLims;
+import com.ruoyi.common.core.domain.entity.User;
+import com.ruoyi.common.utils.QueryWrappers;
+import com.ruoyi.framework.exception.ErrorException;
+import com.ruoyi.inspect.util.HackLoopTableRenderPolicy;
+import com.ruoyi.personnel.dto.PersonBasicInfoDto;
+import com.ruoyi.personnel.dto.PersonBasicInfoWorkDto;
+import com.ruoyi.personnel.dto.UserPageDto;
+import com.ruoyi.personnel.mapper.AnnexMapper;
+import com.ruoyi.personnel.mapper.PersonBasicInfoFileMapper;
+import com.ruoyi.personnel.mapper.PersonBasicInfoMapper;
+import com.ruoyi.personnel.mapper.PersonBasicInfoWorkMapper;
+import com.ruoyi.personnel.pojo.Annex;
+import com.ruoyi.personnel.pojo.PersonBasicInfo;
+import com.ruoyi.personnel.pojo.PersonBasicInfoFile;
+import com.ruoyi.personnel.pojo.PersonBasicInfoWork;
+import com.ruoyi.personnel.service.PersonBasicInfoService;
+import com.ruoyi.system.mapper.DepartmentLimsMapper;
+import com.ruoyi.system.mapper.UserMapper;
+import org.apache.poi.xwpf.usermodel.XWPFTable;
+import org.openxmlformats.schemas.wordprocessingml.x2006.main.STMerge;
+import org.springframework.beans.BeanUtils;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.beans.factory.annotation.Value;
+import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+import org.springframework.web.multipart.MultipartFile;
+
+import javax.annotation.Resource;
+import javax.servlet.http.HttpServletResponse;
+import java.io.File;
+import java.io.IOException;
+import java.io.InputStream;
+import java.io.OutputStream;
+import java.net.URLEncoder;
+import java.time.LocalDateTime;
+import java.time.format.DateTimeFormatter;
+import java.util.*;
+import java.util.stream.Collectors;
+
+/**
+ * <p>
+ * 鏈嶅姟瀹炵幇绫�
+ * </p>
+ *
+ * @author 姹熻嫃榈烽洀缃戠粶绉戞妧鏈夐檺鍏徃
+ * @since 2024-08-30 09:19:57
+ */
+
+@Service
+@Transactional(rollbackFor = Exception.class)
+public class PersonBasicInfoServiceImpl extends ServiceImpl<PersonBasicInfoMapper, PersonBasicInfo> implements PersonBasicInfoService {
+
+ @Autowired
+ private DepartmentLimsMapper departmentMapper;
+ @Value("${file.path}")
+ private String imgUrl;
+ @Value("${wordUrl}")
+ private String wordUrl;
+ @Resource
+ private UserMapper userMapper;
+ @Resource
+ private AnnexMapper annexMapper;
+ @Resource
+ private PersonBasicInfoFileMapper personBasicInfoFileMapper;
+ @Resource
+ private PersonBasicInfoWorkMapper personBasicInfoWorkMapper;
+
+ @Override
+ public List<DepartmentDto> selectCNSAPersonTree() {
+ List<DepartmentDto> departments = departmentMapper.selectDepartment();
+ List<DepartmentDto> limsUser = baseMapper.selectLimsUser();
+ departments.addAll(limsUser);
+ //鑾峰彇鐖惰妭鐐�
+ return departments.stream().filter(m -> m.getFatherId() == null).peek(
+ (m) -> m.setChildren(getChildren(m, departments))
+ ).collect(Collectors.toList());
+ }
+
+ @Override
+ public Map<String,Object> getCNASPersonnelInfo(Integer userId) {
+ Map<String, Object> map = new HashMap<>();
+ Map<Integer,List<DepartmentLims>> childrenMap = new HashMap<>();
+ List<DepartmentLims> deptS = departmentMapper.selectList(null);
+ for (DepartmentLims dept : deptS) {
+ if(!Objects.isNull(dept.getFatherId())) {
+ if(!childrenMap.containsKey(dept.getFatherId())) {
+ childrenMap.put(dept.getFatherId(),new ArrayList<>());
+ }
+ childrenMap.get(dept.getFatherId()).add(dept);
+ }
+ }
+ // 鐖惰妭鐐�
+ List<DepartmentLims> deptF = new ArrayList<>();
+ for (DepartmentLims dept : deptS) {
+ if(Objects.isNull(dept.getFatherId())) {
+ deptF.add(buildTree(dept,childrenMap));
+ }
+ }
+ map.put("department",deptF);
+ map.put("PersonBasicInfoDto",baseMapper.getCNASPersonnelInfo(userId));
+ map.put("annexList",annexMapper.selectList(new LambdaQueryWrapper<Annex>().eq(Annex::getUserId,userId)));
+ return map;
+ }
+
+ private DepartmentLims buildTree(DepartmentLims departmentLims, Map<Integer,List<DepartmentLims>> childrenMap) {
+ if(childrenMap.containsKey(departmentLims.getId())) {
+ departmentLims.setChildren(childrenMap.get(departmentLims.getId()));
+ for (DepartmentLims departmentLims1 : departmentLims.getChildren()) {
+ buildTree(departmentLims1,childrenMap);
+ }
+ }
+ return departmentLims;
+ }
+
+ @Override
+ public void saveCNASPersonnelInfo(PersonBasicInfoDto personBasicInfoDto) {
+ User user = new User();
+ user.setId(personBasicInfoDto.getUserId());
+ user.setAccount(personBasicInfoDto.getAccount());
+ user.setName(personBasicInfoDto.getName());
+ user.setNameEn(personBasicInfoDto.getNameEn());
+ user.setAge(personBasicInfoDto.getAge());
+ user.setPhone(personBasicInfoDto.getPhone());
+ user.setEmail(personBasicInfoDto.getEmail());
+ user.setSignatureUrl(personBasicInfoDto.getSignatureUrl());
+ user.setPictureUrl(personBasicInfoDto.getPictureUrl());
+ user.setDepartLimsId(personBasicInfoDto.getDepartLimsId());
+ userMapper.updateById(user);
+ PersonBasicInfo personBasicInfo = JSONObject.parseObject(JSON.toJSONString(personBasicInfoDto), PersonBasicInfo.class);
+ PersonBasicInfo one = baseMapper.selectOne(new LambdaQueryWrapper<PersonBasicInfo>()
+ .eq(PersonBasicInfo::getUserId, personBasicInfoDto.getUserId()));
+ if(Objects.isNull(one)) {
+ baseMapper.insert(personBasicInfo);
+ }else {
+ baseMapper.updateById(personBasicInfo);
+ }
+ }
+
+ @Override
+ public IPage<Map<String, Object>> basicInformationOfPersonnelSelectPage(Page page, String name, Integer departmentId) {
+ return baseMapper.selectPersonBasecInfoAndUser(page, name, departmentId);
+ }
+
+ @Override
+ public void exportPersonBasicInfo(UserPageDto userPageDto, HttpServletResponse response) throws Exception {
+ ArrayList<PersonBasicInfoDto> data = new ArrayList<>();
+ List<User> list = userMapper.selectList(null);
+ for (User user : list) {
+ PersonBasicInfoDto personBasicInfoDto = new PersonBasicInfoDto();
+ PersonBasicInfo personBasicInfo = baseMapper.selectOne(Wrappers.<PersonBasicInfo>lambdaQuery().eq(PersonBasicInfo::getUserId, user.getId()));
+ if (ObjectUtils.isNotEmpty(personBasicInfo)) {
+ BeanUtils.copyProperties(personBasicInfo, personBasicInfoDto);
+ }
+ personBasicInfoDto.setName(user.getName());
+ personBasicInfoDto.setAccount(user.getAccount());
+ personBasicInfoDto.setPhone(ObjectUtils.isNotEmpty(user.getPhone()) ? user.getPhone() : " ");
+ data.add(personBasicInfoDto);
+ }
+ response.setContentType("application/vnd.ms-excel");
+ response.setCharacterEncoding("UTF-8");
+ String fileName = URLEncoder.encode("浜哄憳鍩烘湰淇℃伅鍒楄〃瀵煎嚭", "UTF-8");
+ response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx");
+ try {
+ // 鏂板缓ExcelWriter
+ ExcelWriter excelWriter = EasyExcel.write(response.getOutputStream()).registerWriteHandler(new LongestMatchColumnWidthStyleStrategy()).build();
+ WriteSheet mainSheet = EasyExcel.writerSheet(0, "浜哄憳鍩烘湰淇℃伅瀵煎嚭").head(PersonBasicInfoDto.class).build();
+ excelWriter.write(data, mainSheet);
+ // 鍏抽棴娴�
+ excelWriter.finish();
+ } catch (IOException e) {
+ throw new RuntimeException("瀵煎嚭澶辫触");
+ }
+ }
+
+ @Override
+ public String exportPersonBasicInfoById(Integer id, HttpServletResponse response) {
+ Map<String, Object> userMap = baseMapper.selectexportPersonBasic(id);
+ User user = userMapper.selectById(id);
+ PersonBasicInfo personBasicInfo = baseMapper.selectOne(Wrappers.<PersonBasicInfo>lambdaQuery().eq(PersonBasicInfo::getUserId, user.getId()));
+ if (ObjectUtils.isEmpty(personBasicInfo)){
+ throw new ErrorException("璇ョ敤鎴风殑鍩烘湰淇℃伅娌℃湁褰曞叆,鏆傛棤娉曞鍑�");
+ }
+ // 璇佷欢
+ List<Annex> annexList = annexMapper.selectList(Wrappers.<Annex>lambdaQuery()
+ .eq(Annex::getUserId, id));
+ // 宸ヤ綔缁忓巻
+ List<PersonBasicInfoWork> personBasicInfoWorks = personBasicInfoWorkMapper.selectList(Wrappers.<PersonBasicInfoWork>lambdaQuery()
+ .eq(PersonBasicInfoWork::getUserId, id));
+
+ List<PersonBasicInfoWorkDto> workList = personBasicInfoWorks.stream().map(basicInfoWork -> {
+ PersonBasicInfoWorkDto personBasicInfoWorkDto = new PersonBasicInfoWorkDto();
+ personBasicInfoWorkDto.setWorkExperience(basicInfoWork.getWorkExperience());
+ personBasicInfoWorkDto.setFill("涓昏宸ヤ綔缁忓巻\nMain work experience鈭�1");
+ return personBasicInfoWorkDto;
+ }).collect(Collectors.toList());
+
+ // 妫�鏌ュ垪琛ㄩ暱搴﹀苟濉厖绌哄璞�
+ while (annexList.size() < 10) {
+ annexList.add(new Annex());
+ }
+
+ // 妫�鏌ュ垪琛ㄩ暱搴﹀苟濉厖绌哄璞�
+ while (workList.size() < 4) {
+ workList.add(new PersonBasicInfoWorkDto());
+ }
+
+ // 鑾峰彇璺緞
+ InputStream inputStream = this.getClass().getResourceAsStream("/static/person-basic-info.docx");
+ Configure configure = Configure.builder()
+ .bind("annexList", new HackLoopTableRenderPolicy())
+ .bind("workList", new HackLoopTableRenderPolicy())
+ .build();
+ XWPFTemplate template = XWPFTemplate.compile(inputStream, configure).render(
+ new HashMap<String, Object>() {{
+ put("user", userMap);
+ put("annexList", annexList);
+ put("workList", workList);
+ }});
+
+ try {
+ response.setContentType("application/msword");
+ String fileName = URLEncoder.encode(
+ userMap.get("name") + "浜哄憳妗ｆ", "UTF-8");
+ response.setHeader("Content-disposition",
+ "attachment;filename=" + fileName + ".docx");
+ OutputStream os = response.getOutputStream();
+ template.write(os);
+ os.flush();
+ os.close();
+ } catch (Exception e) {
+ e.printStackTrace();
+ throw new RuntimeException("瀵煎嚭澶辫触");
+ }
+
+ return null;
+ }
+
+ /**
+ * 浜哄憳鍩硅鍩烘湰淇℃伅闄勪欢鏂板
+ * @param userId
+ * @param file
+ * @return
+ */
+ @Override
+ public boolean uploadBasicInfoFile(Integer userId, MultipartFile file) {
+ if (userId == null) {
+ throw new ErrorException("缂哄皯浜哄憳id");
+ }
+
+ String urlString;
+ String pathName;
+ String path;
+ String filename = file.getOriginalFilename();
+ String contentType = file.getContentType();
+ PersonBasicInfoFile personBasicInfoFile = new PersonBasicInfoFile();
+ personBasicInfoFile.setUserId(userId);
+ personBasicInfoFile.setFileName(filename);
+ if (contentType != null && contentType.startsWith("image/")) {
+ // 鏄浘鐗�
+ path = imgUrl;
+ personBasicInfoFile.setType(1);
+ } else {
+ // 鏄枃浠�
+ path = wordUrl;
+ personBasicInfoFile.setType(2);
+ }
+ try {
+ File realpath = new File(path);
+ if (!realpath.exists()) {
+ realpath.mkdirs();
+ }
+ pathName = LocalDateTime.now().format(DateTimeFormatter.ofPattern("yyMMddHHmmss")) + "_" + file.getOriginalFilename();
+ urlString = realpath + "/" + pathName;
+ file.transferTo(new File(urlString));
+ personBasicInfoFile.setFileUrl(pathName);
+ personBasicInfoFileMapper.insert(personBasicInfoFile);
+ return true;
+ } catch (Exception e) {
+ e.printStackTrace();
+ System.err.println("闄勪欢涓婁紶閿欒");
+ return false;
+ }
+ }
+
+ /**
+ * 閫掑綊鏌ヨ瀛愯妭鐐�
+ * @param root 鏍硅妭鐐�
+ * @param all 鎵�鏈夎妭鐐�
+ * @return 鏍硅妭鐐逛俊鎭�
+ */
+ private List<DepartmentDto> getChildren(DepartmentDto root, List<DepartmentDto> all) {
+ if (ObjectUtils.isNotEmpty(root.getId())) {
+ return all.stream().filter(m -> Objects.equals(m.getFatherId(), root.getId())).peek(
+ (m) -> m.setChildren(getChildren(m, all))
+ ).collect(Collectors.toList());
+ } else {
+ return Collections.emptyList();
+ }
+ }
+
+ // 姘村钩鍚堝苟鍗曞厓鏍�
+ private static void mergeCellsHorizontally(XWPFTable table, int row, int fromCol, int toCol) {
+ for (int i = fromCol; i <= toCol; i++) {
+ if (i == fromCol) {
+ table.getRow(row).getCell(i).getCTTc().addNewTcPr().addNewHMerge().setVal(STMerge.RESTART);
+ } else {
+ table.getRow(row).getCell(i).getCTTc().addNewTcPr().addNewHMerge().setVal(STMerge.CONTINUE);
+ }
+ }
+ }
+
+ // 鍨傜洿鍚堝苟鍗曞厓鏍�
+ private static void mergeCellsVertically(XWPFTable table, int col, int fromRow, int toRow) {
+ for (int i = fromRow; i <= toRow; i++) {
+ if (i == fromRow) {
+ table.getRow(i).getCell(col).getCTTc().addNewTcPr().addNewVMerge().setVal(STMerge.RESTART);
+ } else {
+ table.getRow(i).getCell(col).getCTTc().addNewTcPr().addNewVMerge().setVal(STMerge.CONTINUE);
+ }
+ }
+ }
+}
--
Gitblit v1.9.3