From 63a5530a85e6eaf7f8be733e87d32af2d16477a8 Mon Sep 17 00:00:00 2001 From: qushaowei <qushaowei@163.com> Date: 星期日, 07 四月 2024 13:39:02 +0800 Subject: [PATCH] 设备管理 报表打印修改 --- lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/FaultIntervalTimeController.java | 66 +++++++++++++++++++++++++++++++-- 1 files changed, 62 insertions(+), 4 deletions(-) diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/FaultIntervalTimeController.java b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/FaultIntervalTimeController.java index 6e711c3..8acf2b2 100644 --- a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/FaultIntervalTimeController.java +++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/FaultIntervalTimeController.java @@ -9,9 +9,13 @@ import lombok.extern.slf4j.Slf4j; import org.jeecg.common.api.vo.Result; import org.jeecg.common.aspect.annotation.AutoLog; +import org.jeecg.common.constant.CommonConstant; import org.jeecg.common.system.base.controller.JeecgController; import org.jeecg.common.system.query.QueryGenerator; +import org.jeecg.common.util.DateUtils; +import org.jeecg.modules.eam.entity.Equipment; import org.jeecg.modules.eam.entity.FaultIntervalTime; +import org.jeecg.modules.eam.service.IEamEquipmentService; import org.jeecg.modules.eam.service.IFaultIntervalTimeService; import org.jeecg.modules.eam.vo.EquipmentAvailabilityVo; import org.springframework.beans.factory.annotation.Autowired; @@ -21,10 +25,7 @@ import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.text.ParseException; -import java.util.Arrays; -import java.util.HashMap; -import java.util.List; -import java.util.Map; +import java.util.*; /** * @Description: mom_eam_fault_interval_time @@ -37,8 +38,11 @@ @RequestMapping("/eam/faultIntervalTime") @Slf4j public class FaultIntervalTimeController extends JeecgController<FaultIntervalTime, IFaultIntervalTimeService> { + @Autowired private IFaultIntervalTimeService faultIntervalTimeService; + @Autowired + private IEamEquipmentService equipmentService; /** * 鍒嗛〉鍒楄〃鏌ヨ @@ -182,4 +186,58 @@ return jsonObject; } + @GetMapping("/get2MTBF") + public JSONObject get2MTBF(@RequestParam Map<String, Object> query) throws ParseException { + List<Map<String, Object>> equipmentList = faultIntervalTimeService.getEquipmentList(query); + List<FaultIntervalTime> faultIntervalTimeList = new ArrayList<>(); + for (Map<String, Object> map : equipmentList) { + query.put("equipmentId",map.get("id")); + + List<Map<String, Object>> equipmentMTBF = faultIntervalTimeService.getEquipmentMTBF(query); + + FaultIntervalTime faultIntervalTime = new FaultIntervalTime(); + faultIntervalTime.setEquipmentId((String)map.get("id")); + faultIntervalTime.setEquipmentNum((String)map.get("num")); + faultIntervalTime.setEquipmentName((String)map.get("name")); + faultIntervalTime.setEquipmentModel((String)map.get("model")); + faultIntervalTime.setUserDepart((String)map.get("departName")); + if(equipmentMTBF.size()>0){ + faultIntervalTime.setTotalAvailableTime(equipmentMTBF.get(0).get("totalAvailableTime").toString()); + faultIntervalTime.setNoFaultTime(equipmentMTBF.get(0).get("noFaultTime").toString()); + faultIntervalTime.setFaultTime(equipmentMTBF.get(0).get("faultTime").toString()); + faultIntervalTime.setFaultNumber(equipmentMTBF.get(0).get("faultNumber").toString()); + faultIntervalTime.setAverageRepairTime(equipmentMTBF.get(0).get("averageRepairTime").toString()); + faultIntervalTime.setAverageFaultIntervalTime(equipmentMTBF.get(0).get("averageFaultIntervalTime").toString()); + faultIntervalTime.setRepairTime(equipmentMTBF.get(0).get("repairTime").toString()); + faultIntervalTimeList.add(faultIntervalTime); + }else{ + List<Map<String, Object>> mtbfTotalAvailableTime = faultIntervalTimeService.getMTBFTotalAvailableTime(query); + if(query.get("startTime") != "" && query.get("endTime") != ""){ + faultIntervalTime.setTotalAvailableTime(mtbfTotalAvailableTime.get(0).get("totalAvailableTime").toString()); + faultIntervalTime.setNoFaultTime(mtbfTotalAvailableTime.get(0).get("totalAvailableTime").toString()); + faultIntervalTime.setAverageFaultIntervalTime(mtbfTotalAvailableTime.get(0).get("totalAvailableTime").toString()); + }else{ + faultIntervalTime.setTotalAvailableTime("0"); + faultIntervalTime.setNoFaultTime("0"); + faultIntervalTime.setAverageFaultIntervalTime("0"); + } + faultIntervalTime.setFaultTime("0"); + faultIntervalTime.setFaultNumber("0"); + faultIntervalTime.setAverageRepairTime("0"); + faultIntervalTime.setRepairTime("0"); + faultIntervalTimeList.add(faultIntervalTime); + } + + } +// Map<String,Object> result= new HashMap<>(); +// IPage<FaultIntervalTime> pageData = new Page<FaultIntervalTime>(); +// List<FaultIntervalTime> list = faultIntervalTimeService.getMTBF(query); + JSONObject jsonObject = new JSONObject(); + jsonObject.put("data",faultIntervalTimeList); + return jsonObject; + } + + + + } -- Gitblit v1.9.3