From d950bfac44ca8dcdfe91de52fde0fe86e0829753 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期日, 03 九月 2023 12:03:02 +0800
Subject: [PATCH] 发布表添加新的字段

---
 src/main/java/com/moon/server/controller/data/PublishController.java |  169 ++++++++++++++++++++++++++++++++++----------------------
 1 files changed, 103 insertions(+), 66 deletions(-)

diff --git a/src/main/java/com/moon/server/controller/data/PublishController.java b/src/main/java/com/moon/server/controller/data/PublishController.java
index 0027314..b88a93a 100644
--- a/src/main/java/com/moon/server/controller/data/PublishController.java
+++ b/src/main/java/com/moon/server/controller/data/PublishController.java
@@ -8,17 +8,19 @@
 import com.moon.server.entity.data.PublishEntity;
 import com.moon.server.entity.sys.UserEntity;
 import com.moon.server.helper.StringHelper;
-import com.moon.server.helper.WebHelper;
+import com.moon.server.service.all.PermsService;
 import com.moon.server.service.data.PublishService;
+import com.moon.server.service.data.ShuJianService;
 import com.moon.server.service.sys.TokenService;
 import io.swagger.annotations.Api;
 import io.swagger.annotations.ApiImplicitParam;
 import io.swagger.annotations.ApiImplicitParams;
 import io.swagger.annotations.ApiOperation;
-import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.web.bind.annotation.*;
 
+import javax.annotation.Resource;
 import javax.servlet.http.HttpServletRequest;
+import javax.servlet.http.HttpServletResponse;
 import java.util.List;
 
 /**
@@ -29,11 +31,17 @@
 @RestController
 @RequestMapping("/publish")
 public class PublishController extends BaseController {
-    @Autowired
+    @Resource
     PublishService publishService;
 
-    @Autowired
+    @Resource
     TokenService tokenService;
+
+    @Resource
+    PermsService permsService;
+
+    @Resource
+    ShuJianService shuJianService;
 
     @SysLog()
     @ApiOperation(value = "鍒嗛〉鏌ヨ鍏冩暟鎹�")
@@ -76,15 +84,13 @@
     private String getType(String type) throws Exception {
         switch (type) {
             case "DOM":
-                return "type in ('tif', 'tiff', 'img')";
+                return "type in ('tif', 'tiff', 'img', 'jp2', 'jpg') and mata_type in (1, 3, 4, 5)";
             case "DEM":
-                return "type in ('tif', 'tiff')";
-            case "MPT":
-                return "type = 'mpt'";
-            case "3DML":
-                return "type = '3dml'";
-            case "BIM":
-                return "type in ('ifc', 'fbx', 'rvt')";
+                return "type in ('tif', 'tiff', 'dem') and mata_type = 2";
+            case "Vector":
+                return "type in ('shp', 'gdb') and mata_type = 6";
+            case "Model":
+                return "type in ('ifc', 'gdb') and mata_type = 7";
             default:
                 throw new Exception("鏁版嵁绫诲瀷涓嶅尮閰�");
         }
@@ -94,26 +100,51 @@
     @ApiOperation(value = "鍒嗛〉鏌ヨ骞惰繑鍥炶褰曟暟")
     @ApiImplicitParams({
             @ApiImplicitParam(name = "name", value = "鍚嶇О", dataType = "String", paramType = "query", example = ""),
+            @ApiImplicitParam(name = "dircode", value = "鐩綍", dataType = "String", paramType = "query", example = ""),
+            @ApiImplicitParam(name = "type", value = "绫诲埆", dataType = "String", paramType = "query", example = ""),
             @ApiImplicitParam(name = "pageSize", value = "姣忛〉鏉℃暟", dataType = "Integer", paramType = "query", example = "10"),
             @ApiImplicitParam(name = "pageIndex", value = "鍒嗛〉鏁帮紙浠�1寮�濮嬶級", dataType = "Integer", paramType = "query", example = "1")
     })
     @GetMapping(value = "/selectByPageAndCount")
-    public ResponseMsg<List<PublishEntity>> selectByPageAndCount(String name, Integer pageSize, Integer pageIndex) {
+    public ResponseMsg<List<PublishEntity>> selectByPageAndCount(String name, String dircode, String type, Integer pageSize, Integer pageIndex) {
         try {
             if (pageSize < 1 || pageIndex < 1) {
                 return fail("姣忛〉椤垫暟鎴栧垎椤垫暟灏忎簬1", null);
             }
+            type = getPubType(type);
 
-            int count = publishService.selectCount(name);
+            int count = publishService.selectCount(name, dircode, type);
             if (count == 0) {
                 return success(0, null);
             }
 
-            List<PublishEntity> rs = publishService.selectByPage(name, pageSize, pageSize * (pageIndex - 1));
+            List<PublishEntity> rs = publishService.selectByPage(name, dircode, type, pageSize, pageSize * (pageIndex - 1));
 
             return success(count, rs);
         } catch (Exception ex) {
             return fail(ex.getMessage(), null);
+        }
+    }
+
+    /**
+     * 鑾峰彇鍙戝竷绫诲瀷
+     */
+    private String getPubType(String type) throws Exception {
+        if (StringHelper.isEmpty(type)) {
+            return null;
+        }
+
+        switch (type) {
+            case "DOM":
+                return "type = 'DOM'";
+            case "DEM":
+                return "type = 'DEM'";
+            case "Vector":
+                return "type = 'Vector'";
+            case "Model":
+                return "type = 'Model'";
+            default:
+                throw new Exception("鏁版嵁绫诲瀷涓嶅尮閰�");
         }
     }
 
@@ -134,89 +165,95 @@
     }
 
     @SysLog()
-    @ApiOperation(value = "鎻掑叆鍙戝竷鏁版嵁")
+    @ApiOperation(value = "鍒嗛〉鏌ヨ鏁扮畝鐨勯鑹茶〃")
+    @ApiImplicitParams({
+            @ApiImplicitParam(name = "pageSize", value = "姣忛〉鏉℃暟", dataType = "int", paramType = "query", example = "10"),
+            @ApiImplicitParam(name = "pageIndex", value = "鍒嗛〉鏁帮紙浠�1寮�濮嬶級", dataType = "int", paramType = "query", example = "1")
+    })
+    @GetMapping(value = "/selectSjColorTables")
+    public void selectSjColorTables(int pageSize, int pageIndex, HttpServletRequest req, HttpServletResponse res) {
+        pageIndex = Math.max(pageIndex, 1);
+        pageSize = Math.max(pageSize, 5);
+
+        shuJianService.selectSjColorTables(pageSize, pageIndex, req, res);
+    }
+
+    @SysLog()
+    @ApiOperation(value = "鎻掑叆鏁扮畝鏈嶅姟")
     @ApiImplicitParams({
             @ApiImplicitParam(name = "entity", value = "瀹炰綋绫�", dataType = "PubEntity", paramType = "body")
     })
-    @PostMapping(value = "/insertForPub", produces = "application/json; charset=UTF-8")
-    public ResponseMsg<Object> insertForPub(@RequestBody PubEntity entity, HttpServletRequest req) {
+    @ResponseBody
+    @PostMapping(value = "/insertSjService", produces = "application/json; charset=UTF-8")
+    public ResponseMsg<Object> insertSjService(@RequestBody PubEntity entity, HttpServletRequest req, HttpServletResponse res) {
         try {
             if (null == entity || null == entity.getIds() || entity.getIds().isEmpty()) {
                 return fail("瀹炰綋绫讳负绌烘垨鎵句笉鍒板厓鏁版嵁ID", 0);
             }
             if (StringHelper.isEmpty(entity.getType())) {
-                return fail("鏁版嵁绫诲埆涓虹┖", null);
+                return fail("鍙戝竷绫诲埆涓虹┖", null);
             }
 
             UserEntity ue = tokenService.getCurrentUser(req);
-            if (ue != null) {
+            if (null != ue) {
                 entity.setUserId(ue.getId());
-                entity.setToken(WebHelper.getToken(req));
+                entity.setDepcode(ue.getDepcode());
             }
 
-            String method = getConvertMethod(entity.getType());
-            long count = publishService.postForPub(entity, method, req);
+            permsService.clearPermsCache();
+            Integer rows = shuJianService.insertSjService(entity);
 
-            return success(count);
+            return success(rows);
         } catch (Exception ex) {
             return fail(ex.getMessage(), -1);
         }
     }
 
-    /**
-     * 鑾峰彇杞崲鏂规硶
-     */
-    private String getConvertMethod(String type) throws Exception {
-        switch (type) {
-            case "DOM":
-                return "/Convert/ToTiles";
-            case "DEM":
-                return "/Convert/ToTerra";
-            case "MPT":
-            case "3DML":
-                return "/Convert/ToSG";
-            case "BIM":
-                return "/Convert/ToTileset";
-            default:
-                throw new Exception("鏁版嵁绫诲瀷涓嶅尮閰�");
+    @SysLog()
+    @ApiOperation(value = "鏇存柊鏁扮畝鏈嶅姟")
+    @ApiImplicitParams({
+            @ApiImplicitParam(name = "entity", value = "瀹炰綋绫�", dataType = "PubEntity", paramType = "body")
+    })
+    @ResponseBody
+    @PostMapping(value = "/updateSjService", produces = "application/json; charset=UTF-8")
+    public ResponseMsg<Object> updateSjService(@RequestBody PubEntity entity, HttpServletRequest req, HttpServletResponse res) {
+        try {
+            if (null == entity || null == entity.getPubid()) {
+                return fail("瀹炰綋绫讳负绌烘垨鍙戝竷ID涓虹┖", 0);
+            }
+            if (StringHelper.isEmpty(entity.getType())) {
+                return fail("鍙戝竷绫诲埆涓虹┖", null);
+            }
+
+            UserEntity ue = tokenService.getCurrentUser(req);
+            if (null != ue) {
+                entity.setUserId(ue.getId());
+                entity.setDepcode(ue.getDepcode());
+            }
+
+            permsService.clearPermsCache();
+            Integer rows = shuJianService.updateSjService(entity, req, res);
+
+            return success(rows);
+        } catch (Exception ex) {
+            return fail(ex.getMessage(), -1);
         }
     }
 
     @SysLog()
-    @ApiOperation(value = "鍒犻櫎澶氭潯")
+    @ApiOperation(value = "鍒犻櫎鏁扮畝鏈嶅姟")
     @ApiImplicitParams({
             @ApiImplicitParam(name = "ids", value = "ID鏁扮粍", dataType = "Integer", paramType = "query", allowMultiple = true, example = "1")
     })
     @GetMapping(value = "/deletes")
-    public ResponseMsg<Integer> deletes(@RequestParam List<Integer> ids, HttpServletRequest req) {
+    public ResponseMsg<Integer> deletesSjServices(@RequestParam List<Integer> ids) {
         try {
-            if (ids == null || ids.isEmpty()) {
+            if (null == ids || ids.isEmpty()) {
                 return fail("id鏁扮粍涓嶈兘涓虹┖", -1);
             }
 
-            int count = publishService.deletes(ids, req);
-
-            return success(count);
-        } catch (Exception ex) {
-            return fail(ex.getMessage(), -1);
-        }
-    }
-
-    @SysLog()
-    @ApiOperation(value = "鏇存柊涓�鏉�")
-    @ApiImplicitParams({
-            @ApiImplicitParam(name = "entity", value = "瀹炰綋绫�", dataType = "PublishEntity", paramType = "body")
-    })
-    @ResponseBody
-    @PostMapping(value = "/update", produces = "application/json; charset=UTF-8")
-    public ResponseMsg<Integer> update(@RequestBody PublishEntity entity, HttpServletRequest req) {
-        try {
-            UserEntity ue = tokenService.getCurrentUser(req);
-            if (ue != null) {
-                entity.setUpdateUser(ue.getId());
-            }
-
-            int count = publishService.update(entity);
+            permsService.clearPermsCache();
+            int count = shuJianService.deletesSjServices(ids);
 
             return success(count);
         } catch (Exception ex) {

--
Gitblit v1.9.3