| | |
| | | return jsonObject; |
| | | } |
| | | |
| | | /** |
| | | * 生产设备平均故障间隔时间MTBF |
| | | */ |
| | | @GetMapping("/get2MTBF") |
| | | public JSONObject get2MTBF(@RequestParam Map<String, Object> query) throws ParseException { |
| | | List<Map<String, Object>> equipmentList = faultIntervalTimeService.getEquipmentList(query); |
| | |
| | | } |
| | | |
| | | |
| | | /** |
| | | * A类生产设备平均故障间隔时间MTBF |
| | | */ |
| | | @GetMapping("/getAMTBF") |
| | | public JSONObject getAMTBF(@RequestParam Map<String, Object> query) throws ParseException { |
| | | query.put("abc","A"); |
| | | 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; |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 关键、重要生产设备平均故障间隔时间MTBF |
| | | */ |
| | | @GetMapping("/getGJZYMTBF") |
| | | public JSONObject getGJZYMTBF(@RequestParam Map<String, Object> query) throws ParseException { |
| | | query.put("specificEquipment","true"); |
| | | 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; |
| | | } |
| | | |
| | | /** |
| | | * 各生产单位 生产设备平均故障间隔时间MTBF |
| | | */ |
| | | @GetMapping("/getCenterMTBF") |
| | | public JSONObject getCenterMTBF(@RequestParam Map<String, Object> query) throws ParseException { |
| | | List<Map<String, Object>> workCenterList = faultIntervalTimeService.getWorkCenterList(query); |
| | | List<FaultIntervalTime> faultIntervalTimeList = new ArrayList<>(); |
| | | for (Map<String, Object> map : workCenterList) { |
| | | query.put("workCenterId",map.get("workCenterId")); |
| | | |
| | | List<Map<String, Object>> equipmentMTBF = faultIntervalTimeService.getCenterEquipmentMTBF(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("workCenterName")); |
| | | 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.getCenterMTBFTotalAvailableTime(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; |
| | | } |
| | | |
| | | |
| | | |
| | | /** |
| | | * 各生产单位 A类设备平均故障间隔时间MTBF |
| | | */ |
| | | @GetMapping("/getCenterAMTBF") |
| | | public JSONObject getCenterAMTBF(@RequestParam Map<String, Object> query) throws ParseException { |
| | | query.put("abc","A"); |
| | | List<Map<String, Object>> workCenterList = faultIntervalTimeService.getWorkCenterList(query); |
| | | List<FaultIntervalTime> faultIntervalTimeList = new ArrayList<>(); |
| | | for (Map<String, Object> map : workCenterList) { |
| | | query.put("workCenterId",map.get("workCenterId")); |
| | | |
| | | List<Map<String, Object>> equipmentMTBF = faultIntervalTimeService.getCenterEquipmentMTBF(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("workCenterName")); |
| | | 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.getCenterMTBFTotalAvailableTime(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; |
| | | } |
| | | |
| | | |
| | | } |