-- 卡片管理-刷卡订单统计菜单及超级管理员授权（幂等）
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);