From cf8b7e27e274f7def6339f7a6f2a4d592f7291ca Mon Sep 17 00:00:00 2001 From: jiangping <jp@doumee.com> Date: 星期三, 07 五月 2025 14:44:41 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/RetentionServiceImpl.java | 7 ++++--- 1 files changed, 4 insertions(+), 3 deletions(-) diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/RetentionServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/RetentionServiceImpl.java index 855db4f..7ea1135 100644 --- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/RetentionServiceImpl.java +++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/RetentionServiceImpl.java @@ -309,7 +309,8 @@ .selectAs(Company::getName,Retention::getCompanyName) .selectAs(Company::getType,Retention::getCompanyType) .select(" ( SELECT v.company_name FROM visits v WHERE v.member_id = t.member_id and v.status = "+Constants.VisitStatus.signin+" ORDER BY create_date DESC limit 1 ) as visitCompanyName "); - queryWrapper.eq(Retention::getIsdeleted,Constants.ZERO) + queryWrapper.eq(Retention::getIsdeleted,Constants.ZERO) + .eq(Company::getIsdeleted,Constants.ZERO) .and(StringUtils.isNotBlank(pageWrap.getModel().getKeyWords()),w->{ w.like( Retention::getPhone,pageWrap.getModel().getKeyWords()) .or().like( Retention::getName,pageWrap.getModel().getKeyWords()); }) @@ -319,9 +320,9 @@ .isNull(Objects.nonNull(pageWrap.getModel().getQueryUserType())&&Constants.equalsInteger(pageWrap.getModel().getQueryUserType(),Constants.ZERO), Retention::getCompanyId) .eq(Objects.nonNull(pageWrap.getModel().getQueryUserType())&&Constants.equalsInteger(pageWrap.getModel().getQueryUserType(),Constants.ONE), - Company::getType,Constants.ZERO) + Retention::getType,Constants.FOUR) .eq(Objects.nonNull(pageWrap.getModel().getQueryUserType())&&Constants.equalsInteger(pageWrap.getModel().getQueryUserType(),Constants.TWO), - Company::getType,Constants.ONE) + Retention::getType,Constants.TWO) //杩囨护杞﹁締鏁版嵁 .ne(Retention::getType,3) .and(StringUtils.isNotBlank(pageWrap.getModel().getCompanyName()), -- Gitblit v1.9.3