From aed1ef97d6ae1d3961b9a57c767758c9d34e1b93 Mon Sep 17 00:00:00 2001 From: k94314517 <8417338+k94314517@user.noreply.gitee.com> Date: 星期一, 04 三月 2024 14:01:15 +0800 Subject: [PATCH] ERP接口 --- server/dmvisit_service/src/main/java/com/doumee/service/business/impl/RetentionServiceImpl.java | 15 ++++++++++++--- 1 files changed, 12 insertions(+), 3 deletions(-) diff --git a/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/RetentionServiceImpl.java b/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/RetentionServiceImpl.java index 0f2e09a..df96abb 100644 --- a/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/RetentionServiceImpl.java +++ b/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/RetentionServiceImpl.java @@ -55,7 +55,8 @@ @Override public void deleteById(Integer id) { - retentionMapper.deleteById(id); + retentionMapper.update(null,new UpdateWrapper<Retention>().lambda().set(Retention::getIsdeleted,Constants.ONE).eq(Retention::getId,id)); +// retentionMapper.deleteById(id); } @Override @@ -205,6 +206,13 @@ +dataMap.get(Constants.MEMBER_IMG).getCode() +obj.getFaceImg()); } + if(Objects.nonNull(obj.getType())){ + if(!obj.getType().equals(Constants.memberType.visitor)){ + obj.setExcelCompanyName(obj.getCompanyName()); + }else{ + obj.setExcelCompanyName(obj.getVisitCompanyName()); + } + } }); } return PageData.from(retentionIPage); @@ -256,7 +264,8 @@ queryWrapper.selectAll(Retention.class) .selectAs(Company::getName,Retention::getCompanyName) .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.like(number,Retention::getPhone,pageWrap.getModel().getKeyWords()) + queryWrapper.eq(Retention::getIsdeleted,Constants.ZERO) + .like(number,Retention::getPhone,pageWrap.getModel().getKeyWords()) .like((b||hasWord),Retention::getName,pageWrap.getModel().getKeyWords()) .eq(Objects.nonNull(pageWrap.getModel().getType()), Retention::getType, @@ -268,7 +277,7 @@ .ge(Objects.nonNull(pageWrap.getModel().getStartTime()), Retention::getEventDate,pageWrap.getModel().getStartTime()) .le(Objects.nonNull(pageWrap.getModel().getEndTime()), - Retention::getEventDate,pageWrap.getModel().getStartTime()); + Retention::getEventDate,pageWrap.getModel().getEndTime()); queryWrapper.orderByDesc(Retention::getCreateDate); IPage<Retention> retentionIPage = retentionJoinMapper.selectJoinPage(page, Retention.class, queryWrapper); return retentionIPage; -- Gitblit v1.9.3