From 9ec857efad0288a7a8866aff014e04757bd50685 Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期五, 06 十一月 2026 09:48:19 +0800
Subject: [PATCH] feat(qc): 添加质量巡检数据表与菜单权限配置

---
 .gitignore                       |    2 ++
 sql/mysql/20261105_qc_patrol.sql |   38 ++++++++++++++++++++++++++++++++++++++
 2 files changed, 40 insertions(+), 0 deletions(-)

diff --git a/.gitignore b/.gitignore
index 44a20f9..527d5c4 100644
--- a/.gitignore
+++ b/.gitignore
@@ -1,5 +1,7 @@
 ######################################################################
 # Build Tools
+.playwright-mcp
+.tmp
 
 .gradle
 /build/
diff --git a/sql/mysql/20261105_qc_patrol.sql b/sql/mysql/20261105_qc_patrol.sql
new file mode 100644
index 0000000..4296252
--- /dev/null
+++ b/sql/mysql/20261105_qc_patrol.sql
@@ -0,0 +1,38 @@
+-- 璐ㄩ噺宸℃涓虹嫭绔嬭褰曪紝涓嶇敓鎴愬簱瀛樹笟鍔″崟鎹��
+CREATE TABLE IF NOT EXISTS `mes_qc_patrol` (
+  `id` bigint NOT NULL AUTO_INCREMENT,
+  `code` varchar(100) NOT NULL,
+  `name` varchar(255) NOT NULL,
+  `item_id` bigint NOT NULL,
+  `reel_no` varchar(128) DEFAULT NULL,
+  `batch_code` varchar(128) DEFAULT NULL,
+  `qualified_quantity` decimal(24,6) NOT NULL DEFAULT 0,
+  `unqualified_quantity` decimal(24,6) NOT NULL DEFAULT 0,
+  `inspect_date` datetime NOT NULL,
+  `inspector_user_id` bigint NOT NULL,
+  `remark` varchar(1000) DEFAULT NULL,
+  `creator` varchar(64) DEFAULT '',
+  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
+  `updater` varchar(64) DEFAULT '',
+  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+  `deleted` bit(1) NOT NULL DEFAULT b'0',
+  `tenant_id` bigint NOT NULL DEFAULT 0,
+  PRIMARY KEY (`id`),
+  KEY `idx_patrol_item_reel` (`item_id`, `reel_no`),
+  KEY `idx_patrol_date` (`inspect_date`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='璐ㄩ噺宸℃璁板綍';
+
+-- 浠呭綋璐ㄩ噺绠$悊鑿滃崟瀛樺湪鏃舵柊澧炲贰妫�鍏ュ彛锛涢噸澶嶆墽琛屼笉浼氬垱寤洪噸澶嶉」銆�
+INSERT INTO system_menu (name,permission,type,sort,parent_id,path,icon,component,component_name,status,visible,keep_alive,always_show)
+SELECT '璐ㄩ噺宸℃','',2,12,p.id,'patrol','ep:document-checked','mes/qc/patrol/index','MesQcPatrol',0,b'1',b'1',b'1'
+FROM system_menu p WHERE p.id=5500 AND p.deleted=b'0'
+AND NOT EXISTS (SELECT 1 FROM system_menu m WHERE m.component='mes/qc/patrol/index' AND m.deleted=b'0');
+SET @qc_patrol_menu = (SELECT id FROM system_menu WHERE component='mes/qc/patrol/index' AND deleted=b'0' LIMIT 1);
+INSERT INTO system_menu (name,permission,type,sort,parent_id,path,icon,status,visible,keep_alive,always_show)
+SELECT x.name,x.permission,3,x.sort,@qc_patrol_menu,'','',0,b'1',b'1',b'1'
+FROM (SELECT '宸℃鏌ヨ' name,'mes:qc-patrol:query' permission,1 sort UNION ALL SELECT '宸℃鏂板','mes:qc-patrol:create',2 UNION ALL SELECT '宸℃淇敼','mes:qc-patrol:update',3 UNION ALL SELECT '宸℃鍒犻櫎','mes:qc-patrol:delete',4) x
+WHERE @qc_patrol_menu IS NOT NULL AND NOT EXISTS (SELECT 1 FROM system_menu m WHERE m.permission=x.permission AND m.deleted=b'0');
+INSERT INTO system_role_menu (role_id,menu_id,tenant_id)
+SELECT r.id,m.id,r.tenant_id FROM system_role r JOIN system_menu m ON (m.id=@qc_patrol_menu OR m.parent_id=@qc_patrol_menu)
+WHERE r.code='super_admin' AND r.deleted=b'0' AND m.deleted=b'0'
+AND NOT EXISTS (SELECT 1 FROM system_role_menu rm WHERE rm.role_id=r.id AND rm.menu_id=m.id AND rm.deleted=b'0');

--
Gitblit v1.9.3