CalculationUtil.java 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459
  1. package com.jiayue.biz.util;
  2. import cn.hutool.core.convert.Convert;
  3. import com.jiayue.biz.domain.*;
  4. import com.jiayue.biz.eunms.WindDirectionEnum;
  5. import com.jiayue.common.utils.DateUtil;
  6. import lombok.extern.slf4j.Slf4j;
  7. import org.apache.commons.lang3.time.DateUtils;
  8. import java.math.BigDecimal;
  9. import java.math.BigInteger;
  10. import java.math.RoundingMode;
  11. import java.text.SimpleDateFormat;
  12. import java.util.*;
  13. import java.util.stream.Collectors;
  14. @Slf4j
  15. public class CalculationUtil {
  16. /**
  17. * 根据设备属性风向获取数据
  18. *
  19. * @param filterList 过滤出的风数据
  20. * @param height 属性名(层高)
  21. * @return
  22. */
  23. public static List<Map<String, Object>> getForHeightAndWindDirectionEnum(List<Map<String, Object>> filterList, String height, WindDirectionEnum windDirectionEnum) {
  24. List<Map<String, Object>> collect = new ArrayList<>();
  25. if (windDirectionEnum.name().equals("N")) {
  26. // N的范围为 348.75<wd<360 + 0<wd<11.25
  27. filterList.stream().filter(w -> w.get("wd_ave" + height) != null && (getBigDecimal(w.get("wd_ave" + height)).compareTo(windDirectionEnum.getLower()) >= 0 && getBigDecimal(w.get("wd_ave" + height)).compareTo(new BigDecimal(360)) <= 0) || (getBigDecimal(w.get("wd_ave" + height)).compareTo(windDirectionEnum.getUpper()) < 0 && getBigDecimal(w.get("wd_ave" + height)).compareTo(new BigDecimal(0)) > 0)).collect(Collectors.toList());
  28. } else {
  29. collect = filterList.stream().filter(w -> w.get("wd_ave" + height) != null && getBigDecimal(w.get("wd_ave" + height)).compareTo(windDirectionEnum.getLower()) >= 0 && getBigDecimal(w.get("wd_ave" + height)).compareTo(windDirectionEnum.getUpper()) < 0).collect(Collectors.toList());
  30. }
  31. return collect;
  32. }
  33. /**
  34. * 根据设备属性风向获取数据 Todo 新数据库格式
  35. *
  36. * @param List 过滤出的风数据
  37. * @return
  38. */
  39. public static List<ProphaseAnemometryData> getForHeightAndWindDirectionEnum(List<ProphaseAnemometryData> List, WindDirectionEnum windEnum) {
  40. List<ProphaseAnemometryData> collect = new ArrayList<>();
  41. if (windEnum.name().equals("N")) {
  42. // N的范围为 348.75<wd<360 + 0<wd<11.25
  43. collect = List.stream().filter(e -> e.getWdAve() != null).filter(w -> (getBigDecimal(w.getWdAve()).compareTo(windEnum.getLower()) >= 0 && getBigDecimal(w.getWdAve()).compareTo(new BigDecimal(360)) <= 0) || (getBigDecimal(w.getWdAve()).compareTo(windEnum.getUpper()) < 0 && getBigDecimal(w.getWdAve()).compareTo(new BigDecimal(0)) > 0)).collect(Collectors.toList());
  44. } else {
  45. collect = List.stream().filter(w -> w.getWdAve() != null && getBigDecimal(w.getWdAve()).compareTo(windEnum.getLower()) >= 0 && getBigDecimal(w.getWdAve()).compareTo(windEnum.getUpper()) < 0).collect(Collectors.toList());
  46. }
  47. return collect;
  48. }
  49. /**
  50. * 根据层高获取风速数据 todo 旧
  51. *
  52. * @param filterList 过滤出的风数据
  53. * @param fieldName 属性名(层高)
  54. * @return
  55. */
  56. public static List<BigDecimal> getWsForHeight(List<ProphaseAnemometryData> filterList, String fieldName) {
  57. return filterList.stream().filter(f -> f.getLayerHeight().equals(fieldName)).map(p -> {
  58. return new BigDecimal(p.getWsAve());
  59. }).collect(Collectors.toList());
  60. }
  61. /**
  62. * 计算平均风速
  63. *
  64. * @param bigDecimalList 风速数据
  65. * @return
  66. */
  67. public static BigDecimal getAvgWind(List<BigDecimal> bigDecimalList) {
  68. return new BigDecimal(bigDecimalList.stream().collect(Collectors.averagingDouble(BigDecimal::doubleValue))).setScale(2, RoundingMode.HALF_UP);
  69. }
  70. /**
  71. * 计算风能密度(风功率玫瑰图)
  72. *
  73. * @return 风能密度
  74. */
  75. public static BigDecimal windEnergyDensity(List<ProphaseAnemometryData> anemometryData, Map<String, ProphaseWeatherData> prophaseWeatherDataMap) {
  76. BigDecimal density = new BigDecimal(-99);
  77. try {
  78. if (anemometryData.size() != 0) {
  79. BigDecimal wpdSum = new BigDecimal(0);
  80. for (ProphaseAnemometryData anemometryDatum : anemometryData) {
  81. ProphaseWeatherData prophaseWeatherData = prophaseWeatherDataMap.get(anemometryDatum.getTs().getTime() + "");
  82. if (null != prophaseWeatherData) {
  83. wpdSum = wpdSum.add(getWpdCalculate(getBigDecimal(prophaseWeatherData.getAirDensity()), getBigDecimal(anemometryDatum.getWsAve())));
  84. }
  85. }
  86. density = wpdSum.divide(BigDecimal.valueOf(anemometryData.size()), 2, RoundingMode.HALF_UP);
  87. }
  88. } catch (Exception e) {
  89. log.error("计算风风能密度时发生错误:{}", e);
  90. } finally {
  91. return density;
  92. }
  93. }
  94. //计算风功率密度公式
  95. public static BigDecimal getWpdCalculate(BigDecimal airAve, BigDecimal wsAve) {
  96. return airAve.multiply(power(getBigDecimal(wsAve), 3)).multiply(BigDecimal.valueOf(0.5));
  97. }
  98. /**
  99. * @param x 参数
  100. * @param total 指数
  101. * @return x的total次方
  102. */
  103. public static BigDecimal power(BigDecimal x, Integer total) {
  104. BigDecimal power = x;
  105. for (int i = 1; i < total; i++) {
  106. power = power.multiply(x);
  107. }
  108. return power;
  109. }
  110. /**
  111. * 从 String 中提取数字
  112. *
  113. * @param string
  114. * @return
  115. */
  116. public static String getNumberFromString(String string) {
  117. String str = string;
  118. str = str.trim();
  119. StringBuffer str2 = new StringBuffer();
  120. if (str != null && !"".equals(str)) {
  121. for (int i = 0; i < str.length(); i++) {
  122. if (str.charAt(i) >= 48 && str.charAt(i) <= 57) {
  123. String s = String.valueOf(str.charAt(i));
  124. str2.append(s);
  125. }
  126. }
  127. }
  128. return str2.toString();
  129. }
  130. //获取字符串中数字 附带小数点
  131. public static String getNumberFromStringForDian(String string) {
  132. String str = string;
  133. str = str.trim();
  134. StringBuffer str2 = new StringBuffer();
  135. if (str != null && !"".equals(str)) {
  136. for (int i = 0; i < str.length(); i++) {
  137. if ((str.charAt(i) >= 48 && str.charAt(i) <= 57) || str.charAt(i) == 46) {
  138. String s = String.valueOf(str.charAt(i));
  139. str2.append(s);
  140. }
  141. }
  142. }
  143. return str2.toString();
  144. }
  145. /**
  146. * 计算风切变指数
  147. *
  148. * @param v2 高度 Z2 的风速
  149. * @param v1 高度 Z1 的风速
  150. * @param z2 高度
  151. * @param z1 高度
  152. * @return 风切变指数
  153. */
  154. public static BigDecimal caWindShear(BigDecimal v2, BigDecimal v1, BigDecimal z2, BigDecimal z1) {
  155. v2 = v2.setScale(4, BigDecimal.ROUND_HALF_UP);
  156. z2 = z2.setScale(4, BigDecimal.ROUND_HALF_UP);
  157. BigDecimal result = new BigDecimal(-99);
  158. try {
  159. double v = v2.divide(v1, 2, BigDecimal.ROUND_HALF_UP).doubleValue();
  160. double v3 = 0;
  161. if (v != 0) {
  162. v3 = Math.log10(v);
  163. }
  164. double z = z2.divide(z1, 2, BigDecimal.ROUND_HALF_UP).doubleValue();
  165. double z3 = 0;
  166. if (z != 0) {
  167. z3 = Math.log10(z);
  168. }
  169. if (z3 != 0) {
  170. result = new BigDecimal(v3).divide(new BigDecimal(z3), 2, BigDecimal.ROUND_HALF_UP);
  171. }
  172. } catch (Exception e) {
  173. e.printStackTrace();
  174. } finally {
  175. return result;
  176. }
  177. }
  178. /**
  179. * 计算湍流强度
  180. *
  181. * @param wsSta 风速标准差
  182. * @param ws 风速
  183. * @return 湍流强度
  184. */
  185. public static BigDecimal caTurbulenceIntensity(BigDecimal wsSta, BigDecimal ws) {
  186. BigDecimal result = new BigDecimal(-99);
  187. try {
  188. if (ws.compareTo(new BigDecimal(0)) > 0) {
  189. result = wsSta.divide(ws, 2, BigDecimal.ROUND_HALF_UP);
  190. }
  191. } catch (Exception e) {
  192. e.printStackTrace();
  193. } finally {
  194. return result;
  195. }
  196. }
  197. /**
  198. * 封装逐小时数据集合
  199. *
  200. * @param awsList 数据
  201. * @return
  202. */
  203. public static List<BigDecimal> getData24(List<WindTowerCalculationData> awsList) {
  204. Long hour = 3600000L;
  205. Date systemDate = new Date();
  206. List<BigDecimal> results = new ArrayList<>();
  207. SimpleDateFormat simpleDateFormat = new SimpleDateFormat("HH");
  208. //获取昨日开始和结束时间
  209. Long startTime = DateMomentUtil.getDayStartTime(DateUtils.addDays(systemDate, -1).getTime());
  210. Long endTime = startTime + 86399000;
  211. for (Long time = startTime; time <= endTime; time += hour) {
  212. Long finalTime = time;
  213. String format = simpleDateFormat.format(finalTime);
  214. List<BigDecimal> collect = awsList.stream().filter(s -> simpleDateFormat.format(s.getTime())
  215. .equals(format) && s.getValue().compareTo(new BigDecimal(-99)) != 0)
  216. .map(WindTowerCalculationData::getValue).collect(Collectors.toList());
  217. BigDecimal avg = BigDecimal.ZERO;
  218. if (collect.size() > 0) {
  219. avg = collect.stream().reduce(BigDecimal.ZERO, BigDecimal::add).divide(BigDecimal.valueOf(collect.size()), 4, RoundingMode.HALF_UP);
  220. }
  221. results.add(avg);
  222. }
  223. return results;
  224. }
  225. /**
  226. * Object转BigDecimal类型
  227. *
  228. * @param value 要转的object类型
  229. * @return 转成的BigDecimal类型数据
  230. */
  231. public static BigDecimal getBigDecimal(Object value) {
  232. BigDecimal ret = null;
  233. if (value != null) {
  234. if (value instanceof BigDecimal) {
  235. ret = (BigDecimal) value;
  236. } else if (value instanceof String) {
  237. ret = new BigDecimal((String) value);
  238. } else if (value instanceof BigInteger) {
  239. ret = new BigDecimal((BigInteger) value);
  240. } else if (value instanceof Number) {
  241. ret = BigDecimal.valueOf(((Number) value).doubleValue());
  242. } else {
  243. throw new ClassCastException("不能将数据 [" + value + "] 从 " + value.getClass() + "类型转为BigDecimal类型.");
  244. }
  245. }
  246. return ret;
  247. }
  248. /**
  249. * 机型:WH6.25N-182
  250. *
  251. * @param ws 风速
  252. * @return 拟合功率 BigDecimal
  253. */
  254. public static BigDecimal getBattery(BigDecimal ws) {
  255. BigDecimal battery = new BigDecimal(0);
  256. if (ws.compareTo(BigDecimal.valueOf(3)) > 0 && ws.compareTo(BigDecimal.valueOf(12.5)) < 0) {
  257. //拟合功率 = (-9.066 * e^-5 * ws^8)+ (0.01055 * ws^7) - (0.5109 * ws^6) + (13.29 * ws^5) - (200.3 * ws^4) + (1755 * ws^3) - (8549 * ws^2) + (2.152 * e^4 * ws) - (2.153 * e^4)
  258. battery = (BigDecimal.valueOf(-9.006).multiply(BigDecimal.valueOf(Math.pow(10, -5)).multiply(CalculationUtil.power(ws, 8)))
  259. .add(BigDecimal.valueOf(0.01055).multiply(CalculationUtil.power(ws, 7)))
  260. .subtract(BigDecimal.valueOf(0.5109).multiply(CalculationUtil.power(ws, 6)))
  261. .add(BigDecimal.valueOf(13.29).multiply(CalculationUtil.power(ws, 5)))
  262. .subtract(BigDecimal.valueOf(200.3).multiply(CalculationUtil.power(ws, 4)))
  263. .add(BigDecimal.valueOf(1755).multiply(CalculationUtil.power(ws, 3)))
  264. .subtract(BigDecimal.valueOf(8549).multiply(CalculationUtil.power(ws, 2)))
  265. .add(BigDecimal.valueOf(2.152).multiply(BigDecimal.valueOf(Math.pow(10, 4)).multiply(ws)))
  266. .subtract(BigDecimal.valueOf(2.153).multiply(BigDecimal.valueOf(Math.pow(10, 4)))))
  267. .setScale(4, RoundingMode.HALF_UP);
  268. } else if (ws.compareTo(BigDecimal.valueOf(12)) >= 0) {
  269. battery = BigDecimal.valueOf(6250);
  270. }
  271. //单个风速功率
  272. return battery;
  273. }
  274. /**
  275. * 机型:WH6.25N-182
  276. *
  277. * @param ws 风速
  278. * @return 拟合功率 BigDecimal
  279. */
  280. public static BigDecimal getBatteryDome(BigDecimal ws) {
  281. BigDecimal battery = new BigDecimal(0);
  282. if (ws.compareTo(BigDecimal.valueOf(3)) > 0 && ws.compareTo(BigDecimal.valueOf(12)) < 0) {
  283. //拟合功率 = (-9.066 * e^-5 * ws^8)+ (0.01055 * ws^7) - (0.5109 * ws^6) + (13.29 * ws^5) - (200.3 * ws^4) + (1755 * ws^3) - (8549 * ws^2) + (2.152 * e^4 * ws) - (2.153 * e^4)
  284. battery = BigDecimal.valueOf(0.7593).multiply(CalculationUtil.power(ws, 5))
  285. .subtract(BigDecimal.valueOf(29.67).multiply(CalculationUtil.power(ws, 4)))
  286. .add(BigDecimal.valueOf(421).multiply(CalculationUtil.power(ws, 3)))
  287. .subtract(BigDecimal.valueOf(2646).multiply(CalculationUtil.power(ws, 2)))
  288. .add(BigDecimal.valueOf(7918).multiply(ws))
  289. .subtract(BigDecimal.valueOf(8948));
  290. } else if (ws.compareTo(BigDecimal.valueOf(12)) >= 0 && ws.compareTo(BigDecimal.valueOf(18)) <= 0) {
  291. battery = BigDecimal.valueOf(6250);
  292. }
  293. //单个风速功率
  294. return battery;
  295. }
  296. /**
  297. * 计算威布尔值
  298. *
  299. * @param e e
  300. * @param d 风速
  301. * @param K K
  302. * @param A A
  303. * @return weibull
  304. */
  305. public static BigDecimal getBigDecimal(double e, double d, double K, double A) {
  306. BigDecimal value = BigDecimal.ZERO;
  307. //e的-(U/K)次方的K次方
  308. if (A != 0.0 && K != 0.0) {
  309. // U/A
  310. BigDecimal UAK1 = BigDecimal.valueOf(d).divide(BigDecimal.valueOf(A), 4, RoundingMode.HALF_UP);
  311. double UAK2 = UAK1.doubleValue();
  312. //U/A 的k次方
  313. double UAK = Math.pow(UAK2, K);
  314. //e的负 UAK次方
  315. double EUAK = Math.pow(e, -UAK);
  316. //K/A
  317. BigDecimal KA = BigDecimal.valueOf(K).divide(BigDecimal.valueOf(A), 4, RoundingMode.HALF_UP);
  318. BigDecimal UA1 = BigDecimal.valueOf(d).divide(BigDecimal.valueOf(A), 4, RoundingMode.HALF_UP);
  319. double v = UA1.doubleValue();
  320. double pow = Math.pow(v, (K - 1));
  321. BigDecimal pow1 = BigDecimal.valueOf(pow).multiply(BigDecimal.valueOf(EUAK));
  322. value = pow1.multiply(KA).setScale(4, BigDecimal.ROUND_HALF_UP);
  323. }
  324. return value;
  325. }
  326. /**
  327. * 计算综合风切变
  328. */
  329. public static BigDecimal getWindShear(List<ProphaseAnemometryData> prophaseAnemometryData, String[] heights) {
  330. BigDecimal sumWShear = BigDecimal.ZERO;
  331. BigDecimal total = BigDecimal.ZERO;
  332. for (String maxHeight : heights) {
  333. if (maxHeight.contains("A")) {
  334. continue;
  335. }
  336. BigDecimal wsAveForMax = new BigDecimal(prophaseAnemometryData.stream().filter(p -> p.getLayerHeight().equals(maxHeight)).map(p -> {
  337. return getBigDecimal(p.getWsAve());
  338. }).collect(Collectors.averagingDouble(BigDecimal::doubleValue))).setScale(8, RoundingMode.HALF_UP);
  339. //筛选低层高
  340. List<String> heightList = new ArrayList<>(Arrays.asList(heights)).stream()
  341. .filter(s -> Integer.valueOf(CalculationUtil.getNumberFromString(maxHeight)) > Integer.valueOf(CalculationUtil.getNumberFromString(s))).collect(Collectors.toList());
  342. //计算风切变
  343. for (String minHeight : heightList) {
  344. if (minHeight.contains("A")) {
  345. continue;
  346. }
  347. //计算平均风速
  348. BigDecimal wsAveMin = new BigDecimal(prophaseAnemometryData.stream().filter(p -> p.getLayerHeight().equals(minHeight)).map(p -> {
  349. return getBigDecimal(p.getWsAve());
  350. }).collect(Collectors.averagingDouble(BigDecimal::doubleValue))).setScale(8, RoundingMode.HALF_UP);
  351. double z = new BigDecimal(getNumberFromString(maxHeight)).divide(new BigDecimal(getNumberFromString(minHeight)), 8, RoundingMode.HALF_UP).doubleValue();
  352. //计算log 层高
  353. double z1 = Math.log10(z);
  354. if (wsAveForMax.compareTo(BigDecimal.ZERO) > 0 && wsAveMin.compareTo(BigDecimal.ZERO) > 0 && z1 != 0) {
  355. BigDecimal shear = Convert.toBigDecimal(Math.log10(Convert.toDouble(wsAveForMax.divide(wsAveMin, 8, RoundingMode.HALF_UP))))
  356. .divide(BigDecimal.valueOf(z1), 8, RoundingMode.HALF_UP);
  357. sumWShear = sumWShear.add(shear);
  358. total = total.add(BigDecimal.ONE);
  359. }
  360. }
  361. }
  362. if (total.compareTo(BigDecimal.ZERO) != 0) {
  363. sumWShear = sumWShear.divide(total, 4, RoundingMode.HALF_UP);
  364. }
  365. return sumWShear;
  366. }
  367. //测风塔mysql与mongo转换
  368. public static List<Equipment> getEquipment(List<WindTowerInfo> windTowerInfoList, String equipmentStr) {
  369. List<Equipment> equipmentList = new ArrayList<>();
  370. String[] equipmentArr = equipmentStr.split(",");
  371. for (String equipmentName : equipmentArr) {
  372. List<WindTowerInfo> collect = windTowerInfoList.stream().filter(w -> w.getName().equals(equipmentName) || w.getEquipmentNo().equals(CalculationUtil.getNumberFromString(equipmentName))).collect(Collectors.toList());
  373. if (collect.size() > 0) {
  374. WindTowerInfo windTowerInfo = collect.get(0);
  375. Equipment equipment = new Equipment();
  376. equipment.setEquipmentNo(windTowerInfo.getEquipmentNo());
  377. equipment.setId(windTowerInfo.getId());
  378. equipment.setLatitude(windTowerInfo.getLatitude().toString());
  379. equipment.setLongitude(windTowerInfo.getLongitude().toString());
  380. equipment.setAltitude(windTowerInfo.getAltitude());
  381. equipment.setHeights(windTowerInfo.getHeights());
  382. equipment.setDisplayHeight(windTowerInfo.getDisplayHeight());
  383. equipment.setInstallationTime(windTowerInfo.getInstallationTime() != null ? DateUtil.format(windTowerInfo.getInstallationTime(), "yyyy-MM-dd") : "");
  384. equipment.setManufacturer(windTowerInfo.getManufacturer());
  385. equipment.setModelNumber(windTowerInfo.getModelNumber());
  386. equipment.setWdHeights(windTowerInfo.getWdHeights());
  387. equipment.setType(windTowerInfo.getType());
  388. equipment.setStatus(windTowerInfo.getStatus());
  389. equipment.setPassword(windTowerInfo.getPassword());
  390. equipment.setName(windTowerInfo.getName());
  391. equipment.setRecorderNo(windTowerInfo.getRecorderNo());
  392. equipment.setTerrainComplexity(windTowerInfo.getTerrainComplexity());
  393. equipmentList.add(equipment);
  394. }
  395. }
  396. return equipmentList;
  397. }
  398. }