From d2811d5ee9b13f301326d18b118dde40ba811b14 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期四, 16 十一月 2023 12:46:30 +0800
Subject: [PATCH] 添加xls模板
---
src/main/java/com/moon/server/controller/data/RasterAnalysisController.java | 88 +++++++++++++++++++++++++++++++++++++++++---
1 files changed, 82 insertions(+), 6 deletions(-)
diff --git a/src/main/java/com/moon/server/controller/data/RasterAnalysisController.java b/src/main/java/com/moon/server/controller/data/RasterAnalysisController.java
index 3da5c79..2486fef 100644
--- a/src/main/java/com/moon/server/controller/data/RasterAnalysisController.java
+++ b/src/main/java/com/moon/server/controller/data/RasterAnalysisController.java
@@ -3,8 +3,11 @@
import com.moon.server.annotation.SysLog;
import com.moon.server.controller.all.BaseController;
import com.moon.server.entity.all.ResponseMsg;
+import com.moon.server.entity.all.StaticData;
import com.moon.server.helper.StringHelper;
+import com.moon.server.helper.WebHelper;
import com.moon.server.service.data.RasterAnalysisService;
+import com.moon.server.service.data.SlopeAnalysisService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiImplicitParam;
import io.swagger.annotations.ApiImplicitParams;
@@ -14,6 +17,8 @@
import org.springframework.web.bind.annotation.*;
import javax.annotation.Resource;
+import javax.servlet.http.HttpServletRequest;
+import javax.servlet.http.HttpServletResponse;
import java.util.*;
/**
@@ -28,7 +33,12 @@
@Resource
RasterAnalysisService rasterService;
+ @Resource
+ SlopeAnalysisService slopeAnalysisService;
+
private final static List<Integer> PIXELS = new ArrayList<>(Arrays.asList(1, 2, 4, 8, 16, 32, 64, 128, 256));
+
+ private final static List<Integer> NODES = new ArrayList<>(Arrays.asList(16, 32, 64, 96, 128, 192, 256, 384, 512, 768, 1024));
@SysLog()
@ApiOperation(value = "鏌ヨ鐐瑰垎鏋�")
@@ -62,10 +72,10 @@
@ApiOperation(value = "鏌ヨ绾垮垎鏋�")
@ApiImplicitParams({
@ApiImplicitParam(name = "wkt", value = "绾縒KT", dataType = "String", example = "LINESTRING(165.680851 31.333443,166.383982 31.283475,166.016355 30.908709)"),
- @ApiImplicitParam(name = "pixel", value = "鍍忕礌鍊�", dataType = "Integer", example = "1")
+ @ApiImplicitParam(name = "nodes", value = "鑺傜偣鏁�", dataType = "Integer", example = "16")
})
@GetMapping(value = "/selectByPolyline")
- public ResponseMsg<Object> selectByPolyline(String wkt, Integer pixel) {
+ public ResponseMsg<Object> selectByPolyline(String wkt, Integer nodes) {
try {
if (StringHelper.isEmpty(wkt)) {
return fail("WKT瀛楃涓蹭笉鑳戒负绌�");
@@ -74,11 +84,11 @@
if (null == geo || geo.GetGeometryType() != ogr.wkbLineString) {
return fail("WKT瀛楃涓蹭笉姝ｇ‘");
}
- if (null == pixel || !PIXELS.contains(pixel)) {
- return fail("鍍忕礌鍊煎彧鑳戒负锛�" + StringHelper.join(PIXELS, ", "));
+ if (null == nodes || !NODES.contains(nodes)) {
+ return fail("鑺傜偣鏁板彧鑳戒负锛�" + StringHelper.join(NODES, ", "));
}
- List<?> rs = rasterService.analysis(geo, pixel);
+ List<?> rs = rasterService.analysis(geo, nodes);
return success(rs.size(), rs);
} catch (Exception ex) {
@@ -89,7 +99,8 @@
@SysLog()
@ApiOperation(value = "鏌ヨ闈㈠垎鏋�")
@ApiImplicitParams({
- @ApiImplicitParam(name = "wkt", value = "闈KT", dataType = "String", example = "POLYGON ((165.680851 31.333443,166.383982 31.283475,166.016355 30.908709,165.680851 31.333443))")
+ //@ApiImplicitParam(name = "wkt", value = "闈KT", dataType = "String", example = "POLYGON ((165.680851 31.333443,166.383982 31.283475,166.016355 30.908709,165.680851 31.333443))")
+ @ApiImplicitParam(name = "wkt", value = "闈KT", dataType = "String", example = "POLYGON ((56.61 33.94,115.04 33.56,114.09 -7.17,52.22 -6.22,56.61 33.94))")
})
@GetMapping(value = "/selectByPolygon")
public ResponseMsg<Object> selectByPolygon(String wkt) {
@@ -109,4 +120,69 @@
return fail(ex, null);
}
}
+
+ @SysLog()
+ @ApiOperation(value = "浣跨敤WKT鏌ヨ鍒嗘瀽锛岀粨鏋滀互娑堟伅鎺ㄩ��")
+ @ApiImplicitParams({
+ @ApiImplicitParam(name = "wkt", value = "WKT瀛楃涓�", dataType = "String", example = "POLYGON ((56.61 33.94,115.04 33.56,114.09 -7.17,52.22 -6.22,56.61 33.94))"),
+ @ApiImplicitParam(name = "size", value = "鍍忕礌鍊�(鐐�)鎴栬妭鐐规暟(绾�)", dataType = "Integer", example = "16")
+ })
+ @GetMapping(value = "/selectByWktForPost")
+ public void selectByWktForPost(String wkt, Integer size, HttpServletRequest req, HttpServletResponse res) {
+ try {
+ if (StringHelper.isEmpty(wkt)) {
+ WebHelper.writeStr2Page(res, "WKT瀛楃涓蹭笉鑳戒负绌�");
+ return;
+ }
+ Geometry geo = Geometry.CreateFromWkt(wkt);
+ if (null == geo) {
+ WebHelper.writeStr2Page(res, "WKT瀛楃涓蹭笉姝ｇ‘");
+ return;
+ }
+ int wktType = geo.GetGeometryType();
+ if (wktType != ogr.wkbPoint && wktType != ogr.wkbLineString && wktType != ogr.wkbPolygon) {
+ WebHelper.writeStr2Page(res, "WKT瀛楃涓插彧鏀寔鐐广�佺嚎涓插拰闈㈢被鍨�");
+ return;
+ }
+ if (null == size || size < 0 || size > StaticData.I1024) {
+ WebHelper.writeStr2Page(res, "鍍忕礌鍊�(鐐�)鎴栬妭鐐规暟(绾�)鍊间笉姝ｇ‘");
+ return;
+ }
+
+ String token = WebHelper.getToken(req);
+ rasterService.analysisForPost(geo, size, token);
+ } catch (Exception ex) {
+ log.error(ex.getMessage(), ex);
+ }
+ }
+
+ @SysLog()
+ @ApiOperation(value = "涓嬭浇鍧″害鍒嗘瀽Excel")
+ @ApiImplicitParams({
+ @ApiImplicitParam(name = "wkt", value = "WKT瀛楃涓�", dataType = "String", example = "POLYGON ((-103.2 -12.9,-84.2 -14.3,-86.8 -27.5,-105.1 -25.3,-103.2 -12.9))")
+ })
+ @GetMapping(value = "/downloadSlopXls")
+ public void downloadSlopXls(String wkt, HttpServletRequest req, HttpServletResponse res) {
+ try {
+ if (StringHelper.isEmpty(wkt)) {
+ WebHelper.writeStr2Page(res, "WKT瀛楃涓蹭笉鑳戒负绌�");
+ return;
+ }
+ Geometry geo = Geometry.CreateFromWkt(wkt);
+ if (null == geo) {
+ WebHelper.writeStr2Page(res, "WKT瀛楃涓蹭笉姝ｇ‘");
+ return;
+ }
+ int wktType = geo.GetGeometryType();
+ if (wktType != ogr.wkbPolygon) {
+ WebHelper.writeStr2Page(res, "WKT瀛楃涓插彧鏀寔闈㈢被鍨�");
+ return;
+ }
+
+ slopeAnalysisService.downloadSlopXls(geo, res);
+ } catch (Exception ex) {
+ WebHelper.writeStr2Page(res, ex.getMessage());
+ log.error(ex.getMessage(), ex);
+ }
+ }
}
--
Gitblit v1.9.3