From 9e8a11aea00e194d4532a1adb48891e95f75b8b9 Mon Sep 17 00:00:00 2001 From: liriming <1343021927@qq.com> Date: 星期五, 25 四月 2025 21:29:58 +0800 Subject: [PATCH] 偏差值修改 --- ansteel-biz/src/main/java/com/iailab/module/ansteel/job/task/RunCokingTraceModelBMTask.java | 319 ++++++++++++++++++++++++++--------------------------- 1 files changed, 156 insertions(+), 163 deletions(-) diff --git a/ansteel-biz/src/main/java/com/iailab/module/ansteel/job/task/RunCokingTraceModelBMTask.java b/ansteel-biz/src/main/java/com/iailab/module/ansteel/job/task/RunCokingTraceModelBMTask.java index 1fdee17..714f802 100644 --- a/ansteel-biz/src/main/java/com/iailab/module/ansteel/job/task/RunCokingTraceModelBMTask.java +++ b/ansteel-biz/src/main/java/com/iailab/module/ansteel/job/task/RunCokingTraceModelBMTask.java @@ -4,12 +4,12 @@ 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.entity.CokingAnalyIndEntity; +import com.iailab.module.ansteel.coking.entity.CokingTraceDeviationEntity; +import com.iailab.module.ansteel.coking.entity.CokingTraceSuggestEntity; 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; @@ -32,7 +32,7 @@ * @createTime 2025年04月22日 */ @Component("runCokingTraceModelBMTask") -public class RunCokingTraceModelBMTask implements ITask{ +public class RunCokingTraceModelBMTask implements ITask { private Logger logger = LoggerFactory.getLogger(getClass()); @Autowired @@ -65,6 +65,16 @@ @Autowired private IndItemApi indItemApi; + private final static String process = "备煤工序"; + + private final static String reportName = "备煤工序异常溯源"; + + private final static String SugObj = "BM"; + + private final static String indType = "备煤工序异常溯源"; + + private final static String coalRow = "coalRow"; + private static final HashMap<String, Object> coalColoumMap = new HashMap<String, Object>() {{ put("coalColoum0", "一级指标-偏差值"); put("coalColoum1", "二级指标-偏差值"); @@ -75,21 +85,19 @@ put("F0000101008", "备煤耗电"); }}; - private static final String jsonStr="{\n" + - " \"result\": {\n" + - " \"coalPrepElec\":[1600.8,1613.5], \n" + - " \"coalPrepElecIndex\":[[0.8,0.73],[723,608],[1782,1782],[752,743],[729,783]],\n" + - " \"coalPrepElecTotal1\":\"1#粉碎机耗电因粉碎机偏高增加220KW/h,经模型计算,建建议调整单班用煤量,预计可使粉碎机耗电量指标降低170KW/h\",\n" + - " \"coalPrepElecTotal2\":\"1#粉碎机耗电量数据异常\",\n" + - " \"coalColoum0\":[[0,450],[0,137],[0,342]],\n" + - " \"coalColoum1\":[[2,306],[3,134],[1,142]],\n" + - " \"coalColoum2\":[[4,142],[4,132],[4,349]],\n" + + private static final String jsonStr = "{\n" + " " + + "\"result\": {\n" + + "\"coalPrepElec\":[1600.8,1613.5],\n" + + "\"coalPrepElecIndex\":[[0.8,0.73],[723,608],[1782,1782],[752,743],[729,783]],\n" + + "\"coalPrepElecTotal1\":\"1#粉碎机耗电因粉碎机偏高增加220KW/h,经模型计算,建建议调整单班用煤量,预计可使粉碎机耗电量指标降低170KW/h\",\n" + + "\"coalPrepElecTotal2\":\"1#粉碎机耗电量数据异常\",\n" + + "\"coalRow0\":[[0,450],[0,137],[0,342]],\n" + + "\"coalRow1\":[[0,450],[3,134],[1,142]],\n" + + "\"coalRow2\":[[4,142],[4,132],[4,349]],\n" + "\"coalPrepElecHomePage\":[[50,42],[10,10]],\n" + "\"coalHomeIndex\":[[90.4,90.2],[80.3,78],[103,100],[280,270]],\n" + - "\"coalIndexInfo\":\"2月18日甲班:备煤耗电异常\",\n" + - "\"coalErr\":\"2月18日粉碎机耗电数据异常(无数据)\"\n" + - " }" + - "}"; + "\"coalIndexInfo\":\"4月25日甲班:备煤耗电异常\",\n" + + "\"coalErr\":\"4月25日粉碎机耗电数据异常(无数据)\"\n" + " }" + "}"; @Override public void run(String params) { @@ -98,46 +106,65 @@ 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); + calendar.set(Calendar.MINUTE, 0); 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"); + if (hour >= 8 && hour < 16) { + calendar.set(Calendar.HOUR_OF_DAY, 0); + startDate = calendar.getTime(); + calendar.add(Calendar.HOUR_OF_DAY, 8); + endDate = calendar.getTime(); + clock = DateUtils.format(startDate).concat("-").concat("A"); analyClass = "甲班"; - } else if (hour == 8) { - clock = yesterday.concat("-").concat("B"); + } else if (hour >= 16 && hour < 24) { + calendar.set(Calendar.HOUR_OF_DAY, 8); + startDate = calendar.getTime(); + calendar.add(Calendar.HOUR_OF_DAY, 8); + endDate = calendar.getTime(); + clock = DateUtils.format(startDate).concat("-").concat("B"); analyClass = "乙班"; - } else if (hour == 16) { - clock = yesterday.concat("-").concat("C"); + } else if (hour >= 0 && hour < 8) { + calendar.add(Calendar.DAY_OF_YEAR, -1); + calendar.set(Calendar.HOUR_OF_DAY, 16); + startDate = calendar.getTime(); + calendar.add(Calendar.HOUR_OF_DAY, 8); + endDate = calendar.getTime(); + clock = DateUtils.format(startDate).concat("-").concat("B"); analyClass = "丙班"; } - Map<String, Object> 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 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); + + if (Objects.isNull(result)) { + logger.info("模型结果为空"); + return; } + + // 保存报告 + String analyDate = DateUtils.format(startDate); + String analyContent = result.getString("coalIndexInfo"); + String relId = cokingTraceReportService.save(process, reportName, analyDate, analyClass, clock, analyContent); + + // 保存一级分析指标 + saveAnalyInd(relId, process, analyDate, analyClass, analyContent); + + // 保存优化建议 + saveTraceSuggest(relId, process, clock, result); + + // 保存偏差值 + saveTraceDeviation(relId, process, clock, result); + + // 保存溯源指标 + cokingTraceIndService.saveTraceInd(relId, indType, clock); + + // 保存溯源折线图 + cokingTraceChartService.save(relId, clock, indType, startDate, endDate); + } catch (Exception ex) { logger.error("RunCokingTraceModelBMTask运行异常"); ex.printStackTrace(); @@ -145,138 +172,104 @@ logger.info("RunCokingTraceModelBMTask运行完成"); } - public void saveTraceReport(Map<String, Object> 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<String, Object> tMap,JSONObject result) { - String coalTotal = result.get("coalPrepElecTotal1").toString(); - if(StringUtils.isNotBlank(coalTotal)){ - CokingTraceSuggestEntity suggestEntity = new CokingTraceSuggestEntity(); - suggestEntity.setRelId(tMap.get("relId").toString()); - suggestEntity.setProcess(tMap.get("process").toString()); - suggestEntity.setSugObj("BM"); - suggestEntity.setClock(tMap.get("clock").toString()); - suggestEntity.setContent(coalTotal); - suggestEntity.setCreateDate(new Date()); - cokingTraceSuggestService.save(suggestEntity); - } + public void saveTraceSuggest(String relId, String process, String clock, JSONObject result) { + String coalTotal = result.get("coalPrepElecTotal1").toString(); + if (StringUtils.isBlank(coalTotal)) { + logger.info("coalPrepElecTotal1 is null"); + return; + } + CokingTraceSuggestEntity suggestEntity = new CokingTraceSuggestEntity(); + suggestEntity.setRelId(relId); + suggestEntity.setProcess(process); + suggestEntity.setSugObj(SugObj); + suggestEntity.setClock(clock); + suggestEntity.setContent(coalTotal); + suggestEntity.setCreateDate(new Date()); + cokingTraceSuggestService.save(suggestEntity); } @Transactional - public void saveTraceDeviation(Map<String, Object> tMap,JSONObject result) { + public void saveTraceDeviation(String relId, String process, String clock, JSONObject result) { List<ChartParamDTO> list = mcsApi.getChartParamList(CommonConstant.COAL_INDEX_CHARTCODE); Map<String, String> steamIndexMaps = list.stream().collect(Collectors.toMap(ChartParamDTO::getParamCode, e -> e.getParamName())); - for(int i=0;i<=2;i++){ - String coalColoum = result.get("coalColoum"+i).toString(); - if(StringUtils.isNotBlank(coalColoum)){ - JSONArray responseArr = JSON.parseArray(coalColoum); - List<CokingTraceDeviationEntity> entityList = 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("BM"); - deviationEntity.setGroupName(coalColoumMap.get("coalColoum"+i).toString()); - deviationEntity.setIndName(steamIndexMaps.get(element.get(0).toString())); - deviationEntity.setIndValue(element.get(1).toString()); - deviationEntity.setCreateDate(new Date()); - entityList.add(deviationEntity); - } - cokingTraceDeviationService.save(entityList); + + List<String> coalRowKeys = new ArrayList<>(); + result.forEach((key, value) -> { + if (StringUtils.isNotBlank(key) && key.contains(coalRow)) { + coalRowKeys.add(key); } + + }); + + List<CokingTraceDeviationEntity> entityList = new ArrayList<>(); + for (String key : coalRowKeys) { + JSONArray rowArr = JSON.parseArray(result.get(key).toString()); + if (CollectionUtils.isEmpty(rowArr)) { + continue; + } + CokingTraceDeviationEntity entity = new CokingTraceDeviationEntity(); + entity.setRelId(relId); + entity.setProcess(process); + entity.setClock(clock); + entity.setSugObj(SugObj); + + entity.setInd1Name(steamIndexMaps.get(rowArr.getJSONArray(0).get(0).toString())); + entity.setInd1Value(rowArr.getJSONArray(0).get(1).toString()); + entity.setInd1Unit(""); + + entity.setInd2Name(steamIndexMaps.get(rowArr.getJSONArray(1).get(0).toString())); + entity.setInd2Value(rowArr.getJSONArray(1).get(1).toString()); + entity.setInd2Unit(""); + + if (rowArr.size() > 2) { + entity.setFac1Name(steamIndexMaps.get(rowArr.getJSONArray(2).get(0).toString())); + entity.setFac1Value(rowArr.getJSONArray(2).get(1).toString()); + entity.setFac1Unit(""); + } + if (rowArr.size() > 3) { + entity.setFac2Name(steamIndexMaps.get(rowArr.getJSONArray(3).get(0).toString())); + entity.setFac2Value(rowArr.getJSONArray(3).get(1).toString()); + entity.setFac2Unit(""); + } + if (rowArr.size() > 4) { + entity.setFac3Name(steamIndexMaps.get(rowArr.getJSONArray(4).get(0).toString())); + entity.setFac3Value(rowArr.getJSONArray(4).get(1).toString()); + entity.setFac3Unit(""); + } + if (rowArr.size() > 5) { + entity.setFac4Name(steamIndexMaps.get(rowArr.getJSONArray(5).get(0).toString())); + entity.setFac4Value(rowArr.getJSONArray(5).get(1).toString()); + entity.setFac4Unit(""); + } + if (rowArr.size() > 6) { + entity.setFac5Name(steamIndexMaps.get(rowArr.getJSONArray(6).get(0).toString())); + entity.setFac5Value(rowArr.getJSONArray(6).get(1).toString()); + entity.setFac5Unit(""); + } + entityList.add(entity); } + + cokingTraceDeviationService.save(entityList); } - public void saveAnalyInd(Map<String, Object> tMap,JSONObject result) { - String[] analyContent = tMap.get("analyContent").toString().split(";"); + public void saveAnalyInd(String relId, String process, String analyDate, String analyClass, String analyContent) { + if (StringUtils.isBlank(analyContent)) { + logger.info("analyContent is null"); + return; + } + String[] analyContentArr = analyContent.split(";"); List<CokingAnalyIndEntity> entityList = new ArrayList<>(); - for(int i=0;i<analyContent.length;i++){ + for (int i = 0; i < analyContentArr.length; i++) { CokingAnalyIndEntity analyIndEntity = new CokingAnalyIndEntity(); - analyIndEntity.setRelId(tMap.get("relId").toString()); - analyIndEntity.setAnalyType(tMap.get("process").toString()); - analyIndEntity.setAnalyDate(tMap.get("analyDate").toString()); - analyIndEntity.setAnalyClass(tMap.get("analyClass").toString()); - analyIndEntity.setAnalyContent(analyContent[i]); - analyIndEntity.setSort(i+1); + analyIndEntity.setRelId(relId); + analyIndEntity.setAnalyType(process); + analyIndEntity.setAnalyDate(analyDate); + analyIndEntity.setAnalyClass(analyClass); + analyIndEntity.setAnalyContent(analyContentArr[i]); + analyIndEntity.setSort(i + 1); entityList.add(analyIndEntity); } cokingAnalyIndService.save(entityList); - } - - public void saveTraceInd(Map<String, Object> tMap,JSONObject result) { - Map<String,Object> map = new HashMap<>(); - map.put("indType","备煤工序异常溯源"); - List<CokingTraceConfEntity> list = cokingTraceConfService.list(map); - if (CollectionUtils.isEmpty(list)) { - logger.info("ConfLis is Empty"); - return; - } - List<CokingTraceIndEntity> entityList = 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<String> points = new ArrayList<>(); - points.add(conf.getPointNo()); - Map<String, Object> pointsRealValue = dataPointApi.queryPointsRealValue(points); - value = pointsRealValue.get(conf.getPointNo()).toString(); - break; - case IND: - List<ApiIndItemValueDTO> 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()); - entityList.add(cokingTraceIndEntity); - } - cokingTraceIndService.save(entityList); - } - - public void saveTraceChart(Map<String, Object> tMap, JSONObject result,Date startDate,Date endDate) { - List<CokingTraceChartEntity> entityList = new ArrayList<>(); - 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()); - entityList.add(cokingTraceChartEntity); - }); - cokingTraceChartService.insert(entityList); } } \ No newline at end of file -- Gitblit v1.9.3