员工查询条件关系修改

yijiusmile

2021-03-06 551fe577e2e6b8cfc84b17fbc38b95f41c07ad00

 febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/controller/EmpBaseInfoController.java

@@ -15,6 +15,7 @@
import cc.mrbird.febs.server.hr.annotation.ControllerEndpoint;
import cc.mrbird.febs.server.hr.entity.EmpDimissionLog;
import cc.mrbird.febs.server.hr.entity.EmpJobChange;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.wuwenze.poi.ExcelKit;

import org.springframework.security.access.prepost.PreAuthorize;
@@ -112,7 +113,7 @@
    @PreAuthorize("hasAuthority('empBaseinfo:add')")
    public void addEmpBaseInfo(@Valid EmpBaseInfo empBaseinfo) throws FebsException {
       if(this.empBaseInfoService.verifyEmpNumb(empBaseinfo)){
           throw new FebsException("已存在此员工编号");
           throw new FebsException("已存在此员工编号:" + empBaseinfo.getEmpNumb());
       }
        try {
            this.empBaseInfoService.createEmpBaseInfo(empBaseinfo);
@@ -176,6 +177,15 @@
            throw new FebsException(message);
        }
    }
    @GetMapping("options")
    public FebsResponse roles() {
        QueryWrapper<EmpBaseInfo> wrapper=new QueryWrapper();
        wrapper.eq("empStatus",0);
        wrapper.eq("delFlag",0);
        wrapper.orderByDesc("createTime");
        List<EmpBaseInfo> allRoles = empBaseInfoService.list(wrapper);
        return new FebsResponse().data(allRoles);
    }

    @ApiOperation(value = "导出员工")
   @RequestMapping(value = "export",method= RequestMethod.POST)
@@ -186,34 +196,51 @@
        ExcelKit.$Export(EmpBaseInfo.class, response).downXlsx(records, false);
   }

    @ApiOperation(value = "导出员工")
   @RequestMapping(value = "exportWithField",method= RequestMethod.POST)
    @ControllerEndpoint(operation = "导出用户数据", exceptionMessage = "导出Excel失败")
    public void exportWithField(QueryRequest request, HttpServletResponse response, String exportField,EmpBaseInfo empBaseinfo) throws IOException {
       request.setPageSize(25535);
       request.setPageNum(1);
      List<EmpBaseInfo> exportList = this.empBaseInfoService.findZsEmpBaseInfos(request, empBaseinfo).getRecords();
      List<Map<String, Object>> listMapDicItem = new ArrayList();
      List<Map<String, Object>> allList = PoiExportExcel.getDataList(exportField, exportList, listMapDicItem);
      String fileName = "在职员工列表";
      Date currentDate = new Date();
      String dateStr = DateUtil.formatDate(currentDate);
      boolean result = PoiExportExcel.exportCommonExcel(response, fileName + dateStr, fileName, allList);
   }

    @ApiOperation(value = "导入员工")
   @PostMapping("importEmp")
   public void importEmp(MultipartFile file) throws IOException {
      InputStream in = null;
      List<List<List<Object>>> listObject = null;
   public FebsResponse importEmp(MultipartFile file) {
      InputStream in;
      List<List<List<Object>>> listObject;
      List<String>  returnList = new ArrayList<>();
      try {
         if (!file.isEmpty()) {
            in = file.getInputStream();
            listObject = PoiImportExcel.getMulitListByExcel(in, file.getOriginalFilename());
            in.close();
            empBaseInfoService.importEmpBaseInfo(listObject.get(0));
            empWorkExperienceService.importEmpWorkExperience(listObject.get(1));
            empPhysicalExamService.importEmpPhysicalExam(listObject.get(2));
            empContractInfoService.importEmpContractInfo(listObject.get(3));
            empDimissionAttendService.importEmpDimissionAttend(listObject.get(4));
            empLeaveInfoService.importEmpLeaveInfo(listObject.get(5));
            empResignService.importEmpResign(listObject.get(6));
            empUnemploymentService.importEmpUnemployment(listObject.get(7));
            empInsuranceService.importEmpInsurance(listObject.get(8));
            empAccidentCasesService.importEmpAccidentCases(listObject.get(9));
            empOccupationalService.importEmpOccupational(listObject.get(10));
            empLaborTroubleService.importEmpLaborTrouble(listObject.get(11));
            empBadRecordService.importEmpBadRecord(listObject.get(12));
            empRemarkinfoService.importEmpRemarkInfo(listObject.get(13));
            empBaseInfoService.importEmpBaseInfo(listObject.get(0),returnList);
            empWorkExperienceService.importEmpWorkExperience(listObject.get(1),returnList);
            empPhysicalExamService.importEmpPhysicalExam(listObject.get(2),returnList);
            empContractInfoService.importEmpContractInfo(listObject.get(3),returnList);
            empDimissionAttendService.importEmpDimissionAttend(listObject.get(4),returnList);
            empLeaveInfoService.importEmpLeaveInfo(listObject.get(5),returnList);
            empResignService.importEmpResign(listObject.get(6),returnList);
            empUnemploymentService.importEmpUnemployment(listObject.get(7),returnList);
            empInsuranceService.importEmpInsurance(listObject.get(8),returnList);
            empAccidentCasesService.importEmpAccidentCases(listObject.get(9),returnList);
            empOccupationalService.importEmpOccupational(listObject.get(10),returnList);
            empLaborTroubleService.importEmpLaborTrouble(listObject.get(11),returnList);
            empBadRecordService.importEmpBadRecord(listObject.get(12),returnList);
            empRemarkinfoService.importEmpRemarkInfo(listObject.get(13),returnList);
         }
      } catch (Exception e) {
         log.error("导入员工", e);
      }
             return new FebsResponse().data(returnList);
   }

    @ApiOperation(value = "关闭员工档案")
@@ -250,4 +277,17 @@
        }

    }

    @ApiOperation(value = "在职人员基本信息增加")
    @PostMapping("addInEmp")
    @PreAuthorize("hasAuthority('empBaseinfo:add')")
    public FebsResponse addInEmpBaseInfo(@Valid EmpBaseInfo empBaseinfo) throws FebsException {
        try {
            return new FebsResponse().data(empBaseInfoService.addInEmpBaseInfo(empBaseinfo));
        } catch (Exception e) {
            String message = "新增员工基本信息失败";
            log.error(message, e);
            throw new FebsException(message);
        }
    }
}