From a9d2ef88a2ac9cdc0b07e98e9c3a8ba621cfb1d8 Mon Sep 17 00:00:00 2001
From: gongchunyi <deslre0381@gmail.com>
Date: 星期四, 09 四月 2026 16:11:31 +0800
Subject: [PATCH] feat: 生产订单根据库存数量判断生产,发货与冻结解冻挂钩
---
doc/长治-祥雨远见.sql | 13 ++++++++++++-
1 files changed, 12 insertions(+), 1 deletions(-)
diff --git "a/doc/\351\225\277\346\262\273-\347\245\245\351\233\250\350\277\234\350\247\201.sql" "b/doc/\351\225\277\346\262\273-\347\245\245\351\233\250\350\277\234\350\247\201.sql"
index 8a82d43..8755301 100644
--- "a/doc/\351\225\277\346\262\273-\347\245\245\351\233\250\350\277\234\350\247\201.sql"
+++ "b/doc/\351\225\277\346\262\273-\347\245\245\351\233\250\350\277\234\350\247\201.sql"
@@ -2,4 +2,15 @@
ADD COLUMN `worker_id` bigint NULL COMMENT '鎸囨淳宸ヤ汉ID',
ADD COLUMN `worker_name` varchar(100) NULL COMMENT '鎸囨淳宸ヤ汉濮撳悕',
ADD COLUMN `handover_user_id` bigint NULL COMMENT '浜ゆ帴浜哄憳ID',
- ADD COLUMN `handover_user_name` varchar(100) NULL COMMENT '浜ゆ帴浜哄憳鍚嶇О';
\ No newline at end of file
+ ADD COLUMN `handover_user_name` varchar(100) NULL COMMENT '浜ゆ帴浜哄憳鍚嶇О';
+
+CREATE TABLE `sales_ledger_product_frozen`
+(
+ `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '涓婚敭id',
+ `sales_ledger_product_id` bigint(20) NOT NULL COMMENT '閿�鍞鍗曚骇鍝乮d',
+ `product_model_id` bigint(20) NOT NULL COMMENT '浜у搧瑙勬牸id',
+ `frozen_quantity` decimal(10, 2) NOT NULL DEFAULT '0.00' COMMENT '鍐荤粨鏁伴噺',
+ `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+ PRIMARY KEY (`id`)
+) ENGINE = InnoDB
+ DEFAULT CHARSET = utf8mb4 COMMENT ='閿�鍞骇鍝佸喕缁撳簱瀛樿〃';
--
Gitblit v1.9.3