update import

kongzy

2024-10-30 e7afed8cdb301a311dbad5ed23c7ff9f826b2c48

 assess-system/src/main/java/com/gkhy/assess/system/excel/ExpertExcelListener.java

@@ -40,6 +40,8 @@
    public void invoke(SysExpertInfoExcelVO sysExpertInfoExcelVO, AnalysisContext analysisContext) {
        if(!StringUtils.isBlank(sysExpertInfoExcelVO.getName())){
            cachedDateList.add(sysExpertInfoExcelVO);
        }else{
            System.out.println("ffffff");
        }
        if(cachedDateList.size()>=BATCH_COUNT){
            saveData();
@@ -55,24 +57,28 @@
            SysExpertInfo existExpertInfo = SpringUtil.getBean(SysExpertInfoService.class).getOne(Wrappers.<SysExpertInfo>lambdaQuery()
                    .eq(true, SysExpertInfo::getIdCard, idCard)
                    .last(" limit 1"));
            direction=direction.replace("安全生产：","").trim();
            String[] splits = direction.split("、");
            List<String> safetyArray=new ArrayList<>();
            for(String str:splits){
                str=str.trim();
                String code="1";
                if(str.equals("现场检查")){
                    code="1";
                }else if(str.equals("调查评估")){
                    code="2";
                }else if(str.equals("咨询服务")){
                    code="3";
                }else if(str.equals("教育培训")){
                    code="4";
                }else{
                    code="5";
            List<String> safetyArray = new ArrayList<>();
            if(!StringUtils.isBlank(direction)) {
                direction = direction.replace("安全生产：", "").trim();
                String[] splits = direction.split("、");
                for (String str : splits) {
                    str = str.trim();
                    String code = "1";
                    if (str.equals("现场检查")) {
                        code = "1";
                    } else if (str.equals("调查评估")) {
                        code = "2";
                    } else if (str.equals("咨询服务")) {
                        code = "3";
                    } else if (str.equals("教育培训")) {
                        code = "4";
                    } else {
                        code = "5";
                    }
                    safetyArray.add(code);
                }
                safetyArray.add(code);
            }else{
                safetyArray.add("5");
            }
            if(existExpertInfo!=null){
                existExpertInfo.setState(2);