From 84421ba2a36aa86699c80969f9d3d3be8c011bd9 Mon Sep 17 00:00:00 2001
From: gaoluyang <2820782392@qq.com>
Date: 星期一, 02 十一月 2026 11:26:25 +0800
Subject: [PATCH] 恢复工作流菜单:协同办公/审批中心/流程管理

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

diff --git a/docs/sql/cfwj_bpm_menu_restore.sql b/docs/sql/cfwj_bpm_menu_restore.sql
new file mode 100644
index 0000000..7877297
--- /dev/null
+++ b/docs/sql/cfwj_bpm_menu_restore.sql
@@ -0,0 +1,77 @@
+-- ============================================================
+-- 璇氬彂浜旈噾锛氭仮澶嶅伐浣滄祦锛堝崗鍚屽姙鍏� / 瀹℃壒涓績 / 娴佺▼绠$悊锛夎彍鍗�
+-- 鑳屾櫙锛欱PM 娴佺▼瀹氫箟銆佽〃鍗曘�佸垎绫汇�佸緟鍔炴暟鎹潎鍦ㄥ簱涓紝浣嗚彍鍗曟爲琚鍓紝
+--       鍙墿鑻ュ共瀛ょ珛鐨勬寜閽潈闄愶紙濡� bpm:form:query銆乥pm:task:query锛夛紝
+--       瀵艰嚧銆屾彁浜ゅ鎵广�嶅悗瀹℃壒浜烘病鏈夊緟鍔炲叆鍙o紝涓氬姟鍗曟嵁鏃犳硶娴佽浆銆�
+-- 鐩爣搴擄細璇氬彂浜旈噾瀹㈡埛搴擄紙鏈湴涓� CFWJ锛夛紝璇锋寜瀹為檯搴撳悕鎵ц鎴栧厛 USE銆�
+-- 骞傜瓑锛歊EPLACE 鎸夊浐瀹氳彍鍗� ID 瑕嗙洊锛涜鑹叉巿鏉冩寜 code + NOT EXISTS 鍘婚噸銆�
+-- 娉ㄦ剰锛氭湰鑴氭湰涓嶅惈 tenant_id锛堝崟绉熸埛锛夈��
+-- ============================================================
+
+-- 1. 鑿滃崟涓庢寜閽潈闄愶紙ID 娌跨敤鏍囧噯 BPM 鑿滃崟 ID锛岃鐩栧悓 ID 鐨勫巻鍙叉畫鐣欐寜閽級
+REPLACE INTO `system_menu`
+(`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `component_name`, `status`, `visible`, `keep_alive`, `always_show`)
+VALUES
+(1185,'鍗忓悓鍔炲叕','',1,50,0,'/bpm','fa:medium',NULL,NULL,0,b'1',b'0',b'1'),
+(1186,'娴佺▼绠$悊','',1,1,1185,'manager','fa:dedent',NULL,NULL,0,b'1',b'0',b'1'),
+(1200,'瀹℃壒涓績','',2,2,1185,'task','fa:tasks',NULL,NULL,0,b'1',b'0',b'1'),
+(1193,'娴佺▼妯″瀷','',2,1,1186,'model','fa-solid:project-diagram','bpm/model/index','BpmModel',0,b'1',b'0',b'1'),
+(1187,'娴佺▼琛ㄥ崟','',2,2,1186,'form','fa:hdd-o','bpm/form/index','BpmForm',0,b'1',b'0',b'1'),
+(2714,'娴佺▼鍒嗙被','',2,3,1186,'category','fa:object-ungroup','bpm/category/index','BpmCategory',0,b'1',b'0',b'1'),
+(1209,'鐢ㄦ埛鍒嗙粍','',2,4,1186,'user-group','fa:user-secret','bpm/group/index','BpmUserGroup',0,b'1',b'0',b'1'),
+(1188,'琛ㄥ崟鏌ヨ','bpm:form:query',3,1,1187,'','',NULL,NULL,0,b'1',b'0',b'1'),
+(1189,'琛ㄥ崟鍒涘缓','bpm:form:create',3,2,1187,'','',NULL,NULL,0,b'1',b'0',b'1'),
+(1190,'琛ㄥ崟鏇存柊','bpm:form:update',3,3,1187,'','',NULL,NULL,0,b'1',b'0',b'1'),
+(1191,'琛ㄥ崟鍒犻櫎','bpm:form:delete',3,4,1187,'','',NULL,NULL,0,b'1',b'0',b'1'),
+(1192,'琛ㄥ崟瀵煎嚭','bpm:form:export',3,5,1187,'','',NULL,NULL,0,b'1',b'0',b'1'),
+(1194,'妯″瀷鏌ヨ','bpm:model:query',3,1,1193,'','',NULL,NULL,0,b'1',b'0',b'1'),
+(1195,'妯″瀷鍒涘缓','bpm:model:create',3,2,1193,'','',NULL,NULL,0,b'1',b'0',b'1'),
+(1197,'妯″瀷鏇存柊','bpm:model:update',3,4,1193,'','',NULL,NULL,0,b'1',b'0',b'1'),
+(1198,'妯″瀷鍒犻櫎','bpm:model:delete',3,5,1193,'','',NULL,NULL,0,b'1',b'0',b'1'),
+(1199,'妯″瀷鍙戝竷','bpm:model:deploy',3,6,1193,'','',NULL,NULL,0,b'1',b'0',b'1'),
+(2913,'娴佺▼娓呯悊','bpm:model:clean',3,7,1193,'','',NULL,'',0,b'1',b'0',b'1'),
+(1215,'娴佺▼瀹氫箟鏌ヨ','bpm:process-definition:query',3,10,1193,'','',NULL,NULL,0,b'1',b'0',b'1'),
+(1216,'娴佺▼浠诲姟鍒嗛厤瑙勫垯鏌ヨ','bpm:task-assign-rule:query',3,20,1193,'','',NULL,NULL,0,b'1',b'0',b'1'),
+(1217,'娴佺▼浠诲姟鍒嗛厤瑙勫垯鍒涘缓','bpm:task-assign-rule:create',3,21,1193,'','',NULL,NULL,0,b'1',b'0',b'1'),
+(1218,'娴佺▼浠诲姟鍒嗛厤瑙勫垯鏇存柊','bpm:task-assign-rule:update',3,22,1193,'','',NULL,NULL,0,b'1',b'0',b'1'),
+(2720,'鍙戣捣娴佺▼','',2,0,1200,'create','fa-solid:grin-stars','bpm/processInstance/create/index','BpmProcessInstanceCreate',0,b'1',b'0',b'1'),
+(1201,'鎴戠殑娴佺▼','',2,1,1200,'my','fa-solid:book','bpm/processInstance/index','BpmProcessInstanceMy',0,b'1',b'0',b'1'),
+(1207,'寰呭姙浠诲姟','',2,10,1200,'todo','fa:slack','bpm/task/todo/index','BpmTodoTask',0,b'1',b'0',b'1'),
+(1208,'宸插姙浠诲姟','',2,20,1200,'done','fa:delicious','bpm/task/done/index','BpmDoneTask',0,b'1',b'0',b'1'),
+(2713,'鎶勯�佹垜鐨�','bpm:process-instance-cc:query',2,30,1200,'copy','ep:copy-document','bpm/task/copy/index','BpmProcessInstanceCopy',0,b'1',b'0',b'1'),
+(1202,'娴佺▼瀹炰緥鐨勬煡璇�','bpm:process-instance:query',3,1,1201,'','',NULL,NULL,0,b'1',b'0',b'1'),
+(1219,'娴佺▼瀹炰緥鐨勫垱寤�','bpm:process-instance:create',3,2,1201,'','',NULL,NULL,0,b'1',b'0',b'1'),
+(1220,'娴佺▼瀹炰緥鐨勫彇娑�','bpm:process-instance:cancel',3,3,1201,'','',NULL,NULL,0,b'1',b'0',b'1'),
+(1221,'娴佺▼浠诲姟鐨勬煡璇�','bpm:task:query',3,1,1207,'','',NULL,NULL,0,b'1',b'0',b'1'),
+(1222,'娴佺▼浠诲姟鐨勬洿鏂�','bpm:task:update',3,2,1207,'','',NULL,NULL,0,b'1',b'0',b'1'),
+(1210,'鐢ㄦ埛缁勬煡璇�','bpm:user-group:query',3,1,1209,'','',NULL,NULL,0,b'1',b'0',b'1'),
+(1211,'鐢ㄦ埛缁勫垱寤�','bpm:user-group:create',3,2,1209,'','',NULL,NULL,0,b'1',b'0',b'1'),
+(1212,'鐢ㄦ埛缁勬洿鏂�','bpm:user-group:update',3,3,1209,'','',NULL,NULL,0,b'1',b'0',b'1'),
+(1213,'鐢ㄦ埛缁勫垹闄�','bpm:user-group:delete',3,4,1209,'','',NULL,NULL,0,b'1',b'0',b'1'),
+(2715,'鍒嗙被鏌ヨ','bpm:category:query',3,1,2714,'','',NULL,'',0,b'1',b'0',b'1'),
+(2716,'鍒嗙被鍒涘缓','bpm:category:create',3,2,2714,'','',NULL,'',0,b'1',b'0',b'1'),
+(2717,'鍒嗙被鏇存柊','bpm:category:update',3,3,2714,'','',NULL,'',0,b'1',b'0',b'1'),
+(2718,'鍒嗙被鍒犻櫎','bpm:category:delete',3,4,2714,'','',NULL,'',0,b'1',b'0',b'1')
+;
+
+-- 2. 瀹℃壒涓績鎺堟潈锛氭鍓嶅凡鎸佹湁 BPM 鏌ヨ鎸夐挳鐨勮鑹诧紝鎭㈠鍚庡嵆鍙湅鍒板緟鍔�/宸插姙/鎴戠殑娴佺▼
+--    锛堟祦绋嬬鐞嗕粎瓒呯骇绠$悊鍛樺彲瑙侊紝涓嶅湪姝ゆ巿鏉冿級
+INSERT INTO `system_role_menu` (`role_id`, `menu_id`, `creator`, `updater`, `deleted`)
+SELECT r.`id`, m.`menu_id`, 'admin', 'admin', b'0'
+FROM `system_role` r
+CROSS JOIN (
+    SELECT 1185 AS `menu_id` UNION ALL SELECT 1200 UNION ALL SELECT 2720
+    UNION ALL SELECT 1201 UNION ALL SELECT 1202 UNION ALL SELECT 1219
+    UNION ALL SELECT 1220 UNION ALL SELECT 1207 UNION ALL SELECT 1221
+    UNION ALL SELECT 1222 UNION ALL SELECT 1208 UNION ALL SELECT 2713
+) m
+WHERE r.`deleted` = b'0'
+  AND r.`code` IN ('common', 'tenant_admin', 'test-dp', 'coffee', '鍛樺伐', '鎬荤粡鐞�', 'JL')
+  AND NOT EXISTS (
+      SELECT 1 FROM `system_role_menu` rm
+      WHERE rm.`role_id` = r.`id` AND rm.`menu_id` = m.`menu_id` AND rm.`deleted` = b'0'
+  );
+
+-- 3. 楠岃瘉锛氬簲杩斿洖 40 鏉¤彍鍗曪紝涓� 1185 / 1200 / 1207 瀛樺湪鐖跺瓙鍏崇郴
+-- SELECT id, name, type, parent_id, path, component FROM system_menu
+--  WHERE id IN (1185, 1186, 1187, 1193, 1200, 1201, 1207, 1208, 2713);

--
Gitblit v1.9.3