From d69b6efcab519bd320f3ba74f95269d6b32f0422 Mon Sep 17 00:00:00 2001
From: gaoluyang <2820782392@qq.com>
Date: 星期一, 02 十一月 2026 16:51:57 +0800
Subject: [PATCH] chore(sql,docs): 补菜单脚本与业务流程图更新
---
docs/project-business/data/flows.json | 5
sql/mysql/mes_bom_menu_20261102.sql | 172 +++++++++++++++++
docs/project-business/mermaid/04-production-flow.mmd | 12
sql/mysql/cfwj_menu_align_20261102.sql | 373 +++++++++++++++++++++++++++++++++++++
4 files changed, 557 insertions(+), 5 deletions(-)
diff --git a/docs/project-business/data/flows.json b/docs/project-business/data/flows.json
index e6d7bff..1378a54 100644
--- a/docs/project-business/data/flows.json
+++ b/docs/project-business/data/flows.json
@@ -22,9 +22,10 @@
{"stage": "閫�璐�", "action": "IQC 涓嶅悎鏍奸��璐р啋渚涘簲鍟嗛��璐у嚭搴�(閫夋枡閿佸畾鍒拌鍗曡)锛涙姤搴熻蛋 NCR", "roles": ["浠撶"]},
{"stage": "浠樻", "action": "閲囪喘鍏ュ簱瀹屾垚鍗冲悜鍏ュ簱鍗曞垱寤轰汉+绠$悊鍛樺彂绔欏唴淇�(鍚叆搴撳崟鍙�/閲囪喘璁㈠崟鍙�/璁㈠崟閲戦)锛屾彁閱掕储鍔℃寜鏉ョエ鐢熸垚浠樻鍗曪紱閲囪喘鏉ョエ(FPD, AI OCR, 鈮よ鍗曟�讳环) 鈫� 浠樻鍗�(FKD 鍏宠仈鏉ョエ+闄勪欢, 鈮ゆ潵绁ㄩ噾棰�) BPM 瀹℃壒", "roles": ["璐㈠姟", "瀹℃壒浜�"]}]},
{"id": "production", "name": "鐢熶骇娴佺▼", "mermaid": "mermaid/04-production-flow.mmd", "color": "#e0b34f",
- "summary": "閿�鍞鍗曢┍鍔� MPS 鈫� 涓嬪彂宸ュ崟 鈫� 鎸夊伐鑹鸿矾绾挎媶宸ュ簭浠诲姟 鈫� 棰嗘枡/绾胯竟澶囨枡 鈫� 鎶ュ伐(宸ュ簭椤哄簭纭牎楠�+BPM) 鈫� 鍊掑啿娑堣��/浜у嚭鍏ュ簱/IPQC 鈫� 鏈亾宸ュ簭鍥炲啓杩涘害 鈫� 鑷姩瀹屽伐 鈫� ProductionFinishedEvent 鍥炲啓閿�鍞鍗曘��",
+ "summary": "閿�鍞鍗曢┍鍔� MPS 鈫� 鎻愪氦瀹℃牳(鍗忓悓鍔炲叕 BPM) 鈫� 涓嬪彂宸ュ崟 鈫� 鎸夊伐鑹鸿矾绾挎媶宸ュ簭浠诲姟 鈫� 棰嗘枡/绾胯竟澶囨枡 鈫� 鎶ュ伐(宸ュ簭椤哄簭纭牎楠�+BPM) 鈫� 鍊掑啿娑堣��/浜у嚭鍏ュ簱/IPQC 鈫� 鏈亾宸ュ簭鍥炲啓杩涘害 鈫� 鑷姩瀹屽伐 鈫� ProductionFinishedEvent 鍥炲啓閿�鍞鍗曘��",
"steps": [
- {"stage": "璁″垝", "action": "MPS 鍒涘缓(鎵嬪伐鎴栭攢鍞鍗曡嚜鍔�)鈫掍笅鍙戞垨鍚堝苟涓嬪彂涓哄伐鍗�", "roles": ["璁″垝鍛�"]},
+ {"stage": "鍩虹鏁版嵁", "action": "鐢熶骇鍩虹鏁版嵁缁存姢锛氫骇鍝丅OM(鐗╂枡BOM缁存姢椤点�孊OM 缁勬垚銆�)涓庡伐鑹鸿矾绾挎姇鏂橞OM(鎸変骇鍝伱楀伐搴忥紝浼樺厛浜庝骇鍝丅OM)锛汳PS 杈呮枡鏄庣粏銆佸伐鍗曡緟鏂欓瑙堝潎鎸� BOM 灞曞紑骞舵牎楠屽彲鐢ㄥ簱瀛橈紝鏈淮鎶� BOM 鏃舵槑缁嗕负绌哄苟鎻愮ず鍏堥厤缃紝涓嶅啀鎶婃垚鍝佽嚜韬綋鎴愯緟鏂�", "roles": ["鐢熶骇绠$悊鍛�"]},
+ {"stage": "璁″垝", "action": "MPS 鍒涘缓(鎵嬪伐鎴栭攢鍞鍗曡嚜鍔�)鈫掓彁浜ゅ鏍歌繘鍏ュ崗鍚屽姙鍏�(mes-pro-mps-audit)瀹℃壒锛岄┏鍥�/鎾ゅ洖鍥炶崏绋库啋瀹℃牳閫氳繃鍚庝笅鍙戞垨鍚堝苟涓嬪彂涓哄伐鍗�", "roles": ["璁″垝鍛�", "鐢熶骇绠$悊鍛�"]},
{"stage": "娲惧伐", "action": "宸ュ崟纭鎸夊伐鑹鸿矾绾块�愬伐搴忕敓鎴愪换鍔★紝鍙寚娲�/鏆傚仠/鍙栨秷", "roles": ["杞﹂棿涓讳换"]},
{"stage": "澶囨枡", "action": "鐢熶骇棰嗘枡鍗曞嚭搴撴垨绾胯竟铏氭嫙搴撳鏂�", "roles": ["浠撶"]},
{"stage": "鎶ュ伐", "action": "鎻愪氦鎶ュ伐锛氫笂涓�閬撳伐搴忔湭鎶ユ弧鐩存帴鎷︽埅锛涘惎鐢� BPM 璧板鎵�", "roles": ["鎿嶄綔宸�"]},
diff --git a/docs/project-business/mermaid/04-production-flow.mmd b/docs/project-business/mermaid/04-production-flow.mmd
index 6d2d1a7..f711d68 100644
--- a/docs/project-business/mermaid/04-production-flow.mmd
+++ b/docs/project-business/mermaid/04-production-flow.mmd
@@ -1,9 +1,15 @@
flowchart TD
- P0[閿�鍞鍗曟槑缁� needProduction=1] -->|瀹℃壒閫氳繃鑷姩鍒涘缓| P1[MPS 涓荤敓浜ц鍒捖疯崏绋�0鈫掑凡涓嬪彂1]
- P1 -->|涓嬪彂鎴栧悎骞朵笅鍙憒 P2[鐢熶骇宸ュ崟路鑽夌0鈫掑凡纭1<br/>宸ュ巶/杞﹂棿涓虹敓浜т富浣揮
+ MD1[鐗╂枡BOM缁存姢路浜у搧BOM缁勬垚<br/>mes_md_product_bom] -->|鍗曡�梶 P2M
+ MD2[宸ヨ壓璺嚎鎶曟枡BOM路鎸変骇鍝伱楀伐搴�<br/>mes_pro_route_product_bom] -->|浼樺厛浜庝骇鍝丅OM| P2M
+ P0[閿�鍞鍗曟槑缁� needProduction=1] -->|瀹℃壒閫氳繃鑷姩鍒涘缓| P1[MPS 涓荤敓浜ц鍒捖疯崏绋�0]
+ P1 -->|鎻愪氦瀹℃牳路鍚姩 mes-pro-mps-audit| P1A[鍗忓悓鍔炲叕瀹℃壒路瀹℃牳涓�4]
+ P1A -->|椹冲洖/鎾ゅ洖鈫掕崏绋�0| P1
+ P1A -->|瀹℃壒閫氳繃路宸插鏍�5| P1B[MPS 宸插鏍�5]
+ P1B -->|涓嬪彂鎴栧悎骞朵笅鍙憒 P2[鐢熶骇宸ュ崟路鑽夌0鈫掑凡纭1<br/>宸ュ巶/杞﹂棿涓虹敓浜т富浣揮
P2 -->|鎸夊伐鑹鸿矾绾垮伐搴忚嚜鍔ㄧ敓鎴恷 P3[鐢熶骇浠诲姟脳N路棰勫0鈫掔敓浜т腑1鈫掗儴鍒嗗畬鎴�2鈫掑畬鎴�4路鍙殏鍋�9]
P2 -->|鍚姩鐢熶骇路鍐欏疄闄呭紑宸ユ椂闂翠笌寮�宸ヤ汉| P2S[鐢熶骇涓风姸鎬佷粛涓哄凡纭1]
- P2 -->|鎸変骇鍝�+鏁伴噺棰勮杈呮枡闇�姹倈 P2M[杈呮枡闇�姹備笌鍙敤搴撳瓨鏍¢獙<br/>涓嶈冻鎻愮ず鍏堣閲囪喘路涓嶉樆鏂缓鍗昡
+ P2 -->|鎸変骇鍝�+鏁伴噺棰勮杈呮枡闇�姹倈 P2M[杈呮枡闇�姹備笌鍙敤搴撳瓨鏍¢獙<br/>鎸塀OM灞曞紑路涓嶈冻鎻愮ず鍏堣閲囪喘路涓嶉樆鏂缓鍗昡
+ P1B -->|杈呮枡鏄庣粏| P2M
P3 --> P4[鐢熶骇棰嗘枡路姝e父棰嗘枡绫诲瀷1]
P4 -->|鎻愪氦鈫掓嫞璐р啋瀹屾垚路鎵e噺搴撳瓨骞惰浆鍏ョ嚎杈硅櫄鎷熷簱| P4
P4 --> P4S[琛ラ杈呮枡路棰嗘枡绫诲瀷2路蹇呴』濉ˉ棰嗗師鍥燷
diff --git a/sql/mysql/cfwj_menu_align_20261102.sql b/sql/mysql/cfwj_menu_align_20261102.sql
new file mode 100644
index 0000000..9df083b
--- /dev/null
+++ b/sql/mysql/cfwj_menu_align_20261102.sql
@@ -0,0 +1,373 @@
+-- =====================================================================
+-- 璇氬彂浜旈噾鑿滃崟瀵规爣銆婇檮浠朵竴锛氭妧鏈柟妗�-璇氬彂浜旈噾锛�2026锛夈��
+-- 鐩爣锛氫晶杈规爮鐨� 7 涓笟鍔℃ā鍧楀強鍏跺瓙鑿滃崟涓庢柟妗堢珷鑺傛爣棰樹竴鑷达紱
+-- 鏂规鏈秹鍙婄殑鏍囧噯鍝侀〉闈㈠彧闅愯棌锛坴isible=0锛夛紝涓嶅垹闄ゆ暟鎹紱
+-- 宸ュ崟鍔╂墜涓� APP锛屾湰娆′笉寤鸿彍鍗曘��
+-- 閫傜敤搴擄細璇氬彂浜旈噾鏈湴搴� CFWJ锛堝崟绉熸埛锛岃剼鏈笉鍚� tenant_id锛�
+-- 骞傜瓑锛氬彲閲嶅鎵ц锛涙墽琛屽墠鏁磋〃澶囦唤鍒� system_menu_bak_20261102
+-- 娉ㄦ剰锛氬彧璋冩暣 type=1/2锛泃ype=3 鎸夐挳涓嶇Щ鍔ㄣ�佷笉闅愯棌锛屾帴鍙f潈闄愪笉鍙楀奖鍝嶃��
+-- =====================================================================
+
+SET NAMES utf8mb4;
+
+-- ==================== 0. 澶囦唤锛圖DL 浼氶殣寮忔彁浜わ紝蹇呴』鏀惧湪浜嬪姟澶栵級 ====================
+CREATE TABLE IF NOT EXISTS `system_menu_bak_20261102` AS SELECT * FROM `system_menu`;
+
+START TRANSACTION;
+
+-- ==================== 1. 瀹氫綅 7 涓笟鍔℃ā鍧� ====================
+SET @plan_id = (SELECT id FROM `system_menu` WHERE deleted = b'0' AND parent_id = 0 AND name = '璁″垝鎺掔▼' ORDER BY id LIMIT 1);
+SET @prod_id = (SELECT id FROM `system_menu` WHERE deleted = b'0' AND parent_id = 0 AND name = '鐢熶骇绠℃帶' ORDER BY id LIMIT 1);
+SET @dev_id = (SELECT id FROM `system_menu` WHERE deleted = b'0' AND parent_id = 0 AND name = '璁惧绠$悊' ORDER BY id LIMIT 1);
+SET @pur_id = (SELECT id FROM `system_menu` WHERE deleted = b'0' AND parent_id = 0 AND name = '閲囪喘绠$悊' ORDER BY id LIMIT 1);
+SET @wms_id = (SELECT id FROM `system_menu` WHERE deleted = b'0' AND parent_id = 0 AND name = '浠撳偍鐗╂祦' ORDER BY id LIMIT 1);
+SET @sale_id = (SELECT id FROM `system_menu` WHERE deleted = b'0' AND parent_id = 0 AND name = '钀ラ攢绠$悊' ORDER BY id LIMIT 1);
+SET @hrm_id = (SELECT id FROM `system_menu` WHERE deleted = b'0' AND parent_id = 0 AND name = '浜哄姏璧勬簮' ORDER BY id LIMIT 1);
+
+-- ==================== 2. 璁″垝鎺掔▼ ====================
+-- 1.1 璁″垝鏌ヨ涓庣瓫閫� / 1.2 鏂板鐢熶骇璁″垝 / 1.3 璁″垝鍒楄〃绠$悊 鈫� 鍚屼竴涓�岀敓浜ц鍒掋�嶉〉闈�
+UPDATE `system_menu` SET `name` = '鐢熶骇璁″垝', `parent_id` = @plan_id, `sort` = 1,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW()
+WHERE `id` = 602504;
+
+-- ==================== 3. 鐢熶骇绠℃帶 ====================
+-- 2.1 鐢熶骇宸ュ崟
+UPDATE `system_menu` SET `name` = '鐢熶骇宸ュ崟', `parent_id` = @prod_id, `sort` = 1,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW()
+WHERE `id` = 5530;
+
+-- 2.1鈶€�屾煡鐪嬫墽琛屾儏鍐点�嶄緷璧栨姤宸ユ暟鎹細淇濈暀鐢熶骇鎶ュ伐椤甸潰锛堟柟妗堟湭鍗曞垪锛屼綔涓哄伐鍗曟墽琛岀殑閰嶅椤碉級
+UPDATE `system_menu` SET `name` = '鐢熶骇鎶ュ伐', `parent_id` = @prod_id, `sort` = 2,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW()
+WHERE `id` = 5550;
+
+-- 2.2 棰嗘枡绠$悊锛堢洰褰曪細棰嗘枡鍑哄簱 / 浣欐枡鍏ュ簱锛�
+-- 璇存槑锛氭柟妗� 2.2鈶°�岃ˉ棰嗚緟鏂欍�嶄笌 2.2鈶犮�岄鏂欏嚭搴撱�嶅湪鍚屼竴寮犻鏂欏崟涓婂畬鎴�
+-- 锛堝悓椤甸潰鐢ㄣ�岄鏂欑被鍨嬨�嶅尯鍒嗭紝宸ュ叿鏍忓凡鏈夈�岃ˉ棰嗚緟鏂欍�嶆寜閽級锛屽悎骞朵负銆岄鏂欏嚭搴撱�嶄竴涓彍鍗曪紝涓嶉噸澶嶅缓鑿滃崟銆�
+SET @issue_dir = (SELECT id FROM `system_menu` WHERE deleted = b'0' AND type = 1 AND parent_id = @prod_id AND name = '棰嗘枡绠$悊' ORDER BY id LIMIT 1);
+INSERT INTO `system_menu` (`name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `component_name`, `status`, `visible`, `keep_alive`, `always_show`, `creator`, `create_time`, `updater`, `update_time`, `deleted`)
+SELECT '棰嗘枡绠$悊', '', 1, 3, @prod_id, 'issue', 'ep:box', NULL, NULL, 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'
+FROM DUAL WHERE @issue_dir IS NULL;
+SET @issue_dir = (SELECT id FROM `system_menu` WHERE deleted = b'0' AND type = 1 AND parent_id = @prod_id AND name = '棰嗘枡绠$悊' ORDER BY id LIMIT 1);
+
+UPDATE `system_menu` SET `name` = '棰嗘枡鍑哄簱', `parent_id` = @issue_dir, `sort` = 1,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW()
+WHERE `id` = 5805;
+
+UPDATE `system_menu` SET `name` = '浣欐枡鍏ュ簱', `parent_id` = @issue_dir, `sort` = 2,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW()
+WHERE `id` = 5840;
+
+-- 2.3 鐢熶骇涓讳綋绛夊熀纭�璁剧疆涓嶅崟鍒楄彍鍗曪紝褰掑叆鏀拺妯″潡銆屽熀纭�鏁版嵁銆嶏紱鏂规鏈垪鐨勭敓浜ф帓浜ч殣钘�
+SET @basic_id = (SELECT id FROM `system_menu` WHERE deleted = b'0' AND parent_id = 0 AND name = '鍩虹鏁版嵁' ORDER BY id LIMIT 1);
+UPDATE `system_menu` SET `name` = '宸ュ巶璁剧疆', `parent_id` = @basic_id, `sort` = 10,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW() WHERE `id` = 1075495;
+UPDATE `system_menu` SET `name` = '杞﹂棿璁剧疆', `parent_id` = @basic_id, `sort` = 11,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW() WHERE `id` = 5160;
+UPDATE `system_menu` SET `name` = '宸ヤ綔绔欒缃�', `parent_id` = @basic_id, `sort` = 12,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW() WHERE `id` = 5170;
+-- 璁惧绫诲瀷鍚屽睘鍩虹涓绘暟鎹紝褰掑叆銆屽熀纭�鏁版嵁銆�
+UPDATE `system_menu` SET `name` = '璁惧绫诲瀷', `parent_id` = @basic_id, `sort` = 13,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW() WHERE `id` = 5310;
+-- 娓呯┖鍚庣殑鏃х洰褰�/鐢熶骇鎺掍骇闅愯棌
+UPDATE `system_menu` SET `visible` = b'0', `updater` = '1', `update_time` = NOW()
+WHERE `id` IN (5101, 5700, 5540);
+
+-- ==================== 4. 璁惧绠$悊 ====================
+-- 3.1 璁惧鍩虹淇℃伅绠$悊锛堣澶囧彴璐︼級
+UPDATE `system_menu` SET `name` = '璁惧鍩虹淇℃伅绠$悊', `parent_id` = @dev_id, `sort` = 1,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW()
+WHERE `id` = 5320;
+
+-- 3.2 璁惧鐘舵�佷笌鏃ュ父鎿嶄綔锛堢洰褰曪細璁惧鍊熺敤 / 缁翠慨鍗曪級
+SET @dev_daily_dir = (SELECT id FROM `system_menu` WHERE deleted = b'0' AND type = 1 AND parent_id = @dev_id AND name = '璁惧鐘舵�佷笌鏃ュ父鎿嶄綔' ORDER BY id LIMIT 1);
+INSERT INTO `system_menu` (`name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `component_name`, `status`, `visible`, `keep_alive`, `always_show`, `creator`, `create_time`, `updater`, `update_time`, `deleted`)
+SELECT '璁惧鐘舵�佷笌鏃ュ父鎿嶄綔', '', 1, 2, @dev_id, 'daily', 'ep:switch', NULL, NULL, 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'
+FROM DUAL WHERE @dev_daily_dir IS NULL;
+SET @dev_daily_dir = (SELECT id FROM `system_menu` WHERE deleted = b'0' AND type = 1 AND parent_id = @dev_id AND name = '璁惧鐘舵�佷笌鏃ュ父鎿嶄綔' ORDER BY id LIMIT 1);
+UPDATE `system_menu` SET `name` = '璁惧鍊熺敤', `parent_id` = @dev_daily_dir, `sort` = 1,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW()
+WHERE `id` = 1075514;
+UPDATE `system_menu` SET `name` = '缁翠慨鍗�', `parent_id` = @dev_daily_dir, `sort` = 2,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW()
+WHERE `id` = 5370;
+
+-- 3.3 璁惧缁存姢涓庢淇鐞嗭紙鐩綍锛氱偣妫�淇濆吇椤圭洰 / 鏂规 / 鐐规璁板綍 / 淇濆吇璁板綍锛�
+SET @dev_maint_dir = (SELECT id FROM `system_menu` WHERE deleted = b'0' AND type = 1 AND parent_id = @dev_id AND name = '璁惧缁存姢涓庢淇鐞�' ORDER BY id LIMIT 1);
+INSERT INTO `system_menu` (`name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `component_name`, `status`, `visible`, `keep_alive`, `always_show`, `creator`, `create_time`, `updater`, `update_time`, `deleted`)
+SELECT '璁惧缁存姢涓庢淇鐞�', '', 1, 3, @dev_id, 'maintenance', 'ep:tools', NULL, NULL, 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'
+FROM DUAL WHERE @dev_maint_dir IS NULL;
+SET @dev_maint_dir = (SELECT id FROM `system_menu` WHERE deleted = b'0' AND type = 1 AND parent_id = @dev_id AND name = '璁惧缁存姢涓庢淇鐞�' ORDER BY id LIMIT 1);
+UPDATE `system_menu` SET `name` = '鐐规淇濆吇椤圭洰', `parent_id` = @dev_maint_dir, `sort` = 1,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW()
+WHERE `id` = 5330;
+UPDATE `system_menu` SET `name` = '鐐规淇濆吇鏂规', `parent_id` = @dev_maint_dir, `sort` = 2,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW()
+WHERE `id` = 5350;
+UPDATE `system_menu` SET `name` = '鐐规璁板綍', `parent_id` = @dev_maint_dir, `sort` = 3,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW()
+WHERE `id` = 5360;
+UPDATE `system_menu` SET `name` = '淇濆吇璁板綍', `parent_id` = @dev_maint_dir, `sort` = 4,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW()
+WHERE `id` = 5340;
+
+-- 3.4 鏁版嵁宸ュ叿涓庢壒閲忔搷浣滐紙璁惧缁熻鍒嗘瀽锛�
+UPDATE `system_menu` SET `name` = '鏁版嵁宸ュ叿涓庢壒閲忔搷浣�', `parent_id` = @dev_id, `sort` = 4,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW()
+WHERE `id` = 1075521;
+
+-- ==================== 5. 閲囪喘绠$悊 ====================
+-- 4.1 渚涘簲鍟嗙鐞嗭紙鐩綍锛氫緵搴斿晢妗f / 鍚堝悓绠$悊锛�
+UPDATE `system_menu` SET `name` = '渚涘簲鍟嗙鐞�', `parent_id` = @pur_id, `sort` = 1,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW()
+WHERE `id` = 602524;
+UPDATE `system_menu` SET `name` = '渚涘簲鍟嗘。妗�', `parent_id` = 602524, `sort` = 1,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW()
+WHERE `id` = 602525;
+UPDATE `system_menu` SET `name` = '鍚堝悓绠$悊', `parent_id` = 602524, `sort` = 2,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW()
+WHERE `id` = 1075523;
+
+-- 4.2 閲囪喘涓嬪崟
+UPDATE `system_menu` SET `name` = '閲囪喘涓嬪崟', `parent_id` = @pur_id, `sort` = 2,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW()
+WHERE `id` = 1075529;
+
+-- 4.3 閲囪喘鐢宠鍗曪紙鐩綍锛氱敵璇峰崟鍒楄〃 / 閲囪喘鐢宠缁熻锛�
+SET @req_dir = (SELECT id FROM `system_menu` WHERE deleted = b'0' AND type = 1 AND parent_id = @pur_id AND name = '閲囪喘鐢宠鍗�' ORDER BY id LIMIT 1);
+INSERT INTO `system_menu` (`name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `component_name`, `status`, `visible`, `keep_alive`, `always_show`, `creator`, `create_time`, `updater`, `update_time`, `deleted`)
+SELECT '閲囪喘鐢宠鍗�', '', 1, 3, @pur_id, 'request-bill', 'ep:document-add', NULL, NULL, 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'
+FROM DUAL WHERE @req_dir IS NULL;
+SET @req_dir = (SELECT id FROM `system_menu` WHERE deleted = b'0' AND type = 1 AND parent_id = @pur_id AND name = '閲囪喘鐢宠鍗�' ORDER BY id LIMIT 1);
+UPDATE `system_menu` SET `name` = '鐢宠鍗曞垪琛�', `parent_id` = @req_dir, `sort` = 1,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW()
+WHERE `id` = 602498;
+UPDATE `system_menu` SET `name` = '閲囪喘鐢宠缁熻', `parent_id` = @req_dir, `sort` = 2,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW()
+WHERE `id` = 1075536;
+
+-- 4.4 鐢宠閲囪喘鍗�
+UPDATE `system_menu` SET `name` = '鐢宠閲囪喘鍗�', `parent_id` = @pur_id, `sort` = 4,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW()
+WHERE `id` = 1075530;
+
+-- 4.5 閲囪喘璁㈠崟
+UPDATE `system_menu` SET `name` = '閲囪喘璁㈠崟', `parent_id` = @pur_id, `sort` = 5,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW()
+WHERE `id` = 2666;
+
+-- ==================== 6. 浠撳偍鐗╂祦 ====================
+-- 5.1 浠撳簱绠$悊锛堢洰褰曪級
+SET @wh_dir = (SELECT id FROM `system_menu` WHERE deleted = b'0' AND type = 1 AND parent_id = @wms_id AND name = '浠撳簱绠$悊' ORDER BY id LIMIT 1);
+INSERT INTO `system_menu` (`name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `component_name`, `status`, `visible`, `keep_alive`, `always_show`, `creator`, `create_time`, `updater`, `update_time`, `deleted`)
+SELECT '浠撳簱绠$悊', '', 1, 1, @wms_id, 'warehouse-manage', 'ep:house', NULL, NULL, 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'
+FROM DUAL WHERE @wh_dir IS NULL;
+SET @wh_dir = (SELECT id FROM `system_menu` WHERE deleted = b'0' AND type = 1 AND parent_id = @wms_id AND name = '浠撳簱绠$悊' ORDER BY id LIMIT 1);
+UPDATE `system_menu` SET `name` = '浠撳簱璁剧疆', `parent_id` = @wh_dir, `sort` = 1,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW() WHERE `id` = 5781;
+UPDATE `system_menu` SET `name` = '搴撳瓨鐜版湁閲�', `parent_id` = @wh_dir, `sort` = 2,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW() WHERE `id` = 5786;
+UPDATE `system_menu` SET `name` = '搴撳瓨棰勮', `parent_id` = @wh_dir, `sort` = 3,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW() WHERE `id` = 1075538;
+UPDATE `system_menu` SET `name` = '杞Щ璋冩嫧', `parent_id` = @wh_dir, `sort` = 4,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW() WHERE `id` = 5922;
+UPDATE `system_menu` SET `name` = '鐩樼偣鏂规', `parent_id` = @wh_dir, `sort` = 5,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW() WHERE `id` = 5951;
+UPDATE `system_menu` SET `name` = '鐩樼偣浠诲姟', `parent_id` = @wh_dir, `sort` = 6,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW() WHERE `id` = 5957;
+UPDATE `system_menu` SET `name` = '搴撳瓨浜嬪姟娴佹按', `parent_id` = @wh_dir, `sort` = 7,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW() WHERE `id` = 602476;
+
+-- 5.2 鍑哄叆搴撶鐞嗭紙鐩綍锛�
+SET @io_dir = (SELECT id FROM `system_menu` WHERE deleted = b'0' AND type = 1 AND parent_id = @wms_id AND name = '鍑哄叆搴撶鐞�' ORDER BY id LIMIT 1);
+INSERT INTO `system_menu` (`name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `component_name`, `status`, `visible`, `keep_alive`, `always_show`, `creator`, `create_time`, `updater`, `update_time`, `deleted`)
+SELECT '鍑哄叆搴撶鐞�', '', 1, 2, @wms_id, 'in-out', 'ep:sort', NULL, NULL, 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'
+FROM DUAL WHERE @io_dir IS NULL;
+SET @io_dir = (SELECT id FROM `system_menu` WHERE deleted = b'0' AND type = 1 AND parent_id = @wms_id AND name = '鍑哄叆搴撶鐞�' ORDER BY id LIMIT 1);
+UPDATE `system_menu` SET `name` = '閲囪喘鍏ュ簱', `parent_id` = @io_dir, `sort` = 1,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW() WHERE `id` = 5798;
+UPDATE `system_menu` SET `name` = '浜у搧鍏ュ簱', `parent_id` = @io_dir, `sort` = 2,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW() WHERE `id` = 5819;
+UPDATE `system_menu` SET `name` = '鍙戣揣閫氱煡', `parent_id` = @io_dir, `sort` = 3,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW() WHERE `id` = 5867;
+UPDATE `system_menu` SET `name` = '閿�鍞嚭搴�', `parent_id` = @io_dir, `sort` = 4,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW() WHERE `id` = 5970;
+
+-- 5.3 鍒嗘嫞閰嶉��
+UPDATE `system_menu` SET `name` = '鍒嗘嫞閰嶉��', `parent_id` = @wms_id, `sort` = 3,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW() WHERE `id` = 1075543;
+
+-- ==================== 7. 钀ラ攢绠$悊 ====================
+-- 6.1 寮�鍗� + 6.2 璁㈠崟绠$悊锛氬悓涓�寮犻攢鍞鍗曪紙銆屾柊澧炪�嶅嵆浠e/绐楀彛寮�鍗曪級锛屽悎骞朵负銆岃鍗曠鐞嗐�嶄竴涓彍鍗曪紝涓嶉噸澶嶅缓鑿滃崟銆�
+UPDATE `system_menu` SET `name` = '璁㈠崟绠$悊', `parent_id` = @sale_id, `sort` = 1,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW() WHERE `id` = 2638;
+-- 6.3 閫�璐х鐞�
+UPDATE `system_menu` SET `name` = '閫�璐х鐞�', `parent_id` = @sale_id, `sort` = 2,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW() WHERE `id` = 5847;
+-- 6.4 鎶ヤ环鍗�
+UPDATE `system_menu` SET `name` = '鎶ヤ环鍗�', `parent_id` = @sale_id, `sort` = 3,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW() WHERE `id` = 602512;
+-- 6.5 棰勮璐х鐞�
+UPDATE `system_menu` SET `name` = '棰勮璐х鐞�', `parent_id` = @sale_id, `sort` = 4,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW() WHERE `id` = 1075568;
+-- 6.6 瀹㈡埛绠$悊
+UPDATE `system_menu` SET `name` = '瀹㈡埛绠$悊', `parent_id` = @sale_id, `sort` = 5,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW() WHERE `id` = 2391;
+-- 6.7 閿�鍞粺璁★紙鐩綍锛�
+UPDATE `system_menu` SET `name` = '閿�鍞粺璁�', `parent_id` = @sale_id, `sort` = 6,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW() WHERE `id` = 2560;
+UPDATE `system_menu` SET `name` = '閿�鍞缁熻', `parent_id` = 2560, `sort` = 6,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW() WHERE `id` = 1075574;
+
+-- ==================== 8. 浜哄姏璧勬簮 ====================
+UPDATE `system_menu` SET `name` = '鍚堝悓绠$悊', `parent_id` = @hrm_id, `sort` = 1,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW() WHERE `id` = 1063105;
+UPDATE `system_menu` SET `name` = '璧勪骇绠$悊', `parent_id` = @hrm_id, `sort` = 2,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW() WHERE `id` = 1075548;
+UPDATE `system_menu` SET `name` = '鍛樺伐绠$悊', `parent_id` = @hrm_id, `sort` = 3,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW() WHERE `id` = 6006;
+UPDATE `system_menu` SET `name` = '鍔炲叕鐢ㄥ搧绠$悊', `parent_id` = @hrm_id, `sort` = 4,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW() WHERE `id` = 1075557;
+
+-- 7.5 缁勭粐鏈烘瀯绠$悊锛堢洰褰曪細閮ㄩ棬绠$悊 / 宀椾綅绠$悊锛�
+SET @org_dir = (SELECT id FROM `system_menu` WHERE deleted = b'0' AND type = 1 AND parent_id = @hrm_id AND name = '缁勭粐鏈烘瀯绠$悊' ORDER BY id LIMIT 1);
+INSERT INTO `system_menu` (`name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `component_name`, `status`, `visible`, `keep_alive`, `always_show`, `creator`, `create_time`, `updater`, `update_time`, `deleted`)
+SELECT '缁勭粐鏈烘瀯绠$悊', '', 1, 5, @hrm_id, 'organization', 'ep:office-building', NULL, NULL, 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'
+FROM DUAL WHERE @org_dir IS NULL;
+SET @org_dir = (SELECT id FROM `system_menu` WHERE deleted = b'0' AND type = 1 AND parent_id = @hrm_id AND name = '缁勭粐鏈烘瀯绠$悊' ORDER BY id LIMIT 1);
+UPDATE `system_menu` SET `name` = '閮ㄩ棬绠$悊', `parent_id` = @org_dir, `sort` = 1,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW() WHERE `id` = 103;
+UPDATE `system_menu` SET `name` = '宀椾綅绠$悊', `parent_id` = @org_dir, `sort` = 2,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW() WHERE `id` = 104;
+
+-- 7.6 璐﹀彿绠$悊
+UPDATE `system_menu` SET `name` = '璐﹀彿绠$悊', `parent_id` = @hrm_id, `sort` = 6,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW() WHERE `id` = 100;
+
+-- 7.7 浜轰簨瀹℃壒绠$悊
+UPDATE `system_menu` SET `name` = '浜轰簨瀹℃壒绠$悊', `parent_id` = @hrm_id, `sort` = 7,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW() WHERE `id` = 6002;
+-- 7.8 鑰冨嫟绠$悊
+UPDATE `system_menu` SET `name` = '鑰冨嫟绠$悊', `parent_id` = @hrm_id, `sort` = 8,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW() WHERE `id` = 6010;
+-- 7.9 钖祫绠$悊
+UPDATE `system_menu` SET `name` = '钖祫绠$悊', `parent_id` = @hrm_id, `sort` = 9,
+ `status` = 0, `visible` = b'1', `deleted` = b'0', `updater` = '1', `update_time` = NOW() WHERE `id` = 6020;
+
+-- ==================== 9. 涓烘柊鑿滃崟琛ヨ鑹叉槧灏勶紙鎸夊悓绾у凡鏈夎彍鍗曞鍒讹級 ====================
+-- 棰嗘枡绠$悊鐩綍锛氬鍒躲�岄鏂欏嚭搴撱�嶇殑瑙掕壊
+INSERT INTO `system_role_menu` (`role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`)
+SELECT DISTINCT rm.`role_id`, @issue_dir, '1', NOW(), '1', NOW(), b'0'
+FROM `system_role_menu` rm
+WHERE rm.`menu_id` = 5805
+ AND NOT EXISTS (SELECT 1 FROM `system_role_menu` x WHERE x.`role_id` = rm.`role_id` AND x.`menu_id` = @issue_dir);
+
+-- 閲囪喘鐢宠鍗曠洰褰曪細澶嶅埗銆岄噰璐敵璇枫�嶇殑瑙掕壊
+INSERT INTO `system_role_menu` (`role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`)
+SELECT DISTINCT rm.`role_id`, @req_dir, '1', NOW(), '1', NOW(), b'0'
+FROM `system_role_menu` rm
+WHERE rm.`menu_id` = 602498
+ AND NOT EXISTS (SELECT 1 FROM `system_role_menu` x WHERE x.`role_id` = rm.`role_id` AND x.`menu_id` = @req_dir);
+
+-- 缁勭粐鏈烘瀯绠$悊鐩綍锛氬鍒躲�岄儴闂ㄧ鐞嗐�嶇殑瑙掕壊
+INSERT INTO `system_role_menu` (`role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`)
+SELECT DISTINCT rm.`role_id`, @org_dir, '1', NOW(), '1', NOW(), b'0'
+FROM `system_role_menu` rm
+WHERE rm.`menu_id` = 103
+ AND NOT EXISTS (SELECT 1 FROM `system_role_menu` x WHERE x.`role_id` = rm.`role_id` AND x.`menu_id` = @org_dir);
+
+-- 璁惧鐘舵�佷笌鏃ュ父鎿嶄綔鐩綍锛氬鍒躲�岃澶囧熀纭�淇℃伅绠$悊銆嶇殑瑙掕壊
+INSERT INTO `system_role_menu` (`role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`)
+SELECT DISTINCT rm.`role_id`, @dev_daily_dir, '1', NOW(), '1', NOW(), b'0'
+FROM `system_role_menu` rm
+WHERE rm.`menu_id` = 5320
+ AND NOT EXISTS (SELECT 1 FROM `system_role_menu` x WHERE x.`role_id` = rm.`role_id` AND x.`menu_id` = @dev_daily_dir);
+
+-- 璁惧缁存姢涓庢淇鐞嗙洰褰曪細澶嶅埗銆岃澶囧熀纭�淇℃伅绠$悊銆嶇殑瑙掕壊
+INSERT INTO `system_role_menu` (`role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`)
+SELECT DISTINCT rm.`role_id`, @dev_maint_dir, '1', NOW(), '1', NOW(), b'0'
+FROM `system_role_menu` rm
+WHERE rm.`menu_id` = 5320
+ AND NOT EXISTS (SELECT 1 FROM `system_role_menu` x WHERE x.`role_id` = rm.`role_id` AND x.`menu_id` = @dev_maint_dir);
+
+-- 浠撳簱绠$悊鐩綍锛氬鍒躲�屼粨搴撹缃�嶇殑瑙掕壊
+INSERT INTO `system_role_menu` (`role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`)
+SELECT DISTINCT rm.`role_id`, @wh_dir, '1', NOW(), '1', NOW(), b'0'
+FROM `system_role_menu` rm
+WHERE rm.`menu_id` = 5781
+ AND NOT EXISTS (SELECT 1 FROM `system_role_menu` x WHERE x.`role_id` = rm.`role_id` AND x.`menu_id` = @wh_dir);
+
+-- 鍑哄叆搴撶鐞嗙洰褰曪細澶嶅埗銆岄噰璐叆搴撱�嶇殑瑙掕壊
+INSERT INTO `system_role_menu` (`role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`)
+SELECT DISTINCT rm.`role_id`, @io_dir, '1', NOW(), '1', NOW(), b'0'
+FROM `system_role_menu` rm
+WHERE rm.`menu_id` = 5798
+ AND NOT EXISTS (SELECT 1 FROM `system_role_menu` x WHERE x.`role_id` = rm.`role_id` AND x.`menu_id` = @io_dir);
+
+-- ==================== 10. 闅愯棌鏂规鏈秹鍙婄殑椤甸潰 ====================
+DROP TEMPORARY TABLE IF EXISTS `tmp_keep_menu`;
+CREATE TEMPORARY TABLE `tmp_keep_menu` (`id` bigint NOT NULL PRIMARY KEY);
+INSERT INTO `tmp_keep_menu` (`id`) VALUES
+-- 璁″垝鎺掔▼
+(@plan_id), (602504),
+-- 鐢熶骇绠℃帶
+(@prod_id), (5530), (5550), (@issue_dir), (5805), (5840),
+-- 璁惧绠$悊
+(@dev_id), (5320), (@dev_daily_dir), (1075514), (5370),
+(@dev_maint_dir), (5330), (5350), (5360), (5340), (1075521),
+-- 閲囪喘绠$悊锛堥噰璐笅鍗曞凡骞跺叆閲囪喘璁㈠崟椤电銆佺敵璇烽噰璐崟宸插苟鍏ラ噰璐敵璇峰崟椤电锛屽潎闅愯棌锛�
+(@pur_id), (602524), (602525), (1075523),
+(@req_dir), (602498), (1075536), (2666),
+-- 浠撳偍鐗╂祦
+(@wms_id), (@wh_dir), (5781), (5786), (1075538), (5922), (5951), (5957), (602476),
+(@io_dir), (5798), (5819), (5867), (5970), (1075543),
+-- 钀ラ攢绠$悊
+(@sale_id), (2638), (5847), (602512), (1075568), (2391),
+(2560), (2712), (2561), (2736), (2737), (2738), (1075574),
+-- 浜哄姏璧勬簮
+(@hrm_id), (1063105), (1075548), (6006), (1075557),
+(@org_dir), (103), (104), (100), (6002), (6003), (6004), (6005), (1065211),
+(6010), (6013), (6011), (6012), (6014), (6015), (6016), (6017),
+(6020), (6021), (6022), (6023), (602445), (602449), (6024);
+
+-- 璁$畻 7 涓笟鍔℃ā鍧椾笅鐨勫叏閮ㄧ洰褰�/鑿滃崟
+DROP TEMPORARY TABLE IF EXISTS `tmp_business_menu`;
+CREATE TEMPORARY TABLE `tmp_business_menu` (`id` bigint NOT NULL PRIMARY KEY);
+INSERT INTO `tmp_business_menu` (`id`)
+WITH RECURSIVE tree AS (
+ SELECT `id` FROM `system_menu`
+ WHERE `deleted` = b'0' AND `parent_id` = 0
+ AND `id` IN (@plan_id, @prod_id, @dev_id, @pur_id, @wms_id, @sale_id, @hrm_id)
+ UNION ALL
+ SELECT m.`id` FROM `system_menu` m
+ JOIN tree t ON m.`parent_id` = t.`id`
+ WHERE m.`deleted` = b'0'
+)
+SELECT `id` FROM tree;
+
+-- 淇濈暀椤瑰彲瑙�
+UPDATE `system_menu` SET `visible` = b'1', `status` = 0
+WHERE `deleted` = b'0' AND `type` IN (1, 2)
+ AND `id` IN (SELECT `id` FROM `tmp_keep_menu`);
+
+-- 涓氬姟妯″潡鍐呮柟妗堟湭娑夊強鐨勯〉闈㈤殣钘�
+UPDATE `system_menu` SET `visible` = b'0'
+WHERE `deleted` = b'0' AND `type` IN (1, 2)
+ AND `id` IN (SELECT `id` FROM `tmp_business_menu`)
+ AND `id` NOT IN (SELECT `id` FROM `tmp_keep_menu`);
+
+DROP TEMPORARY TABLE IF EXISTS `tmp_keep_menu`;
+DROP TEMPORARY TABLE IF EXISTS `tmp_business_menu`;
+
+COMMIT;
+
+-- ==================== 楠岃瘉 ====================
+-- 1) 涓�绾ц彍鍗�
+SELECT `id`, `name`, `sort`, `visible` FROM `system_menu`
+WHERE `deleted` = b'0' AND `parent_id` = 0 AND `type` = 1 ORDER BY `sort`;
+-- 2) 涓氬姟妯″潡浜岀骇鑿滃崟
+SELECT p.`name` AS module, m.`id`, m.`name`, m.`type`, m.`sort`, m.`visible`
+FROM `system_menu` m JOIN `system_menu` p ON p.`id` = m.`parent_id`
+WHERE m.`deleted` = b'0' AND m.`type` IN (1, 2)
+ AND p.`parent_id` = 0 AND p.`id` IN (@plan_id, @prod_id, @dev_id, @pur_id, @wms_id, @sale_id, @hrm_id)
+ORDER BY p.`sort`, m.`sort`;
diff --git a/sql/mysql/mes_bom_menu_20261102.sql b/sql/mysql/mes_bom_menu_20261102.sql
new file mode 100644
index 0000000..754c596
--- /dev/null
+++ b/sql/mysql/mes_bom_menu_20261102.sql
@@ -0,0 +1,172 @@
+-- =============================================
+-- MES 鐢熶骇鍩虹鏁版嵁锛氱墿鏂橞OM缁存姢 / 宸ュ簭绠$悊 / 宸ヨ壓璺嚎 鑿滃崟涓庢潈闄�
+-- 鑳屾櫙锛歁PS 杈呮枡鏄庣粏銆佸伐鍗曡緟鏂欓瑙堟寜 BOM 灞曞紑璁$畻锛屼絾缁存姢鍏ュ彛鏈寕鑿滃崟锛�
+-- 1) 鐗╂枡BOM缁存姢 鈫� MES 鐗╂枡椤碉紙鍚�孊OM 缁勬垚銆嶉〉绛撅級锛岀淮鎶や骇鍝� BOM锛坢es_md_product_bom锛�
+-- 2) 宸ュ簭绠$悊 鈫� 缁存姢鐢熶骇宸ュ簭锛坢es_pro_process锛夛紝宸ヨ壓璺嚎蹇呴』鎸傚伐搴�
+-- 3) 宸ヨ壓璺嚎 鈫� 缁存姢璺嚎銆佷骇鍑轰骇鍝併�佸伐搴忔姇鏂欙紙mes_pro_route_*锛夛紝璺嚎鎶曟枡浼樺厛浜庝骇鍝� BOM
+-- 鍙噸澶嶆墽琛岋紝涓嶅寘鍚� tenant_id锛堥」鐩笉浣跨敤澶氱鎴凤級
+-- =============================================
+START TRANSACTION;
+
+-- =============================================
+-- 0. 鐩綍锛氱敓浜у熀纭�鏁版嵁锛堜笉瀛樺湪鏃惰ˉ寤猴紝鎸傚湪 鐢熶骇绠℃帶 涓嬶級
+-- =============================================
+SET @prod_root = (SELECT id FROM system_menu WHERE deleted = b'0' AND name = '鐢熶骇绠℃帶' AND parent_id = 0 LIMIT 1);
+SET @base_dir = (SELECT id FROM system_menu WHERE deleted = b'0' AND name = '鐢熶骇鍩虹鏁版嵁' AND parent_id = @prod_root LIMIT 1);
+
+INSERT INTO system_menu(id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
+SELECT (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '鐢熶骇鍩虹鏁版嵁', '', 1, 1, @prod_root, 'md', 'ep:data-analysis', NULL, NULL, 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'
+FROM DUAL
+WHERE @prod_root IS NOT NULL AND @base_dir IS NULL;
+
+SET @base_dir = (SELECT id FROM system_menu WHERE deleted = b'0' AND name = '鐢熶骇鍩虹鏁版嵁' AND parent_id = @prod_root LIMIT 1);
+
+-- 鐩綍姝ゅ墠鍙兘鏄殣钘忕姸鎬侊紙visible=0锛夋垨鍋滅敤鐘舵�侊紙status<>0锛夛紝浼氬鑷村瓙鑿滃崟鍦ㄤ晶杈规爮瀹屽叏涓嶆樉绀猴紝缁熶竴缃负鏄剧ず銆佸惎鐢�
+UPDATE system_menu
+SET visible = b'1', status = 0, updater = '1', update_time = NOW()
+WHERE deleted = b'0' AND id = @base_dir AND (visible = b'0' OR status <> 0);
+
+-- =============================================
+-- 1. 椤甸潰鑿滃崟
+-- =============================================
+-- 1.1 鐗╂枡BOM缁存姢锛圡ES 鐗╂枡椤碉紝缂栬緫寮圭獥鍐呭惈銆孊OM 缁勬垚銆嶉〉绛撅級
+INSERT INTO system_menu(id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
+SELECT (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '鐗╂枡BOM缁存姢', '', 2, 1, @base_dir, 'item-bom', 'ep:box', 'mes/md/item/index', NULL, 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'
+FROM DUAL
+WHERE @base_dir IS NOT NULL
+ AND NOT EXISTS (SELECT 1 FROM system_menu WHERE deleted = b'0' AND component = 'mes/md/item/index');
+
+-- 1.2 宸ュ簭绠$悊
+INSERT INTO system_menu(id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
+SELECT (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '宸ュ簭绠$悊', '', 2, 2, @base_dir, 'process', 'ep:operation', 'mes/pro/process/index', NULL, 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'
+FROM DUAL
+WHERE @base_dir IS NOT NULL
+ AND NOT EXISTS (SELECT 1 FROM system_menu WHERE deleted = b'0' AND component = 'mes/pro/process/index');
+
+-- 1.3 宸ヨ壓璺嚎锛堝惈浜у嚭浜у搧銆佸伐搴忋�佸伐搴忔姇鏂欙級
+INSERT INTO system_menu(id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
+SELECT (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '宸ヨ壓璺嚎', '', 2, 3, @base_dir, 'route', 'ep:guide', 'mes/pro/route/index', NULL, 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'
+FROM DUAL
+WHERE @base_dir IS NOT NULL
+ AND NOT EXISTS (SELECT 1 FROM system_menu WHERE deleted = b'0' AND component = 'mes/pro/route/index');
+
+SET @page_item = (SELECT id FROM system_menu WHERE deleted = b'0' AND component = 'mes/md/item/index' ORDER BY id LIMIT 1);
+SET @page_process = (SELECT id FROM system_menu WHERE deleted = b'0' AND component = 'mes/pro/process/index' ORDER BY id LIMIT 1);
+SET @page_route = (SELECT id FROM system_menu WHERE deleted = b'0' AND component = 'mes/pro/route/index' ORDER BY id LIMIT 1);
+
+-- =============================================
+-- 2. 鎸夐挳鏉冮檺
+-- =============================================
+-- 2.1 鐗╂枡BOM缁存姢锛圔OM 缁勬垚鐨勫鍒犳敼涓庣墿鏂欏鍑哄叡鐢� mes:md-item:* 鏉冮檺鐮侊級
+INSERT INTO system_menu(id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
+SELECT (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '鐗╂枡BOM-鏂板', 'mes:md-item:create', 3, 1, @page_item, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'
+FROM DUAL
+WHERE @page_item IS NOT NULL
+ AND NOT EXISTS (SELECT 1 FROM system_menu WHERE deleted = b'0' AND permission = 'mes:md-item:create');
+
+INSERT INTO system_menu(id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
+SELECT (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '鐗╂枡BOM-缂栬緫', 'mes:md-item:update', 3, 2, @page_item, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'
+FROM DUAL
+WHERE @page_item IS NOT NULL
+ AND NOT EXISTS (SELECT 1 FROM system_menu WHERE deleted = b'0' AND permission = 'mes:md-item:update');
+
+INSERT INTO system_menu(id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
+SELECT (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '鐗╂枡BOM-鍒犻櫎', 'mes:md-item:delete', 3, 3, @page_item, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'
+FROM DUAL
+WHERE @page_item IS NOT NULL
+ AND NOT EXISTS (SELECT 1 FROM system_menu WHERE deleted = b'0' AND permission = 'mes:md-item:delete');
+
+INSERT INTO system_menu(id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
+SELECT (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '鐗╂枡BOM-瀵煎嚭', 'mes:md-item:export', 3, 4, @page_item, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'
+FROM DUAL
+WHERE @page_item IS NOT NULL
+ AND NOT EXISTS (SELECT 1 FROM system_menu WHERE deleted = b'0' AND permission = 'mes:md-item:export');
+
+-- 2.2 宸ュ簭绠$悊
+INSERT INTO system_menu(id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
+SELECT (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '宸ュ簭-鏂板', 'mes:pro-process:create', 3, 1, @page_process, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'
+FROM DUAL
+WHERE @page_process IS NOT NULL
+ AND NOT EXISTS (SELECT 1 FROM system_menu WHERE deleted = b'0' AND permission = 'mes:pro-process:create');
+
+INSERT INTO system_menu(id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
+SELECT (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '宸ュ簭-缂栬緫', 'mes:pro-process:update', 3, 2, @page_process, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'
+FROM DUAL
+WHERE @page_process IS NOT NULL
+ AND NOT EXISTS (SELECT 1 FROM system_menu WHERE deleted = b'0' AND permission = 'mes:pro-process:update');
+
+INSERT INTO system_menu(id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
+SELECT (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '宸ュ簭-鍒犻櫎', 'mes:pro-process:delete', 3, 3, @page_process, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'
+FROM DUAL
+WHERE @page_process IS NOT NULL
+ AND NOT EXISTS (SELECT 1 FROM system_menu WHERE deleted = b'0' AND permission = 'mes:pro-process:delete');
+
+INSERT INTO system_menu(id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
+SELECT (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '宸ュ簭-瀵煎嚭', 'mes:pro-process:export', 3, 4, @page_process, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'
+FROM DUAL
+WHERE @page_process IS NOT NULL
+ AND NOT EXISTS (SELECT 1 FROM system_menu WHERE deleted = b'0' AND permission = 'mes:pro-process:export');
+
+-- 2.3 宸ヨ壓璺嚎锛堜骇鍝併�佸伐搴忋�佸伐搴忔姇鏂欑殑鏂板/淇敼缁熶竴浣跨敤 mes:pro-route:update锛�
+INSERT INTO system_menu(id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
+SELECT (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '宸ヨ壓璺嚎-鏂板', 'mes:pro-route:create', 3, 1, @page_route, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'
+FROM DUAL
+WHERE @page_route IS NOT NULL
+ AND NOT EXISTS (SELECT 1 FROM system_menu WHERE deleted = b'0' AND permission = 'mes:pro-route:create');
+
+INSERT INTO system_menu(id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
+SELECT (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '宸ヨ壓璺嚎-缂栬緫', 'mes:pro-route:update', 3, 2, @page_route, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'
+FROM DUAL
+WHERE @page_route IS NOT NULL
+ AND NOT EXISTS (SELECT 1 FROM system_menu WHERE deleted = b'0' AND permission = 'mes:pro-route:update');
+
+INSERT INTO system_menu(id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
+SELECT (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '宸ヨ壓璺嚎-鍒犻櫎', 'mes:pro-route:delete', 3, 3, @page_route, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'
+FROM DUAL
+WHERE @page_route IS NOT NULL
+ AND NOT EXISTS (SELECT 1 FROM system_menu WHERE deleted = b'0' AND permission = 'mes:pro-route:delete');
+
+INSERT INTO system_menu(id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
+SELECT (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '宸ヨ壓璺嚎-瀵煎嚭', 'mes:pro-route:export', 3, 4, @page_route, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'
+FROM DUAL
+WHERE @page_route IS NOT NULL
+ AND NOT EXISTS (SELECT 1 FROM system_menu WHERE deleted = b'0' AND permission = 'mes:pro-route:export');
+
+INSERT INTO system_menu(id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
+SELECT (SELECT IFNULL(MAX(id), 0) + 1 FROM system_menu), '宸ヨ壓璺嚎-瀵煎叆', 'mes:pro-route:import', 3, 5, @page_route, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'
+FROM DUAL
+WHERE @page_route IS NOT NULL
+ AND NOT EXISTS (SELECT 1 FROM system_menu WHERE deleted = b'0' AND permission = 'mes:pro-route:import');
+
+-- =============================================
+-- 3. 鎺堟潈
+-- 鐢熶骇绠$悊鍛�(SC)銆佺粡鐞�(JL)锛氬叏閮�
+-- 鐢熶骇鍛�(SCY)锛氭煡鐪� + 缂栬緫/瀵煎嚭锛堜笉鎺堜簣鏂板銆佸垹闄ゃ�佸鍏ワ級
+-- =============================================
+INSERT INTO system_role_menu(role_id, menu_id, creator, create_time, updater, update_time, deleted)
+SELECT r.id, m.id, '1', NOW(), '1', NOW(), b'0'
+FROM system_role r
+JOIN system_menu m ON m.deleted = b'0' AND (
+ m.id = @base_dir
+ OR m.parent_id IN (@page_item, @page_process, @page_route)
+ OR m.id IN (@page_item, @page_process, @page_route))
+ -- 鏂板/鍒犻櫎/瀵煎叆灞炰簬绠$悊鍔ㄤ綔锛岀敓浜у憳涓嶆巿浜堬紙瑙佷笅鏂瑰崟鐙巿鏉冩锛�
+ AND COALESCE(m.permission, '') NOT IN ('mes:md-item:create', 'mes:md-item:delete',
+ 'mes:pro-process:create', 'mes:pro-process:delete',
+ 'mes:pro-route:create', 'mes:pro-route:delete', 'mes:pro-route:import')
+WHERE r.deleted = b'0' AND r.code IN ('SC', 'SCY', 'JL')
+ 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');
+
+INSERT INTO system_role_menu(role_id, menu_id, creator, create_time, updater, update_time, deleted)
+SELECT r.id, m.id, '1', NOW(), '1', NOW(), b'0'
+FROM system_role r
+JOIN system_menu m ON m.deleted = b'0'
+ AND m.permission IN ('mes:md-item:create', 'mes:md-item:delete',
+ 'mes:pro-process:create', 'mes:pro-process:delete',
+ 'mes:pro-route:create', 'mes:pro-route:delete', 'mes:pro-route:import')
+WHERE r.deleted = b'0' AND r.code IN ('SC', 'JL')
+ 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');
+
+COMMIT;
--
Gitblit v1.9.3