From e2f8fb1fbe26ba6d92f3e5dfcaeb0c69abe76b25 Mon Sep 17 00:00:00 2001
From: jiangping <jp@doumee.com>
Date: 星期四, 14 十二月 2023 14:28:57 +0800
Subject: [PATCH] 海康接口对接开发

---
 server/dmvisit_service/src/main/java/com/doumee/service/business/impl/RetentionServiceImpl.java |   21 ++++++++-------------
 1 files changed, 8 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..14d23b5 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
@@ -21,6 +21,7 @@
 import org.springframework.stereotype.Service;
 import org.springframework.util.CollectionUtils;
 
+import java.util.Date;
 import java.util.List;
 import java.util.Objects;
 
@@ -197,27 +198,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().getStartTime());
         queryWrapper.orderByDesc(Retention::getCreateDate);
         IPage<Retention> retentionIPage = retentionJoinMapper.selectJoinPage(page, Retention.class, queryWrapper);
         return PageData.from(retentionIPage);

--
Gitblit v1.9.3