From 3c61c5f4bc92f75b4fe60653eaa676a21cde4325 Mon Sep 17 00:00:00 2001 From: Fancy <Fancy.fx@outlook.com> Date: 星期四, 19 十二月 2024 17:09:02 +0800 Subject: [PATCH] edit BI Device log and planList --- pms-parent/pms-web-other/src/main/java/com/dy/pmsOther/screen/ScreenReportSv.java | 50 ++++++++++++++++++++++++++++---------------------- 1 files changed, 28 insertions(+), 22 deletions(-) diff --git a/pms-parent/pms-web-other/src/main/java/com/dy/pmsOther/screen/ScreenReportSv.java b/pms-parent/pms-web-other/src/main/java/com/dy/pmsOther/screen/ScreenReportSv.java index 1150855..366d9d3 100644 --- a/pms-parent/pms-web-other/src/main/java/com/dy/pmsOther/screen/ScreenReportSv.java +++ b/pms-parent/pms-web-other/src/main/java/com/dy/pmsOther/screen/ScreenReportSv.java @@ -4,6 +4,8 @@ import cn.hutool.json.JSONArray; import cn.hutool.json.JSONObject; import com.baomidou.mybatisplus.core.toolkit.StringUtils; +import com.dy.common.springUtil.SpringContextUtil; +import com.dy.pmsGlobal.daoOth.OthStatisticWorkloadMapper; import com.dy.pmsGlobal.daoPr.PrAssemblyPlanMapper; import com.dy.pmsGlobal.daoSta.*; import com.dy.pmsGlobal.pojoSta.*; @@ -16,6 +18,7 @@ import java.time.LocalTime; import java.time.ZoneId; import java.time.format.DateTimeFormatter; +import java.time.temporal.ChronoUnit; import java.time.temporal.TemporalAccessor; import java.util.Date; import java.util.HashMap; @@ -33,6 +36,8 @@ private StaDeviceProductionLogMapper deviceProductionLogDao; private StaRepairInfoMapper repairInfoDao; private PrAssemblyPlanMapper assemblyPlanDao; + private OthStatisticWorkloadMapper workloadDao; + @Autowired public void setDeviceLastDao(StaDeviceLastMapper deviceLastDao) { this.deviceLastDao = deviceLastDao; @@ -63,6 +68,11 @@ this.repairInfoDao = repairInfoDao; } + @Autowired + public void setWorkloadDao(OthStatisticWorkloadMapper workloadDao) { + this.workloadDao = workloadDao; + } + public Map<String, Object> getDeviceInfo(String deviceNo) { if (StringUtils.isBlank(deviceNo)) { return null; @@ -72,7 +82,7 @@ if (deviceLast == null) { return null; } - Map<String, Object> deviceInfo =new HashMap<>(); + Map<String, Object> deviceInfo = new HashMap<>(); deviceInfo.put("deviceInfo", deviceLast); //鏌ヨ璁惧鏃ュ織 List<StaDeviceProductionLog> log = deviceProductionLogDao.selectByDeviceNo(deviceNo); @@ -90,21 +100,21 @@ } public List<StaDeviceProductionLog> queryDeviceLog(String startTime, String endTime) { - Date startDt = parseToDate(startTime,0); - Date endDt = parseToDate(endTime,1); + Date startDt = parseToDate(startTime, 0); + Date endDt = parseToDate(endTime, 1); //鏌ヨ璁惧鏃ュ織 - List<StaDeviceProductionLog> log = deviceProductionLogDao.selectProductLog("",startDt,endDt); + List<StaDeviceProductionLog> log = deviceProductionLogDao.selectProductLog("", startDt, endDt); return log; } - private Date parseToDate(String strDt,long offDays) { - LocalDateTime dt = LocalDateTime.of(LocalDate.now().plusDays(offDays), LocalTime.of(0,0,0)); // 浠婂ぉ24鐐� + private Date parseToDate(String strDt, long offDays) { + LocalDateTime dt = LocalDateTime.of(LocalDate.now().plusDays(offDays), LocalTime.of(0, 0, 0)); // 浠婂ぉ24鐐� DateTimeFormatter dtf = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"); DateTimeFormatter dtf1 = DateTimeFormatter.ofPattern("yyyy-MM-dd"); if (strDt.matches("\\d{4}(-\\d{2}){2} \\d{2}(:\\d{2}){2}")) {//2024-08-15 00:00:00 - dt = LocalDateTime.parse(strDt,dtf); - }else if (strDt.matches("\\d{4}(-\\d{2}){2}")){ - dt = LocalDateTime.of(LocalDate.parse(strDt,dtf1), LocalTime.of(0,0,0)); + dt = LocalDateTime.parse(strDt, dtf); + } else if (strDt.matches("\\d{4}(-\\d{2}){2}")) { + dt = LocalDateTime.of(LocalDate.parse(strDt, dtf1), LocalTime.of(0, 0, 0)); } Date date = Date.from(dt.atZone(ZoneId.systemDefault()).toInstant()); return date; @@ -112,30 +122,26 @@ public List<JSONObject> queryPlanList() { List<JSONObject> list = assemblyPlanDao.queryPlanList(); - Map<String, JSONObject> map = new ConcurrentHashMap<>(); // 浣跨敤骞跺彂瀹夊叏鐨凪ap - for(JSONObject item:list){ + /*Map<String, JSONObject> map = new ConcurrentHashMap<>(); // 浣跨敤骞跺彂瀹夊叏鐨凪ap + for (JSONObject item : list) { String planId = String.valueOf(item.getObj("planId")); JSONObject innerObject = new JSONObject() .set("nodeId", String.valueOf(item.getObj("nodeId"))) .set("content", item.getObj("content")); - if(map.containsKey(planId)){ - JSONArray array = (JSONArray)map.get(planId).get("nodes"); + if (map.containsKey(planId)) { + JSONArray array = (JSONArray) map.get(planId).get("nodes"); array.add(innerObject); - }else{ + } else { JSONArray array = new JSONArray(); array.add(innerObject); - JSONObject outObject= new JSONObject() + JSONObject outObject = new JSONObject() .set("planId", planId) .set("planName", item.getObj("planName")) .set("nodes", array); - map.put(planId,outObject); + map.put(planId, outObject); } } - return map.values().stream().collect(Collectors.toList()); + return map.values().stream().collect(Collectors.toList());*/ + return list; } - - - - - } -- Gitblit v1.8.0