修复接收通道状态字段映射

yeg

2026-08-30 366e24749a240359efe3f421eb43f31ce1f36e36

修复接收通道状态字段映射

 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"));
    }


 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}