From 8d590f68b15baac8eecd2625b548a3fefece4f71 Mon Sep 17 00:00:00 2001 From: jiangping <jp@doumee.com> Date: 星期四, 14 十二月 2023 11:54:06 +0800 Subject: [PATCH] 海康接口对接开发 --- server/dmvisit_service/src/main/java/com/doumee/service/business/impl/RetentionServiceImpl.java | 20 +++++++------------- 1 files changed, 7 insertions(+), 13 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 6339165..f2006a3 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 @@ -197,27 +197,21 @@ IPage<Retention> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); MPJLambdaWrapper<Retention> queryWrapper = new MPJLambdaWrapper<>(); Utils.MP.blankToNull(pageWrap.getModel()); - queryWrapper.leftJoin(Company.class,Company::getId,Retention::getId) - .leftJoin(Member.class,Member::getId,Retention::getMemberId) - .leftJoin(DeviceEvent.class,DeviceEvent::getEventId,Retention::getEventCode); + queryWrapper.leftJoin(Company.class,Company::getId,Retention::getId); queryWrapper.selectAll(Retention.class) - .selectAs(Company::getName,Retention::getCompanyName) - .selectAs(Member::getType,Retention::getMemberType) - .selectAs(DeviceEvent::getSrcName,Retention::getSrcName); - queryWrapper.like(number,Member::getPhone,pageWrap.getModel().getKeyWords()) - .like((b||hasWord),Member::getName,pageWrap.getModel().getKeyWords()) + .selectAs(Company::getName,Retention::getCompanyName); + queryWrapper.like(number,Retention::getPhone,pageWrap.getModel().getKeyWords()) + .like((b||hasWord),Retention::getName,pageWrap.getModel().getKeyWords()) .eq(Objects.nonNull(pageWrap.getModel().getType()), - Member::getType, + Retention::getType, pageWrap.getModel().getType()) .like(StringUtils.isNotBlank(pageWrap.getModel().getCompanyName()), Company::getName, pageWrap.getModel().getCompanyName()) .ge(Objects.nonNull(pageWrap.getModel().getStartTime()), - Retention::getEventDate, - Utils.Date.getStart(pageWrap.getModel().getStartTime())) + Retention::getEventDate, pageWrap.getModel().getStartTime()) .le(Objects.nonNull(pageWrap.getModel().getEndTime()), - Retention::getEventDate, - Utils.Date.getDayEnd(pageWrap.getModel().getEndTime())); + Retention::getEventDate, pageWrap.getModel().getEndTime()); queryWrapper.orderByDesc(Retention::getCreateDate); IPage<Retention> retentionIPage = retentionJoinMapper.selectJoinPage(page, Retention.class, queryWrapper); return PageData.from(retentionIPage); -- Gitblit v1.9.3