fix(bug修复): 入离职记录智搜无法按姓名查询

luoyb

2021-05-12 49a2f509d6a114c062b966a5bab83f45980e808f

 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实现
@@ -148,6 +149,18 @@
        }
        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);
                    }
                }
            };
            queryWrapper.and(consumer);
        }
        queryWrapper.inSql("c.dept_Id", remoteDeptService.userRightDepts());
        if (StrUtil.isNotBlank(vo.getFileName())){
@@ -184,7 +197,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();