修改外联历史报警按alarm_time逆序返回数据 修改门禁历史报警按alarm_time逆序返回数据 修改app一键历史报警按create_time...

‘liusuyi’

2023-09-13 d06a1424f108c9b321a268b53918bba0a569e7bc

修改外联历史报警按alarm_time逆序返回数据
修改门禁历史报警按alarm_time逆序返回数据
修改app一键历史报警按create_time逆序返回数据

 ard-work/src/main/resources/mapper/alarm/ArdAlarmAccessMapper.xml

@@ -33,6 +33,7 @@
        <include refid="selectArdAlarmAccessVo"/>
        <where>  
        </where>
        order by alarm_time desc
    </select>
    
    <select id="selectArdAlarmAccessById" parameterType="String" resultMap="ArdAlarmAccessResult">

 ard-work/src/main/resources/mapper/alarm/ArdAlarmApponekeyMapper.xml

@@ -24,6 +24,7 @@
        <include refid="selectArdAlarmApponekeyVo"/>
        <where>  
        </where>
        order by create_time desc
    </select>
    
    <select id="selectArdAlarmApponekeyById" parameterType="String" resultMap="ArdAlarmApponekeyResult">

 ard-work/src/main/resources/mapper/alarm/ArdAlarmExternalMapper.xml

@@ -53,6 +53,7 @@
                AND alarm_time &lt;= to_timestamp(#{params.endTime},'yyyy-MM-DD HH24:MI:ss')
            </if>
        </where>
        order by alarm_time desc
    </select>

    <select id="selectArdAlarmExternalById" parameterType="String" resultMap="ArdAlarmExternalResult">