thingsKit_1.2.2_1.3.0.sql
22.3 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
--更新区域表的名称
update sys_area
set name ='澳门特别行政区'
where code = 820000
and "level" = 'PROVINCE';
update sys_area
set name ='香港特别行政区'
where code = 810000
and "level" = 'PROVINCE';
UPDATE "public"."sys_area"
SET "name" = '香港特别行政区',
"level" = 'CITY'
WHERE "code" = 810000
AND "parent_id" = 810000;
UPDATE "public"."sys_area"
SET "name" = '澳门特别行政区',
"level" = 'CITY'
WHERE "code" = 820000
AND "parent_id" = 820000;
ALTER TABLE tk_device_camera ALTER COLUMN name TYPE varchar(128);
DROP TABLE IF EXISTS "public"."tk_media_server";
CREATE TABLE "public"."tk_media_server"
(
"id" varchar(36) COLLATE "pg_catalog"."default" NOT NULL,
"ip" varchar(20) COLLATE "pg_catalog"."default",
"hook_ip" varchar(20) COLLATE "pg_catalog"."default",
"sdp_ip" varchar(20) COLLATE "pg_catalog"."default",
"stream_ip" varchar(20) COLLATE "pg_catalog"."default",
"http_port" int4,
"http_ssl_port" int4,
"rtmp_port" int4,
"rtmp_ssl_port" int4,
"rtp_proxy_port" int4,
"rtsp_port" int4,
"rtsp_ssl_port" int4,
"secret" varchar(50) COLLATE "pg_catalog"."default",
"rtp_enable" bool,
"rtp_port_range" varchar(20) COLLATE "pg_catalog"."default",
"send_rtp_port_range" varchar(20) COLLATE "pg_catalog"."default",
"record_assist_port" int4,
"status" int2,
"tenant_id" varchar(36) COLLATE "pg_catalog"."default",
"creator" char(36) COLLATE "pg_catalog"."default",
"create_time" timestamp(6),
"updater" char(36) COLLATE "pg_catalog"."default",
"update_time" timestamp(6),
"remark" varchar(255) COLLATE "pg_catalog"."default",
"default_server" bool,
"media_server_id" varchar(36) COLLATE "pg_catalog"."default",
"auto_config" bool,
"hook_alive_interval" float4
)
;
COMMENT
ON COLUMN "public"."tk_media_server"."id" IS '主键ID';
COMMENT
ON COLUMN "public"."tk_media_server"."ip" IS 'IP';
COMMENT
ON COLUMN "public"."tk_media_server"."hook_ip" IS 'zlmediakit访问平台的IP';
COMMENT
ON COLUMN "public"."tk_media_server"."sdp_ip" IS 'SDP IP';
COMMENT
ON COLUMN "public"."tk_media_server"."stream_ip" IS '流IP';
COMMENT
ON COLUMN "public"."tk_media_server"."http_port" IS 'zlmediakit的HTTP端口';
COMMENT
ON COLUMN "public"."tk_media_server"."http_ssl_port" IS 'zlmediakit的HTTPS端口';
COMMENT
ON COLUMN "public"."tk_media_server"."rtmp_port" IS 'zlmediakit的RTMP端口';
COMMENT
ON COLUMN "public"."tk_media_server"."rtmp_ssl_port" IS 'zlmediakit的RTMPS端口';
COMMENT
ON COLUMN "public"."tk_media_server"."rtp_proxy_port" IS 'RTP收流端口（单端口模式有用）';
COMMENT
ON COLUMN "public"."tk_media_server"."rtsp_port" IS 'zlmediakit的RTSP端口';
COMMENT
ON COLUMN "public"."tk_media_server"."rtsp_ssl_port" IS 'zlmediakit的RTSPS端口';
COMMENT
ON COLUMN "public"."tk_media_server"."secret" IS 'zlmediakit的鉴权参数';
COMMENT
ON COLUMN "public"."tk_media_server"."rtp_enable" IS '是否使用多端口模式';
COMMENT
ON COLUMN "public"."tk_media_server"."rtp_port_range" IS '多端口RTP收流端口范围';
COMMENT
ON COLUMN "public"."tk_media_server"."send_rtp_port_range" IS '多端口RTP发流端口范围';
COMMENT
ON COLUMN "public"."tk_media_server"."record_assist_port" IS '录像辅助端口：0代表未使用';
COMMENT
ON COLUMN "public"."tk_media_server"."status" IS '流媒体服务状态：0离线 1在线';
COMMENT
ON COLUMN "public"."tk_media_server"."tenant_id" IS '租户ID';
COMMENT
ON COLUMN "public"."tk_media_server"."creator" IS '创建用户';
COMMENT
ON COLUMN "public"."tk_media_server"."create_time" IS '创建时间';
COMMENT
ON COLUMN "public"."tk_media_server"."updater" IS '更新用户';
COMMENT
ON COLUMN "public"."tk_media_server"."update_time" IS '更新时间';
COMMENT
ON COLUMN "public"."tk_media_server"."remark" IS '备注';
COMMENT
ON COLUMN "public"."tk_media_server"."default_server" IS '是否系统默认服务';
COMMENT
ON COLUMN "public"."tk_media_server"."media_server_id" IS '流媒体ID';
COMMENT
ON COLUMN "public"."tk_media_server"."auto_config" IS '是否开启自动配置ZLM';
COMMENT
ON COLUMN "public"."tk_media_server"."hook_alive_interval" IS 'keepalive hook触发间隔,单位秒';
COMMENT
ON TABLE "public"."tk_media_server" IS '流媒体表（ZLMediakit）GBT28181';
-- ----------------------------
-- Primary Key structure for table tk_media_server
-- ----------------------------
ALTER TABLE "public"."tk_media_server"
ADD CONSTRAINT "tk_media_server_pkey" PRIMARY KEY ("id");
DROP TABLE IF EXISTS "public"."tk_video_channel";
CREATE TABLE "public"."tk_video_channel"
(
"id" varchar(36) COLLATE "pg_catalog"."default" NOT NULL,
"name" varchar(36) COLLATE "pg_catalog"."default",
"camera_code" varchar(50) COLLATE "pg_catalog"."default",
"manufacturer" varchar(50) COLLATE "pg_catalog"."default",
"model" varchar(36) COLLATE "pg_catalog"."default",
"owner" varchar(36) COLLATE "pg_catalog"."default",
"civil_code" varchar(50) COLLATE "pg_catalog"."default",
"address" varchar(255) COLLATE "pg_catalog"."default",
"parental" int2,
"safety_way" int2 DEFAULT 0,
"register_way" int2 DEFAULT 1,
"cert_num" varchar(50) COLLATE "pg_catalog"."default",
"certifiable" int2 DEFAULT 0,
"error_code" int2 DEFAULT 1,
"end_time" timestamp(6),
"secrecy" int2 DEFAULT 0,
"ip_address" varchar(36) COLLATE "pg_catalog"."default",
"port" int4,
"password" varchar(128) COLLATE "pg_catalog"."default",
"status" varchar(20) COLLATE "pg_catalog"."default",
"tenant_id" varchar(36) COLLATE "pg_catalog"."default" NOT NULL,
"creator" char(36) COLLATE "pg_catalog"."default",
"create_time" timestamp(6),
"updater" char(36) COLLATE "pg_catalog"."default",
"update_time" timestamp(6),
"remark" varchar(255) COLLATE "pg_catalog"."default",
"channel_id" varchar(50) COLLATE "pg_catalog"."default",
"stream_id" varchar(50) COLLATE "pg_catalog"."default",
"device_id" varchar(36) COLLATE "pg_catalog"."default"
)
;
COMMENT
ON COLUMN "public"."tk_video_channel"."id" IS '视频通道编码ID';
COMMENT
ON COLUMN "public"."tk_video_channel"."name" IS '视频通道名称';
COMMENT
ON COLUMN "public"."tk_video_channel"."camera_code" IS '设备国标编号';
COMMENT
ON COLUMN "public"."tk_video_channel"."manufacturer" IS '制造厂商';
COMMENT
ON COLUMN "public"."tk_video_channel"."model" IS '型号';
COMMENT
ON COLUMN "public"."tk_video_channel"."owner" IS '设备归属';
COMMENT
ON COLUMN "public"."tk_video_channel"."civil_code" IS '行政区域';
COMMENT
ON COLUMN "public"."tk_video_channel"."address" IS '安装地址';
COMMENT
ON COLUMN "public"."tk_video_channel"."parental" IS '是否有子设备: 0没有 1有';
COMMENT
ON COLUMN "public"."tk_video_channel"."safety_way" IS '信令安全模式缺省为0; 0:不采用;2:S/MIME 签名方式;3:S/
MIME加密签名同时采用方式;4:数字摘要方式';
COMMENT
ON COLUMN "public"."tk_video_channel"."register_way" IS '注册方式缺省为1;1:符合IETFRFC3261标准的认证注册模
式;2:基于口令的双向认证注册模式;3:基于数字证书的双向认证注册模式';
COMMENT
ON COLUMN "public"."tk_video_channel"."cert_num" IS '证书序列号';
COMMENT
ON COLUMN "public"."tk_video_channel"."certifiable" IS '证书有效标识(有证书的设备必选)缺省为0;证书有效标识:0:无效 1:
有效';
COMMENT
ON COLUMN "public"."tk_video_channel"."error_code" IS '无效原因码';
COMMENT
ON COLUMN "public"."tk_video_channel"."end_time" IS '证书终止有效期';
COMMENT
ON COLUMN "public"."tk_video_channel"."secrecy" IS '保密属性缺省为0;0:不涉密,1:涉密';
COMMENT
ON COLUMN "public"."tk_video_channel"."ip_address" IS '系统IP地址';
COMMENT
ON COLUMN "public"."tk_video_channel"."port" IS '端口';
COMMENT
ON COLUMN "public"."tk_video_channel"."password" IS '密码';
COMMENT
ON COLUMN "public"."tk_video_channel"."status" IS '通道状态：ON 在线 OFF 离线，使用枚举值';
COMMENT
ON COLUMN "public"."tk_video_channel"."tenant_id" IS '租户ID';
COMMENT
ON COLUMN "public"."tk_video_channel"."creator" IS '创建人';
COMMENT
ON COLUMN "public"."tk_video_channel"."create_time" IS '创建时间';
COMMENT
ON COLUMN "public"."tk_video_channel"."updater" IS '更新人';
COMMENT
ON COLUMN "public"."tk_video_channel"."update_time" IS '更新时间';
COMMENT
ON COLUMN "public"."tk_video_channel"."remark" IS '备注';
COMMENT
ON COLUMN "public"."tk_video_channel"."channel_id" IS '视频通道编码ID';
COMMENT
ON COLUMN "public"."tk_video_channel"."stream_id" IS '流唯一编号，存在表示正在直播';
COMMENT
ON COLUMN "public"."tk_video_channel"."device_id" IS '通道所属设备ID';
COMMENT
ON TABLE "public"."tk_video_channel" IS '摄像头通道信息表（字段来源于GBT28181）';
-- ----------------------------
-- Primary Key structure for table tk_video_channel
-- ----------------------------
ALTER TABLE "public"."tk_video_channel"
ADD CONSTRAINT "tk_video_channel_pkey" PRIMARY KEY ("id");
DROP TABLE IF EXISTS "public"."tk_device_access_information";
CREATE TABLE "public"."tk_device_access_information"
(
"id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
"intranet_ip" varchar(100) COLLATE "pg_catalog"."default",
"intranet_port" varchar(100) COLLATE "pg_catalog"."default",
"outer_net_ip" varchar(100) COLLATE "pg_catalog"."default",
"outer_net_port" varchar(100) COLLATE "pg_catalog"."default",
"device_agreement" varchar(100) COLLATE "pg_catalog"."default",
"sip_extend" varchar COLLATE "pg_catalog"."default",
"creator" char(64) COLLATE "pg_catalog"."default",
"create_time" timestamp(0),
"updater" char(64) COLLATE "pg_catalog"."default",
"update_time" timestamp(0),
"tenant_id" varchar(64) COLLATE "pg_catalog"."default"
)
;
COMMENT
ON COLUMN "public"."tk_device_access_information"."intranet_ip" IS '内网ip';
COMMENT
ON COLUMN "public"."tk_device_access_information"."intranet_port" IS '内网端口';
COMMENT
ON COLUMN "public"."tk_device_access_information"."outer_net_ip" IS '外网IP';
COMMENT
ON COLUMN "public"."tk_device_access_information"."outer_net_port" IS '外网端口';
COMMENT
ON COLUMN "public"."tk_device_access_information"."device_agreement" IS '设备接入协议';
COMMENT
ON COLUMN "public"."tk_device_access_information"."sip_extend" IS 'sip扩展信息 serverId服务器id serverRegion服务器域 password';
COMMENT
ON COLUMN "public"."tk_device_access_information"."creator" IS '创建人';
COMMENT
ON COLUMN "public"."tk_device_access_information"."create_time" IS '创建时间';
COMMENT
ON COLUMN "public"."tk_device_access_information"."updater" IS '更新人';
COMMENT
ON COLUMN "public"."tk_device_access_information"."update_time" IS '更新时间';
COMMENT
ON COLUMN "public"."tk_device_access_information"."tenant_id" IS '租户id';
COMMENT
ON TABLE "public"."tk_device_access_information" IS '设备接入信息表';
-- ----------------------------
-- Primary Key structure for table tk_device_access_information
-- ----------------------------
ALTER TABLE "public"."tk_device_access_information"
ADD CONSTRAINT "tk_device_access_information_pkey" PRIMARY KEY ("id");
INSERT INTO "public"."sys_dict_item"("id", "dict_id", "item_text", "item_value", "description", "sort", "status", "tenant_id", "creator", "create_time", "updater", "update_time") VALUES ('638bdb47-81bd-4982-bcf7-54ef6239f697', '73d5d8b1-0ac8-475e-97f7-709dd4125ccd', '个人中心', 'system:personal_center:view', NULL, 1, 1, '13814000-1dd2-11b2-8080-808080808080', '80808080-8080-8080-8080-808080808080', '2024-01-24 11:43:40.971602', NULL, NULL);
INSERT INTO "public"."sys_dict_item"("id", "dict_id", "item_text", "item_value", "description", "sort", "status", "tenant_id", "creator", "create_time", "updater", "update_time") VALUES ('b963cf7c-bed8-4719-86a0-82d1530c2f1b', '6d53709b-d5b6-4b5e-b9e1-0a55e6c8f9f5', '设备接入信息编辑', 'api:yt:device_profile:access_information:update', NULL, 16, 1, '13814000-1dd2-11b2-8080-808080808080', '80808080-8080-8080-8080-808080808080', '2024-02-22 18:51:34.10582', NULL, NULL);
INSERT INTO "public"."sys_dict_item"("id", "dict_id", "item_text", "item_value", "description", "sort", "status", "tenant_id", "creator", "create_time", "updater", "update_time") VALUES ('9129d75f-d9e7-4351-bf1c-1664c292c8d9', '6d53709b-d5b6-4b5e-b9e1-0a55e6c8f9f5', '设备接入信息删除', 'api:yt:device_profile:access_information:delete', NULL, 15, 1, '13814000-1dd2-11b2-8080-808080808080', '80808080-8080-8080-8080-808080808080', '2024-02-21 14:52:52.907144', NULL, NULL);
INSERT INTO "public"."sys_dict_item"("id", "dict_id", "item_text", "item_value", "description", "sort", "status", "tenant_id", "creator", "create_time", "updater", "update_time") VALUES ('b17b1559-8f42-44d5-92d4-122e9f70cb50', 'c5183b83-eb2a-4111-959b-5c7c7e668d94', '设备接入信息', 'deviceManager:deviceAccess:list', NULL, 1, 1, '13814000-1dd2-11b2-8080-808080808080', '80808080-8080-8080-8080-808080808080', '2024-02-19 10:29:24.048745', '80808080-8080-8080-8080-808080808080', '2024-02-19 10:29:39.684479');
INSERT INTO "public"."sys_dict_item"("id", "dict_id", "item_text", "item_value", "description", "sort", "status", "tenant_id", "creator", "create_time", "updater", "update_time") VALUES ('c8f7c6d5-4cd2-4c82-87cf-c6d2facecf77', '6d53709b-d5b6-4b5e-b9e1-0a55e6c8f9f5', '设备接入信息新增', 'api:yt:device_profile:access_information:post', NULL, 14, 1, '13814000-1dd2-11b2-8080-808080808080', '80808080-8080-8080-8080-808080808080', '2024-02-21 14:52:12.462541', '80808080-8080-8080-8080-808080808080', '2024-02-21 14:53:15.150577');
INSERT INTO "public"."sys_dict_item"("id", "dict_id", "item_text", "item_value", "description", "sort", "status", "tenant_id", "creator", "create_time", "updater", "update_time") VALUES ('f8c06892-f637-4c31-aac4-f935728cf625', 'c5183b83-eb2a-4111-959b-5c7c7e668d94', '个人中心', 'system:personal_center:view', NULL, 1, 1, '13814000-1dd2-11b2-8080-808080808080', '80808080-8080-8080-8080-808080808080', '2024-01-24 11:41:18.521978', NULL, NULL);
INSERT INTO "public"."sys_menu"("id", "parent_id", "path", "type", "permission", "creator", "create_time", "updater", "update_time", "name", "tenant_id", "component", "redirect", "alias", "case_sensitive", "meta", "sort") VALUES ('00fccddb-cbdc-4abd-9a1f-1c4f049e6ba2', '38b9a21a-aaf5-42fc-a85f-4381bca3303c', NULL, 'SYSADMIN', 'api:yt:device_profile:access_information:delete', '80808080-8080-8080-8080-808080808080', '2024-02-19 16:44:56.138043', '80808080-8080-8080-8080-808080808080', '2024-02-21 11:28:44.753107', '删除', '13814000-1dd2-11b2-8080-808080808080', NULL, NULL, NULL, NULL, '{"title":"删除","menuType":"2","status":"0"}', 4);
INSERT INTO "public"."sys_menu"("id", "parent_id", "path", "type", "permission", "creator", "create_time", "updater", "update_time", "name", "tenant_id", "component", "redirect", "alias", "case_sensitive", "meta", "sort") VALUES ('38b9a21a-aaf5-42fc-a85f-4381bca3303c', '885ef223-94b1-4b39-89a8-94584183c0be', '/device/deviceaccess', 'SYSADMIN', 'deviceManager:deviceAccess:list', '80808080-8080-8080-8080-808080808080', '2024-02-19 10:24:45.968051', '80808080-8080-8080-8080-808080808080', '2024-02-20 15:42:57.492133', '设备接入信息', '13814000-1dd2-11b2-8080-808080808080', '/device/deviceaccess/index', NULL, NULL, NULL, '{"icon":"ant-design:branches-outlined","title":"设备接入信息","isLink":false,"menuType":"1","ignoreKeepAlive":false,"hideMenu":false,"status":"0"}', 5);
INSERT INTO "public"."sys_menu"("id", "parent_id", "path", "type", "permission", "creator", "create_time", "updater", "update_time", "name", "tenant_id", "component", "redirect", "alias", "case_sensitive", "meta", "sort") VALUES ('44f65518-2d9e-4fd5-aa3f-8baf816d912f', '38b9a21a-aaf5-42fc-a85f-4381bca3303c', NULL, 'SYSADMIN', 'api:yt:device_profile:access_information:get', '80808080-8080-8080-8080-808080808080', '2024-02-19 16:43:38.877863', '80808080-8080-8080-8080-808080808080', '2024-02-21 11:28:31.362367', '详情', '13814000-1dd2-11b2-8080-808080808080', NULL, NULL, NULL, NULL, '{"title":"详情","menuType":"2","status":"0"}', 3);
INSERT INTO "public"."sys_menu"("id", "parent_id", "path", "type", "permission", "creator", "create_time", "updater", "update_time", "name", "tenant_id", "component", "redirect", "alias", "case_sensitive", "meta", "sort") VALUES ('68da3a6d-75e8-49f7-a27f-a4ff6bf822db', '815b9cb0-dbdd-4e57-a1c5-2820741d8e5f', NULL, 'SYSADMIN', 'api:yt:video:control:play', '80808080-8080-8080-8080-808080808080', '2024-02-21 17:51:53.607779', '80808080-8080-8080-8080-808080808080', '2024-02-21 17:52:07.960339', '视频点播', '13814000-1dd2-11b2-8080-808080808080', NULL, NULL, NULL, NULL, '{"title":"视频点播","menuType":"2","status":"0"}', 12);
INSERT INTO "public"."sys_menu"("id", "parent_id", "path", "type", "permission", "creator", "create_time", "updater", "update_time", "name", "tenant_id", "component", "redirect", "alias", "case_sensitive", "meta", "sort") VALUES ('68da3a6d-75e8-49f7-a27f-a4ff6bf832db', '815b9cb0-dbdd-4e57-a1c5-2820741d8e5f', NULL, 'SYSADMIN', 'api:yt:video:control:channel', '80808080-8080-8080-8080-808080808080', '2024-02-21 17:51:53.607779', '80808080-8080-8080-8080-808080808080', '2024-02-21 17:52:07.960339', '视频通道同步', '13814000-1dd2-11b2-8080-808080808080', NULL, NULL, NULL, NULL, '{"title":"视频通道同步","menuType":"2","status":"0"}', 12);
INSERT INTO "public"."sys_menu"("id", "parent_id", "path", "type", "permission", "creator", "create_time", "updater", "update_time", "name", "tenant_id", "component", "redirect", "alias", "case_sensitive", "meta", "sort") VALUES ('68da3a6d-75e8-49f7-a27f-a4ff6bf833db', '815b9cb0-dbdd-4e57-a1c5-2820741d8e5f', NULL, 'SYSADMIN', 'api:yt:video:control:control', '80808080-8080-8080-8080-808080808080', '2024-02-21 17:51:53.607779', '80808080-8080-8080-8080-808080808080', '2024-02-21 17:52:07.960339', '摄像头控制', '13814000-1dd2-11b2-8080-808080808080', NULL, NULL, NULL, NULL, '{"title":"摄像头控制","menuType":"2","status":"0"}', 12);
INSERT INTO "public"."sys_menu"("id", "parent_id", "path", "type", "permission", "creator", "create_time", "updater", "update_time", "name", "tenant_id", "component", "redirect", "alias", "case_sensitive", "meta", "sort") VALUES ('966b3dbb-37c7-4cf0-95d1-7d66511f0a3a', '815b9cb0-dbdd-4e57-a1c5-2820741d8e5f', NULL, 'SYSADMIN', 'api:yt:video:control:stop', '80808080-8080-8080-8080-808080808080', '2024-02-21 17:52:44.156915', NULL, NULL, '视频停止点播', '13814000-1dd2-11b2-8080-808080808080', NULL, NULL, NULL, NULL, '{"title":"视频停止点播","menuType":"2","status":"0"}', 13);
INSERT INTO "public"."sys_menu"("id", "parent_id", "path", "type", "permission", "creator", "create_time", "updater", "update_time", "name", "tenant_id", "component", "redirect", "alias", "case_sensitive", "meta", "sort") VALUES ('b47acbb6-ef7f-4c8a-9ab7-17098b5f3b63', '38b9a21a-aaf5-42fc-a85f-4381bca3303c', NULL, 'SYSADMIN', 'api:yt:device_profile:access_information:post', '80808080-8080-8080-8080-808080808080', '2024-02-19 16:42:38.723093', '80808080-8080-8080-8080-808080808080', '2024-02-21 11:27:57.643463', '新增', '13814000-1dd2-11b2-8080-808080808080', NULL, NULL, NULL, NULL, '{"title":"新增","menuType":"2","status":"0"}', 1);
INSERT INTO "public"."sys_menu"("id", "parent_id", "path", "type", "permission", "creator", "create_time", "updater", "update_time", "name", "tenant_id", "component", "redirect", "alias", "case_sensitive", "meta", "sort") VALUES ('dac55d7f-4359-4a4f-99f5-4cb728c1efee', '38b9a21a-aaf5-42fc-a85f-4381bca3303c', NULL, 'SYSADMIN', 'api:yt:device_profile:access_information:update', '80808080-8080-8080-8080-808080808080', '2024-02-21 15:34:25.935524', NULL, NULL, '编辑', '13814000-1dd2-11b2-8080-808080808080', NULL, NULL, NULL, NULL, '{"title":"编辑","menuType":"2","status":"0"}', 2);
UPDATE "public"."tk_data_view_interface" SET "interface_name" = '设备历史轨迹（适合设备历史轨迹地图）', "request_content_type" = 0, "request_origin_url" = 'localhost', "request_http_type" = 'GET', "request_url" = '/api/plugins/telemetry/{entityType}/{entityId}/values/timeseries{?agg,endTs,interval,keys,limit,orderBy,startTs,endTs,useStrictDataTypes}', "request_params" = '{"requestSQLContent":{},"Params":[{"key":"scope","value":"entityType","mores":null,"editDisabled":false,"required":true},{"key":"date_range","value":"startTs,endTs","mores":true,"editDisabled":true,"required":false},{"key":"deviceProfileId,organizationId,entityId,keys","value":"","mores":null,"editDisabled":true,"required":false}],"Header":[{"key":"ContentType","value":"none","required":false}]}', "state" = 1, "creator" = '80808080-8080-8080-8080-808080808080', "create_time" = '2023-12-26 14:36:44.891373', "updater" = '80808080-8080-8080-8080-808080808080', "update_time" = '2024-01-03 14:48:27.96855', "tenant_id" = '13814000-1dd2-11b2-8080-808080808080', "remark" = NULL, "interface_type" = 'SYSTEM', "filter" = 'const longKey = ''longitude''
const latKey = ''latitude''
const allKeys = Object.keys(res)
let list = []
//不是结构体
if (allKeys.includes(longKey)) {
res[longKey].forEach((longItem, longIndex) => {
list.push([
Number(longItem.value),
Number(res[latKey][longIndex].value),
])
})
} else {
//为结构体
const values = Object.values(res)
list = values[0].reduce((acc, curr)=> {
const serializeValue = JSON.parse(curr.value)
const {
longitude, latitude
} = serializeValue
acc.push([longitude, latitude])
return acc
}, [])
}
return list.reverse()' WHERE "id" = 'f65d5637-3e60-48d7-b3cc-6791fb3883fd';
INSERT INTO "public"."tk_device_access_information"("id", "intranet_ip", "intranet_port", "outer_net_ip", "outer_net_port", "device_agreement", "sip_extend", "creator", "create_time", "updater", "update_time", "tenant_id") VALUES ('ff1edbc3-0cfd-4263-ae50-cf9f11f9a88d', '127.0.0.1', '5060', '127.0.0.1', '5060', 'GBT28181', '{"serverId":"51010700599000000001","serverDomain":"5101070059","serverPassword":"61332286"}', '80808080-8080-8080-8080-808080808080 ', '2024-02-29 15:29:54', NULL, NULL, '13814000-1dd2-11b2-8080-808080808080');