From 3bed823c3fe17d375b1863d5f39f654f905e43bb Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期日, 08 一月 2023 13:29:17 +0800
Subject: [PATCH] 1.8.1
---
src/main/java/com/lf/server/entity/data/CoordEntity.java | 51 +++++++++++++++++
src/main/java/com/lf/server/service/data/UploadService.java | 23 +++++++
data/update.sql | 2
src/main/java/com/lf/server/mapper/data/UploadMapper.java | 23 +++++++
src/main/resources/mapper/data/UploadMapper.xml | 14 ++++
src/main/java/com/lf/server/controller/data/upload/QueryController.java | 24 ++++++-
6 files changed, 132 insertions(+), 5 deletions(-)
diff --git a/data/update.sql b/data/update.sql
index e7a7763..0e12c69 100644
--- a/data/update.sql
+++ b/data/update.sql
@@ -71,7 +71,7 @@
select * from lf.sys_meta a inner join lf.sys_meta_file b on a.id = b.metaid
where depid = ANY(fn_rec_array(10, 'dep'));
-
+select * from lf.sys_dir order by id
diff --git a/src/main/java/com/lf/server/controller/data/upload/QueryController.java b/src/main/java/com/lf/server/controller/data/upload/QueryController.java
index 640376c..2e20aa2 100644
--- a/src/main/java/com/lf/server/controller/data/upload/QueryController.java
+++ b/src/main/java/com/lf/server/controller/data/upload/QueryController.java
@@ -8,10 +8,7 @@
import com.lf.server.entity.all.ResponseMsg;
import com.lf.server.entity.all.StaticData;
import com.lf.server.entity.ctrl.TabEntity;
-import com.lf.server.entity.data.DictEntity;
-import com.lf.server.entity.data.DirEntity;
-import com.lf.server.entity.data.MetaEntity;
-import com.lf.server.entity.data.VerEntity;
+import com.lf.server.entity.data.*;
import com.lf.server.entity.sys.DepEntity;
import com.lf.server.entity.sys.UserEntity;
import com.lf.server.helper.ClassHelper;
@@ -49,6 +46,9 @@
@Autowired
protected TokenService tokenService;
+
+ @Autowired
+ protected UploadService uploadService;
@Autowired
protected BaseQueryService baseQueryService;
@@ -103,6 +103,22 @@
}
@SysLog()
+ @ApiOperation(value = "鏌ヨ鍧愭爣绯�")
+ @ApiImplicitParams({
+ @ApiImplicitParam(name = "zoning", value = "甯﹀彿", dataType = "String", paramType = "query", example = "6搴︽湁甯﹀彿")
+ })
+ @GetMapping(value = "/selectCoords")
+ public ResponseMsg<Object> selectCoords(String zoning) {
+ try {
+ List<CoordEntity> list = uploadService.selectCoords(zoning);
+
+ return success(list);
+ } catch (Exception ex) {
+ return fail(ex.getMessage(), null);
+ }
+ }
+
+ @SysLog()
@ApiOperation(value = "鏌ヨ鎵�鏈夎〃")
@GetMapping(value = "/selectTabs")
public ResponseMsg<List<TabEntity>> selectTabs() {
diff --git a/src/main/java/com/lf/server/entity/data/CoordEntity.java b/src/main/java/com/lf/server/entity/data/CoordEntity.java
new file mode 100644
index 0000000..3f32ef0
--- /dev/null
+++ b/src/main/java/com/lf/server/entity/data/CoordEntity.java
@@ -0,0 +1,51 @@
+package com.lf.server.entity.data;
+
+import java.io.Serializable;
+
+/**
+ * 鍧愭爣绯�
+ * @author WWW
+ */
+public class CoordEntity implements Serializable {
+ private static final long serialVersionUID = 5660360983928368364L;
+
+ private Integer id;
+
+ private String epsgcode;
+
+ private String coordinate;
+
+ private String zoning;
+
+ public Integer getId() {
+ return id;
+ }
+
+ public void setId(Integer id) {
+ this.id = id;
+ }
+
+ public String getEpsgcode() {
+ return epsgcode;
+ }
+
+ public void setEpsgcode(String epsgcode) {
+ this.epsgcode = epsgcode;
+ }
+
+ public String getCoordinate() {
+ return coordinate;
+ }
+
+ public void setCoordinate(String coordinate) {
+ this.coordinate = coordinate;
+ }
+
+ public String getZoning() {
+ return zoning;
+ }
+
+ public void setZoning(String zoning) {
+ this.zoning = zoning;
+ }
+}
diff --git a/src/main/java/com/lf/server/mapper/data/UploadMapper.java b/src/main/java/com/lf/server/mapper/data/UploadMapper.java
new file mode 100644
index 0000000..635ae07
--- /dev/null
+++ b/src/main/java/com/lf/server/mapper/data/UploadMapper.java
@@ -0,0 +1,23 @@
+package com.lf.server.mapper.data;
+
+import com.lf.server.entity.data.CoordEntity;
+import org.apache.ibatis.annotations.Mapper;
+import org.springframework.web.bind.annotation.ResponseBody;
+
+import java.util.List;
+
+/**
+ * 鏁版嵁涓婁紶
+ * @author WWW
+ */
+@Mapper
+@ResponseBody
+public interface UploadMapper {
+ /**
+ * 鏌ヨ鍧愭爣绯�
+ *
+ * @param zoning
+ * @return
+ */
+ public List<CoordEntity> selectCoords(String zoning);
+}
diff --git a/src/main/java/com/lf/server/service/data/UploadService.java b/src/main/java/com/lf/server/service/data/UploadService.java
new file mode 100644
index 0000000..528bd33
--- /dev/null
+++ b/src/main/java/com/lf/server/service/data/UploadService.java
@@ -0,0 +1,23 @@
+package com.lf.server.service.data;
+
+import com.lf.server.entity.data.CoordEntity;
+import com.lf.server.mapper.data.UploadMapper;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Service;
+
+import java.util.List;
+
+/**
+ * 鏁版嵁涓婁紶鏈嶅姟绫�
+ * @author WWW
+ */
+@Service
+public class UploadService implements UploadMapper {
+ @Autowired
+ UploadMapper uploadMapper;
+
+ @Override
+ public List<CoordEntity> selectCoords(String zoning) {
+ return uploadMapper.selectCoords(zoning);
+ }
+}
diff --git a/src/main/resources/mapper/data/UploadMapper.xml b/src/main/resources/mapper/data/UploadMapper.xml
new file mode 100644
index 0000000..1c09870
--- /dev/null
+++ b/src/main/resources/mapper/data/UploadMapper.xml
@@ -0,0 +1,14 @@
+<?xml version="1.0" encoding="UTF-8" ?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="com.lf.server.mapper.data.UploadMapper">
+ <select id="selectCoords" resultType="com.lf.server.entity.data.CoordEntity">
+ select * from lf.sys_coord
+ <where>
+ 1 = 1
+ <if test="zoning != null">
+ and zoning = #{zoning}
+ </if>
+ </where>
+ order by id
+ </select>
+</mapper>
\ No newline at end of file
--
Gitblit v1.9.3