mescloud/db/mysql/add_mes_welding_param_menu.sql

-- 焊接参数拆分为「点焊参数」「弧焊参数」两个菜单
-- 原菜单 href 含 mesProductArcWelding 时更新为点焊参数；并新增弧焊参数菜单（同父级）

UPDATE `js_sys_menu`
SET `menu_name` = '点焊参数',
    `menu_href` = '/mes/mesProductArcWelding/listSpot',
    `tree_names` = REPLACE(`tree_names`, '焊接参数', '点焊参数'),
    `update_date` = NOW()
WHERE (`menu_href` LIKE '%mesProductArcWelding/list%'
    OR `menu_href` LIKE '%mesProductArcWelding/listSpot%')
  AND `menu_name` IN ('焊接参数', '点焊参数');

INSERT INTO `js_sys_menu` (
  `menu_code`, `parent_code`, `parent_codes`, `tree_sort`, `tree_sorts`, `tree_leaf`, `tree_level`,
  `tree_names`, `menu_name`, `menu_type`, `menu_href`, `menu_target`, `menu_icon`, `menu_color`,
  `menu_title`, `permission`, `weight`, `is_show`, `sys_code`, `module_codes`, `component`, `params`,
  `status`, `create_by`, `create_date`, `update_by`, `update_date`, `remarks`
)
SELECT
  'mesProductArcWeldingArc',
  m.`parent_code`,
  m.`parent_codes`,
  IFNULL(m.`tree_sort`, 0) + 1,
  m.`tree_sorts`,
  '1',
  m.`tree_level`,
  REPLACE(m.`tree_names`, '点焊参数', '弧焊参数'),
  '弧焊参数',
  '1',
  '/mes/mesProductArcWelding/listArc',
  '',
  IFNULL(m.`menu_icon`, 'icon-notebook'),
  '',
  '',
  m.`permission`,
  IFNULL(m.`weight`, 40),
  '1',
  IFNULL(m.`sys_code`, 'default'),
  IFNULL(m.`module_codes`, 'core'),
  NULL,
  NULL,
  '0',
  'system',
  NOW(),
  'system',
  NOW(),
  ''
FROM `js_sys_menu` m
WHERE m.`menu_href` = '/mes/mesProductArcWelding/listSpot'
  AND NOT EXISTS (
    SELECT 1 FROM `js_sys_menu` x WHERE x.`menu_code` = 'mesProductArcWeldingArc'
  )
LIMIT 1;