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