1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
| -- 卡片管理-刷卡订单统计菜单及超级管理员授权（幂等）
| USE charging_pile_other;
|
| INSERT INTO sys_menu
| (menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
| SELECT CONVERT(0xE588B7E58DA1E8AEA2E7BB9FE8AEA1 USING utf8mb4), parent.menu_id, 3, 'cardOrderStatistics', 'order/cardOrderStatistics/index', '', 1, 0, 'C', '0', '0', '/cardOrderStatistics', 'transaction', 'admin', NOW(), '', NULL, '刷卡订单统计'
| FROM sys_menu parent
| WHERE parent.path = 'card'
| AND parent.menu_type = 'M'
| AND NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms = '/cardOrderStatistics');
|
| INSERT INTO sys_role_menu (role_id, menu_id)
| SELECT 1, menu.menu_id
| FROM sys_menu menu
| WHERE menu.perms = '/cardOrderStatistics'
| AND NOT EXISTS (SELECT 1 FROM sys_role_menu role_menu WHERE role_menu.role_id = 1 AND role_menu.menu_id = menu.menu_id);
|
|
