shanxia2.0/docs/sql/migrations/2026-08-08-move-crm-clue-opportunity-pool-menus-to-system.sql

-- 将「线索管理」「商机管理」「公海池」从 CRM管理 挪到 系统管理
-- 菜单 id:
--   CRM1000000000000000000000000010 线索管理
--   CRM2000000000000000000000000010 商机管理
--   CRM1000000000000000000000000003 公海池
-- 关联隐藏页（线索详情 / 商机详情）一并调整 parent_id，按钮子菜单仍挂在业务菜单下。
-- 幂等：可重复执行
-- 注意：web-admin 开发环境默认 VITE_ACCESS_MODE=frontend，侧栏还依赖
-- web-admin/src/router/modules/sqxp.ts 中上述路由挂在系统管理 children 下。

UPDATE `sys_menu`
SET `parent_id` = 'SYSM000000000000000000000000000001',
    `order_num` = 11,
    `update_time` = NOW()
WHERE `id` = 'CRM1000000000000000000000000010'
  AND `del_flag` = 0
  AND (
    `parent_id` <> 'SYSM000000000000000000000000000001'
    OR `order_num` <> 11
  );

UPDATE `sys_menu`
SET `parent_id` = 'SYSM000000000000000000000000000001',
    `order_num` = 12,
    `update_time` = NOW()
WHERE `id` = 'CRM2000000000000000000000000010'
  AND `del_flag` = 0
  AND (
    `parent_id` <> 'SYSM000000000000000000000000000001'
    OR `order_num` <> 12
  );

UPDATE `sys_menu`
SET `parent_id` = 'SYSM000000000000000000000000000001',
    `order_num` = 13,
    `update_time` = NOW()
WHERE `id` = 'CRM1000000000000000000000000003'
  AND `del_flag` = 0
  AND (
    `parent_id` <> 'SYSM000000000000000000000000000001'
    OR `order_num` <> 13
  );

-- 侧栏不展示的详情页：挂到系统管理下，与列表同模块
UPDATE `sys_menu`
SET `parent_id` = 'SYSM000000000000000000000000000001',
    `update_time` = NOW()
WHERE `id` IN (
  'CRM1000000000000000000000000011',
  'CRM2000000000000000000000000011'
)
  AND `del_flag` = 0
  AND `parent_id` <> 'SYSM000000000000000000000000000001';