zkxw/docs/sql/mobile_menu_oa_wechat_notify.sql

-- 小程序「开启微信通知」菜单（抄送我的之后）
-- 前置：docs/sql/mobile_menu_oa_task_centers.sql（OA006）可已执行
-- 角色授权请在 Web「角色管理」勾选本菜单。

SET @mini_root = (
  SELECT id FROM sys_menu
  WHERE del_flag = 0 AND parent_id = '0' AND menu_name LIKE '%移动端%'
  LIMIT 1
);

INSERT INTO sys_menu (
  id, menu_name, parent_id, menu_type, path, component, perms,
  is_frame, visible, status, tenant_no, order_num, remark,
  create_by, create_dept_id, create_time, update_by, update_time, del_flag
)
SELECT
  'MINI000000000000000000000000OA007',
  '开启微信通知',
  @mini_root,
  'C',
  '/pages/oa/wechat-notify/index',
  NULL,
  'mini:oa:wechat-notify',
  1,
  '1',
  '1',
  'zkxw',
  70,
  '小程序开启微信通知（关注+绑定）',
  'admin',
  '',
  NOW(),
  NULL,
  NOW(),
  0
FROM DUAL
WHERE @mini_root IS NOT NULL
  AND NOT EXISTS (
    SELECT 1 FROM sys_menu WHERE id = 'MINI000000000000000000000000OA007' AND del_flag = 0
  );