update

jinpengyong

2020-09-21 f694728af353dcf32e270c0b1b27d81ba76fecd8

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
package com.moral.service.impl;
 
import java.time.LocalDateTime;
import java.time.temporal.ChronoUnit;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.HashMap;
import java.util.HashSet;
import java.util.List;
import java.util.Map;
import java.util.Set;
import java.util.stream.Collectors;
 
import javax.annotation.Resource;
 
import org.springframework.stereotype.Service;
 
import com.alibaba.druid.support.json.JSONUtils;
import com.moral.mapper.AlarmMapper;
import com.moral.service.AlarmService;
 
 
@Service
public class AlarmServiceImpl implements AlarmService {
 
    @Resource
    private AlarmMapper alarmMapper;
 
    @Override
    public int insertAlarmDaily() {
        LocalDateTime time = LocalDateTime.now();
        LocalDateTime endTime = time.truncatedTo(ChronoUnit.DAYS);
        LocalDateTime startTime = endTime.minusDays(1);
        String year = startTime.getYear() + "";
        String month = null;
        int monthValue = startTime.getMonthValue();
        if (monthValue < 10) {
            month = "0" + monthValue;
        } else {
            month = monthValue + "";
        }
        String yearAndMonth = year + month;
        Map<String, Object> devices = new HashMap<>();
        devices.put("start", startTime);
        devices.put("end", endTime);
        devices.put("yearAndMonth", yearAndMonth);
        List<String> macs = alarmMapper.getMacs(devices);
        int count = 0;
        for (String mac : macs) {
            List<Map<String, Object>> resultList = new ArrayList<>();
            devices.put("mac", mac);
            List<Map<String, Object>> list = alarmMapper.getAlarmData(devices);
            List<Map<String, Object>> newList = list.stream().distinct().collect(Collectors.toList());
            for (Map<String, Object> map : newList) {
                for (String key : map.keySet()) {
                    String[] strings = map.get(key).toString().replace("$.", "")
                            .replace("[", "").replace("]", "")
                            .replace("\"", "").replace(" ", "").split(",");
 
                    List<String> sensors = new ArrayList<String>(Arrays.asList(strings));
                    map.put(key, sensors);
 
                }
            }
            Map<String, Object> hashMap = new HashMap<>();
            Set<String> stateSet1 = new HashSet<>();
            Set<String> stateSet2 = new HashSet<>();
            Set<String> stateSet3 = new HashSet<>();
            for (Map<String, Object> map : newList) {
                if (map.get("1") != null) {
                    stateSet1.addAll((ArrayList<String>) map.get("1"));
                    hashMap.put("1", stateSet1);
                }
                if (map.get("2") != null) {
                    stateSet2.addAll((ArrayList<String>) map.get("2"));
                    hashMap.put("2", stateSet2);
                }
                if (map.get("3") != null) {
                    stateSet3.addAll((ArrayList<String>) map.get("3"));
                    hashMap.put("3", stateSet3);
                }
            }
 
            for (String key : hashMap.keySet()) {
                Map<String, Object> jsonMap = new HashMap<>();
                Map<String, Object> map = new HashMap<>();
                map.put("mac", mac);
                map.put("time", startTime);
                map.put("state", key);
                Set<String> sensors = (Set<String>) hashMap.get(key);
                for (String sensor : sensors) {
                    jsonMap.put(sensor, 1);
                }
                map.put("json", JSONUtils.toJSONString(jsonMap));
                resultList.add(map);
            }
            count = count + alarmMapper.insertAlarmDaily(resultList);
        }
        return count;
    }
 
    @Override
    public void createTable(String yearAndMonth) {
        alarmMapper.createTable(yearAndMonth);
    }
}