From c509bd8047cfd582c59bba66d148b236e45d038d Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期四, 12 一月 2023 10:15:15 +0800
Subject: [PATCH] 1
---
src/main/java/com/lf/server/controller/data/ProjectController.java | 74 ++++++++++++++++++++++++++-----------
1 files changed, 52 insertions(+), 22 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..80f9916 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,20 @@
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.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 +27,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;
@@ -45,6 +48,9 @@
@Autowired
BsprojectMapper bsprojectMapper;
+
+ @Autowired
+ BaseQueryService baseQueryService;
@SysLog()
@ApiOperation(value = "鏌ヨ鎵�鏈夊崟浣嶆暟鎹�")
@@ -59,11 +65,12 @@
}
@SysLog()
- @ApiOperation(value = "鏌ヨ鎵�鏈夌洰褰曟暟鎹�")
- @GetMapping(value = "/selectDirAll")
- public ResponseMsg<List<DirEntity>> selectDirAll() {
+ @ApiOperation(value = "鏌ヨ鏍圭洰褰�")
+ @GetMapping(value = "/selectDirRoot")
+ public ResponseMsg<List<DirEntity>> selectDirRoot() {
try {
- List<DirEntity> list = dirService.selectDirAll();
+ List<DirEntity> list = dirService.selectDirRoot();
+
return success(list);
} catch (Exception ex) {
return fail(ex.getMessage(), null);
@@ -71,22 +78,45 @@
}
@SysLog()
- @ApiOperation(value = "鏍规嵁鐩綍ID鏌ヨ")
+ @ApiOperation(value = "鍒嗛〉鏌ヨ骞惰繑鍥炶褰曟暟")
@ApiImplicitParams({
- @ApiImplicitParam(name = "dirid", value = "鐩綍ID", dataType = "int", paramType = "query", example = "0")
+ @ApiImplicitParam(name = "dirid", value = "鐩綍ID", dataType = "Integer", 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(Integer 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);
+ }
+ }
+
+ @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.getMessage(), null);
}
@@ -123,7 +153,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);
@@ -152,7 +182,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