From ab80f75f65480b4b5da95e9963b4e0fa4a9aa97b Mon Sep 17 00:00:00 2001 From: k94314517 <8417338+k94314517@user.noreply.gitee.com> Date: 星期五, 13 六月 2025 15:52:19 +0800 Subject: [PATCH] git ch --- server/service/src/main/java/com/doumee/service/business/impl/UnionApplyServiceImpl.java | 2 ++ 1 files changed, 2 insertions(+), 0 deletions(-) diff --git a/server/service/src/main/java/com/doumee/service/business/impl/UnionApplyServiceImpl.java b/server/service/src/main/java/com/doumee/service/business/impl/UnionApplyServiceImpl.java index fa6fa88..a73309e 100644 --- a/server/service/src/main/java/com/doumee/service/business/impl/UnionApplyServiceImpl.java +++ b/server/service/src/main/java/com/doumee/service/business/impl/UnionApplyServiceImpl.java @@ -161,6 +161,7 @@ .selectAs(Solutions::getTimeUnit,UnionApply::getTimeUnit) .selectAs(Solutions::getOrtherInfo,UnionApply::getOrtherInfo) .selectAs(Solutions::getSpecialAgreement,UnionApply::getSpecialAgreement) + .selectAs(Company::getName,UnionApply::getCompanyName) .selectAs(Solutions::getSpecialInfo,UnionApply::getSpecialInfo); queryWrapper.select("(select count(distinct(b.MEMBER_ID)) from apply_detail b where b.isdeleted=0 and b.union_apply_id=t.id) as insureNum "); queryWrapper.select(" ( select count(DISTINCT(b.MEMBER_ID)) from apply_detail b inner join insurance_apply a on b.apply_id = a.id and a.status in ( 5 , 27 ) where b.union_apply_id=t.id and b.END_TIME > now() ) as guaranteeNum"); @@ -181,6 +182,7 @@ "and b.status = "+Constants.InsuranceApplyStatus.WTB_TOUBAOING.getKey()+" and a.type = 1 ) as changeApplyNum "); } queryWrapper.leftJoin(Solutions.class,Solutions::getId,UnionApply::getSolutionId); + queryWrapper.leftJoin(Company.class,Company::getId,UnionApply::getCompanyId); LoginUserInfo user = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal(); if(Constants.equalsInteger(user.getType(),Constants.TWO)){ queryWrapper.eq(UnionApply::getCompanyId, user.getCompanyId()); -- Gitblit v1.9.3