HlBaseServiceImpl.java 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398
  1. package com.jjt.biz.service.impl;
  2. import com.googlecode.aviator.AviatorEvaluator;
  3. import com.jjt.biz.domain.*;
  4. import com.jjt.biz.mapper.HlBaseMapper;
  5. import com.jjt.biz.service.*;
  6. import com.jjt.common.utils.DateUtils;
  7. import com.jjt.common.utils.StringUtils;
  8. import org.springframework.jdbc.core.JdbcTemplate;
  9. import org.springframework.stereotype.Service;
  10. import javax.annotation.Resource;
  11. import java.math.BigDecimal;
  12. import java.time.LocalDate;
  13. import java.time.ZoneId;
  14. import java.util.*;
  15. import java.util.concurrent.atomic.AtomicReference;
  16. import java.util.regex.Matcher;
  17. import java.util.regex.Pattern;
  18. import java.util.stream.Collectors;
  19. /**
  20. * 健康度配置基本Service业务层处理
  21. *
  22. * @author jjt
  23. * @date 2024-08-28
  24. */
  25. @Service
  26. public class HlBaseServiceImpl implements IHlBaseService {
  27. @Resource
  28. private HlBaseMapper hlBaseMapper;
  29. @Resource
  30. private IHlClassService classService;
  31. @Resource
  32. private IHlObjService objService;
  33. @Resource
  34. private IHlDetailService detailService;
  35. @Resource
  36. private JdbcTemplate jdbcTemplate;
  37. @Resource
  38. private IHlScoreService scoreService;
  39. @Resource
  40. private IHlScoreDetailService scoreDetailService;
  41. @Resource
  42. private IHlDayService dayService;
  43. @Resource
  44. private IHlDayDetailService dayDetailService;
  45. @Resource
  46. private IHlMetricsRelaService relaService;
  47. @Resource
  48. private IMetricsDefService defService;
  49. @Resource
  50. private IBizModelService modelService;
  51. /**
  52. * 查询健康度配置基本
  53. *
  54. * @param hlBaseId 健康度配置基本主键
  55. * @return 健康度配置基本
  56. */
  57. @Override
  58. public HlBase selectHlBaseByHlBaseId(Long hlBaseId) {
  59. return hlBaseMapper.selectHlBaseByHlBaseId(hlBaseId);
  60. }
  61. /**
  62. * 根据模型ID查询
  63. *
  64. * @param modelId 健康度配置基本主键
  65. * @return 结果
  66. */
  67. @Override
  68. public HlBase selectHlBaseByModelId(Long modelId) {
  69. return hlBaseMapper.selectHlBaseByModelId(modelId);
  70. }
  71. /**
  72. * 查询健康度配置基本列表
  73. *
  74. * @param hlBase 健康度配置基本
  75. * @return 健康度配置基本
  76. */
  77. @Override
  78. public List<HlBase> selectHlBaseList(HlBase hlBase) {
  79. return hlBaseMapper.selectHlBaseList(hlBase);
  80. }
  81. /**
  82. * 新增健康度配置基本
  83. *
  84. * @param hlBase 健康度配置基本
  85. * @return 结果
  86. */
  87. @Override
  88. public int insertHlBase(HlBase hlBase) {
  89. hlBase.setCreateTime(DateUtils.getNowDate());
  90. return hlBaseMapper.insertHlBase(hlBase);
  91. }
  92. /**
  93. * 修改健康度配置基本
  94. *
  95. * @param hlBase 健康度配置基本
  96. * @return 结果
  97. */
  98. @Override
  99. public int updateHlBase(HlBase hlBase) {
  100. hlBase.setUpdateTime(DateUtils.getNowDate());
  101. return hlBaseMapper.updateHlBase(hlBase);
  102. }
  103. /**
  104. * 批量删除健康度配置基本
  105. *
  106. * @param hlBaseIds 需要删除的健康度配置基本主键
  107. * @return 结果
  108. */
  109. @Override
  110. public int deleteHlBaseByHlBaseIds(Long[] hlBaseIds) {
  111. return hlBaseMapper.deleteHlBaseByHlBaseIds(hlBaseIds);
  112. }
  113. /**
  114. * 删除健康度配置基本信息
  115. *
  116. * @param hlBaseId 健康度配置基本主键
  117. * @return 结果
  118. */
  119. @Override
  120. public int deleteHlBaseByHlBaseId(Long hlBaseId) {
  121. return hlBaseMapper.deleteHlBaseByHlBaseId(hlBaseId);
  122. }
  123. /**
  124. * 根据模型ID插入健康度数据
  125. *
  126. * @param modelId 模型ID
  127. */
  128. @Override
  129. public void insertHlBase4ModelId(Long modelId) {
  130. //如果没有数据,则复制基础数据到模型
  131. HlBase base = selectHlBaseByHlBaseId(1L);
  132. base.setHlBaseId(null);
  133. base.setModelId(modelId);
  134. insertHlBase(base);
  135. List<HlClass> classes = base.getHlClassList();
  136. HlBase finalBase = base;
  137. classes.forEach(cs -> {
  138. cs.setClassId(null);
  139. cs.setHlBaseId(finalBase.getHlBaseId());
  140. classService.insertHlClass(cs);
  141. List<HlObj> objs = cs.getHlObjList();
  142. objs.forEach(ob -> {
  143. ob.setClassId(cs.getClassId());
  144. ob.setHlObjId(null);
  145. objService.insertHlObj(ob);
  146. List<HlDetail> details = ob.getHlDetailList();
  147. details.forEach(d -> {
  148. d.setHlObjId(ob.getHlObjId());
  149. d.setHlDetailId(null);
  150. detailService.insertHlDetail(d);
  151. });
  152. });
  153. });
  154. }
  155. /**
  156. * 根据模型ID删除健康度数据
  157. *
  158. * @param modelId 模型ID
  159. */
  160. @Override
  161. public void deleteHlBase4ModelId(Long modelId) {
  162. if (modelId == -1) {
  163. return;
  164. }
  165. try {
  166. // 开始事务
  167. jdbcTemplate.execute("BEGIN");
  168. // 执行删除语句
  169. jdbcTemplate.update("DELETE FROM hl_detail WHERE HL_OBJ_ID IN (SELECT HL_OBJ_ID FROM hl_obj WHERE CLASS_ID IN (SELECT CLASS_ID FROM hl_class WHERE hl_base_id IN (SELECT hl_base_id FROM hl_base WHERE model_id = ?)))", modelId);
  170. jdbcTemplate.update("DELETE FROM hl_obj WHERE CLASS_ID IN (SELECT CLASS_ID FROM hl_class WHERE hl_base_id IN (SELECT hl_base_id FROM hl_base WHERE model_id = ?))", modelId);
  171. jdbcTemplate.update("DELETE FROM hl_class WHERE hl_base_id IN (SELECT hl_base_id FROM hl_base WHERE model_id = ?)", modelId);
  172. jdbcTemplate.update("DELETE FROM hl_base WHERE model_id = ?", modelId);
  173. // 提交事务
  174. jdbcTemplate.execute("COMMIT");
  175. } catch (Exception e) {
  176. // 回滚事务
  177. jdbcTemplate.execute("ROLLBACK");
  178. throw new RuntimeException(e);
  179. }
  180. }
  181. /**
  182. * 健康度评分
  183. */
  184. @Override
  185. public void score() {
  186. Map<String, String> expMap = relaService.selectHlMetricsRelaList(new HlMetricsRela()).stream()
  187. .collect(Collectors.toMap(HlMetricsRela::getHlCode, HlMetricsRela::getExp));
  188. Map<String, Long> defMap = defService.selectMetricsDefList(new MetricsDef()).stream().collect(Collectors.toMap(MetricsDef::getMetricsCode, MetricsDef::getMetricsId));
  189. List<HlBase> list = selectHlBaseList(new HlBase());
  190. list.forEach(base -> {
  191. if (base.getModelId() != -1) {
  192. Map<Long, List<BizObjMetrics>> metricsGroup = modelService.selectBizModelMetricsList(base.getModelId()).stream().collect(Collectors.groupingBy(BizObjMetrics::getMetricsId));
  193. HlScore score = new HlScore();
  194. score.setModelId(base.getModelId());
  195. scoreService.insertHlScore(score);
  196. List<HlClass> classes = base.getHlClassList();
  197. AtomicReference<BigDecimal> total = new AtomicReference<>(new BigDecimal(0));
  198. classes.forEach(cs -> {
  199. HlScoreDetail csDetail = new HlScoreDetail();
  200. csDetail.setHlScoreId(score.getHlScoreId());
  201. csDetail.setHlType("CLASS");
  202. csDetail.setHlCode(cs.getClassCode());
  203. List<HlObj> objs = cs.getHlObjList();
  204. AtomicReference<BigDecimal> scc = new AtomicReference<>(new BigDecimal(0));
  205. objs.forEach(ob -> {
  206. List<HlDetail> details = ob.getHlDetailList();
  207. HlScoreDetail obDetail = new HlScoreDetail();
  208. obDetail.setHlScoreId(score.getHlScoreId());
  209. obDetail.setHlType("OBJ");
  210. obDetail.setHlCode(ob.getHlObjCode());
  211. AtomicReference<BigDecimal> sc = new AtomicReference<>(new BigDecimal(0));
  212. if ("LINK".equals(ob.getHlObjCode())) {
  213. details.forEach(d -> {
  214. HlScoreDetail scoreDetail = new HlScoreDetail();
  215. scoreDetail.setHlScoreId(score.getHlScoreId());
  216. scoreDetail.setHlType("DETAIL");
  217. scoreDetail.setHlCode(d.getHlDetailCode());
  218. String hlCode = d.getHlDetailCode();
  219. String exp = expMap.get(hlCode);
  220. BigDecimal standScore = new BigDecimal(d.getHlDetailScore());
  221. switch (hlCode) {
  222. case "C01":
  223. case "C02":
  224. case "C03":
  225. if (StringUtils.isNotEmpty(exp)) {
  226. Matcher matcher = match(exp);
  227. Map<String, List<BizObjMetrics>> originalMap = new HashMap<>();
  228. //先拿到一个code,好获取组件数量
  229. String oneCode = "";
  230. while (matcher.find()) {
  231. String code = matcher.group(1);
  232. String old = String.format("${%s}", code);
  233. String newCode = code.replace(".", "");
  234. oneCode = newCode;
  235. exp = exp.replace(old, newCode);
  236. Long mid = defMap.get(code);
  237. List<BizObjMetrics> omList = metricsGroup.get(mid);
  238. originalMap.put(newCode, omList);
  239. }
  240. // 获取组件数量
  241. int size = originalMap.get(oneCode).size();
  242. int alarmSize = 0;
  243. // 遍历列表并创建新的 Map
  244. for (int i = 0; i < size; i++) {
  245. Map<String, Object> singleEntryMap = new HashMap<>();
  246. for (String s : originalMap.keySet()) {
  247. singleEntryMap.put(s, originalMap.get(s).get(i).getDValue().floatValue());
  248. }
  249. boolean flag = evaluator(exp, singleEntryMap);
  250. if (flag) {
  251. alarmSize++;
  252. }
  253. }
  254. //最终得分(告警组件数量/总数量 )*细项分
  255. BigDecimal df = standScore.subtract(BigDecimal.valueOf(alarmSize).divide(BigDecimal.valueOf(size)).multiply(standScore));
  256. scoreDetail.setHlScore(df);
  257. scoreDetailService.insertHlScoreDetail(scoreDetail);
  258. }
  259. break;
  260. default:
  261. break;
  262. }
  263. });
  264. } else {
  265. sc.set(random(ob.getHlObjScore()));
  266. }
  267. obDetail.setHlScore(sc.get());
  268. scoreDetailService.insertHlScoreDetail(obDetail);
  269. scc.set(scc.get().add(obDetail.getHlScore()));
  270. });
  271. csDetail.setHlScore(scc.get());
  272. scoreDetailService.insertHlScoreDetail(csDetail);
  273. total.set(total.get().add(csDetail.getHlScore()));
  274. });
  275. score.setHlScore(total.get());
  276. scoreService.updateHlScore(score);
  277. }
  278. });
  279. }
  280. /**
  281. * 昨日健康度评分
  282. */
  283. @Override
  284. public void yesterday() {
  285. LocalDate localDate = LocalDate.now().minusDays(1);
  286. List<HlBase> list = selectHlBaseList(new HlBase());
  287. list.forEach(base -> {
  288. if (base.getModelId() != -1) {
  289. HlDay hlDay = new HlDay();
  290. hlDay.setModelId(base.getModelId());
  291. hlDay.setHlDate(Date.from(localDate.atStartOfDay(ZoneId.systemDefault()).toInstant()));
  292. dayService.insertHlDay(hlDay);
  293. List<HlClass> classes = base.getHlClassList();
  294. AtomicReference<BigDecimal> total = new AtomicReference<>(new BigDecimal(0));
  295. classes.forEach(cs -> {
  296. HlDayDetail csDetail = new HlDayDetail();
  297. csDetail.setDayId(hlDay.getDayId());
  298. csDetail.setHlType("CLASS");
  299. csDetail.setHlCode(cs.getClassCode());
  300. List<HlObj> objs = cs.getHlObjList();
  301. AtomicReference<BigDecimal> scc = new AtomicReference<>(new BigDecimal(0));
  302. objs.forEach(ob -> {
  303. List<HlDetail> details = ob.getHlDetailList();
  304. HlDayDetail obDetail = new HlDayDetail();
  305. obDetail.setDayId(hlDay.getDayId());
  306. obDetail.setHlType("OBJ");
  307. obDetail.setHlCode(ob.getHlObjCode());
  308. AtomicReference<BigDecimal> sc = new AtomicReference<>(new BigDecimal(0));
  309. if ("LINK".equals(ob.getHlObjCode())) {
  310. details.forEach(d -> {
  311. HlDayDetail scoreDetail = new HlDayDetail();
  312. scoreDetail.setDayId(hlDay.getDayId());
  313. scoreDetail.setHlType("DETAIL");
  314. scoreDetail.setHlCode(d.getHlDetailCode());
  315. switch (d.getHlDetailCode()) {
  316. case "C01":
  317. case "C02":
  318. case "C03":
  319. BigDecimal dc = random(d.getHlDetailScore());
  320. scoreDetail.setHlScore(dc);
  321. sc.set(sc.get().add(dc));
  322. dayDetailService.insertHlDayDetail(scoreDetail);
  323. break;
  324. default:
  325. break;
  326. }
  327. });
  328. } else {
  329. sc.set(random(ob.getHlObjScore()));
  330. }
  331. obDetail.setHlScore(sc.get());
  332. dayDetailService.insertHlDayDetail(obDetail);
  333. scc.set(scc.get().add(obDetail.getHlScore()));
  334. });
  335. csDetail.setHlScore(scc.get());
  336. dayDetailService.insertHlDayDetail(csDetail);
  337. total.set(total.get().add(csDetail.getHlScore()));
  338. });
  339. hlDay.setHlScore(total.get());
  340. dayService.updateHlDay(hlDay);
  341. }
  342. });
  343. }
  344. private BigDecimal random(Long s) {
  345. Random random = new Random();
  346. int randomNumber = random.nextInt(3);
  347. // 生01到3的随机数
  348. int v = s.intValue() - randomNumber;
  349. return BigDecimal.valueOf(v);
  350. }
  351. /**
  352. * 公式计算
  353. *
  354. * @param exp 表达式
  355. * @param env 值
  356. * @return 结果
  357. */
  358. private boolean evaluator(String exp, Map<String, Object> env) {
  359. return (boolean) AviatorEvaluator.execute(exp, env);
  360. }
  361. /**
  362. * 正则匹配
  363. *
  364. * @param exp 表达式
  365. * @return 结果
  366. */
  367. private Matcher match(String exp) {
  368. //正则表达式匹配变量
  369. Pattern pattern = Pattern.compile("\\$\\{(.+?)\\}");
  370. return pattern.matcher(exp);
  371. }
  372. }