风场sql

jpy

2023-05-28 a30cc74a46477c1820c6114cbda7f4e11b3aaf0d

风场sql

 screen-api/src/main/resources/mapper/HistoryFiveMinutelyMapper.xml

@@ -12,13 +12,12 @@
        h.value->'$.a01008' AS windDir
        FROM history_five_minutely_${timeUnits} h ,
        `device` AS d
        WHERE d.mac = h.mac
        AND d.mac IN
        (SELECT mac FROM device WHERE 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 = (SELECT max(time) FROM history_five_minutely_${timeUnits})
    </select>