From c5cc7da07c7f202f336468c0cd0d2789b4775b03 Mon Sep 17 00:00:00 2001
From: jiangping <jp@doumee.com>
Date: 星期三, 09 十月 2024 11:31:15 +0800
Subject: [PATCH] 最新版本

---
 server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/PlatformEventServiceImpl.java |  111 ++++++++++++++++++++++++++++++++-----------------------
 1 files changed, 65 insertions(+), 46 deletions(-)

diff --git a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/PlatformEventServiceImpl.java b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/PlatformEventServiceImpl.java
index cddc0f2..1b631ea 100644
--- a/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/PlatformEventServiceImpl.java
+++ b/server/visits/dmvisit_service/src/main/java/com/doumee/service/business/impl/PlatformEventServiceImpl.java
@@ -1,20 +1,27 @@
 package com.doumee.service.business.impl;
 
+import com.doumee.biz.system.SystemDictDataBiz;
 import com.doumee.core.model.PageData;
 import com.doumee.core.model.PageWrap;
+import com.doumee.core.utils.Constants;
 import com.doumee.core.utils.Utils;
 import com.doumee.dao.business.PlatformEventMapper;
+import com.doumee.dao.business.model.Empower;
+import com.doumee.dao.business.model.Platform;
 import com.doumee.dao.business.model.PlatformEvent;
 import com.doumee.service.business.PlatformEventService;
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
 import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.github.yulichang.wrapper.MPJLambdaWrapper;
+import org.apache.commons.lang3.StringUtils;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
 import org.springframework.util.CollectionUtils;
 
 import java.util.List;
+import java.util.Objects;
 
 /**
  * 鏈堝彴杞﹁締杩涘嚭浜嬩欢鎺ㄩ�佽褰曡〃Service瀹炵幇
@@ -24,6 +31,8 @@
 @Service
 public class PlatformEventServiceImpl implements PlatformEventService {
 
+    @Autowired
+    private SystemDictDataBiz systemDictDataBiz;
     @Autowired
     private PlatformEventMapper platformEventMapper;
 
@@ -87,129 +96,139 @@
     @Override
     public PageData<PlatformEvent> findPage(PageWrap<PlatformEvent> pageWrap) {
         IPage<PlatformEvent> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
-        QueryWrapper<PlatformEvent> queryWrapper = new QueryWrapper<>();
+        MPJLambdaWrapper<PlatformEvent> queryWrapper = new MPJLambdaWrapper<>();
+        queryWrapper.selectAll(PlatformEvent.class)
+                .selectAs(Platform::getName,PlatformEvent::getPlatformName)
+                .leftJoin(Platform.class, Platform::getId,PlatformEvent::getPlatformId);
         Utils.MP.blankToNull(pageWrap.getModel());
         if (pageWrap.getModel().getId() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getId, pageWrap.getModel().getId());
+            queryWrapper.eq(PlatformEvent::getId, pageWrap.getModel().getId());
         }
         if (pageWrap.getModel().getCreator() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getCreator, pageWrap.getModel().getCreator());
+            queryWrapper.eq(PlatformEvent::getCreator, pageWrap.getModel().getCreator());
         }
         if (pageWrap.getModel().getCreateDate() != null) {
-            queryWrapper.lambda().ge(PlatformEvent::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate()));
-            queryWrapper.lambda().le(PlatformEvent::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate()));
+            queryWrapper.ge(PlatformEvent::getCreateDate, Utils.Date.getStart(pageWrap.getModel().getCreateDate()));
+            queryWrapper.le(PlatformEvent::getCreateDate, Utils.Date.getEnd(pageWrap.getModel().getCreateDate()));
         }
         if (pageWrap.getModel().getEditor() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getEditor, pageWrap.getModel().getEditor());
+            queryWrapper.eq(PlatformEvent::getEditor, pageWrap.getModel().getEditor());
         }
         if (pageWrap.getModel().getEditDate() != null) {
-            queryWrapper.lambda().ge(PlatformEvent::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate()));
-            queryWrapper.lambda().le(PlatformEvent::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate()));
+            queryWrapper.ge(PlatformEvent::getEditDate, Utils.Date.getStart(pageWrap.getModel().getEditDate()));
+            queryWrapper.le(PlatformEvent::getEditDate, Utils.Date.getEnd(pageWrap.getModel().getEditDate()));
         }
         if (pageWrap.getModel().getIsdeleted() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getIsdeleted, pageWrap.getModel().getIsdeleted());
+            queryWrapper.eq(PlatformEvent::getIsdeleted, pageWrap.getModel().getIsdeleted());
         }
         if (pageWrap.getModel().getRemark() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getRemark, pageWrap.getModel().getRemark());
+            queryWrapper.eq(PlatformEvent::getRemark, pageWrap.getModel().getRemark());
         }
         if (pageWrap.getModel().getEventId() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getEventId, pageWrap.getModel().getEventId());
+            queryWrapper.eq(PlatformEvent::getEventId, pageWrap.getModel().getEventId());
         }
         if (pageWrap.getModel().getEventType() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getEventType, pageWrap.getModel().getEventType());
+            queryWrapper.eq(PlatformEvent::getEventType, pageWrap.getModel().getEventType());
         }
         if (pageWrap.getModel().getSrcType() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getSrcType, pageWrap.getModel().getSrcType());
+            queryWrapper.eq(PlatformEvent::getSrcType, pageWrap.getModel().getSrcType());
         }
         if (pageWrap.getModel().getHappenTime() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getHappenTime, pageWrap.getModel().getHappenTime());
+            queryWrapper.eq(PlatformEvent::getHappenTime, pageWrap.getModel().getHappenTime());
         }
         if (pageWrap.getModel().getSrcIndex() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getSrcIndex, pageWrap.getModel().getSrcIndex());
+            queryWrapper.eq(PlatformEvent::getSrcIndex, pageWrap.getModel().getSrcIndex());
         }
         if (pageWrap.getModel().getSrcName() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getSrcName, pageWrap.getModel().getSrcName());
+            queryWrapper.eq(PlatformEvent::getSrcName, pageWrap.getModel().getSrcName());
         }
         if (pageWrap.getModel().getStatus() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getStatus, pageWrap.getModel().getStatus());
+            queryWrapper.eq(PlatformEvent::getStatus, pageWrap.getModel().getStatus());
         }
         if (pageWrap.getModel().getTimeout() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getTimeout, pageWrap.getModel().getTimeout());
+            queryWrapper.eq(PlatformEvent::getTimeout, pageWrap.getModel().getTimeout());
         }
         if (pageWrap.getModel().getDataType() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getDataType, pageWrap.getModel().getDataType());
+            queryWrapper.eq(PlatformEvent::getDataType, pageWrap.getModel().getDataType());
         }
         if (pageWrap.getModel().getSendTime() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getSendTime, pageWrap.getModel().getSendTime());
+            queryWrapper.eq(PlatformEvent::getSendTime, pageWrap.getModel().getSendTime());
         }
         if (pageWrap.getModel().getDateTime() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getDateTime, pageWrap.getModel().getDateTime());
+            queryWrapper.eq(PlatformEvent::getDateTime, pageWrap.getModel().getDateTime());
         }
         if (pageWrap.getModel().getIpAddress() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getIpAddress, pageWrap.getModel().getIpAddress());
+            queryWrapper.eq(PlatformEvent::getIpAddress, pageWrap.getModel().getIpAddress());
         }
         if (pageWrap.getModel().getIpv6Address() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getIpv6Address, pageWrap.getModel().getIpv6Address());
+            queryWrapper.eq(PlatformEvent::getIpv6Address, pageWrap.getModel().getIpv6Address());
         }
         if (pageWrap.getModel().getPortNo() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getPortNo, pageWrap.getModel().getPortNo());
+            queryWrapper.eq(PlatformEvent::getPortNo, pageWrap.getModel().getPortNo());
         }
         if (pageWrap.getModel().getProtocol() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getProtocol, pageWrap.getModel().getProtocol());
+            queryWrapper.eq(PlatformEvent::getProtocol, pageWrap.getModel().getProtocol());
         }
         if (pageWrap.getModel().getMacAddress() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getMacAddress, pageWrap.getModel().getMacAddress());
+            queryWrapper.eq(PlatformEvent::getMacAddress, pageWrap.getModel().getMacAddress());
         }
         if (pageWrap.getModel().getChannelId() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getChannelId, pageWrap.getModel().getChannelId());
+            queryWrapper.eq(PlatformEvent::getChannelId, pageWrap.getModel().getChannelId());
         }
         if (pageWrap.getModel().getActivePostCount() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getActivePostCount, pageWrap.getModel().getActivePostCount());
+            queryWrapper.eq(PlatformEvent::getActivePostCount, pageWrap.getModel().getActivePostCount());
         }
         if (pageWrap.getModel().getEventState() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getEventState, pageWrap.getModel().getEventState());
+            queryWrapper.eq(PlatformEvent::getEventState, pageWrap.getModel().getEventState());
         }
         if (pageWrap.getModel().getEventDescription() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getEventDescription, pageWrap.getModel().getEventDescription());
+            queryWrapper.eq(PlatformEvent::getEventDescription, pageWrap.getModel().getEventDescription());
         }
         if (pageWrap.getModel().getChannelName() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getChannelName, pageWrap.getModel().getChannelName());
+            queryWrapper.like(PlatformEvent::getChannelName, pageWrap.getModel().getChannelName());
         }
         if (pageWrap.getModel().getDeviceId() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getDeviceId, pageWrap.getModel().getDeviceId());
+            queryWrapper.eq(PlatformEvent::getDeviceId, pageWrap.getModel().getDeviceId());
         }
         if (pageWrap.getModel().getHpno() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getHpno, pageWrap.getModel().getHpno());
+            queryWrapper.eq(PlatformEvent::getHpno, pageWrap.getModel().getHpno());
         }
         if (pageWrap.getModel().getMotionStatus() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getMotionStatus, pageWrap.getModel().getMotionStatus());
+            queryWrapper.eq(PlatformEvent::getMotionStatus, pageWrap.getModel().getMotionStatus());
         }
         if (pageWrap.getModel().getPlateNo() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getPlateNo, pageWrap.getModel().getPlateNo());
+            queryWrapper.like(PlatformEvent::getPlateNo, pageWrap.getModel().getPlateNo());
         }
         if (pageWrap.getModel().getVehicleDoorStatus() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getVehicleDoorStatus, pageWrap.getModel().getVehicleDoorStatus());
+            queryWrapper.eq(PlatformEvent::getVehicleDoorStatus, pageWrap.getModel().getVehicleDoorStatus());
         }
         if (pageWrap.getModel().getStockStatus() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getStockStatus, pageWrap.getModel().getStockStatus());
+            queryWrapper.eq(PlatformEvent::getStockStatus, pageWrap.getModel().getStockStatus());
         }
         if (pageWrap.getModel().getPlateScore() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getPlateScore, pageWrap.getModel().getPlateScore());
+            queryWrapper.eq(PlatformEvent::getPlateScore, pageWrap.getModel().getPlateScore());
         }
         if (pageWrap.getModel().getBackgroundImageContent() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getBackgroundImageContent, pageWrap.getModel().getBackgroundImageContent());
+            queryWrapper.eq(PlatformEvent::getBackgroundImageContent, pageWrap.getModel().getBackgroundImageContent());
         }
         if (pageWrap.getModel().getPlatePictureContent() != null) {
-            queryWrapper.lambda().eq(PlatformEvent::getPlatePictureContent, pageWrap.getModel().getPlatePictureContent());
+            queryWrapper.eq(PlatformEvent::getPlatePictureContent, pageWrap.getModel().getPlatePictureContent());
         }
-        for(PageWrap.SortData sortData: pageWrap.getSorts()) {
-            if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) {
-                queryWrapper.orderByDesc(sortData.getProperty());
-            } else {
-                queryWrapper.orderByAsc(sortData.getProperty());
+        queryWrapper.like(StringUtils.isNotBlank(pageWrap.getModel().getPlatformName()), Platform::getName,pageWrap.getModel().getPlatformName());
+        queryWrapper.ge(Objects.nonNull(pageWrap.getModel().getStartDate()), PlatformEvent::getCreateDate,pageWrap.getModel().getStartDate());
+        queryWrapper.le(Objects.nonNull(pageWrap.getModel().getEndDate()),PlatformEvent::getCreateDate,pageWrap.getModel().getEndDate());
+        queryWrapper.orderByDesc(PlatformEvent::getCreateDate);
+        PageData<PlatformEvent> result = PageData.from(platformEventMapper.selectJoinPage(page, PlatformEvent.class,queryWrapper));
+        if(result!=null && result.getRecords()!=null){
+            String prefixUrl = systemDictDataBiz.queryByCode(Constants.FTP,Constants.FTP_RESOURCE_PATH).getCode() +
+                    systemDictDataBiz.queryByCode(Constants.FTP,Constants.MEMBER_IMG).getCode();
+            for(PlatformEvent model : result.getRecords()){
+                if(StringUtils.isNotBlank(model.getBackgroundImageContent())){
+                    model.setBackgroundImageDown(prefixUrl + model.getBackgroundImageContent());
+                }
             }
         }
-        return PageData.from(platformEventMapper.selectPage(page, queryWrapper));
+        return  result;
     }
 
     @Override

--
Gitblit v1.9.3