From 1155b4447464eaaa17121168e9df7b39a87ef9ef Mon Sep 17 00:00:00 2001
From: zss <zss@example.com>
Date: 星期五, 17 四月 2026 09:10:32 +0800
Subject: [PATCH] 不合格字段添加
---
src/main/java/com/ruoyi/quality/pojo/QualityUnqualified.java | 24 ++++++++++++++++++++++++
src/main/resources/mapper/quality/QualityUnqualifiedMapper.xml | 4 ++++
doc/君歌化工.sql | 8 +++++++-
3 files changed, 35 insertions(+), 1 deletions(-)
diff --git "a/doc/\345\220\233\346\255\214\345\214\226\345\267\245.sql" "b/doc/\345\220\233\346\255\214\345\214\226\345\267\245.sql"
index 446d326..4d86380 100644
--- "a/doc/\345\220\233\346\255\214\345\214\226\345\267\245.sql"
+++ "b/doc/\345\220\233\346\255\214\345\214\226\345\267\245.sql"
@@ -16,4 +16,10 @@
ADD COLUMN `product_model_id` bigint NULL COMMENT '浜у搧ID' AFTER `id`,
MODIFY COLUMN `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '宸ュ簭鍚嶇О' AFTER `no`,
MODIFY COLUMN `create_time` datetime NULL DEFAULT NULL COMMENT '褰曞叆鏃堕棿' AFTER `dept_id`,
- MODIFY COLUMN `update_time` datetime NULL DEFAULT NULL COMMENT '鏇存柊鏃堕棿' AFTER `create_time`;
\ No newline at end of file
+ MODIFY COLUMN `update_time` datetime NULL DEFAULT NULL COMMENT '鏇存柊鏃堕棿' AFTER `create_time`;
+
+ALTER TABLE `product-inventory-management-jghg`.`quality_unqualified`
+ ADD COLUMN `reason_analysis` varchar(255) NULL COMMENT '鍘熷洜鍒嗘瀽' AFTER `dept_id`,
+ADD COLUMN `preventive_corrective` varchar(255) NULL COMMENT '棰勯槻涓庣籂姝ｆ帾鏂�' AFTER `reason_analysis`,
+ADD COLUMN `loss_working` varchar(255) NULL COMMENT '宸ユ椂鎹熷け' AFTER `preventive_corrective`,
+ADD COLUMN `loss_material` varchar(255) NULL COMMENT '鏉愭枡璐规崯澶�' AFTER `loss_working`;
diff --git a/src/main/java/com/ruoyi/quality/pojo/QualityUnqualified.java b/src/main/java/com/ruoyi/quality/pojo/QualityUnqualified.java
index 60760ec..ecfca49 100644
--- a/src/main/java/com/ruoyi/quality/pojo/QualityUnqualified.java
+++ b/src/main/java/com/ruoyi/quality/pojo/QualityUnqualified.java
@@ -143,4 +143,28 @@
@TableField(fill = FieldFill.INSERT)
private Long deptId;
+
+ /**
+ * 鍘熷洜鍒嗘瀽
+ */
+ @Excel(name = "鍘熷洜鍒嗘瀽")
+ private String reasonAnalysis;
+
+ /**
+ * 棰勯槻涓庣籂姝ｆ帾鏂�
+ */
+ @Excel(name = "棰勯槻涓庣籂姝ｆ帾鏂�")
+ private String preventiveCorrective;
+
+ /**
+ * 宸ユ椂鎹熷け
+ */
+ @Excel(name = "宸ユ椂鎹熷け")
+ private String lossWorking;
+
+ /**
+ * 鏉愭枡璐规崯澶�
+ */
+ @Excel(name = "鏉愭枡璐规崯澶�")
+ private String lossMaterial;
}
diff --git a/src/main/resources/mapper/quality/QualityUnqualifiedMapper.xml b/src/main/resources/mapper/quality/QualityUnqualifiedMapper.xml
index 5bda4f6..99f402d 100644
--- a/src/main/resources/mapper/quality/QualityUnqualifiedMapper.xml
+++ b/src/main/resources/mapper/quality/QualityUnqualifiedMapper.xml
@@ -16,6 +16,10 @@
qu.deal_result,
qu.deal_name,
qu.deal_time,
+ qu.reason_analysis,
+ qu.preventive_corrective,
+ qu.loss_working,
+ qu.loss_material,
CASE
WHEN qu.model = pm.id THEN pm.model
ELSE qu.model
--
Gitblit v1.9.3