| | |
| | | import org.jeecg.common.system.base.controller.JeecgController; |
| | | import org.jeecg.common.system.query.QueryGenerator; |
| | | import org.jeecg.common.system.vo.LoginUser; |
| | | import org.jeecg.common.util.DateUtils; |
| | | import org.jeecg.common.util.oConvertUtils; |
| | | import org.jeecg.modules.eam.entity.*; |
| | | import org.jeecg.modules.eam.mapper.RepairOrderMapper; |
| | |
| | | import java.io.IOException; |
| | | import java.math.BigDecimal; |
| | | import java.text.ParseException; |
| | | import java.text.SimpleDateFormat; |
| | | import java.util.*; |
| | | import java.util.stream.Collectors; |
| | | |
| | |
| | | HttpServletRequest req) { |
| | | Page<RepairOrder> page = new Page<RepairOrder>(pageNo, pageSize); |
| | | IPage<RepairOrder> pageList = repairOrderService.getRepairOrderList(page, repairOrder); |
| | | List<RepairOrder> records = pageList.getRecords(); |
| | | for (RepairOrder record : records) { |
| | | record.setFaultCauseCount("故障原因统计"); |
| | | List<Map<String, Object>> allFaultCause = repairOrderService.getAllFaultCause(); |
| | | record.setAllFaultCause(allFaultCause); |
| | | |
| | | String equipmentId = record.getEquipmentId(); |
| | | List<Map<String, Object>> faultCause = repairOrderService.getFaultCause(equipmentId); |
| | | record.setEquipmentFaultCause(faultCause); |
| | | } |
| | | // for(RepairOrder repairOrder1 : pageList.getRecords()){ |
| | | // if(StringUtils.isNotBlank(repairOrder1.getReportRepairId())){ |
| | | // EquipmentReportRepair equipmentReportRepair = equipmentReportRepairService.getById(repairOrder1.getReportRepairId()); |
| | |
| | | repairOrder.getFaultEndTime(), |
| | | repairOrder.getCreateStartTime(), |
| | | repairOrder.getCreateEndTime(), |
| | | repairOrder.getEquipmentImportanceId()); |
| | | repairOrder.getEquipmentImportanceId(), |
| | | repairOrder.getFaultCause(), |
| | | null, |
| | | null, |
| | | null |
| | | ); |
| | | |
| | | // Step.3 AutoPoi 导出Excel |
| | | ModelAndView mv = new ModelAndView(new JeecgEntityExcelView()); |
| | |
| | | jsonObject.put("data",list); |
| | | return jsonObject; |
| | | } |
| | | } |
| | | |
| | | |
| | | /** |
| | | * 设备维修柱状图 |
| | | * qsw 2024-7-11 |
| | | */ |
| | | @GetMapping("getFaultCausePie") |
| | | public Result<?> getFaultCausePie(@RequestParam Map<String, Object> params) { |
| | | List<Map<String, Object>> faultCausePie = repairOrderService.getFaultCausePie(params); |
| | | return Result.ok(faultCausePie); |
| | | } |
| | | |
| | | /** |
| | | * 设备维修扇形图 |
| | | * qsw 2024-7-11 |
| | | */ |
| | | @GetMapping("getFaultCauseBar") |
| | | public Result<?> getFaultCauseBar(@RequestParam Map<String, Object> params) { |
| | | List<Map<String, Object>> faultCauseBar = repairOrderService.getFaultCauseBar(params); |
| | | return Result.ok(faultCauseBar); |
| | | } |
| | | |
| | | /** |
| | | * 设备故障折现图 |
| | | * qsw 2024-7-24 |
| | | */ |
| | | @GetMapping("getEquipmentFaultCause") |
| | | public Result<?> getEquipmentFaultCause(@RequestParam Map<String, Object> params) { |
| | | String faultStartTime = (String)params.get("faultStartTime"); |
| | | if(StringUtils.isBlank(faultStartTime)){ |
| | | Date dayAfter = DateUtils.getDayAfter(new Date(),15); |
| | | params.put("faultStartTime",DateUtils.date2Str(DateUtils.getDayAfter(new Date(),-15),new SimpleDateFormat("yyyy-MM-dd hh:MM:ss"))); |
| | | params.put("faultEndTime", DateUtils.getCurrentDateStr()+" 23:59:59"); |
| | | } |
| | | List<Map<String, Object>> equipmentFaultCause = repairOrderService.getEquipmentFaultCause(params); |
| | | return Result.ok(equipmentFaultCause); |
| | | } |
| | | |
| | | |
| | | /** |
| | | * MTPF |
| | | * qsw 2024-7-11 |
| | | */ |
| | | @GetMapping("getMTPF") |
| | | public Result<?> getMTPF(@RequestParam("pageNo") Integer pageNo, |
| | | @RequestParam("pageSize") Integer pageSize, |
| | | @RequestParam Map<String, Object> params) { |
| | | IPage<Map<String, Object>> mtpf = repairOrderService.getMTPF(pageNo, pageSize, params); |
| | | return Result.ok(mtpf); |
| | | } |
| | | |
| | | } |