风场sql修改

jpy

2023-05-28 5aa000fbc4a6c763edae4465158bb3a59213cb4e

风场sql修改

 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>