From e622bd5e3b2638b9ab9a712ed1160a66018d6fd7 Mon Sep 17 00:00:00 2001
From: MrShi <1878285526@qq.com>
Date: 星期四, 22 二月 2024 09:21:15 +0800
Subject: [PATCH] mrshi

---
 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