From 61fbbc45feb0e08031e369770bda3eb8e6032a17 Mon Sep 17 00:00:00 2001
From: zss <zss@example.com>
Date: 星期一, 16 三月 2026 11:31:14 +0800
Subject: [PATCH] 来料检增加试样字段
---
doc/宁夏-中盛建材.sql | 8 ++++++++
src/main/java/com/ruoyi/quality/pojo/QualityInspect.java | 32 ++++++++++++++++++++++++++++++++
2 files changed, 40 insertions(+), 0 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 bc95ed7..cf511bf 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"
@@ -234,3 +234,11 @@
ALTER TABLE `product-inventory-management-zsjc`.`customer`
ADD COLUMN `form_instance_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '瀹滄惌琛ㄥ崟瀹炰緥ID' AFTER `customer_type`,
ADD COLUMN `form_modified_time` datetime(0) NULL DEFAULT NULL COMMENT '瀹滄惌淇敼鏃堕棿' AFTER `form_instance_id`;
+
+
+ALTER TABLE `product-inventory-management-zsjc`.`quality_inspect`
+ ADD COLUMN `inspect_nature` varchar(255) NULL COMMENT '妫�娴嬫�ц川' AFTER `test_standard_id`,
+ADD COLUMN `sample_code` varchar(255) NULL COMMENT '璇曟牱缂栧彿' AFTER `inspect_nature`,
+ADD COLUMN `sample_state` varchar(255) NULL COMMENT '璇曟牱鐘舵��' AFTER `sample_code`,
+ADD COLUMN `sample_time` date NULL COMMENT '鍙栨牱鏃ユ湡' AFTER `sample_state`,
+ADD COLUMN `license_plate_number` varchar(255) NULL COMMENT '杞︾墝鍙�' AFTER `sample_time`;
diff --git a/src/main/java/com/ruoyi/quality/pojo/QualityInspect.java b/src/main/java/com/ruoyi/quality/pojo/QualityInspect.java
index 9d23429..ef7f13d 100644
--- a/src/main/java/com/ruoyi/quality/pojo/QualityInspect.java
+++ b/src/main/java/com/ruoyi/quality/pojo/QualityInspect.java
@@ -73,6 +73,7 @@
* 鍏宠仈浜у搧id
*/
@NotBlank(message = "浜у搧id涓嶈兘涓虹┖")
+ //瀹佸-涓洓寤烘潗浣跨敤鏂扮殑浜у搧琛ㄥ叧鑱攑roduct_material_sku
private Long productId;
/**
@@ -157,4 +158,35 @@
private String workOrderNo;
@TableField(exist = false)
private String purchaseContractNo;
+
+ /**
+ * 鍙栨牱鏃ユ湡
+ */
+ @JsonFormat(pattern = "yyyy-MM-dd")
+ @Excel(name = "鍙栨牱鏃ユ湡", width = 30, dateFormat = "yyyy-MM-dd")
+ private Date sampleTime;
+
+ /**
+ * 妫�娴嬫�ц川
+ */
+ @Excel(name = "妫�娴嬫�ц川")
+ private String inspectNature;
+
+ /**
+ * 璇曟牱缂栧彿
+ */
+ @Excel(name = "璇曟牱缂栧彿")
+ private String sampleCode;
+
+ /**
+ * 璇曟牱鐘舵��
+ */
+ @Excel(name = "璇曟牱鐘舵��")
+ private String sampleState;
+
+ /**
+ * 杞︾墝鍙�
+ */
+ @Excel(name = "杞︾墝鍙�")
+ private String licensePlateNumber;
}
--
Gitblit v1.9.3