From c421d2deeec5530d8060d8e06b5b86bb02e72dbf Mon Sep 17 00:00:00 2001 From: k94314517 <8417338+k94314517@user.noreply.gitee.com> Date: 星期三, 21 二月 2024 18:32:31 +0800 Subject: [PATCH] 111 --- server/service/src/main/java/com/doumee/service/business/impl/SolutionsServiceImpl.java | 6 ++++++ 1 files changed, 6 insertions(+), 0 deletions(-) diff --git a/server/service/src/main/java/com/doumee/service/business/impl/SolutionsServiceImpl.java b/server/service/src/main/java/com/doumee/service/business/impl/SolutionsServiceImpl.java index 75e4954..ebac33f 100644 --- a/server/service/src/main/java/com/doumee/service/business/impl/SolutionsServiceImpl.java +++ b/server/service/src/main/java/com/doumee/service/business/impl/SolutionsServiceImpl.java @@ -451,11 +451,17 @@ List<Solutions> solutionsList = solutionsJoinMapper.selectJoinList(Solutions.class,new MPJLambdaWrapper<Solutions>() .selectAll(Solutions.class) .leftJoin(CompanySolution.class,CompanySolution::getSolutionId,Solutions::getId) + .leftJoin(Company.class,Company::getId,CompanySolution::getCompanyId) + .leftJoin(Insurance.class,Insurance::getId,Solutions::getInsuranceId) .eq(Solutions::getIsdeleted,Constants.ZERO) .eq(Solutions::getStatus,Constants.ZERO) .eq(Solutions::getDataType,dataType) .eq(CompanySolution::getIsdeleted,Constants.ZERO) .eq(CompanySolution::getCompanyId,user.getCompanyId()) + .eq(Company::getIsdeleted,Constants.ZERO) + .eq(Company::getStatus,Constants.ZERO) + .eq(Insurance::getIsdeleted,Constants.ZERO) + .eq(Insurance::getStatus,Constants.ZERO) .orderByAsc(Solutions::getSortnum) ); return solutionsList; -- Gitblit v1.9.3