From e8818935af3b350dc18534e96fd8fa0dde9e3caf Mon Sep 17 00:00:00 2001
From: gongchunyi <deslre0381@gmail.com>
Date: 星期四, 05 三月 2026 14:28:54 +0800
Subject: [PATCH] fix: 投入分析重复计算
---
src/main/resources/mapper/production/ProductionProductInputMapper.xml | 3 ++-
1 files changed, 2 insertions(+), 1 deletions(-)
diff --git a/src/main/resources/mapper/production/ProductionProductInputMapper.xml b/src/main/resources/mapper/production/ProductionProductInputMapper.xml
index 65e2b96..29fc27e 100644
--- a/src/main/resources/mapper/production/ProductionProductInputMapper.xml
+++ b/src/main/resources/mapper/production/ProductionProductInputMapper.xml
@@ -42,7 +42,8 @@
SELECT
DATE_FORMAT(ppi.create_time, '%Y-%m-%d') AS date,
-- 鎶ュ伐鏁伴噺 * 鏈�灏忕郴鏁�
- SUM(ppi.quantity * IFNULL(distinct_ps.unit_quantity, 1)) AS quantity
+ # SUM(ppi.quantity * IFNULL(distinct_ps.unit_quantity, 1)) AS quantity
+ SUM(ppi.quantity) AS quantity
FROM production_product_input ppi
INNER JOIN production_product_main ppm ON ppm.id = ppi.product_main_id
INNER JOIN product_process_route_item ppri ON ppri.id = ppm.product_process_route_item_id
--
Gitblit v1.9.3