package com.iailab.module.ansteel.job.task; import com.alibaba.fastjson.JSON; import com.alibaba.fastjson.JSONArray; import com.alibaba.fastjson.JSONObject; import com.iailab.framework.common.util.date.DateUtils; import com.iailab.module.ansteel.coking.entity.*; import com.iailab.module.ansteel.coking.service.*; import com.iailab.module.ansteel.common.constant.CommonConstant; import com.iailab.module.ansteel.common.enums.ProcessConfDataTypeEnum; import com.iailab.module.data.api.ind.IndItemApi; import com.iailab.module.data.api.ind.dto.ApiIndItemValueDTO; import com.iailab.module.data.api.point.DataPointApi; import com.iailab.module.model.api.mcs.McsApi; import com.iailab.module.model.api.mcs.dto.ChartParamDTO; import org.apache.commons.lang3.StringUtils; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Component; import org.springframework.transaction.annotation.Transactional; import org.springframework.util.CollectionUtils; import java.util.*; import java.util.stream.Collectors; /** * 化产工序异常溯源 * * @author lirm * @Description * @createTime 2025年04月22日 */ @Component("runCokingTraceModelHCTask") public class RunCokingTraceModelHCTask implements ITask{ private Logger logger = LoggerFactory.getLogger(getClass()); @Autowired private CokingTraceReportService cokingTraceReportService; @Autowired private CokingTraceSuggestService cokingTraceSuggestService; @Autowired private CokingTraceDeviationService cokingTraceDeviationService; @Autowired private CokingAnalyIndService cokingAnalyIndService; @Autowired private CokingTraceIndService cokingTraceIndService; @Autowired private CokingTraceConfService cokingTraceConfService; @Autowired private CokingTraceChartService cokingTraceChartService; @Autowired private McsApi mcsApi; @Autowired private DataPointApi dataPointApi; @Autowired private IndItemApi indItemApi; private static final HashMap chemProdColoumMap = new HashMap() {{ put("chemProdFirstColoum0", "一级指标-偏差值"); put("chemProdFirstColoum1", "二级指标-偏差值"); put("chemProdFirstColoum2", "影响因素1-偏差值"); }}; private static final HashMap historyPointMap = new HashMap() {{ put("F0000101006", "蒸汽消耗"); put("F0000101006", "初冷器出口煤气温度"); put("F0000101006", "洗苯塔后煤气含苯"); put("F0000101006", "脱硫后H2S含量"); }}; private static final String jsonStr="{\n" + " \"result\":{\n" + " \"chemProdSteam\":[[33836,33925]], \n" + " \"chemProdIndex\":[[352,355],[68,66.3],[82.5,87.6],[50.7,56.5],[73.5,73.1]],\n" + " \"chemProdTotal\":\"蒸汽消耗量异常,当前值1342,经模型计算,指标1异常,当前值1342,建议调整指标1至区间[90,110],指标2异常,当前值1342,建议调整指标2至区间[50,80]\",\n" + " \"chemProdFirstColoum0\":[[0,42]],\n" + " \"chemProdFirstColoum1\":[[5,1342],[7,1342],[9,1342]],\n" + " \"chemProdFirstColoum2\":[[5,10,1342],[5,16,1342],[7,18,1342]],\n" + " \"chemProdHomePage\":[[9,1342],[9,1342]],\n" + " \"chemProdHomeIndex\":[[90.4,90.2],[80.3,78],[103,100],[280,270]],\n" + " \"chemProdHomeIndexInfo\":\"2月18日甲班:化产蒸汽消耗量异常\",\n" + " \"chemProdHomeErr\":\"2月18日化产蒸汽消耗量数据异常(无数据)\"\n" + " }" + "}"; @Override public void run(String params) { logger.info("RunCokingTraceModelHCTask,参数为:{}", params); try { Calendar calendar = Calendar.getInstance(); calendar.set(Calendar.MILLISECOND, 0); calendar.set(Calendar.SECOND, 0); calendar.set(Calendar.MINUTE,0); calendar.add(Calendar.DAY_OF_YEAR, -1); String yesterday = DateUtils.format(calendar.getTime(), DateUtils.FORMAT_YEAR_MONTH_DAY); int hour = calendar.get(Calendar.HOUR_OF_DAY); Date startDate = calendar.getTime(); calendar.add(Calendar.HOUR, 8); Date endDate = calendar.getTime(); String clock = ""; String analyClass = ""; if (hour == 0) { clock = yesterday.concat("-").concat("A"); analyClass = "甲班"; } else if (hour == 8) { clock = yesterday.concat("-").concat("B"); analyClass = "乙班"; } else if (hour == 16) { clock = yesterday.concat("-").concat("C"); analyClass = "丙班"; } Map tMap = new HashMap<>(); tMap.put("relId", UUID.randomUUID().toString()); tMap.put("process", "化产工序"); tMap.put("reportName", "化产工序"); tMap.put("analyDate", yesterday); tMap.put("analyClass", analyClass); tMap.put("clock", clock); tMap.put("analyContent", "化产蒸汽消耗量异常"); tMap.put("startDate", startDate); tMap.put("endDate", endDate); JSONObject jsonObject= JSONObject.parseObject(jsonStr); JSONObject result = (JSONObject) JSON.toJSON(jsonObject.get("result")); if(!Objects.isNull(result)){ saveTraceReport(tMap,result); saveTraceSuggest(tMap,result); saveTraceDeviation(tMap,result); saveAnalyInd(tMap,result); saveTraceInd(tMap,result); saveTraceChart(tMap,result,startDate,endDate); } } catch (Exception ex) { logger.error("RunCokingTraceModelHCTask运行异常"); ex.printStackTrace(); } logger.info("RunCokingTraceModelHCTask运行完成"); } public void saveTraceReport(Map tMap,JSONObject result) { CokingTraceReportEntity reportEntity = new CokingTraceReportEntity(); reportEntity.setId(tMap.get("relId").toString()); reportEntity.setProcess(tMap.get("process").toString()); reportEntity.setReportName(tMap.get("reportName").toString()); reportEntity.setAnalyDate(tMap.get("analyDate").toString()); reportEntity.setAnalyClass(tMap.get("analyClass").toString()); reportEntity.setClock(tMap.get("clock").toString()); reportEntity.setAnalyContent(tMap.get("analyContent").toString()); reportEntity.setCreateDate(new Date()); cokingTraceReportService.save(reportEntity); } public void saveTraceSuggest(Map tMap,JSONObject result) { String chemProdTotal = result.get("chemProdTotal").toString(); if(StringUtils.isNotBlank(chemProdTotal)){ CokingTraceSuggestEntity suggestEntity = new CokingTraceSuggestEntity(); suggestEntity.setRelId(tMap.get("relId").toString()); suggestEntity.setProcess(tMap.get("process").toString()); suggestEntity.setSugObj("HC"); suggestEntity.setClock(tMap.get("clock").toString()); suggestEntity.setContent(chemProdTotal); suggestEntity.setCreateDate(new Date()); cokingTraceSuggestService.save(suggestEntity); } } public void saveTraceDeviation(Map tMap,JSONObject result) { List list = mcsApi.getChartParamList(CommonConstant.CHEMPROD_INDEX_CHARTCODE); Map steamIndexMaps = list.stream().collect(Collectors.toMap(ChartParamDTO::getParamCode, e -> e.getParamName())); for(int i=0;i<=2;i++){ String chemProdFirstColoum = result.get("chemProdFirstColoum"+i).toString(); if(StringUtils.isNotBlank(chemProdFirstColoum)){ JSONArray responseArr = JSON.parseArray(chemProdFirstColoum); List cokingTraceDeviationEntities = new ArrayList<>(); for (int j = 0; j < responseArr.size(); j++) { JSONArray element = JSON.parseArray(responseArr.get(j).toString()); CokingTraceDeviationEntity deviationEntity = new CokingTraceDeviationEntity(); deviationEntity.setRelId(tMap.get("relId").toString()); deviationEntity.setProcess(tMap.get("process").toString()); deviationEntity.setClock(tMap.get("clock").toString()); deviationEntity.setSugObj("HC"); deviationEntity.setGroupName(chemProdColoumMap.get("chemProdFirstColoum"+i).toString()); deviationEntity.setIndName(steamIndexMaps.get(element.get(0).toString())); deviationEntity.setIndValue(element.get(1).toString()); deviationEntity.setCreateDate(new Date()); cokingTraceDeviationEntities.add(deviationEntity); } cokingTraceDeviationService.save(cokingTraceDeviationEntities); } } } public void saveAnalyInd(Map tMap,JSONObject result) { String[] analyContent = tMap.get("analyContent").toString().split(";"); List list = new ArrayList<>(); for(int i=0;i tMap,JSONObject result) { Map map = new HashMap<>(); map.put("indType","化产工序异常溯源"); List list = cokingTraceConfService.list(map); if (CollectionUtils.isEmpty(list)) { logger.info("ConfLis is Empty"); return; } List cokingTraceIndEntities = new ArrayList<>(); for (CokingTraceConfEntity conf : list) { if (StringUtils.isBlank(conf.getDataType())) { logger.info("DataType is Empty"); continue; } if (StringUtils.isBlank(conf.getPointNo())) { logger.info("PointNo is Empty"); continue; } String value = ""; switch (ProcessConfDataTypeEnum.getEumByCode(conf.getDataType())) { case DATAPOINT: List points = new ArrayList<>(); points.add(conf.getPointNo()); Map pointsRealValue = dataPointApi.queryPointsRealValue(points); value = pointsRealValue.get(conf.getPointNo()).toString(); break; case IND: List indValues = indItemApi.queryIndItemDefaultValue(conf.getPointNo()); if (!CollectionUtils.isEmpty(indValues)) { value = indValues.get(indValues.size() - 1).getDataValue().toString(); } break; default: break; } CokingTraceIndEntity cokingTraceIndEntity = new CokingTraceIndEntity(); cokingTraceIndEntity.setRelId(tMap.get("relId").toString()); cokingTraceIndEntity.setTitle(conf.getIndType()); cokingTraceIndEntity.setClock(tMap.get("clock").toString()); cokingTraceIndEntity.setIndCode(conf.getIndCode()); cokingTraceIndEntity.setIndName(conf.getIndName()); cokingTraceIndEntity.setIndValue(value); cokingTraceIndEntity.setIndUnit(conf.getIndUnit()); cokingTraceIndEntities.add(cokingTraceIndEntity); } cokingTraceIndService.save(cokingTraceIndEntities); } public void saveTraceChart(Map tMap, JSONObject result,Date startDate,Date endDate) { historyPointMap.forEach((key,value) ->{ CokingTraceChartEntity cokingTraceChartEntity = new CokingTraceChartEntity(); cokingTraceChartEntity.setRelId(tMap.get("relId").toString()); cokingTraceChartEntity.setName(value.toString()); cokingTraceChartEntity.setClock(tMap.get("clock").toString()); cokingTraceChartEntity.setDataNo(key); cokingTraceChartEntity.setDataType("DATAPOINT"); cokingTraceChartEntity.setStartTime(startDate); cokingTraceChartEntity.setEndTime(endDate); cokingTraceChartEntity.setCreateDate(new Date()); cokingTraceChartService.save(cokingTraceChartEntity); }); } }