From d06a1424f108c9b321a268b53918bba0a569e7bc Mon Sep 17 00:00:00 2001
From: ‘liusuyi’ <1951119284@qq.com>
Date: 星期三, 13 九月 2023 13:02:55 +0800
Subject: [PATCH] 修改外联历史报警按alarm_time逆序返回数据 修改门禁历史报警按alarm_time逆序返回数据 修改app一键历史报警按create_time逆序返回数据
---
ard-work/src/main/resources/mapper/alarm/ArdAlarmAccessMapper.xml | 1 +
ard-work/src/main/resources/mapper/alarm/ArdAlarmApponekeyMapper.xml | 1 +
ard-work/src/main/resources/mapper/alarm/ArdAlarmExternalMapper.xml | 1 +
3 files changed, 3 insertions(+), 0 deletions(-)
diff --git a/ard-work/src/main/resources/mapper/alarm/ArdAlarmAccessMapper.xml b/ard-work/src/main/resources/mapper/alarm/ArdAlarmAccessMapper.xml
index f02b6c3..3f246dc 100644
--- a/ard-work/src/main/resources/mapper/alarm/ArdAlarmAccessMapper.xml
+++ b/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">
diff --git a/ard-work/src/main/resources/mapper/alarm/ArdAlarmApponekeyMapper.xml b/ard-work/src/main/resources/mapper/alarm/ArdAlarmApponekeyMapper.xml
index d6fc8f8..c047dc5 100644
--- a/ard-work/src/main/resources/mapper/alarm/ArdAlarmApponekeyMapper.xml
+++ b/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">
diff --git a/ard-work/src/main/resources/mapper/alarm/ArdAlarmExternalMapper.xml b/ard-work/src/main/resources/mapper/alarm/ArdAlarmExternalMapper.xml
index 636a8e5..0325f29 100644
--- a/ard-work/src/main/resources/mapper/alarm/ArdAlarmExternalMapper.xml
+++ b/ard-work/src/main/resources/mapper/alarm/ArdAlarmExternalMapper.xml
@@ -53,6 +53,7 @@
AND alarm_time <= 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">
--
Gitblit v1.9.3