From 2ed5d099efee3a64bbe6925acfbf5faccb87ff03 Mon Sep 17 00:00:00 2001 From: jiangping <jp@doumee.com> Date: 星期二, 11 六月 2024 11:18:38 +0800 Subject: [PATCH] 更改头部 --- server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java | 20 +++++++++++++------- 1 files changed, 13 insertions(+), 7 deletions(-) diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java index 321887e..82ee127 100644 --- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java +++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java @@ -1086,6 +1086,9 @@ queryWrapper.leftJoin(Company.class,Company::getId,Member::getCompanyId); queryWrapper.selectAll(Member.class) .selectAs(Company::getName,Member::getCompanyName) ; + if(StringUtils.isNotBlank(member.getName())){ + queryWrapper.like(Member::getName,member.getName()); + } if(null != member.getType()) { queryWrapper.eq(Member::getType,member.getType()); @@ -1095,11 +1098,11 @@ } queryWrapper.eq(Member::getIsdeleted,Constants.ZERO); List<Member> list = memberJoinMapper.selectJoinList(Member.class,queryWrapper); - if(list!=null){ - for(Member m : list){ - m.setName(StringUtils.defaultString(m.getName(),"")+"-"+StringUtils.defaultString(m.getCompanyName(),"")); - } - } +// if(list!=null){ +// for(Member m : list){ +// m.setName(StringUtils.defaultString(m.getName(),"")+"-"+StringUtils.defaultString(m.getCompanyName(),"")); +// } +// } return list; } @Override @@ -1109,7 +1112,7 @@ queryWrapper.selectAll(Member.class) .selectAs(Company::getName,Member::getCompanyName) .eq(Member::getType,Constants.TWO) - .exists("select d.id from car_driver b where b.isdeleted=0 and b.member_id=t.id"); + .exists("select b.id from car_driver b where b.isdeleted=0 and b.member_id=t.id"); if(null != member.getType()) { queryWrapper.eq(Member::getType,member.getType()); @@ -1657,7 +1660,10 @@ @Override public List<MemberVO> getVisitedMember(CheckVisitedDTO checkVisitedDTO){ - List<Member> memberList = memberMapper.selectList(new QueryWrapper<Member>().lambda() + List<Member> memberList = memberJoinMapper.selectJoinList(Member.class,new MPJLambdaWrapper<Member>() + .selectAll(Member.class) + .selectAs(Company::getName,Member::getCompanyName) + .leftJoin(Company.class,Company::getId,Member::getCompanyId) .eq(StringUtils.isNotBlank(checkVisitedDTO.getMobile()),Member::getPhone,checkVisitedDTO.getMobile()) .eq(StringUtils.isNotBlank(checkVisitedDTO.getName()),Member::getName,checkVisitedDTO.getName()) .eq(Member::getIsdeleted,Constants.ZERO) -- Gitblit v1.9.3