648540858
2023-05-04 381c3bdc2079ece5147cf4cee004e9071edadf7a
src/main/java/com/genersoft/iot/vmp/storager/dao/DeviceMapper.java
@@ -171,9 +171,6 @@
    @Delete("DELETE FROM device WHERE deviceId=#{deviceId}")
    int del(String deviceId);
    @Update("UPDATE device SET online=0")
    int outlineForAll();
    @Select("SELECT " +
            "deviceId, " +
            "coalesce(custom_name, name) as name, " +
@@ -258,7 +255,7 @@
            "<if test=\"mediaServerId != null\">, mediaServerId=#{mediaServerId}</if>" +
            "WHERE deviceId=#{deviceId}"+
            " </script>"})
    int updateCustom(Device device);
    void updateCustom(Device device);
    @Insert("INSERT INTO device (" +
            "deviceId, " +
@@ -272,7 +269,7 @@
            "asMessageChannel," +
            "geoCoordSys," +
            "treeType," +
            "online" +
            "online," +
            "mediaServerId" +
            ") VALUES (" +
            "#{deviceId}," +
@@ -286,7 +283,7 @@
            "#{asMessageChannel}," +
            "#{geoCoordSys}," +
            "#{treeType}," +
            "#{online}" +
            "#{online}," +
            "#{mediaServerId}" +
            ")")
    void addCustomDevice(Device device);