REPLACE INTO `zw_c_resource` (`id`, `icon_cls`, `resource_name`, `type`, `code`, `permission`, `perm_value`, `description`, `parent_id`, `sort_order`, `domain`, `code_num`, `editable`, `enabled`, `flag`, `create_data_time`, `create_data_username`, `update_data_time`, `update_data_username`) VALUES
('535c1d76-b624-41a6-8560-1d91414ace57',NULL,'上报里程统计','0',NULL,'extra_oil_mileage','/m/report/mileage/statistics/list',NULL,'f9602388-02ec-4d1a-b40f-92aee2ebea46','150105',NULL,'110074','1','1','1',NULL,NULL,NULL,NULL),
('851b050b-68f4-4529-b461-46c882e3e0ef',NULL,'站点管理','0',NULL,'extra_oil_station','/m/station/manage/list',NULL,'f9602388-02ec-4d1a-b40f-92aee2ebea46','150102',NULL,'110072','1','1','1',NULL,NULL,NULL,NULL),
('2a149552-b5b8-42bd-8d4d-b07fdd556888',NULL,'定位信息统计','0',NULL,'extra_oil_location','/m/statistics/check/locationInformation/list',NULL,'f9602388-02ec-4d1a-b40f-92aee2ebea46','150106',NULL,'110075','1','1','1',NULL,NULL,NULL,NULL),
('b4ec118a-a949-437e-a91b-eb08a950ca53',NULL,'线路管理','0',NULL,'extra_oil_route','/m/line/manage/list',NULL,'f9602388-02ec-4d1a-b40f-92aee2ebea46','150104',NULL,'110073','1','1','1',NULL,NULL,NULL,NULL),
('d648c829-df51-4770-9207-31a948bacfcc',NULL,'转发车辆管理','0',NULL,'extra_oil_vehicle','/m/forward/vehicle/manage/list',NULL,'f9602388-02ec-4d1a-b40f-92aee2ebea46','150101',NULL,'110071','1','1','1',NULL,NULL,NULL,NULL);

REPLACE INTO `zw_c_role_resource`(`id`, `resource_id`, `role_id`, `create_data_time`, `create_data_username`, `update_data_time`, `update_data_username`, `flag`, `editable`) VALUES
('58ef2095-c09a-4ffc-bde7-4f0536cc1003', '535c1d76-b624-41a6-8560-1d91414ace57', 'cn=ROLE_ADMIN,ou=Groups', '2021-01-07 10:49:22', 'admin', NULL, NULL, 1, 1),
('9a8df61c-b8df-494a-a447-6e44dd33bcc4', '851b050b-68f4-4529-b461-46c882e3e0ef', 'cn=ROLE_ADMIN,ou=Groups', '2021-01-07 10:49:22', 'admin', NULL, NULL, 1, 1),
('6ad8810c-a713-42fc-8660-cf728e444c87', '2a149552-b5b8-42bd-8d4d-b07fdd556888', 'cn=ROLE_ADMIN,ou=Groups', '2021-01-07 10:49:22', 'admin', NULL, NULL, 1, 1),
('2f3d86ee-812b-4436-9263-b43046917330', 'b4ec118a-a949-437e-a91b-eb08a950ca53', 'cn=ROLE_ADMIN,ou=Groups', '2021-01-07 10:49:22', 'admin', NULL, NULL, 1, 1),
('186c5350-24bd-4e54-b500-71f2cf7ca58c', 'd648c829-df51-4770-9207-31a948bacfcc', 'cn=ROLE_ADMIN,ou=Groups', '2021-01-07 10:49:22', 'admin', NULL, NULL, 1, 1);
 
 -- 增值服务菜单--温湿度监控
REPLACE INTO `zw_c_resource` (`id`, `icon_cls`, `resource_name`, `type`, `code`, `permission`, `perm_value`, `description`, `parent_id`, `sort_order`, `domain`, `code_num`, `editable`, `enabled`, `flag`, `create_data_time`, `create_data_username`, `update_data_time`, `update_data_username`) VALUES ('37108d89-3fea-11e9-9b4f-00163e2cf72b',NULL,'温湿度监控','0',NULL,'extra_temperature','/v/monitoring/humiture/list',NULL,'8dd33331-2016-4f85-9e8d-958b4ee79535','150200',NULL,'110006','1','1','1',NULL,NULL,NULL,NULL);
REPLACE INTO `zw_c_role_resource` (`id`, `resource_id`, `role_id`, `create_data_time`, `create_data_username`, `update_data_time`, `update_data_username`, `flag`, `editable`) VALUES ('a4d46b62-8677-4f81-b179-acb9678a39d0', '37108d89-3fea-11e9-9b4f-00163e2cf72b', 'cn=ROLE_ADMIN,ou=Groups', '2021-01-25 10:52:55', 'admin', NULL, NULL, '1', '1');

-- 第三方转发功能
REPLACE INTO `zw_c_resource` (`id`, `icon_cls`, `resource_name`, `type`, `code`, `permission`, `perm_value`, `description`, `parent_id`, `sort_order`, `domain`, `code_num`, `editable`, `enabled`, `flag`, `create_data_time`, `create_data_username`, `update_data_time`, `update_data_username`) VALUES ('7c558b1d-2377-472f-bd08-f29d0a1f83ad',NULL,'第三方转发管理','0',NULL,'extra_forward','/m/forward-platform/net-car/list',NULL,'8dd33331-2016-4f85-9e8d-958b4ee79535','150300',NULL,'110014','1','1','1',NULL,NULL,NULL,NULL);
REPLACE INTO `zw_c_role_resource` (`id`, `resource_id`, `role_id`, `create_data_time`, `create_data_username`, `update_data_time`, `update_data_username`, `flag`, `editable`) VALUES ('34293f24-37b0-431b-8810-581948ecbcfc', '7c558b1d-2377-472f-bd08-f29d0a1f83ad', 'cn=ROLE_ADMIN,ou=Groups', '2021-03-09 15:17:24', 'admin', NULL, NULL, '1', '1');

-- 浙江入网证明转发
REPLACE INTO `zw_c_resource` (`id`, `icon_cls`, `resource_name`, `type`, `code`, `permission`, `perm_value`, `description`, `parent_id`, `sort_order`, `domain`, `code_num`, `editable`, `enabled`, `flag`, `create_data_time`, `create_data_username`, `update_data_time`, `update_data_username`) VALUES ('f9c7729c-f40e-11e7-bc74-92361f003671',NULL,'浙江入网证明转发','0',NULL,'extra_zhejiang','/m/netAccessProveForward/list',NULL,'8dd33331-2016-4f85-9e8d-958b4ee79535','150400',NULL,'110028','1','1','1',NULL,NULL,NULL,NULL);
REPLACE INTO `zw_c_role_resource` (`id`, `resource_id`, `role_id`, `create_data_time`, `create_data_username`, `update_data_time`, `update_data_username`, `flag`, `editable`) VALUES ('a4d1c867-80af-11eb-8872-000c29dcff33', 'f9c7729c-f40e-11e7-bc74-92361f003671', 'cn=ROLE_ADMIN,ou=Groups', '2021-03-09 15:17:24', 'admin', NULL, NULL, '1', '1');


-- 补传管理
REPLACE INTO `zw_c_resource` (`id`, `icon_cls`, `resource_name`, `type`, `code`, `permission`, `perm_value`, `description`, `parent_id`, `sort_order`, `domain`, `code_num`, `editable`, `enabled`, `flag`, `create_data_time`, `create_data_username`, `update_data_time`, `update_data_username`) VALUES ('25e89331-6724-d368-ba4e-a30e5ff7c2e2',NULL,'补传管理','0',NULL,'extra_oil_resend','/m/subsidy/manage/list',NULL,'f9602388-02ec-4d1a-b40f-92aee2ebea46','150103',NULL,'110072','1','1','1',NULL,NULL,NULL,NULL);
REPLACE INTO `zw_c_role_resource`(`id`, `resource_id`, `role_id`, `create_data_time`, `create_data_username`, `update_data_time`, `update_data_username`, `flag`, `editable`) VALUES ('3a9b38b2-2777-b501-26ec-531ad9256444', '25e89331-6724-d368-ba4e-a30e5ff7c2e2', 'cn=ROLE_ADMIN,ou=Groups', '2021-03-25 16:54:13', 'admin', NULL, NULL, 1, 1);
REPLACE INTO `zw_c_role_resource`(`id`, `resource_id`, `role_id`, `create_data_time`, `create_data_username`, `update_data_time`, `update_data_username`, `flag`, `editable`) VALUES ('2ad868a2-bf97-f435-9b28-18835b1c9255', '25e89331-6724-d368-ba4e-a30e5ff7c2e2', 'cn=POWER_USER,ou=Groups', '2021-03-25 16:54:13', 'admin', NULL, NULL, 1, 1);

-- 报警图片处理管理
REPLACE INTO `zw_c_resource` (`id`, `icon_cls`, `resource_name`, `type`, `code`, `permission`, `perm_value`, `description`, `parent_id`, `sort_order`, `domain`, `code_num`, `editable`, `enabled`, `flag`, `create_data_time`, `create_data_username`, `update_data_time`, `update_data_username`) VALUES ('f9c7729c-f40e-11e7-bc74-92361f003672',NULL,'报警图片处理管理','0',NULL,'extra_image','/adas/risk/pic-postprocess/list',NULL,'8dd33331-2016-4f85-9e8d-958b4ee79535','150500',NULL,'110032','1','1','1',NULL,NULL,NULL,NULL);
REPLACE INTO `zw_c_role_resource` (`id`, `resource_id`, `role_id`, `create_data_time`, `create_data_username`, `update_data_time`, `update_data_username`, `flag`, `editable`) VALUES ('3a9b38b2-2777-b501-26ec-531ad9256444', 'f9c7729c-f40e-11e7-bc74-92361f003672', 'cn=ROLE_ADMIN,ou=Groups', '2021-03-25 16:54:13', 'admin', NULL, NULL, 1, 1);
REPLACE INTO `zw_c_role_resource` (`id`, `resource_id`, `role_id`, `create_data_time`, `create_data_username`, `update_data_time`, `update_data_username`, `flag`, `editable`) VALUES ('2ad868a2-bf97-f435-9b28-18835b1c9255', 'f9c7729c-f40e-11e7-bc74-92361f003672', 'cn=POWER_USER,ou=Groups', '2021-03-25 16:54:13', 'admin', NULL, NULL, 1, 1);

-- 808/809消息转发结果报表
REPLACE INTO `clbs`.`zw_c_resource` (`id`, `resource_name`, `type`, `perm_value`, `parent_id`, `sort_order`, `editable`, `code_num`) VALUES ('e0d753ba-437c-11ec-b8b3-000c294a3301', '定制报表', '0', 'javascript:void(0);', '8dd33331-2016-4f85-9e8d-958b4ee79535', 150700, '1', 110037);
REPLACE INTO `clbs`.`zw_c_resource` (`id`, `resource_name`, `type`, `permission`, `perm_value`, `parent_id`, `sort_order`, `editable`, `code_num`) VALUES ('e0d753bb-437c-11ec-b8b3-000c294a3301', '808消息转发结果报表', '0', 'extra_report_808', '/m/reportManagement/forwardResult808/list', 'e0d753ba-437c-11ec-b8b3-000c294a3301', 150701, '1', 11003701);
REPLACE INTO `clbs`.`zw_c_resource` (`id`, `resource_name`, `type`, `permission`, `perm_value`, `parent_id`, `sort_order`, `editable`, `code_num`) VALUES ('e0d753bc-437c-11ec-b8b3-000c294a3301', '809消息转发结果报表', '0', 'extra_report_809', '/m/reportManagement/forwardResult809/list', 'e0d753ba-437c-11ec-b8b3-000c294a3301', 150702, '1', 11003702);
REPLACE INTO `clbs`.`zw_c_role_resource` (`id`, `resource_id`, `role_id`) VALUES ('e808f635-437d-11ec-b8b3-000c294a3301', 'e0d753ba-437c-11ec-b8b3-000c294a3301', 'cn=POWER_USER,ou=Groups');
REPLACE INTO `clbs`.`zw_c_role_resource` (`id`, `resource_id`, `role_id`) VALUES ('e808f636-437d-11ec-b8b3-000c294a3301', 'e0d753bb-437c-11ec-b8b3-000c294a3301', 'cn=POWER_USER,ou=Groups');
REPLACE INTO `clbs`.`zw_c_role_resource` (`id`, `resource_id`, `role_id`) VALUES ('e808f637-437d-11ec-b8b3-000c294a3301', 'e0d753bc-437c-11ec-b8b3-000c294a3301', 'cn=POWER_USER,ou=Groups');
REPLACE INTO `clbs`.`zw_c_role_resource` (`id`, `resource_id`, `role_id`) VALUES ('e808f638-437d-11ec-b8b3-000c294a3301', 'e0d753ba-437c-11ec-b8b3-000c294a3301', 'cn=ROLE_ADMIN,ou=Groups');
REPLACE INTO `clbs`.`zw_c_role_resource` (`id`, `resource_id`, `role_id`) VALUES ('e808f639-437d-11ec-b8b3-000c294a3301', 'e0d753bb-437c-11ec-b8b3-000c294a3301', 'cn=ROLE_ADMIN,ou=Groups');
REPLACE INTO `clbs`.`zw_c_role_resource` (`id`, `resource_id`, `role_id`) VALUES ('e808f63a-437d-11ec-b8b3-000c294a3301', 'e0d753bc-437c-11ec-b8b3-000c294a3301', 'cn=ROLE_ADMIN,ou=Groups');

-- 主动安全-风险监管 4.4.4新增
REPLACE INTO `clbs`.`zw_c_resource` (`id`, `icon_cls`, `resource_name`, `type`, `code`, `permission`, `perm_value`, `description`, `parent_id`, `sort_order`, `domain`, `code_num`, `editable`, `enabled`, `flag`, `create_data_time`, `create_data_username`, `update_data_time`, `update_data_username`) VALUES ('baf66d4e-0a6e-11ea-9469-000c29920fdc',NULL,'风险监管','0',NULL,'extra_risk','/adas/s/riskManage/intelligence/enterprise/list',NULL,'8dd33331-2016-4f85-9e8d-958b4ee79535','150600',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL);

-- 西藏809
REPLACE INTO `clbs`.`zw_c_resource` (`id`, `icon_cls`, `resource_name`, `type`, `code`, `permission`, `perm_value`, `description`, `parent_id`, `sort_order`, `domain`, `code_num`, `editable`, `enabled`, `flag`, `create_data_time`, `create_data_username`, `update_data_time`, `update_data_username`) VALUES ('212b1b78-b3f0-4bc5-83c2-63272b364103',NULL,'车辆路线','0',NULL,'extra_xizang_line','/vas/xizang/line/list',NULL,'fe900067-d781-4631-8abf-e370fa2fa214','150802',NULL,'11003802','0','0','1','2022-06-30 14:11:06','admin',NULL,NULL),
('f93c5ddb-190c-4044-898c-c09a09cef922',NULL,'危险货物运单','0',NULL,'extra_xizang_waybill','/vas/xizang/waybill/list',NULL,'fe900067-d781-4631-8abf-e370fa2fa214','150801',NULL,'11003801','0','0','1','2022-06-30 14:07:28','admin',NULL,NULL),
('fe900067-d781-4631-8abf-e370fa2fa214',NULL,'西藏809','1',NULL,NULL,'javascript:void(0);',NULL,'8dd33331-2016-4f85-9e8d-958b4ee79535','150800',NULL,'110038','1','1','1','2022-06-30 13:51:27','admin',NULL,NULL);

REPLACE INTO `clbs`.`zw_c_role_resource` (`id`, `resource_id`, `role_id`, `create_data_time`, `create_data_username`, `update_data_time`, `update_data_username`, `flag`, `editable`) VALUES
('82c5f982-fe54-46aa-863f-56ed2760f806', 'fe900067-d781-4631-8abf-e370fa2fa214', 'cn=ROLE_ADMIN,ou=Groups', '2022-06-30 13:51:27', 'admin', NULL, NULL, 1, 1),
('f27aeb8e-8cf9-4ee3-ba53-41cb3ea15bf1', '212b1b78-b3f0-4bc5-83c2-63272b364103', 'cn=ROLE_ADMIN,ou=Groups', '2022-06-30 14:11:06', 'admin', NULL, NULL, 1, 1),
('ffd6712d-83ec-48e2-9ff6-44a94d93256f', 'f93c5ddb-190c-4044-898c-c09a09cef922', 'cn=ROLE_ADMIN,ou=Groups', '2022-06-30 14:07:30', 'admin', NULL, NULL, 1, 1),
('524dc86d-3ccb-418d-858f-59d4d138dc5b', 'fe900067-d781-4631-8abf-e370fa2fa214', 'cn=POWER_USER,ou=Groups', '2022-06-30 13:51:27', 'admin', NULL, NULL, 1, 1),
('ebf491db-d058-4171-9f97-a8961f2e5701', '212b1b78-b3f0-4bc5-83c2-63272b364103', 'cn=POWER_USER,ou=Groups', '2022-06-30 14:11:06', 'admin', NULL, NULL, 1, 1),
('296e6ace-6d89-468d-bfe4-d5bca3402b11', 'f93c5ddb-190c-4044-898c-c09a09cef922', 'cn=POWER_USER,ou=Groups', '2022-06-30 14:07:30', 'admin', NULL, NULL, 1, 1);

-- 蜂云定制 主要报警统计报表
REPLACE INTO `clbs`.`zw_c_resource` (`id`, `icon_cls`, `resource_name`, `type`, `code`, `permission`, `perm_value`, `description`, `parent_id`, `sort_order`, `domain`, `code_num`, `editable`, `enabled`, `flag`, `create_data_time`, `create_data_username`, `update_data_time`, `update_data_username`) VALUES ('e0d753bd-437c-11ec-b8b3-000c294a3301', NULL, '主要报警统计报表', 0, NULL, 'extra_report_important_alarm', '/m/reportManagement/importantAlarm/list', NULL, 'e0d753ba-437c-11ec-b8b3-000c294a3301', 150703, NULL, '11003703', 1, 1, 1, NULL, NULL, NULL, NULL);

REPLACE INTO `clbs`.`zw_c_role_resource` (`id`, `resource_id`, `role_id`, `create_data_time`, `create_data_username`, `update_data_time`, `update_data_username`, `flag`, `editable`) VALUES
('4b8be874-f069-4bb3-adb1-661b04ef46a5', 'e0d753bd-437c-11ec-b8b3-000c294a3301', 'cn=ROLE_ADMIN,ou=Groups', '2022-06-30 13:51:27', 'admin', NULL, NULL, 1, 1),
('b81b8c0b-9332-4c0e-843e-f1a9a8321441', 'e0d753bd-437c-11ec-b8b3-000c294a3301', 'cn=POWER_USER,ou=Groups', '2022-06-30 13:51:27', 'admin', NULL, NULL, 1, 1);

-- 深圳809
INSERT IGNORE INTO `clbs`.`zw_c_resource` (`id`, `icon_cls`, `resource_name`, `type`, `code`, `permission`, `perm_value`, `description`, `parent_id`, `sort_order`, `domain`, `code_num`, `editable`, `enabled`, `flag`, `create_data_time`, `create_data_username`, `update_data_time`, `update_data_username`)
VALUES ('73d65abb-2785-46b9-a59d-07bccc2c0833', NULL, '深圳车险报警统计', 0, NULL, 'extra_report_insurance_alarm', '/m/reportManagement/809/alarm/statistic/list', NULL, 'e0d753ba-437c-11ec-b8b3-000c294a3301', 150704, NULL, '11003704', 1, 1, 1, NULL, NULL, NULL, NULL);

INSERT IGNORE INTO `clbs`.`zw_c_role_resource` (`id`, `resource_id`, `role_id`, `create_data_time`, `create_data_username`, `update_data_time`, `update_data_username`, `flag`, `editable`) VALUES
('5565d1c3-c378-458c-acc3-9cbb4d4ba0f1', '73d65abb-2785-46b9-a59d-07bccc2c0833', 'cn=ROLE_ADMIN,ou=Groups', '2022-06-30 13:51:27', 'admin', NULL, NULL, 1, 1),
('58bfca5a-9749-44a7-aca2-efd9beda492e', '73d65abb-2785-46b9-a59d-07bccc2c0833', 'cn=POWER_USER,ou=Groups', '2022-06-30 13:51:27', 'admin', NULL, NULL, 1, 1);


-- 能源能耗管理模块（仅能源项目需要取消注释，执行以下两句sql，共四行；其他平台不执行）
 REPLACE INTO `clbs`.`zw_c_resource` (`id`, `icon_cls`, `resource_name`, `type`, `code`, `permission`, `perm_value`, `description`, `parent_id`, `sort_order`, `domain`, `code_num`, `editable`, `enabled`, `flag`, `create_data_time`, `create_data_username`, `update_data_time`, `update_data_username`) VALUES
 ('c783c1c6-7bad-4444-95c8-8ea1c008c7a3', 'fa-th-list', '能源能耗管理', 1, NULL, NULL, 'energy-and-energy-management', NULL, '0', 110000, 2, '11000', 1, 1, 1, NULL, NULL, NULL, NULL);

 REPLACE INTO `clbs`.`zw_c_role_resource` (`id`, `resource_id`, `role_id`, `create_data_time`, `create_data_username`, `update_data_time`, `update_data_username`, `flag`, `editable`) VALUES
 ('2bf499fb-def6-4340-bb84-f9e387faa3df', 'c783c1c6-7bad-4444-95c8-8ea1c008c7a3', 'cn=ROLE_ADMIN,ou=Groups', '2023-06-02 09:34:05', 'admin', NULL, NULL, 1, 1);



