From 4e55bd9cee8e44f7a7a0d9185d8323fc7be9193d Mon Sep 17 00:00:00 2001
From: yubo <autumnal_wind@yeah.net>
Date: 星期六, 11 四月 2026 21:14:01 +0800
Subject: [PATCH] fix(hr): 修正员工基础信息字典字段的大小写问题

---
 febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpLeaveInfoServiceImpl.java |   66 +++++++++++++++++---------------
 1 files changed, 35 insertions(+), 31 deletions(-)

diff --git a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpLeaveInfoServiceImpl.java b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpLeaveInfoServiceImpl.java
index 8698d06..6955b7e 100644
--- a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpLeaveInfoServiceImpl.java
+++ b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpLeaveInfoServiceImpl.java
@@ -1,34 +1,16 @@
 package cc.mrbird.febs.server.hr.service.impl;
 
-import java.math.BigDecimal;
-import java.util.ArrayList;
-import java.util.Arrays;
-import java.util.Date;
-import java.util.List;
-import java.util.Optional;
-
-import cc.mrbird.febs.common.core.entity.constant.FebsConstant;
-import cc.mrbird.febs.common.core.utils.SortUtil;
-import org.apache.commons.lang3.StringUtils;
-import org.springframework.stereotype.Service;
-import org.springframework.transaction.annotation.Propagation;
-import org.springframework.transaction.annotation.Transactional;
-
-import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
-import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
-import com.baomidou.mybatisplus.core.metadata.IPage;
-import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
-import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
-
 import cc.mrbird.febs.common.core.constant.DicCode;
 import cc.mrbird.febs.common.core.constant.ModuleCode;
 import cc.mrbird.febs.common.core.entity.QueryRequest;
+import cc.mrbird.febs.common.core.entity.constant.FebsConstant;
 import cc.mrbird.febs.common.core.entity.constant.StringConstant;
 import cc.mrbird.febs.common.core.entity.system.Dept;
 import cc.mrbird.febs.common.core.entity.system.DicItem;
 import cc.mrbird.febs.common.core.utils.CastUtil;
 import cc.mrbird.febs.common.core.utils.FebsUtil;
 import cc.mrbird.febs.common.core.utils.SequenceUtil;
+import cc.mrbird.febs.common.core.utils.SortUtil;
 import cc.mrbird.febs.common.redis.service.RedisService;
 import cc.mrbird.febs.server.hr.entity.EmpBaseInfo;
 import cc.mrbird.febs.server.hr.entity.EmpLeaveInfo;
@@ -38,7 +20,19 @@
 import cc.mrbird.febs.server.hr.service.IEmpLeaveInfoService;
 import cn.hutool.core.date.DateUtil;
 import cn.hutool.core.util.StrUtil;
+import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import lombok.RequiredArgsConstructor;
+import org.apache.commons.lang3.StringUtils;
+import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Propagation;
+import org.springframework.transaction.annotation.Transactional;
+
+import java.math.BigDecimal;
+import java.util.*;
 
 /**
  * name:EmpLeaveinfo
@@ -76,14 +70,17 @@
             queryWrapper.like("a.CertificateNumb", empLeaveinfo.getCertificateNumb());
         }
         if (StringUtils.isNotBlank(empLeaveinfo.getDeptName())) {
-            queryWrapper.like("a.DeptName", empLeaveinfo.getDeptName());
+            queryWrapper.like("b.allDeptName", empLeaveinfo.getDeptName());
         }
         if (StringUtils.isNotBlank(empLeaveinfo.getEmpStatus())) {
-            queryWrapper.in("a.EmpStatus", empLeaveinfo.getEmpStatus().split(","));
+            queryWrapper.in("b.EmpStatus", empLeaveinfo.getEmpStatus().split(","));
         }
         if (StringUtils.isNotBlank(empLeaveinfo.getLeaveDateStr())) {
         	queryWrapper.ge("a.BeginTime", empLeaveinfo.getLeaveDateStr().split(",")[0]);
         	queryWrapper.le("a.EndTime", empLeaveinfo.getLeaveDateStr().split(",")[1]);
+        }
+        if(StringUtils.isNotBlank(empLeaveinfo.getLeaveType())){
+            queryWrapper.eq("a.leaveType", empLeaveinfo.getLeaveType());
         }
         queryWrapper.in("c.dept_Id", remoteDeptService.userRightDepts().split(StringConstant.COMMA));
         Page<EmpLeaveInfo> page = new Page<>(request.getPageNum(), request.getPageSize());
@@ -184,12 +181,22 @@
 			leaveInfo.setJobName(list.get(2).toString());
 			leaveInfo.setEmpName(list.get(3).toString());
 			leaveInfo.setCertificateNumb(list.get(4).toString());
-			if (StringUtils.isNotBlank(list.get(5).toString())) {
-				leaveInfo.setBeginTime(DateUtil.parseDate(list.get(5).toString()));
-			}
-			if (StringUtils.isNotBlank(list.get(6).toString())) {
-				leaveInfo.setEndTime(DateUtil.parseDate(list.get(6).toString()));
-			}
+			try {
+                if (StringUtils.isNotBlank(list.get(5).toString())) {
+                    leaveInfo.setBeginTime(DateUtil.parse(list.get(5).toString()));
+                }
+                if (StringUtils.isNotBlank(list.get(6).toString())) {
+                    leaveInfo.setEndTime(DateUtil.parse(list.get(6).toString()));
+                }
+
+                if (StringUtils.isNotBlank(list.get(9).toString())) {
+                    leaveInfo.setReturnDate(DateUtil.parse(list.get(9).toString()));
+                }
+            }catch (Exception e){
+                returnList.add(StrUtil.format("导入员工请假记录异常: 出现位置第{}行, 原因:{}时间格式错误",listObject.indexOf(list)+1,list.get(0).toString()));
+                continue;
+            }
+
 			if (StringUtils.isNotBlank(list.get(7).toString())) {
 				leaveInfo.setLeaveDay(new BigDecimal(list.get(7).toString()));
 			}
@@ -199,9 +206,6 @@
                 leaveInfo.setLeaveType(dicItem.getDicItemCode());
             }
 
-			if (StringUtils.isNotBlank(list.get(9).toString())) {
-				leaveInfo.setReturnDate(DateUtil.parseDate(list.get(9).toString()));
-			}
 			leaveInfo.setReporter(list.get(10).toString());
 			leaveInfo.setRemark(list.get(11).toString());
             leaveInfo.setEmpStatus(empBaseInfo.getEmpStatus());

--
Gitblit v1.8.0