select * from obpm2.rbac_categories where name='电子政务' ; select * from obpm2.rbac_resources where category_id in (select id from obpm2.rbac_categories where name='电子政务'); INSERT INTO `obpm2`.`rbac_categories` (`id`, `creator_created_time`, `creator_id`, `creator_name`, `last_modifier_created_time`, `last_modifier_id`, `last_modifier_name`, `code`, `created_time`, `name`, `note`) VALUES ('third_party__ZG0ZtjrEhvNbj2rlOsF1', NULL, NULL, NULL, NULL, NULL, NULL, 'RC_third_party__ZG0ZtjrEhvNbj2rlOsF1', '2021-11-23 03:37:58', '报名管理', ''); INSERT INTO `obpm2`.`rbac_resources` (`id`, `creator_created_time`, `creator_id`, `creator_name`, `last_modifier_created_time`, `last_modifier_id`, `last_modifier_name`, `created_time`, `extend_field`, `meta_config`, `meta_data`, `meta_id`, `code`, `data`, `data_type`, `level`, `name`, `note`, `tree_path_id`, `category_id`, `parent_id`) VALUES ('__sCf0MnLmHy3upyi0AdJ6', NULL, NULL, NULL, NULL, NULL, NULL, '2021-12-23 03:52:28', NULL, NULL, NULL, NULL, 'RCR___sCf0MnLmHy3upyi0AdJ6', '管理员', 'Menu', 0, '管理员', NULL, '__sCf0MnLmHy3upyi0AdJ6', 'third_party__ZG0ZtjrEhvNbj2rlOsF1', NULL); select * from obpm2.rbac_categories where name in ('报名管理','报名审核管理') ; select * from obpm2.rbac_resources where category_id in (select id from obpm2.rbac_categories where name in ('报名管理','报名审核管理') ); select a.BIND_APPLICATIONS from obpm2.t_domain a limit 10; INSERT INTO `obpm2`.`rbac_resources` (`id`, `creator_created_time`, `creator_id`, `creator_name`, `last_modifier_created_time`, `last_modifier_id`, `last_modifier_name`, `created_time`, `extend_field`, `meta_config`, `meta_data`, `meta_id`, `code`, `data`, `data_type`, `level`, `name`, `note`, `tree_path_id`, `category_id`, `parent_id`) VALUES ('__sCf0MnLmHy3upyi0AdJ5', NULL, NULL, NULL, NULL, NULL, NULL, '2021-12-23 03:52:28', NULL, NULL, NULL, NULL, 'RCR___sCf0MnLmHy3upyi0AdJ5', '报名条件配置', 'Menu', 0, '报名条件配置', NULL, '__sCf0MnLmHy3upyi0AdJ5', 'third_party__ZG0ZtjrEhvNbj2rlOsF', NULL); select * from organizationauth.tlk_app_list where item_APP_ID like '%third_party%'; INSERT INTO `organizationauth`.`tlk_app_list` (`PARENT`, `LASTMODIFIED`, `FORMNAME`, `STATE`, `AUDITUSER`, `AUDITDATE`, `AUTHOR`, `AUTHOR_DEPT_INDEX`, `CREATED`, `FORMID`, `ISTMP`, `VERSIONS`, `APPLICATIONID`, `STATEINT`, `STATELABEL`, `AUDITORNAMES`, `LASTFLOWOPERATION`, `LASTMODIFIER`, `DOMAINID`, `AUDITORLIST`, `COAUDITORLIST`, `STATELABELINFO`, `PREVAUDITNODE`, `PREVAUDITUSER`, `OPTIONITEM`, `SIGN`, `KINGGRIDSIGNATURE`, `ITEM_APP_NAME`, `ITEM_CHARGING_METHOD`, `ITEM_MONTH_PRICE`, `ITEM_APP_STATE`, `ITEM_APP_ICON`, `ITEM_SORT_NUM`, `ITEM_APP_INTRODUCE`, `ID`, `ITEM_APPTYPE_HIDE`, `ITEM_APPTYPE_DISPLAY`, `ITEM_ONETIME_PRICE`, `ITEM_YEAR_PRICE`, `ITEM_APP_ID`, `ITEM_APP_ID1`, `ITEM_DEFAULT_TIME`, `ITEM_FLAG`, `ITEM_EXCLUSIVE`, `ITEM_CLIENTYPE`, `ITEM_INAWORD`, `ITEM_BAOFFICETYPE`, `ITEM_REGION`, `ITEM_REGIONID`, `ITEM_ORGANIZATION`, `ITEM_ORGANIZATIONID`, `AUTHORDEPTID`, `AUTHOR_USER_INDEX`, `SUBFORMIDS`, `INITIATOR`, `ITEM_USERCASE`, `ITEM_APPTYPE_DISPLAY1`, `ITEM_APPTYPE_HIDE1`, `ITEM_APPTYPE_DISPLAY2`, `ITEM_APPTYPE_HIDE2`, `ITEM_SORT_NUM1`, `ITEM_SORT_NUM2`, `ITEM_APP_SOURCE`, `ITEM_APP_URL`) VALUES (NULL, '2025-11-13 17:29:37', '平台应用管理/应用列表/app_list', NULL, NULL, NULL, '__A7yVvj33RRHsOLgvt0d', NULL, '2025-11-13 17:29:37', '__VTpi4B5zQh6c7NIZQPw', b'0', 1, '__ekbsagrjF60f5gJnBQQ', 0, '', '', NULL, '__A7yVvj33RRHsOLgvt0d', '__2gH5luUlviULa7KnmqW', '{}', '{}', '[{\"nodes\":[{\"nodeId\":\"\",\"stateLabel\":\"\",\"state\":\"\",\"auditors\":[],\"coAuditors\":[]}]}]', NULL, NULL, NULL, NULL, NULL, '报名管理', '0', NULL, 's1', '[{\"name\":\"1652429094355门户@2x.png\",\"path\":\"https:\\/\\/download.baibaodun.cn\\/uploads\\/2025\\/11-06\\/__2gH5luUlviULa7KnmqW\\/1762421373932\\/1652429094355门户@2x.png\",\"url\":\"https:\\/\\/download.baibaodun.cn\\/uploads\\/2025\\/11-06\\/__2gH5luUlviULa7KnmqW\\/1762421373932\\/1652429094355门户@2x.png\",\"fileType\":\"\",\"uploader\":\"平台运营超管_禁止操作\",\"uploadTime\":\"2025-11-06 17:29:34\",\"userName\":\"平台运营超管_禁止操作\",\"time\":\"2025-11-06 17:29:34\",\"size\":1198,\"uid\":1762421374684,\"status\":\"success\"}]', NULL, NULL, 'third_party__ZG0ZtjrEhvNbj2rlOsF--__VTpi4B5zQh6c7NIZQPw', '', '企业注册', NULL, NULL, 'third_party__ZG0ZtjrEhvNbj2rlOsF', 'A', NULL, '', '否', '电脑端;移动端', '', '0102;0103;0104;0101', NULL, '', NULL, '', '__sWKq8S8pQPlFBSHj93k', '$$$test', NULL, NULL, NULL, '', '', '', '', NULL, NULL, '1', ''); INSERT INTO `organizationauth`.`tlk_app_list` (`PARENT`, `LASTMODIFIED`, `FORMNAME`, `STATE`, `AUDITUSER`, `AUDITDATE`, `AUTHOR`, `AUTHOR_DEPT_INDEX`, `CREATED`, `FORMID`, `ISTMP`, `VERSIONS`, `APPLICATIONID`, `STATEINT`, `STATELABEL`, `AUDITORNAMES`, `LASTFLOWOPERATION`, `LASTMODIFIER`, `DOMAINID`, `AUDITORLIST`, `COAUDITORLIST`, `STATELABELINFO`, `PREVAUDITNODE`, `PREVAUDITUSER`, `OPTIONITEM`, `SIGN`, `KINGGRIDSIGNATURE`, `ITEM_APP_NAME`, `ITEM_CHARGING_METHOD`, `ITEM_MONTH_PRICE`, `ITEM_APP_STATE`, `ITEM_APP_ICON`, `ITEM_SORT_NUM`, `ITEM_APP_INTRODUCE`, `ID`, `ITEM_APPTYPE_HIDE`, `ITEM_APPTYPE_DISPLAY`, `ITEM_ONETIME_PRICE`, `ITEM_YEAR_PRICE`, `ITEM_APP_ID`, `ITEM_APP_ID1`, `ITEM_DEFAULT_TIME`, `ITEM_FLAG`, `ITEM_EXCLUSIVE`, `ITEM_CLIENTYPE`, `ITEM_INAWORD`, `ITEM_BAOFFICETYPE`, `ITEM_REGION`, `ITEM_REGIONID`, `ITEM_ORGANIZATION`, `ITEM_ORGANIZATIONID`, `AUTHORDEPTID`, `AUTHOR_USER_INDEX`, `SUBFORMIDS`, `INITIATOR`, `ITEM_USERCASE`, `ITEM_APPTYPE_DISPLAY1`, `ITEM_APPTYPE_HIDE1`, `ITEM_APPTYPE_DISPLAY2`, `ITEM_APPTYPE_HIDE2`, `ITEM_SORT_NUM1`, `ITEM_SORT_NUM2`, `ITEM_APP_SOURCE`, `ITEM_APP_URL`) VALUES (NULL, '2025-11-13 17:29:37', '平台应用管理/应用列表/app_list', NULL, NULL, NULL, '__A7yVvj33RRHsOLgvt0d', NULL, '2025-11-13 17:29:37', '__VTpi4B5zQh6c7NIZQPw', b'0', 1, '__ekbsagrjF60f5gJnBQQ', 0, '', '', NULL, '__A7yVvj33RRHsOLgvt0d', '__2gH5luUlviULa7KnmqW', '{}', '{}', '[{\"nodes\":[{\"nodeId\":\"\",\"stateLabel\":\"\",\"state\":\"\",\"auditors\":[],\"coAuditors\":[]}]}]', NULL, NULL, NULL, NULL, NULL, '报名审核管理', '0', NULL, 's1', '[{\"name\":\"1652429094355门户@2x.png\",\"path\":\"https:\\/\\/download.baibaodun.cn\\/uploads\\/2025\\/11-06\\/__2gH5luUlviULa7KnmqW\\/1762421373932\\/1652429094355门户@2x.png\",\"url\":\"https:\\/\\/download.baibaodun.cn\\/uploads\\/2025\\/11-06\\/__2gH5luUlviULa7KnmqW\\/1762421373932\\/1652429094355门户@2x.png\",\"fileType\":\"\",\"uploader\":\"平台运营超管_禁止操作\",\"uploadTime\":\"2025-11-06 17:29:34\",\"userName\":\"平台运营超管_禁止操作\",\"time\":\"2025-11-06 17:29:34\",\"size\":1198,\"uid\":1762421374684,\"status\":\"success\"}]', NULL, NULL, 'third_party__ZG0ZtjrEhvNbj2rlOsF1--__VTpi4B5zQh6c7NIZQPw', '', '企业注册', NULL, NULL, 'third_party__ZG0ZtjrEhvNbj2rlOsF1', 'A', NULL, '', '否', '电脑端;移动端', '', '0102;0103;0104;0101', NULL, '', NULL, '', '__sWKq8S8pQPlFBSHj93k', '$$$test', NULL, NULL, NULL, '', '', '', '', NULL, NULL, '1', ''); select a.BIND_APPLICATIONS from obpm2.t_domain a where name like '%0910-0822-082208210821百川信啊%'; select a.BIND_APPLICATIONS from obpm2.t_domain a where a.id='__2gH5luUlviULa7KnmqW'; select a.* from obpm2.t_domain a where name like '%0910-0822-082208210821百川信啊%'; select * from obpm2.tenant_organizations where name like '%0910-0822-082208210821百川信啊%'; {icon:'/uploads/lib/icon/upload/从业单位管理@2x.png',url:'https://www.baidu.com/',label:'报名数据审核'} label 对应字段actionContent;icon 对应字段ico和newIco;label对应name http://paas.te.baibaodun.com.cn/#/auto-login?qt=eyJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJhdXRoMCIsImV4cCI6MTc2Mzg2MzQzMSwidXNlcm5hbWUiOiJfX0E3eVZ2ajMzUlJIc09MZ3Z0MGQifQ.FUvDCoednA212kmGV6b70HGRIigoBhQITVjp2ZnNPbg&org_id=428564963670360064&return-url=/renders/1182773632252067840 帮我在localStorage获取domainId 和 token的值替换到url:http://paas.te.baibaodun.com.cn/#/auto-login?qt=eyJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJhdXRoMCIsImV4cCI6MTc2Mzg2MzQzMSwidXNlcm5hbWUiOiJfX0E3eVZ2ajMzUlJIc09MZ3Z0MGQifQ.FUvDCoednA212kmGV6b70HGRIigoBhQITVjp2ZnNPbg&org_id=428564963670360064&return-url=/renders/1182773632252067840 token对应qt;domainId对应org_id http://paas.te.baibaodun.com.cn/#/renders/1182773632252067840?qt=和org_id http://paas.te.baibaodun.com.cn/#/auto-login?qt=和org_id&return-url=/rexxxxx INSERT INTO `obpm2`.`rbac_resources` (`id`, `creator_created_time`, `creator_id`, `creator_name`, `last_modifier_created_time`, `last_modifier_id`, `last_modifier_name`, `created_time`, `extend_field`, `meta_config`, `meta_data`, `meta_id`, `code`, `data`, `data_type`, `level`, `name`, `note`, `tree_path_id`, `category_id`, `parent_id`) VALUES ('__sCf0MnLmHy3upyi0AdJ1', NULL, NULL, NULL, NULL, NULL, NULL, '2021-12-23 03:52:28', NULL, NULL, NULL, NULL, 'RCR___sCf0MnLmHy3upyi0AdJ1', '{icon:\'/uploads/lib/icon/upload/从业单位管理@2x.png\',url:\'http://paas.te.baibaodun.com.cn/#/auto-login?qt=eyJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJhdXRoMCIsImV4cCI6MTc2Mzg2MzQzMSwidXNlcm5hbWUiOiJfX0E3eVZ2ajMzUlJIc09MZ3Z0MGQifQ.FUvDCoednA212kmGV6b70HGRIigoBhQITVjp2ZnNPbg&org_id=428564963670360064&return-url=/renders/1182773632252067840\',label:\'报名条件配置\'}', 'Menu', 0, '报名条件配置', NULL, '__sCf0MnLmHy3upyi0AdJ1', 'third_party__ZG0ZtjrEhvNbj2rlOsF', NULL); INSERT INTO `obpm2`.`rbac_resources` (`id`, `creator_created_time`, `creator_id`, `creator_name`, `last_modifier_created_time`, `last_modifier_id`, `last_modifier_name`, `created_time`, `extend_field`, `meta_config`, `meta_data`, `meta_id`, `code`, `data`, `data_type`, `level`, `name`, `note`, `tree_path_id`, `category_id`, `parent_id`) VALUES ('__sCf0MnLmHy3upyi0AdJ2', NULL, NULL, NULL, NULL, NULL, NULL, '2021-12-23 03:52:28', NULL, NULL, NULL, NULL, 'RCR___sCf0MnLmHy3upyi0AdJ2', '{icon:\'/uploads/lib/icon/upload/从业单位管理@2x.png\',url:\'http://paas.te.baibaodun.com.cn/#/auto-login?qt=eyJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJhdXRoMCIsImV4cCI6MTc2Mzg2MzQzMSwidXNlcm5hbWUiOiJfX0E3eVZ2ajMzUlJIc09MZ3Z0MGQifQ.FUvDCoednA212kmGV6b70HGRIigoBhQITVjp2ZnNPbg&org_id=428564963670360064&return-url=/renders/1182773632252067840\',label:\'报名数据\'}', 'Menu', 0, '报名数据', NULL, '__sCf0MnLmHy3upyi0AdJ2', 'third_party__ZG0ZtjrEhvNbj2rlOsF', NULL); INSERT INTO `obpm2`.`rbac_resources` (`id`, `creator_created_time`, `creator_id`, `creator_name`, `last_modifier_created_time`, `last_modifier_id`, `last_modifier_name`, `created_time`, `extend_field`, `meta_config`, `meta_data`, `meta_id`, `code`, `data`, `data_type`, `level`, `name`, `note`, `tree_path_id`, `category_id`, `parent_id`) VALUES ('__sCf0MnLmHy3upyi0AdJ3', NULL, NULL, NULL, NULL, NULL, NULL, '2021-12-23 03:52:28', NULL, NULL, NULL, NULL, 'RCR___sCf0MnLmHy3upyi0AdJ3', '{icon:\'/uploads/lib/icon/upload/从业单位管理@2x.png\',url:\'http://paas.te.baibaodun.com.cn/#/auto-login?qt=eyJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJhdXRoMCIsImV4cCI6MTc2Mzg2MzQzMSwidXNlcm5hbWUiOiJfX0E3eVZ2ajMzUlJIc09MZ3Z0MGQifQ.FUvDCoednA212kmGV6b70HGRIigoBhQITVjp2ZnNPbg&org_id=428564963670360064&return-url=/renders/1182773632252067840\',label:\'变更管理\'}', 'Menu', 0, '变更管理', NULL, '__sCf0MnLmHy3upyi0AdJ3', 'third_party__ZG0ZtjrEhvNbj2rlOsF', NULL); INSERT INTO `obpm2`.`rbac_resources` (`id`, `creator_created_time`, `creator_id`, `creator_name`, `last_modifier_created_time`, `last_modifier_id`, `last_modifier_name`, `created_time`, `extend_field`, `meta_config`, `meta_data`, `meta_id`, `code`, `data`, `data_type`, `level`, `name`, `note`, `tree_path_id`, `category_id`, `parent_id`) VALUES ('__sCf0MnLmHy3upyi0AdJ4', NULL, NULL, NULL, NULL, NULL, NULL, '2021-12-23 03:52:28', NULL, NULL, NULL, NULL, 'RCR___sCf0MnLmHy3upyi0AdJ4', '{icon:\'/uploads/lib/icon/upload/从业单位管理@2x.png\',url:\'http://paas.te.baibaodun.com.cn/#/auto-login?qt=eyJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJhdXRoMCIsImV4cCI6MTc2Mzg2MzQzMSwidXNlcm5hbWUiOiJfX0E3eVZ2ajMzUlJIc09MZ3Z0MGQifQ.FUvDCoednA212kmGV6b70HGRIigoBhQITVjp2ZnNPbg&org_id=428564963670360064&return-url=/renders/1182773632252067840\',label:\'变更列表\'}', 'Menu', 1, '变更列表', NULL, '__sCf0MnLmHy3upyi0AdJ4', 'third_party__ZG0ZtjrEhvNbj2rlOsF', '__sCf0MnLmHy3upyi0AdJ3'); INSERT INTO `obpm2`.`rbac_resources` (`id`, `creator_created_time`, `creator_id`, `creator_name`, `last_modifier_created_time`, `last_modifier_id`, `last_modifier_name`, `created_time`, `extend_field`, `meta_config`, `meta_data`, `meta_id`, `code`, `data`, `data_type`, `level`, `name`, `note`, `tree_path_id`, `category_id`, `parent_id`) VALUES ('__sCf0MnLmHy3upyi0AdJ5', NULL, NULL, NULL, NULL, NULL, NULL, '2021-12-23 03:52:28', NULL, NULL, NULL, NULL, 'RCR___sCf0MnLmHy3upyi0AdJ5', '{icon:\'/uploads/lib/icon/upload/从业单位管理@2x.png\',url:\'http://paas.te.baibaodun.com.cn/#/auto-login?qt=eyJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJhdXRoMCIsImV4cCI6MTc2Mzg2MzQzMSwidXNlcm5hbWUiOiJfX0E3eVZ2ajMzUlJIc09MZ3Z0MGQifQ.FUvDCoednA212kmGV6b70HGRIigoBhQITVjp2ZnNPbg&org_id=428564963670360064&return-url=/renders/1182773632252067840\',label:\'其他列表\'}', 'Menu', 1, '其他列表', NULL, '__sCf0MnLmHy3upyi0AdJ5', 'third_party__ZG0ZtjrEhvNbj2rlOsF', '__sCf0MnLmHy3upyi0AdJ3'); INSERT INTO `obpm2`.`rbac_resources` (`id`, `creator_created_time`, `creator_id`, `creator_name`, `last_modifier_created_time`, `last_modifier_id`, `last_modifier_name`, `created_time`, `extend_field`, `meta_config`, `meta_data`, `meta_id`, `code`, `data`, `data_type`, `level`, `name`, `note`, `tree_path_id`, `category_id`, `parent_id`) VALUES ('__sCf0MnLmHy3upyi0AdJ6', NULL, NULL, NULL, NULL, NULL, NULL, '2021-12-23 03:52:28', NULL, NULL, NULL, NULL, 'RCR___sCf0MnLmHy3upyi0AdJ6', '{icon:\'/uploads/lib/icon/upload/从业单位管理@2x.png\',url:\'http://paas.te.baibaodun.com.cn/#/auto-login?qt=eyJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJhdXRoMCIsImV4cCI6MTc2Mzg2MzQzMSwidXNlcm5hbWUiOiJfX0E3eVZ2ajMzUlJIc09MZ3Z0MGQifQ.FUvDCoednA212kmGV6b70HGRIigoBhQITVjp2ZnNPbg&org_id=428564963670360064&return-url=/renders/1182773632252067840\',label:\'报名数据审核1234566\'}', 'Menu', 0, '报名数据审核', NULL, '__sCf0MnLmHy3upyi0AdJ6', 'third_party__ZG0ZtjrEhvNbj2rlOsF1', NULL);