| | |
| | | package com.panzhihua.common.listen; |
| | | |
| | | import cn.hutool.core.date.DateException; |
| | | import cn.hutool.core.date.DateUtil; |
| | | import com.alibaba.excel.EasyExcel; |
| | | import com.alibaba.excel.ExcelWriter; |
| | |
| | | import java.io.File; |
| | | import java.io.FileInputStream; |
| | | import java.io.InputStream; |
| | | import java.text.ParseException; |
| | | import java.util.ArrayList; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | |
| | | vo.setNotPlaceReason(oneData.get(34).trim()); |
| | | } |
| | | if(StringUtils.isNotEmpty(oneData.get(35))){ |
| | | vo.setHelpBegin(DateUtil.parse(oneData.get(35).trim())); |
| | | try { |
| | | vo.setHelpBegin(DateUtil.parse(oneData.get(35).trim())); |
| | | } catch (DateException e) { |
| | | log.info("处理数据时失败"); |
| | | e.printStackTrace(); |
| | | ComMngPopulationRehabilitationMistakeExcelVO mistake = new ComMngPopulationRehabilitationMistakeExcelVO(); |
| | | index++; |
| | | setRehabilitationMistake(oneData, mistake); |
| | | mistake.setMistake("您填写的帮教开始日期有误"); |
| | | mistakes.add(mistake); |
| | | continue; |
| | | } |
| | | } |
| | | if(StringUtils.isNotEmpty(oneData.get(36))){ |
| | | vo.setHelpEnd(DateUtil.parse(oneData.get(36).trim())); |
| | | try { |
| | | vo.setHelpEnd(DateUtil.parse(oneData.get(36).trim())); |
| | | } catch (DateException e) { |
| | | log.info("处理数据时失败"); |
| | | e.printStackTrace(); |
| | | ComMngPopulationRehabilitationMistakeExcelVO mistake = new ComMngPopulationRehabilitationMistakeExcelVO(); |
| | | index++; |
| | | setRehabilitationMistake(oneData, mistake); |
| | | mistake.setMistake("您填写的帮教结束日期有误"); |
| | | mistakes.add(mistake); |
| | | continue; |
| | | } |
| | | } |
| | | if(StringUtils.isNotEmpty(oneData.get(37))){ |
| | | vo.setHelpSituation(oneData.get(37).trim()); |