From 12614448a0e4c9521cc9d99cc56f4b453705c48c Mon Sep 17 00:00:00 2001 From: zjh <1084500556@qq.com> Date: 星期四, 03 七月 2025 18:19:36 +0800 Subject: [PATCH] zjh20250703 --- ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjDwGroupingController.java | 32 +++++++++++++++++++++++++++++++- 1 files changed, 31 insertions(+), 1 deletions(-) diff --git a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjDwGroupingController.java b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjDwGroupingController.java index 04f9c4c..4d828d1 100644 --- a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjDwGroupingController.java +++ b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjDwGroupingController.java @@ -275,14 +275,44 @@ */ @GetMapping("/getTjParentProjectList") @ApiOperation(value = "鑾峰彇浣撴鍗曢」椤圭洰淇℃伅") - public AjaxResult getTjParentProjectList(@RequestParam(required = false) @ApiParam(value = "鍗曢」鍚�") String proName) { + public AjaxResult getTjParentProjectList(@RequestParam(required = false) @ApiParam(value = "鍗曢」鍚�") String proName, + @RequestParam(required = false) @ApiParam(value = "鎷奸煶鐮�") String pym) { LambdaQueryWrapper<TjProject> wq =new LambdaQueryWrapper<>(); wq.eq(TjProject::getProParentId,0); wq.eq(TjProject::getProStatus,0); if(null !=proName && !proName.isEmpty()){ wq.like(TjProject::getProName,proName); } + if(null !=pym && !pym.isEmpty()){ + wq.apply("LOWER(pro_eng_name) LIKE {0}", "%" + pym.toLowerCase() + "%"); + } + List<TjProject> tjProjectList = projectService.list(wq); return success(tjProjectList); } + + + @GetMapping("/huoqutuantitaocanxiangmuList") + @ApiOperation(value = "鑾峰彇鎵�鏈夊崟浣嶅洟浣撳椁愰」鐩�") + public AjaxResult huoqutuantitaocanxiangmuList(@RequestParam(required = false) String dwId) { + List<TjPackage> list= tjDwGroupingService.huoqutuantitaocanxiangmuhuoqutuantitaocanxiangmuList(dwId); + if (null !=list && !list.isEmpty()){ + for (TjPackage tjPackage : list) { + List<TjProject> res=new ArrayList<>(); + LambdaQueryWrapper<TjGroupingPro> wqq=new LambdaQueryWrapper<>(); + wqq.eq(TjGroupingPro::getGroupingId,tjPackage.getPacId()); + final List<TjGroupingPro> groupingProList = groupingProService.list(wqq); + if (null !=groupingProList && !groupingProList.isEmpty()){ + for (TjGroupingPro pro : groupingProList) { + final TjProject byId = projectService.getById(pro.getProId()); + if(null !=byId){ + res.add(byId); + } + } + tjPackage.setTjProjectList(res); + } + } + } + return AjaxResult.success(list); + } } -- Gitblit v1.8.0