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 | 76 +++++++++++++++++++++++++++++++++++++
1 files changed, 75 insertions(+), 1 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 c5b3f69..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.*;
/**
@@ -27,6 +32,9 @@
public class RasterAnalysisController extends BaseController {
@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));
@@ -91,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) {
@@ -111,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