From 6a3591c42a84b36d24d75f4584f0eeb145bb4de7 Mon Sep 17 00:00:00 2001 From: “linengliang” <vanSuperEnergy@163.com> Date: 星期五, 15 三月 2024 15:00:24 +0800 Subject: [PATCH] xg --- lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/CalibrationOrderController.java | 328 ++++++++++++++++++++++++++++++++++++++++++++++------- 1 files changed, 281 insertions(+), 47 deletions(-) diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/CalibrationOrderController.java b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/CalibrationOrderController.java index a604a67..ce24a6a 100644 --- a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/CalibrationOrderController.java +++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/CalibrationOrderController.java @@ -3,6 +3,8 @@ import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; +import com.baomidou.mybatisplus.core.toolkit.ObjectUtils; +import com.baomidou.mybatisplus.core.toolkit.StringUtils; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.github.xiaoymin.knife4j.core.util.CollectionUtils; import io.swagger.annotations.Api; @@ -21,14 +23,11 @@ import org.jeecg.common.system.vo.LoginUser; import org.jeecg.common.util.oConvertUtils; import org.jeecg.modules.eam.entity.*; -import org.jeecg.modules.eam.service.ICalibrationOrderDetailService; -import org.jeecg.modules.eam.service.ICalibrationOrderReportService; -import org.jeecg.modules.eam.service.ICalibrationOrderService; -import org.jeecg.modules.eam.service.IEamEquipmentService; +import org.jeecg.modules.eam.service.*; import org.jeecg.modules.eam.vo.CalibrationOrderPage; - -//import org.jeecg.modules.system.service.IUploadRelaService; -//import org.jeecg.modules.system.service.IUploadService; +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; @@ -45,6 +44,8 @@ import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.io.IOException; +import java.time.LocalDate; +import java.time.ZoneId; import java.util.*; import java.util.concurrent.atomic.AtomicReference; import java.util.stream.Collectors; @@ -69,12 +70,27 @@ private ICalibrationOrderReportService calibrationOrderReportService; @Autowired private IEamEquipmentService equipmentService; + + @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; /** * 鍒嗛〉鍒楄〃鏌ヨ * @@ -457,37 +473,41 @@ 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("姝e父"); - } - }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("姝e父"); - } - } - } +// 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("姝e父"); +// } +// }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("姝e父"); +// } +// } +// } } return Result.OK(pageList); } @@ -502,16 +522,24 @@ for (CalibrationOrderDetail calibrationOrderDetail : calibrationOrderDetails) { calibrationOrderDetailService.removeById(calibrationOrderDetail); } - List<Map<String, Object>> precisionParameterList = calibrationOrderService.getPrecisionParameterList(calibrationOrder.getEquipmentId()); - CalibrationOrderDetail calibrationOrderDetail = null; - for (Map<String, Object> map : precisionParameterList) { - calibrationOrderDetail = new CalibrationOrderDetail(); +// addAndEdit(calibrationOrder); + return Result.OK("缂栬緫鎴愬姛!"); + } + + private void addAndEdit(@RequestBody CalibrationOrder calibrationOrder) { + String precisionParametersTemplateId = calibrationOrder.getCalibrationOrderUda1(); + List<PrecisionParametersTemplateDetail> precisionParametersTemplateDetails = precisionParametersTemplateDetailService + .list(new QueryWrapper<PrecisionParametersTemplateDetail>() + .eq("precision_parameters_template_id",precisionParametersTemplateId) + .eq("del_flag",0)); + for (PrecisionParametersTemplateDetail precisionParametersTemplateDetail : precisionParametersTemplateDetails) { + CalibrationOrderDetail calibrationOrderDetail = new CalibrationOrderDetail(); calibrationOrderDetail.setCalibrationOrderId(calibrationOrder.getId()); - calibrationOrderDetail.setEquipmentPrecisionParametersId((String)map.get("id")); - calibrationOrderDetail.setPrecisionParametersId((String)map.get("precisionParametersId")); + calibrationOrderDetail.setCalibrationOrderDetailUda1(precisionParametersTemplateDetail.getId()); + calibrationOrderDetail.setPrecisionParametersId(precisionParametersTemplateDetail.getPrecisionParametersId()); + calibrationOrderDetail.setSort(precisionParametersTemplateDetail.getSort()); calibrationOrderDetailService.save(calibrationOrderDetail); } - return Result.OK("缂栬緫鎴愬姛!"); } /** @@ -523,16 +551,24 @@ public Result<String> addNew(@RequestBody CalibrationOrder calibrationOrder) { calibrationOrder.setStatus("1"); calibrationOrderService.save(calibrationOrder); - List<Map<String, Object>> precisionParameterList = calibrationOrderService.getPrecisionParameterList(calibrationOrder.getEquipmentId()); - CalibrationOrderDetail calibrationOrderDetail = null; - for (Map<String, Object> map : precisionParameterList) { - calibrationOrderDetail = new CalibrationOrderDetail(); - calibrationOrderDetail.setCalibrationOrderId(calibrationOrder.getId()); - calibrationOrderDetail.setEquipmentPrecisionParametersId((String)map.get("id")); - calibrationOrderDetail.setPrecisionParametersId((String)map.get("precisionParametersId")); - calibrationOrderDetailService.save(calibrationOrderDetail); + + 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); } /** @@ -598,4 +634,202 @@ calibrationOrderService.removeById(id); return Result.OK("鍒犻櫎鎴愬姛!"); } + @GetMapping(value = "/listByMainId") + public Result<IPage<CalibrationOrderDetail>> listByMainId(CalibrationOrderDetail calibrationOrderDetail, + @RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo, + @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize, + HttpServletRequest req) { + QueryWrapper<CalibrationOrderDetail> queryWrapper = QueryGenerator.initQueryWrapper(calibrationOrderDetail, req.getParameterMap()); + Page<CalibrationOrderDetail> page = new Page<CalibrationOrderDetail>(pageNo, pageSize); + IPage<CalibrationOrderDetail> pageList = calibrationOrderDetailService.pageList(page,calibrationOrderDetail.getCalibrationOrderId()); + return Result.OK(pageList); + } + @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("璇ヨ澶囧皻鏈淮鎶ゆ瀹氬懆鏈燂紝璇峰厛缁存姢妫�瀹氬懆鏈�"); + } + + // 杞崲涓簀ava.util.Date + 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); + } + } -- Gitblit v1.9.3