From 501aead9955b65d956f746f0ec2a480d87b4caf5 Mon Sep 17 00:00:00 2001
From: zhang_nuo <zhang_12370@163.com>
Date: 星期二, 15 九月 2026 01:23:17 +0800
Subject: [PATCH] fix(sales): 修正发货率统计逻辑
---
src/main/java/com/ruoyi/sales/service/impl/MetricStatisticsServiceImpl.java | 11 ++---------
src/main/java/com/ruoyi/sales/mapper/SalesLedgerMapper.java | 5 +++--
2 files changed, 5 insertions(+), 11 deletions(-)
diff --git a/src/main/java/com/ruoyi/sales/mapper/SalesLedgerMapper.java b/src/main/java/com/ruoyi/sales/mapper/SalesLedgerMapper.java
index 0270328..63d77e6 100644
--- a/src/main/java/com/ruoyi/sales/mapper/SalesLedgerMapper.java
+++ b/src/main/java/com/ruoyi/sales/mapper/SalesLedgerMapper.java
@@ -67,11 +67,12 @@
"COUNT(DISTINCT sl.id) AS order_count, " + // 鎬昏鍗曟暟
"SUM(slp.tax_inclusive_total_price) AS sales_amount, " + // 閿�鍞
"SUM(IFNULL(slp.quantity, 0)) AS product_quantity, " + // 浜у搧閿�鍞暟閲�
- // 鍙戣揣鐜� = 鍙戣揣璁㈠崟鏁� * 100 / 鎬昏鍗曟暟锛堜繚鐣�2浣嶅皬鏁帮紝閬垮厤闄�0鎶ラ敊锛�
+ // 鍙戣揣鐜� = 鏈夊彂璐ц褰曠殑璁㈠崟鏁� / 鎬昏鍗曟暟 * 100锛堜繚鐣�2浣嶅皬鏁帮紝閬垮厤闄�0鎶ラ敊锛�
"ROUND(IF(COUNT(DISTINCT sl.id) = 0, 0, " +
- "SUM(CASE WHEN slp.approve_status = 2 THEN 1 ELSE 0 END) / COUNT(DISTINCT sl.id) * 100), 2) AS ship_rate " +
+ "COUNT(DISTINCT CASE WHEN si.id IS NOT NULL THEN sl.id END) / COUNT(DISTINCT sl.id) * 100), 2) AS ship_rate " +
"FROM sales_ledger sl " +
"LEFT JOIN sales_ledger_product slp ON sl.id = slp.sales_ledger_id " +
+ "LEFT JOIN shipping_info si ON sl.id = si.sales_ledger_id " +
"WHERE sl.entry_date >= DATE_FORMAT(#{statisticsTableDto.entryDateStart}, '%Y-%m-01') " +
"AND sl.entry_date <= LAST_DAY(#{statisticsTableDto.entryDateEnd}) " +
// 浜у搧澶х被绛涢��
diff --git a/src/main/java/com/ruoyi/sales/service/impl/MetricStatisticsServiceImpl.java b/src/main/java/com/ruoyi/sales/service/impl/MetricStatisticsServiceImpl.java
index 2ceec4e..1bb819a 100644
--- a/src/main/java/com/ruoyi/sales/service/impl/MetricStatisticsServiceImpl.java
+++ b/src/main/java/com/ruoyi/sales/service/impl/MetricStatisticsServiceImpl.java
@@ -69,17 +69,10 @@
.filter(p -> p.getId() != null && p.getSalesLedgerId() != null)
.collect(Collectors.toMap(SalesLedgerProduct::getId, SalesLedgerProduct::getSalesLedgerId, (k1, k2) -> k1));
- List<ShippingInfo> shippingInfos = shippingInfoMapper.selectList(new LambdaQueryWrapper<ShippingInfo>()
- .eq(ShippingInfo::getStatus, "瀹℃牳閫氳繃"));
+ List<ShippingInfo> shippingInfos = shippingInfoMapper.selectList(null);
long shippedOrderCount = shippingInfos.stream()
- .filter(info -> productIdToLedgerIdMap.containsKey(info.getSalesLedgerProductId()))
- .map(info -> {
- if (info.getSalesLedgerId() != null) {
- return info.getSalesLedgerId();
- }
- return productIdToLedgerIdMap.get(info.getSalesLedgerProductId());
- })
+ .map(ShippingInfo::getSalesLedgerId)
.filter(Objects::nonNull)
.distinct()
.count();
--
Gitblit v1.9.3