PowerCurveFittingService.java 60 KB

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