From 70ea0911ce7519ca802266078624e9fed3559a2c Mon Sep 17 00:00:00 2001
From: yeg <1347747024@qq.com>
Date: 星期五, 18 九月 2026 14:05:13 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/main'
---
talent-card-server/src/test/java/com/talentcard/server/business/admin/AdminBusinessServiceTests.java | 14 ++++++++++++++
1 files changed, 14 insertions(+), 0 deletions(-)
diff --git a/talent-card-server/src/test/java/com/talentcard/server/business/admin/AdminBusinessServiceTests.java b/talent-card-server/src/test/java/com/talentcard/server/business/admin/AdminBusinessServiceTests.java
index e98e072..3459405 100644
--- a/talent-card-server/src/test/java/com/talentcard/server/business/admin/AdminBusinessServiceTests.java
+++ b/talent-card-server/src/test/java/com/talentcard/server/business/admin/AdminBusinessServiceTests.java
@@ -42,4 +42,18 @@
void supportsMerchantAppLoginForHotelMerchants() {
assertThat(service.supportsMerchantAppLogin("酒店服务")).isTrue();
}
+
+ @Test
+ void productSalesCountComesFromValidOrders() {
+ // 商品表上的 sales_count 只有部分流程会累加，销量必须按有效订单算，否则后台列表一直是空的。
+ String salesSelect = service.salesCountSelect("r.product_id", "p");
+
+ assertThat(salesSelect)
+ .contains("greatest")
+ .contains("from benefit_order bo")
+ .contains("bo.product_id = r.product_id")
+ .contains("bo.order_status = 1")
+ .contains("bo.refund_status is null or bo.refund_status = 0")
+ .endsWith("as sales_count");
+ }
}
--
Gitblit v1.7.1