From 5a4da0dd1db1727a039bbefc40551525eff6d0fb Mon Sep 17 00:00:00 2001
From: shinnosuke <tantao@1hoper.com>
Date: 星期四, 17 九月 2026 19:16:46 +0800
Subject: [PATCH] 更新....
---
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