shanxia/bx/bx-backend/sql/restructure_biz_menu_under_300.sql

-- 报销菜单：三个业务分组为一级目录（parent_id=0），不再使用「报销业务」父级 id=300。
-- 结构：
--   310 我的 → 311 备用金申请、321 报销申请
--   320 待办 → 312 备用金审批、322 报销审批
--   330 发放/冲抵 → 313 备用金发放管理、323 支付管理（发放/冲抵）
-- 一级排序：基础管理(100)=1，基础配置(200)=2，本脚本 310/320/330=3/4/5，视图中心(400)=6。
-- 若 id=330 已存在且用途不同，请先调整本脚本中的 id。

START TRANSACTION;

UPDATE bx_menu SET menu_name = '我的' WHERE id = 310 AND del_flag = 0;
UPDATE bx_menu SET menu_name = '待办' WHERE id = 320 AND del_flag = 0;

INSERT INTO bx_menu (
  id, parent_id, menu_name, menu_code, menu_type, path, icon, sort_order, visible, status,
  remark, create_by, create_time, update_by, update_time, del_flag
) VALUES (
  330, 300, '发放/冲抵', NULL, 1, NULL, NULL, 3, 1, 1,
  NULL, NULL, NOW(), NULL, NOW(), 0
)
ON DUPLICATE KEY UPDATE
  menu_name = '发放/冲抵',
  menu_type = 1,
  del_flag = 0,
  update_time = NOW();

UPDATE bx_menu SET parent_id = 310, sort_order = 1 WHERE id = 311;
UPDATE bx_menu SET parent_id = 310, sort_order = 2 WHERE id = 321;
UPDATE bx_menu SET parent_id = 320, sort_order = 1 WHERE id = 312;
UPDATE bx_menu SET parent_id = 320, sort_order = 2 WHERE id = 322;
UPDATE bx_menu SET parent_id = 330, sort_order = 1 WHERE id = 313;
UPDATE bx_menu SET parent_id = 330, sort_order = 2, menu_name = '支付管理（发放/冲抵）' WHERE id = 323;

UPDATE bx_menu SET parent_id = 0, sort_order = 3 WHERE id = 310 AND del_flag = 0;
UPDATE bx_menu SET parent_id = 0, sort_order = 4 WHERE id = 320 AND del_flag = 0;
UPDATE bx_menu SET parent_id = 0, sort_order = 5 WHERE id = 330 AND del_flag = 0;

UPDATE bx_menu SET sort_order = 6 WHERE id = 400 AND del_flag = 0;

DELETE FROM bx_menu_role WHERE menu_id IN (300, 404);
UPDATE bx_menu SET del_flag = 1 WHERE id IN (300, 404);

COMMIT;