From 56c25bcb0dc03aae78aba23f32ebbf548b866332 Mon Sep 17 00:00:00 2001
From: xing <xingjs@qq.com>
Date: 星期三, 22 二月 2023 14:11:09 +0800
Subject: [PATCH] 20230221@xingjs@提交官网一张图相关内容接口
---
src/main/java/com/lf/server/controller/data/ProjectController.java | 68 ++++++++++++++++++++++-----------
1 files changed, 45 insertions(+), 23 deletions(-)
diff --git a/src/main/java/com/lf/server/controller/data/ProjectController.java b/src/main/java/com/lf/server/controller/data/ProjectController.java
index f1cef60..4528200 100644
--- a/src/main/java/com/lf/server/controller/data/ProjectController.java
+++ b/src/main/java/com/lf/server/controller/data/ProjectController.java
@@ -1,18 +1,19 @@
package com.lf.server.controller.data;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.metadata.OrderItem;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.lf.server.annotation.SysLog;
import com.lf.server.controller.all.BaseController;
-import com.lf.server.controller.all.BaseQueryController;
import com.lf.server.entity.all.ResponseMsg;
import com.lf.server.entity.bs.BsprojectEntity;
+import com.lf.server.entity.ctrl.KeyValueEntity;
import com.lf.server.entity.data.DictEntity;
import com.lf.server.entity.data.DirEntity;
import com.lf.server.entity.sys.DepEntity;
import com.lf.server.entity.sys.UserEntity;
-import com.lf.server.helper.ClassHelper;
import com.lf.server.helper.StringHelper;
import com.lf.server.helper.WebHelper;
-import com.lf.server.mapper.all.BasicMapper;
import com.lf.server.mapper.bs.BsprojectMapper;
import com.lf.server.service.all.BaseQueryService;
import com.lf.server.service.data.DirService;
@@ -27,12 +28,10 @@
import javax.servlet.http.HttpServletRequest;
import java.util.ArrayList;
-import java.util.HashMap;
import java.util.List;
-import java.util.Map;
/**
- * 鏁版嵁妫�绱�
+ * 椤圭洰绠＄悊
* @author WWW
*/
@Api(tags = "鏁版嵁绠＄悊\\椤圭洰绠＄悊")
@@ -67,11 +66,12 @@
}
@SysLog()
- @ApiOperation(value = "鏌ヨ鎵�鏈夌洰褰曟暟鎹�")
- @GetMapping(value = "/selectDirAll")
- public ResponseMsg<List<DirEntity>> selectDirAll() {
+ @ApiOperation(value = "鏌ヨ椤圭洰")
+ @GetMapping(value = "/selectProject")
+ public ResponseMsg<List<DirEntity>> selectProject() {
try {
- List<DirEntity> list = dirService.selectDirAll();
+ List<DirEntity> list = dirService.selectProject();
+
return success(list);
} catch (Exception ex) {
return fail(ex.getMessage(), null);
@@ -79,22 +79,26 @@
}
@SysLog()
- @ApiOperation(value = "鏍规嵁鐩綍ID鏌ヨ")
+ @ApiOperation(value = "鍒嗛〉鏌ヨ骞惰繑鍥炶褰曟暟")
@ApiImplicitParams({
- @ApiImplicitParam(name = "dirid", value = "鐩綍ID", dataType = "int", paramType = "query", example = "0")
+ @ApiImplicitParam(name = "dirid", value = "鐩綍ID", dataType = "String", paramType = "query", example = "1"),
+ @ApiImplicitParam(name = "pageSize", value = "姣忛〉鏉℃暟", dataType = "Integer", paramType = "query", example = "10"),
+ @ApiImplicitParam(name = "pageIndex", value = "鍒嗛〉鏁帮紙浠�1寮�濮嬶級", dataType = "Integer", paramType = "query", example = "1")
})
- @GetMapping(value = "/selectByDirid")
- public ResponseMsg<BsprojectEntity> selectByDirid(int dirid) {
+ @GetMapping(value = "/selectByPageAndCount")
+ public ResponseMsg<Object> selectByPageAndCount(String dirid, Integer pageSize, Integer pageIndex) {
try {
- Map<String, Object> map = new HashMap<>(1);
- map.put("dirid", dirid);
-
- List<BsprojectEntity> list = bsprojectMapper.selectByMap(map);
- if (null == list || list.isEmpty()) {
- return success(null);
+ QueryWrapper<BsprojectEntity> wrapper = new QueryWrapper<>();
+ wrapper.select("ST_AsText(geom) as geom, *");
+ if (null != dirid) {
+ wrapper.eq("dirid", dirid);
}
- return success(list.get(0));
+ Page<BsprojectEntity> page = new Page<>(pageIndex, pageSize);
+ page.addOrder(OrderItem.asc("gid"));
+ Page paged = bsprojectMapper.selectPage(page, wrapper);
+
+ return success(paged.getTotal(), paged.getRecords());
} catch (Exception ex) {
return fail(ex.getMessage(), null);
}
@@ -112,6 +116,24 @@
String[] strs = tabName.split("\\.");
List<DictEntity> list = baseQueryService.selectFields(strs[0], strs[1]);
+
+ return success(list);
+ } catch (Exception ex) {
+ return fail(ex.getMessage(), null);
+ }
+ }
+
+ @SysLog()
+ @ApiOperation(value = "鏌ヨ浣嶇疆")
+ @ApiImplicitParams({
+ @ApiImplicitParam(name = "x", value = "X", dataType = "Double", paramType = "query", example = "114.178955"),
+ @ApiImplicitParam(name = "y", value = "Y", dataType = "Double", paramType = "query", example = "38.991743")
+ })
+ @GetMapping(value = "/selectLocation")
+ public ResponseMsg<Object> selectLocation(double x, double y) {
+ try {
+ String wkt = String.format("POINT(%f %f)", x, y);
+ List<KeyValueEntity> list = baseQueryService.selectLocation(wkt);
return success(list);
} catch (Exception ex) {
@@ -150,7 +172,7 @@
UserEntity ue = tokenService.getCurrentUser(req);
entity.setCreateuser(ue.getId());
entity.setCreatetime(WebHelper.getCurrentTimestamp());
- entity.setGeom(StringHelper.getGeomWKT(entity.getGeom()));
+ entity.setGeom(StringHelper.getGeomWkt(entity.getGeom()));
List<BsprojectEntity> list = new ArrayList<>();
list.add(entity);
@@ -179,7 +201,7 @@
UserEntity ue = tokenService.getCurrentUser(req);
entity.setUpdateuser(ue.getId());
entity.setUpdatetime(WebHelper.getCurrentTimestamp());
- entity.setGeom(StringHelper.getGeomWKT(entity.getGeom()));
+ entity.setGeom(StringHelper.getGeomWkt(entity.getGeom()));
List<BsprojectEntity> list = new ArrayList<>();
list.add(entity);
--
Gitblit v1.9.3