From fb9823428a7705d8ed8e2f4128e525df3781e968 Mon Sep 17 00:00:00 2001
From: luoyb <412940104@qq.com>
Date: 星期二, 03 八月 2021 10:21:09 +0800
Subject: [PATCH] fix(bug修复): 导入的新员工增加了入离职记录；重新处理了导入的日期格式
---
febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpAccessoryServiceImpl.java | 47 ++++++++++++++++++++++++-----------------------
1 files changed, 24 insertions(+), 23 deletions(-)
diff --git a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpAccessoryServiceImpl.java b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpAccessoryServiceImpl.java
index dfc02f8..ecaaebd 100644
--- a/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpAccessoryServiceImpl.java
+++ b/febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/service/impl/EmpAccessoryServiceImpl.java
@@ -40,6 +40,7 @@
import javax.servlet.http.HttpServletResponse;
import java.io.*;
import java.util.*;
+import java.util.function.Consumer;
/**
* 附件管理 Service实现
@@ -92,29 +93,16 @@
if (StrUtil.isNotBlank(vo.getEntryDate())) {
queryWrapper.between("a.entryDate", vo.getEntryDate().split(",")[0], vo.getEntryDate().split(",")[1]);
}
- if (StrUtil.isNotBlank(vo.getAge())) {
- String[] arr = vo.getAge().split(",");
- for (String s : arr) {
- if (StrUtil.equals(s, "18-29")) {
- queryWrapper.or().between("a.age", 18, 29);
- }
- if (StrUtil.equals(s, "30-39")) {
- queryWrapper.or().between("a.age", 30, 39);
- }
- if (StrUtil.equals(s, "40-49")) {
- queryWrapper.or().between("a.age", 40, 49);
- }
- if (StrUtil.equals(s, "50-59")) {
- queryWrapper.or().between("a.age", 50, 59);
- }
- if (StrUtil.equals(s, "60-69")) {
- queryWrapper.or().between("a.age", 60, 69);
- }
- if (StrUtil.equals(s, "69-999")) {
- queryWrapper.or().ge("a.age", 69);
- }
- }
+ if (StringUtils.isNotBlank(vo.getAge())) {
+ String[] ages = vo.getAge().split(",");
+ Consumer<QueryWrapper<EmpAccessoryVO>> consumer = wrapper -> {
+ for (int i = 0; i < ages.length; i++) {
+ String ageBtn = ages[i];
+ wrapper.or().between("a.Age", ageBtn.split("-")[0], ageBtn.split("-")[1]);
+ }
+ };
+ queryWrapper.and(consumer);
}
if (StrUtil.isNotBlank(vo.getArchivesStatus())) {
queryWrapper.in("a.archivesStatus", vo.getArchivesStatus().split(","));
@@ -148,6 +136,20 @@
}
if (StringUtils.isNotBlank(vo.getEntryType())) {
queryWrapper.in("a.entryType", vo.getEntryType().split(","));
+ } if (StringUtils.isNotBlank(vo.getCertificateList())) {
+ String[] certificates = vo.getCertificateList().split(",");
+ Consumer<QueryWrapper<EmpAccessoryVO>> consumer = new Consumer<QueryWrapper<EmpAccessoryVO>>() {
+ @Override
+ public void accept(QueryWrapper<EmpAccessoryVO> wrapper) {
+ for (int i = 0; i < certificates.length; i++) {
+ // String ageBtn = certificates[i];
+ // wrapper.or().like("a.certificateList", ageBtn);
+ String ageBtn = "|" + certificates[i] + "|";
+ wrapper.gt("LOCATE('"+ageBtn+"',CONCAT('|',replace( certificateList, ',', '|,|'),'|'))",0);
+ }
+ }
+ };
+ queryWrapper.and(consumer);
}
queryWrapper.inSql("c.dept_Id", remoteDeptService.userRightDepts());
if (StrUtil.isNotBlank(vo.getFileName())){
@@ -184,7 +186,6 @@
queryWrapper.orderByAsc("a.certificateNumb");
}
}
-
queryWrapper.groupBy(" a.delFlag,a.empName,a.empStatus,a.empId,a.certificateNumb,a.empNumb,deptName,a.jobName");
Page<EmpAccessory> page = new Page<>(request.getPageNum(), request.getPageSize());
// String querySql = empAccessoryMapper.getQuerySql();
--
Gitblit v1.8.0