From 5aa000fbc4a6c763edae4465158bb3a59213cb4e Mon Sep 17 00:00:00 2001
From: jpy <812110275@qq.com>
Date: Sun, 28 May 2023 16:50:37 +0800
Subject: [PATCH] 风场sql修改
---
screen-api/src/main/resources/mapper/HistoryHourlyMapper.xml | 35 ++++++++++++++++++++++++-----------
1 files changed, 24 insertions(+), 11 deletions(-)
diff --git a/screen-api/src/main/resources/mapper/HistoryHourlyMapper.xml b/screen-api/src/main/resources/mapper/HistoryHourlyMapper.xml
index 2ef6b15..b2cc720 100644
--- a/screen-api/src/main/resources/mapper/HistoryHourlyMapper.xml
+++ b/screen-api/src/main/resources/mapper/HistoryHourlyMapper.xml
@@ -3,9 +3,12 @@
<mapper namespace="com.moral.api.mapper.HistoryHourlyMapper">
<select id="selectHourlyData" resultType="java.lang.String">
- SELECT `value` FROM history_hourly_${timeUnits} WHERE mac = #{mac} AND `time` = #{time}
+ SELECT `value`
+ FROM history_hourly_${timeUnits}
+ WHERE mac = #{mac}
+ AND `time` = #{time}
</select>
-
+
<select id="selectDataByMacsAndTime" parameterType="java.util.List" resultType="java.util.Map">
select mac, `time`, `value` from history_hourly_${timeUnits}
where mac in
@@ -16,9 +19,11 @@
</select>
<select id="queryLastHourlyMac" resultType="java.lang.String">
- SELECT `value` FROM history_hourly_${timeUnits} WHERE mac = #{mac} AND `time` = #{time}
+ SELECT `value`
+ FROM history_hourly_${timeUnits}
+ WHERE mac = #{mac}
+ AND `time` = #{time}
</select>
-
<select id="getArea" resultType="com.moral.api.pojo.dto.Wind.WindData">
@@ -30,27 +35,35 @@
h.value->'$.a01008' AS windDir
FROM history_hourly_${timeUnits} h ,
`device` AS d
- WHERE d.mac = h.mac
- AND d.mac IN
- (SELECT mac FROM device WHERE is_delete = '0' and monitor_point_id IN
+ WHERE d.is_delete = '0'
+ and d.mac = h.mac
+ AND d.monitor_point_id IN
<foreach item="monitorPointId" collection="monitorPointIds" index="index" open="(" separator="," close=")">
#{monitorPointId}
</foreach>
- )
AND h.time = #{time}
</select>
<select id="getTVOCByMac" resultType="java.lang.String">
- select `value` ->'$.${sensor}' from history_hourly_${yearAndMonth} where mac=#{mac} and time=#{time}
+ select `value` - > '$.${sensor}'
+ from history_hourly_${yearAndMonth}
+ where mac = #{mac}
+ and time =#{time}
</select>
<select id="getPressureByMac" resultType="java.lang.String">
- select `value`->'$.a01006' from history_hourly_${yearAndMonth} where mac=#{mac} and time=#{time}
+ select `value` - > '$.a01006'
+ from history_hourly_${yearAndMonth}
+ where mac = #{mac}
+ and time =#{time}
</select>
<select id="getDataByMac" resultType="java.util.Map">
- select `value` from history_hourly_${yearAndMonth} where mac=#{mac} and time=#{time}
+ select `value`
+ from history_hourly_${yearAndMonth}
+ where mac = #{mac}
+ and time =#{time}
</select>
</mapper>
\ No newline at end of file
--
Gitblit v1.8.0