#保安服务公司审批通过的公司页面拉取到外网，配置`obpm2_security`.`dynamic_data_map_templates`
INSERT INTO `obpm2_security`.`dynamic_data_map_templates` (`mapkey`, `template`, `old_template`, `is_online`, `note`, `createdTime`, `region`) VALUES ( 'dzzw_tlk_SecuritySeviceK', 'insert into obpm2.tenant_organization_requests(id,industry_code,institutional_code,content,status,number,created_time) \nVALUES(\n\'#{id}\',\n\'01\',\n\'0102\',\n \'{\"companyName\":\"#{item_companyName}\",\n\"companyType\":\"#{item_companytype}\",\n\"phone\":\"#{item_phone}\",\n\"legalName\":\"#{item_legalName}\",\n\"legalCardNumber\":\"#{item_legalCardnumber}\",\n\"legalPhone\":\"#{item_legalPhone}\",\n\"registeredCapital\":\"#{item_registeredCapital}\",\n\"businessScope\":\"#{item_businessScope}\",\n\"address\":\"#{ITEM_zipCode}\",\n\"officePoliceAddress\":\"BJ_#{ITEM_officePoliceAddressID}\"\n}\',\n\'#{item_auditstatus}\',\n \'#{id}\', \n\'#{created_time}\');\ninsert into obpm2.shared_messages(id,sender_id,business_number,content,created_time,message_type,receiver,receiver_type,status,title,unique_id)\nVALUES(\n  \'#{id}\',\n  \'#{id}\',\n	\'18559681023\',\n  \'【百保盾】尊敬的#{item_companyName}，您办理的保安服务公司备案项已通过审批，请通过以下网址完善信息并开通企业账号：https://v5qy.te.baibaodun.com.cn/static/signon/fronts/#/register?number=#{id}\',\n   \'#{created_time}\',\n  	\'1\',\n  \'#{id}\',\n  \'1\',\n  \'1\',\n  \'百宝盾\',\n  \'#{id}\'\n	  )', NULL, '
', '保安服务公司审批通过的公司拉取到外网', '2023-05-06 18:14:10', NULL);

#保安培训单位审批通过的公司页面拉取到外网，配置`obpm2_security`.`dynamic_data_map_templates`
INSERT INTO `obpm2_security`.`dynamic_data_map_templates` ( `mapkey`, `template`, `old_template`, `is_online`, `note`, `createdTime`, `region`) VALUES ('dzzw_tlk_SecurityTrainingS', 'insert into obpm2.tenant_organization_requests(id,industry_code,institutional_code,content,status,number,created_time) \nVALUES(\n\'#{id}\',\n \'01\',\n \'0103\',\n \'{\"companyName\":\"#{item_companyName}\",\n\"companyType\":\"#{item_companytype}\",\n\"trainingContent\":\"#{item_trainingContent}\",\n\"legalName\":\"#{item_legalName}\",\n\"legalCardNumber\":\"#{item_legalCardnumber}\",\n\"legalPhone\":\"#{item_legalPhone}\",\n\"address\":\"#{ITEM_zipCode}\",\n\"officePoliceAddress\":\"BJ_#{ITEM_officePoliceAddressID}\"\n}\',\n\'#{item_auditstatus}\',\n\'#{id}\',\n\'#{created_time}\');\ninsert into obpm2.shared_messages(id,sender_id,business_number,content,created_time,message_type,receiver,receiver_type,status,title,unique_id)\nVALUES(\n  \'#{id}\',\n   \'#{id}\',\n	\'18559681023\',\n  \'【百保盾】尊敬的#{item_companyName}，您办理的保安培训单位备案项已通过审批，请通过以下网址完善信息并开通企业账号：https://v5qy.te.baibaodun.com.cn/static/signon/fronts/#/register?number=#{id}\',\n   \'#{created_time}\',\n  	\'1\',\n  \'#{id}\',\n  \'1\',\n  \'1\',\n  \'百宝盾\',\n  \'#{id}\'\n	  )', NULL, '
', '保安培训单位审批通过的公司拉取到外网', '2023-05-08 09:19:57', NULL);

#自行招用保安员单位审批通过的公司页面拉取到外网，配置`obpm2_security`.`dynamic_data_map_templates`
INSERT INTO `obpm2_security`.`dynamic_data_map_templates` ( `mapkey`, `template`, `old_template`, `is_online`, `note`, `createdTime`, `region`) VALUES ('dzzw_tlk_Recruitment', 'insert into obpm2.tenant_organization_requests(id,industry_code,institutional_code,content,status,number,created_time) \nVALUES(\n\'#{id}\',\n \'01\',\n  \'0104\',\n \'{\"companyName\":\"#{item_companyName}\",\n\"companyType\":\"#{item_companytype}\",\n\"legalName\":\"#{item_legalName}\",\n\"legalCardNumber\":\"#{item_legalCardnumber}\",\n\"legalPhone\":\"#{item_legalPhone}\",\n\"chargeName\":\"#{item_chargeName}\",\n\"chargePhone\":\"#{item_chargePhone}\",\n\"chargeCardNumber\":\"#{item_chargeCardNumber}\",\n\"creditCode\":\"#{item_creditCode}\",\n\"recordPersonNum\":\"#{item_recordPeronNum}\",\n\"address\":\"#{item_zipCode}\",\n\"officePoliceAddress\":\"BJ_#{ITEM_officePoliceAddressID}\"\n}\',\n\'#{item_auditstatus}\',\n \'#{id}\', \n\'#{created_time}\');\ninsert into obpm2.shared_messages(id,sender_id,business_number,content,created_time,message_type,receiver,receiver_type,status,title,unique_id)\nVALUES(\n  \'#{id}\',\n   \'#{id}\',\n	\'18559681023\',\n  \'【百保盾】尊敬的#{item_companyName}，您办理的自行招用保安员单位备案项已通过审批，请通过以下网址完善信息并开通企业账号：https://v5qy.te.baibaodun.com.cn/static/signon/fronts/#/register?number=#{id}\',\n   \'#{created_time}\',\n  	\'1\',\n  \'#{id}\',\n  \'1\',\n  \'1\',\n  \'百宝盾\',\n  \'#{id}\'\n	  )', NULL, '
', '自行招用保安员单位审批通过的公司拉取到外网', '2023-05-08 09:47:35', NULL);


#保安培训单位审批通过的公司拉取到外网，配置同步脚本`obpm2_security`.`meta_forms`表插入数据
INSERT INTO `obpm2_security`.`meta_forms` (`id`, `created_time`, `form_id`, `form_type`, `is_online`, `last_updated_time`, `name`, `table_name`, `application_meta_id`) VALUES ('dzzw_tlk_SecurityTrainingS_info', '2021-01-01 00:00:01', 'dzzw_tlk_SecurityTrainingS', '0', '
', '2021-01-01 00:00:01', '保安培训单位审批通过的公司拉取到外网', 'sync_dzzw_SecurityTrainingS_view', '0090e001-1b4c-4ea9-877e-a06d9ac4e888');

#保安服务公司审批通过的公司拉取到外网，配置同步脚本`obpm2_security`.`meta_forms`表插入数据
INSERT INTO `obpm2_security`.`meta_forms` (`id`, `created_time`, `form_id`, `form_type`, `is_online`, `last_updated_time`, `name`, `table_name`, `application_meta_id`) VALUES ('dzzw_tlk_SecuritySeviceK_info', '2021-01-01 00:00:01', 'dzzw_tlk_SecuritySeviceK', '0', '
', '2021-01-01 00:00:01', '保安服务公司审批通过的公司拉取到外网', 'sync_dzzw_SecuritySeviceK_view', '0090e001-1b4c-4ea9-877e-a06d9ac4e888');

#自行招用保安员单位审批通过的公司拉取到外网，配置同步脚本`obpm2_security`.`meta_forms`表插入数据
INSERT INTO `obpm2_security`.`meta_forms` (`id`, `created_time`, `form_id`, `form_type`, `is_online`, `last_updated_time`, `name`, `table_name`, `application_meta_id`) VALUES ('dzzw_tlk_recruitment_info', '2021-01-01 00:00:01', 'dzzw_tlk_recruitment', '0', '
', '2021-01-01 00:00:01', '自行招用保安员单位审批通过的公司拉取到外网', 'sync_dzzw_recruitment_view', '0090e001-1b4c-4ea9-877e-a06d9ac4e888');

#自行招用保安员单位审批通过的公司拉取到外网，配置同步脚本`obpm2_security`.`sync_meta_forms`表插入数据
INSERT INTO `obpm2_security`.`sync_meta_forms` (`id`, `config`, `created_time`, `filter`, `is_online`, `last_synced_time`, `last_updated_time`, `note`, `synced_record_count`, `form_meta_id`, `target_meta_id`) VALUES ('instance-form-dzzw-000-000-001-SecurityTrainingS', '{\"mapKey\":\"dzzw_tlk_SecurityTrainingS\"}', '2021-01-01 00:00:01', '', '1', '2023-03-22 17:11:16', '2021-01-01 00:00:01', '同步周期: >=2023-03-22 15:07:13.0 ~ < 2023-03-22 15:07:13.0 pageIndex=0;', '12288', 'dzzw_tlk_SecurityTrainingS_info', 'neidaiwai-baidu-api');

#保安服务公司审批通过的公司拉取到外网，配置同步脚本 `obpm2_security`.`sync_meta_forms`表插入数据
INSERT INTO `obpm2_security`.`sync_meta_forms` (`id`, `config`, `created_time`, `filter`, `is_online`, `last_synced_time`, `last_updated_time`, `note`, `synced_record_count`, `form_meta_id`, `target_meta_id`) VALUES ('instance-form-dzzw-000-000-001-SecuritySeviceK', '{\"mapKey\":\"dzzw_tlk_SecuritySeviceK\"}', '2021-01-01 00:00:01', '', '1', '2023-03-22 17:11:16', '2021-01-01 00:00:01', '同步周期: >=2023-03-22 15:07:13.0 ~ < 2023-03-22 15:07:13.0 pageIndex=0;', '12288', 'dzzw_tlk_SecuritySeviceK_info', 'neidaiwai-baidu-api');

#保安培训单位审批通过的公司拉取到外网，配置同步脚本`obpm2_security`.`sync_meta_forms`表插入数据
INSERT INTO `obpm2_security`.`sync_meta_forms` (`id`, `config`, `created_time`, `filter`, `is_online`, `last_synced_time`, `last_updated_time`, `note`, `synced_record_count`, `form_meta_id`, `target_meta_id`) VALUES ('instance-form-dzzw-000-000-001-recruitment', '{\"mapKey\":\"dzzw_tlk_recruitment\"}', '2021-01-01 00:00:01', '', '1', '2023-03-22 17:11:16', '2021-01-01 00:00:01', '同步周期: >=2023-03-22 15:07:13.0 ~ < 2023-03-22 15:07:13.0 pageIndex=0;', '12288', 'dzzw_tlk_recruitment_info', 'neidaiwai-baidu-api');


#security_flow创建保安培训单位审批通过的视图
CREATE VIEW `sync_dzzw_securitytrainings_view` AS select `tlk_securitytrainings`.`ID` AS `id`,`tlk_securitytrainings`.`ITEM_COMPANYNAME` AS `item_companyName`,`tlk_securitytrainings`.`ITEM_COMPANYTYPE` AS `item_companytype`,`tlk_securitytrainings`.`ITEM_LEGALNAME` AS `item_legalName`,`tlk_securitytrainings`.`ITEM_LEGALCARDNUMBER` AS `item_legalCardnumber`,`tlk_securitytrainings`.`ITEM_LEGALPHONE` AS `item_legalPhone`,`tlk_securitytrainings`.`ITEM_TRAININGCONTENT` AS `ITEM_trainingContent`,`tlk_securitytrainings`.`ITEM_OFFICEPOLICEADDRESSID` AS `ITEM_officePoliceAddressID`,`tlk_securitytrainings`.`ITEM_ZIPCODE` AS `ITEM_zipCode`,`tlk_securitytrainings`.`ITEM_BUSINESSSCOPE` AS `item_businessScope`,date_format(now(),'%Y-%m-%d %H:%i:%s') AS `created_time`,`tlk_securitytrainings`.`ITEM_AUDITSTATUS` AS `item_auditstatus`,`tlk_securitytrainings`.`LASTMODIFIED` AS `LASTMODIFIED` from `tlk_securitytrainings` where (`tlk_securitytrainings`.`ITEM_AUDITSTATUS` = 1)

#security_flow创建保安服务公司审批通过的视图
CREATE VIEW `sync_dzzw_securitysevicek_view` AS select `tlk_securitysevicek`.`ID` AS `id`,`tlk_securitysevicek`.`ITEM_companyName` AS `item_companyName`,`tlk_securitysevicek`.`ITEM_companyType` AS `item_companytype`,`tlk_securitysevicek`.`ITEM_phone` AS `item_phone`,`tlk_securitysevicek`.`ITEM_legalName` AS `item_legalName`,`tlk_securitysevicek`.`ITEM_legalCardnumber` AS `item_legalCardnumber`,`tlk_securitysevicek`.`ITEM_legalPhone` AS `item_legalPhone`,cast(`tlk_securitysevicek`.`ITEM_registeredCapital` as char charset utf8) AS `item_registeredCapital`,`tlk_securitysevicek`.`ITEM_businessScope` AS `item_businessScope`,`tlk_securitysevicek`.`ITEM_zipcode` AS `ITEM_zipCode`,`tlk_securitysevicek`.`ITEM_officePoliceAddressID` AS `ITEM_officePoliceAddressID`,date_format(now(),'%Y-%m-%d %H:%i:%s') AS `created_time`,`tlk_securitysevicek`.`ITEM_auditStatus` AS `item_auditstatus`,`tlk_securitysevicek`.`LASTMODIFIED` AS `LASTMODIFIED` from `tlk_securitysevicek` where (`tlk_securitysevicek`.`ITEM_auditStatus` = 1)

#security_flow创建自行招用保安员单位审批通过的视图
CREATE  VIEW `sync_dzzw_recruitment_view` AS select `tlk_recruitment`.`ID` AS `id`,`tlk_recruitment`.`ITEM_companyName` AS `item_companyName`,`tlk_recruitment`.`ITEM_companyType` AS `item_companytype`,`tlk_recruitment`.`ITEM_legalName` AS `item_legalName`,`tlk_recruitment`.`ITEM_legalCardnumber` AS `item_legalCardnumber`,`tlk_recruitment`.`ITEM_legalPhone` AS `item_legalPhone`,`tlk_recruitment`.`ITEM_chargeName` AS `item_chargeName`,`tlk_recruitment`.`ITEM_chargePhone` AS `item_chargePhone`,`tlk_recruitment`.`ITEM_chargeCardNumber` AS `item_chargeCardNumber`,`tlk_recruitment`.`ITEM_creditCode` AS `item_creditCode`,cast(`tlk_recruitment`.`ITEM_recordPeronNum` as char charset utf8) AS `item_recordPeronNum`,`tlk_recruitment`.`ITEM_zipCode` AS `ITEM_zipCode`,`tlk_recruitment`.`ITEM_officePoliceAddressID` AS `ITEM_officePoliceAddressID`,date_format(now(),'%Y-%m-%d %H:%i:%s') AS `created_time`,`tlk_recruitment`.`ITEM_auditStatus` AS `item_auditstatus`,`tlk_recruitment`.`LASTMODIFIED` AS `LASTMODIFIED` from `tlk_recruitment` where (`tlk_recruitment`.`ITEM_auditStatus` = 1)