INSERT INTO `obpm2_security`.`dynamic_data_map_templates` (`id`, `mapkey`, `template`, `old_template`, `is_online`, `note`, `createdTime`, `region`) VALUES ('1', 'zhihuibaoan-ImportantMan', 'INSERT INTO\n  baibaodunflow.tlk_importantman (\n    PARENT,\n    LASTMODIFIED,\n    FORMNAME,\n    STATE,\n    AUDITUSER,\n    AUDITDATE,\n    AUTHOR,\n    AUTHOR_DEPT_INDEX,\n    CREATED,\n    FORMID,\n    ISTMP,\n    VERSIONS,\n    APPLICATIONID,\n    STATEINT,\n    STATELABEL,\n    AUDITORNAMES,\n    LASTFLOWOPERATION,\n    LASTMODIFIER,\n    DOMAINID,\n    AUDITORLIST,\n    COAUDITORLIST,\n    STATELABELINFO,\n    PREVAUDITNODE,\n    PREVAUDITUSER,\n    OPTIONITEM,\n    SIGN,\n    KINGGRIDSIGNATURE,\n    ITEM_questionType,\n    ITEM_documentID,\n    ITEM_securityName,\n    ITEM_phone,\n    ITEM_companyName,\n    ITEM_domain_id,\n    ITEM_workStatus,\n    ITEM_compareTime,\n    ITEM_registerPoliceAddressID,\n    ITEM_registerPoliceAddress,\n    ITEM_policeStatus,\n    ITEM_policeInternalAdvice,\n    ITEM_policeExternalAdvice,\n    ITEM_policeSuggestedTreatment,\n    ITEM_policeMan,\n    ITEM_policeOrganization,\n    ITEM_policeTime,\n    ITEM_companyMan,\n    ITEM_companyTime,\n    ITEM_companyStatus,\n    ITEM_companyTreatment,\n    ID,\n    ITEM_lastCompareTime,\n    AUTHORDEPTID,\n    AUTHOR_USER_INDEX,\n    SUBFORMIDS,\n    INITIATOR\n  )\nVALUES\n  (\n    \'#{PARENT}\',\n    \'#{LASTMODIFIED}\',\n    \'#{FORMNAME}\',\n    \'#{STATE}\',\n    \'#{AUDITUSER}\',\n    \'#{AUDITDATE}\',\n    \'#{AUTHOR}\',\n    \'#{AUTHOR_DEPT_INDEX}\',\n    \'#{CREATED}\',\n    \'__CrVIR32eQhv9xvrEuYF\',\n    \'#{ISTMP}\',\n    \'#{VERSIONS}\',\n    \'__DXZvc8mnEmDqMARhK7G\',\n    \'#{STATEINT}\',\n    \'#{STATELABEL}\',\n    \'#{AUDITORNAMES}\',\n    \'#{LASTFLOWOPERATION}\',\n    \'#{LASTMODIFIER}\',\n    \'#{ITEM_domain_id}\',\n    \'#{AUDITORLIST}\',\n    \'#{COAUDITORLIST}\',\n    \'#{STATELABELINFO}\',\n    \'#{PREVAUDITNODE}\',\n    \'#{PREVAUDITUSER}\',\n    \'#{OPTIONITEM}\',\n    \'#{SIGN}\',\n    \'#{KINGGRIDSIGNATURE}\',\n    \'#{ITEM_questionType}\',\n    \'#{ITEM_documentID}\',\n    \'#{ITEM_securityName}\',\n    \'#{ITEM_phone}\',\n    \'#{ITEM_companyName}\',\n    \'#{ITEM_domain_id}\',\n    \'#{ITEM_workStatus}\',\n    \'#{ITEM_compareTime}\',\n    \'#{ITEM_registerPoliceAddressID}\',\n    \'#{ITEM_registerPoliceAddress}\',\n    \'#{ITEM_policeStatus}\',\n    \'#{ITEM_policeInternalAdvice}\',\n    \'#{ITEM_policeExternalAdvice}\',\n    \'#{ITEM_policeSuggestedTreatment}\',\n    \'#{ITEM_policeMan}\',\n    \'#{ITEM_policeOrganization}\',\n    \'#{ITEM_policeTime}\',\n    \'#{ITEM_companyMan}\',\n    \'#{ITEM_companyTime}\',\n    \'#{ITEM_companyStatus}\',\n    \'#{ITEM_companyTreatment}\',\n    REPLACE (\n      \'#{ID}\',\n      \'__38HWQpmVuW7sNdWBluk\',\n      \'__CrVIR32eQhv9xvrEuYF\'\n    ),\n    \'#{ITEM_lastCompareTime}\',\n    \'#{AUTHORDEPTID}\',\n    \'#{AUTHOR_USER_INDEX}\',\n    \'#{SUBFORMIDS}\',\n    \'#{INITIATOR}\'\n  ) ON DUPLICATE KEY\nUPDATE APPLICATIONID=\'__DXZvc8mnEmDqMARhK7G\';\n\nUPDATE baibaodunflow.tlk_importantman SET \n  LASTMODIFIED = \'#{LASTMODIFIED}\',\n  ITEM_policeStatus = \'#{ITEM_policeStatus}\',\n  ITEM_policeInternalAdvice = \'#{ITEM_policeInternalAdvice}\',\n  ITEM_policeExternalAdvice = \'#{ITEM_policeExternalAdvice}\',\n  ITEM_policeSuggestedTreatment = \'#{ITEM_policeSuggestedTreatment}\',\n  ITEM_policeMan = \'#{ITEM_policeMan}\',\n  ITEM_policeOrganization = \'#{ITEM_policeOrganization}\',\n  ITEM_policeTime = \'#{ITEM_policeTime}\'\nWHERE ID=REPLACE (\n      \'#{ID}\',\n      \'__38HWQpmVuW7sNdWBluk\',\n      \'__CrVIR32eQhv9xvrEuYF\'\n    ) ', NULL, '
', '智慧保安-重点人员', '2022-09-13 15:41:05', 'govin-to-public');
INSERT INTO `obpm2_security`.`dynamic_data_map_templates` (`id`, `mapkey`, `template`, `old_template`, `is_online`, `note`, `createdTime`, `region`) VALUES ('2', 'zhihuibaoan-EscapeMan', 'INSERT INTO\n  baibaodunflow.tlk_escapeman (\n    PARENT,\n    LASTMODIFIED,\n    FORMNAME,\n    STATE,\n    AUDITUSER,\n    AUDITDATE,\n    AUTHOR,\n    AUTHOR_DEPT_INDEX,\n    CREATED,\n    FORMID,\n    ISTMP,\n    VERSIONS,\n    APPLICATIONID,\n    STATEINT,\n    STATELABEL,\n    AUDITORNAMES,\n    LASTFLOWOPERATION,\n    LASTMODIFIER,\n    DOMAINID,\n    AUDITORLIST,\n    COAUDITORLIST,\n    STATELABELINFO,\n    PREVAUDITNODE,\n    PREVAUDITUSER,\n    OPTIONITEM,\n    SIGN,\n    KINGGRIDSIGNATURE,\n    ITEM_questionType,\n    ITEM_documentID,\n    ITEM_securityName,\n    ITEM_phone,\n    ITEM_companyName,\n    ITEM_domain_id,\n    ITEM_workStatus,\n    ITEM_compareTime,\n    ITEM_registerPoliceAddressID,\n    ITEM_registerPoliceAddress,\n    ITEM_policeStatus,\n    ITEM_captureStatus,\n    ITEM_policeInternalAdvice,\n    ITEM_policeExternalAdvice,\n    ITEM_policeSuggestedTreatment,\n    ITEM_policeMan,\n    ITEM_policeOrganization,\n    ITEM_policeTime,\n    ITEM_companyMan,\n    ITEM_companyTime,\n    ITEM_companyStatus,\n    ITEM_companyTreatment,\n    ID,\n    ITEM_lastCompareTime,\n    AUTHORDEPTID,\n    AUTHOR_USER_INDEX,\n    SUBFORMIDS,\n    INITIATOR\n  )\nVALUES\n  (\n    \'#{PARENT}\',\n    \'#{LASTMODIFIED}\',\n    \'#{FORMNAME}\',\n    \'#{STATE}\',\n    \'#{AUDITUSER}\',\n    \'#{AUDITDATE}\',\n    \'#{AUTHOR}\',\n    \'#{AUTHOR_DEPT_INDEX}\',\n    \'#{CREATED}\',\n    \'__nGsPx71jDn3zzNbSCZP\',\n    \'#{ISTMP}\',\n    \'#{VERSIONS}\',\n    \'__DXZvc8mnEmDqMARhK7G\',\n    \'#{STATEINT}\',\n    \'#{STATELABEL}\',\n    \'#{AUDITORNAMES}\',\n    \'#{LASTFLOWOPERATION}\',\n    \'#{LASTMODIFIER}\',\n    \'#{ITEM_domain_id}\',\n    \'#{AUDITORLIST}\',\n    \'#{COAUDITORLIST}\',\n    \'#{STATELABELINFO}\',\n    \'#{PREVAUDITNODE}\',\n    \'#{PREVAUDITUSER}\',\n    \'#{OPTIONITEM}\',\n    \'#{SIGN}\',\n    \'#{KINGGRIDSIGNATURE}\',\n    \'#{ITEM_questionType}\',\n    \'#{ITEM_documentID}\',\n    \'#{ITEM_securityName}\',\n    \'#{ITEM_phone}\',\n    \'#{ITEM_companyName}\',\n    \'#{ITEM_domain_id}\',\n    \'#{ITEM_workStatus}\',\n    \'#{ITEM_compareTime}\',\n    \'#{ITEM_registerPoliceAddressID}\',\n    \'#{ITEM_registerPoliceAddress}\',\n    \'#{ITEM_policeStatus}\',\n    \'#{ITEM_captureStatus}\',\n    \'#{ITEM_policeInternalAdvice}\',\n    \'#{ITEM_policeExternalAdvice}\',\n    \'#{ITEM_policeSuggestedTreatment}\',\n    \'#{ITEM_policeMan}\',\n    \'#{ITEM_policeOrganization}\',\n    \'#{ITEM_policeTime}\',\n    \'#{ITEM_companyMan}\',\n    \'#{ITEM_companyTime}\',\n    \'#{ITEM_companyStatus}\',\n    \'#{ITEM_companyTreatment}\',\n    REPLACE (\n      \'#{ID}\',\n      \'__ovMcA0Xv3ZRp8VsCFpM\',\n      \'__nGsPx71jDn3zzNbSCZP\'\n    ),\n    \'#{ITEM_lastCompareTime}\',\n    \'#{AUTHORDEPTID}\',\n    \'#{AUTHOR_USER_INDEX}\',\n    \'#{SUBFORMIDS}\',\n    \'#{INITIATOR}\'\n  ) ON DUPLICATE KEY\nUPDATE APPLICATIONID=\'__DXZvc8mnEmDqMARhK7G\';\nUPDATE baibaodunflow.tlk_escapeman set \n  LASTMODIFIED = \'#{LASTMODIFIED}\',\n  ITEM_policeStatus = \'#{ITEM_policeStatus}\',\n  ITEM_policeInternalAdvice = \'#{ITEM_policeInternalAdvice}\',\n  ITEM_policeExternalAdvice = \'#{ITEM_policeExternalAdvice}\',\n  ITEM_policeSuggestedTreatment = \'#{ITEM_policeSuggestedTreatment}\',\n  ITEM_policeMan = \'#{ITEM_policeMan}\',\n  ITEM_policeOrganization = \'#{ITEM_policeOrganization}\',\n  ITEM_policeTime = \'#{ITEM_policeTime}\'\nWHERE ID=REPLACE (\n      \'#{ID}\',\n      \'__ovMcA0Xv3ZRp8VsCFpM\',\n      \'__nGsPx71jDn3zzNbSCZP\'\n    )', NULL, '
', '智慧保安-在逃人员', '2022-09-13 15:42:58', 'govin-to-public');
INSERT INTO `obpm2_security`.`dynamic_data_map_templates` (`id`, `mapkey`, `template`, `old_template`, `is_online`, `note`, `createdTime`, `region`) VALUES ('3', 'zhihuibaoan-DrugMan', 'INSERT INTO\n  baibaodunflow.tlk_drugman (\n    `PARENT`,\n    `LASTMODIFIED`,\n    `FORMNAME`,\n    `STATE`,\n    `AUDITUSER`,\n    `AUDITDATE`,\n    `AUTHOR`,\n    `AUTHOR_DEPT_INDEX`,\n    `CREATED`,\n    `FORMID`,\n    `ISTMP`,\n    `VERSIONS`,\n    `APPLICATIONID`,\n    `STATEINT`,\n    `STATELABEL`,\n    `AUDITORNAMES`,\n    `LASTFLOWOPERATION`,\n    `LASTMODIFIER`,\n    `DOMAINID`,\n    `AUDITORLIST`,\n    `COAUDITORLIST`,\n    `STATELABELINFO`,\n    `PREVAUDITNODE`,\n    `PREVAUDITUSER`,\n    `OPTIONITEM`,\n    `SIGN`,\n    `KINGGRIDSIGNATURE`,\n    `ITEM_questionType`,\n    `ITEM_documentID`,\n    `ITEM_drugerName`,\n    `ITEM_phone`,\n    `ITEM_companyName`,\n    `ITEM_domain_id`,\n    `ITEM_workStatus`,\n    `ITEM_compareTime`,\n    `ITEM_registerPoliceAddressID`,\n    `ITEM_registerPoliceAddress`,\n    `ITEM_policeStatus`,\n    `ITEM_policeInternalAdvice`,\n    `ITEM_policeExternalAdvice`,\n    `ITEM_policeSuggestedTreatment`,\n    `ITEM_policeMan`,\n    `ITEM_policeOrganization`,\n    `ITEM_policeTime`,\n    `ITEM_companyMan`,\n    `ITEM_companyTime`,\n    `ITEM_companyStatus`,\n    `ITEM_companyTreatment`,\n    `ID`,\n    `ITEM_lastCompareTime`,\n    `AUTHORDEPTID`,\n    `AUTHOR_USER_INDEX`,\n    `SUBFORMIDS`,\n    `INITIATOR`\n  )\nVALUES\n  (\n    \'#{PARENT}\',\n    \'#{LASTMODIFIED}\',\n    \'#{FORMNAME}\',\n    \'#{STATE}\',\n    \'#{AUDITUSER}\',\n    \'#{AUDITDATE}\',\n    \'#{AUTHOR}\',\n    \'#{AUTHOR_DEPT_INDEX}\',\n    \'#{CREATED}\',\n    \'__ayxQHDgCgft8cKU690v\',\n    \'#{ISTMP}\',\n    \'#{VERSIONS}\',\n    \'__DXZvc8mnEmDqMARhK7G\',\n    \'#{STATEINT}\',\n    \'#{STATELABEL}\',\n    \'#{AUDITORNAMES}\',\n    \'#{LASTFLOWOPERATION}\',\n    \'#{LASTMODIFIER}\',\n    \'#{ITEM_domain_id}\',\n    \'#{AUDITORLIST}\',\n    \'#{COAUDITORLIST}\',\n    \'#{STATELABELINFO}\',\n    \'#{PREVAUDITNODE}\',\n    \'#{PREVAUDITUSER}\',\n    \'#{OPTIONITEM}\',\n    \'#{SIGN}\',\n    \'#{KINGGRIDSIGNATURE}\',\n    \'#{ITEM_questionType}\',\n    \'#{ITEM_documentID}\',\n    \'#{ITEM_drugerName}\',\n    \'#{ITEM_phone}\',\n    \'#{ITEM_companyName}\',\n    \'#{ITEM_domain_id}\',\n    \'#{ITEM_workStatus}\',\n    \'#{ITEM_compareTime}\',\n    \'#{ITEM_registerPoliceAddressID}\',\n    \'#{ITEM_registerPoliceAddress}\',\n    \'#{ITEM_policeStatus}\',\n    \'#{ITEM_policeInternalAdvice}\',\n    \'#{ITEM_policeExternalAdvice}\',\n    \'#{ITEM_policeSuggestedTreatment}\',\n    \'#{ITEM_policeMan}\',\n    \'#{ITEM_policeOrganization}\',\n    \'#{ITEM_policeTime}\',\n    \'#{ITEM_companyMan}\',\n    \'#{ITEM_companyTime}\',\n    \'#{ITEM_companyStatus}\',\n    \'#{ITEM_companyTreatment}\',\n    REPLACE (\n      \'#{ID}\',\n      \'__gwmsYV1yeFHTlLPuMzz\',\n      \'__ayxQHDgCgft8cKU690v\'\n    ),\n    \'#{ITEM_lastCompareTime}\',\n    \'#{AUTHORDEPTID}\',\n    \'#{AUTHOR_USER_INDEX}\',\n    \'#{SUBFORMIDS}\',\n    \'#{INITIATOR}\'\n  ) ON DUPLICATE KEY\nUPDATE APPLICATIONID=\'__DXZvc8mnEmDqMARhK7G\';\nUPDATE baibaodunflow.tlk_drugman set \n  LASTMODIFIED = \'#{LASTMODIFIED}\',\n  ITEM_policeStatus = \'#{ITEM_policeStatus}\',\n  ITEM_policeInternalAdvice = \'#{ITEM_policeInternalAdvice}\',\n  ITEM_policeExternalAdvice = \'#{ITEM_policeExternalAdvice}\',\n  ITEM_policeSuggestedTreatment = \'#{ITEM_policeSuggestedTreatment}\',\n  ITEM_policeMan = \'#{ITEM_policeMan}\',\n  ITEM_policeOrganization = \'#{ITEM_policeOrganization}\',\n  ITEM_policeTime = \'#{ITEM_policeTime}\'\nWHERE ID=REPLACE (\n      \'#{ID}\',\n      \'__gwmsYV1yeFHTlLPuMzz\',\n      \'__ayxQHDgCgft8cKU690v\'\n    )', NULL, '
', '智慧保安-吸毒人员', '2022-09-13 15:45:55', 'govin-to-public');
INSERT INTO `obpm2_security`.`dynamic_data_map_templates` (`id`, `mapkey`, `template`, `old_template`, `is_online`, `note`, `createdTime`, `region`) VALUES ('4', 'zhihuibaoan-ImportantInfoError', 'INSERT INTO\n  baibaodunflow.tlk_importantinfoerror (\n    PARENT,\n    LASTMODIFIED,\n    FORMNAME,\n    STATE,\n    AUDITUSER,\n    AUDITDATE,\n    AUTHOR,\n    AUTHOR_DEPT_INDEX,\n    CREATED,\n    FORMID,\n    ISTMP,\n    VERSIONS,\n    APPLICATIONID,\n    STATEINT,\n    STATELABEL,\n    AUDITORNAMES,\n    LASTFLOWOPERATION,\n    LASTMODIFIER,\n    DOMAINID,\n    AUDITORLIST,\n    COAUDITORLIST,\n    STATELABELINFO,\n    PREVAUDITNODE,\n    PREVAUDITUSER,\n    OPTIONITEM,\n    SIGN,\n    KINGGRIDSIGNATURE,\n    ITEM_phone,\n    ITEM_questionType,\n    ITEM_securityName,\n    ITEM_realtimeName,\n    ITEM_documentID,\n    ITEM_realtimeDocumentID,\n    ITEM_companyName,\n    ITEM_domain_id,\n    ITEM_workStatus,\n    ITEM_compareTime,\n    ITEM_registerPoliceAddressID,\n    ITEM_registerPoliceAddress,\n    ITEM_policeStatus,\n    ITEM_policeInternalAdvice,\n    ITEM_policeExternalAdvice,\n    ITEM_policeSuggestedTreatment,\n    ITEM_policeMan,\n    ITEM_policeOrganization,\n    ITEM_policeTime,\n    ITEM_companyMan,\n    ITEM_companyTime,\n    ITEM_companyStatus,\n    ITEM_companyTreatment,\n    ID,\n    AUTHORDEPTID,\n    AUTHOR_USER_INDEX,\n    SUBFORMIDS,\n    INITIATOR\n  )\nVALUES\n  (\n    \'#{PARENT}\',\n    \'#{LASTMODIFIED}\',\n    \'#{FORMNAME}\',\n    \'#{STATE}\',\n    \'#{AUDITUSER}\',\n    \'#{AUDITDATE}\',\n    \'#{AUTHOR}\',\n    \'#{AUTHOR_DEPT_INDEX}\',\n    \'#{CREATED}\',\n    \'__ZOM9gsTgGeHfxRDdeRh\',\n    \'#{ISTMP}\',\n    \'#{VERSIONS}\',\n    \'__DXZvc8mnEmDqMARhK7G\',\n    \'#{STATEINT}\',\n    \'#{STATELABEL}\',\n    \'#{AUDITORNAMES}\',\n    \'#{LASTFLOWOPERATION}\',\n    \'#{LASTMODIFIER}\',\n    \'#{ITEM_domain_id}\',\n    \'#{AUDITORLIST}\',\n    \'#{COAUDITORLIST}\',\n    \'#{STATELABELINFO}\',\n    \'#{PREVAUDITNODE}\',\n    \'#{PREVAUDITUSER}\',\n    \'#{OPTIONITEM}\',\n    \'#{SIGN}\',\n    \'#{KINGGRIDSIGNATURE}\',\n    \'#{ITEM_phone}\',\n    \'#{ITEM_questionType}\',\n    \'#{ITEM_securityName}\',\n    \'#{ITEM_realtimeName}\',\n    \'#{ITEM_documentID}\',\n    \'#{ITEM_realtimeDocumentID}\',\n    \'#{ITEM_companyName}\',\n    \'#{ITEM_domain_id}\',\n    \'#{ITEM_workStatus}\',\n    \'#{ITEM_compareTime}\',\n    \'#{ITEM_registerPoliceAddressID}\',\n    \'#{ITEM_registerPoliceAddress}\',\n    \'#{ITEM_policeStatus}\',\n    \'#{ITEM_policeInternalAdvice}\',\n    \'#{ITEM_policeExternalAdvice}\',\n    \'#{ITEM_policeSuggestedTreatment}\',\n    \'#{ITEM_policeMan}\',\n    \'#{ITEM_policeOrganization}\',\n    \'#{ITEM_policeTime}\',\n    \'#{ITEM_companyMan}\',\n    \'#{ITEM_companyTime}\',\n    \'#{ITEM_companyStatus}\',\n    \'#{ITEM_companyTreatment}\',\n    REPLACE (\n      \'#{ID}\',\n      \'__bbQkMSNNzjUEZj5stQg\',\n      \'__ZOM9gsTgGeHfxRDdeRh\'\n    ),\n    \'#{AUTHORDEPTID}\',\n    \'#{AUTHOR_USER_INDEX}\',\n    \'#{SUBFORMIDS}\',\n    \'#{INITIATOR}\'\n  ) ON DUPLICATE KEY\nUPDATE APPLICATIONID=\'__DXZvc8mnEmDqMARhK7G\';\nUPDATE baibaodunflow.tlk_importantinfoerror set \n  LASTMODIFIED = \'#{LASTMODIFIED}\',\n  ITEM_policeStatus = \'#{ITEM_policeStatus}\',\n  ITEM_policeInternalAdvice = \'#{ITEM_policeInternalAdvice}\',\n  ITEM_policeExternalAdvice = \'#{ITEM_policeExternalAdvice}\',\n  ITEM_policeSuggestedTreatment = \'#{ITEM_policeSuggestedTreatment}\',\n  ITEM_policeMan = \'#{ITEM_policeMan}\',\n  ITEM_policeOrganization = \'#{ITEM_policeOrganization}\',\n  ITEM_policeTime = \'#{ITEM_policeTime}\'\nWHERE ID=REPLACE (\n      \'#{ID}\',\n      \'__bbQkMSNNzjUEZj5stQg\',\n      \'__ZOM9gsTgGeHfxRDdeRh\'\n    )', NULL, '
', '智慧保安-重要信息有误', '2022-09-13 15:47:16', 'govin-to-public');
INSERT INTO `obpm2_security`.`dynamic_data_map_templates` (`id`, `mapkey`, `template`, `old_template`, `is_online`, `note`, `createdTime`, `region`) VALUES ('5', 'jianguan_SendSmsToPolice', 'INSERT INTO\n  baibaodunflow.tlk_SendSmsToPolice (\n    PARENT,\n    LASTMODIFIED,\n    FORMNAME,\n    STATE,\n    AUDITUSER,\n    AUDITDATE,\n    AUTHOR,\n    AUTHOR_DEPT_INDEX,\n    CREATED,\n    FORMID,\n    ISTMP,\n    VERSIONS,\n    APPLICATIONID,\n    STATEINT,\n    STATELABEL,\n    AUDITORNAMES,\n    LASTFLOWOPERATION,\n    LASTMODIFIER,\n    DOMAINID,\n    AUDITORLIST,\n    COAUDITORLIST,\n    STATELABELINFO,\n    PREVAUDITNODE,\n    PREVAUDITUSER,\n    OPTIONITEM,\n    SIGN,\n    KINGGRIDSIGNATURE,\n    ITEM_theme,\n    ITEM_messageContent,\n    ITEM_uploadFile,\n    ITEM_IsReplayFile,\n    ITEM_receiverID,\n    ITEM_messageID,\n    ITEM_toFrom,\n    ITEM_fromMan,\n    ITEM_sendDate,\n    ITEM_departmentName,\n    ITEM_departmentID,\n    ITEM_status,\n    ITEM_IsToAll,\n    ITEM_receiverName,\n    ITEM_replyContent,\n    ITEM_replyFile,\n    ITEM_replyCompany,\n    ITEM_replyStatus,\n    ITEM_readStatus,\n    ITEM_readDate,\n    ITEM_domain_id,\n    ITEM_replyName,\n    ITEM_replyDate,\n    ID,\n    AUTHORDEPTID,\n    AUTHOR_USER_INDEX,\n    SUBFORMIDS,\n    INITIATOR\n  )\nVALUES\n  (\n    \'#{PARENT}\',\n    \'#{LASTMODIFIED}\',\n    \'#{FORMNAME}\',\n    \'#{STATE}\',\n    \'#{AUDITUSER}\',\n    \'#{AUDITDATE}\',\n    \'#{AUTHOR}\',\n    \'#{AUTHOR_DEPT_INDEX}\',\n    \'#{CREATED}\',\n    \'__1s1CEOcmoHo8sZRNEYh\',\n    \'#{ISTMP}\',\n    \'#{VERSIONS}\',\n    \'__DXZvc8mnEmDqMARhK7G\',\n    \'#{STATEINT}\',\n    \'#{STATELABEL}\',\n    \'#{AUDITORNAMES}\',\n    \'#{LASTFLOWOPERATION}\',\n    \'#{LASTMODIFIER}\',\n    \'#{ITEM_domain_id}\',\n    \'#{AUDITORLIST}\',\n    \'#{COAUDITORLIST}\',\n    \'#{STATELABELINFO}\',\n    \'#{PREVAUDITNODE}\',\n    \'#{PREVAUDITUSER}\',\n    \'#{OPTIONITEM}\',\n    \'#{SIGN}\',\n    \'#{KINGGRIDSIGNATURE}\',\n    \'#{ITEM_theme}\',\n    \'#{ITEM_messageContent}\',\n    \'#{ITEM_uploadFile}\',\n    \'#{ITEM_IsReplayFile}\',\n    \'#{ITEM_receiverID}\',\n    \'#{ITEM_messageID}\',\n    \'#{ITEM_toFrom}\',\n    \'#{ITEM_fromMan}\',\n    \'#{ITEM_sendDate}\',\n    \'#{ITEM_departmentName}\',\n    \'#{ITEM_departmentID}\',\n    \'#{ITEM_status}\',\n    \'#{ITEM_IsToAll}\',\n    \'#{ITEM_receiverName}\',\n    \'#{ITEM_replyContent}\',\n    \'#{ITEM_replyFile}\',\n    \'#{ITEM_replyCompany}\',\n    \'#{ITEM_replyStatus}\',\n    \'#{ITEM_readStatus}\',\n    \'#{ITEM_readDate}\',\n    \'#{ITEM_domain_id}\',\n    \'#{ITEM_replyName}\',\n    \'#{ITEM_replyDate}\',\n    \'#{ID}\',\n    \'#{AUTHORDEPTID}\',\n    \'#{AUTHOR_USER_INDEX}\',\n    \'#{SUBFORMIDS}\',\n    \'#{INITIATOR}\'\n  ) ON DUPLICATE KEY\nUPDATE  APPLICATIONID=\'__DXZvc8mnEmDqMARhK7G\';\nUPDATE baibaodunflow.tlk_SendSmsToPolice set\n  LASTMODIFIED = \'#{LASTMODIFIED}\',\n  ITEM_theme = \'#{ITEM_theme}\',\n  ITEM_messageContent = \'#{ITEM_messageContent}\',\n  ITEM_uploadFile = \'#{ITEM_uploadFile}\',\n  ITEM_IsReplayFile = \'#{ITEM_IsReplayFile}\',\n  ITEM_receiverID = \'#{ITEM_receiverID}\',\n  ITEM_messageID = \'#{ITEM_messageID}\',\n  ITEM_toFrom = \'#{ITEM_toFrom}\',\n  ITEM_fromMan = \'#{ITEM_fromMan}\',\n  ITEM_sendDate = \'#{ITEM_sendDate}\',\n  ITEM_departmentName = \'#{ITEM_departmentName}\',\n  ITEM_departmentID = \'#{ITEM_departmentID}\',\n  ITEM_status = \'#{ITEM_status}\',\n  ITEM_IsToAll = \'#{ITEM_IsToAll}\',\n  ITEM_receiverName = \'#{ITEM_receiverName}\',\n  ITEM_domain_id = \'#{ITEM_domain_id}\'\nWHERE ID=\'#{ID}\' and LASTMODIFIED< \'#{LASTMODIFIED}\'', NULL, '
', '保安从业服务展示-公安通知', '2022-09-13 18:09:46', NULL);
INSERT INTO `obpm2_security`.`dynamic_data_map_templates` (`id`, `mapkey`, `template`, `old_template`, `is_online`, `note`, `createdTime`, `region`) VALUES ('6', 'tenant-account-info', ' insert into obpm2.tenant_users (id,authenticated_status,checked_status,created_time,head_photo,im_identity,name,sex,stature,telephone,user_type,selected_credential_id,household_type,one_inch_color_white_photo,two_inch_color_blue_photo,\n			education,marital_status,military_status,nation,native_place,politics_status,cid,last_updated_time,background_screening_status,last_background_screening_time,\n						   third_party_login_no) values(\'#{id}\',\'#{authenticated_status}\',\'#{checked_status}\',\'#{created_time}\',\'#{head_photo}\',\'#{im_identity}\',\'#{name}\',\'#{sex}\',\'#{stature}\',\'#{telephone}\',\'#{user_type}\',\'#{selected_credential_id}\',\'#{household_type}\',\'#{one_inch_color_white_photo}\',\'#{two_inch_color_blue_photo}\',\n			\'#{education}\',\'#{marital_status}\',\'#{military_status}\',\'#{nation}\',\'#{native_place}\',\'#{politics_status}\',\'#{cid}\',\'#{LASTMODIFIED}\',\'#{background_screening_status}\',\'#{last_background_screening_time}\',\'#{third_party_login_no}\') ON DUPLICATE KEY UPDATE last_updated_time=\'#{LASTMODIFIED}\';\n			\n insert into obpm2.tenant_employees (id,created_time,job_number,last_updated_time,leave_note,leave_operator_created_time,leave_operator_id,leave_operator_name,leave_time,master_slave_type,occupation_type,position,salary,salary_bank_number,status,work_place,organization_id,tenant_user_id,unique_offset,department_id,insure,is_domain_admin) values(\'#{employee_id}\',\'#{employee_created_time}\',\'#{employee_job_number}\',\'#{employee_last_updated_time}\',\'#{employee_leave_note}\',\'#{employee_leave_operator_created_time}\',\'#{employee_leave_operator_id}\',\'#{employee_leave_operator_name}\',\'#{employee_leave_time}\',\'#{employee_master_slave_type}\',\'#{employee_occupation_type}\',\'#{employee_position}\',\'#{employee_salary}\',\'#{employee_salary_bank_number}\',\'#{employee_status}\',\'#{employee_work_place}\',\'#{domainid}\',\'#{employee_tenant_user_id}\',\'#{employee_unique_offset}\',\'#{employee_department_id}\',\'#{employee_insure}\',\'#{employee_is_domain_admin}\') ON DUPLICATE KEY UPDATE last_updated_time=\'#{employee_last_updated_time}\';\n \ninsert into obpm2.tenant_department_employee_relations (id,created_time,master_slave_type,department_id,employee_id) values(\'#{department_relations_id}\',\'#{department_relations_created_time}\',\'#{department_relations_master_slave_type}\',\'#{department_relations_department_id}\',\'#{department_relations_employee_id}\')  ON DUPLICATE KEY UPDATE created_time=\'#{department_relations_created_time}\';\n\n insert into obpm2.identity_user (id,created_time,NAME,telephone,tenant_user_id,note) values(\'#{identity_user_id}\',\'#{identity_user_created_time}\',\'#{identity_user_name}\',\'#{identity_user_telephone}\',\'#{identity_user_tenant_user_id}\',\'#{identity_user_note}\') ON DUPLICATE KEY UPDATE NAME=\'#{identity_user_name}\';\n \ninsert into obpm2.identity_principals (id,created_time,last_login_time,last_status_changed_time,last_updated_time,status,identity_user_id) values(\'#{principals_id}\',\'#{principals_created_time}\',\'#{principals_last_login_time}\',\'#{principals_last_status_changed_time}\',\'#{principals_last_updated_time}\',\'#{principals_status}\',\'#{principals_identity_user_id}\') ON DUPLICATE KEY UPDATE identity_user_id=\'#{principals_identity_user_id}\';\n\n insert into obpm2.identity_userpassword (id,algorithm_type,password,user_name) values(\'#{userpassword_id}\',\'#{userpassword_algorithm_type}\',\'#{userpassword_password}\',\'#{userpassword_user_name}\') ON DUPLICATE KEY UPDATE user_name=\'#{userpassword_user_name}\';\n \n  insert into obpm2.t_user (id,DEFAULTDEPARTMENT,LOGINNO,LOGINPWD,NAME,STATUS,DOMAINID,ISDOMAINUSER,ORDERBYNO,FIELD13,\n	PWDTYPE	,TELEPHONEPUBLIC,TELEPHONEPUBLIC2,EMAILPUBLIC,USERINFOPUBLIC,LASTMODIFYTIME) values(\'#{employee_id}\',\'#{employee_department_id}\',\'#{userpassword_user_name}\',\'#{userpassword_password}\',\'#{name}\',\'1\',\'#{domainid}\',\'0\',\'10000\',\'已提交\',\'SM2\',\'1\',\'1\',\'1\',\'1\',\'#{principals_last_updated_time}\')  ON DUPLICATE KEY UPDATE STATUS=1;\n \ninsert into obpm2.t_user_department_role_set (id,DEPARTMENTID,USERID,ROLEID) values(\'#{department_relations_id}\',\'#{department_relations_department_id}\',\'#{employee_id}\',\'__gznw4iZWbPKh114QPN9\')  ON DUPLICATE KEY UPDATE DEPARTMENTID=\'#{department_relations_department_id}\';\ninsert into obpm2.t_user_department_role_set (id,DEPARTMENTID,USERID,ROLEID) values(\'#{department_relations_id}\',\'#{department_relations_department_id}\',\'#{employee_id}\',\'__R5sJSjWmK3ckW0SuQjD\')  ON DUPLICATE KEY UPDATE DEPARTMENTID=\'#{department_relations_department_id}\';\ninsert into obpm2.t_user_department_role_set (id,DEPARTMENTID,USERID,ROLEID) values(\'#{department_relations_id}\',\'#{department_relations_department_id}\',\'#{employee_id}\',\'__F0mxUSlh6l7pdfQMhjM\')  ON DUPLICATE KEY UPDATE DEPARTMENTID=\'#{department_relations_department_id}\';\ninsert into obpm2.t_user_department_role_set (id,DEPARTMENTID,USERID,ROLEID) values(\'#{department_relations_id}\',\'#{department_relations_department_id}\',\'#{employee_id}\',\'__hNnMIoSqyNjLXq4fkKx\')  ON DUPLICATE KEY UPDATE DEPARTMENTID=\'#{department_relations_department_id}\';\ninsert into obpm2.t_user_department_role_set (id,DEPARTMENTID,USERID,ROLEID) values(\'#{department_relations_id}\',\'#{department_relations_department_id}\',\'#{employee_id}\',\'__BmNHuhvjmSsisJqc6ls\')  ON DUPLICATE KEY UPDATE DEPARTMENTID=\'#{department_relations_department_id}\';\ninsert into obpm2.t_user_department_role_set (id,DEPARTMENTID,USERID,ROLEID) values(\'#{department_relations_id}\',\'#{department_relations_department_id}\',\'#{employee_id}\',\'__71i5A1UlQNHntcZOMh3\')  ON DUPLICATE KEY UPDATE DEPARTMENTID=\'#{department_relations_department_id}\';\ninsert into obpm2.t_user_department_role_set (id,DEPARTMENTID,USERID,ROLEID) values(\'#{department_relations_id}\',\'#{department_relations_department_id}\',\'#{employee_id}\',\'__AgNju9oSOdZha4OnnWT\')  ON DUPLICATE KEY UPDATE DEPARTMENTID=\'#{department_relations_department_id}\';\ninsert into obpm2.t_user_department_role_set (id,DEPARTMENTID,USERID,ROLEID) values(\'#{department_relations_id}\',\'#{department_relations_department_id}\',\'#{employee_id}\',\'__Ggz9hoU31YMB6ItkjdZ\')  ON DUPLICATE KEY UPDATE DEPARTMENTID=\'#{department_relations_department_id}\';\ninsert into obpm2.t_user_department_role_set (id,DEPARTMENTID,USERID,ROLEID) values(\'#{department_relations_id}\',\'#{department_relations_department_id}\',\'#{employee_id}\',\'__2x0yQDY9USMnrlwlIgc\')  ON DUPLICATE KEY UPDATE DEPARTMENTID=\'#{department_relations_department_id}\';\ninsert into obpm2.t_user_department_role_set (id,DEPARTMENTID,USERID,ROLEID) values(\'#{department_relations_id}\',\'#{department_relations_department_id}\',\'#{employee_id}\',\'__geu9euXznBvuyr3U8ja\')  ON DUPLICATE KEY UPDATE DEPARTMENTID=\'#{department_relations_department_id}\';', NULL, '
', '公安账号同步到外网-tenant-account-info', '2022-09-14 14:24:12', NULL);
INSERT INTO `obpm2_security`.`dynamic_data_map_templates` (`id`, `mapkey`, `template`, `old_template`, `is_online`, `note`, `createdTime`, `region`) VALUES ('7', 'jianguan_securityman_to_tenant_users', 'UPDATE\n  obpm2.tenant_users\nSET\n  authenticated_status = \'#{authenticated_status}\',\n  authenticated_result = IF(\'#{authenticated_status}\'=\'0\' || \'#{authenticated_status}\'=\'1\',\'\',\'#{authenticated_result}\'),\n  authenticated_time = \'#{authenticated_time}\',\n  background_screening_status = \'#{background_screening_status}\',\n  last_background_screening_time = \'#{last_background_screening_time}\'\nWHERE id=SUBSTRING(\'#{id}\',1,INSTR(\'#{id}\',\'___\')-1)', NULL, '
', '内网保安员信息同步到外网', '2022-09-14 15:32:51', 'govin-to-public');
INSERT INTO `obpm2_security`.`dynamic_data_map_templates` (`id`, `mapkey`, `template`, `old_template`, `is_online`, `note`, `createdTime`, `region`) VALUES ('8', 'jianguan_management', 'INSERT INTO\n  baibaodunflow.tlk_securitymastermanagement (\n    PARENT,\n    LASTMODIFIED,\n    FORMNAME,\n    STATE,\n    AUDITUSER,\n    AUDITDATE,\n    AUTHOR,\n    AUTHOR_DEPT_INDEX,\n    CREATED,\n    FORMID,\n    ISTMP,\n    VERSIONS,\n    APPLICATIONID,\n    STATEINT,\n    STATELABEL,\n    AUDITORNAMES,\n    LASTFLOWOPERATION,\n    LASTMODIFIER,\n    DOMAINID,\n    AUDITORLIST,\n    COAUDITORLIST,\n    STATELABELINFO,\n    PREVAUDITNODE,\n    PREVAUDITUSER,\n    OPTIONITEM,\n    SIGN,\n    KINGGRIDSIGNATURE,\n    ITEM_NAME,\n    ITEM_SEX,\n    ITEM_PHONE,\n    ID,\n    ITEM_SECURITYCOMPANY,\n    ITEM_TRAININGINSTITUTIONS,\n    ITEM_EDUCATION,\n    ITEM_STARTDATE,\n    ITEM_ENDDATE,\n    ITEM_JOB,\n    ITEM_DEGREE,\n    ITEM_CERTIFICATENO,\n    ITEM_CERTIFICATEDATE,\n    ITEM_WORKPLACE,\n    ITEM_ADMISSIONNUMBER,\n    ITEM_THEORETICALSCORE,\n    ITEM_PRACTICALSCORE,\n    ITEM_COMPREHENSIVESCORE,\n    ITEM_DOCUMENTID,\n    AUTHORDEPTID,\n    AUTHOR_USER_INDEX,\n    SUBFORMIDS,\n    INITIATOR,\n    ITEM_JOBTYPEAPTITUDE\n  )\nVALUES\n  (\n    \'#{PARENT}\',\n    \'#{LASTMODIFIED}\',\n    \'#{FORMNAME}\',\n    \'#{STATE}\',\n    \'#{AUDITUSER}\',\n    \'#{AUDITDATE}\',\n    \'#{AUTHOR}\',\n    \'#{AUTHOR_DEPT_INDEX}\',\n    \'#{CREATED}\',\n    \'__aiVYZFCVqeVj0fju94l\',\n    \'#{ISTMP}\',\n    \'#{VERSIONS}\',\n    \'__wGomeHJBz6CpLFCCl4y\',\n    \'#{STATEINT}\',\n    \'#{STATELABEL}\',\n    \'#{AUDITORNAMES}\',\n    \'#{LASTFLOWOPERATION}\',\n    \'#{LASTMODIFIER}\',\n    \'#{DOMAINID}\',\n    \'#{AUDITORLIST}\',\n    \'#{COAUDITORLIST}\',\n    \'#{STATELABELINFO}\',\n    \'#{PREVAUDITNODE}\',\n    \'#{PREVAUDITUSER}\',\n    \'#{OPTIONITEM}\',\n    \'#{SIGN}\',\n    \'#{KINGGRIDSIGNATURE}\',\n    \'#{ITEM_NAME}\',\n    \'#{ITEM_SEX}\',\n    \'#{ITEM_PHONE}\',\n    \'#{ID}\',\n    \'#{ITEM_SECURITYCOMPANY}\',\n    \'#{ITEM_TRAININGINSTITUTIONS}\',\n    \'#{ITEM_EDUCATION}\',\n    \'#{ITEM_STARTDATE}\',\n    \'#{ITEM_ENDDATE}\',\n    \'#{ITEM_JOB}\',\n    \'#{ITEM_DEGREE}\',\n    \'#{ITEM_CERTIFICATENO}\',\n    \'#{ITEM_CERTIFICATEDATE}\',\n    \'#{ITEM_WORKPLACE}\',\n    \'#{ITEM_ADMISSIONNUMBER}\',\n    \'#{ITEM_THEORETICALSCORE}\',\n    \'#{ITEM_PRACTICALSCORE}\',\n    \'#{ITEM_COMPREHENSIVESCORE}\',\n    \'#{ITEM_DOCUMENTID}\',\n    \'#{AUTHORDEPTID}\',\n    \'#{AUTHOR_USER_INDEX}\',\n    \'#{SUBFORMIDS}\',\n    \'#{INITIATOR}\',\n    \'#{ITEM_JOBTYPEAPTITUDE}\'\n  ) ON DUPLICATE KEY\nUPDATE  APPLICATIONID=\'__wGomeHJBz6CpLFCCl4y\';\n\nUPDATE baibaodunflow.tlk_securitymastermanagement set\n  LASTMODIFIED = \'#{LASTMODIFIED}\',\n  ITEM_SECURITYCOMPANY = \'#{ITEM_SECURITYCOMPANY}\',\n  ITEM_TRAININGINSTITUTIONS = \'#{ITEM_TRAININGINSTITUTIONS}\',\n  ITEM_EDUCATION = \'#{ITEM_EDUCATION}\',\n  ITEM_STARTDATE = \'#{ITEM_STARTDATE}\',\n  ITEM_ENDDATE = \'#{ITEM_ENDDATE}\',\n  ITEM_JOB = \'#{ITEM_JOB}\',\n  ITEM_DEGREE = \'#{ITEM_DEGREE}\',\n  ITEM_CERTIFICATENO = \'#{ITEM_CERTIFICATENO}\',\n  ITEM_CERTIFICATEDATE = \'#{ITEM_CERTIFICATEDATE}\',\n  ITEM_WORKPLACE = \'#{ITEM_WORKPLACE}\',\n  ITEM_ADMISSIONNUMBER = \'#{ITEM_ADMISSIONNUMBER}\',\n  ITEM_THEORETICALSCORE = \'#{ITEM_THEORETICALSCORE}\',\n  ITEM_PRACTICALSCORE = \'#{ITEM_PRACTICALSCORE}\',\n  ITEM_COMPREHENSIVESCORE = \'#{ITEM_COMPREHENSIVESCORE}\',\n  ITEM_DOCUMENTID = \'#{ITEM_DOCUMENTID}\',\n  ITEM_JOBTYPEAPTITUDE = \'#{ITEM_JOBTYPEAPTITUDE}\'\nWHERE ID=\'#{ID}\' and LASTMODIFIED< \'#{LASTMODIFIED}\'', NULL, '
', '行业信息-保安师信息', '2022-09-14 17:24:05', NULL);
INSERT INTO `obpm2_security`.`dynamic_data_map_templates` (`id`, `mapkey`, `template`, `old_template`, `is_online`, `note`, `createdTime`, `region`) VALUES ('9', 'mysql_jianguan_tlk_qualify_person_apply', 'UPDATE\n  tms.tlk_qualify_person_apply\nSET\n  LASTMODIFIED = \'#{LASTMODIFIED}\',\n  ITEM_BACKGROUNDSTATUS = \'#{ITEM_BACKGROUNDSTATUS}\',\n  ITEM_APPLYSTATUS = \'#{ITEM_APPLYSTATUS}\'\nWHERE\n  ID = REPLACE (\n    \'#{ID}\',\n    \'__btCmLDlw8qaZvjlKLf4\',\n    \'__3p4Ro0NJIbAnbx6tmEc\'\n  )\n  and ITEM_BACKGROUNDSTATUS = \'5\'', NULL, '
', '背景筛查申诉', '2022-09-14 17:32:12', NULL);
INSERT INTO `obpm2_security`.`dynamic_data_map_templates` (`id`, `mapkey`, `template`, `old_template`, `is_online`, `note`, `createdTime`, `region`) VALUES ('10', 'mysql_jianguan_tlk_grade_card_class', 'UPDATE \n	tms.tlk_grade_card_class\n	set\n	 LASTMODIFIED = \'#{LASTMODIFIED}\',\n	ITEM_classStatus=\'#{ITEM_classStatus}\'\n	WHERE\n  ID = REPLACE (\n    \'#{ID]\',\n    \'__hF7eSn1gbkvtNCKqdZ2\',\n    \'__m9P0IztvBTahDSR5qP0\'\n	)', NULL, '
', '等级班级审核', '2022-09-14 17:32:53', NULL);
INSERT INTO `obpm2_security`.`dynamic_data_map_templates` (`id`, `mapkey`, `template`, `old_template`, `is_online`, `note`, `createdTime`, `region`) VALUES ('11', 'jianguan_setsupervise', 'UPDATE\n  baibaodunflow.tlk_SetSupervise\nset\n  LASTMODIFIED = \'#{LASTMODIFIED}\',\n  ITEM_domain_id = \'#{ITEM_domain_id}\',\n  ITEM_registerAddress = \'#{ITEM_registerAddress}\',\n  ITEM_registerAddressID = \'#{ITEM_registerAddressID}\',\n  ITEM_registerPoliceAddress = \'#{ITEM_registerPoliceAddress}\',\n  ITEM_registerPoliceAddressID = \'#{ITEM_registerPoliceAddressID}\',\n  ITEM_registerPoliceIDIndex = \'#{ITEM_registerPoliceIDIndex}\',\n  ITEM_officeAddress = \'#{ITEM_officeAddress}\',\n  ITEM_officeAddressID = \'#{ITEM_officeAddressID}\',\n  ITEM_officePoliceAddress = \'#{ITEM_officePoliceAddress}\',\n  ITEM_officePoliceAddressID = \'#{ITEM_officePoliceAddressID}\',\n  ITEM_officePoliceIDIndex = \'#{ITEM_officePoliceIDIndex}\'\nWHERE\n  ID = \'#{ID}\'\n  and LASTMODIFIED < \'#{LASTMODIFIED}\'', NULL, '
', '企业信息-监管归属', '2022-09-14 17:34:57', NULL);
INSERT INTO `obpm2_security`.`dynamic_data_map_templates` (`id`, `mapkey`, `template`, `old_template`, `is_online`, `note`, `createdTime`, `region`) VALUES ('12', 'jianguan_company', 'UPDATE\n  baibaodunflow.tlk_CompanyInformation\nset\n  LASTMODIFIED = \'#{LASTMODIFIED}\',\n  ITEM_companyName = \'#{ITEM_companyName}\',\n  ITEM_isSub = \'#{ITEM_isSub}\',\n  ITEM_companyPhone = \'#{ITEM_companyPhone}\',\n  ITEM_companyFax = \'#{ITEM_companyFax}\',\n  ITEM_economicType = \'#{ITEM_economicType}\',\n  ITEM_companyType = \'#{ITEM_companyType}\',\n  ITEM_registerAddress = \'#{ITEM_registerAddress}\',\n  ITEM_officeAddress = \'#{ITEM_officeAddress}\',\n  ITEM_registerAddressDetail = \'#{ITEM_registerAddressDetail}\',\n  ITEM_officeAddressDetail = \'#{ITEM_officeAddressDetail}\',\n  ITEM_companyStatus = \'#{ITEM_companyStatus}\',\n  ITEM_groupName = \'#{ITEM_groupName}\',\n  ITEM_domain_id = \'#{ITEM_domain_id}\',\n  ITEM_groupDocumentType = \'#{ITEM_groupDocumentType}\',\n  ITEM_groupLegalPerson = \'#{ITEM_groupLegalPerson}\',\n  ITEM_groupDocumentNO = \'#{ITEM_groupDocumentNO}\',\n  ITEM_groupPhone = \'#{ITEM_groupPhone}\',\n  ITEM_systemAdmin = \'#{ITEM_systemAdmin}\',\n  ITEM_legalPerson = \'#{ITEM_legalPerson}\',\n  ITEM_legalPersonPhone = \'#{ITEM_legalPersonPhone}\',\n  ITEM_documentType = \'#{ITEM_documentType}\',\n  ITEM_nationality = \'#{ITEM_nationality}\',\n  ITEM_documentID = \'#{ITEM_documentID}\',\n  ITEM_registeredCapital = \'#{ITEM_registeredCapital}\',\n  ITEM_fixedAssets = \'#{ITEM_fixedAssets}\',\n  ITEM_annuaTurnover = \'#{ITEM_annuaTurnover}\',\n  ITEM_profitTaxes = \'#{ITEM_profitTaxes}\',\n  ITEM_registerDocumentType = \'#{ITEM_registerDocumentType}\',\n  ITEM_registerID = \'#{ITEM_registerID}\',\n  ITEM_registerPhoto = \'#{ITEM_registerPhoto}\',\n  ITEM_officeType = \'#{ITEM_officeType}\',\n  ITEM_securityServicePermitNo = \'#{ITEM_securityServicePermitNo}\',\n  ITEM_securityServicePhoto = \'#{ITEM_securityServicePhoto}\',\n  ITEM_issuingSecurityService = \'#{ITEM_issuingSecurityService}\',\n  ITEM_issueServiceDate = \'#{ITEM_issueServiceDate}\',\n  ITEM_businessScope = \'#{ITEM_businessScope}\',\n  ITEM_HRLevel = \'#{ITEM_HRLevel}\',\n  ITEM_armedEscortLevel = \'#{ITEM_armedEscortLevel}\',\n  ITEM_securityPrecautions = \'#{ITEM_securityPrecautions}\',\n  ITEM_isRiskAssessment = \'#{ITEM_isRiskAssessment}\',\n  ITEM_securityTrainPermitNo = \'#{ITEM_securityTrainPermitNo}\',\n  ITEM_securityTrainPhoto = \'#{ITEM_securityTrainPhoto}\',\n  ITEM_issuingTrainPermit = \'#{ITEM_issuingTrainPermit}\',\n  ITEM_issueTrainDate = \'#{ITEM_issueTrainDate}\',\n  ITEM_trainScope = \'#{ITEM_trainScope}\',\n  ITEM_SecurityNums = \'#{ITEM_SecurityNums}\',\n  ITEM_securityGroupLevel = \'#{ITEM_securityGroupLevel}\',\n  ITEM_securityType = \'#{ITEM_securityType}\',\n  ITEM_isInvoivingPlaces = \'#{ITEM_isInvoivingPlaces}\',\n  ITEM_isKeyProtectionUnits = \'#{ITEM_isKeyProtectionUnits}\',\n  ITEM_saas_organId = \'#{ITEM_saas_organId}\',\n  ITEM_saas_LearnId = \'#{ITEM_saas_LearnId}\',\n  ITEM_attendanceSiteType = \'#{ITEM_attendanceSiteType}\',\n  item_companycode = \'#{item_companycode}\'\nWHERE\n  id = \'#{ID}\'\n  and LASTMODIFIED < \'#{LASTMODIFIED}\'', NULL, '
', '行业信息-企业信息', '2022-09-14 17:39:18', NULL);
INSERT INTO `obpm2_security`.`dynamic_data_map_templates` (`id`, `mapkey`, `template`, `old_template`, `is_online`, `note`, `createdTime`, `region`) VALUES ('13', 'zhihui_tlk_securitysevicek', 'UPDATE\n  securitygovernment.tlk_securitysevicecompany\nset\n  ITEM_REJECTREASON = \'#{ITEM_REJECTREASON}\',\n  ITEM_AUDITSTATUS = \'#{ITEM_AUDITSTATUS}\',\n  LASTMODIFIED = \'#{LASTMODIFIED}\',\n  ITEM_domain_id = \'#{ITEM_domain_id}\'\nWHERE\n  id = replace(\n    \'#{id}\',\n    \'__0TXoiEr3uNf7rO0sduB\',\n    \'__AVYis7QN4iLJYRXNGhE\'\n  )', NULL, '
', '保安服务公司许可审批-tlk_SecuritySeviceK', '2022-09-15 09:14:45', NULL);
INSERT INTO `obpm2_security`.`dynamic_data_map_templates` (`id`, `mapkey`, `template`, `old_template`, `is_online`, `note`, `createdTime`, `region`) VALUES ('14', 'pg_tlk_securitytrainings', 'UPDATE\n  securitygovernment.tlk_companypermit\nset\n  ITEM_REJECTREASON = \'#{ITEM_REJECTREASON}\',\n  ITEM_AUDITSTATUS = \'#{ITEM_AUDITSTATUS}\',\n  LASTMODIFIED = \'#{LASTMODIFIED}\',\n  item_domain_id = \'#{item_domain_id}\'\nWHERE\n  id = replace(\n    \'#{id}\',\n    \'__RCOcXGrkJRC4HyyXmrG\',\n    \'__zagjldcIQyPSATrE9me\'\n  )', NULL, '
', '保安培训公司许可证-tlk_SecurityTrainingS', '2022-09-15 09:17:14', NULL);
INSERT INTO `obpm2_security`.`dynamic_data_map_templates` (`id`, `mapkey`, `template`, `old_template`, `is_online`, `note`, `createdTime`, `region`) VALUES ('15', 'zhihuibaoan-Cross', 'UPDATE\n  securitygovernment.tlk_waishengcrossr\nset\n  ITEM_REJECTREASON = \'#{ITEM_REJECTREASON}\',\n  ITEM_auditStatus6 = \'#{ITEM_AUDITSTATUS}\',\n  LASTMODIFIED = \'#{LASTMODIFIED}\',\n  item_domain_id = \'#{item_domain_id}\'\nWHERE\n  id = replace(\n    \'#{id}\',\n    \'__f6KPracyua0kseIfnAf\',\n    \'__6sVq2e7D6SVInCgisRS\'\n  )', NULL, '
', '外省保安跨区服务设立分公司审批-tlk_Crossr', '2022-09-15 09:20:33', NULL);
INSERT INTO `obpm2_security`.`dynamic_data_map_templates` (`id`, `mapkey`, `template`, `old_template`, `is_online`, `note`, `createdTime`, `region`) VALUES ('16', 'zhihuibaoan-Revoke', 'UPDATE\n  securitygovernment.tlk_revoke_record\nset\n  ITEM_REJECTREASON = \'#{ITEM_REJECTREASON}\',\n  ITEM_auditStatus = \'#{ITEM_AUDITSTATUS}\',\n  LASTMODIFIED = \'#{LASTMODIFIED}\',\n  item_domain_id = \'#{item_domain_id}\'\nWHERE\n  id = replace(\n    \'#{id}\',\n    \'__gcUSDii3Y98mCcLM2dD\',\n    \'__05GzdsMQSO1wDQY5L05\'\n  )', NULL, '
', '自行招用保安员单位撤销备案-tlk_Revoke', '2022-09-15 09:22:30', NULL);
INSERT INTO `obpm2_security`.`dynamic_data_map_templates` (`id`, `mapkey`, `template`, `old_template`, `is_online`, `note`, `createdTime`, `region`) VALUES ('17', 'zhihuibaoan-Establish', 'UPDATE\n  securitygovernment.tlk_branchoffice\nset\n  ITEM_REJECTREASON = \'#{ITEM_REJECTREASON}\',\n  ITEM_auditStatus5 = \'#{ITEM_auditStatus}\',\n  LASTMODIFIED = \'#{LASTMODIFIED}\',\n  item_domain_id = \'#{item_domain_id}\'\nWHERE\n  id = replace(\n    \'#{id}\',\n    \'__Cf9cHA3xWKgzDNL80xE\',\n    \'__1jYgutkCLwptfT3zbLW\'\n  )', NULL, '
', '本市保安服务公司设立分公司审批表-tlk_Establish', '2022-09-15 09:24:17', NULL);
INSERT INTO `obpm2_security`.`dynamic_data_map_templates` (`id`, `mapkey`, `template`, `old_template`, `is_online`, `note`, `createdTime`, `region`) VALUES ('18', 'zhihuibaoan-Recruitment', 'UPDATE\n  securitygovernment.tlk_recruitment_record\nset\n  ITEM_REJECTREASON = \'#{ITEM_REJECTREASON}\',\n  ITEM_auditStatus7 = \'#{ITEM_auditStatus}\',\n  LASTMODIFIED = \'#{LASTMODIFIED}\',\n  item_domain_id = \'#{item_domain_id}\'\nWHERE\n  id = replace(\n    \'#{id}\',\n    \'__Kh9sHO1jncg49KqR2MN\',\n    \'__ApIdjDPXF5g3dIg9LMM\'\n  )', NULL, '
', '自行招用保安员单位备案-tlk_Recruitment', '2022-09-15 09:26:10', NULL);
INSERT INTO `obpm2_security`.`dynamic_data_map_templates` (`id`, `mapkey`, `template`, `old_template`, `is_online`, `note`, `createdTime`, `region`) VALUES ('19', 'pg_tlk_LegalChangeK', 'UPDATE\n  securitygovernment.tlk_legalchange_change\nset\n  ITEM_REJECTREASON = \'#{ITEM_REJECTREASON}\',\n  ITEM_auditStatus = \'#{ITEM_auditStatus}\',\n  LASTMODIFIED = \'#{LASTMODIFIED}\',\n  item_domain_id = \'#{item_domain_id}\'\nWHERE\n  id = replace(\n    \'#{id}\',\n    \'__5pbeYTFpNEdQdpDbtG7\',\n    \'__PX0OFiN9BKKt6hjbEy9\'\n  )', NULL, '
', '法人变更-tlk_LegalChangeK', '2022-09-15 09:30:25', NULL);
INSERT INTO `obpm2_security`.`dynamic_data_map_templates` (`id`, `mapkey`, `template`, `old_template`, `is_online`, `note`, `createdTime`, `region`) VALUES ('20', 'pg_tlk_scope_addresschangek', 'UPDATE\n  securitygovernment.tlk_address_change\nset\n  ITEM_REJECTREASON = \'#{ITEM_REJECTREASON}\',\n  ITEM_auditStatus = \'#{ITEM_auditStatus}\',\n  LASTMODIFIED = \'#{LASTMODIFIED}\',\n  item_domain_id = \'#{item_domain_id}\'\nWHERE\n  id = replace(\n    \'#{id}\',\n    \'__8GTBJMfP2hTYSW4DJYE\',\n    \'__Sh4uBAZH4CHpdd2MR9O\'\n  )', NULL, '
', '许可证项目注册地址变更-tlk_scope_addressChangeK', '2022-09-15 09:31:52', NULL);
INSERT INTO `obpm2_security`.`dynamic_data_map_templates` (`id`, `mapkey`, `template`, `old_template`, `is_online`, `note`, `createdTime`, `region`) VALUES ('21', 'pg_tlk_scope_nameChangeS', 'UPDATE\n  securitygovernment.tlk_name_change\nset\n  ITEM_REJECTREASON = \'#{ITEM_REJECTREASON}\',\n  ITEM_auditStatus = \'#{ITEM_auditStatus}\',\n  LASTMODIFIED = \'#{LASTMODIFIED}\',\n  item_domain_id = \'#{item_domain_id}\'\nWHERE\n  id = replace(\n    \'#{id}\',\n    \'__CbTO0EyWWTGhuwwNWug\',\n    \'__vzqcktfgwHTYFqPyqa9\'\n  )', NULL, '
', '项目名称变更-tlk_scope_nameChangeS', '2022-09-15 09:33:44', NULL);
INSERT INTO `obpm2_security`.`dynamic_data_map_templates` (`id`, `mapkey`, `template`, `old_template`, `is_online`, `note`, `createdTime`, `region`) VALUES ('22', 'pg_tlk_ccmoneychangek', 'UPDATE\n  securitygovernment.tlk_ccmoney_change\nset\n  ITEM_REJECTREASON = \'#{ITEM_REJECTREASON}\',\n  ITEM_auditStatus = \'#{ITEM_auditStatus}\',\n  LASTMODIFIED = \'#{LASTMODIFIED}\',\n  item_domain_id = \'#{item_domain_id}\'\nWHERE\n  id = replace(\n    \'#{id}\',\n    \'__jEAcjiYeqCe5UhkKrqM\',\n    \'__gVmdJQrPz9eGpP2xPxr\'\n  )', NULL, '
', '项目注册资金变更-tlk_CCmoneyChangeK', '2022-09-15 09:36:41', NULL);
INSERT INTO `obpm2_security`.`dynamic_data_map_templates` (`id`, `mapkey`, `template`, `old_template`, `is_online`, `note`, `createdTime`, `region`) VALUES ('23', 'pg_tlk_scope_businessk', 'UPDATE\n  securitygovernment.tlk_business_change\nset\n  ITEM_REJECTREASON = \'#{ITEM_REJECTREASON}\',\n  ITEM_auditStatus = \'#{ITEM_auditStatus}\',\n  LASTMODIFIED = \'#{LASTMODIFIED}\',\n  item_domain_id = \'#{item_domain_id}\'\nWHERE\n  id = replace(\n    \'#{id}\',\n    \'__dQ5tzbeRORlWUkk54AI\',\n    \'__nJxSIFSPBQ8OfRvCM0t\'\n  )', NULL, '
', '项目经营范围变更-tlk_scope_businessK', '2022-09-15 09:38:03', NULL);
INSERT INTO `obpm2_security`.`dynamic_data_map_templates` (`id`, `mapkey`, `template`, `old_template`, `is_online`, `note`, `createdTime`, `region`) VALUES ('43', 'jianguan-zhihuibaoan-CompanyInformation', '	update baibaodunflow.TLK_COMPANYINFORMATION set \n  LASTMODIFIED = \'#{LASTMODIFIED}\',\n	ITEM_companyName = \'#{ITEM_companyName}\',\n	ITEM_registerAddress = \'#{ITEM_registerAddress}\',\n	ITEM_registerAddressDetail = \'#{ITEM_registerAddressDetail}\',\n	ITEM_officeAddress = \'#{ITEM_officeAddress}\',\n	ITEM_officeAddressDetail = \'#{ITEM_officeAddressDetail}\',\n	ITEM_companyPhone = \'#{ITEM_companyPhone}\',\n	ITEM_companyFax = \'#{ITEM_companyFax}\',\n	ITEM_economicType = \'#{ITEM_economicType}\',\n	ITEM_companyType = \'#{ITEM_companyType}\',\n	ITEM_isSub = \'#{ITEM_isSub}\',\n	ITEM_groupName = \'#{ITEM_groupName}\',\n	ITEM_groupDocumentType = \'#{ITEM_groupDocumentType}\',\n	ITEM_groupDocumentNO = \'#{ITEM_groupDocumentNO}\',\n	ITEM_groupLegalPerson = \'#{ITEM_groupLegalPerson}\',\n	ITEM_groupPhone = \'#{ITEM_groupPhone}\',\n	ITEM_legalPerson = \'#{ITEM_legalPerson}\',\n	ITEM_documentType = \'#{ITEM_documentType}\',\n	ITEM_documentID = \'#{ITEM_documentID}\',\n	ITEM_nationality = \'#{ITEM_nationality}\',\n	ITEM_legalPersonPhone = \'#{ITEM_legalPersonPhone}\',\n	ITEM_registeredCapital = \'#{ITEM_registeredCapital}\',\n	ITEM_fixedAssets = \'#{ITEM_fixedAssets}\',\n	ITEM_annuaTurnover = \'#{ITEM_annuaTurnover}\',\n	ITEM_profitTaxes = \'#{ITEM_profitTaxes}\',\n	ITEM_registerDocumentType = \'#{ITEM_registerDocumentType}\',\n	ITEM_registerID = \'#{ITEM_registerID}\',\n	ITEM_registerPhoto = \'#{ITEM_registerPhoto}\',\n	ITEM_officeType = \'#{ITEM_officeType}\',\n	ITEM_securityServicePermitNo = \'#{ITEM_securityServicePermitNo}\',\n	ITEM_securityServicePhoto = \'#{ITEM_securityServicePhoto}\',\n	ITEM_issuingSecurityService = \'#{ITEM_issuingSecurityService}\',\n	ITEM_issueServiceDate = \'#{ITEM_issueServiceDate}\',\n	ITEM_businessScope = \'#{ITEM_businessScope}\',\n	ITEM_HRLevel = \'#{ITEM_HRLevel}\',\n	ITEM_armedEscortLevel = \'#{ITEM_armedEscortLevel}\',\n	ITEM_securityPrecautions = \'#{ITEM_securityPrecautions}\',\n	ITEM_isRiskAssessment = \'#{ITEM_isRiskAssessment}\',\n	ITEM_securityTrainPermitNo = \'#{ITEM_securityTrainPermitNo}\',\n	ITEM_securityTrainPhoto = \'#{ITEM_securityTrainPhoto}\',\n	ITEM_issuingTrainPermit = \'#{ITEM_issuingTrainPermit}\',\n	ITEM_issueTrainDate = \'#{ITEM_issueTrainDate}\',\n	ITEM_trainScope = \'#{ITEM_trainScope}\',\n	ITEM_SecurityNums = \'#{ITEM_SecurityNums}\',\n	ITEM_securityGroupLevel = \'#{ITEM_securityGroupLevel}\',\n	ITEM_domain_id = \'#{ITEM_domain_id}\',\n	ITEM_companyStatus = \'#{ITEM_companyStatus}\',\n	ITEM_systemAdmin = \'#{ITEM_systemAdmin}\',\n	ITEM_securityType = \'#{ITEM_securityType}\',\n	ITEM_isInvoivingPlaces = \'#{ITEM_isInvoivingPlaces}\',\n	ITEM_isKeyProtectionUnits = \'#{ITEM_isKeyProtectionUnits}\',\n	ITEM_saas_organId = \'#{ITEM_saas_organId}\',\n	ITEM_saas_LearnId = \'#{ITEM_saas_LearnId}\',\n	ITEM_securityServicePermitN = \'#{ITEM_securityServicePermitN}\',\n	ITEM_yin01 = \'#{ITEM_yin01}\',\n	ITEM_yin02 = \'#{ITEM_yin02}\',\n	ITEM_yin03 = \'#{ITEM_yin03}\',\n	ITEM_yin04 = \'#{ITEM_yin04}\',\n	ITEM_attendanceSiteType = \'#{ITEM_attendanceSiteType}\',\n	item_inmycompanyNums = \'#{item_inmycompanyNums}\',\n	item_stationNum = \'#{item_stationNum}\',\n	item_securityTeacherNum = \'#{item_securityTeacherNum}\',\n	item_shareholderNum = \'#{item_shareholderNum}\',\n	ITEM_place_of_register_province_code = \'#{ITEM_place_of_register_province_code}\',\n	ITEM_place_of_business_province_code = \'#{ITEM_place_of_business_province_code}\',\n	ITEM_place_of_register_city_code = \'#{ITEM_place_of_register_city_code}\',\n	ITEM_place_of_business_city_code = \'#{ITEM_place_of_business_city_code}\',\n	ITEM_place_of_register_district_code = \'#{ITEM_place_of_register_district_code}\',\n	ITEM_place_of_business_district_code = \'#{ITEM_place_of_business_district_code}\',\n	item_companycode = \'#{item_companycode}\',\n	ITEM_securityNum = \'#{ITEM_securityNum}\'\n  where id=\'#{id}\' and LASTMODIFIED<\'#{LASTMODIFIED}\';', NULL, '
', '监管-行业信息查询-单位信息', '2022-09-16 09:29:32', NULL);
INSERT INTO `obpm2_security`.`dynamic_data_map_templates` (`id`, `mapkey`, `template`, `old_template`, `is_online`, `note`, `createdTime`, `region`) VALUES ('44', 'mysql_jianguan_tlk_grade_registration', 'UPDATE\n  tms.tlk_grade_registration\nSET\n  LASTMODIFIED = \'#{LASTMODIFIED}\',\n  ITEM_BACKGROUNDSTATUS = \'#{ITEM_BACKGROUNDSTATUS}\',\n  ITEM_APPLYSTATUS = \'#{ITEM_APPLYSTATUS}\'\nWHERE\n  ID = REPLACE (\n    \'#{ID]\',\n    \'__c5LTCeEmS52OWaNZpdZ\',\n    \'__4xps3fR1UmijuSMS7as\'\n  )\n  and ITEM_BACKGROUNDSTATUS =\'5\'', NULL, '
', '等级证背景筛查', '2022-09-20 14:15:09', NULL);
INSERT INTO `obpm2_security`.`dynamic_data_map_templates` (`id`, `mapkey`, `template`, `old_template`, `is_online`, `note`, `createdTime`, `region`) VALUES ('45', 'tenant-department', 'INSERT INTO `obpm2`.`tenant_departments`(`id`, `code`, `created_time`, `display_order`, `index_tree`, `last_updated_time`, `level`, `name`, `permission_config`, `permission_type`, `status`, `total_member`, `organization_id`, `parent_id`, `is_deleted`) VALUES (\'#{id}\', \'#{code}\',  \'#{created_time}\', \'#{display_order}\', \'#{index_tree}\', \'#{LASTMODIFIED}\', \'#{level}\', \'#{name}\', \'#{permission_config}\', \'#{permission_type}\', \'#{status}\', 0, \'#{organization_id}\', \'#{parent_id}\', \'0\') ON DUPLICATE KEY UPDATE display_order=\'#{display_order}\';\n', NULL, '
', '内网同步部门信息到互联网', '2022-10-09 17:17:43', NULL);