From f02d0df2f1dfc7a8b775cf50d45375e57628a5ef Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期二, 10 十一月 2026 11:26:22 +0800
Subject: [PATCH] feat(ncr): 完善NCR处置联动逻辑与关闭校验

---
 yudao-module-mes/src/test/resources/sql/create_tables.sql |    4 ++++
 1 files changed, 4 insertions(+), 0 deletions(-)

diff --git a/yudao-module-mes/src/test/resources/sql/create_tables.sql b/yudao-module-mes/src/test/resources/sql/create_tables.sql
index f88c563..5dcf69b 100644
--- a/yudao-module-mes/src/test/resources/sql/create_tables.sql
+++ b/yudao-module-mes/src/test/resources/sql/create_tables.sql
@@ -353,6 +353,7 @@
     "expire_date" timestamp DEFAULT NULL,
     "lot_number" varchar(128) DEFAULT NULL,
     "quality_status" int DEFAULT NULL,
+    "ncr_disposition_id" bigint DEFAULT NULL,
     "remark" varchar(500) DEFAULT NULL,
     "creator" varchar(64) DEFAULT '',
     "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
@@ -475,6 +476,7 @@
 CREATE TABLE IF NOT EXISTS "mes_wm_product_sales_line" (
     "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
     "sales_id" bigint NOT NULL,
+    "sale_order_item_id" bigint DEFAULT NULL,
     "notice_line_id" bigint DEFAULT NULL,
     "item_id" bigint NOT NULL,
     "quantity" decimal(20,6) NOT NULL,
@@ -484,6 +486,7 @@
     "oqc_check_flag" tinyint DEFAULT NULL,
     "oqc_id" bigint DEFAULT NULL,
     "quality_status" int DEFAULT NULL,
+    "ncr_disposition_id" bigint DEFAULT NULL,
     "remark" varchar(500) DEFAULT NULL,
     "creator" varchar(64) DEFAULT '',
     "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
@@ -508,6 +511,7 @@
     "rqc_id" bigint DEFAULT NULL,
     "rqc_check_flag" bit NOT NULL DEFAULT FALSE,
     "quality_status" int DEFAULT NULL,
+    "ncr_disposition_id" bigint DEFAULT NULL,
     "remark" varchar(500) DEFAULT '',
     "creator" varchar(64) DEFAULT '',
     "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

--
Gitblit v1.9.3