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/DeviceEventServiceImpl.java | 29 +++++++++++++---------------- 1 files changed, 13 insertions(+), 16 deletions(-) diff --git a/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/DeviceEventServiceImpl.java b/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/DeviceEventServiceImpl.java index a136eea..6b0577f 100644 --- a/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/DeviceEventServiceImpl.java +++ b/server/dmvisit_service/src/main/java/com/doumee/service/business/impl/DeviceEventServiceImpl.java @@ -206,11 +206,11 @@ if (pageWrap.getModel().getExtEventRoleID() != null) { queryWrapper.lambda().eq(DeviceEvent::getExtEventRoleID, pageWrap.getModel().getExtEventRoleID()); } - if (pageWrap.getModel().getExtEventSubDevID() != null) { - queryWrapper.lambda().eq(DeviceEvent::getExtEventSubDevID, pageWrap.getModel().getExtEventSubDevID()); + if (pageWrap.getModel().getExtEventEubDevID() != null) { + queryWrapper.lambda().eq(DeviceEvent::getExtEventEubDevID, pageWrap.getModel().getExtEventEubDevID()); } - if (pageWrap.getModel().getExtEventSwipNum() != null) { - queryWrapper.lambda().eq(DeviceEvent::getExtEventSwipNum, pageWrap.getModel().getExtEventSwipNum()); + if (pageWrap.getModel().getExtEventEwipNum() != null) { + queryWrapper.lambda().eq(DeviceEvent::getExtEventEwipNum, pageWrap.getModel().getExtEventEwipNum()); } if (pageWrap.getModel().getExtEventType() != null) { queryWrapper.lambda().eq(DeviceEvent::getExtEventType, pageWrap.getModel().getExtEventType()); @@ -286,7 +286,7 @@ } @Override - public PageData<DeviceEventDTO> findDeviceEventDTOPage(PageWrap<DeviceEventQuery> pageWrap) { + public PageData<DeviceEventDTO> findDeviceEventDTOPage(PageWrap<DeviceEvent> pageWrap) { IPage<DeviceEvent> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity()); MPJLambdaWrapper<DeviceEvent> queryWrapper = new MPJLambdaWrapper<>(); @@ -298,19 +298,16 @@ boolean b = Validator.hasChinese(pageWrap.getModel().getKeyWords()); //鏄惁鍖呭惈鑻辨枃 boolean hasWord = ReUtil.contains(PatternPool.WORD, pageWrap.getModel().getKeyWords()); - queryWrapper.leftJoin(Member.class,Member::getId,DeviceEvent::getExtEventPersonNo) + queryWrapper.leftJoin(Member.class,Member::getHkId,DeviceEvent::getExtEventPersonNo) .leftJoin(Company.class,Company::getId,Member::getCompanyId) .selectAll(DeviceEvent.class) .selectAs(Member::getName,DeviceEventDTO::getPersonName) + .selectAs(Member::getType,DeviceEventDTO::getPersonType) .selectAs(Member::getPhone,DeviceEventDTO::getPersonPhone) .selectAs(Member::getIdcardDecode,DeviceEventDTO::getPersonIdcardDecode) .selectAs(Company::getName,DeviceEventDTO::getPersonCompanyName); - queryWrapper.like(number, - Member::getPhone, - pageWrap.getModel().getKeyWords()) - .like((b||hasWord), - Member::getName, - pageWrap.getModel().getKeyWords()) + queryWrapper.like(number, Member::getPhone, pageWrap.getModel().getKeyWords()) + .like((b||hasWord),Member::getName, pageWrap.getModel().getKeyWords()) .eq(StringUtils.isNotBlank(pageWrap.getModel().getPersonType()), Member::getType, pageWrap.getModel().getPersonType()) @@ -319,11 +316,11 @@ pageWrap.getModel().getEventType()) .ge(Objects.nonNull(pageWrap.getModel().getStartTime()), DeviceEvent::getCreateDate, - Utils.Date.getStart(pageWrap.getModel().getStartTime())) - .le(Objects.nonNull(pageWrap.getModel().getStartTime()), + pageWrap.getModel().getStartTime()) + .le(Objects.nonNull(pageWrap.getModel().getEndTime()), DeviceEvent::getCreateDate, - Utils.Date.getDayEnd(pageWrap.getModel().getEndTime())); - + pageWrap.getModel().getEndTime()); + queryWrapper.orderByDesc(DeviceEvent::getHappenTime); IPage<DeviceEventDTO> deviceEventDTOIPage = deviceEventJoinMapper.selectJoinPage(page, DeviceEventDTO.class, queryWrapper); return PageData.from(deviceEventDTOIPage); } -- Gitblit v1.9.3