From 588b1da35a1a51ddfca76fb8ca9c2c0c6cd70038 Mon Sep 17 00:00:00 2001 From: 648540858 <648540858@qq.com> Date: 星期一, 13 五月 2024 11:12:20 +0800 Subject: [PATCH] Merge branch 'refs/heads/2.7.0' into 271-优化notify存储 --- src/main/java/com/genersoft/iot/vmp/storager/dao/DeviceChannelMapper.java | 17 +++++++++++++++++ 1 files changed, 17 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/genersoft/iot/vmp/storager/dao/DeviceChannelMapper.java b/src/main/java/com/genersoft/iot/vmp/storager/dao/DeviceChannelMapper.java index 1555221..be78a52 100755 --- a/src/main/java/com/genersoft/iot/vmp/storager/dao/DeviceChannelMapper.java +++ b/src/main/java/com/genersoft/iot/vmp/storager/dao/DeviceChannelMapper.java @@ -401,6 +401,23 @@ " </script>"}) int updatePosition(DeviceChannel deviceChannel); + @Update({"<script>" + + "<foreach collection='deviceChannelList' item='item' separator=';'>" + + " UPDATE" + + " wvp_device_channel" + + " SET gps_time=#{item.gpsTime}" + + "<if test='item.longitude != null'>, longitude=#{item.longitude}</if>" + + "<if test='item.latitude != null'>, latitude=#{item.latitude}</if>" + + "<if test='item.longitudeGcj02 != null'>, longitude_gcj02=#{item.longitudeGcj02}</if>" + + "<if test='item.latitudeGcj02 != null'>, latitude_gcj02=#{item.latitudeGcj02}</if>" + + "<if test='item.longitudeWgs84 != null'>, longitude_wgs84=#{item.longitudeWgs84}</if>" + + "<if test='item.latitudeWgs84 != null'>, latitude_wgs84=#{item.latitudeWgs84}</if>" + + "WHERE device_id=#{item.deviceId} " + + " <if test='item.channelId != null' > AND channel_id=#{item.channelId}</if>" + + "</foreach>" + + "</script>"}) + int batchUpdatePosition(List<DeviceChannel> deviceChannelList); + @Select("SELECT * FROM wvp_device_channel WHERE length(trim(stream_id)) > 0") List<DeviceChannel> getAllChannelInPlay(); -- Gitblit v1.8.0