From a4bc13b71095983cb6b1f96ea72c150573ae86ba Mon Sep 17 00:00:00 2001
From: luoyb <412940104@qq.com>
Date: 星期六, 06 三月 2021 20:01:38 +0800
Subject: [PATCH] fix(bug修复): 员工选择关键词查询

---
 febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpLeaveInfoServiceImpl.java |   61 ++++++++++++++++++------------
 1 files changed, 37 insertions(+), 24 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 ca6251c..46a76ca 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,32 +1,42 @@
 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 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.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.redis.service.RedisService;
+import cc.mrbird.febs.server.hr.entity.EmpBaseInfo;
 import cc.mrbird.febs.server.hr.entity.EmpLeaveInfo;
+import cc.mrbird.febs.server.hr.feign.IRemoteDeptService;
 import cc.mrbird.febs.server.hr.mapper.EmpLeaveInfoMapper;
 import cc.mrbird.febs.server.hr.service.IEmpBaseInfoService;
 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.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
@@ -45,35 +55,37 @@
 	private final RedisService redisService;
     private final EmpLeaveInfoMapper empLeaveinfoMapper;
     private final IEmpBaseInfoService empBaseInfoService;
+    private final IRemoteDeptService remoteDeptService;
     private final String operatorId = Optional.ofNullable(FebsUtil.getCurrentUser())
             .map(u -> u.getUserId().toString())
             .orElse("1");
 
     @Override
     public IPage<EmpLeaveInfo> findEmpLeaveInfos(QueryRequest request, EmpLeaveInfo empLeaveinfo) {
-        LambdaQueryWrapper<EmpLeaveInfo> queryWrapper = new LambdaQueryWrapper<>();
-        queryWrapper.eq(EmpLeaveInfo::getDelFlag, empLeaveinfo.getDelFlag());
+    	QueryWrapper<EmpLeaveInfo> queryWrapper = new QueryWrapper<>();
+        queryWrapper.eq("a.DelFlag", empLeaveinfo.getDelFlag());
         if (StringUtils.isNotBlank(empLeaveinfo.getEmpNumb())) {
-            queryWrapper.like(EmpLeaveInfo::getEmpNumb, empLeaveinfo.getEmpNumb());
+            queryWrapper.like("a.EmpNumb", empLeaveinfo.getEmpNumb());
         }
         if (StringUtils.isNotBlank(empLeaveinfo.getEmpName())) {
-            queryWrapper.like(EmpLeaveInfo::getEmpName, empLeaveinfo.getEmpName());
+            queryWrapper.like("a.EmpName", empLeaveinfo.getEmpName());
         }
         if (StringUtils.isNotBlank(empLeaveinfo.getCertificateNumb())) {
-            queryWrapper.like(EmpLeaveInfo::getCertificateNumb, empLeaveinfo.getCertificateNumb());
+            queryWrapper.like("a.CertificateNumb", empLeaveinfo.getCertificateNumb());
         }
         if (StringUtils.isNotBlank(empLeaveinfo.getDeptName())) {
-            queryWrapper.like(EmpLeaveInfo::getDeptName, empLeaveinfo.getDeptName());
+            queryWrapper.like("a.DeptName", empLeaveinfo.getDeptName());
         }
         if (StringUtils.isNotBlank(empLeaveinfo.getEmpStatus())) {
-            queryWrapper.eq(EmpLeaveInfo::getEmpStatus, empLeaveinfo.getEmpStatus());
+            queryWrapper.eq("a.EmpStatus", empLeaveinfo.getEmpStatus());
         }
         if (StringUtils.isNotBlank(empLeaveinfo.getLeaveDateStr())) {
-        	queryWrapper.ge(EmpLeaveInfo::getBeginTime, empLeaveinfo.getLeaveDateStr().split(",")[0]);
-        	queryWrapper.le(EmpLeaveInfo::getEndTime, empLeaveinfo.getLeaveDateStr().split(",")[1]);
+        	queryWrapper.ge("a.BeginTime", empLeaveinfo.getLeaveDateStr().split(",")[0]);
+        	queryWrapper.le("a.EndTime", empLeaveinfo.getLeaveDateStr().split(",")[1]);
         }
+        queryWrapper.in("c.dept_Id", remoteDeptService.userRightDepts().split(StringConstant.COMMA));
         Page<EmpLeaveInfo> page = new Page<>(request.getPageNum(), request.getPageSize());
-        IPage<EmpLeaveInfo> iPage = this.page(page, queryWrapper);
+        IPage<EmpLeaveInfo> iPage = empLeaveinfoMapper.selectPageVo(page, queryWrapper);
         iPage.setRecords(this.convertDicItemName(iPage.getRecords()));
         return iPage;
     }
@@ -154,13 +166,13 @@
                 returnList.add(StrUtil.format("导入员工请假记录异常: 出现位置第{}行, 原因:{}部门不存在",listObject.indexOf(list)+1,list.get(1).toString()));
                 continue;
             }
-            Long empId = empBaseInfoService.getEmpIdByEmpNumb(list.get(0).toString());
-            if (null == empId){
+            EmpBaseInfo empBaseInfo = empBaseInfoService.getEmpBaseInfoByEmpNumb(list.get(0).toString());
+            if (null == empBaseInfo){
                 returnList.add(StrUtil.format("导入员工请假记录异常: 出现位置第{}行, 原因:{}员工编号不存在",listObject.indexOf(list)+1,list.get(0).toString()));
                 continue;
             }
             leaveInfo.setDelFlag(2);
-            leaveInfo.setEmpId(empId);
+            leaveInfo.setEmpId(empBaseInfo.getEmpId());
 			leaveInfo.setDeptName(list.get(1).toString());
 			leaveInfo.setDeptId(dept.getDeptId());
 			leaveInfo.setJobName(list.get(2).toString());
@@ -181,6 +193,7 @@
 			}
 			leaveInfo.setReporter(list.get(10).toString());
 			leaveInfo.setRemark(list.get(11).toString());
+            leaveInfo.setEmpStatus(empBaseInfo.getEmpStatus());
 			this.save(leaveInfo);
 		}
 	}

--
Gitblit v1.8.0