From 261f60837f9224fa1afdaf819cb33b85ff9f4d77 Mon Sep 17 00:00:00 2001 From: jiangping <jp@doumee.com> Date: 星期三, 29 五月 2024 11:33:14 +0800 Subject: [PATCH] 最新版本 --- server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java | 24 ++++++++++++++++++++++++ 1 files changed, 24 insertions(+), 0 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 38c780a..21b6767 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 @@ -1100,6 +1100,30 @@ } return list; } + @Override + public List<Member> findDriveList(Member member) { + MPJLambdaWrapper<Member> queryWrapper = new MPJLambdaWrapper<>(); + queryWrapper.leftJoin(Company.class,Company::getId,Member::getCompanyId); + 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"); + + if(null != member.getType()) { + queryWrapper.eq(Member::getType,member.getType()); + } + if(null != member.getCompanyId()) { + queryWrapper.eq(Member::getCompanyId,member.getCompanyId()); + } + 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(),"")); + } + } + return list; + } @Override public PageData<Member> findPage(PageWrap<Member> pageWrap) { -- Gitblit v1.9.3