Update --bug---.md

648540858

2023-04-15 f5d07c4c14a6555c0f1c80f5f47881a431570622

 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);