From d4428bee31e1278d5cf0fa43cdba12864831bb94 Mon Sep 17 00:00:00 2001
From: yijiusmile <253281376@qq.com>
Date: 星期二, 02 三月 2021 10:30:19 +0800
Subject: [PATCH] 增加两项查询项

---
 febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpWorkExperienceServiceImpl.java |   52 ++++++++++++++++++++++++++++++++++++++++++++++++++--
 1 files changed, 50 insertions(+), 2 deletions(-)

diff --git a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpWorkExperienceServiceImpl.java b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpWorkExperienceServiceImpl.java
index ec37857..f8d1e83 100644
--- a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpWorkExperienceServiceImpl.java
+++ b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpWorkExperienceServiceImpl.java
@@ -3,9 +3,13 @@
 import cc.mrbird.febs.common.core.constant.ModuleCode;
 import cc.mrbird.febs.common.core.utils.FebsUtil;
 import cc.mrbird.febs.common.core.utils.SequenceUtil;
+import cc.mrbird.febs.server.hr.entity.EmpBaseInfo;
 import cc.mrbird.febs.server.hr.entity.EmpWorkExperience;
 import cc.mrbird.febs.server.hr.mapper.EmpWorkExperienceMapper;
 import cc.mrbird.febs.server.hr.service.IEmpWorkExperienceService;
+import cn.hutool.core.date.DateUtil;
+
+import org.apache.commons.lang3.StringUtils;
 import org.springframework.stereotype.Service;
 import org.springframework.transaction.annotation.Transactional;
 import org.springframework.transaction.annotation.Propagation;
@@ -40,7 +44,22 @@
     @Override
     public IPage<EmpWorkExperience> findEmpWorkExperiences(QueryRequest request, EmpWorkExperience empWorkexperience) {
         LambdaQueryWrapper<EmpWorkExperience> queryWrapper = new LambdaQueryWrapper<>();
-        queryWrapper.eq(EmpWorkExperience::getDelFlag, 0);
+        queryWrapper.eq(EmpWorkExperience::getDelFlag,empWorkexperience.getDelFlag());
+        if (StringUtils.isNotBlank(empWorkexperience.getEmpNumb())) {
+            queryWrapper.like(EmpWorkExperience::getEmpNumb, empWorkexperience.getEmpNumb());
+        }
+        if (StringUtils.isNotBlank(empWorkexperience.getEmpName())) {
+            queryWrapper.like(EmpWorkExperience::getEmpName, empWorkexperience.getEmpName());
+        }
+        if (StringUtils.isNotBlank(empWorkexperience.getCertificateNumb())) {
+            queryWrapper.like(EmpWorkExperience::getCertificateNumb, empWorkexperience.getCertificateNumb());
+        }
+        if (StringUtils.isNotBlank(empWorkexperience.getCertificateNumb())) {
+            queryWrapper.like(EmpWorkExperience::getCertificateNumb, empWorkexperience.getCertificateNumb());
+        }
+        if (StringUtils.isNotBlank(empWorkexperience.getJobContent())) {
+            queryWrapper.like(EmpWorkExperience::getJobContent, empWorkexperience.getJobContent());
+        }
         Page<EmpWorkExperience> page = new Page<>(request.getPageNum(), request.getPageSize());
         return this.page(page, queryWrapper);
     }
@@ -48,7 +67,7 @@
     @Override
     public List<EmpWorkExperience> findEmpWorkExperiences(EmpWorkExperience empWorkexperience) {
         LambdaQueryWrapper<EmpWorkExperience> queryWrapper = new LambdaQueryWrapper<>();
-        queryWrapper.eq(EmpWorkExperience::getDelFlag, 0);
+        queryWrapper.eq(EmpWorkExperience::getDelFlag,empWorkexperience.getDelFlag());
         return this.baseMapper.selectList(queryWrapper);
     }
 
@@ -100,4 +119,33 @@
         list.addAll(Arrays.asList(str));
         empWorkexperienceMapper.logicDeleteByIds(list, operatorId);
     }
+
+    @Override
+    public boolean momentToNormal(String ids) {
+        String[] str = ids.split(",");
+        List<String> list = new ArrayList<>(Arrays.asList(str));
+        return empWorkexperienceMapper.momentToNormal(list, operatorId)>0;
+    }
+
+    @Override
+	@Transactional(rollbackFor = Exception.class)
+	public void importEmpWorkExperience(List<List<Object>> listObject) {
+		for (List<Object> list : listObject) {
+			EmpWorkExperience workExperience = new EmpWorkExperience();
+			workExperience.setWorkExperienceId(SequenceUtil.generateId(0L, ModuleCode.HR_EMPLOYEE));
+			workExperience.setEmpNumb(list.get(0).toString());
+			workExperience.setEmpName(list.get(1).toString());
+			workExperience.setCertificateNumb(list.get(2).toString());
+			workExperience.setSex("男".equals(list.get(3).toString()) ? "1" : "2");
+			workExperience.setWorkUnit(list.get(4).toString());
+			if (StringUtils.isNotBlank(list.get(5).toString())) {
+				workExperience.setBeginDate(DateUtil.parseDate(list.get(5).toString()));
+			}
+			if (StringUtils.isNotBlank(list.get(6).toString())) {
+				workExperience.setBeginDate(DateUtil.parseDate(list.get(6).toString()));
+			}
+			workExperience.setJobContent(list.get(7).toString());
+			this.save(workExperience);
+		}
+	}
 }
\ No newline at end of file

--
Gitblit v1.8.0