From c1b5d8b81d63555f6f0095aa823f07d99f80fe21 Mon Sep 17 00:00:00 2001 From: k94314517 <8417338+k94314517@user.noreply.gitee.com> Date: 星期五, 11 四月 2025 18:22:49 +0800 Subject: [PATCH] git ch --- server/service/src/main/java/com/doumee/service/business/impl/DispatchUnitServiceImpl.java | 3 +++ 1 files changed, 3 insertions(+), 0 deletions(-) diff --git a/server/service/src/main/java/com/doumee/service/business/impl/DispatchUnitServiceImpl.java b/server/service/src/main/java/com/doumee/service/business/impl/DispatchUnitServiceImpl.java index 2b8691f..f3210d9 100644 --- a/server/service/src/main/java/com/doumee/service/business/impl/DispatchUnitServiceImpl.java +++ b/server/service/src/main/java/com/doumee/service/business/impl/DispatchUnitServiceImpl.java @@ -882,7 +882,9 @@ .selectAll(DuSolution.class) .selectAs(Solutions::getName,DuSolution::getSolutionName) .leftJoin(Solutions.class,Solutions::getId,DuSolution::getSolutionId) + .leftJoin(CompanySolution.class,CompanySolution::getSolutionId,Solutions::getId) .eq(DuSolution::getDispatchUnitId,dispatchUnit.getId()) + .eq(CompanySolution::getCompanyId,dispatchUnit.getCompanyId()) .orderByAsc(DuSolution::getSortnum) ); if(CollectionUtils.isNotEmpty(duSolutionList)){ @@ -937,6 +939,7 @@ .eq(DispatchUnit::getStatus,Constants.ZERO) .select("(select b.id from du_solution b where b.isdeleted=0 and b.dispatch_unit_id=t.id and b.solution_id="+dispatchUnitQueryDTO.getSolutionId()+" order by b.CHECK_DATE desc limit 1) as du_solution_id" ) .eq(loginUserInfo.getType().equals(Constants.ONE),DispatchUnit::getCompanyId,loginUserInfo.getCompanyId()) + .eq(Objects.nonNull(dispatchUnitQueryDTO.getCompanyId()),DispatchUnit::getCompanyId,dispatchUnitQueryDTO.getCompanyId()) .eq(Objects.isNull(dispatchUnitQueryDTO.getDataType()),DispatchUnit::getDataType,Constants.TWO) .eq(!Objects.isNull(dispatchUnitQueryDTO.getDataType()),DispatchUnit::getDataType,dispatchUnitQueryDTO.getDataType()) .exists(!Objects.isNull(dispatchUnitQueryDTO.getSolutionId()), -- Gitblit v1.9.3