From bd0fafde817b60dee79b1e4dd091a5e34ac8625c Mon Sep 17 00:00:00 2001
From: 648540858 <648540858@qq.com>
Date: 星期一, 15 四月 2024 15:51:10 +0800
Subject: [PATCH] 修复目录订阅发送订阅未携带经纬度的问题

---
 数据库/2.7.0/更新-mysql-2.7.0.sql                                                               |   12 +++++++++++-
 src/main/java/com/genersoft/iot/vmp/gb28181/transmit/cmd/impl/SIPCommanderFroPlatform.java |    2 ++
 数据库/2.7.0/更新-postgresql-kingbase-2.7.0.sql                                                 |   12 +++++++++++-
 3 files changed, 24 insertions(+), 2 deletions(-)

diff --git a/src/main/java/com/genersoft/iot/vmp/gb28181/transmit/cmd/impl/SIPCommanderFroPlatform.java b/src/main/java/com/genersoft/iot/vmp/gb28181/transmit/cmd/impl/SIPCommanderFroPlatform.java
index 2964654..2082d39 100755
--- a/src/main/java/com/genersoft/iot/vmp/gb28181/transmit/cmd/impl/SIPCommanderFroPlatform.java
+++ b/src/main/java/com/genersoft/iot/vmp/gb28181/transmit/cmd/impl/SIPCommanderFroPlatform.java
@@ -665,6 +665,8 @@
                                 .append("<Owner> " + channel.getOwner()+ "</Owner>\r\n")
                                 .append("<CivilCode>" + channel.getCivilCode() + "</CivilCode>\r\n")
                                 .append("<Address>" + channel.getAddress() + "</Address>\r\n");
+                        catalogXml.append("<Longitude>" + channel.getLongitude() + "</Longitude>\r\n");
+                        catalogXml.append("<Latitude>" + channel.getLatitude() + "</Latitude>\r\n");
                     }
                     if (!"presence".equals(subscribeInfo.getEventType())) {
                         catalogXml.append("<Event>" + type + "</Event>\r\n");
diff --git "a/\346\225\260\346\215\256\345\272\223/2.7.0/\346\233\264\346\226\260-mysql-2.7.0.sql" "b/\346\225\260\346\215\256\345\272\223/2.7.0/\346\233\264\346\226\260-mysql-2.7.0.sql"
index c229fb1..b14a5c8 100644
--- "a/\346\225\260\346\215\256\345\272\223/2.7.0/\346\233\264\346\226\260-mysql-2.7.0.sql"
+++ "b/\346\225\260\346\215\256\345\272\223/2.7.0/\346\233\264\346\226\260-mysql-2.7.0.sql"
@@ -4,5 +4,15 @@
 alter table wvp_device
     drop switch_primary_sub_stream;
 
+# 绗竴涓ˉ涓佸寘
 alter table wvp_platform
-    add send_stream_ip character varying(50);
\ No newline at end of file
+    add send_stream_ip character varying(50);
+
+alter table wvp_device
+    change on_line on_line bool default false;
+
+alter table wvp_device
+    change id id serial primary key;
+
+alter table wvp_device
+    change ssrc_check ssrc_check bool default false;
\ No newline at end of file
diff --git "a/\346\225\260\346\215\256\345\272\223/2.7.0/\346\233\264\346\226\260-postgresql-kingbase-2.7.0.sql" "b/\346\225\260\346\215\256\345\272\223/2.7.0/\346\233\264\346\226\260-postgresql-kingbase-2.7.0.sql"
index c229fb1..b14a5c8 100644
--- "a/\346\225\260\346\215\256\345\272\223/2.7.0/\346\233\264\346\226\260-postgresql-kingbase-2.7.0.sql"
+++ "b/\346\225\260\346\215\256\345\272\223/2.7.0/\346\233\264\346\226\260-postgresql-kingbase-2.7.0.sql"
@@ -4,5 +4,15 @@
 alter table wvp_device
     drop switch_primary_sub_stream;
 
+# 绗竴涓ˉ涓佸寘
 alter table wvp_platform
-    add send_stream_ip character varying(50);
\ No newline at end of file
+    add send_stream_ip character varying(50);
+
+alter table wvp_device
+    change on_line on_line bool default false;
+
+alter table wvp_device
+    change id id serial primary key;
+
+alter table wvp_device
+    change ssrc_check ssrc_check bool default false;
\ No newline at end of file

--
Gitblit v1.8.0