-- Operation management menus. Safe to run repeatedly.
INSERT INTO `sa_system_menu` (`parent_id`,`name`,`code`,`slug`,`type`,`path`,`component`,`method`,`icon`,`sort`,`link_url`,`is_iframe`,`is_keep_alive`,`is_hidden`,`is_fixed_tab`,`is_full_page`,`generate_id`,`generate_key`,`status`,`remark`,`created_by`,`updated_by`,`create_time`,`update_time`,`delete_time`)
SELECT 0, CONVERT(0xE8BF90E890A5E7AEA1E79086 USING utf8mb4), 'OperationManagement', NULL, 1, '/operation-management', NULL, NULL, 'ri:settings-3-line', 83, NULL, 2, 2, 2, 2, 2, 0, NULL, 1, NULL, 1, 1, NOW(), NOW(), NULL WHERE NOT EXISTS (SELECT 1 FROM `sa_system_menu` WHERE `path` = '/operation-management' AND `delete_time` IS NULL);
INSERT INTO `sa_system_menu` (`parent_id`,`name`,`code`,`slug`,`type`,`path`,`component`,`method`,`icon`,`sort`,`link_url`,`is_iframe`,`is_keep_alive`,`is_hidden`,`is_fixed_tab`,`is_full_page`,`generate_id`,`generate_key`,`status`,`remark`,`created_by`,`updated_by`,`create_time`,`update_time`,`delete_time`)
SELECT (SELECT id FROM `sa_system_menu` WHERE path = '/operation-management' AND delete_time IS NULL LIMIT 1), CONVERT(0xE59586E688B7E68AA5E8ADA6 USING utf8mb4), 'MerchantAlerts', NULL, 2, 'merchant-alerts', '/operation-management/merchant-alerts', NULL, 'ri:alarm-warning-line', 100, NULL, 2, 2, 2, 2, 2, 0, NULL, 1, NULL, 1, 1, NOW(), NOW(), NULL WHERE NOT EXISTS (SELECT 1 FROM `sa_system_menu` WHERE component = '/operation-management/merchant-alerts' AND delete_time IS NULL);
INSERT INTO `sa_system_menu` (`parent_id`,`name`,`code`,`slug`,`type`,`path`,`component`,`method`,`icon`,`sort`,`link_url`,`is_iframe`,`is_keep_alive`,`is_hidden`,`is_fixed_tab`,`is_full_page`,`generate_id`,`generate_key`,`status`,`remark`,`created_by`,`updated_by`,`create_time`,`update_time`,`delete_time`)
SELECT (SELECT id FROM `sa_system_menu` WHERE path = '/operation-management' AND delete_time IS NULL LIMIT 1), CONVERT(0xE8AEBEE5A487E8B4ADE4B9B0E8AEB0E5BD95 USING utf8mb4), 'DevicePurchases', NULL, 2, 'device-purchases', '/operation-management/device-purchases', NULL, 'ri:shopping-cart-2-line', 90, NULL, 2, 2, 2, 2, 2, 0, NULL, 1, NULL, 1, 1, NOW(), NOW(), NULL WHERE NOT EXISTS (SELECT 1 FROM `sa_system_menu` WHERE component = '/operation-management/device-purchases' AND delete_time IS NULL);
INSERT INTO `sa_system_menu` (`parent_id`,`name`,`code`,`slug`,`type`,`path`,`component`,`method`,`icon`,`sort`,`link_url`,`is_iframe`,`is_keep_alive`,`is_hidden`,`is_fixed_tab`,`is_full_page`,`generate_id`,`generate_key`,`status`,`remark`,`created_by`,`updated_by`,`create_time`,`update_time`,`delete_time`)
SELECT (SELECT id FROM `sa_system_menu` WHERE path = '/operation-management' AND delete_time IS NULL LIMIT 1), CONVERT(0xE8AEBEE5A487E68AA5E4BFAEE8AEB0E5BD95 USING utf8mb4), 'DeviceWarranties', NULL, 2, 'device-warranties', '/operation-management/device-warranties', NULL, 'ri:tools-line', 80, NULL, 2, 2, 2, 2, 2, 0, NULL, 1, NULL, 1, 1, NOW(), NOW(), NULL WHERE NOT EXISTS (SELECT 1 FROM `sa_system_menu` WHERE component = '/operation-management/device-warranties' AND delete_time IS NULL);
UPDATE `sa_system_menu` SET `name` = CONVERT(0xE8AEBEE5A487E68AA5E4BFAEE8AEB0E5BD95 USING utf8mb4), `update_time` = NOW() WHERE `component` = '/operation-management/device-warranties' AND `delete_time` IS NULL;
INSERT INTO `sa_system_menu` (`parent_id`,`name`,`code`,`slug`,`type`,`path`,`component`,`method`,`icon`,`sort`,`link_url`,`is_iframe`,`is_keep_alive`,`is_hidden`,`is_fixed_tab`,`is_full_page`,`generate_id`,`generate_key`,`status`,`remark`,`created_by`,`updated_by`,`create_time`,`update_time`,`delete_time`)
SELECT (SELECT id FROM `sa_system_menu` WHERE path = '/operation-management' AND delete_time IS NULL LIMIT 1), CONVERT(0xE8AEBEE5A487E8BF90E890A5 USING utf8mb4), 'DeviceOperations', NULL, 2, 'device-operations', '/operation-management/device-operations', NULL, 'ri:line-chart-line', 70, NULL, 2, 2, 2, 2, 2, 0, NULL, 1, NULL, 1, 1, NOW(), NOW(), NULL WHERE NOT EXISTS (SELECT 1 FROM `sa_system_menu` WHERE component = '/operation-management/device-operations' AND delete_time IS NULL);