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/business/order/OrderService.java | 6 +++---
1 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/talent-card-server/src/main/java/com/talentcard/server/business/order/OrderService.java b/talent-card-server/src/main/java/com/talentcard/server/business/order/OrderService.java
index 10470e9..bf51ee3 100644
--- a/talent-card-server/src/main/java/com/talentcard/server/business/order/OrderService.java
+++ b/talent-card-server/src/main/java/com/talentcard/server/business/order/OrderService.java
@@ -251,7 +251,7 @@
left join benefit b on b.id = r.benefit_id
left join merchant_product p on p.id = o.product_id and p.deleted = 0
left join merchant m on m.id = r.merchant_id
- """.formatted(ORDER_CARD_LEVEL_SQL) + where + " order by r.id desc limit ? offset ?", pageArgs.toArray());
+ """.formatted(ORDER_CARD_LEVEL_SQL) + where + " order by r.created_at desc, r.id desc limit ? offset ?", pageArgs.toArray());
Long total = jdbcTemplate.queryForObject("""
select count(*)
from order_refund r
@@ -327,7 +327,7 @@
left join talent_card tc on tc.id = r.card_id
left join benefit b on b.id = r.benefit_id
left join merchant m on m.id = r.merchant_id
- """.formatted(ORDER_CARD_LEVEL_SQL) + where + " order by r.id desc limit ? offset ?", pageArgs.toArray());
+ """.formatted(ORDER_CARD_LEVEL_SQL) + where + " order by r.verify_time desc, r.id desc limit ? offset ?", pageArgs.toArray());
Long total = jdbcTemplate.queryForObject("""
select count(*)
from verify_record r
@@ -427,7 +427,7 @@
left join benefit b on b.id = o.benefit_id
left join merchant_product p on p.id = o.product_id and p.deleted = 0
left join merchant m on m.id = o.merchant_id
- """.formatted(ORDER_CARD_LEVEL_SQL) + where + " order by o.id desc limit ? offset ?", pageArgs.toArray());
+ """.formatted(ORDER_CARD_LEVEL_SQL) + where + " order by o.created_at desc, o.id desc limit ? offset ?", pageArgs.toArray());
Long total = jdbcTemplate.queryForObject("""
select count(*)
from benefit_order o
--
Gitblit v1.7.1