-- 入口归入既有售后管理一级菜单,不新增或修改一级菜单。 -- 直接执行后需按目标环境运维流程刷新相关菜单及角色权限缓存。 SET @finance_parent := (SELECT id FROM system_menu WHERE path='/aftersales' AND parent_id=0 AND type=1 AND deleted=b'0' LIMIT 1); INSERT INTO system_menu (name,permission,type,sort,parent_id,path,icon,component,component_name,status,visible,keep_alive,always_show,creator,updater) SELECT '售后财务草稿','',2,30,@finance_parent,'after-sale-draft','lucide:file-check','erp/finance/after-sale-draft/index','ErpAfterSaleFinanceDraft',0,b'1',b'1',b'1','1','1' WHERE @finance_parent IS NOT NULL AND NOT EXISTS(SELECT 1 FROM system_menu WHERE component='erp/finance/after-sale-draft/index' AND deleted=b'0'); SET @finance_page := (SELECT id FROM system_menu WHERE component='erp/finance/after-sale-draft/index' AND deleted=b'0' LIMIT 1); -- 兼容先前安装到 ERP 财务管理下的版本,仅移动已知的旧入口。 UPDATE system_menu SET parent_id=@finance_parent, path='after-sale-draft', updater='1', update_time=NOW() WHERE id=@finance_page AND @finance_parent IS NOT NULL AND parent_id IN (SELECT id FROM (SELECT f.id FROM system_menu f JOIN system_menu e ON f.parent_id=e.id WHERE f.path='finance' AND e.path='/erp' AND e.parent_id=0 AND f.deleted=b'0' AND e.deleted=b'0') old_parent); -- 原有草稿使用角色需要售后管理目录才能看到已授权的页面。 INSERT INTO system_role_menu (role_id,menu_id,creator,updater,tenant_id) SELECT DISTINCT rm.role_id,@finance_parent,'1','1',rm.tenant_id FROM system_role_menu rm WHERE @finance_parent IS NOT NULL AND @finance_page IS NOT NULL AND rm.deleted=b'0' AND rm.menu_id=@finance_page AND NOT EXISTS (SELECT 1 FROM system_role_menu existing WHERE existing.role_id=rm.role_id AND existing.tenant_id=rm.tenant_id AND existing.menu_id=@finance_parent AND existing.deleted=b'0'); INSERT INTO system_menu (name,permission,type,sort,parent_id,path,icon,status,visible,keep_alive,always_show,creator,updater) SELECT p.name,p.permission,3,p.sort_no,@finance_page,'','',0,b'1',b'1',b'1','1','1' FROM (SELECT '草稿查询' name,'erp:after-sale-finance:query' permission,1 sort_no UNION ALL SELECT '草稿审核','erp:after-sale-finance:review',2) p WHERE @finance_page IS NOT NULL AND NOT EXISTS(SELECT 1 FROM system_menu m WHERE m.permission=p.permission AND m.deleted=b'0');