| | |
| | | import com.alibaba.excel.context.AnalysisContext; |
| | | import com.alibaba.excel.event.AnalysisEventListener; |
| | | import com.google.common.collect.Lists; |
| | | import com.panzhihua.common.enums.PopulIsOkEnum; |
| | | import com.panzhihua.common.enums.PopulPoliticalOutlookEnum; |
| | | import com.panzhihua.common.enums.PopulSexEnum; |
| | | import com.panzhihua.common.enums.*; |
| | | import com.panzhihua.common.exceptions.ServiceException; |
| | | import com.panzhihua.common.model.vos.R; |
| | | import com.panzhihua.common.model.vos.community.ComMngPopulationServeExcelVO; |
| | | import com.panzhihua.common.service.community.CommunityService; |
| | | import com.panzhihua.common.utlis.AgeUtils; |
| | | import com.panzhihua.common.utlis.StringUtils; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | |
| | | import java.util.ArrayList; |
| | |
| | | vo.setIsRent(PopulIsOkEnum.getCodeByName(oneData.get(4))); |
| | | } |
| | | if(oneData.get(5) != null){ |
| | | vo.setRelation(oneData.get(5)); |
| | | vo.setRelation(PopulRelationEnum.getCodeByName(oneData.get(5))); |
| | | } |
| | | if(oneData.get(6) != null){ |
| | | vo.setRoad(oneData.get(6)); |
| | |
| | | vo.setNativePlace(oneData.get(12)); |
| | | } |
| | | if(oneData.get(13) != null){ |
| | | vo.setCultureLevel(oneData.get(13)); |
| | | vo.setCultureLevel(PopulCultureLevelEnum.getCodeByName(oneData.get(13))); |
| | | } |
| | | if(oneData.get(14) != null){ |
| | | vo.setMarriage(oneData.get(14)); |
| | | vo.setMarriage(PopulMarriageEnum.getCodeByName(oneData.get(14))); |
| | | } |
| | | if(oneData.get(15) != null){ |
| | | vo.setHealthy(oneData.get(15)); |
| | |
| | | if(oneData.get(16) != null){ |
| | | vo.setWorkCompany(oneData.get(16)); |
| | | } |
| | | if(oneData.get(17) != null){ |
| | | vo.setRemark(oneData.get(17)); |
| | | |
| | | if(oneData.get(17) != null && StringUtils.isNotEmpty(oneData.get(17))){ |
| | | String outOrLocal = oneData.get(17); |
| | | if(outOrLocal.equals(ComMngPopulationServeExcelVO.outOrLocal.bd)){ |
| | | vo.setOutOrLocal(1); |
| | | }else if(outOrLocal.equals(ComMngPopulationServeExcelVO.outOrLocal.wd)){ |
| | | vo.setOutOrLocal(2); |
| | | } |
| | | } |
| | | for (int i = 18; i < headSize; i++) { |
| | | if(oneData.get(18) != null){ |
| | | vo.setCensusRegister(oneData.get(18)); |
| | | } |
| | | if(oneData.get(19) != null){ |
| | | vo.setRemark(oneData.get(19)); |
| | | } |
| | | for (int i = 20; i < headSize; i++) { |
| | | if (oneData.get(i) != null && oneData.get(i).equals("是")) { |
| | | vo.getUserTagStr().add(headData.get(i)); |
| | | vo.getUserTagStr().add(headData.get(i).substring(0,headData.get(i).indexOf("("))); |
| | | } |
| | | } |
| | | voList.add(vo); |