- 菜单处理sql 菜单id冲突时将菜单整体加一个数
SELECT
menu_id +1000 as menu_id,
menu_name,
CASE
WHEN parent_id = 0 THEN
1182 ELSE parent_id + 1000
END AS parent_id,
order_num,
path,
CASE
WHEN component IS NOT NULL
OR component != '' THEN
'subproject/index' ELSE component
END AS component,
`query`,
is_frame,
is_cache,
menu_type,
visible,
STATUS,
perms,
icon,
create_by,
create_time,
update_by,
update_time,
remark
FROM
sys_menu
WHERE
menu_id >= 2096
AND menu_id <= 2251