51 lines
4.1 KiB
MySQL
51 lines
4.1 KiB
MySQL
|
-- ============================================================
|
|||
|
|
-- 为所有菜单补齐图标（只更新 icon 为空的，已有的保留）
|
|||
|
|
-- 图标使用 Element Plus 图标名（PascalCase），侧边栏通过 iconMap[icon] 渲染
|
|||
|
|
-- 执行前建议先跑：SELECT id,name,icon FROM sys_menu WHERE type IN(0,1) ORDER BY parent_id,order_num;
|
|||
|
|
-- 若菜单 name 与下方不一致，请按实际 name 调整 WHERE 条件
|
|||
|
|
-- ============================================================
|
|||
|
|
|
|||
|
|
-- ===== 一级目录 =====
|
|||
|
|
UPDATE `sys_menu` SET `icon`='Briefcase' WHERE `name`='业务管理' AND (`icon` IS NULL OR `icon`='');
|
|||
|
|
UPDATE `sys_menu` SET `icon`='Connection' WHERE `name`='第三方接口管理' AND (`icon` IS NULL OR `icon`='');
|
|||
|
|
UPDATE `sys_menu` SET `icon`='VideoCamera' WHERE `name`='媒资管理' AND (`icon` IS NULL OR `icon`='');
|
|||
|
|
UPDATE `sys_menu` SET `icon`='Setting' WHERE `name`='系统管理' AND (`icon` IS NULL OR `icon`='');
|
|||
|
|
UPDATE `sys_menu` SET `icon`='OfficeBuilding' WHERE `name`='组织管理' AND (`icon` IS NULL OR `icon`='');
|
|||
|
|
|
|||
|
|
-- ===== 业务管理 下 =====
|
|||
|
|
UPDATE `sys_menu` SET `icon`='Share' WHERE `name`='渠道管理' AND (`icon` IS NULL OR `icon`='');
|
|||
|
|
UPDATE `sys_menu` SET `icon`='Shop' WHERE `name`='门店管理' AND (`icon` IS NULL OR `icon`='');
|
|||
|
|
UPDATE `sys_menu` SET `icon`='Monitor' WHERE `name`='设备管理' AND (`icon` IS NULL OR `icon`='');
|
|||
|
|
UPDATE `sys_menu` SET `icon`='PriceTag' WHERE `name`='定价策略' AND (`icon` IS NULL OR `icon`='');
|
|||
|
|
UPDATE `sys_menu` SET `icon`='Wallet' WHERE `name`='支付配置' AND (`icon` IS NULL OR `icon`='');
|
|||
|
|
UPDATE `sys_menu` SET `icon`='Tickets' WHERE `name`='天卡池管理' AND (`icon` IS NULL OR `icon`='');
|
|||
|
|
UPDATE `sys_menu` SET `icon`='Document' WHERE `name`='天卡订单' AND (`icon` IS NULL OR `icon`='');
|
|||
|
|
UPDATE `sys_menu` SET `icon`='Key' WHERE `name`='天卡激活码' AND (`icon` IS NULL OR `icon`='');
|
|||
|
|
UPDATE `sys_menu` SET `icon`='Coin' WHERE `name`='分润规则' AND (`icon` IS NULL OR `icon`='');
|
|||
|
|
UPDATE `sys_menu` SET `icon`='Wallet' WHERE `name`='分账记录' AND (`icon` IS NULL OR `icon`='');
|
|||
|
|
UPDATE `sys_menu` SET `icon`='RefreshLeft' WHERE `name`='退款记录' AND (`icon` IS NULL OR `icon`='');
|
|||
|
|
|
|||
|
|
-- ===== 第三方接口管理 下 =====
|
|||
|
|
UPDATE `sys_menu` SET `icon`='UserFilled' WHERE `name`='合作伙伴管理' AND (`icon` IS NULL OR `icon`='');
|
|||
|
|
UPDATE `sys_menu` SET `icon`='Files' WHERE `name`='内容包配置' AND (`icon` IS NULL OR `icon`='');
|
|||
|
|
UPDATE `sys_menu` SET `icon`='ShoppingCart' WHERE `name`='天卡库存' AND (`icon` IS NULL OR `icon`='');
|
|||
|
|
UPDATE `sys_menu` SET `icon`='Document' WHERE `name`='审计日志' AND (`icon` IS NULL OR `icon`='');
|
|||
|
|
UPDATE `sys_menu` SET `icon`='Monitor' WHERE `name`='设备列表' AND (`icon` IS NULL OR `icon`='');
|
|||
|
|
|
|||
|
|
-- ===== 媒资管理 下 =====
|
|||
|
|
UPDATE `sys_menu` SET `icon`='Film' WHERE `name`='橘视厅媒资' AND (`icon` IS NULL OR `icon`='');
|
|||
|
|
|
|||
|
|
-- ===== 系统管理 下 =====
|
|||
|
|
UPDATE `sys_menu` SET `icon`='User' WHERE `name`='用户管理' AND (`icon` IS NULL OR `icon`='');
|
|||
|
|
UPDATE `sys_menu` SET `icon`='UserFilled'WHERE `name`='角色管理' AND (`icon` IS NULL OR `icon`='');
|
|||
|
|
UPDATE `sys_menu` SET `icon`='Menu' WHERE `name`='菜单管理' AND (`icon` IS NULL OR `icon`='');
|
|||
|
|
UPDATE `sys_menu` SET `icon`='Tools' WHERE `name`='参数配置' AND (`icon` IS NULL OR `icon`='');
|
|||
|
|
UPDATE `sys_menu` SET `icon`='Memo' WHERE `name`='日志管理' AND (`icon` IS NULL OR `icon`='');
|
|||
|
|
UPDATE `sys_menu` SET `icon`='Memo' WHERE `name`='操作日志' AND (`icon` IS NULL OR `icon`='');
|
|||
|
|
UPDATE `sys_menu` SET `icon`='Memo' WHERE `name`='审计日志记录' AND (`icon` IS NULL OR `icon`='');
|
|||
|
|
UPDATE `sys_menu` SET `icon`='Timer' WHERE `name`='定时任务' AND (`icon` IS NULL OR `icon`='');
|
|||
|
|
UPDATE `sys_menu` SET `icon`='Document' WHERE `name`='定时日志' AND (`icon` IS NULL OR `icon`='');
|
|||
|
|
|
|||
|
|
-- ===== 通用兜底：仍为空的菜单统一给一个默认图标 =====
|
|||
|
|
UPDATE `sys_menu` SET `icon`='Menu' WHERE (`icon` IS NULL OR `icon`='') AND `type` IN (0,1);
|