/**
 * 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 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.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.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.security.MessageDigest;
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");
		wb.write(out);
		out.close();
	}

	/***
	 * MD5加码 生成32位md5码
	 */
	public static String string2MD5(String inStr) {
		MessageDigest md5 = null;
		try {
			md5 = MessageDigest.getInstance("MD5");
		} catch (Exception e) {
			System.out.println(e.toString());
			e.printStackTrace();
			return "";
		}
		char[] charArray = inStr.toCharArray();
		byte[] byteArray = new byte[charArray.length];

		for (int i = 0; i < charArray.length; i++)
			byteArray[i] = (byte) charArray[i];
		byte[] md5Bytes = md5.digest(byteArray);
		StringBuffer hexValue = new StringBuffer();
		for (int i = 0; i < md5Bytes.length; i++) {
			int val = ((int) md5Bytes[i]) & 0xff;
			if (val < 16)
				hexValue.append("0");
			hexValue.append(Integer.toHexString(val));
		}
		return hexValue.toString();

	}


}