From 43870ea90711808e22f99c460821f98a4de7a60c Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期四, 29 六月 2023 09:23:16 +0800
Subject: [PATCH] 1
---
src/main/java/com/lf/server/entity/bs/MsurfacedeformationdatadateEntity.java | 145 ++++++++++++++++++++++++++++++++++++
data/db_cx.sql | 24 -----
src/main/java/com/lf/server/mapper/bs/MsurfacedeformationdatadateMapper.java | 15 +++
3 files changed, 163 insertions(+), 21 deletions(-)
diff --git a/data/db_cx.sql b/data/db_cx.sql
index 006c9e6..d51eef4 100644
--- a/data/db_cx.sql
+++ b/data/db_cx.sql
@@ -9,6 +9,7 @@
select ST_AsText(geom) "geom", a.*, fn_get_fullname(a.depid, 1) depName, fn_get_fullname(a.dirid, 2) dirName, fn_uname(create_user) createName, fn_uname(update_user) updateName from lf.sys_publish a
select fn_get_fullname(depcode, 1) "m1", cast(sum(sizes) as decimal(18, 3)) "sizes" from lf.sys_meta group by depcode order by depcode;
select fn_get_fullname(code, 2) from lf.sys_dir where code='0A05'; -- 鏌ヨ瀹屾暣璺緞
+select * from lf.sys_token where token ='c36e4f94-dfde-401e-9967-2c4a449f1300'; -- FME
-- 鍒犻櫎鍐椾綑鏁版嵁锛屼慨澶峵ab_guid鍊�
select id,name,path,tab,tab_guid from lf.sys_attach where tab != 'bd.b_borehole' order by id desc limit 200;
@@ -34,7 +35,6 @@
select * from lf.sys_ars;
select * from lf.sys_report;
--- ALL -> 560, type=2 -> 442, WMS -> 340, url=null -> 77, type=2 & url -> 25, .json -> 17
select serve_type from lf.sys_layer group by serve_type;
update lf.sys_layer set serve_type = null where type = 2;
update lf.sys_layer set serve_type = 'WMS' where type = 2 and position('LF:' in url) > 0;
@@ -47,28 +47,10 @@
select id, pid, cn_name, en_name, url, serve_type, data_type, elev, pubid, is_project, bak
from lf.sys_layer where type = 2 and serve_type is not null order by id;
-- update lf.sys_publish a set url = replace(url, '192.168.20.205:80', '{host}') where position('192.' in url) > 0;
-
-select * from bs.s_explorationpoint where createtime < '2023-05-26 10:00:00';
-select * from bs.s_surveyworksite where createtime < '2023-05-26 10:00:00';
-select * from lf.sys_meta where type='cpt';
-select id,name,code from lf.sys_dir where pid=0 order by code
-
-select * from bs.dlg_resnt2000;
-alter table bs.dlg_resnt2000 alter column floors type varchar(20);
-select * from lf.sys_layer l where cn_name='鍊炬枩鎽勫奖鏁版嵁';
-
select id, pid, type, cn_name, en_name, url, serve_type, data_type, elev, pubid, is_project, bak from lf.sys_layer order by id; -- 8-299
--- update lf.sys_layer set is_project = 1 where id between 8 and 299;
-update lf.sys_layer set is_project = null where id between 8 and 299 and type = 1;
-select id, pid, type, cn_name, en_name, url, serve_type, data_type, elev, pubid, is_project, bak
-from lf.sys_layer where serve_type = 'WMS' order by id;
-select id,uid,uname,pwd from lf.sys_user order by uid;
-select * from lf.sys_meta where type='osgb' order by id desc limit 20;
-
-select * from lf.sys_token where token ='c36e4f94-dfde-401e-9967-2c4a449f1300';
-select * from lf.sys_user where id=61;
-select bak,count(*) from lf.sys_dict group by bak order by bak;
+select * from lf.sys_meta where type='xlsx' order by id desc limit 20;
+select * from lf.sys_dict where tab_desc in('鍦拌〃褰㈠彉鏁版嵁鏃跺簭琛�','宕╁') order by id; -- m_surface_deformation_data_date
diff --git a/src/main/java/com/lf/server/entity/bs/MsurfacedeformationdatadateEntity.java b/src/main/java/com/lf/server/entity/bs/MsurfacedeformationdatadateEntity.java
new file mode 100644
index 0000000..f22fa97
--- /dev/null
+++ b/src/main/java/com/lf/server/entity/bs/MsurfacedeformationdatadateEntity.java
@@ -0,0 +1,145 @@
+package com.lf.server.entity.bs;
+
+import com.baomidou.mybatisplus.annotation.TableField;
+import com.baomidou.mybatisplus.annotation.TableName;
+import com.lf.server.entity.all.BaseEntity;
+import lombok.*;
+
+import java.math.BigDecimal;
+import java.sql.Timestamp;
+import java.time.LocalDate;
+
+/**
+ * Msurfacedeformationdatadate
+ * @author WWW
+ */
+@Data
+@AllArgsConstructor
+@TableName("bs.m_surface_deformation_data_date")
+@EqualsAndHashCode(callSuper = false)
+public class MsurfacedeformationdatadateEntity extends BaseEntity {
+ private static final long serialVersionUID = 458597513594942912L;
+
+ private String segname;
+
+ private String defpointno;
+
+ private BigDecimal seqvar;
+
+ private Timestamp defdate;
+
+ private String projname;
+
+ private String pipename;
+
+ private String belongs;
+
+ private String belongsid;
+
+ private String datastatus;
+
+ private String remarks;
+
+ private String version;
+
+ private String datastage;
+
+ public MsurfacedeformationdatadateEntity() {
+ }
+
+ public String getSegname() {
+ return segname;
+ }
+
+ public void setSegname(String segname) {
+ this.segname = segname;
+ }
+
+ public String getDefpointno() {
+ return defpointno;
+ }
+
+ public void setDefpointno(String defpointno) {
+ this.defpointno = defpointno;
+ }
+
+ public BigDecimal getSeqvar() {
+ return seqvar;
+ }
+
+ public void setSeqvar(BigDecimal seqvar) {
+ this.seqvar = seqvar;
+ }
+
+ public Timestamp getDefdate() {
+ return defdate;
+ }
+
+ public void setDefdate(Timestamp defdate) {
+ this.defdate = defdate;
+ }
+
+ public String getProjname() {
+ return projname;
+ }
+
+ public void setProjname(String projname) {
+ this.projname = projname;
+ }
+
+ public String getPipename() {
+ return pipename;
+ }
+
+ public void setPipename(String pipename) {
+ this.pipename = pipename;
+ }
+
+ public String getBelongs() {
+ return belongs;
+ }
+
+ public void setBelongs(String belongs) {
+ this.belongs = belongs;
+ }
+
+ public String getBelongsid() {
+ return belongsid;
+ }
+
+ public void setBelongsid(String belongsid) {
+ this.belongsid = belongsid;
+ }
+
+ public String getDatastatus() {
+ return datastatus;
+ }
+
+ public void setDatastatus(String datastatus) {
+ this.datastatus = datastatus;
+ }
+
+ public String getRemarks() {
+ return remarks;
+ }
+
+ public void setRemarks(String remarks) {
+ this.remarks = remarks;
+ }
+
+ public String getVersion() {
+ return version;
+ }
+
+ public void setVersion(String version) {
+ this.version = version;
+ }
+
+ public String getDatastage() {
+ return datastage;
+ }
+
+ public void setDatastage(String datastage) {
+ this.datastage = datastage;
+ }
+}
diff --git a/src/main/java/com/lf/server/mapper/bs/MsurfacedeformationdatadateMapper.java b/src/main/java/com/lf/server/mapper/bs/MsurfacedeformationdatadateMapper.java
new file mode 100644
index 0000000..aff5061
--- /dev/null
+++ b/src/main/java/com/lf/server/mapper/bs/MsurfacedeformationdatadateMapper.java
@@ -0,0 +1,15 @@
+package com.lf.server.mapper.bs;
+
+import com.lf.server.entity.bs.MsurfacedeformationdatadateEntity;
+import com.lf.server.mapper.all.BasicMapper;
+import org.apache.ibatis.annotations.Mapper;
+import org.springframework.stereotype.Repository;
+
+/**
+ * Msurfacedeformationdatadate
+ * @author WWW
+ */
+@Mapper
+@Repository
+public interface MsurfacedeformationdatadateMapper extends BasicMapper<MsurfacedeformationdatadateEntity> {
+}
--
Gitblit v1.9.3