/**
|
* Copyright (c) 2018-2028, Chill Zhuang 庄骞 (smallchill@163.com).
|
* <p>
|
* Licensed under the Apache License, Version 2.0 (the "License");
|
* you may not use this file except in compliance with the License.
|
* You may obtain a copy of the License at
|
* <p>
|
* http://www.apache.org/licenses/LICENSE-2.0
|
* <p>
|
* Unless required by applicable law or agreed to in writing, software
|
* distributed under the License is distributed on an "AS IS" BASIS,
|
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
|
* See the License for the specific language governing permissions and
|
* limitations under the License.
|
*/
|
package org.springblade.modules.mountainrain.controller;
|
|
import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport;
|
import io.swagger.annotations.Api;
|
import io.swagger.annotations.ApiOperation;
|
import jodd.io.PathUtil;
|
import liquibase.pro.packaged.S;
|
import lombok.AllArgsConstructor;
|
import org.apache.poi.hssf.usermodel.HSSFSheet;
|
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
|
import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
|
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
|
import org.apache.poi.ss.usermodel.CellType;
|
import org.apache.poi.ss.usermodel.Sheet;
|
import org.apache.poi.ss.usermodel.Workbook;
|
import org.apache.poi.ss.usermodel.WorkbookFactory;
|
import org.apache.poi.ss.util.CellRangeAddress;
|
import org.apache.poi.xssf.usermodel.XSSFSheet;
|
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
|
import org.python.antlr.ast.Str;
|
import org.springblade.core.boot.ctrl.BladeController;
|
import org.springblade.core.log.annotation.ApiLog;
|
import org.springblade.core.mp.support.Condition;
|
import org.springblade.core.tool.api.R;
|
import org.springblade.modules.mountainrain.entity.Yucbig;
|
import org.springblade.modules.mountainrain.service.IBigriverService;
|
import org.springblade.modules.mountainrain.vo.BigriverVO;
|
import org.springblade.modules.mountainrain.wrapper.BigriverWrapper;
|
import org.springframework.core.io.ClassPathResource;
|
import org.springframework.core.io.Resource;
|
import org.springframework.web.bind.annotation.*;
|
import org.springframework.web.multipart.MultipartFile;
|
|
import javax.servlet.http.HttpServletRequest;
|
import javax.servlet.http.HttpServletResponse;
|
import javax.validation.Valid;
|
import java.awt.image.BufferedImage;
|
import java.io.*;
|
import java.math.BigDecimal;
|
import java.security.MessageDigest;
|
import java.text.DateFormat;
|
import java.text.ParseException;
|
import java.text.SimpleDateFormat;
|
import java.util.*;
|
|
/**
|
* 控制器
|
*
|
* @author Blade
|
* @since 2019-11-07
|
*/
|
@RestController
|
@AllArgsConstructor
|
@RequestMapping("/bigriver")
|
@Api(value = "", tags = "接口")
|
public class BigriverController extends BladeController {
|
|
private IBigriverService iBigriverService;
|
|
/**
|
* 详情
|
*/
|
@ApiLog("详情")
|
@GetMapping("/detail")
|
@ApiOperationSupport(order = 1)
|
@ApiOperation(value = "详情", notes = "site")
|
public R<Yucbig> detail(Yucbig yucbig) {
|
Yucbig detail = iBigriverService.getOne(Condition.getQueryWrapper(yucbig));
|
return R.data(BigriverWrapper.build().entityVO(detail));
|
}
|
|
|
/**
|
* 新增
|
*/
|
@ApiLog("新增")
|
@PostMapping("/save")
|
@ApiOperationSupport(order = 4)
|
@ApiOperation(value = "新增", notes = "传入site")
|
public R save(@Valid @RequestBody Yucbig yucbig) {
|
return R.status(iBigriverService.save(yucbig));
|
}
|
|
/**
|
* 修改
|
*/
|
@ApiLog("修改")
|
@PostMapping("/update")
|
@ApiOperationSupport(order = 5)
|
@ApiOperation(value = "修改", notes = "传入site")
|
public R update(@Valid @RequestBody Yucbig yucbig) {
|
return R.status(iBigriverService.updateById(yucbig));
|
}
|
|
|
// /**
|
// * 大江大河预报数据导入
|
// */
|
// @PostMapping("import-bgr")
|
// public R importbgr(MultipartFile file) {
|
// BgrImporter bgrImporter = new BgrImporter(iBigriverService, false);
|
// ExcelUtil.save(file, bgrImporter, BgrExcel.class);
|
// return R.success("导入成功");
|
// }
|
|
/**
|
* 大江大河预警
|
*
|
* @return
|
*/
|
@GetMapping("/selectbgriver")
|
public R selectbgriver() {
|
List<Map<String, Object>> selctsmriver = iBigriverService.selctbgriver();
|
//预警数据
|
List listyj = new ArrayList();
|
//无预警数据
|
List listzc = new ArrayList();
|
for (int i = 0; i < selctsmriver.size(); i++) {
|
//警戒水位
|
String yjsw = selctsmriver.get(i).get("yjsw").toString();
|
Double yjz = Double.parseDouble(yjsw);
|
//水位
|
String zs = selctsmriver.get(i).get("Z").toString();
|
Double z = Double.parseDouble(zs);
|
if (z > yjz) {
|
listyj.add(selctsmriver.get(i));
|
} else {
|
listzc.add(selctsmriver.get(i));
|
}
|
}
|
Map map = new HashMap();
|
map.put("yj", listyj);
|
map.put("zc", listzc);
|
List list = new ArrayList();
|
list.add(map);
|
return R.data(list);
|
}
|
|
|
@PostMapping("import-bgr")
|
public void importbgr(MultipartFile file) throws IOException, InvalidFormatException {
|
InputStream is = file.getInputStream();
|
HSSFWorkbook workbook = new HSSFWorkbook(is);
|
//确定版本
|
boolean isExcel2003 = file.getOriginalFilename().endsWith("xls") ? true : false;
|
List<Map<String, Object>> returnMap;//返回execlClass类见下
|
if (isExcel2003) { //判断版本
|
HSSFSheet sheet = workbook.getSheetAt(1);
|
sheet.getRow(4).getCell(12).setCellType(CellType.STRING);
|
sheet.getRow(4).getCell(13).setCellType(CellType.STRING);
|
sheet.getRow(4).getCell(14).setCellType(CellType.STRING);
|
sheet.getRow(4).getCell(15).setCellType(CellType.STRING);
|
sheet.getRow(4).getCell(3).setCellType(CellType.STRING);
|
sheet.getRow(4).getCell(8).setCellType(CellType.STRING);
|
sheet.getRow(4).getCell(9).setCellType(CellType.STRING);
|
sheet.getRow(4).getCell(10).setCellType(CellType.STRING);
|
sheet.getRow(4).getCell(11).setCellType(CellType.STRING);
|
//发布时间
|
String ftimes = sheet.getRow(1).getCell(11).getStringCellValue();
|
String substring = ftimes.substring(5, ftimes.length());
|
String year = substring.substring(0, substring.lastIndexOf("年"));
|
String yues = substring.substring(substring.indexOf("年") + 1, substring.lastIndexOf("月"));
|
String yue;
|
if (yues.length() == 1) {
|
yue = 0 + yues;
|
} else {
|
yue = yues;
|
}
|
String r = substring.substring(substring.indexOf("月") + 1, substring.lastIndexOf("日"));
|
String ms = substring.substring(substring.indexOf("日") + 1, substring.lastIndexOf("时"));
|
String ftime = year + "-" + yue + "-" + r + " " + ms + ":00:00";
|
//河名
|
String river = sheet.getRow(4).getCell(0).getStringCellValue();
|
//站点名称
|
String stnames = sheet.getRow(4).getCell(1).getStringCellValue();
|
String stcd = iBigriverService.selectINfo(stnames);
|
//降雨量
|
String drp = sheet.getRow(4).getCell(3).getStringCellValue();
|
//降雨起止时间
|
String drptime = sheet.getRow(4).getCell(4).getStringCellValue();
|
//起涨时间
|
String qztime = sheet.getRow(4).getCell(7).getStringCellValue();
|
//起涨流量
|
String qzll = sheet.getRow(4).getCell(9).getStringCellValue();
|
//发布水位
|
String fbsw = sheet.getRow(4).getCell(10).getStringCellValue();
|
//发布流量
|
String fbll = sheet.getRow(4).getCell(11).getStringCellValue();
|
//预报时间
|
String ytimes = sheet.getRow(4).getCell(12).getStringCellValue();
|
String[] split = ytimes.split(",");
|
String a;
|
if (split[0].length() == 1) {
|
a = 0 + yues;
|
} else {
|
a = yues;
|
}
|
String ytime = year + "-" + a + "-" + split[1] + " " + split[2] + ":00:00";
|
//预测水位
|
String yuz = sheet.getRow(4).getCell(13).getStringCellValue();
|
//预警流量
|
String yq = sheet.getRow(4).getCell(14).getStringCellValue();
|
//预警水位
|
String yjsw = sheet.getRow(4).getCell(15).getStringCellValue();
|
//预报水位与警戒水位比较
|
String dbi = sheet.getRow(4).getCell(16).getStringCellValue();
|
//起涨水位
|
String qzsw = sheet.getRow(4).getCell(8).getStringCellValue();
|
Yucbig yucbig = new Yucbig();
|
yucbig.setStcd(stcd);
|
yucbig.setStname(stnames);
|
yucbig.setRiver(river);
|
yucbig.setFtime(ftime);
|
yucbig.setYjsw(yjsw);
|
yucbig.setYtime(ytime);
|
yucbig.setYuz(yuz);
|
yucbig.setYq(yq);
|
yucbig.setQzsw(qzsw);
|
yucbig.setDrp(drp);
|
yucbig.setDrptime(drptime);
|
yucbig.setQztime(qztime);
|
yucbig.setQzsw(qzsw);
|
yucbig.setQzll(qzll);
|
yucbig.setFbsw(fbsw);
|
yucbig.setFbll(fbll);
|
yucbig.setDbi(dbi);
|
iBigriverService.save(yucbig);
|
} else {
|
//有多少个sheet
|
int sheets = workbook.getNumberOfSheets();
|
System.out.println("其他:" + sheets);
|
}
|
}
|
|
|
/**
|
* 主要河流导出预警模板
|
*
|
* @param emp01
|
* @throws IOException
|
* @throws InvalidFormatException
|
*/
|
@PostMapping("createEmpExcel")
|
public void createEmpExcel(@RequestBody Map<String, Object> emp01) throws IOException, InvalidFormatException {
|
// import為需要導入的EXCEL模板，exportFilePath為生成的員工EXCEL文件
|
String importFilePath = "D://excel//temple.xls";
|
//String exportFilePath = "D:\\Excel";
|
|
File fi = new File(importFilePath);
|
InputStream in = new FileInputStream(fi);
|
Workbook wb = WorkbookFactory.create(in);
|
Sheet sheet = wb.getSheetAt(1); //示意访问sheet
|
// //读取excel模板
|
// XSSFWorkbook wb = new XSSFWorkbook(in);
|
// //读取了模板内所有sheet内容
|
// XSSFSheet sheet = wb.getSheetAt(0);
|
//如果这行没有了，整个公式都不会有自动计算的效果的
|
sheet.setForceFormulaRecalculation(true);
|
//河名
|
sheet.getRow(4).getCell(0).setCellValue(emp01.get("river").toString());
|
//站名
|
sheet.getRow(4).getCell(1).setCellValue(emp01.get("stname").toString());
|
//pa
|
sheet.getRow(4).getCell(2).setCellValue(emp01.get("pa").toString());
|
//降雨量
|
sheet.getRow(4).getCell(3).setCellValue(emp01.get("drp").toString());
|
//降雨起止时间
|
sheet.getRow(4).getCell(4).setCellValue(emp01.get("drptime").toString());
|
CellRangeAddress region = new CellRangeAddress(4, 4, 4, 6);
|
sheet.addMergedRegion(region);
|
//起涨时间
|
sheet.getRow(4).getCell(7).setCellValue(emp01.get("qztime").toString());
|
//起涨水位
|
sheet.getRow(4).getCell(8).setCellValue(emp01.get("qzsw").toString());
|
//起涨流量
|
sheet.getRow(4).getCell(9).setCellValue(emp01.get("qzll").toString());
|
//发布时间水位
|
sheet.getRow(4).getCell(10).setCellValue(emp01.get("fbsw").toString());
|
//发布时间流量
|
sheet.getRow(4).getCell(11).setCellValue(emp01.get("fbll").toString());
|
//预报时间
|
sheet.getRow(4).getCell(12).setCellValue(emp01.get("ytime").toString());
|
//预报水位
|
sheet.getRow(4).getCell(13).setCellValue(emp01.get("Z").toString());
|
//预报流量
|
sheet.getRow(4).getCell(14).setCellValue(emp01.get("yq").toString());
|
//警戒水位
|
sheet.getRow(4).getCell(15).setCellValue(emp01.get("yjsw").toString());
|
//预报水位与警戒水位比较
|
sheet.getRow(4).getCell(16).setCellValue(emp01.get("dbi").toString());
|
//防洪对象
|
sheet.getRow(5).getCell(3).setCellValue(emp01.get("fh").toString());
|
CellRangeAddress regions = new CellRangeAddress(5, 6, 3, 16);
|
sheet.addMergedRegion(regions);
|
//发布时间
|
sheet.getRow(1).getCell(11).setCellValue("发布时间:" + emp01.get("ftime").toString());
|
CellRangeAddress regionf = new CellRangeAddress(1, 1, 11, 16);
|
sheet.addMergedRegion(regionf);
|
FileOutputStream out = new FileOutputStream("D://Software//nginx-1.20.0//dist//fzswz//excel//主要河流预警.xls");
|
//FileOutputStream out = new FileOutputStream("D://Temp//主要河流预警.xls");
|
wb.write(out);
|
out.close();
|
}
|
|
|
/**
|
* 大江大河预报库读取
|
*
|
* @return
|
*/
|
@GetMapping("/selectYb")
|
public R selectYb(String time) throws ParseException {
|
//预警数据
|
List listyj = new ArrayList();
|
//无预警数据
|
List listzc = new ArrayList();
|
Map mnum = new HashMap();
|
String s = iBigriverService.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);
|
String substrings = time.substring(0, 10);
|
String ftimez = substrings + " 08:00:00";
|
List<BigriverVO> list = iBigriverService.selectYb(ftimez, code);
|
for (int i = 0; i < list.size(); i++) {
|
String stcd = list.get(i).getStcd();
|
String ftime = list.get(i).getFtime();
|
String substring = ftime.substring(0, 13);
|
String times = substring + ":00:00";
|
String endTime = times;
|
Date dates = beforeHourToNowDate(time, 1);
|
DateFormat sdfc = new SimpleDateFormat("yyyy-MM-dd 08:00:00");
|
String beginTime = sdfc.format(dates);
|
List<Map<String, Object>> list1 = iBigriverService.selecF(stcd, times, beginTime, endTime);
|
for (int c = 0; c < list1.size(); c++) {
|
list.get(i).setFbsw(list1.get(c).get("fbsw").toString());
|
list.get(i).setFbll(list1.get(c).get("fbll").toString());
|
list.get(i).setQzll(list1.get(c).get("qzll").toString());
|
list.get(i).setQztime(list1.get(c).get("qztime").toString());
|
list.get(i).setQzsw(list1.get(c).get("qzsw").toString());
|
}
|
}
|
for (int i = 0; i < list.size(); i++) {
|
String yjsw = list.get(i).getYjsw();
|
Double yjz = Double.parseDouble(yjsw);
|
BigDecimal ybsws = list.get(i).getYbsw();
|
Double ybsw = ybsws.doubleValue();
|
if (ybsw > yjz) {
|
if (mnum.containsKey(list.get(i).getStcd()) == true) {
|
} else {
|
mnum.put(list.get(i).getStcd(), i);
|
listyj.add(list.get(i));
|
}
|
} else {
|
if (mnum.containsKey(list.get(i).getStcd()) == true) {
|
} else {
|
mnum.put(list.get(i).getStcd(), i);
|
listzc.add(list.get(i));
|
}
|
}
|
}
|
Map map = new HashMap();
|
map.put("yj", listyj);
|
map.put("zc", listzc);
|
List lists = new ArrayList();
|
lists.add(map);
|
return R.data(lists);
|
}
|
|
public static Date beforeHourToNowDate(String date, int hours) {
|
Calendar c = Calendar.getInstance();
|
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
try {
|
c.setTime(sdf.parse(date));
|
//c.set(Calendar.HOUR_OF_DAY, c.get(Calendar.HOUR_OF_DAY) - hours);
|
c.set(Calendar.DATE, c.get(Calendar.DATE) - hours);
|
} catch (Exception e) {
|
e.printStackTrace();
|
}
|
return c.getTime();
|
}
|
|
@GetMapping("/ss")
|
public void ss() {
|
String s = iBigriverService.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);
|
System.out.println(code);
|
}
|
|
/**
|
* 大江大河预报库读取
|
*
|
* @return
|
*/
|
@GetMapping("/selectYbs")
|
public R selectYbs(String time) throws ParseException {
|
//预警数据
|
List listyj = new ArrayList();
|
//无预警数据
|
List listzc = new ArrayList();
|
Map mnum = new HashMap();
|
String s = iBigriverService.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);
|
List<Map<String, Object>> listz = new ArrayList<Map<String, Object>>();
|
List<BigriverVO> list = iBigriverService.selectYb(time, code);
|
for (int i = 0; i < list.size(); i++) {
|
Map<String, Object> map = new HashMap<String, Object>();
|
String stcd = list.get(i).getStcd();
|
String ftime = list.get(i).getFtime();
|
String substring = ftime.substring(0, 13);
|
String times = substring + ":00:00";
|
String endTime = times;
|
Date dates = beforeHourToNowDate(time, 1);
|
DateFormat sdfc = new SimpleDateFormat("yyyy-MM-dd 08:00:00");
|
String beginTime = sdfc.format(dates);
|
map.put("beginTime", beginTime);
|
map.put("endTime", endTime);
|
map.put("stcd", stcd);
|
map.put("times", times);
|
listz.add(map);
|
}
|
List<Map<String, Object>> list1 = iBigriverService.selectStation(listz);
|
for (int i = 0; i < list.size(); i++) {
|
for (int c = 0; c < list1.size(); c++) {
|
String stcd = list.get(i).getStcd();
|
String stcdz = list1.get(i).get("STCD").toString();
|
if (stcd == stcdz) {
|
list.get(i).setFbsw(list1.get(c).get("fbsw").toString());
|
list.get(i).setFbll(list1.get(c).get("fbll").toString());
|
list.get(i).setQzll(list1.get(c).get("qzll").toString());
|
list.get(i).setQztime(list1.get(c).get("qztime").toString());
|
list.get(i).setQzsw(list1.get(c).get("qzsw").toString());
|
} else {
|
continue;
|
}
|
|
}
|
}
|
for (int i = 0; i < list.size(); i++) {
|
String yjsw = list.get(i).getYjsw();
|
Double yjz = Double.parseDouble(yjsw);
|
BigDecimal ybsws = list.get(i).getYbsw();
|
Double ybsw = ybsws.doubleValue();
|
if (ybsw > yjz) {
|
if (mnum.containsKey(list.get(i).getStcd()) == true) {
|
} else {
|
mnum.put(list.get(i).getStcd(), i);
|
listyj.add(list.get(i));
|
}
|
} else {
|
if (mnum.containsKey(list.get(i).getStcd()) == true) {
|
} else {
|
mnum.put(list.get(i).getStcd(), i);
|
listzc.add(list.get(i));
|
}
|
}
|
}
|
Map map = new HashMap();
|
map.put("yj", listyj);
|
map.put("zc", listzc);
|
List lists = new ArrayList();
|
lists.add(map);
|
return R.data(lists);
|
}
|
|
}
|
