From 1511296b46ddc0ed8a285d2d19e5491ef3506488 Mon Sep 17 00:00:00 2001
From: gongchunyi <deslre0381@gmail.com>
Date: 星期一, 21 九月 2026 23:23:17 +0800
Subject: [PATCH] feat: 首检字段
---
doc/20260921_过程检验增加首检字段.sql | 18 ++++++++++++++++++
src/main/java/com/ruoyi/quality/pojo/QualityInspect.java | 7 +++++++
2 files changed, 25 insertions(+), 0 deletions(-)
diff --git "a/doc/20260921_\350\277\207\347\250\213\346\243\200\351\252\214\345\242\236\345\212\240\351\246\226\346\243\200\345\255\227\346\256\265.sql" "b/doc/20260921_\350\277\207\347\250\213\346\243\200\351\252\214\345\242\236\345\212\240\351\246\226\346\243\200\345\255\227\346\256\265.sql"
new file mode 100644
index 0000000..3f8ef67
--- /dev/null
+++ "b/doc/20260921_\350\277\207\347\250\213\346\243\200\351\252\214\345\242\236\345\212\240\351\246\226\346\243\200\345\255\227\346\256\265.sql"
@@ -0,0 +1,18 @@
+-- 杩囩▼妫�楠�(quality_inspect)澧炲姞"鏄惁棣栨"瀛楁
+SET
+@col_exists = (
+ SELECT COUNT(1)
+ FROM information_schema.COLUMNS
+ WHERE TABLE_SCHEMA = DATABASE()
+ AND TABLE_NAME = 'quality_inspect'
+ AND COLUMN_NAME = 'is_first_inspect'
+);
+
+SET
+@ddl = IF(@col_exists = 0,
+ 'ALTER TABLE quality_inspect ADD COLUMN is_first_inspect TINYINT(1) NOT NULL DEFAULT 0 COMMENT ''鏄惁棣栨(0:鍚�;1:鏄�)'' AFTER sampling_quantity',
+ 'SELECT ''is_first_inspect 宸插瓨鍦紝璺宠繃'' AS msg');
+
+PREPARE stmt FROM @ddl;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
diff --git a/src/main/java/com/ruoyi/quality/pojo/QualityInspect.java b/src/main/java/com/ruoyi/quality/pojo/QualityInspect.java
index 04fc58b..09135c4 100644
--- a/src/main/java/com/ruoyi/quality/pojo/QualityInspect.java
+++ b/src/main/java/com/ruoyi/quality/pojo/QualityInspect.java
@@ -121,6 +121,13 @@
private BigDecimal samplingQuantity;
/**
+ * 鏄惁棣栨(0:鍚�;1:鏄�)
+ */
+ @Excel(name = "鏄惁棣栨", readConverterExp = "0=鍚�,1=鏄�")
+ @TableField("is_first_inspect")
+ private Integer isFirstInspect;
+
+ /**
* 妫�娴嬪崟浣�
*/
@Excel(name = "妫�娴嬪崟浣�")
--
Gitblit v1.9.3