From 0cf54692efc067adca7fa4308af241f723930b58 Mon Sep 17 00:00:00 2001
From: liujie <1793218484@qq.com>
Date: 星期五, 31 七月 2026 17:54:56 +0800
Subject: [PATCH] update
---
backend/src/main/java/com/tourguide/modules/order/mapper/TourOrderMapper.java | 14 ++++++++++++++
1 files changed, 14 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 614bfac..2ba2d77 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
@@ -3,11 +3,13 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.tourguide.modules.order.entity.TourOrder;
import com.tourguide.modules.order.dto.GuideTodayStatsResponse;
+import com.tourguide.modules.order.dto.VisitorOrderStatRow;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.apache.ibatis.annotations.Param;
import java.math.BigDecimal;
import java.time.LocalDateTime;
+import java.util.Collection;
import java.util.List;
public interface TourOrderMapper extends BaseMapper<TourOrder> {
@@ -23,6 +25,18 @@
@Select("SELECT DISTINCT scenic_name FROM tour_order WHERE deleted = 0 AND scenic_name IS NOT NULL AND scenic_name <> '' ORDER BY scenic_name")
List<String> selectScenicOptions();
+ @Select({
+ "<script>",
+ "SELECT visitor_id AS visitorId, COUNT(*) AS orderCount, ",
+ "COALESCE(SUM(CASE WHEN status NOT IN ('PENDING_PAYMENT', 'CANCELLED', 'REFUNDED') ",
+ "THEN COALESCE(payment_amount, amount) ELSE 0 END), 0) AS totalConsumption ",
+ "FROM tour_order WHERE deleted = 0 AND visitor_id IN ",
+ "<foreach collection='visitorIds' item='visitorId' open='(' separator=',' close=')'>#{visitorId}</foreach>",
+ "GROUP BY visitor_id",
+ "</script>"
+ })
+ List<VisitorOrderStatRow> selectVisitorOrderStats(@Param("visitorIds") Collection<Long> visitorIds);
+
@Select("SELECT COALESCE(SUM(guide_earning_amount), 0) FROM tour_order " +
"WHERE deleted = 0 AND guide_id = #{guideId} AND status = 'COMPLETED' " +
"AND guide_earning_amount IS NOT NULL " +
--
Gitblit v1.7.1