-- 营销管理菜单按业务流程排序;保留原菜单 ID、组件和权限。 UPDATE system_menu SET sort = CASE id WHEN 2701 THEN 10 WHEN 1075495 THEN 20 WHEN 1075496 THEN 30 WHEN 1075497 THEN 40 WHEN 1075498 THEN 50 WHEN 2524 THEN 90 WHEN 2404 THEN 10 WHEN 2546 THEN 20 WHEN 2391 THEN 30 WHEN 2416 THEN 40 WHEN 2618 THEN 50 WHEN 2410 THEN 10 WHEN 602512 THEN 20 WHEN 602630 THEN 30 WHEN 2398 THEN 40 WHEN 2638 THEN 50 WHEN 2428 THEN 10 WHEN 2422 THEN 20 WHEN 1063093 THEN 30 WHEN 1075660 THEN 40 WHEN 1065000 THEN 10 WHEN 1065100 THEN 20 WHEN 2560 THEN 30 ELSE sort END, parent_id = CASE WHEN id = 602630 THEN 1075496 ELSE parent_id END WHERE id IN (2701,1075495,1075496,1075497,1075498,2524, 2404,2546,2391,2416,2618,2410,602512,602630,2398,2638, 2428,2422,1063093,1075660,1065000,1065100,2560);