From 15fe445c820f28139e4e7e1a4cb286ad6ae37e6e Mon Sep 17 00:00:00 2001
From: liuhaonan <31457034@qq.com>
Date: 星期一, 06 六月 2022 11:05:17 +0800
Subject: [PATCH] bug修复

---
 ximon-admin/src/main/java/com/sandu/ximon/admin/service/PoleService.java |   58 ++++++++++++++++++++++++++++++++++++++++++++++------------
 1 files changed, 46 insertions(+), 12 deletions(-)

diff --git a/ximon-admin/src/main/java/com/sandu/ximon/admin/service/PoleService.java b/ximon-admin/src/main/java/com/sandu/ximon/admin/service/PoleService.java
index 43999d0..4d72f4c 100644
--- a/ximon-admin/src/main/java/com/sandu/ximon/admin/service/PoleService.java
+++ b/ximon-admin/src/main/java/com/sandu/ximon/admin/service/PoleService.java
@@ -16,7 +16,6 @@
 import com.sandu.ximon.admin.dto.DeviceStatus;
 import com.sandu.ximon.admin.dto.WaterQualityDataDto;
 import com.sandu.ximon.admin.manager.iot.frame.A1Frame;
-import com.sandu.ximon.admin.manager.iot.frame.A5Frame;
 import com.sandu.ximon.admin.manager.iot.frame.FrameBuilder;
 import com.sandu.ximon.admin.manager.iot.frame.IRequestFrame;
 import com.sandu.ximon.admin.manager.iot.frame.inner.report.A5AtmosphereHeartbeatReportInnerFrame;
@@ -26,7 +25,6 @@
 import com.sandu.ximon.admin.manager.iot.frame.inner.response.A1DeviceMacRespInnerFrame;
 import com.sandu.ximon.admin.manager.iot.frame.inner.response.A1TernaryCodeRespInnerFrame;
 import com.sandu.ximon.admin.manager.iot.rrpc.dto.CommonFrame;
-import com.sandu.ximon.admin.manager.iot.rrpc.dto.WrapResponseCommonFrame;
 import com.sandu.ximon.admin.manager.iot.rrpc.enums.*;
 import com.sandu.ximon.admin.manager.iot.rrpc.mainboard.MainBoardInvokeSyncService;
 import com.sandu.ximon.admin.param.*;
@@ -40,6 +38,7 @@
 import com.sandu.ximon.admin.vo.PoleBindVO;
 import com.sandu.ximon.dao.bo.*;
 import com.sandu.ximon.dao.domain.*;
+import com.sandu.ximon.dao.enums.OrderByEnums;
 import com.sandu.ximon.dao.mapper.PoleMapper;
 import lombok.AllArgsConstructor;
 import lombok.extern.slf4j.Slf4j;
@@ -175,7 +174,7 @@
         result.put("poleTotalCount", list.size());
 
         //璇虹摝
-        List<LedPlayerEntity> ledPlayerEntities = SpringContextHolder.getBean(LedPlayerEntityService.class).ledPlayerEntityList(null, null);
+        List<LedPlayerEntity> ledPlayerEntities = SpringContextHolder.getBean(LedPlayerEntityService.class).ledPlayerEntityList(null, null, null, null);
         int number = 0;
         for (LedPlayerEntity bean : ledPlayerEntities) {
             if (bean.getOnlineStatus() == 1) {
@@ -190,7 +189,7 @@
         BroadcastTerminalV2Param broadcastTerminalV2Param = new BroadcastTerminalV2Param();
         broadcastTerminalV2Param.setBindingState(2);
         broadcastTerminalV2Param.setWorkState(2);
-        List<BroadcastTerminalV2EntityBo> broadcastTerminalList = SpringContextHolder.getBean(IpVolumeService.class).getBroadcastTerminalList(null, broadcastTerminalV2Param);
+        List<BroadcastTerminalV2EntityBo> broadcastTerminalList = SpringContextHolder.getBean(IpVolumeService.class).getBroadcastTerminalList(null, null, null, broadcastTerminalV2Param);
         for (BroadcastTerminalV2EntityBo bean : broadcastTerminalList) {
             if (bean.getStatus() == 1 || bean.getStatus() == 0) {
                 number++;
@@ -204,9 +203,9 @@
         MonitorParam monitorParam = new MonitorParam();
         monitorParam.setEquipmentState(2);
         monitorParam.setBindingState(2);
-        List<MonitorBo> monitorBos = SpringContextHolder.getBean(MonitorService.class).listMonitorByKeyword(null, monitorParam).getList();
+        List<MonitorBo> monitorBos = SpringContextHolder.getBean(MonitorService.class).listMonitorByKeyword(null, null, null, monitorParam).getList();
         monitorParam.setEquipmentState(1);
-        List<MonitorBo> online = SpringContextHolder.getBean(MonitorService.class).listMonitorByKeyword(null, monitorParam).getList();
+        List<MonitorBo> online = SpringContextHolder.getBean(MonitorService.class).listMonitorByKeyword(null, null, null, monitorParam).getList();
         result.put("monitorOnlineCount", online.size());
         result.put("monitorTotalCount", monitorBos.size());
 
@@ -278,8 +277,8 @@
         result.put("LightPoleHeelingTotalCount", lightPoleHeelings.size());
 
         //鐔欒
-        List<PoleLightemitEntity> poleLightemitEntities = SpringContextHolder.getBean(PoleLightemitService.class).listLed(null, false);
-        List<PoleLightemitEntity> poleLightemitEntityOnlineList = SpringContextHolder.getBean(PoleLightemitService.class).listLed(null, true);
+        List<PoleLightemitEntity> poleLightemitEntities = SpringContextHolder.getBean(PoleLightemitService.class).listLed(null, null, null, false);
+        List<PoleLightemitEntity> poleLightemitEntityOnlineList = SpringContextHolder.getBean(PoleLightemitService.class).listLed(null, null, null, true);
 
         result.put("XiXunOnlineCount", poleLightemitEntityOnlineList.size());
         result.put("XiXunTotalCount", poleLightemitEntities.size());
@@ -287,16 +286,51 @@
         return result;
     }
 
-    public CommonPage queryAllStatesAndList(Integer pageNo, Integer pageSize, PoleStatesParam param) {
+    public CommonPage queryAllStatesAndList(Integer pageNo, Integer pageSize, PoleStatesParam param, Integer order, Integer seq) {
         if (param == null) {
             param = new PoleStatesParam();
         }
-        System.out.println(param);
+
+        //鎺掑簭瀛楁
+        String orderByResult = OrderByEnums.POLE_ID.getCode();
+        //姝e簭銆佸�掑彊
+        String orderBySeq = OrderByEnums.ASC.getCode();
+        if (order != null) {
+            switch (order) {
+                case 1:
+                    orderByResult = OrderByEnums.POLE_NAME.getCode();
+                    break;
+                case 2:
+                    orderByResult = OrderByEnums.POLE_ID.getCode();
+                    break;
+                case 3:
+                    orderByResult = OrderByEnums.POLE_CREATE_TIME.getCode();
+                    break;
+                default:
+            }
+        }
+        if (seq != null) {
+            switch (seq) {
+                case 1:
+                    orderBySeq = OrderByEnums.ASC.getCode();
+                    break;
+                case 2:
+                    orderBySeq = OrderByEnums.DESC.getCode();
+                    break;
+                default:
+                    break;
+            }
+        }
+        //鎺掑簭鏂瑰紡
+        String orderBy = "t1." + orderByResult + " " + orderBySeq;
+
         List<Pole> poleList;
         if (SecurityUtils.getClientId() == null) {
-            poleList = poleMapper.queryPoleOnLineStatesList(null, param.getIsTrue(), param.getBingStates(), param.getGroupid(), param.getKeyword());
+            poleList = poleMapper.queryPoleOnLineStatesList(null, param.getIsTrue(),
+                    param.getBingStates(), param.getGroupid(), param.getKeyword(), orderBy);
         } else {
-            poleList = poleMapper.queryPoleOnLineStatesList(SecurityUtils.getUserId(), param.getIsTrue(), param.getBingStates(), param.getGroupid(), param.getKeyword());
+            poleList = poleMapper.queryPoleOnLineStatesList(SecurityUtils.getUserId(),
+                    param.getIsTrue(), param.getBingStates(), param.getGroupid(), param.getKeyword(), orderBy);
         }
 
         List<Pole> PoleResult = isOnLine(poleList, param);

--
Gitblit v1.9.3