From 87204491aac135822f96f3fff297ddca400ea8c9 Mon Sep 17 00:00:00 2001
From: tangzy <tangzy123456>
Date: Wed, 20 Oct 2021 15:09:32 +0800
Subject: [PATCH] 1.山洪
---
src/main/java/org/springblade/modules/mountainrain/controller/MountainrainController.java | 215 ++++++++++++++++++++++++++++++++++++-----------------
1 files changed, 147 insertions(+), 68 deletions(-)
diff --git a/src/main/java/org/springblade/modules/mountainrain/controller/MountainrainController.java b/src/main/java/org/springblade/modules/mountainrain/controller/MountainrainController.java
index 3220316..07a9204 100644
--- a/src/main/java/org/springblade/modules/mountainrain/controller/MountainrainController.java
+++ b/src/main/java/org/springblade/modules/mountainrain/controller/MountainrainController.java
@@ -23,6 +23,7 @@
import lombok.AllArgsConstructor;
import org.apache.poi.hssf.usermodel.*;
import org.springblade.core.boot.ctrl.BladeController;
+import org.springblade.core.excel.util.ExcelUtil;
import org.springblade.core.log.annotation.ApiLog;
import org.springblade.core.mp.support.Condition;
import org.springblade.core.mp.support.Query;
@@ -33,10 +34,16 @@
import org.springblade.modules.mountain.vo.MountainVO;
import org.springblade.modules.mountainrain.entity.Mountainrain;
import org.springblade.modules.mountainrain.entity.Yucpptn;
+import org.springblade.modules.mountainrain.excel.BgrExcel;
+import org.springblade.modules.mountainrain.excel.BgrImporter;
+import org.springblade.modules.mountainrain.excel.MgrExcel;
+import org.springblade.modules.mountainrain.excel.MgrImporter;
import org.springblade.modules.mountainrain.service.IMountainrainService;
import org.springblade.modules.mountainrain.vo.*;
import org.springblade.modules.mountainrain.wrapper.MountainrainWrapper;
import org.springblade.modules.regionWeight.service.IRegionWeightService;
+import org.springblade.modules.system.excel.UserExcel;
+import org.springblade.modules.system.excel.UserImporter;
import org.springframework.stereotype.Component;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;
@@ -47,6 +54,7 @@
import java.io.*;
import java.math.BigDecimal;
import java.net.URLEncoder;
+import java.sql.Timestamp;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.*;
@@ -598,8 +606,13 @@
e.printStackTrace();
}
Process proc;
+ Timestamp timestamp = new Timestamp(System.currentTimeMillis());
+ long url = timestamp.getTime();
+ Map m = new HashMap();
+ m.put("url", url + ".png");
+ String[] args1 = new String[]{"python", "D:\\fz\\mou.py", String.valueOf(url)};
try {
- proc = Runtime.getRuntime().exec("python D:\\fz\\mou.py");
+ proc = Runtime.getRuntime().exec(args1);
BufferedReader in = new BufferedReader(new InputStreamReader(proc.getInputStream()));
String line = null;
while ((line = in.readLine()) != null) {
@@ -612,6 +625,7 @@
} catch (InterruptedException e) {
e.printStackTrace();
}
+ lists.add(m);
return R.data(lists);
}
@@ -720,8 +734,13 @@
e.printStackTrace();
}
Process proc;
+ Timestamp timestamp = new Timestamp(System.currentTimeMillis());
+ long url = timestamp.getTime();
+ Map m = new HashMap();
+ m.put("url", url + ".png");
+ String[] args1 = new String[]{"python", "D:\\fz\\moup.py", String.valueOf(url)};
try {
- proc = Runtime.getRuntime().exec("python D:\\fz\\moup.py");
+ proc = Runtime.getRuntime().exec(args1);
BufferedReader in = new BufferedReader(new InputStreamReader(proc.getInputStream()));
String line = null;
while ((line = in.readLine()) != null) {
@@ -734,34 +753,34 @@
} catch (InterruptedException e) {
e.printStackTrace();
}
+ lists.add(m);
return R.data(lists);
}
}
- /**
- * 土壤湿度计算
- *
- * @return
- */
- @GetMapping("/soleval")
- public R soleval() {
- mountainrainService.soildel();
- int intervals = 31;
- ArrayList passDaysList = new ArrayList<>();
- for (int i = 0; i < intervals; i++) {
- passDaysList.add(getDays(i, false));
- }
- Collections.sort(passDaysList);
- //String s = mountainrainService.selectCode();
- String s = regionWeightService.selectCode();
- String[] split = s.split(",");
- String strArrays = "";
- System.out.println("长度："+split.length);
- for (int i = 0; i < split.length; i++) {
- strArrays += "'" + split[i] + "',";
- }
- String code = strArrays.substring(0, strArrays.length() - 1);
+// /**
+// * 土壤湿度计算
+// *
+// * @return
+// */
+// @GetMapping("/soleval")
+// public R soleval() {
+// mountainrainService.soildel();
+// int intervals = 31;
+// ArrayList passDaysList = new ArrayList<>();
+// for (int i = 0; i < intervals; i++) {
+// passDaysList.add(getDays(i, false));
+// }
+// Collections.sort(passDaysList);
+// //String s = mountainrainService.selectCode();
+// String s = regionWeightService.selectCode();
+// String[] split = s.split(",");
+// String strArrays = "";
+// for (int i = 0; i < split.length; i++) {
+// strArrays += "'" + split[i] + "',";
+// }
+// String code = strArrays.substring(0, strArrays.length() - 1);
// for (int i = 0; i < split.length; i++) {
// Integer num = 30;
// double v1 = 0;
@@ -795,9 +814,9 @@
// mountainrainService.soleInster(stcd, a);
// }
// }
-
- return R.success("成功");
- }
+//
+// return R.success("成功");
+// }
public static double formatDouble1(double d) {
return (double) Math.round(d * 10) / 10;
@@ -1121,6 +1140,7 @@
String[] split = s.split(",");
String strArrays = "";
for (int i = 0; i < split.length; i++) {
+ System.out.println(split.length);
strArrays += "'" + split[i] + "',";
}
String code = strArrays.substring(0, strArrays.length() - 1);
@@ -1136,11 +1156,13 @@
if (mountainrainsCVOS.get(i).getDrp1() > mountainrainsCVOS.get(i).getGohours()) {
int drp1 = mountainrainsCVOS.get(i).getDrp1();
Integer gohours = mountainrainsCVOS.get(i).getGohours();
- int i1 = drp1 - gohours;
+ float i1 = (float)drp1 - gohours;
+ float v = (float) (Math.round(i1 * 10)) / 10;
+ String a= String.valueOf(v);
map.put("List", mountainrainsCVOS.get(i));
map.put("flage1", "true");
map.put("status", 2);
- map.put("num", i1);
+ map.put("num", a);
lists.add(map);
} else {
map.put("List", mountainrainsCVOS.get(i));
@@ -1153,11 +1175,13 @@
if (mountainrainsCVOS.get(i).getDrp1() > mountainrainsCVOS.get(i).getGohour()) {
int drp1 = mountainrainsCVOS.get(i).getDrp1();
Integer gohour = mountainrainsCVOS.get(i).getGohour();
- int i1 = drp1 - gohour;
+ float i1 = (float)drp1 - gohour;
+ float v = (float) (Math.round(i1 * 10)) / 10;
+ String a= String.valueOf(v);
map.put("List", mountainrainsCVOS.get(i));
map.put("flage1", "true");
map.put("status", 1);
- map.put("num", i1);
+ map.put("num", a);
lists.add(map);
} else {
map.put("List", mountainrainsCVOS.get(i));
@@ -1223,8 +1247,13 @@
e.printStackTrace();
}
Process proc;
+ Timestamp timestamp = new Timestamp(System.currentTimeMillis());
+ long url = timestamp.getTime();
+ Map m = new HashMap();
+ m.put("url", url + ".png");
+ String[] args1 = new String[]{"python", "D:\\fz\\mou.py", String.valueOf(url)};
try {
- proc = Runtime.getRuntime().exec("python D:\\fz\\mou.py");
+ proc = Runtime.getRuntime().exec(args1);
BufferedReader in = new BufferedReader(new InputStreamReader(proc.getInputStream()));
String line = null;
while ((line = in.readLine()) != null) {
@@ -1237,6 +1266,7 @@
} catch (InterruptedException e) {
e.printStackTrace();
}
+ lists.add(m);
return R.data(lists);
}
@@ -1263,8 +1293,10 @@
double drp1 = w1.doubleValue();
if (drp1 > 30) {
double v = drp1 - 30;
+ double v1 = (double) Math.round(v * 100) / 100;
+ String a=String.valueOf(v1);
map.put("flage1", "true");
- map.put("num", v);
+ map.put("num", a);
} else {
map.put("flage1", "false");
}
@@ -1314,8 +1346,13 @@
e.printStackTrace();
}
Process proc;
+ Timestamp timestamp = new Timestamp(System.currentTimeMillis());
+ long url = timestamp.getTime();
+ Map m = new HashMap();
+ m.put("url", url + ".png");
+ String[] args1 = new String[]{"python", "D:\\fz\\moup.py", String.valueOf(url)};
try {
- proc = Runtime.getRuntime().exec("python D:\\fz\\moup.py");
+ proc = Runtime.getRuntime().exec(args1);
BufferedReader in = new BufferedReader(new InputStreamReader(proc.getInputStream()));
String line = null;
while ((line = in.readLine()) != null) {
@@ -1328,6 +1365,7 @@
} catch (InterruptedException e) {
e.printStackTrace();
}
+ lists.add(m);
return R.data(lists);
}
@@ -1366,12 +1404,14 @@
if (mountainrainsCVOS.get(i).getDrp1() > mountainrainsCVOS.get(i).getGohours()) {
int drp1 = mountainrainsCVOS.get(i).getDrp1();
Integer gohours = mountainrainsCVOS.get(i).getGohours();
- int i1 = drp1 - gohours;
+ float i1 = (float)drp1 - gohours;
+ float v = (float) (Math.round(i1 * 10)) / 10;
+ String a= String.valueOf(v);
map.put("List", mountainrainsCVOS.get(i));
map.put("flage1", "true");
map.put("flage3", "false");
map.put("status", 2);
- map.put("num", i1);
+ map.put("num", a);
lists.add(map);
} else if (mountainrainsCVOS.get(i).getDrp3() > mountainrainsCVOS.get(i).getGthours()) {
map.put("List", mountainrainsCVOS.get(i));
@@ -1391,12 +1431,14 @@
if (mountainrainsCVOS.get(i).getDrp1() > mountainrainsCVOS.get(i).getGohour()) {
int drp1 = mountainrainsCVOS.get(i).getDrp1();
Integer gohour = mountainrainsCVOS.get(i).getGohour();
- int i1 = drp1 - gohour;
+ float i1 = (float)drp1 - gohour;
+ float v = (float) (Math.round(i1 * 10)) / 10;
+ String a= String.valueOf(v);
map.put("List", mountainrainsCVOS.get(i));
map.put("flage1", "true");
map.put("flage3", "false");
map.put("status", 1);
- map.put("num", i1);
+ map.put("num", a);
lists.add(map);
} else if (mountainrainsCVOS.get(i).getDrp3() > mountainrainsCVOS.get(i).getGthour()) {
map.put("List", mountainrainsCVOS.get(i));
@@ -1475,8 +1517,13 @@
e.printStackTrace();
}
Process proc;
+ Timestamp timestamp = new Timestamp(System.currentTimeMillis());
+ long url = timestamp.getTime();
+ Map m = new HashMap();
+ m.put("url", url + ".png");
+ String[] args1 = new String[]{"python", "D:\\fz\\mou.py", String.valueOf(url)};
try {
- proc = Runtime.getRuntime().exec("python D:\\fz\\mou.py");
+ proc = Runtime.getRuntime().exec(args1);
BufferedReader in = new BufferedReader(new InputStreamReader(proc.getInputStream()));
String line = null;
while ((line = in.readLine()) != null) {
@@ -1489,6 +1536,7 @@
} catch (InterruptedException e) {
e.printStackTrace();
}
+ lists.add(m);
return R.data(lists);
}
@@ -1515,8 +1563,9 @@
double drp1 = w1.doubleValue();
if (drp1 > 50) {
double v = drp1 - 50;
+ double v1 = (double) Math.round(v * 10) / 10;
map.put("flage2", "true");
- map.put("num", v);
+ map.put("num", v1);
} else {
map.put("flage2", "false");
}
@@ -1547,13 +1596,13 @@
double drp1 = w1.doubleValue();
row.createCell((short) 0).setCellValue(list.get(i).get("LGTD").toString());
row.createCell((short) 1).setCellValue(list.get(i).get("LTTD").toString());
- if (drp1 > 50) {
- row.createCell((short) 2).setCellValue(2);
- continue;
- } else {
- row.createCell((short) 2).setCellValue(1);
- continue;
- }
+ if (drp1 > 50) {
+ row.createCell((short) 2).setCellValue(2);
+ continue;
+ } else {
+ row.createCell((short) 2).setCellValue(1);
+ continue;
+ }
}
// 第六步，将文件存到指定位置
try {
@@ -1566,8 +1615,13 @@
e.printStackTrace();
}
Process proc;
+ Timestamp timestamp = new Timestamp(System.currentTimeMillis());
+ long url = timestamp.getTime();
+ Map m = new HashMap();
+ m.put("url", url + ".png");
+ String[] args1 = new String[]{"python", "D:\\fz\\moup.py", String.valueOf(url)};
try {
- proc = Runtime.getRuntime().exec("python D:\\fz\\moup.py");
+ proc = Runtime.getRuntime().exec(args1);
BufferedReader in = new BufferedReader(new InputStreamReader(proc.getInputStream()));
String line = null;
while ((line = in.readLine()) != null) {
@@ -1580,6 +1634,7 @@
} catch (InterruptedException e) {
e.printStackTrace();
}
+ lists.add(m);
return R.data(lists);
}
@@ -1619,11 +1674,13 @@
if (mountainrainsCVOS.get(i).getDrp1() > mountainrainsCVOS.get(i).getGthours()) {
int drp1 = mountainrainsCVOS.get(i).getDrp1();
Integer gohours = mountainrainsCVOS.get(i).getGohours();
- int i1 = drp1 - gohours;
+ float i1 = (float)drp1 - gohours;
+ float v = (float) (Math.round(i1 * 10)) / 10;
+ String a= String.valueOf(v);
map.put("List", mountainrainsCVOS.get(i));
map.put("flage3", "true");
map.put("status", 2);
- map.put("num", i1);
+ map.put("num", a);
lists.add(map);
} else {
map.put("List", mountainrainsCVOS.get(i));
@@ -1636,11 +1693,13 @@
if (mountainrainsCVOS.get(i).getDrp1() > mountainrainsCVOS.get(i).getGthour()) {
int drp1 = mountainrainsCVOS.get(i).getDrp1();
Integer gohour = mountainrainsCVOS.get(i).getGohour();
- int i1 = drp1 - gohour;
+ float i1 = (float)drp1 - gohour;
+ float v = (float) (Math.round(i1 * 10)) / 10;
+ String a= String.valueOf(v);
map.put("List", mountainrainsCVOS.get(i));
map.put("flage3", "true");
map.put("status", 1);
- map.put("num", i1);
+ map.put("num", a);
lists.add(map);
} else {
map.put("List", mountainrainsCVOS.get(i));
@@ -1706,8 +1765,13 @@
e.printStackTrace();
}
Process proc;
+ Timestamp timestamp = new Timestamp(System.currentTimeMillis());
+ long url = timestamp.getTime();
+ Map m = new HashMap();
+ m.put("url", url + ".png");
+ String[] args1 = new String[]{"python", "D:\\fz\\mou.py", String.valueOf(url)};
try {
- proc = Runtime.getRuntime().exec("python D:\\fz\\mou.py");
+ proc = Runtime.getRuntime().exec(args1);
BufferedReader in = new BufferedReader(new InputStreamReader(proc.getInputStream()));
String line = null;
while ((line = in.readLine()) != null) {
@@ -1720,6 +1784,7 @@
} catch (InterruptedException e) {
e.printStackTrace();
}
+ lists.add(m);
return R.data(lists);
}
@@ -1746,8 +1811,9 @@
double drp1 = w1.doubleValue();
if (drp1 > 80) {
double v = drp1 - 80;
+ double v1 = (double) Math.round(v * 10) / 10;
map.put("flage3", "true");
- map.put("num", v);
+ map.put("num", v1);
} else {
map.put("flage3", "false");
}
@@ -1798,8 +1864,13 @@
e.printStackTrace();
}
Process proc;
+ Timestamp timestamp = new Timestamp(System.currentTimeMillis());
+ long url = timestamp.getTime();
+ Map m = new HashMap();
+ m.put("url", url + ".png");
+ String[] args1 = new String[]{"python", "D:\\fz\\moup.py", String.valueOf(url)};
try {
- proc = Runtime.getRuntime().exec("python D:\\fz\\moup.py");
+ proc = Runtime.getRuntime().exec(args1);
BufferedReader in = new BufferedReader(new InputStreamReader(proc.getInputStream()));
String line = null;
while ((line = in.readLine()) != null) {
@@ -1812,6 +1883,7 @@
} catch (InterruptedException e) {
e.printStackTrace();
}
+ lists.add(m);
return R.data(lists);
}
@@ -1821,7 +1893,7 @@
* 土壤色斑图
*/
@GetMapping("/selectS")
- public void selectS(){
+ public R selectS(String time) {
List<Map<String, Object>> list = mountainrainService.selectS();
String fileName = "";
// 第一步，创建一个webbook，对应一个Excel文件
@@ -1847,47 +1919,47 @@
row.createCell((short) 0).setCellValue(list.get(i).get("LGTD").toString());
row.createCell((short) 1).setCellValue(list.get(i).get("LTTD").toString());
row.createCell((short) 2).setCellValue(list.get(i).get("soilval").toString());
- if (stcd.equals("62455350")){
+ if (stcd.equals("62455350")) {
row.createCell((short) 0).setCellValue("117.344876");
row.createCell((short) 1).setCellValue("27.827067");
row.createCell((short) 2).setCellValue(list.get(i).get("soilval").toString());
}
- if (stcd.equals("62334845")){
+ if (stcd.equals("62334845")) {
row.createCell((short) 0).setCellValue("115.625720");
row.createCell((short) 1).setCellValue("27.152794");
row.createCell((short) 2).setCellValue(list.get(i).get("soilval").toString());
}
- if (stcd.equals("62433800")){
+ if (stcd.equals("62433800")) {
row.createCell((short) 0).setCellValue("115.618546");
row.createCell((short) 1).setCellValue("27.683604");
row.createCell((short) 2).setCellValue(list.get(i).get("soilval").toString());
}
- if (stcd.equals("62436760")){
+ if (stcd.equals("62436760")) {
row.createCell((short) 0).setCellValue("116.060889");
row.createCell((short) 1).setCellValue("28.216806");
row.createCell((short) 2).setCellValue(list.get(i).get("soilval").toString());
}
- if (stcd.equals("62437250")){
+ if (stcd.equals("62437250")) {
row.createCell((short) 0).setCellValue("116.622783");
row.createCell((short) 1).setCellValue("28.489384");
row.createCell((short) 2).setCellValue(list.get(i).get("soilval").toString());
}
- if (stcd.equals("62433700")){
+ if (stcd.equals("62433700")) {
row.createCell((short) 0).setCellValue("115.558771");
row.createCell((short) 1).setCellValue("27.518623");
row.createCell((short) 2).setCellValue(list.get(i).get("soilval").toString());
}
- if (stcd.equals("62425740")){
+ if (stcd.equals("62425740")) {
row.createCell((short) 0).setCellValue("117.208587");
row.createCell((short) 1).setCellValue("27.298647");
row.createCell((short) 2).setCellValue(list.get(i).get("soilval").toString());
}
- if (stcd.equals("62437235")){
+ if (stcd.equals("62437235")) {
row.createCell((short) 0).setCellValue("116.780591");
row.createCell((short) 1).setCellValue("28.391352");
row.createCell((short) 2).setCellValue(list.get(i).get("soilval").toString());
}
- if (stcd.equals("62437250")){
+ if (stcd.equals("62437250")) {
row.createCell((short) 0).setCellValue("116.555834");
row.createCell((short) 1).setCellValue("28.518077");
row.createCell((short) 2).setCellValue(list.get(i).get("soilval").toString());
@@ -1904,8 +1976,13 @@
e.printStackTrace();
}
Process proc;
+ Timestamp timestamp = new Timestamp(System.currentTimeMillis());
+ long url = timestamp.getTime();
+ Map m = new HashMap();
+ m.put("url", url + ".png");
+ String[] args1 = new String[]{"python", "D:\\fz\\tur.py", String.valueOf(url)};
try {
- proc = Runtime.getRuntime().exec("python D:\\fz\\tur.py");
+ proc = Runtime.getRuntime().exec(args1);
BufferedReader in = new BufferedReader(new InputStreamReader(proc.getInputStream()));
String line = null;
while ((line = in.readLine()) != null) {
@@ -1918,7 +1995,9 @@
} catch (InterruptedException e) {
e.printStackTrace();
}
+ return R.data(m);
+ }
-}
+
}
--
Gitblit v1.9.3