From c4a9a6f3f5740f475068378a19f41d651635f1a3 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期四, 06 四月 2023 11:07:03 +0800
Subject: [PATCH] 1
---
src/main/java/com/lf/server/service/show/ApplyService.java | 6 +++++-
data/db_tab.sql | 4 +++-
data/db_cx.sql | 7 +++----
src/main/java/com/lf/server/entity/show/ApplyEntity.java | 10 ++++++++++
4 files changed, 21 insertions(+), 6 deletions(-)
diff --git a/data/db_cx.sql b/data/db_cx.sql
index 211126a..2fa9c30 100644
--- a/data/db_cx.sql
+++ b/data/db_cx.sql
@@ -21,10 +21,9 @@
-- delete from lf.sys_apply where id > 47; delete from lf.sys_flow where applyid > 47;
select * from lf.sys_download order by id desc
select st_astext(geom) from bs.s_explorationpoint where exppointid in ('XTCK16')
-
-
-
-
+select * from lf.sys_publish order by id desc;
+select * from lf.sys_download order by id desc limit 20; --downid
+select * from lf.sys_apply order by id desc;
diff --git a/data/db_tab.sql b/data/db_tab.sql
index 20149c2..e8703fe 100644
--- a/data/db_tab.sql
+++ b/data/db_tab.sql
@@ -994,6 +994,7 @@
status integer default 0,
count integer default 0,
descr varchar(100),
+ guid varchar(40),
create_user integer default 1,
create_time timestamp(6) without time zone default now(),
update_user integer,
@@ -1013,12 +1014,13 @@
comment on column lf.sys_apply.status is '鐘舵�侊細-10-浣滃簾锛�-1-鎵撳洖锛�0~9-瀹℃牳涓紝10-閫氳繃';
comment on column lf.sys_apply.count is '瀹℃牳鎬绘暟';
comment on column lf.sys_apply.descr is '鎻忚堪';
+comment on column lf.sys_apply.guid is 'GUID';
comment on column lf.sys_apply.create_user is '鍒涘缓浜篿d';
comment on column lf.sys_apply.create_time is '鍒涘缓鏃堕棿';
comment on column lf.sys_apply.update_user is '鏇存柊浜篿d';
comment on column lf.sys_apply.update_time is '鏇存柊鏃堕棿';
-select * from lf.sys_apply;
+select * from lf.sys_apply order by id desc;
----------------------------------------------------------------------------------------------------- 29.鐢宠娴佺▼琛�
-- drop table if exists lf.sys_flow;
create table lf.sys_flow (
diff --git a/src/main/java/com/lf/server/entity/show/ApplyEntity.java b/src/main/java/com/lf/server/entity/show/ApplyEntity.java
index b345326..133beef 100644
--- a/src/main/java/com/lf/server/entity/show/ApplyEntity.java
+++ b/src/main/java/com/lf/server/entity/show/ApplyEntity.java
@@ -49,6 +49,8 @@
private String gids;
private String filters;
+
+ private String guid;
public ApplyEntity() {
}
@@ -212,4 +214,12 @@
public void setFilters(String filters) {
this.filters = filters;
}
+
+ public String getGuid() {
+ return guid;
+ }
+
+ public void setGuid(String guid) {
+ this.guid = guid;
+ }
}
diff --git a/src/main/java/com/lf/server/service/show/ApplyService.java b/src/main/java/com/lf/server/service/show/ApplyService.java
index f1863e0..9f4eba7 100644
--- a/src/main/java/com/lf/server/service/show/ApplyService.java
+++ b/src/main/java/com/lf/server/service/show/ApplyService.java
@@ -216,7 +216,11 @@
dr.setIds(getIds(entity));
dr.setFilter(entity.getFilters());
- dataLibService.downloadDbReq(ue, dr);
+ String guid = dataLibService.downloadDbReq(ue, dr);
+ if (!StringHelper.isEmpty(guid)){
+ entity.setGuid(guid);
+ update(entity);
+ }
} catch (Exception ex) {
log.error(ex.getMessage(), ex);
}
--
Gitblit v1.9.3