新增无人机当天查询sql

ZhuDongming

2019-08-13 83941694ce880ee4c0e280ca08ab9361d4706dd9

新增无人机当天查询sql

 src/main/resources/mapper/HistoryMapper.xml

@@ -169,4 +169,26 @@
        WHERE mac = #{mac}

        AND time BETWEEN #{starttime} AND #{endtime}

    </select>



    <!-- 无人机sensor当天查询 -->

    <select id="getSensorDataToday" resultType="java.util.LinkedHashMap">

        SELECT

        DATE_FORMAT(time,'%Y-%m-%d %H:%i') time,

        <foreach collection="sensorKeys" separator="," item="sensorKey">

            AVG(h.value ->'$.${sensorKey}') AS '${sensorKey}'

        </foreach>

        FROM

        history h

        <where>

            <if test="mac!=null">

                and h.mac=#{mac}

            </if>

            and h.time >= #{startTime}

            and h.time <![CDATA[<=]]> #{endTime}

        </where>

        GROUP BY

        DATE_FORMAT(time,'%Y-%m-%d %H:%i')

        ORDER BY

        time

    </select>

</mapper>