From 366e24749a240359efe3f421eb43f31ce1f36e36 Mon Sep 17 00:00:00 2001
From: yeg <1347747024@qq.com>
Date: 星期日, 30 八月 2026 00:05:17 +0800
Subject: [PATCH] 修复接收通道状态字段映射

---
 ruoyi-admin/src/test/java/com/ruoyi/config/TestDeviceBindingMapperContractTest.java |    5 ++++-
 ruoyi-system/src/main/resources/mapper/system/TTestMapper.xml                       |    9 +++++----
 2 files changed, 9 insertions(+), 5 deletions(-)

diff --git a/ruoyi-admin/src/test/java/com/ruoyi/config/TestDeviceBindingMapperContractTest.java b/ruoyi-admin/src/test/java/com/ruoyi/config/TestDeviceBindingMapperContractTest.java
index f0ddad8..d3538af 100644
--- a/ruoyi-admin/src/test/java/com/ruoyi/config/TestDeviceBindingMapperContractTest.java
+++ b/ruoyi-admin/src/test/java/com/ruoyi/config/TestDeviceBindingMapperContractTest.java
@@ -23,7 +23,10 @@
         assertTrue(mapper.contains("reception_status = 'NOT_STARTED'"));
         assertTrue(mapper.contains("channel_count channelCount"));
         assertTrue(mapper.contains("id=\"selectBatteryNosByTestIds\""));
-        assertTrue(mapper.contains("select channel_fact.channel_id, channel_fact.adapter_id"));
+        assertTrue(mapper.contains("channel_fact.channel_id channelId"));
+        assertTrue(mapper.contains("id=\"selectReceptionChannelForUpdate\""));
+        assertTrue(mapper.contains("channel_fact.online_status onlineStatus"));
+        assertTrue(mapper.contains("channel_fact.last_seen_at_utc lastSeenAtUtc"));
         assertFalse(mapper.contains("group_concat"));
     }
 
diff --git a/ruoyi-system/src/main/resources/mapper/system/TTestMapper.xml b/ruoyi-system/src/main/resources/mapper/system/TTestMapper.xml
index fa02411..d432575 100644
--- a/ruoyi-system/src/main/resources/mapper/system/TTestMapper.xml
+++ b/ruoyi-system/src/main/resources/mapper/system/TTestMapper.xml
@@ -351,10 +351,11 @@
     </insert>
 
     <select id="selectReceptionChannelForUpdate" parameterType="Long" resultType="com.ruoyi.system.domain.TDetectionChannel">
-        select channel_fact.channel_id, channel_fact.adapter_id, channel_fact.cabinet_id,
-               channel_fact.devtype, channel_fact.devid, channel_fact.subdevid, channel_fact.chlid,
-               channel_fact.display_no, channel_fact.online_status, channel_fact.work_status,
-               channel_fact.last_seen_at_utc, channel_fact.status
+        select channel_fact.channel_id channelId, channel_fact.adapter_id adapterId, channel_fact.cabinet_id cabinetId,
+               channel_fact.devtype devtype, channel_fact.devid devid, channel_fact.subdevid subdevid,
+               channel_fact.chlid chlid, channel_fact.display_no displayNo,
+               channel_fact.online_status onlineStatus, channel_fact.work_status workStatus,
+               channel_fact.last_seen_at_utc lastSeenAtUtc, channel_fact.status status
         from t_detection_channel channel_fact
         join t_detection_cabinet cabinet on cabinet.cabinet_id = channel_fact.cabinet_id
         where channel_fact.channel_id = #{channelId}

--
Gitblit v1.7.1