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