From 0dcc14943b6dcaecf56597ed149e61da997be8e5 Mon Sep 17 00:00:00 2001
From: gongchunyi <deslre0381@gmail.com>
Date: 星期五, 20 三月 2026 09:29:54 +0800
Subject: [PATCH] fix: BOM的单位产出需要数量精度修改、返回单位取消产品表绑定
---
doc/宁夏-中盛建材.sql | 6 +++++-
src/main/resources/mapper/production/ProductStructureMapper.xml | 2 +-
2 files changed, 6 insertions(+), 2 deletions(-)
diff --git "a/doc/\345\256\201\345\244\217-\344\270\255\347\233\233\345\273\272\346\235\220.sql" "b/doc/\345\256\201\345\244\217-\344\270\255\347\233\233\345\273\272\346\235\220.sql"
index 3c9a4af..d9c5e24 100644
--- "a/doc/\345\256\201\345\244\217-\344\270\255\347\233\233\345\273\272\346\235\220.sql"
+++ "b/doc/\345\256\201\345\244\217-\344\270\255\347\233\233\345\273\272\346\235\220.sql"
@@ -423,4 +423,8 @@
ADD COLUMN `param_format` varchar(255) DEFAULT NULL COMMENT '鍙傛暟鏍煎紡',
ADD COLUMN `value_mode` tinyint DEFAULT '1' COMMENT '鍊兼ā寮�(1鍗曞�� 2鍖洪棿)',
ADD COLUMN `unit` varchar(50) DEFAULT NULL COMMENT '鍗曚綅',
- ADD COLUMN `remark` varchar(255) DEFAULT NULL COMMENT '澶囨敞';
\ No newline at end of file
+ ADD COLUMN `remark` varchar(255) DEFAULT NULL COMMENT '澶囨敞';
+
+ALTER TABLE `product-inventory-management-zsjc`.`product_structure`
+ MODIFY COLUMN `unit_quantity` decimal(20, 15) NOT NULL COMMENT '鍗曚綅浜у嚭闇�瑕佹暟閲�' AFTER `process_id`,
+ MODIFY COLUMN `demanded_quantity` decimal(20, 15) NULL DEFAULT NULL COMMENT '闇�姹傛暟閲�' AFTER `unit_quantity`,
\ No newline at end of file
diff --git a/src/main/resources/mapper/production/ProductStructureMapper.xml b/src/main/resources/mapper/production/ProductStructureMapper.xml
index 18a4f89..f8ab02b 100644
--- a/src/main/resources/mapper/production/ProductStructureMapper.xml
+++ b/src/main/resources/mapper/production/ProductStructureMapper.xml
@@ -20,7 +20,7 @@
ps.process_id,
pp.name AS process_name,
pm.product_name AS productName,
- pm.unit,
+ ps.unit,
pms.model
FROM product_structure ps
--
Gitblit v1.9.3