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/review/mapper/OrderReviewMapper.java | 13 +++++++++++++
1 files changed, 13 insertions(+), 0 deletions(-)
diff --git a/backend/src/main/java/com/tourguide/modules/review/mapper/OrderReviewMapper.java b/backend/src/main/java/com/tourguide/modules/review/mapper/OrderReviewMapper.java
index 701d495..a1ca538 100644
--- a/backend/src/main/java/com/tourguide/modules/review/mapper/OrderReviewMapper.java
+++ b/backend/src/main/java/com/tourguide/modules/review/mapper/OrderReviewMapper.java
@@ -2,8 +2,11 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.tourguide.modules.review.entity.OrderReview;
+import com.tourguide.modules.review.dto.VisitorReviewStatRow;
+import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import java.math.BigDecimal;
+import java.util.Collection;
import java.util.List;
public interface OrderReviewMapper extends BaseMapper<OrderReview> {
@@ -13,6 +16,16 @@
@Select("SELECT COUNT(*) FROM tour_order_review WHERE order_id = #{orderId} AND deleted = 0")
long countByOrderId(Long orderId);
+ @Select({
+ "<script>",
+ "SELECT visitor_id AS visitorId, COUNT(*) AS reviewCount ",
+ "FROM tour_order_review WHERE deleted = 0 AND status = 1 AND visitor_id IN ",
+ "<foreach collection='visitorIds' item='visitorId' open='(' separator=',' close=')'>#{visitorId}</foreach>",
+ "GROUP BY visitor_id",
+ "</script>"
+ })
+ List<VisitorReviewStatRow> selectVisitorReviewStats(@Param("visitorIds") Collection<Long> visitorIds);
+
@Select("SELECT COALESCE(AVG(score), 0) FROM tour_order_review WHERE guide_id = #{guideId} AND status = 1 AND deleted = 0")
BigDecimal selectAverageScore(Long guideId);
}
--
Gitblit v1.7.1