PowerCurveFittingService.java 60 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273
  1. package com.gyee.generation.service;
  2. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
  3. import com.gyee.common.contant.ContantXk;
  4. import com.gyee.common.model.PointData;
  5. import com.gyee.generation.init.CacheContext;
  6. import com.gyee.generation.model.auto.*;
  7. import com.gyee.generation.model.vo.CureFittingVo;
  8. import com.gyee.generation.model.vo.PointVo;
  9. import com.gyee.generation.model.vo.PointfVo;
  10. import com.gyee.generation.service.auto.*;
  11. import com.gyee.generation.util.DateUtils;
  12. import com.gyee.generation.util.realtimesource.math.LineUtil;
  13. import com.gyee.generation.util.StringUtils;
  14. import com.gyee.generation.util.realtimesource.IEdosUtil;
  15. import org.slf4j.Logger;
  16. import org.slf4j.LoggerFactory;
  17. import org.springframework.beans.factory.annotation.Value;
  18. import org.springframework.stereotype.Service;
  19. import javax.annotation.Resource;
  20. import java.util.*;
  21. import java.util.stream.Collectors;
  22. @Service
  23. public class PowerCurveFittingService {
  24. private static final Logger logger = LoggerFactory.getLogger(PowerCurveFittingService.class);
  25. @Resource
  26. private IEdosUtil edosUtil;
  27. @Value("${curvefitting.dimension}")
  28. private Integer dimension;
  29. @Value("${curvefitting.scale}")
  30. private Double scale;
  31. @Value("${initialcode}")
  32. private String initialcode;
  33. public Map<String, Double> windturbineCapacity;
  34. @Resource
  35. private IProEconWtCurveFittingMonthService proEconWtCurveFittingMonthService;
  36. @Resource
  37. private IProEconWtCurveFittingYearService proEconWtCurveFittingYearService;
  38. @Resource
  39. private IProEconWtCurveFittingService proEconWtCurveFittingService;
  40. @Resource
  41. private IProEconCurveFittingMainService proEconCurveFittingMainService;
  42. @Resource
  43. private IProEconCurveFittingSubService proEconCurveFittingSubService;
  44. @Resource
  45. private IProEconCurveFittMonthMainService proEconCurveFittMonthMainService;
  46. @Resource
  47. private IProEconCurveFittMonthSubService proEconCurveFittMonthSubService;
  48. @Resource
  49. private IProEconWtPowerCurveFittingService proEconWtPowerCurveFittingService;
  50. @Resource
  51. private IProEconCurveFittYearSubService proEconCurveFittYearSubService;
  52. @Resource
  53. private IProEconCurveFittYearMainService proEconCurveFittYearMainService;
  54. //inserttype 0表示正常拟合工作,1表示存值到windturbinePowerCurveFitting表
  55. public void cureFitting(Date nowDate, Date begion, int insertType, List<ProBasicEquipment> wtls) throws Exception {
  56. //日期变为昨天
  57. Date current = DateUtils.addDays(DateUtils.truncDay(nowDate), -1);
  58. Calendar c = Calendar.getInstance();
  59. c.setTime(current);
  60. int year = c.get(Calendar.YEAR);
  61. int month = c.get(Calendar.MONTH) + 1;
  62. c.set(Calendar.DAY_OF_MONTH, 1);
  63. Date begin1 = c.getTime();
  64. c.set(Calendar.MONTH, 0);
  65. Date begin3 = c.getTime();
  66. Date begin2 = DateUtils.addDays(current, -6);
  67. Date end = DateUtils.truncDay(nowDate);
  68. if (begion.getTime() != new Date(0).getTime() && begion.getTime() != new Date(Long.MAX_VALUE).getTime()) {
  69. begin1 = begion;
  70. }
  71. int dimension = this.dimension;
  72. double scale = this.scale;
  73. //上个月
  74. c.setTime(DateUtils.addMonths(begin1, -1));
  75. int year2 = c.get(Calendar.YEAR);
  76. int month2 = c.get(Calendar.MONTH) + 1;
  77. //去年同期
  78. c.setTime(DateUtils.addYears(begin1, -1));
  79. int year3 = c.get(Calendar.YEAR);
  80. int month3 = c.get(Calendar.MONTH) + 1;
  81. Map<String, CureFittingVo> windMap = new HashMap<>();
  82. //初始化风机装机容量
  83. if (windturbineCapacity == null) {
  84. windturbineCapacity = new HashMap<>();
  85. Map<String, ProEconEquipmentmodel> modelMap = CacheContext.modelMap;
  86. for (ProBasicEquipment windturbine : wtls) {
  87. if (modelMap.containsKey(windturbine.getModelId())) {
  88. windturbineCapacity.put(windturbine.getId(), modelMap.get(windturbine.getModelId()).getPowerProduction());
  89. }
  90. }
  91. }
  92. for (ProBasicEquipment wt : wtls) {
  93. String windturbineId = wt.getId();
  94. Map<String, ProBasicEquipmentPoint> windturbinetestingpointnewMap = CacheContext.wtpAimap.get(wt.getId());
  95. //设备有功功率
  96. String pointIdGL = windturbinetestingpointnewMap.get(ContantXk.CJ_SSGL).getNemCode();
  97. //设备明细状态
  98. String pointIdZT = windturbinetestingpointnewMap.get(ContantXk.MXZT).getNemCode();
  99. String pointIdFS;
  100. if (wt.getWindpowerstationId().contains("GDC")) { //测风塔70米风速
  101. if (windturbinetestingpointnewMap.containsKey(ContantXk.FCCFTFS70)) {
  102. ProBasicEquipmentPoint point = windturbinetestingpointnewMap.get(ContantXk.FCCFTFS70);
  103. if (StringUtils.notEmp(point.getNemCode()) && !point.getNemCode().equals(initialcode)) {
  104. pointIdFS = windturbinetestingpointnewMap.get(ContantXk.FCCFTFS70).getNemCode();
  105. } else {
  106. pointIdFS = windturbinetestingpointnewMap.get(ContantXk.CJ_SSFS).getNemCode();
  107. }
  108. } else {
  109. pointIdFS = windturbinetestingpointnewMap.get(ContantXk.CJ_SSFS).getNemCode();
  110. }
  111. } else { //设备风速
  112. pointIdFS = windturbinetestingpointnewMap.get(ContantXk.CJ_SSFS).getNemCode();
  113. }
  114. CureFittingVo item = new CureFittingVo();
  115. item.setPointIdFS(pointIdFS);
  116. item.setPointIdZT(pointIdZT);
  117. item.setPointIdGL(pointIdGL);
  118. //获取标杆风机编号
  119. if (CacheContext.wtstandardmap.containsKey(wt.getId())) {
  120. item.setStandardId(CacheContext.wtstandardmap.get(wt.getId()));
  121. } else {
  122. item.setStandardId(wt.getId());
  123. }
  124. windMap.put(windturbineId, item);
  125. }
  126. for (String key : windMap.keySet()) {
  127. //初始化集合
  128. windMap.get(key).setYsjglPoints(new ArrayList<>());
  129. windMap.get(key).setYzyglPoints(new ArrayList<>());
  130. windMap.get(key).setRsjglPoints(new ArrayList<>());
  131. windMap.get(key).setRzyglPoints(new ArrayList<>());
  132. windMap.get(key).setNsjglPoints(new ArrayList<>());
  133. windMap.get(key).setNzyglPoints(new ArrayList<>());
  134. if (windMap.get(key).getPointIdGL() == null || windMap.get(key).getPointIdFS() == null || windMap.get(key).getPointIdZT() == null) {
  135. logger.info(key);
  136. continue;
  137. }
  138. //拟合月功率曲线
  139. curveFittingBuilder(begin1, end, dimension, scale, windMap.get(key).getPointIdGL(), windMap.get(key).getPointIdFS(), windMap.get(key).getPointIdZT(), windMap.get(key).getYsjglPoints(), windMap.get(key).getYzyglPoints(), key);
  140. List<PointVo> vos= windMap.get(key).getYsjglPoints().stream().filter(it -> it.getX() >= 0 && it.getX() <= 25).sorted(Comparator.comparing(PointVo::getX)).collect(Collectors.toList());
  141. windMap.get(key).setYsjglPoints(vos);
  142. vos=windMap.get(key).getYzyglPoints().stream().filter(it -> it.getX() >= 0 && it.getX() <= 25).sorted(Comparator.comparing(PointVo::getX)).collect(Collectors.toList());
  143. windMap.get(key).setYzyglPoints(vos);
  144. //拟合日功率曲线
  145. curveFittingBuilder(begin2, end, dimension, scale, windMap.get(key).getPointIdGL(), windMap.get(key).getPointIdFS(), windMap.get(key).getPointIdZT(), windMap.get(key).getRsjglPoints(), windMap.get(key).getRzyglPoints(), key);
  146. vos= windMap.get(key).getRsjglPoints().stream().filter(it -> it.getX() >= 0 && it.getX() <= 25).sorted(Comparator.comparing(PointVo::getX)).collect(Collectors.toList());
  147. windMap.get(key).setRsjglPoints(vos);
  148. vos=windMap.get(key).getRzyglPoints().stream().filter(it -> it.getX() >= 0 && it.getX() <= 25).sorted(Comparator.comparing(PointVo::getX)).collect(Collectors.toList());
  149. windMap.get(key).setRzyglPoints(vos);
  150. //拟合年功率曲线
  151. curveFittingBuilder(begin3, end, dimension, scale, windMap.get(key).getPointIdGL(), windMap.get(key).getPointIdFS(), windMap.get(key).getPointIdZT(), windMap.get(key).getNsjglPoints(), windMap.get(key).getNzyglPoints(), key);
  152. vos= windMap.get(key).getNsjglPoints().stream().filter(it -> it.getX() >= 0 && it.getX() <= 25).sorted(Comparator.comparing(PointVo::getX)).collect(Collectors.toList());
  153. windMap.get(key).setNsjglPoints(vos);
  154. vos=windMap.get(key).getNzyglPoints().stream().filter(it -> it.getX() >= 0 && it.getX() <= 25).sorted(Comparator.comparing(PointVo::getX)).collect(Collectors.toList());
  155. windMap.get(key).setNzyglPoints(vos);
  156. }
  157. for (String key : windMap.keySet()) {
  158. Double modelpower = 1500.0;
  159. if (windturbineCapacity.containsKey(key)) {
  160. modelpower = windturbineCapacity.get(key);
  161. }
  162. // //年的上月
  163. List<PointVo> yearLastMonthPoints = new ArrayList<>();
  164. // //年的去年同期
  165. List<PointVo> yearLastYearPoints;
  166. // //年标准功率
  167. List<PointVo> yearStandardPoints = new ArrayList<>();
  168. //月的上月
  169. List<PointVo> monthLastMonthPoints = new ArrayList<>();
  170. //月的去年同期
  171. List<PointVo> monthLastYearPoints = new ArrayList<>();
  172. //月标准功率
  173. List<PointVo> monthStandardPoints = new ArrayList<>();
  174. //日的昨天
  175. List<PointVo> dayLastMonthPoints = new ArrayList<>();
  176. //日的去年同期
  177. List<PointVo> dayLastYearPoints = new ArrayList<>();
  178. //日标准功率
  179. List<PointVo> dayStandardPoints = new ArrayList<>();
  180. //保证功率
  181. List<PointVo> bzglpowerPoints = new ArrayList<>();
  182. if (CacheContext.wtstandardmap.containsKey(key)) {
  183. String standardId = CacheContext.wtstandardmap.get(key);
  184. if (StringUtils.notEmp(standardId)) {
  185. if (windMap.containsKey(key)) {
  186. yearStandardPoints = windMap.get(standardId).getNsjglPoints();
  187. monthStandardPoints = windMap.get(standardId).getYsjglPoints();
  188. dayStandardPoints = windMap.get(standardId).getRsjglPoints();
  189. }
  190. }
  191. }
  192. String stringyear = String.valueOf(year);
  193. String stringmonth = String.valueOf(month);
  194. String stringyear2 = String.valueOf(year2);
  195. String stringmonth2 = String.valueOf(month2);
  196. String stringyear3 = String.valueOf(year3);
  197. String stringmonth3 = String.valueOf(month3);
  198. // /*********************************************年曲线偏差上个月和上一年记录**********************************************************/
  199. List<ProEconWtCurveFittingYear> wcfyls = proEconWtCurveFittingYearService.list().stream().filter(i -> i.getWindturbineId().equals(key) &&
  200. i.getYear().equals(stringyear3)).collect(Collectors.toList());
  201. //与轶总的原始代码对比不一致,新增代码修改测试
  202. yearBuildPoints(wcfyls, yearLastMonthPoints);
  203. yearLastYearPoints = yearLastMonthPoints;
  204. //*********************************************年曲线偏差上个月和上一年记录**********************************************************/
  205. //*********************************************月曲线偏差上个月和上一年记录**********************************************************/
  206. List<ProEconWtCurveFittingMonth> wcfmls = proEconWtCurveFittingMonthService.list().stream().filter(i -> i.getWindturbineId().equals(key) &&
  207. i.getYear().equals(stringyear2) && i.getMonth().equals(stringmonth2)).sorted(Comparator.comparing(ProEconWtCurveFittingMonth::getSpeed)).collect(Collectors.toList());
  208. monthBuildPoints(wcfmls, monthLastMonthPoints);
  209. wcfmls = proEconWtCurveFittingMonthService.list().stream().filter(i -> i.getWindturbineId().equals(key) &&
  210. i.getYear().equals(stringyear3) && i.getMonth().equals(stringmonth3)).collect(Collectors.toList());
  211. wcfmls.sort(Comparator.comparing(ProEconWtCurveFittingMonth::getSpeed));
  212. monthBuildPoints(wcfmls, monthLastYearPoints);
  213. //*********************************************月曲线偏差上个月和上一年记录**********************************************************/
  214. //*********************************************日曲线偏差上个月和上一年记录**********************************************************/
  215. Date d1 = DateUtils.addDays(current, -1);
  216. Date d2 = DateUtils.addYears(current, -1);
  217. List<ProEconWtCurveFitting> wcfls = proEconWtCurveFittingService.list().stream().filter(i -> i.getWindturbineId().equals(key) &&
  218. i.getRecordDate().compareTo(d1) == 0).collect(Collectors.toList());
  219. dayBuildPoints(wcfls, dayLastMonthPoints);
  220. wcfls = proEconWtCurveFittingService.list().stream().filter(i -> i.getWindturbineId().equals(key) &&
  221. i.getRecordDate().compareTo(d2) == 0).collect(Collectors.toList());
  222. //与轶总的原始代码对比不一致,临时修改测试
  223. dayBuildPoints(wcfls, dayLastMonthPoints);
  224. //*********************************************日曲线偏差上个月和上一年记录**********************************************************/
  225. if (CacheContext.wtmap.containsKey(key)) {
  226. String modelid = CacheContext.wtmap.get(key).getModelId();
  227. if (StringUtils.notEmp(modelid)) {
  228. //获取模型功率曲线
  229. if (CacheContext.modelpowermap.containsKey(modelid)) {
  230. for (Double speed : CacheContext.modelpowermap.get(modelid).keySet()) {
  231. PointVo point = new PointVo();
  232. point.setX(speed);
  233. point.setY(CacheContext.modelpowermap.get(modelid).get(speed).getEnsurePower());
  234. bzglpowerPoints.add(point);
  235. }
  236. }
  237. }
  238. }
  239. //*********************************************年曲线偏差记录**********************************************************/
  240. //*********************************************当年曲线偏差记录**********************************************************/
  241. Optional<ProEconCurveFittYearMain> cfmyearo = proEconCurveFittYearMainService.list().stream().filter(i -> i.getWindturbineId().equals(key)
  242. && i.getYear().equals(stringyear)).findFirst();
  243. ProEconCurveFittYearMain cfmyear;
  244. if (cfmyearo.isPresent()) {
  245. cfmyear = cfmyearo.get();
  246. QueryWrapper<ProEconCurveFittMonthMain> wrapper = new QueryWrapper<>();
  247. wrapper.eq("id", cfmyear.getId());
  248. proEconCurveFittMonthMainService.remove(wrapper);
  249. }
  250. cfmyear = new ProEconCurveFittYearMain();
  251. cfmyear.setWindturbineId(key);
  252. cfmyear.setYear(String.valueOf(year));
  253. //年---实际/最优
  254. cfmyear.setDeviationRate1(pcl(windMap.get(key).getNsjglPoints(), windMap.get(key).getNzyglPoints(), modelpower));
  255. //年---实际/保证
  256. cfmyear.setDeviationRate2( pcl(windMap.get(key).getNsjglPoints(), bzglpowerPoints, modelpower));
  257. //年---最优/保证
  258. cfmyear.setDeviationRate3( pcl(windMap.get(key).getNzyglPoints(), bzglpowerPoints, modelpower));
  259. //年---实际/上月实际
  260. cfmyear.setMonthDeviationRate( pcl(windMap.get(key).getNsjglPoints(), yearLastMonthPoints, modelpower));
  261. //年---实际/同期实际
  262. cfmyear.setYearDeviationRate( pcl(windMap.get(key).getNsjglPoints(), yearLastYearPoints, modelpower));
  263. //年---实际/标杆实际
  264. cfmyear.setStandardDeviationRate( pcl(windMap.get(key).getNsjglPoints(), yearStandardPoints, modelpower));
  265. proEconCurveFittYearMainService.save(cfmyear);
  266. //*********************************************当年曲线偏差记录**********************************************************/
  267. //*********************************************当月曲线偏差记录**********************************************************/
  268. Optional<ProEconCurveFittMonthMain> cfmmontho = proEconCurveFittMonthMainService.list().stream().filter(i -> i.getWindturbineId().equals(key)
  269. && i.getYear().equals(stringyear) && i.getMonth().equals(stringmonth)).findFirst();
  270. ProEconCurveFittMonthMain cfmmonth;
  271. if (cfmmontho.isPresent()) {
  272. cfmmonth = cfmmontho.get();
  273. QueryWrapper<ProEconCurveFittMonthMain> wrapper = new QueryWrapper<>();
  274. wrapper.eq("id", cfmmonth.getId());
  275. proEconCurveFittMonthMainService.remove(wrapper);
  276. }
  277. cfmmonth = new ProEconCurveFittMonthMain();
  278. cfmmonth.setWindturbineId(key);
  279. cfmmonth.setYear(String.valueOf(year));
  280. cfmmonth.setMonth(String.valueOf(month));
  281. //月---实际/最优
  282. cfmmonth.setDeviationRate1( pcl(windMap.get(key).getYsjglPoints(), windMap.get(key).getYzyglPoints(), modelpower));
  283. //月---实际/保证
  284. cfmmonth.setDeviationRate2( pcl(windMap.get(key).getYsjglPoints(), bzglpowerPoints, modelpower));
  285. //月---最优/保证
  286. cfmmonth.setDeviationRate3( pcl(windMap.get(key).getYzyglPoints(), bzglpowerPoints, modelpower));
  287. //月---实际/上月实际
  288. cfmmonth.setMonthDeviationRate( pcl(windMap.get(key).getYsjglPoints(), monthLastMonthPoints, modelpower));
  289. //月---实际/同期实际
  290. cfmmonth.setYearDeviationRate( pcl(windMap.get(key).getYsjglPoints(), monthLastYearPoints, modelpower));
  291. //月---实际/标杆实际
  292. cfmmonth.setStandardDeviationRate( pcl(windMap.get(key).getYsjglPoints(), monthStandardPoints, modelpower));
  293. proEconCurveFittMonthMainService.save(cfmmonth);
  294. //*********************************************当月曲线偏差记录**********************************************************/
  295. //*********************************************当日曲线偏差记录**********************************************************/
  296. Optional<ProEconCurveFittingMain> cfmdayo = proEconCurveFittingMainService.list().stream().filter(i -> i.getWindturbineId().equals(key)
  297. && i.getRecordDate().compareTo(current) == 0).findFirst();
  298. ProEconCurveFittingMain cfmday ;
  299. if (cfmdayo.isPresent()) {
  300. cfmday = cfmdayo.get();
  301. QueryWrapper<ProEconCurveFittingMain> wrapper = new QueryWrapper<>();
  302. wrapper.eq("id", cfmday.getId());
  303. proEconCurveFittingMainService.remove(wrapper);
  304. }
  305. cfmday = new ProEconCurveFittingMain();
  306. cfmday.setWindturbineId(key);
  307. cfmday.setRecordDate(current);
  308. //日---实际/最优
  309. cfmday.setDeviationRate1( pcl(windMap.get(key).getYsjglPoints(), windMap.get(key).getYzyglPoints(), modelpower));
  310. //日---实际/保证
  311. cfmday.setDeviationRate2( pcl(windMap.get(key).getRsjglPoints(), bzglpowerPoints, modelpower));
  312. //日---最优/保证
  313. cfmday.setDeviationRate3( pcl(windMap.get(key).getRzyglPoints(), bzglpowerPoints, modelpower));
  314. //日---实际/上日实际
  315. cfmday.setMonthDeviationRate( pcl(windMap.get(key).getRsjglPoints(), dayLastMonthPoints, modelpower));
  316. //日---实际/同期实际
  317. cfmday.setYearDeviationRate( pcl(windMap.get(key).getRsjglPoints(), dayLastYearPoints, modelpower));
  318. //日---实际/标杆实际
  319. cfmday.setStandardDeviationRate( pcl(windMap.get(key).getRsjglPoints(), dayStandardPoints, modelpower));
  320. proEconCurveFittingMainService.save(cfmday);
  321. //*********************************************当日曲线偏差记录**********************************************************/
  322. pLCBuild(key, stringyear, stringmonth, current, windMap, modelpower, 3, bzglpowerPoints, monthLastMonthPoints, monthLastYearPoints, monthStandardPoints, dayLastMonthPoints, dayLastYearPoints, dayStandardPoints, yearLastMonthPoints, yearLastYearPoints, yearStandardPoints);
  323. pLCBuild(key, stringyear, stringmonth, current, windMap, modelpower, 4, bzglpowerPoints, monthLastMonthPoints, monthLastYearPoints, monthStandardPoints, dayLastMonthPoints, dayLastYearPoints, dayStandardPoints, yearLastMonthPoints, yearLastYearPoints, yearStandardPoints);
  324. pLCBuild(key, stringyear, stringmonth, current, windMap, modelpower, 5, bzglpowerPoints, monthLastMonthPoints, monthLastYearPoints, monthStandardPoints, dayLastMonthPoints, dayLastYearPoints, dayStandardPoints, yearLastMonthPoints, yearLastYearPoints, yearStandardPoints);
  325. pLCBuild(key, stringyear, stringmonth, current, windMap, modelpower, 6, bzglpowerPoints, monthLastMonthPoints, monthLastYearPoints, monthStandardPoints, dayLastMonthPoints, dayLastYearPoints, dayStandardPoints, yearLastMonthPoints, yearLastYearPoints, yearStandardPoints);
  326. pLCBuild(key, stringyear, stringmonth, current, windMap, modelpower, 7, bzglpowerPoints, monthLastMonthPoints, monthLastYearPoints, monthStandardPoints, dayLastMonthPoints, dayLastYearPoints, dayStandardPoints, yearLastMonthPoints, yearLastYearPoints, yearStandardPoints);
  327. pLCBuild(key, stringyear, stringmonth, current, windMap, modelpower, 8, bzglpowerPoints, monthLastMonthPoints, monthLastYearPoints, monthStandardPoints, dayLastMonthPoints, dayLastYearPoints, dayStandardPoints, yearLastMonthPoints, yearLastYearPoints, yearStandardPoints);
  328. pLCBuild(key, stringyear, stringmonth, current, windMap, modelpower, 9, bzglpowerPoints, monthLastMonthPoints, monthLastYearPoints, monthStandardPoints, dayLastMonthPoints, dayLastYearPoints, dayStandardPoints, yearLastMonthPoints, yearLastYearPoints, yearStandardPoints);
  329. pLCBuild(key, stringyear, stringmonth, current, windMap, modelpower, 10, bzglpowerPoints, monthLastMonthPoints, monthLastYearPoints, monthStandardPoints, dayLastMonthPoints, dayLastYearPoints, dayStandardPoints, yearLastMonthPoints, yearLastYearPoints, yearStandardPoints);
  330. pLCBuild(key, stringyear, stringmonth, current, windMap, modelpower, 11, bzglpowerPoints, monthLastMonthPoints, monthLastYearPoints, monthStandardPoints, dayLastMonthPoints, dayLastYearPoints, dayStandardPoints, yearLastMonthPoints, yearLastYearPoints, yearStandardPoints);
  331. pLCBuild(key, stringyear, stringmonth, current, windMap, modelpower, 12, bzglpowerPoints, monthLastMonthPoints, monthLastYearPoints, monthStandardPoints, dayLastMonthPoints, dayLastYearPoints, dayStandardPoints, yearLastMonthPoints, yearLastYearPoints, yearStandardPoints);
  332. pLCBuild(key, stringyear, stringmonth, current, windMap, modelpower, 13, bzglpowerPoints, monthLastMonthPoints, monthLastYearPoints, monthStandardPoints, dayLastMonthPoints, dayLastYearPoints, dayStandardPoints, yearLastMonthPoints, yearLastYearPoints, yearStandardPoints);
  333. if (insertType == 0) {
  334. insertPoints(current, stringyear, stringmonth, windMap.get(key).getYsjglPoints(), windMap.get(key).getYzyglPoints(), windMap.get(key).getRsjglPoints(), windMap.get(key).getRzyglPoints(), windMap.get(key).getNsjglPoints(), windMap.get(key).getNzyglPoints(), key);
  335. } else {
  336. insertPoints2(current, stringyear, stringmonth, windMap.get(key).getYsjglPoints(), windMap.get(key).getYzyglPoints(), windMap.get(key).getRsjglPoints(), windMap.get(key).getRzyglPoints(), windMap.get(key).getNsjglPoints(), windMap.get(key).getNzyglPoints(), key);
  337. }
  338. logger.info(key);
  339. //
  340. // logger.info(String.format("{1}:更新sqlserver数据库记录数:{0}", z, new Date()));
  341. }
  342. }
  343. public void pLCBuild(String key, String stringyear, String stringmonth, Date current, Map<String, CureFittingVo> windMap, Double modelpower, double speed,
  344. List<PointVo> bzglpowerPoints, List<PointVo> monthLastMonthPoints, List<PointVo> monthLastYearPoints, List<PointVo> monthStandardPoints,
  345. List<PointVo> dayLastMonthPoints, List<PointVo> dayLastYearPoints, List<PointVo> dayStandardPoints,
  346. List<PointVo> yearLastMonthPoints, List<PointVo> yearLastYearPoints, List<PointVo> yearStandardPoints) {
  347. String speedStr = String.valueOf(speed);
  348. //*********************************************当年曲线偏差子表记录**********************************************************/
  349. Optional<ProEconCurveFittYearSub> cfmsyearo = proEconCurveFittYearSubService.list().stream().filter(i -> i.getWindturbineId().equals(key)
  350. && i.getYear().equals(stringyear) && i.getSpeed().equals(speedStr)).findFirst();
  351. ProEconCurveFittYearSub cfmsyear;
  352. if (cfmsyearo.isPresent()) {
  353. cfmsyear = cfmsyearo.get();
  354. QueryWrapper<ProEconCurveFittYearSub> wrapper = new QueryWrapper<>();
  355. wrapper.eq("id", cfmsyear.getId());
  356. proEconCurveFittYearSubService.remove(wrapper);
  357. }
  358. cfmsyear = new ProEconCurveFittYearSub();
  359. cfmsyear.setWindturbineId(key);
  360. cfmsyear.setYear(stringyear);
  361. cfmsyear.setSpeed(String.valueOf(speed));
  362. proEconCurveFittYearSubService.save(cfmsyear);
  363. //年---实际/最优
  364. cfmsyear.setDeviationRate1( pcl2(windMap.get(key).getYsjglPoints(), windMap.get(key).getYzyglPoints(), modelpower, speed));
  365. //年---实际/保证
  366. cfmsyear.setDeviationRate2( pcl2(windMap.get(key).getYsjglPoints(), bzglpowerPoints, modelpower, speed));
  367. //年---最优/保证
  368. cfmsyear.setDeviationRate3( pcl2(windMap.get(key).getYzyglPoints(), bzglpowerPoints, modelpower, speed));
  369. //年---实际/上月实际
  370. cfmsyear.setMonthDeviationRate( pcl2(windMap.get(key).getYsjglPoints(), yearLastMonthPoints, modelpower, speed));
  371. //年---实际/同期实际
  372. cfmsyear.setYearDeviationRate( pcl2(windMap.get(key).getYsjglPoints(), yearLastYearPoints, modelpower, speed));
  373. //年---实际/标杆实际
  374. cfmsyear.setStandardDeviationRate( pcl2(windMap.get(key).getYsjglPoints(), yearStandardPoints, modelpower, speed));
  375. proEconCurveFittYearSubService.save(cfmsyear);
  376. //*********************************************当年曲线偏差子表记录**********************************************************/
  377. //*********************************************当月曲线偏差子表记录**********************************************************/
  378. Optional<ProEconCurveFittMonthSub> cfmsmontho = proEconCurveFittMonthSubService.list().stream().filter(i -> i.getWindturbineId().equals(key)
  379. && i.getYear().equals(stringyear) && i.getMonth().equals(stringmonth) && i.getSpeed().equals(speedStr)).findFirst();
  380. ProEconCurveFittMonthSub cfmsmonth ;
  381. if (cfmsmontho.isPresent()) {
  382. cfmsmonth = cfmsmontho.get();
  383. QueryWrapper<ProEconCurveFittMonthSub> wrapper = new QueryWrapper<>();
  384. wrapper.eq("id", cfmsmonth.getId());
  385. proEconCurveFittMonthSubService.remove(wrapper);
  386. }
  387. cfmsmonth = new ProEconCurveFittMonthSub();
  388. cfmsmonth.setWindturbineId(key);
  389. cfmsmonth.setYear(stringyear);
  390. cfmsmonth.setMonth(stringmonth);
  391. cfmsmonth.setSpeed(String.valueOf(speed));
  392. proEconCurveFittMonthSubService.save(cfmsmonth);
  393. //月---实际/最优
  394. cfmsmonth.setDeviationRate1( pcl2(windMap.get(key).getYsjglPoints(), windMap.get(key).getYzyglPoints(), modelpower, speed));
  395. //月---实际/保证
  396. cfmsmonth.setDeviationRate2( pcl2(windMap.get(key).getYsjglPoints(), bzglpowerPoints, modelpower, speed));
  397. //月---最优/保证
  398. cfmsmonth.setDeviationRate3( pcl2(windMap.get(key).getYzyglPoints(), bzglpowerPoints, modelpower, speed));
  399. //月---实际/上月实际
  400. cfmsmonth.setMonthDeviationRate( pcl2(windMap.get(key).getYsjglPoints(), monthLastMonthPoints, modelpower, speed));
  401. //月---实际/同期实际
  402. cfmsmonth.setYearDeviationRate( pcl2(windMap.get(key).getYsjglPoints(), monthLastYearPoints, modelpower, speed));
  403. //月---实际/标杆实际
  404. cfmsmonth.setStandardDeviationRate( pcl2(windMap.get(key).getYsjglPoints(), monthStandardPoints, modelpower, speed));
  405. proEconCurveFittMonthSubService.save(cfmsmonth);
  406. //*********************************************当月曲线偏差子表记录**********************************************************/
  407. //*********************************************当日曲线偏差子表记录**********************************************************/
  408. Optional<ProEconCurveFittingSub> cfmso = proEconCurveFittingSubService.list().stream().filter(i -> i.getWindturbineId().equals(key)
  409. && i.getRecordDate().compareTo(current) == 0 && i.getSpeed().equals(speedStr)).findFirst();
  410. ProEconCurveFittingSub cfms ;
  411. if (cfmso.isPresent()) {
  412. cfms = cfmso.get();
  413. QueryWrapper<ProEconCurveFittingSub> wrapper = new QueryWrapper<>();
  414. wrapper.eq("id", cfms.getId());
  415. proEconCurveFittingSubService.remove(wrapper);
  416. }
  417. cfms = new ProEconCurveFittingSub();
  418. cfms.setWindturbineId(key);
  419. cfms.setSpeed(String.valueOf(speed));
  420. cfms.setRecordDate(current);
  421. cfms.setDeviationRate1( pcl2(windMap.get(key).getRsjglPoints(), windMap.get(key).getRzyglPoints(), modelpower, speed));
  422. //日---实际/保证
  423. cfms.setDeviationRate2( pcl2(windMap.get(key).getRsjglPoints(), bzglpowerPoints, modelpower, speed));
  424. //日---最优/保证
  425. cfms.setDeviationRate3( pcl2(windMap.get(key).getRzyglPoints(), bzglpowerPoints, modelpower, speed));
  426. //日---实际/上日实际
  427. cfms.setMonthDeviationRate( pcl2(windMap.get(key).getRsjglPoints(), dayLastMonthPoints, modelpower, speed));
  428. //日---实际/同期实际
  429. cfms.setYearDeviationRate( pcl2(windMap.get(key).getRsjglPoints(), dayLastYearPoints, modelpower, speed));
  430. //日---实际/标杆实际
  431. cfms.setStandardDeviationRate( pcl2(windMap.get(key).getRsjglPoints(), dayStandardPoints, modelpower, speed));
  432. proEconCurveFittingSubService.save(cfms);
  433. //*********************************************当日曲线偏差子表记录**********************************************************/
  434. }
  435. private void insertPoints(Date current, String year, String month, List<PointVo> monthSjglls, List<PointVo> monthZyglls, List<PointVo> daySjglls, List<PointVo> dayZyglls, List<PointVo> yearSjglls, List<PointVo> yearZyglls, String windturbineId) {
  436. //*********************************************当年曲线偏差记录**********************************************************/
  437. List<Integer> wtcfmyearidls = proEconWtCurveFittingYearService.list().stream().filter(i -> i.getWindturbineId().equals(windturbineId) &&
  438. i.getYear().equals(year)).map(ProEconWtCurveFittingYear::getId).collect(Collectors.toList());
  439. for (int i = 0; i < wtcfmyearidls.size(); i++) {
  440. proEconWtCurveFittingYearService.removeByIds(wtcfmyearidls);
  441. }
  442. if (yearSjglls.size() == yearZyglls.size()) {
  443. for (int i = 0; i < yearSjglls.size(); i++) {
  444. ProEconWtCurveFittingYear item = new ProEconWtCurveFittingYear();
  445. item.setWindturbineId(windturbineId);
  446. if (CacheContext.wtmap.containsKey(windturbineId)) {
  447. ProBasicEquipment wt = CacheContext.wtmap.get(windturbineId);
  448. if (wt.getWindpowerstationId().contains("GDC")) {
  449. continue;
  450. // item.SPEED = Double.Truncate(pointsF1[i].X);
  451. } else {
  452. item.setSpeed(yearSjglls.get(i).getX());
  453. }
  454. item.setActualPower(yearSjglls.get(i).getY());
  455. item.setOptimalPower(yearZyglls.get(i).getY());
  456. item.setYear(String.valueOf(year));
  457. proEconWtCurveFittingYearService.save(item);
  458. }
  459. }
  460. } else {
  461. logger.warn(String.format("下标不一致的风机编号:{0},实际功率:{1},最有功率:{2}", windturbineId, yearSjglls.size(), yearZyglls.size()));
  462. for (int i = 0; i < yearSjglls.size(); i++) {
  463. ProEconWtCurveFittingYear item = new ProEconWtCurveFittingYear();
  464. item.setWindturbineId(windturbineId);
  465. if (CacheContext.wtmap.containsKey(windturbineId)) {
  466. ProBasicEquipment wt = CacheContext.wtmap.get(windturbineId);
  467. if (wt.getWindpowerstationId().contains("GDC")) {
  468. continue;
  469. //item.SPEED = Double.Truncate(pointsF1[i].X);
  470. } else {
  471. item.setSpeed(yearSjglls.get(i).getX());
  472. }
  473. item.setActualPower(yearSjglls.get(i).getY());
  474. int finalI = i;
  475. OptionalDouble op = yearZyglls.stream().filter(x -> Objects.equals(x.getX(), yearSjglls.get(finalI).getX())).mapToDouble(PointVo::getY).findFirst();
  476. if (op.isPresent()) {
  477. item.setOptimalPower(op.getAsDouble());
  478. } else {
  479. item.setOptimalPower(0.0);
  480. }
  481. item.setYear(String.valueOf(year));
  482. proEconWtCurveFittingYearService.save(item);
  483. }
  484. }
  485. }
  486. //*********************************************当年曲线偏差记录**********************************************************/
  487. //*********************************************当月曲线偏差记录**********************************************************/
  488. List<Integer> wtcfmmonthidls = proEconWtCurveFittingMonthService.list().stream().filter(i -> i.getWindturbineId().equals(windturbineId) &&
  489. i.getYear().equals(year) && i.getMonth().equals(month)).map(ProEconWtCurveFittingMonth::getId).collect(Collectors.toList());
  490. for (int i = 0; i < wtcfmmonthidls.size(); i++) {
  491. proEconWtCurveFittingMonthService.removeByIds(wtcfmmonthidls);
  492. }
  493. if (monthSjglls.size() == monthZyglls.size()) {
  494. for (int i = 0; i < monthSjglls.size(); i++) {
  495. ProEconWtCurveFittingMonth item = new ProEconWtCurveFittingMonth();
  496. item.setWindturbineId(windturbineId);
  497. if (CacheContext.wtmap.containsKey(windturbineId)) {
  498. ProBasicEquipment wt = CacheContext.wtmap.get(windturbineId);
  499. if (wt.getWindpowerstationId().contains("GDC")) {
  500. continue;
  501. // item.SPEED = Double.Truncate(pointsF1[i].X);
  502. } else {
  503. item.setSpeed(monthSjglls.get(i).getX());
  504. }
  505. item.setActualPower(monthSjglls.get(i).getY());
  506. item.setOptimalPower(monthZyglls.get(i).getY());
  507. item.setYear(String.valueOf(year));
  508. item.setMonth(String.valueOf(month));
  509. proEconWtCurveFittingMonthService.save(item);
  510. }
  511. }
  512. } else {
  513. logger.warn(String.format("下标不一致的风机编号:{0},实际功率:{1},最有功率:{2}", windturbineId, monthSjglls.size(), monthZyglls.size()));
  514. for (int i = 0; i < monthSjglls.size(); i++) {
  515. ProEconWtCurveFittingMonth item = new ProEconWtCurveFittingMonth();
  516. item.setWindturbineId(windturbineId);
  517. if (CacheContext.wtmap.containsKey(windturbineId)) {
  518. ProBasicEquipment wt = CacheContext.wtmap.get(windturbineId);
  519. if (wt.getWindpowerstationId().contains("GDC")) {
  520. continue;
  521. //item.SPEED = Double.Truncate(pointsF1[i].X);
  522. } else {
  523. item.setSpeed(monthSjglls.get(i).getX());
  524. }
  525. item.setActualPower(monthSjglls.get(i).getY());
  526. int finalI = i;
  527. OptionalDouble op = monthZyglls.stream().filter(x -> Objects.equals(x.getX(), monthSjglls.get(finalI).getX())).mapToDouble(PointVo::getY).findFirst();
  528. if (op.isPresent()) {
  529. item.setOptimalPower(op.getAsDouble());
  530. } else {
  531. item.setOptimalPower(0.0);
  532. }
  533. item.setYear(String.valueOf(year));
  534. item.setMonth(String.valueOf(month));
  535. proEconWtCurveFittingMonthService.save(item);
  536. }
  537. }
  538. }
  539. //*********************************************当月曲线偏差记录**********************************************************/
  540. //*********************************************当日曲线偏差记录**********************************************************/
  541. List<Integer> wtcfidls = proEconWtCurveFittingService.list().stream().filter(i -> i.getWindturbineId().equals(windturbineId) &&
  542. i.getRecordDate().compareTo(current) == 0).map(ProEconWtCurveFitting::getId).collect(Collectors.toList());
  543. for (int i = 0; i < wtcfidls.size(); i++) {
  544. proEconWtCurveFittingService.removeByIds(wtcfidls);
  545. }
  546. if (daySjglls.size() == dayZyglls.size()) {
  547. for (int i = 0; i < daySjglls.size(); i++) {
  548. ProEconWtCurveFitting item = new ProEconWtCurveFitting();
  549. item.setWindturbineId(windturbineId);
  550. if (CacheContext.wtmap.containsKey(windturbineId)) {
  551. ProBasicEquipment wt = CacheContext.wtmap.get(windturbineId);
  552. if (wt.getWindpowerstationId().contains("GDC")) {
  553. continue;
  554. // item.SPEED = Double.Truncate(pointsF2[i].X);
  555. } else {
  556. boolean l = String.valueOf(daySjglls.get(i).getX()).contains(".");
  557. if (l) {
  558. continue;
  559. }
  560. item.setSpeed(daySjglls.get(i).getX());
  561. }
  562. item.setActualPower(daySjglls.get(i).getY());
  563. item.setOptimalPower(dayZyglls.get(i).getY());
  564. item.setRecordDate(current);
  565. proEconWtCurveFittingService.save(item);
  566. }
  567. }
  568. } else {
  569. logger.warn(String.format("下标不一致的风机编号:{0},实际功率:{1},最有功率:{2}", windturbineId, daySjglls.size(), dayZyglls.size()));
  570. for (int i = 0; i < daySjglls.size(); i++) {
  571. ProEconWtCurveFitting item = new ProEconWtCurveFitting();
  572. item.setWindturbineId(windturbineId);
  573. if (CacheContext.wtmap.containsKey(windturbineId)) {
  574. ProBasicEquipment wt = CacheContext.wtmap.get(windturbineId);
  575. if (wt.getWindpowerstationId().contains("GDC")) {
  576. continue;
  577. //item.SPEED = Double.Truncate(pointsF2[i].X);
  578. } else {
  579. boolean l = String.valueOf(daySjglls.get(i).getX()).contains(".");
  580. if (l) {
  581. continue;
  582. }
  583. item.setSpeed(daySjglls.get(i).getX());
  584. }
  585. int finalI = i;
  586. OptionalDouble op = dayZyglls.stream().filter(x -> Objects.equals(x.getX(), daySjglls.get(finalI).getX())).mapToDouble(PointVo::getY).findFirst();
  587. if (op.isPresent()) {
  588. item.setOptimalPower(op.getAsDouble());
  589. } else {
  590. item.setOptimalPower(0.0);
  591. }
  592. item.setActualPower(daySjglls.get(i).getY());
  593. item.setRecordDate(current);
  594. proEconWtCurveFittingService.save(item);
  595. }
  596. }
  597. //*********************************************当日曲线偏差记录**********************************************************/
  598. }
  599. }
  600. private void insertPoints2(Date current, String year, String month, List<PointVo> monthSjglls, List<PointVo> monthZyglls, List<PointVo> daySjglls, List<PointVo> dayZyglls, List<PointVo> yearSjglls, List<PointVo> yearZyglls, String windturbineId) {
  601. List<Integer> wtpcfidls = proEconWtPowerCurveFittingService.list().stream().filter(i -> i.getWindturbineId().equals(windturbineId)).map(ProEconWtPowerCurveFitting::getId).collect(Collectors.toList());
  602. for (int i = 0; i < wtpcfidls.size(); i++) {
  603. proEconWtPowerCurveFittingService.removeByIds(wtpcfidls);
  604. }
  605. if (monthSjglls.size() == monthZyglls.size()) {
  606. for (int i = 0; i < monthSjglls.size(); i++) {
  607. ProEconWtPowerCurveFitting item = new ProEconWtPowerCurveFitting();
  608. item.setWindturbineId(windturbineId);
  609. if (CacheContext.wtmap.containsKey(windturbineId)) {
  610. ProBasicEquipment wt = CacheContext.wtmap.get(windturbineId);
  611. if (wt.getWindpowerstationId().contains("GDC")) {
  612. continue;
  613. // item.SPEED = Double.Truncate(pointsF1[i].X);
  614. } else {
  615. boolean l = String.valueOf(monthSjglls.get(i).getX()).contains(".");
  616. if (l) {
  617. continue;
  618. }
  619. item.setSpeed(monthSjglls.get(i).getX());
  620. }
  621. item.setActualPower(monthSjglls.get(i).getY());
  622. item.setOptimalPower(monthZyglls.get(i).getY());
  623. proEconWtPowerCurveFittingService.save(item);
  624. }
  625. }
  626. } else {
  627. logger.warn(String.format("下标不一致的风机编号:{0},实际功率:{1},最有功率:{2}", windturbineId, monthSjglls.size(), monthZyglls.size()));
  628. for (int i = 0; i < monthSjglls.size(); i++) {
  629. ProEconWtPowerCurveFitting item = new ProEconWtPowerCurveFitting();
  630. item.setWindturbineId(windturbineId);
  631. if (CacheContext.wtmap.containsKey(windturbineId)) {
  632. ProBasicEquipment wt = CacheContext.wtmap.get(windturbineId);
  633. if (wt.getWindpowerstationId().contains("GDC")) {
  634. continue;
  635. //item.SPEED = Double.Truncate(pointsF1[i].X);
  636. } else {
  637. boolean l = String.valueOf(monthSjglls.get(i).getX()).contains(".");
  638. if (l) {
  639. continue;
  640. }
  641. item.setSpeed(monthSjglls.get(i).getX());
  642. }
  643. item.setActualPower(monthSjglls.get(i).getY());
  644. int finalI = i;
  645. OptionalDouble op = monthZyglls.stream().filter(x -> Objects.equals(x.getX(), monthSjglls.get(finalI).getX())).mapToDouble(PointVo::getY).findFirst();
  646. if (op.isPresent()) {
  647. item.setOptimalPower(op.getAsDouble());
  648. } else {
  649. item.setOptimalPower(0.0);
  650. }
  651. proEconWtPowerCurveFittingService.save(item);
  652. }
  653. }
  654. }
  655. }
  656. private void yearBuildPoints(List<ProEconWtCurveFittingYear> data, List<PointVo> points) {
  657. if (data != null) {
  658. for (ProEconWtCurveFittingYear datum : data) {
  659. PointVo point = new PointVo();
  660. point.setX(datum.getSpeed());
  661. point.setY(datum.getActualPower());
  662. points.add(point);
  663. }
  664. }
  665. }
  666. private void monthBuildPoints(List<ProEconWtCurveFittingMonth> data, List<PointVo> points) {
  667. if (data != null) {
  668. for (ProEconWtCurveFittingMonth datum : data) {
  669. PointVo point = new PointVo();
  670. point.setX(datum.getSpeed());
  671. point.setY(datum.getActualPower());
  672. points.add(point);
  673. }
  674. }
  675. }
  676. private void dayBuildPoints(List<ProEconWtCurveFitting> data, List<PointVo> points) {
  677. if (data != null) {
  678. for (ProEconWtCurveFitting datum : data) {
  679. PointVo point = new PointVo();
  680. point.setX(datum.getSpeed());
  681. point.setY(datum.getActualPower());
  682. points.add(point);
  683. }
  684. }
  685. }
  686. //曲线偏差率
  687. private double pcl(List<PointVo> points1, List<PointVo> points2, Double modelpower) {
  688. double result = -0;
  689. double pc = 0;
  690. if (points1 != null && points1.size() != 0 && points2 != null && points2.size() != 0) {
  691. double count = 0;
  692. double sum = 0;
  693. double max = modelpower;
  694. for (PointVo point : points1) {
  695. List<PointVo> item = points2.stream().filter(it -> Objects.equals(it.getX(), point.getX())).collect(Collectors.toList());
  696. if (item.size() > 0) {
  697. sum += Math.pow((point.getY() - item.get(0).getY()), 2);
  698. count++;
  699. pc += point.getY() - item.get(0).getY();
  700. }
  701. }
  702. sum = Math.sqrt(sum);
  703. count = Math.sqrt(count);
  704. max = max * count;
  705. if (max != 0) {
  706. result = sum / max * 100;
  707. }
  708. if (pc < 0) {
  709. result = 0 - result;
  710. }
  711. }
  712. return result;
  713. }
  714. //曲线偏差率2
  715. private double pcl2(List<PointVo> points1, List<PointVo> points2, Double modelpower, double speed) {
  716. double minSpeed = speed;
  717. double maxSpeed = minSpeed + 1;
  718. double result = -0;
  719. double pc = 0;
  720. if (points1 != null && points1.size() != 0 && points2 != null && points2.size() != 0) {
  721. double count = 0;
  722. double sum = 0;
  723. double max = modelpower;
  724. for (PointVo point : points1) {
  725. List<PointVo> item = points2.stream().filter(it -> Objects.equals(it.getX(), point.getX())).collect(Collectors.toList());
  726. if (item.size() > 0 && item.get(0).getX() >= minSpeed && item.get(0).getX() < maxSpeed) {
  727. sum += Math.pow((point.getY() - item.get(0).getY()), 2);
  728. count++;
  729. pc += point.getY() - item.get(0).getY();
  730. }
  731. }
  732. sum = Math.sqrt(sum);
  733. count = Math.sqrt(count);
  734. max = max * count;
  735. if (max != 0) {
  736. result = sum / max * 100;
  737. }
  738. if (pc < 0) {
  739. result = 0 - result;
  740. }
  741. }
  742. return result;
  743. }
  744. //todo-sl 添加数据筛选
  745. private boolean filterData(PointData gl, PointData fs, PointData zt, double maxvalue, String windturbineId) throws Exception {
  746. if (StringUtils.notEmp(gl)) {
  747. //判定功率是否超过最大值
  748. if (gl.getPointValueInDouble() > maxvalue) {
  749. return false;
  750. }
  751. }
  752. if (StringUtils.notEmp(fs)) {
  753. //判定功率是否超过最大值
  754. if (gl.getPointValueInDouble() > 25) {
  755. return false;
  756. }
  757. }
  758. //判定状态不为运行的进行过滤
  759. if (zt.getPointValueInDouble() != 2) {
  760. return false;
  761. }
  762. //设置时间为10分钟前,10钟前有停机事件数据进行过滤
  763. Calendar c = Calendar.getInstance();
  764. c.setTimeInMillis(zt.getPointTime());
  765. Date end = c.getTime();
  766. c.add(Calendar.MINUTE, -10);
  767. Date bedin = c.getTime();
  768. List<PointData> points = edosUtil.getHistoryDatasSnap(zt.getEdnaId(), bedin.getTime() / 1000, end.getTime() / 1000);
  769. if (!points.isEmpty()) {
  770. for (PointData p : points) {
  771. if (p.getPointValueInDouble() == 4) {
  772. return false;
  773. }
  774. }
  775. }
  776. //设置时间为10分钟后,运行后10分钟数据进行过滤
  777. c = Calendar.getInstance();
  778. c.setTimeInMillis(zt.getPointTime());
  779. bedin = c.getTime();
  780. c.add(Calendar.MINUTE, 10);
  781. end = c.getTime();
  782. points = edosUtil.getHistoryDatasSnap(zt.getEdnaId(), bedin.getTime() / 1000, end.getTime() / 1000);
  783. if (!points.isEmpty()) {
  784. for (PointData p : points) {
  785. if (p.getPointValueInDouble() != 2) {
  786. return false;
  787. }
  788. }
  789. }
  790. Map<String, Map<String, ProBasicEquipmentPoint>> wtpAimap = CacheContext.wtpAimap;
  791. Map<String, ProBasicEquipmentPoint> wtpointmap = wtpAimap.get(windturbineId);
  792. //与保证功率进行对比,偏差大于25%的进行过滤
  793. List<String> pointid = new ArrayList<>();
  794. pointid.add(wtpointmap.get(ContantXk.BZGL).getNemCode());
  795. List<PointData> value = edosUtil.getHistMatrix(pointid, gl.getPointTime() / 1000);
  796. if (null != value && value.size() > 0) {
  797. double bzgl = value.get(0).getPointValueInDouble();
  798. double sjgl = gl.getPointValueInDouble();
  799. double temp = Math.abs(sjgl - bzgl);
  800. if (temp > sjgl * 0.25) {
  801. return false;
  802. }
  803. }
  804. //欠发状态大于2过滤掉
  805. pointid = new ArrayList<>();
  806. pointid.add(wtpointmap.get(ContantXk.LSQFZT).getNemCode());
  807. value = edosUtil.getHistMatrix(pointid, gl.getPointTime() / 1000);
  808. if (null != value && value.size() > 0) {
  809. double qfzt = value.get(0).getPointValueInDouble();
  810. return !(qfzt > 2);
  811. }
  812. return true;
  813. }
  814. //功率曲线拟合
  815. public void curveFittingBuilder(Date begin, Date end, int dimension, double scale, String pointIdGL, String pointIdFS, String pointIdZT, List<PointVo> sjglPoints, List<PointVo> zyglPoints, String windturbineId) throws Exception {
  816. double maxPower = windturbineCapacity.get(windturbineId) * 1.3;
  817. List<PointfVo> sjglnhpoints = new ArrayList<>();
  818. Map<Double, PointfVo> zyglnhpoints = new HashMap<>();
  819. if (end.after(begin)) {
  820. if (StringUtils.notEmp(pointIdGL) && StringUtils.notEmp(pointIdFS)) {
  821. List<PointData> glpointstemp = edosUtil.getHistoryDatasSnap(pointIdGL, begin.getTime() / 1000, end.getTime() / 1000);
  822. List<PointData> fspointstemp = edosUtil.getHistoryDatasSnap(pointIdFS, begin.getTime() / 1000, end.getTime() / 1000);
  823. List<PointData> ztpointstemp = edosUtil.getHistoryDatasSnap(pointIdZT, begin.getTime() / 1000, end.getTime() / 1000);
  824. List<PointData> glpoints = new ArrayList<>();
  825. List<PointData> fspoints = new ArrayList<>();
  826. List<PointData> ztpoints = new ArrayList<>();
  827. if (!glpointstemp.isEmpty() && !fspointstemp.isEmpty() && !ztpointstemp.isEmpty() && glpointstemp.size() == fspointstemp.size() && fspointstemp.size() == ztpointstemp.size()) {
  828. for (int i = 0; i < glpointstemp.size(); i++) {
  829. if (filterData(glpointstemp.get(i), fspointstemp.get(i), ztpointstemp.get(i), maxPower, windturbineId)) {
  830. glpoints.add(glpointstemp.get(i));
  831. fspoints.add(fspointstemp.get(i));
  832. ztpoints.add(ztpointstemp.get(i));
  833. }
  834. }
  835. }
  836. if (glpoints.size() != fspoints.size() || glpoints.size() != ztpoints.size()) {
  837. for (int i = 0; i < fspoints.size(); i++) {
  838. double x = fspoints.get(i).getPointValueInDouble();
  839. double y = -1;
  840. double z = -1;
  841. int finalI1 = i;
  842. List<PointData> yArray = glpoints.stream().filter(it -> it.getPointTime().compareTo(fspoints.get(finalI1).getPointTime()) == 0).collect(Collectors.toList());
  843. if (yArray.size() > 0) {
  844. y = yArray.get(i).getPointValueInDouble();
  845. }
  846. int finalI = i;
  847. yArray = ztpoints.stream().filter(it -> it.getPointTime().compareTo(fspoints.get(finalI).getPointTime()) == 0).collect(Collectors.toList());
  848. if (yArray.size() > 0) {
  849. z = yArray.get(i).getPointValueInDouble();
  850. }
  851. Double x1 = StringUtils.round(x, 2);
  852. Double y1 = y;
  853. boolean b = true;
  854. if (CacheContext.wtmap.containsKey(windturbineId)) {
  855. ProBasicEquipment wt = CacheContext.wtmap.get(windturbineId);
  856. if (wt.getWindpowerstationId().contains("GDC")) {
  857. b = (x >= 0 && y > 0);
  858. } else {
  859. if (z == 2) {
  860. b = (x >= 0 && x <= 30 && y >= 0 && y <= maxPower);
  861. if (b) {
  862. if (x > 3 && y <= 0) {
  863. b = false;
  864. }
  865. if (x <= 3 && y > 0) {
  866. b = false;
  867. }
  868. }
  869. } else {
  870. b = false;
  871. }
  872. }
  873. }
  874. if (b) {
  875. sjglnhpoints.add(new PointfVo(x1, y1));
  876. if (zyglnhpoints.containsKey(x1)) {
  877. if (zyglnhpoints.get(x1).getY() < y1) {
  878. zyglnhpoints.put(x1, new PointfVo(x1, y1));
  879. }
  880. } else {
  881. zyglnhpoints.put(x1, new PointfVo(x1, y1));
  882. }
  883. }
  884. }
  885. } else {
  886. for (int i = 0; i < fspoints.size(); i++) {
  887. double x = fspoints.get(i).getPointValueInDouble();
  888. double y = glpoints.get(i).getPointValueInDouble();
  889. double z = ztpoints.get(i).getPointValueInDouble();
  890. Double x1 = StringUtils.round(x, 2);
  891. Double y1 = y;
  892. boolean b = true;
  893. if (CacheContext.wtmap.containsKey(windturbineId)) {
  894. ProBasicEquipment wt = CacheContext.wtmap.get(windturbineId);
  895. if (wt.getWindpowerstationId().contains("GDC")) {
  896. b = (x >= 0 && y > 0);
  897. } else {
  898. if (z == 2) {
  899. b = (x >= 0 && x <= 30 && y >= 0 && y <= maxPower);
  900. if (b) {
  901. if (x > 3 && y <= 0) {
  902. b = false;
  903. }
  904. if (x <= 3 && y > 0) {
  905. b = false;
  906. }
  907. }
  908. } else {
  909. b = false;
  910. }
  911. }
  912. }
  913. if (b) {
  914. sjglnhpoints.add(new PointfVo(x1, y1));
  915. if (zyglnhpoints.containsKey(x1)) {
  916. if (zyglnhpoints.get(x1).getY() < y1) {
  917. zyglnhpoints.put(x1, new PointfVo(x1, y1));
  918. }
  919. } else {
  920. zyglnhpoints.put(x1, new PointfVo(x1, y1));
  921. }
  922. }
  923. }
  924. }
  925. sjglnhpoints.add(new PointfVo(0.0, 0.0));
  926. sjglnhpoints = sjglnhpoints.stream().filter(it -> it.getX() >= 3).sorted(Comparator.comparing(PointfVo::getX)).collect(Collectors.toList());
  927. List<PointVo> temp = LineUtil.buildLine(sjglnhpoints.stream().mapToDouble(PointfVo::getX).toArray(), sjglnhpoints.stream().mapToDouble(PointfVo::getY).toArray(), sjglnhpoints.size(), dimension, scale);
  928. sjglPoints.addAll(temp);
  929. if (sjglPoints.size() != 0) {
  930. buildMyPoints(sjglPoints, scale);
  931. }
  932. if (!zyglnhpoints.containsKey(0.0))
  933. zyglnhpoints.put(0.0, new PointfVo(0.0, 0.0));
  934. List<PointfVo> zygltemp = zyglnhpoints.values().stream().filter(it -> it.getX() >= 3).sorted(Comparator.comparing(PointfVo::getX)).collect(Collectors.toList());
  935. if (zygltemp.size() != 0) {
  936. temp = LineUtil.buildLine(zygltemp.stream().mapToDouble(PointfVo::getX).toArray(), zygltemp.stream().mapToDouble(PointfVo::getY).toArray(), zygltemp.size(), dimension, scale);
  937. }
  938. zyglPoints.addAll(temp);
  939. if (zyglPoints.size() != 0) {
  940. buildMyPoints(zyglPoints, scale);
  941. }
  942. }
  943. }
  944. }
  945. private static void buildMyPoints(List<PointVo> sjglPoints, double scale) {
  946. int coefficient = 1;
  947. int dec = 0;
  948. int smax = 25;
  949. if (scale == 0.01) {
  950. coefficient = 100;
  951. dec = 2;
  952. }
  953. if (scale == 0.1) {
  954. coefficient = 10;
  955. dec = 1;
  956. }
  957. smax *= coefficient;
  958. double min =0.0;
  959. double max=0.0;
  960. double maxval =0.0;
  961. if(sjglPoints.stream().min(Comparator.comparing(PointVo::getX)).isPresent())
  962. {
  963. min = sjglPoints.stream().min(Comparator.comparing(PointVo::getX)).get().getX() * coefficient;
  964. }
  965. if(sjglPoints.stream().max(Comparator.comparing(PointVo::getX)).isPresent())
  966. {
  967. max = sjglPoints.stream().max(Comparator.comparing(PointVo::getX)).get().getX() * coefficient;
  968. }
  969. if(sjglPoints.stream().max(Comparator.comparing(PointVo::getY)).isPresent())
  970. {
  971. maxval = sjglPoints.stream().max(Comparator.comparing(PointVo::getY)).get().getY();
  972. }
  973. for (double i = 0; i < min; i += 1) {
  974. PointVo point = new PointVo();
  975. point.setX(StringUtils.round(i / coefficient, dec));
  976. point.setY(0.0);
  977. sjglPoints.add(point);
  978. }
  979. for (double i = smax; i > max; i -= 1) {
  980. PointVo point = new PointVo();
  981. point.setX(StringUtils.round(i / coefficient, dec));
  982. point.setY(maxval);
  983. sjglPoints.add(point);
  984. }
  985. }
  986. }