| | |
| | | import cc.mrbird.febs.server.hr.util.PoiExportExcel; |
| | | import cn.hutool.core.collection.CollUtil; |
| | | import cn.hutool.core.date.DateUtil; |
| | | import cn.hutool.core.util.IdcardUtil; |
| | | import cn.hutool.core.util.StrUtil; |
| | | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | |
| | | empBaseInfo.setJobId(position.getPositionId()); |
| | | empBaseInfo.setJobName(list.get(3).toString()); |
| | | empBaseInfo.setEmpName(list.get(4).toString()); |
| | | empBaseInfo.setCertificateNumb(list.get(5).toString()); |
| | | try { |
| | | if(StrUtil.isNotBlank(list.get(5).toString())){ |
| | | empBaseInfo.setCertificateNumb(list.get(5).toString()); |
| | | if (IdcardUtil.isValidCard(list.get(5).toString())){ |
| | | empBaseInfo.setAge(IdcardUtil.getAgeByIdCard(list.get(5).toString())); |
| | | empBaseInfo.setBirthdate(IdcardUtil.getBirthDate(list.get(5).toString())); |
| | | } |
| | | } |
| | | |
| | | }catch (Exception e){ |
| | | log.error("导入人员身份证异常:{}",e); |
| | | returnList.add(StrUtil.format("导入员工基本信息异常: 出现位置第{}行, 原因:{}检查身份证是否正确", listObject.indexOf(list) + 1, list.get(5).toString())); |
| | | continue; |
| | | } |
| | | |
| | | |
| | | empBaseInfo.setSex("男".equals(list.get(6).toString()) ? "1" : "2"); |
| | | |
| | | //民族 |