From ad5db85e540947e82c7a4d5612879b3b3ecdf459 Mon Sep 17 00:00:00 2001
From: liujie <1793218484@qq.com>
Date: 星期五, 21 八月 2026 10:38:07 +0800
Subject: [PATCH] update
---
backend/src/main/java/com/tourguide/modules/order/mapper/TourOrderMapper.java | 16 ++++++++++++++++
1 files changed, 16 insertions(+), 0 deletions(-)
diff --git a/backend/src/main/java/com/tourguide/modules/order/mapper/TourOrderMapper.java b/backend/src/main/java/com/tourguide/modules/order/mapper/TourOrderMapper.java
index 12767f6..cea1a02 100644
--- a/backend/src/main/java/com/tourguide/modules/order/mapper/TourOrderMapper.java
+++ b/backend/src/main/java/com/tourguide/modules/order/mapper/TourOrderMapper.java
@@ -56,6 +56,22 @@
"AND scenic_name IS NOT NULL AND scenic_name <> '' ORDER BY scenic_name")
List<String> selectGuideEarningScenics(Long guideId);
+ @Select("SELECT id FROM tour_order WHERE deleted = 0 AND status = 'COMPLETED' " +
+ "AND settled_at IS NULL AND settlement_due_at IS NOT NULL " +
+ "AND settlement_due_at <= #{now} AND guide_id IS NOT NULL " +
+ "AND guide_earning_amount IS NOT NULL " +
+ "AND (refund_status IS NULL OR refund_status <> 'REFUNDED') " +
+ "ORDER BY settlement_due_at, id LIMIT #{limit}")
+ List<Long> selectDueSettlementIds(@Param("now") LocalDateTime now, @Param("limit") int limit);
+
+ @Update("UPDATE tour_order SET status = 'COMPLETED', completed_at = #{completedAt}, " +
+ "settlement_due_at = TIMESTAMPADD(DAY, COALESCE(settlement_days, 1), #{completedAt}), " +
+ "updated_at = NOW() WHERE guide_id = #{guideId} AND receiving_session_id = #{sessionId} " +
+ "AND deleted = 0 AND status = 'IN_SERVICE'")
+ int completeSessionOrders(@Param("guideId") Long guideId,
+ @Param("sessionId") Long sessionId,
+ @Param("completedAt") LocalDateTime completedAt);
+
@Update("UPDATE tour_order SET status = 'CANCELLED', refund_status = 'REFUNDING', updated_at = NOW() " +
"WHERE id = #{id} AND deleted = 0 AND status = 'PENDING_ACCEPT' " +
"AND payment_time IS NOT NULL AND (refund_status IS NULL OR refund_status = 'NONE')")
--
Gitblit v1.7.1