| | |
| | | import org.jeecg.modules.eam.entity.*; |
| | | import org.jeecg.modules.eam.service.*; |
| | | import org.jeecg.modules.eam.vo.CalibrationOrderPage; |
| | | import org.jeecg.modules.eam.vo.SysFileNameVo; |
| | | import org.jeecg.modules.system.entity.SysDepart; |
| | | import org.jeecg.modules.system.service.ISysDepartService; |
| | | import org.jeecgframework.poi.excel.ExcelImportUtil; |
| | | import org.jeecgframework.poi.excel.def.NormalExcelConstants; |
| | | import org.jeecgframework.poi.excel.entity.ExportParams; |
| | |
| | | |
| | | @Autowired |
| | | private IPrecisionParametersTemplateDetailService precisionParametersTemplateDetailService; |
| | | |
| | | @Autowired |
| | | private ITechnologyStatusService technologyStatusService; |
| | | |
| | | @Autowired |
| | | private ISysFileNameService sysFileNameService; |
| | | |
| | | @Autowired |
| | | private ISysDepartService sysDepartService; |
| | | // @Autowired |
| | | // private IUploadRelaService uploadRelaService; |
| | | // @Autowired |
| | | // private IUploadService uploadService; |
| | | |
| | | private ISysBaseAPI sysBaseApi; |
| | | |
| | | @Autowired |
| | | private IAreaService areaService; |
| | | /** |
| | | * 分页列表查询 |
| | | * |
| | |
| | | String managementMode = record.getManagementMode(); |
| | | String equipmentId = record.getEquipmentId(); |
| | | Equipment equipment = equipmentService.getById(equipmentId); |
| | | String useId = equipment.getUseId(); |
| | | SysDepart depart = sysDepartService.getById(useId); |
| | | if(equipment != null){ |
| | | record.setEquipmentNum(equipment.getNum()); |
| | | record.setEquipmentName(equipment.getName()); |
| | | record.setEquipmentModel(equipment.getModel()); |
| | | record.setEquipmentSpecification(equipment.getSpecification()); |
| | | record.setEquipmentImportance(equipment.getEquipmentImportanceId()); |
| | | record.setUseDepartName(ObjectUtils.isNotNull(depart)?depart.getDepartName():""); |
| | | } |
| | | List<Map<String, Object>> precisionParameterList = calibrationOrderService.getPrecisionParameterList(equipmentId); |
| | | record.setPrecisionParameterList(precisionParameterList); |
| | | if("4".equals(status)){ |
| | | if("data".equals(managementMode)){ |
| | | List<CalibrationOrderDetail> calibrationOrderDetails = calibrationOrderDetailService.lambdaQuery() |
| | | .eq(CalibrationOrderDetail::getCalibrationOrderId, id) |
| | | .eq(CalibrationOrderDetail::getJudgmentResult, "fail") |
| | | .eq(CalibrationOrderDetail::getDelFlag,"0").list(); |
| | | if(calibrationOrderDetails.size()>0){ |
| | | record.setCalibrationResult("异常"); |
| | | }else{ |
| | | record.setCalibrationResult("正常"); |
| | | } |
| | | }else{ |
| | | List<CalibrationOrderReport> calibrationOrderReports = calibrationOrderReportService.lambdaQuery() |
| | | .eq(CalibrationOrderReport::getCalibrationOrderId, id) |
| | | .eq(CalibrationOrderReport::getJudgmentResult, "fail") |
| | | .eq(CalibrationOrderReport::getDelFlag, "0").list(); |
| | | if(calibrationOrderReports.size()>0){ |
| | | record.setCalibrationResult("异常"); |
| | | }else{ |
| | | record.setCalibrationResult("正常"); |
| | | } |
| | | } |
| | | } |
| | | // List<Map<String, Object>> precisionParameterList = calibrationOrderService.getPrecisionParameterList(equipmentId); |
| | | // record.setPrecisionParameterList(precisionParameterList); |
| | | // if("4".equals(status)){ |
| | | // if("data".equals(managementMode)){ |
| | | // List<CalibrationOrderDetail> calibrationOrderDetails = calibrationOrderDetailService.lambdaQuery() |
| | | // .eq(CalibrationOrderDetail::getCalibrationOrderId, id) |
| | | // .eq(CalibrationOrderDetail::getJudgmentResult, "fail") |
| | | // .eq(CalibrationOrderDetail::getDelFlag,"0").list(); |
| | | // if(calibrationOrderDetails.size()>0){ |
| | | // record.setCalibrationResult("异常"); |
| | | // }else{ |
| | | // record.setCalibrationResult("正常"); |
| | | // } |
| | | // }else{ |
| | | // List<CalibrationOrderReport> calibrationOrderReports = calibrationOrderReportService.lambdaQuery() |
| | | // .eq(CalibrationOrderReport::getCalibrationOrderId, id) |
| | | // .eq(CalibrationOrderReport::getJudgmentResult, "fail") |
| | | // .eq(CalibrationOrderReport::getDelFlag, "0").list(); |
| | | // if(calibrationOrderReports.size()>0){ |
| | | // record.setCalibrationResult("异常"); |
| | | // }else{ |
| | | // record.setCalibrationResult("正常"); |
| | | // } |
| | | // } |
| | | // } |
| | | } |
| | | return Result.OK(pageList); |
| | | } |
| | |
| | | for (CalibrationOrderDetail calibrationOrderDetail : calibrationOrderDetails) { |
| | | calibrationOrderDetailService.removeById(calibrationOrderDetail); |
| | | } |
| | | addAndEdit(calibrationOrder); |
| | | // addAndEdit(calibrationOrder); |
| | | return Result.OK("编辑成功!"); |
| | | } |
| | | |
| | |
| | | public Result<String> addNew(@RequestBody CalibrationOrder calibrationOrder) { |
| | | calibrationOrder.setStatus("1"); |
| | | calibrationOrderService.save(calibrationOrder); |
| | | addAndEdit(calibrationOrder); |
| | | |
| | | String equipmentId = calibrationOrder.getEquipmentId(); |
| | | Equipment equipment = equipmentService.getById(equipmentId); |
| | | String equipmentImportance = equipment.getEquipmentImportanceId(); |
| | | if("D".equals(equipmentImportance)){ |
| | | this.createTechnologyStatus(calibrationOrder); |
| | | } |
| | | |
| | | // addAndEdit(calibrationOrder); |
| | | return Result.OK("添加成功!"); |
| | | } |
| | | |
| | | void createTechnologyStatus(CalibrationOrder calibrationOrder){ |
| | | List<SysFileNameVo> sysFileName = sysFileNameService.getSysFileName("9"); |
| | | TechnologyStatus technologyStatus = new TechnologyStatus(); |
| | | technologyStatus.setOrderId(calibrationOrder.getId()); |
| | | technologyStatus.setReceipts(sysFileName.get(0).getReceipts()); |
| | | technologyStatusService.save(technologyStatus); |
| | | } |
| | | |
| | | /** |
| | |
| | | @RequestMapping(value = "/saveFinal", method = {RequestMethod.PUT, RequestMethod.POST}) |
| | | public Result<String> saveFinal(@RequestBody CalibrationOrder calibrationOrder) { |
| | | calibrationOrder.setCalibrationTime(new Date()); |
| | | calibrationOrder.setStatus("5"); |
| | | if(StringUtils.isNotBlank(calibrationOrder.getEquipmentId())){ |
| | | String equipmentId = calibrationOrder.getEquipmentId(); |
| | | Equipment equipment = equipmentService.getById(equipmentId); |
| | | if(ObjectUtils.isNotNull(equipment)){ |
| | | LocalDate currentDate = LocalDate.now(); |
| | | // 添加维护周期的日期 |
| | | String checkPeriod = equipment.getCheckPeriod(); |
| | | if(StringUtils.isNotBlank(checkPeriod)){ |
| | | LocalDate dateAfter30Days = currentDate.plusDays(Integer.parseInt(checkPeriod)); |
| | | Date result = Date.from(dateAfter30Days.atStartOfDay(ZoneId.systemDefault()).toInstant()); |
| | | equipment.setTechnologyStatus(calibrationOrder.getCalibrationOrderUda6()); |
| | | equipment.setTechnologyStatusQualificationTime(new Date()); |
| | | equipment.setNextTechnologyStatusQualificationTime(result); |
| | | }else { |
| | | return Result.error("该设备尚未维护检定周期,请先维护检定周期"); |
| | | } |
| | | |
| | | // 添加30天 |
| | | LocalDate dateAfter30Days = currentDate.plusDays(Integer.parseInt(equipment.getCheckPeriod())); |
| | | // 转换为java.util.Date |
| | | Date result = Date.from(dateAfter30Days.atStartOfDay(ZoneId.systemDefault()).toInstant()); |
| | | equipment.setTechnologyStatus(calibrationOrder.getCalibrationOrderUda6()); |
| | | equipment.setTechnologyStatusQualificationTime(new Date()); |
| | | equipment.setNextTechnologyStatusQualificationTime(result); |
| | | equipmentService.updateById(equipment); |
| | | } |
| | | |
| | |
| | | calibrationOrderService.updateById(calibrationOrder); |
| | | return Result.OK("编辑成功!"); |
| | | } |
| | | |
| | | /** |
| | | *首页公司级 技术状态数量统计 |
| | | * qsw 2024-3-13 |
| | | */ |
| | | @GetMapping("getFactoryEquipmentTechnologyStatusList") |
| | | public Result<?> getFactoryEquipmentTechnologyStatusList() { |
| | | List<Map<String, Object>> list = calibrationOrderService.getFactoryEquipmentTechnologyStatusList(); |
| | | return Result.ok(list); |
| | | } |
| | | |
| | | /** |
| | | *首页公司级 设备报修情况统计 |
| | | * qsw 2024-3-13 |
| | | */ |
| | | @GetMapping("getFactoryReportRepairEquipmentList") |
| | | public Result<?> getFactoryReportRepairEquipmentList() { |
| | | List<Map<String, Object>> list = calibrationOrderService.getFactoryReportRepairEquipmentList(); |
| | | return Result.ok(list); |
| | | } |
| | | |
| | | /** |
| | | *首页公司级 本月三保计划 |
| | | * qsw 2024-3-14 |
| | | */ |
| | | @GetMapping("getFactoryThisMonthMaintenanceList") |
| | | public Result<?> getFactoryThisMonthMaintenanceList() { |
| | | List<Map<String, Object>> list = calibrationOrderService.getFactoryThisMonthMaintenanceList(); |
| | | return Result.ok(list); |
| | | } |
| | | |
| | | /** |
| | | *首页公司级 下月三保计划 |
| | | * qsw 2024-3-14 |
| | | */ |
| | | @GetMapping("getFactoryNextMonthMaintenanceList") |
| | | public Result<?> getFactoryNextMonthMaintenanceList() { |
| | | List<Map<String, Object>> list = calibrationOrderService.getFactoryNextMonthMaintenanceList(); |
| | | return Result.ok(list); |
| | | } |
| | | |
| | | /** |
| | | *首页公司级 本月三保完成数量 |
| | | * qsw 2024-3-14 |
| | | */ |
| | | @GetMapping("getFactoryThisMonthMaintenanceFinishList") |
| | | public Result<?> getFactoryThisMonthMaintenanceFinishList() { |
| | | List<Map<String, Object>> list = calibrationOrderService.getFactoryThisMonthMaintenanceFinishList(); |
| | | return Result.ok(list); |
| | | } |
| | | |
| | | /** |
| | | *首页公司级 下下月三保计划 |
| | | * qsw 2024-3-14 |
| | | */ |
| | | @GetMapping("getFactoryNextNextMonthMaintenanceList") |
| | | public Result<?> getFactoryNextNextMonthMaintenanceList() { |
| | | List<Map<String, Object>> list = calibrationOrderService.getFactoryNextNextMonthMaintenanceList(); |
| | | return Result.ok(list); |
| | | } |
| | | |
| | | |
| | | /** |
| | | *首页(二级页面)技术状态数量统计 |
| | | * qsw 2024-3-13 |
| | | */ |
| | | @GetMapping("getEquipmentTechnologyStatusList") |
| | | public Result<?> getEquipmentTechnologyStatusList(@Param("factoryNum") String factoryNum) { |
| | | List<Area> areaList = areaService.lambdaQuery().eq(Area::getNum, factoryNum).eq(Area::getDelFlag, 0).list(); |
| | | List<Map<String, Object>> list; |
| | | if(areaList.size()>0){ |
| | | list = calibrationOrderService.getEquipmentTechnologyStatusList(areaList.get(0).getId()); |
| | | }else{ |
| | | list = null; |
| | | } |
| | | return Result.ok(list); |
| | | } |
| | | |
| | | /** |
| | | *首页(二级页面)设备报修情况统计 |
| | | * qsw 2024-3-13 |
| | | */ |
| | | @GetMapping("getReportRepairEquipmentList") |
| | | public Result<?> getReportRepairEquipmentList(@Param("factoryNum") String factoryNum) { |
| | | List<Area> areaList = areaService.lambdaQuery().eq(Area::getNum, factoryNum).eq(Area::getDelFlag, 0).list(); |
| | | List<Map<String, Object>> list; |
| | | if(areaList.size()>0){ |
| | | list = calibrationOrderService.getReportRepairEquipmentList(areaList.get(0).getId()); |
| | | }else{ |
| | | list = null; |
| | | } |
| | | return Result.ok(list); |
| | | } |
| | | |
| | | /** |
| | | *首页(二级页面)本月三保计划 |
| | | * qsw 2024-3-14 |
| | | */ |
| | | @GetMapping("getThisMonthMaintenanceList") |
| | | public Result<?> getThisMonthMaintenanceList(@Param("factoryNum") String factoryNum) { |
| | | List<Area> areaList = areaService.lambdaQuery().eq(Area::getNum, factoryNum).eq(Area::getDelFlag, 0).list(); |
| | | List<Map<String, Object>> list; |
| | | if(areaList.size()>0){ |
| | | list = calibrationOrderService.getThisMonthMaintenanceList(areaList.get(0).getId()); |
| | | }else{ |
| | | list = null; |
| | | } |
| | | return Result.ok(list); |
| | | } |
| | | |
| | | /** |
| | | *首页(二级页面)下月三保计划 |
| | | * qsw 2024-3-14 |
| | | */ |
| | | @GetMapping("getNextMonthMaintenanceList") |
| | | public Result<?> getNextMonthMaintenanceList(@Param("factoryNum") String factoryNum) { |
| | | List<Area> areaList = areaService.lambdaQuery().eq(Area::getNum, factoryNum).eq(Area::getDelFlag, 0).list(); |
| | | List<Map<String, Object>> list; |
| | | if(areaList.size()>0){ |
| | | list = calibrationOrderService.getNextMonthMaintenanceList(areaList.get(0).getId()); |
| | | }else{ |
| | | list = null; |
| | | } |
| | | return Result.ok(list); |
| | | } |
| | | |
| | | /** |
| | | *首页(二级页面)下下月三保计划 |
| | | * qsw 2024-3-14 |
| | | */ |
| | | @GetMapping("getNextNextMonthMaintenanceList") |
| | | public Result<?> getNextNextMonthMaintenanceList(@Param("factoryNum") String factoryNum) { |
| | | List<Area> areaList = areaService.lambdaQuery().eq(Area::getNum, factoryNum).eq(Area::getDelFlag, 0).list(); |
| | | List<Map<String, Object>> list; |
| | | if(areaList.size()>0){ |
| | | list = calibrationOrderService.getNextNextMonthMaintenanceList(areaList.get(0).getId()); |
| | | }else{ |
| | | list = null; |
| | | } |
| | | return Result.ok(list); |
| | | } |
| | | |
| | | /** |
| | | *首页(二级页面)本月三保完成数量 |
| | | * qsw 2024-3-14 |
| | | */ |
| | | @GetMapping("getThisMonthMaintenanceFinishList") |
| | | public Result<?> getThisMonthMaintenanceFinishList(@Param("factoryNum") String factoryNum) { |
| | | List<Area> areaList = areaService.lambdaQuery().eq(Area::getNum, factoryNum).eq(Area::getDelFlag, 0).list(); |
| | | List<Map<String, Object>> list; |
| | | if(areaList.size()>0){ |
| | | list = calibrationOrderService.getThisMonthMaintenanceFinishList(areaList.get(0).getId()); |
| | | }else{ |
| | | list = null; |
| | | } |
| | | return Result.ok(list); |
| | | } |
| | | |
| | | } |