package cc.mrbird.febs.server.hr.controller;
|
|
import cc.mrbird.febs.common.core.entity.FebsResponse;
|
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.DicItem;
|
import cc.mrbird.febs.common.core.exception.FebsException;
|
import cc.mrbird.febs.common.core.utils.FebsUtil;
|
import cc.mrbird.febs.server.hr.annotation.ControllerEndpoint;
|
import cc.mrbird.febs.server.hr.entity.EmpBaseInfo;
|
import cc.mrbird.febs.server.hr.entity.EmpDimissionLog;
|
import cc.mrbird.febs.server.hr.entity.EmpJobChange;
|
import cc.mrbird.febs.server.hr.feign.IRemoteDeptService;
|
import cc.mrbird.febs.server.hr.feign.IRemoteDicItemService;
|
import cc.mrbird.febs.server.hr.service.*;
|
import cc.mrbird.febs.server.hr.util.PoiExportExcel;
|
import cc.mrbird.febs.server.hr.util.PoiImportExcel;
|
import cn.hutool.core.date.DateUtil;
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.wuwenze.poi.ExcelKit;
|
import io.swagger.annotations.Api;
|
import io.swagger.annotations.ApiOperation;
|
import lombok.RequiredArgsConstructor;
|
import lombok.extern.slf4j.Slf4j;
|
import org.springframework.security.access.prepost.PreAuthorize;
|
import org.springframework.validation.annotation.Validated;
|
import org.springframework.web.bind.annotation.*;
|
import org.springframework.web.multipart.MultipartFile;
|
|
import javax.servlet.http.HttpServletRequest;
|
import javax.servlet.http.HttpServletResponse;
|
import javax.validation.Valid;
|
import javax.validation.constraints.NotBlank;
|
import java.io.IOException;
|
import java.io.InputStream;
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* name:EmpBaseInfo
|
* package:cc.mrbird.febs.server.hr.controller
|
* description:控制器
|
*
|
* @author luoyibo
|
* @date 2021-01-30 08:04:50
|
* @since JDK1.8
|
*/
|
@Api(tags = "人员基本信息录入接口")
|
@Slf4j
|
@Validated
|
@RestController
|
@RequestMapping("empBaseInfo")
|
@RequiredArgsConstructor
|
public class EmpBaseInfoController {
|
private final IRemoteDeptService remoteDeptService;
|
private final IEmpBaseInfoService empBaseInfoService;
|
private final IEmpWorkExperienceService empWorkExperienceService;
|
private final IEmpPhysicalExamService empPhysicalExamService;
|
private final IEmpContractInfoService empContractInfoService;
|
private final IEmpDimissionAttendService empDimissionAttendService;
|
private final IEmpLeaveInfoService empLeaveInfoService;
|
private final IEmpResignService empResignService;
|
private final IEmpUnemploymentService empUnemploymentService;
|
private final IEmpInsuranceService empInsuranceService;
|
private final IEmpAccidentCasesService empAccidentCasesService;
|
private final IEmpOccupationalService empOccupationalService;
|
private final IEmpLaborTroubleService empLaborTroubleService;
|
private final IEmpBadRecordService empBadRecordService;
|
private final IEmpRemarkinfoService empRemarkinfoService;
|
private final IRemoteDicItemService dicItemService;
|
|
@ApiOperation(value = "人员基本信息无翻页列表")
|
@GetMapping
|
@PreAuthorize("hasAuthority('empBaseinfo:list')")
|
public FebsResponse getAllEmpBaseInfos(EmpBaseInfo empBaseinfo) {
|
return new FebsResponse().data(empBaseInfoService.findEmpBaseInfos(empBaseinfo));
|
}
|
@ApiOperation(value = "人员基本信息翻页列表")
|
@GetMapping("list")
|
@PreAuthorize("hasAuthority('empBaseinfo:list')")
|
public FebsResponse empBaseInfoList(QueryRequest request, EmpBaseInfo empBaseinfo) {
|
Map<String, Object> dataTable = FebsUtil.getDataTable(this.empBaseInfoService.findEmpBaseInfos(request, empBaseinfo));
|
return new FebsResponse().data(dataTable);
|
}
|
|
@ApiOperation(value = "智搜人员基本信息翻页列表")
|
@GetMapping("zslist")
|
@PreAuthorize("hasAuthority('empBaseinfo:list')")
|
public FebsResponse empBaseInfoZsList(QueryRequest request, EmpBaseInfo empBaseinfo) {
|
Map<String, Object> dataTable = FebsUtil.getDataTable(this.empBaseInfoService.findZsEmpBaseInfos(request, empBaseinfo));
|
return new FebsResponse().data(dataTable);
|
}
|
|
@ApiOperation(value = "人员基本信息增加")
|
@PostMapping
|
@PreAuthorize("hasAuthority('empBaseinfo:add')")
|
public void addEmpBaseInfo(@Valid EmpBaseInfo empBaseinfo) throws FebsException {
|
if(this.empBaseInfoService.verifyEmpNumb(empBaseinfo)){
|
throw new FebsException("已存在此员工编号:" + empBaseinfo.getEmpNumb());
|
}
|
if(this.empBaseInfoService.verifyCertificateNumb(empBaseinfo)){
|
throw new FebsException("已存在此身份证号:" + empBaseinfo.getCertificateNumb());
|
}
|
try {
|
empBaseinfo.setEntryType("20");
|
this.empBaseInfoService.createEmpBaseInfo(empBaseinfo);
|
} catch (Exception e) {
|
String message = "新增员工基本信息失败";
|
log.error(message, e);
|
throw new FebsException(message);
|
}
|
}
|
|
@ApiOperation(value = "人员基本信息物理删除")
|
@DeleteMapping
|
@PreAuthorize("hasAuthority('empBaseinfo:delete')")
|
public void deleteEmpBaseInfo(EmpBaseInfo empBaseinfo) throws FebsException {
|
try {
|
this.empBaseInfoService.deleteEmpBaseInfo(empBaseinfo);
|
} catch (Exception e) {
|
String message = "删除员工基本信息失败";
|
log.error(message, e);
|
throw new FebsException(message);
|
}
|
}
|
|
@ApiOperation(value = "人员基本信息逻辑删除")
|
@DeleteMapping("{ids}")
|
@PreAuthorize("hasAuthority('empBaseinfo:delete')")
|
public void logicDeleteEmpBaseInfo(@NotBlank(message = "{required}") @PathVariable("ids") String ids) throws FebsException {
|
try {
|
this.empBaseInfoService.logicDelEmpBaseInfo(ids);
|
} catch (Exception e) {
|
String message = "逻辑员工基本信息删除失败";
|
log.error(message, e);
|
throw new FebsException(message);
|
}
|
}
|
|
@ApiOperation(value = "人员基本信息修改")
|
@PutMapping
|
@PreAuthorize("hasAuthority('empBaseinfo:update')")
|
public void updateEmpBaseInfo(@Valid EmpBaseInfo empBaseinfo) throws FebsException {
|
if(this.empBaseInfoService.verifyEmpNumb(empBaseinfo)){
|
throw new FebsException("已存在此员工编号:" + empBaseinfo.getEmpNumb());
|
}
|
try {
|
this.empBaseInfoService.updateEmpBaseInfo(empBaseinfo);
|
} catch (Exception e) {
|
String message = "修改失败";
|
log.error(message, e);
|
throw new FebsException(message);
|
}
|
}
|
@ApiOperation(value = "基本信息提交")
|
@DeleteMapping("toNormal/{ids}")
|
@PreAuthorize("hasAuthority('empBaseinfo:delete')")
|
public void momentToNormal(@NotBlank(message = "{required}") @PathVariable("ids") String ids) throws FebsException {
|
try {
|
this.empBaseInfoService.momentToNormal(ids);
|
} catch (Exception e) {
|
String message = "基本信息提交失败";
|
log.error(message, e);
|
throw new FebsException(message);
|
}
|
}
|
@GetMapping("options")
|
public FebsResponse roles() {
|
QueryWrapper<EmpBaseInfo> wrapper=new QueryWrapper();
|
wrapper.eq("a.empStatus",0);
|
wrapper.eq("a.delFlag",0);
|
wrapper.orderByDesc("a.createTime");
|
wrapper.in("c.dept_Id", remoteDeptService.userRightDepts().split(StringConstant.COMMA));
|
List<EmpBaseInfo> allRoles = empBaseInfoService.listAll(wrapper);
|
return new FebsResponse().data(allRoles);
|
}
|
|
@ApiOperation(value = "导出员工")
|
@RequestMapping(value = "export",method= RequestMethod.POST)
|
@ControllerEndpoint(operation = "导出用户数据", exceptionMessage = "导出Excel失败")
|
public void export(QueryRequest request, EmpBaseInfo empBaseinfo, HttpServletResponse response) throws IOException {
|
request.setPageSize(this.empBaseInfoService.count());
|
List<EmpBaseInfo> records = this.empBaseInfoService.findZsEmpBaseInfos(request, empBaseinfo).getRecords();
|
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, null);
|
String fileName = "员工列表";
|
Date currentDate = new Date();
|
String dateStr = DateUtil.formatDate(currentDate);
|
boolean result = PoiExportExcel.exportCommonExcel(response, fileName + dateStr, fileName, allList);
|
}
|
|
@ApiOperation(value = "导出员工")
|
@RequestMapping(value = "exportEmpAll",method= RequestMethod.POST)
|
@ControllerEndpoint(operation = "导出用户数据", exceptionMessage = "导出Excel失败")
|
public void exportEmpAll(HttpServletResponse response,EmpBaseInfo empBaseinfo) throws IOException {
|
this.empBaseInfoService.exportEmpAll(response,empBaseinfo);
|
}
|
|
@ApiOperation(value = "导入员工")
|
@PostMapping("importEmp")
|
public FebsResponse importEmp(MultipartFile file) {
|
InputStream in;
|
List<List<List<Object>>> listObject;
|
List<String> returnList = new ArrayList<>();
|
List<DicItem> dicItems = dicItemService.getAllDicitemsAll();
|
try {
|
if (!file.isEmpty()) {
|
in = file.getInputStream();
|
listObject = PoiImportExcel.getMulitListByExcel(in, file.getOriginalFilename());
|
in.close();
|
empBaseInfoService.importEmpBaseInfo(listObject.get(0),returnList,dicItems);
|
empWorkExperienceService.importEmpWorkExperience(listObject.get(1),returnList);
|
empPhysicalExamService.importEmpPhysicalExam(listObject.get(2),returnList,dicItems);
|
empContractInfoService.importEmpContractInfo(listObject.get(3),returnList,dicItems);
|
empDimissionAttendService.importEmpDimissionAttend(listObject.get(4),returnList);
|
empLeaveInfoService.importEmpLeaveInfo(listObject.get(5),returnList,dicItems);
|
empResignService.importEmpResign(listObject.get(6),returnList);
|
empUnemploymentService.importEmpUnemployment(listObject.get(7),returnList);
|
empInsuranceService.importEmpInsurance(listObject.get(8),returnList,dicItems);
|
empAccidentCasesService.importEmpAccidentCases(listObject.get(9),returnList);
|
empOccupationalService.importEmpOccupational(listObject.get(10),returnList);
|
empLaborTroubleService.importEmpLaborTrouble(listObject.get(11),returnList,dicItems);
|
empBadRecordService.importEmpBadRecord(listObject.get(12),returnList);
|
empRemarkinfoService.importEmpRemarkInfo(listObject.get(13),returnList);
|
}
|
}catch (IndexOutOfBoundsException e){
|
log.error("导入员工,下表越界", e);
|
}catch (Exception e) {
|
log.error("导入员工", e);
|
}
|
return new FebsResponse().data(returnList);
|
}
|
|
@ApiOperation(value = "关闭员工档案")
|
@PostMapping("dimission")
|
@PreAuthorize("hasAuthority('empBaseinfo:dimission')")
|
public void dimissionEmp(EmpDimissionLog empDimissionLog) throws FebsException {
|
try {
|
this.empBaseInfoService.closeEmpArchives(empDimissionLog);
|
} catch (Exception e) {
|
String message = "关闭员工档案失败";
|
log.error(message, e);
|
throw new FebsException(message);
|
}
|
}
|
@ApiOperation(value = "员工岗位变更")
|
@PostMapping("jobChange")
|
@PreAuthorize("hasAuthority('empBaseinfo:jobChange')")
|
public void changeEmpJob(EmpJobChange empJobChange) throws FebsException {
|
try {
|
this.empBaseInfoService.changeEmpJob(empJobChange);
|
} catch (Exception e) {
|
String message = "员工调岗保存失败";
|
log.error(message, e);
|
throw new FebsException(message);
|
}
|
}
|
|
@GetMapping("image/{empId}")
|
public void getImage(@PathVariable String empId, HttpServletResponse response) throws FebsException {
|
try {
|
this.empBaseInfoService.getImage(empId,response);
|
} catch (Exception e) {
|
String message = "获取员工图片异常";
|
log.error(message, e);
|
throw new FebsException(message);
|
}
|
|
}
|
|
@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);
|
}
|
}
|
|
@ApiOperation(value = "社保提醒人员基本信息翻页列表")
|
@GetMapping("insurance/alert")
|
@PreAuthorize("hasAuthority('empBaseinfo:list')")
|
public FebsResponse insuranceAlertEmpBaseInfoList(QueryRequest request, EmpBaseInfo empBaseinfo) {
|
empBaseinfo.setTimeRange(2);
|
Map<String, Object> dataTable = FebsUtil.getDataTable(this.empBaseInfoService.findInsuranceEmpBaseInfos(request, empBaseinfo));
|
return new FebsResponse().data(dataTable);
|
}
|
|
@ApiOperation(value = "退休提醒人员基本信息翻页列表")
|
@GetMapping("retire/alert")
|
@PreAuthorize("hasAuthority('empBaseinfo:list')")
|
public FebsResponse retirementAlertEmpBaseInfoList(QueryRequest request, EmpBaseInfo empBaseinfo) {
|
empBaseinfo.setTimeRange(2);
|
Map<String, Object> dataTable = FebsUtil.getDataTable(this.empBaseInfoService.findRetirementEmpBaseInfos(request, empBaseinfo));
|
return new FebsResponse().data(dataTable);
|
}
|
|
@ApiOperation(value = "退休解骋")
|
@PostMapping("retire/dismiss")
|
@PreAuthorize("hasAuthority('empBaseinfo:dimission')")
|
public void retireDismissionEmp(EmpDimissionLog empDimissionLog) throws FebsException {
|
try {
|
empDimissionLog.setDimissionDate(new Date());
|
|
this.empBaseInfoService.closeEmpArchives(empDimissionLog);
|
} catch (Exception e) {
|
String message = "退休解骋员工失败";
|
log.error(message, e);
|
throw new FebsException(message);
|
}
|
}
|
@ApiOperation(value = "转正提醒人员基本信息翻页列表")
|
@GetMapping("probation/alert")
|
@PreAuthorize("hasAuthority('empBaseinfo:list')")
|
public FebsResponse probationAlertEmpBaseInfoList(QueryRequest request, EmpBaseInfo empBaseinfo) {
|
Map<String, Object> dataTable = FebsUtil.getDataTable(this.empBaseInfoService.findProbationEmpBaseInfos(request, empBaseinfo));
|
return new FebsResponse().data(dataTable);
|
}
|
@ApiOperation(value = "设置人员转正信息")
|
@PostMapping("probation/change")
|
@PreAuthorize("hasAuthority('empBaseinfo:dimission')")
|
public void probationChangeEmpBaseInfo(EmpBaseInfo empBaseinfo) {
|
this.empBaseInfoService.probationEmpBaseInfo(empBaseinfo);
|
}
|
|
@ApiOperation(value = "导出社保四险员工")
|
@PostMapping(value = "export/insurance")
|
@ControllerEndpoint(operation = "导出社保四险数据", exceptionMessage = "导出 Excel 失败")
|
public void exportInsuranceWithField(QueryRequest request, HttpServletRequest httpRequest, HttpServletResponse response, EmpBaseInfo empBaseinfo) throws IOException {
|
String exportField = httpRequest.getParameter("exportField");
|
log.info("exportField: {}", exportField);
|
request.setPageSize(25535);
|
request.setPageNum(1);
|
List<EmpBaseInfo> exportList = this.empBaseInfoService.findInsuranceEmpBaseInfos(request, empBaseinfo).getRecords();
|
exportExcel(response, exportField, exportList, "社保四险员工列表");
|
}
|
|
@ApiOperation(value = "导出退休提醒员工")
|
@PostMapping(value = "export/retirement")
|
@ControllerEndpoint(operation = "导出退休提醒数据", exceptionMessage = "导出 Excel 失败")
|
public void exportRetirementWithField(QueryRequest request, HttpServletResponse response, String exportField, EmpBaseInfo empBaseinfo) throws IOException {
|
request.setPageSize(25535);
|
request.setPageNum(1);
|
List<EmpBaseInfo> exportList = this.empBaseInfoService.findRetirementEmpBaseInfos(request, empBaseinfo).getRecords();
|
exportExcel(response, exportField, exportList, "退休提醒员工列表");
|
}
|
|
@ApiOperation(value = "导出转正提醒员工")
|
@PostMapping(value = "export/probation")
|
@ControllerEndpoint(operation = "导出转正提醒数据", exceptionMessage = "导出 Excel 失败")
|
public void exportProbationWithField(QueryRequest request, HttpServletResponse response, String exportField, EmpBaseInfo empBaseinfo) throws IOException {
|
request.setPageSize(25535);
|
request.setPageNum(1);
|
List<EmpBaseInfo> exportList = this.empBaseInfoService.findProbationEmpBaseInfos(request, empBaseinfo).getRecords();
|
exportExcel(response, exportField, exportList, "转正提醒员工列表");
|
}
|
|
@ApiOperation(value = "导出身份证到期员工")
|
@PostMapping(value = "export/sfz")
|
@ControllerEndpoint(operation = "导出身份证到期员工", exceptionMessage = "导出 Excel 失败")
|
public void exportIdNumberWithField(QueryRequest request, HttpServletResponse response, String exportField, EmpBaseInfo empBaseinfo) throws IOException {
|
request.setPageSize(25535);
|
request.setPageNum(1);
|
String index = empBaseinfo.getTimeRange().toString();
|
List<EmpBaseInfo> exportList = this.empBaseInfoService.baseInfoList(index, null, null, "25535", "1", "11", null).getRecords();
|
exportExcel(response, exportField, exportList, "身份证到期员工列表");
|
}
|
|
@ApiOperation(value = "导出合同到期员工")
|
@PostMapping(value = "export/expireHt")
|
@ControllerEndpoint(operation = "导出合同证到期员工", exceptionMessage = "导出 Excel 失败")
|
public void exportExpireHtWithField(QueryRequest request, HttpServletResponse response, String exportField, EmpBaseInfo empBaseinfo) throws IOException {
|
request.setPageSize(25535);
|
request.setPageNum(1);
|
String index = empBaseinfo.getTimeRange().toString();
|
List<EmpBaseInfo> exportList = this.empBaseInfoService.baseInfoHeList(index, null, null, "25535", "1", "12", null).getRecords();
|
exportExcel(response, exportField, exportList, "合同到期员工列表");
|
}
|
|
/**
|
* 通用 Excel 导出方法
|
*
|
* @param response HTTP 响应对象
|
* @param exportField 导出字段
|
* @param exportList 导出数据列表
|
* @param fileName 文件名（不含日期）
|
* @throws IOException IO 异常
|
*/
|
private void exportExcel(HttpServletResponse response, String exportField, List<EmpBaseInfo> exportList, String fileName) throws IOException {
|
log.info("导出Excel - exportField: {}", exportField);
|
log.info("导出Excel - exportList size: {}", exportList != null ? exportList.size() : 0);
|
List<Map<String, Object>> allList = PoiExportExcel.getDataList(exportField, exportList, null);
|
Date currentDate = new Date();
|
String dateStr = DateUtil.formatDate(currentDate);
|
PoiExportExcel.exportCommonExcel(response, fileName + dateStr, fileName, allList);
|
}
|
}
|
