| | |
| | | queryWrapper.eq("a.ArbitrationStatus", empLabortrouble.getArbitrationStatus()); |
| | | } |
| | | if (StringUtils.isNotBlank(empLabortrouble.getEmpStatus())) { |
| | | queryWrapper.eq("a.EmpStatus", empLabortrouble.getEmpStatus()); |
| | | queryWrapper.in("a.EmpStatus", empLabortrouble.getEmpStatus().split(",")); |
| | | } |
| | | if (StringUtils.isNotBlank(empLabortrouble.getArbitrationReason())) { |
| | | queryWrapper.like("a.ArbitrationReason", empLabortrouble.getArbitrationReason()); |
| | |
| | | |
| | | @Override |
| | | @Transactional(rollbackFor = Exception.class) |
| | | public void importEmpLaborTrouble(List<List<Object>> listObject,List<String> returnList) { |
| | | public void importEmpLaborTrouble(List<List<Object>> listObject,List<String> returnList,List<DicItem> dicItems ) { |
| | | for (List<Object> list : listObject) { |
| | | if (list.size()==0){ |
| | | continue; |
| | |
| | | returnList.add(StrUtil.format("导入员工劳资案件异常: 出现位置第{}行, 原因:{}部门不存在",listObject.indexOf(list)+1,list.get(1).toString())); |
| | | continue; |
| | | } |
| | | Long empId = empBaseInfoService.getEmpIdByEmpNumb(list.get(0).toString()); |
| | | if (null == empId){ |
| | | EmpBaseInfo empBaseInfo = empBaseInfoService.getEmpBaseInfoByEmpNumb(list.get(0).toString()); |
| | | if (null == empBaseInfo){ |
| | | returnList.add(StrUtil.format("导入员工劳资案件异常: 出现位置第{}行, 原因:{}员工编号不存在",listObject.indexOf(list)+1,list.get(0).toString())); |
| | | continue; |
| | | } |
| | | empLabortrouble.setDelFlag(2); |
| | | empLabortrouble.setEmpId(empId); |
| | | empLabortrouble.setEmpId(empBaseInfo.getEmpId()); |
| | | empLabortrouble.setDeptName(list.get(1).toString()); |
| | | empLabortrouble.setDeptId(dept.getDeptId()); |
| | | empLabortrouble.setJobName(list.get(2).toString()); |
| | |
| | | if (StringUtils.isNotBlank(list.get(5).toString())) { |
| | | empLabortrouble.setArbitrationDate(DateUtil.parseDateTime(list.get(5).toString())); |
| | | } |
| | | empLabortrouble.setArbitrationType(list.get(6).toString()); |
| | | |
| | | //仲裁类型 |
| | | DicItem dicItem =dicItems.parallelStream().filter(j->StrUtil.equalsIgnoreCase(j.getDicCode(),"zctype")&&StrUtil.equals(j.getDicItemName(),list.get(6).toString())).findFirst().orElse(null); |
| | | if (null!=dicItem){ |
| | | empLabortrouble.setArbitrationType(dicItem.getDicItemCode()); |
| | | } |
| | | |
| | | |
| | | empLabortrouble.setArbitrationReason(list.get(7).toString()); |
| | | empLabortrouble.setReporter(list.get(8).toString()); |
| | | empLabortrouble.setRemark(list.get(9).toString()); |
| | |
| | | if (StringUtils.isNotBlank(list.get(12).toString())) { |
| | | empLabortrouble.setSettleDate(DateUtil.parseDate(list.get(12).toString())); |
| | | } |
| | | empLabortrouble.setEmpStatus(empBaseInfo.getEmpStatus()); |
| | | this.save(empLabortrouble); |
| | | } |
| | | } |