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