From ac20dc99bf1f463365dba071973e08fffbd294b4 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期五, 14 七月 2023 14:12:21 +0800
Subject: [PATCH] 1
---
src/main/java/com/lf/server/controller/data/ProjectController.java | 109 ++++++++++++++++++++++++++++++++++++++++--------------
1 files changed, 81 insertions(+), 28 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 dc2897f..b149628 100644
--- a/src/main/java/com/lf/server/controller/data/ProjectController.java
+++ b/src/main/java/com/lf/server/controller/data/ProjectController.java
@@ -1,15 +1,21 @@
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.BaseQueryController;
+import com.lf.server.controller.all.BaseController;
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.StringHelper;
import com.lf.server.helper.WebHelper;
import com.lf.server.mapper.bs.BsprojectMapper;
+import com.lf.server.service.all.BaseQueryService;
import com.lf.server.service.data.DirService;
import com.lf.server.service.sys.DepService;
import com.lf.server.service.sys.TokenService;
@@ -22,18 +28,16 @@
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 = "鏁版嵁绠＄悊\\椤圭洰绠＄悊")
@RestController
@RequestMapping("/project")
-public class ProjectController extends BaseQueryController {
+public class ProjectController extends BaseController {
@Autowired
DepService depService;
@@ -46,6 +50,9 @@
@Autowired
BsprojectMapper bsprojectMapper;
+ @Autowired
+ BaseQueryService baseQueryService;
+
@SysLog()
@ApiOperation(value = "鏌ヨ鎵�鏈夊崟浣嶆暟鎹�")
@GetMapping(value = "/selectDepAll")
@@ -54,41 +61,86 @@
List<DepEntity> list = depService.selectDepAll();
return success(list);
} catch (Exception ex) {
- return fail(ex.getMessage(), null);
+ return fail(ex, null);
}
}
@SysLog()
- @ApiOperation(value = "鏌ヨ鎵�鏈夌洰褰曟暟鎹�")
- @GetMapping(value = "/selectDirAll")
- public ResponseMsg<List<DirEntity>> selectDirAll() {
+ @ApiOperation(value = "鏌ヨ椤圭洰")
+ @ApiImplicitParams({
+ @ApiImplicitParam(name = "name", value = "鍚嶇О", dataType = "String", paramType = "query", example = "瑗�")
+ })
+ @GetMapping(value = "/selectProject")
+ public ResponseMsg<List<DirEntity>> selectProject(String name) {
try {
- List<DirEntity> list = dirService.selectDirAll();
+ List<DirEntity> list = dirService.selectProject(name);
+
return success(list);
} catch (Exception ex) {
- return fail(ex.getMessage(), null);
+ return fail(ex, null);
}
}
@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.desc("gid"));
+ Page paged = bsprojectMapper.selectPage(page, wrapper);
+
+ return success(paged.getTotal(), paged.getRecords());
} catch (Exception ex) {
- return fail(ex.getMessage(), null);
+ return fail(ex, null);
+ }
+ }
+
+ @SysLog()
+ @ApiOperation(value = "鏌ヨ瀛楁淇℃伅")
+ @GetMapping(value = "/selectFields")
+ public ResponseMsg<List<DictEntity>> selectFields() {
+ try {
+ String tabName = BaseQueryService.getTabName(bsprojectMapper);
+ if (tabName == null) {
+ return null;
+ }
+
+ String[] strs = tabName.split("\\.");
+ List<DictEntity> list = baseQueryService.selectFields(strs[0], strs[1]);
+
+ return success(list);
+ } catch (Exception ex) {
+ return fail(ex, 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) {
+ return fail(ex, null);
}
}
@@ -104,7 +156,7 @@
return success(rows);
} catch (Exception ex) {
- return fail(ex.getMessage(), -1);
+ return fail(ex, -1);
}
}
@@ -122,8 +174,9 @@
UserEntity ue = tokenService.getCurrentUser(req);
entity.setCreateuser(ue.getId());
+ entity.setEventid(StringHelper.getGuid());
entity.setCreatetime(WebHelper.getCurrentTimestamp());
- entity.setGeom(StringHelper.getGeomWKT(entity.getGeom()));
+ entity.setGeom(StringHelper.getGeomWkt(entity.getGeom()));
List<BsprojectEntity> list = new ArrayList<>();
list.add(entity);
@@ -132,7 +185,7 @@
return success(rows);
} catch (Exception ex) {
- return fail(ex.getMessage(), -1);
+ return fail(ex, -1);
}
}
@@ -152,7 +205,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);
@@ -161,7 +214,7 @@
return success(rows);
} catch (Exception ex) {
- return fail(ex.getMessage(), -1);
+ return fail(ex, -1);
}
}
}
--
Gitblit v1.9.3