lizijie
2019-10-14 9f79dd626f3a5096acedcae8d7a919c8910ac240
修改单位
2 files modified
7 ■■■■■ changed files
src/main/java/com/moral/controller/ScreenController.java 5 ●●●●● patch | view | raw | blame | history
src/main/resources/mapper/SensorMapper.xml 2 ●●● patch | view | raw | blame | history
src/main/java/com/moral/controller/ScreenController.java
@@ -1030,10 +1030,11 @@
        String monitor_point_id = (String) parameters.get("monitor_point_id");
        List<Map<String, Object>> list = sensorService.getSensorByMonitorPointId(monitor_point_id);
        List<Map<String, Object>> sensorUnitList = sensorUnitService.getSensorsByMonitPointId2(monitor_point_id);
        System.out.println(sensorUnitList);
        System.out.println("list:"+list);
        System.out.println("sensorUnitList:"+sensorUnitList);
        for (Map<String, Object> sensorMap : list) {
            for (Map<String, Object> sensorUnitMap : sensorUnitList) {
                if (sensorUnitMap.get("sensor_key").equals(sensorMap.get("sensor_key"))) {
                if (sensorUnitMap.get("sensor_key").equals(sensorMap.get("sensorKey"))) {
                    sensorMap.put("unit", sensorUnitMap.get("name"));
                }
            }
src/main/resources/mapper/SensorMapper.xml
@@ -138,7 +138,7 @@
    </select>
    
    <select id="getSensorByMonitorPointId" resultType="java.util.Map">
        SELECT DISTINCT s.*
        SELECT DISTINCT s.sensor_key sensorKey,s.unit,s.name,s.description,s.id
        FROM device d,device_version dv,device_version_sensor dvs,sensor s
        WHERE d.device_version_id = dvs.device_version_id
        AND dvs.sensor_id = s.id