shanxia2.0/docs/sql/migrate_pl_transport_submenu_order_20261004.sql

-- 运输管理二级菜单顺序：
-- 运输计划 → 运输归档 → 危化品证上传 → 运费管理 → 证件提醒 → 库存管理
-- 2026-10-04

UPDATE `sys_menu` SET `order_num` = 1, `update_time` = NOW()
WHERE `id` = 'PL_GROUP_PLAN' AND `del_flag` = 0;

UPDATE `sys_menu` SET `order_num` = 2, `update_time` = NOW()
WHERE `id` = 'PL_GROUP_ARCHIVE' AND `del_flag` = 0;

UPDATE `sys_menu` SET `order_num` = 3, `update_time` = NOW()
WHERE `id` = 'PL_GROUP_CERT' AND `del_flag` = 0;

UPDATE `sys_menu` SET `order_num` = 3, `update_time` = NOW()
WHERE `id` = 'PL_PLAN_CERT' AND `parent_id` = 'PL_MENU_ROOT' AND `del_flag` = 0;

UPDATE `sys_menu` SET `order_num` = 4, `update_time` = NOW()
WHERE `id` = 'PL_GROUP_FREIGHT' AND `del_flag` = 0;

UPDATE `sys_menu` SET `order_num` = 5, `update_time` = NOW()
WHERE `id` = 'PL_GROUP_DOC' AND `del_flag` = 0;

UPDATE `sys_menu` SET `order_num` = 6, `update_time` = NOW()
WHERE `id` = 'PL_GROUP_STOCK' AND `del_flag` = 0;