chore:补充提交

jinpengyong

2023-11-01 77fb7786036fd4c7dd16b9b15c6569cdf2d8ba19

 screen-api/src/main/java/com/moral/api/service/impl/ExcelServiceImpl.java

@@ -491,60 +491,60 @@
            HashMap<String, Object> map = new HashMap<>();
            map.put("mac", objects[0]);
            map.put("time", objects[1]);
            // pm2.5
            if (!objects[2].toString().equals("-")){
                map.put("a34004", objects[2]);
            }

            // pm10
            if (!objects[3].toString().equals("-")){
                map.put("a34002", objects[3]);
            }
            // 二氧化硫
            if (!objects[2].toString().equals("--")){
                map.put("a21026", objects[2]);
            if (!objects[4].toString().equals("-")){
                map.put("a21026", objects[4]);
            }

            // 二氧化氮
            if (!objects[3].toString().equals("--")){
                map.put("a21004", objects[3]);
            if (!objects[5].toString().equals("-")){
                map.put("a21004", objects[5]);
            }
            // 一氧化碳
            if (!objects[4].toString().equals("--")){
                map.put("a21005", objects[4]);
            // co
            if (!objects[6].toString().equals("-")){
                map.put("a21005", objects[6]);
            }
            // 臭氧
            if (!objects[5].toString().equals("--")){
                map.put("a05024", objects[5]);
            }
            // PM10
            if (!objects[6].toString().equals("--")){
                map.put("a34002", objects[6]);
            }
            // PM 2.5
            if (!objects[7].toString().equals("--")){
                map.put("a34004", objects[7]);
            // o3
            if (!objects[7].toString().equals("-")){
                map.put("a05024", objects[7]);
            }

            // TVOCs
            if (!objects[8].toString().equals("--")){
                map.put("a99054", objects[8]);
            }
            // 温度
            if (!objects[9].toString().equals("--")){
                map.put("a01001", objects[9]);
            if (!objects[8].toString().equals("-")){
                map.put("a01001", objects[8]);
            }
            // 湿度
            if (!objects[10].toString().equals("--")){
                map.put("a01002", objects[10]);
            if (!objects[9].toString().equals("-")){
                map.put("a01002", objects[9]);
            }
            // 气压
            if (!objects[11].toString().equals("--")){
                map.put("a01006", objects[11]);
            }

            // 风速
            if (!objects[12].toString().equals("--")){
                map.put("a01007", objects[12]);
            if (!objects[10].toString().equals("-")){
                map.put("a01007", objects[10]);
            }
            // 风向
            if (!objects[13].toString().equals("--")){
                map.put("a01008", objects[13]);
            if (!objects[11].toString().equals("-")){
                map.put("a01008", objects[11]);
            }
            // 光照
            if (!objects[14].toString().equals("--")){
                map.put("a00e12", objects[14]);

            // 气压
            if (!objects[12].toString().equals("-")){
                map.put("a01006", objects[12]);
            }
            // 光照强度
            if (!objects[13].toString().equals("-")){
                map.put("a00e12", objects[13]);
            }
            // tvoc
            if (!objects[14].toString().equals("-")){
                map.put("a99054", objects[14]);
            }

//            map.put("颗粒物0.3", objects[15]);
@@ -561,7 +561,13 @@
        for (Map<String, Object> map : list) {
            HistoryDaily historyDaily = new HistoryDaily();
            String time = map.remove("time").toString();
            Date date = DateUtils.dateStringToDate(time);
            Date date=null;
            if (time.length()>20){
                date = DateUtils.dateStringToDate(time);
            }else {
                date = DateUtils.getDate(time, DateUtils.yyyy_MM_dd_HH_mm_ss_EN);
            }

            String mac = map.remove("mac").toString();
            String value = JSONObject.toJSONString(map);
            historyDaily.setMac(mac);