From 9b015b51b72ba050b4c38a6ba79eb45b7065e67d Mon Sep 17 00:00:00 2001 From: Lius <Lius2225@163.com> Date: 星期四, 25 七月 2024 10:11:52 +0800 Subject: [PATCH] 调整sql --- lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/DailyMaintenanceOrderDetailController.java | 39 ++++++++++++++++++++++++++++++++++++--- 1 files changed, 36 insertions(+), 3 deletions(-) diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/DailyMaintenanceOrderDetailController.java b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/DailyMaintenanceOrderDetailController.java index 943f517..ab2d9f9 100644 --- a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/DailyMaintenanceOrderDetailController.java +++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/DailyMaintenanceOrderDetailController.java @@ -15,8 +15,11 @@ import org.jeecg.common.system.base.entity.SysUpload; import org.jeecg.common.system.base.entity.SysUploadRela; import org.jeecg.common.system.query.QueryGenerator; +import org.jeecg.modules.eam.entity.DailyMaintenanceOrder; import org.jeecg.modules.eam.entity.DailyMaintenanceOrderDetail; +import org.jeecg.modules.eam.entity.InspectionOrder; import org.jeecg.modules.eam.service.IDailyMaintenanceOrderDetailService; +import org.jeecg.modules.eam.service.IDailyMaintenanceOrderService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import org.springframework.web.servlet.ModelAndView; @@ -41,6 +44,8 @@ @Autowired private IDailyMaintenanceOrderDetailService dailyMaintenanceOrderDetailService; + @Autowired + private IDailyMaintenanceOrderService dailyMaintenanceOrderService; @Autowired private ISysBaseAPI sysBaseApi; @@ -176,14 +181,21 @@ } /** - * 鑾峰彇鏃ュ父鐐规宸ュ崟鏄庣粏 + * 浜屼繚宸ュ崟鏄庣粏 * 2023-4-25 qsw */ @GetMapping(value = "/getDailyMaintenanceOrderDetailList") @PermissionData public Result<?> getDailyMaintenanceOrderDetailList(@RequestParam("pageNo") Integer pageNo, @RequestParam("pageSize") Integer pageSize, @RequestParam Map<String, Object> params) { IPage<Map<String, Object>> dailyMaintenanceOrderDetailList = dailyMaintenanceOrderDetailService.getDailyMaintenanceOrderDetailList(pageNo, pageSize, params); -// for (Map<String, Object> record : dailyMaintenanceOrderDetailList.getRecords()) { + for (Map<String, Object> record : dailyMaintenanceOrderDetailList.getRecords()) { + String dailyMaintenanceOrderId = (String)record.get("dailyMaintenanceOrderId"); + DailyMaintenanceOrder dailyMaintenanceOrder = dailyMaintenanceOrderService.getById(dailyMaintenanceOrderId); + if("4".equals(dailyMaintenanceOrder.getStatus())){ + record.put("disabled",false); + }else{ + record.put("disabled",true); + } // //鑾峰彇鏄惁鏈夌ず渚嬪浘鐗� //// List<SysUploadRela> sketchUploadRelas = uploadRelaService.lambdaQuery().eq(SysUploadRela::getBusId, (String) record.get("maintenanceStandardDetailId")).eq(SysUploadRela::getDelFlag, 0).list(); // List<SysUploadRela> sketchUploadRelas = sysBaseApi.listByBusIdAndBusType((String) record.get("maintenanceStandardDetailId"), null); @@ -200,8 +212,29 @@ // SysUpload upload = new SysUpload(); // record.put("sketchPhoto", upload); // } -// } + } return Result.ok(dailyMaintenanceOrderDetailList); } + /** + * 涓変繚宸ュ崟鏄庣粏 + * 2023-4-25 qsw + */ + @GetMapping(value = "/get3MaintenanceOrderDetailList") + @PermissionData + public Result<?> get3MaintenanceOrderDetailList(@RequestParam("pageNo") Integer pageNo, @RequestParam("pageSize") Integer pageSize, @RequestParam Map<String, Object> params) { + IPage<Map<String, Object>> dailyMaintenanceOrderDetailList = dailyMaintenanceOrderDetailService.get3MaintenanceOrderDetailList(pageNo, pageSize, params); + for (Map<String, Object> record : dailyMaintenanceOrderDetailList.getRecords()) { + String dailyMaintenanceOrderId = (String)record.get("dailyMaintenanceOrderId"); + DailyMaintenanceOrder dailyMaintenanceOrder = dailyMaintenanceOrderService.getById(dailyMaintenanceOrderId); + if("4".equals(dailyMaintenanceOrder.getStatus())){ + record.put("disabled",false); + }else{ + record.put("disabled",true); + } + } + return Result.ok(dailyMaintenanceOrderDetailList); + } + + } -- Gitblit v1.9.3