From dc79419f90bd4b9622e06320e15e3e056c13d89b Mon Sep 17 00:00:00 2001 From: liukangdong <898885815@qq.com> Date: 星期二, 15 十月 2024 19:07:27 +0800 Subject: [PATCH] Merge branch 'master' of http://139.186.142.91:10010/r/productDev/dmvisit --- server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/MemberServiceImpl.java | 17 +++++++++++++++-- 1 files changed, 15 insertions(+), 2 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 0d64ceb..2418a69 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 @@ -327,7 +327,7 @@ if (StringUtils.isBlank(member.getPhone())||!PhoneUtil.isPhone(member.getPhone())){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"鐢佃瘽鍙风爜鏍煎紡鏈夎"); } - if (StringUtils.isBlank(member.getIdcardNo())||!IdcardUtil.isValidCard(member.getIdcardNo())){ + if (StringUtils.isNotBlank(member.getIdcardNo()) && !IdcardUtil.isValidCard(member.getIdcardNo())){ throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"韬唤璇佸彿鏍煎紡鏈夎"); } if(memberMapper.selectCount(new QueryWrapper<Member>().lambda() @@ -396,7 +396,8 @@ } if (StringUtils.isNotBlank(member.getIdcardNoNew())){ String encrptNo = (DESUtil.encrypt(Constants.EDS_PWD, member.getIdcardNoNew()));//韬唤璇佸彿鍔犲瘑 - if(!isDebug && !StringUtils.equals(model.getIdcardNo(),encrptNo)&& !IdcardUtil.isValidCard(member.getIdcardNoNew())){ + if(!isDebug && StringUtils.isNotBlank(member.getIdcardNoNew()) && + !StringUtils.equals(model.getIdcardNo(),encrptNo)&& !IdcardUtil.isValidCard(member.getIdcardNoNew())){ //濡傛灉鍙戠敓鏀瑰彉锛屽苟涓斾笉鍚堟硶锛屾彁绀哄紓甯� throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"淇敼鐨勬柊韬唤璇佸彿鏍煎紡鏈夎"); } @@ -1109,6 +1110,8 @@ queryWrapper.leftJoin(Company.class,Company::getId,Member::getCompanyId); queryWrapper.selectAll(Member.class) .selectAs(Company::getName,Member::getCompanyName) ; + queryWrapper.selectAs(Position::getName,Member::getPositionName); + queryWrapper.leftJoin(Position.class,Position::getId,Member::getPositionId); if(StringUtils.isNotBlank(member.getName())){ queryWrapper.like(Member::getName,member.getName()); } @@ -1140,6 +1143,8 @@ .eq(Member::getType,Constants.TWO) .exists("select b.id from car_driver b where b.isdeleted=0 and b.member_id=t.id"); + queryWrapper.selectAs(Position::getName,Member::getPositionName); + queryWrapper.leftJoin(Position.class,Position::getId,Member::getPositionId); if(null != member.getType()) { queryWrapper.eq(Member::getType,member.getType()); } @@ -1353,6 +1358,8 @@ queryWrapper.select(" ( select count(1) from member_card mc where mc.isdeleted = 0 and mc.member_id = t.id ) as memberCardCount "); queryWrapper.leftJoin(SystemUser.class,SystemUser::getId,Member::getEditor); queryWrapper.leftJoin(Company.class,Company::getId,Member::getCompanyId); + queryWrapper.selectAs(Position::getName,Member::getPositionName); + queryWrapper.leftJoin(Position.class,Position::getId,Member::getPositionId); queryWrapper.eq(Member::getType,pageWrap.getModel().getType()); // queryWrapper.eq(Objects.nonNull(model.getCompanyId()),Member::getCompanyId,model.getCompanyId()) queryWrapper.in(Objects.nonNull(pageWrap.getModel().getCompanyIds())&&pageWrap.getModel().getCompanyIds().size()>0, @@ -1451,6 +1458,8 @@ queryWrapper.leftJoin(Company.class,Company::getId,Member::getCompanyId); queryWrapper.selectAll(Member.class) .selectAs(Company::getName,Member::getCompanyName) + .selectAs(Position::getName,Member::getPositionName) + .leftJoin(Position.class,Position::getId,Member::getPositionId) .selectAs(Member::getLastVisitDate,Member::getLastVisitDate) .select(" (select count(v.id) from visits v where v.MEMBER_ID=t.id and v.ISDELETED=0 and v.status in (7,8) ) as visitTimes"); queryWrapper.like(StringUtils.isNotBlank(pageWrap.getModel().getName()),Member::getName,pageWrap.getModel().getName()) @@ -1500,6 +1509,8 @@ .eq(Objects.nonNull(pageWrap.getModel().getCode()),Member::getCode,pageWrap.getModel().getCode()) .orderByDesc(Member::getCreateDate); + queryWrapper.selectAs(Position::getName,Member::getPositionName); + queryWrapper.leftJoin(Position.class,Position::getId,Member::getPositionId); IPage<Member> memberIPage = memberJoinMapper.selectJoinPage(page, Member.class,queryWrapper); return PageData.from(memberIPage); @@ -1696,6 +1707,8 @@ .selectAll(Member.class) .selectAs(Company::getName,Member::getCompanyName) .leftJoin(Company.class,Company::getId,Member::getCompanyId) + .selectAs(Position::getName,Member::getPositionName) + .leftJoin(Position.class,Position::getId,Member::getPositionId) .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