From 6e4db32c87234aa6036d88e4b889acaf397ec968 Mon Sep 17 00:00:00 2001
From: dengzedong <dengzedong@email>
Date: 星期四, 23 一月 2025 11:34:30 +0800
Subject: [PATCH] getLastScheduleResult ORDER BY schedule_time desc,create_time desc
---
iailab-module-model/iailab-module-model-biz/src/main/resources/mapper/mcs/StScheduleRecordDao.xml | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/iailab-module-model/iailab-module-model-biz/src/main/resources/mapper/mcs/StScheduleRecordDao.xml b/iailab-module-model/iailab-module-model-biz/src/main/resources/mapper/mcs/StScheduleRecordDao.xml
index 406a330..3e75434 100644
--- a/iailab-module-model/iailab-module-model-biz/src/main/resources/mapper/mcs/StScheduleRecordDao.xml
+++ b/iailab-module-model/iailab-module-model-biz/src/main/resources/mapper/mcs/StScheduleRecordDao.xml
@@ -4,7 +4,7 @@
<select id="getLastScheduleResult" resultType="com.iailab.module.model.api.mdk.dto.StScheduleRecordVO">
SELECT t2.* FROM t_st_schedule_scheme t1 LEFT JOIN t_st_schedule_record t2 on t1.id = t2.scheme_id
WHERE t1.`code` = #{scheduleCode} AND result_code = "100"
- ORDER BY t2.schedule_time desc
+ ORDER BY t2.schedule_time desc,create_time desc
LIMIT #{limit}
</select>
</mapper>
\ No newline at end of file
--
Gitblit v1.9.3