From 42bdd4c5c74fb019b6a3397a6eec63a02d90ffda Mon Sep 17 00:00:00 2001
From: gaoluyang <2820782392@qq.com>
Date: 星期五, 06 十一月 2026 09:08:11 +0800
Subject: [PATCH] fix(mes): 补充质检单「完成」按钮权限,修复完成检验单报没有该操作权限

---
 docs/sql/mes_qc_finish_menu.sql |   39 +++++++++++++++++++++++++++++++++++++++
 1 files changed, 39 insertions(+), 0 deletions(-)

diff --git a/docs/sql/mes_qc_finish_menu.sql b/docs/sql/mes_qc_finish_menu.sql
new file mode 100644
index 0000000..c9d7ee1
--- /dev/null
+++ b/docs/sql/mes_qc_finish_menu.sql
@@ -0,0 +1,39 @@
+-- 璐ㄦ鍗曘�屽畬鎴愩�嶆寜閽潈闄�
+--
+-- 鑳屾櫙锛氬悗绔� MesQcIqc/Ipqc/Oqc/RqcController 鐨� /finish 鎺ュ彛鍒嗗埆鏍¢獙
+--       mes:qc-iqc:finish / mes:qc-ipqc:finish / mes:qc-oqc:finish / mes:qc-rqc:finish锛�
+--       浣� system_menu 涓病鏈夎繖鍥涗釜鏉冮檺鐮佸搴旂殑鎸夐挳锛屽鑷撮潪瓒呯鐢ㄦ埛鐐瑰嚮銆屽畬鎴愩��
+--       鐩存帴杩斿洖 403銆屾病鏈夎鎿嶄綔鏉冮檺銆嶃��
+--
+-- 鏈剼鏈箓绛夛紝鍙噸澶嶆墽琛屻�傛墽琛屽悗娓呯悊 Redis 涓浉鍏宠鑹茬殑 role_menu_ids 缂撳瓨锛�
+-- 鎴栬鐢ㄦ埛閲嶆柊鐧诲綍鍚庣敓鏁堛��
+
+-- 1. 琛ュ洓涓�屽畬鎴愩�嶆寜閽紝鎸傚湪鍚勮嚜璐ㄦ鍒楄〃鑿滃崟涓�
+INSERT INTO system_menu (name, permission, type, sort, parent_id, status, icon, creator, updater)
+SELECT s.name, s.permission, 3, 7, p.id, 0, '', '1', '1'
+FROM system_menu p
+JOIN (
+    SELECT '鏉ユ枡妫�楠屽畬鎴�' AS name, 'mes:qc-iqc:finish' AS permission, 'mes/qc/iqc/index' AS component
+    UNION ALL SELECT '杩囩▼妫�楠屽畬鎴�', 'mes:qc-ipqc:finish', 'mes/qc/ipqc/index'
+    UNION ALL SELECT '鍑鸿揣妫�楠屽畬鎴�', 'mes:qc-oqc:finish', 'mes/qc/oqc/index'
+    UNION ALL SELECT '閫�鏂欐楠屽畬鎴�', 'mes:qc-rqc:finish', 'mes/qc/rqc/index'
+) s ON p.component = s.component
+WHERE p.type = 2 AND p.deleted = b'0'
+  AND NOT EXISTS (
+      SELECT 1 FROM system_menu m
+      WHERE m.permission = s.permission AND m.deleted = b'0'
+  );
+
+-- 2. 鎺堜簣宸叉嫢鏈夊搴旇川妫�鍒楄〃鑿滃崟鐨勮鑹�
+INSERT INTO system_role_menu (role_id, menu_id, creator, updater)
+SELECT DISTINCT rm.role_id, m.id, '1', '1'
+FROM system_role_menu rm
+JOIN system_menu p ON p.id = rm.menu_id AND p.type = 2 AND p.deleted = b'0'
+JOIN system_menu m ON m.parent_id = p.id AND m.deleted = b'0'
+WHERE p.component IN ('mes/qc/iqc/index', 'mes/qc/ipqc/index', 'mes/qc/oqc/index', 'mes/qc/rqc/index')
+  AND m.permission IN ('mes:qc-iqc:finish', 'mes:qc-ipqc:finish', 'mes:qc-oqc:finish', 'mes:qc-rqc:finish')
+  AND rm.deleted = b'0'
+  AND NOT EXISTS (
+      SELECT 1 FROM system_role_menu x
+      WHERE x.role_id = rm.role_id AND x.menu_id = m.id AND x.deleted = b'0'
+  );

--
Gitblit v1.9.3