From 6a972c54fe99a186b5885db1b1319643ce9679dd Mon Sep 17 00:00:00 2001
From: shinnosuke <tantao@1hoper.com>
Date: 星期三, 26 八月 2026 18:43:38 +0800
Subject: [PATCH] 又又更新
---
talent-card-server/src/main/java/com/talentcard/server/mapper/TransportParkingCardLevelRightMapper.java | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/talent-card-server/src/main/java/com/talentcard/server/mapper/TransportParkingCardLevelRightMapper.java b/talent-card-server/src/main/java/com/talentcard/server/mapper/TransportParkingCardLevelRightMapper.java
index de2ce92..dde2a43 100644
--- a/talent-card-server/src/main/java/com/talentcard/server/mapper/TransportParkingCardLevelRightMapper.java
+++ b/talent-card-server/src/main/java/com/talentcard/server/mapper/TransportParkingCardLevelRightMapper.java
@@ -43,7 +43,7 @@
and (#{cardLevel} is null or #{cardLevel} = '' or r.card_level = #{cardLevel})
and (#{enabled} is null or r.enabled = #{enabled})
and (#{keyword} is null or #{keyword} = '' or m.merchant_name like concat('%', #{keyword}, '%') or m.address like concat('%', #{keyword}, '%'))
- order by m.sort_no desc, m.id desc,
+ order by m.sort_no desc, m.created_at desc, m.id desc,
case r.card_level when '卓越人才卡' then 1 when '杰出人才卡' then 2 when '菁英人才卡' then 3 else 99 end
limit #{size} offset #{offset}
""")
@@ -132,7 +132,7 @@
and r.status = 1
and r.card_level = #{cardLevel}
and (#{merchantId} is null or r.merchant_id = #{merchantId})
- order by m.sort_no desc, m.id desc
+ order by m.sort_no desc, m.created_at desc, m.id desc
""")
List<Map<String, Object>> selectAvailableForCard(@Param("cardLevel") String cardLevel, @Param("merchantId") Long merchantId);
}
--
Gitblit v1.7.1