INSERT INTO `obpm2`.`dynamic_data_map_templates` (`id`, `mapkey`, `template`, `old_template`, `is_online`, `note`, `createdTime`) VALUES ('14', 'tenant-app-securityman', 'insert into tlk_securityman (\n          id,formid,created,LASTMODIFIED,domainid,item_pirture,item_leavedate,item_deptid,item_phone,item_jobtype,item_deptname,item_userid,item_securityname,item_isinmycompany,item_companyname,item_iscertified,item_lastauthtime,item_documenttype,item_documentid,item_entrydate,item_domain_id,item_insure,item_birthdate,item_sex,item_nationality,item_education,item_height,item_bloodtype,item_nation,item_politicaloutlook,\n          item_maritalstatus,item_homeaddress,item_householdtype,item_emergencycontact,item_emergencyphone,item_licenselevel,item_isveteran,item_workyears,item_diseasehistory,item_idfacephoto,item_idnationphoto,item_idvalidations,item_idvalidatione,item_idaddress,item_headphoto,item_shiming,item_beizhu,item_registerpoliceidindex\n          )VALUES(\n          \'#{id}\',\'__qFCcCnozYNwzoG3O6Ms\',\'#{created_time}\',\'#{LASTMODIFIED}\',\'#{dynamic_domain_id}\',\'#{one_inch_color_white_photo}\',\'#{leave_date}\',\'#{depart_id}\',\'#{telephone}\',\n          \'#{job_type}\',\'#{depart_name}\',\'#{tenant_user_id}\',\'#{name}\',\'#{is_in_mycompany}\',\'#{company_name}\',\'#{is_certified}\',\'#{last_auth_time}\',\'#{credential_type}\',\n          \'#{credential_number}\',\'#{hired_date}\',\'#{domain_id}\',\n          \'#{insure}\',\'#{birth_date}\',\'#{sex}\',\'#{nationality}\',\'#{education}\',\'#{stature}\',\'无\',\'#{nation}\',\'#{politics_status}\',\'#{marital_status}\',\'#{home_address}\',\n          \'#{household_type}\',\'#{emergency_contact}\',\'#{emergency_phone}\',\'#{license_level}\',\'#{is_veteran}\',\'#{work_years}\',\'#{disease_history}\',\n          \'#{id_face_photo}\',\'#{id_nation_photo}\',\'#{id_validation_s}\',\'#{id_validation_e}\',\'#{id_address}\',\'#{id_header_photo}\',\'#{shi_ming}\',NULL,\n\n          (select ITEM_registerPoliceIDIndex from tlk_setsupervise e where ITEM_DOMAIN_ID=\'#{domain_id}\' limit 1)\n          )ON DUPLICATE KEY UPDATE item_pirture=\'#{one_inch_color_white_photo}\',item_leavedate=\'#{leave_date}\',item_deptid=\'#{depart_id}\',item_phone=\'#{telephone}\',\n          item_jobtype=\'#{job_type}\',item_deptname=\'#{depart_name}\',item_userid=\'#{tenant_user_id}\',item_securityname=\'#{name}\',item_isinmycompany=\'#{is_in_mycompany}\',\n          item_companyname=\'#{company_name}\',item_iscertified=\'#{is_certified}\',item_lastauthtime=\'#{last_auth_time}\',item_documenttype=\'#{credential_type}\',item_documentid=\'#{credential_number}\',\n          item_entrydate=\'#{hired_date}\',item_domain_id=\'#{domain_id}\',item_insure=\'#{insure}\',item_birthdate=\'#{birth_date}\',item_sex=\'#{sex}\',item_nationality=\'#{nationality}\',\n          item_education=\'#{education}\',item_height=\'#{stature}\',item_bloodtype=\'无\',item_nation=\'#{nation}\',item_politicaloutlook=\'#{politics_status}\',item_maritalstatus=\'#{marital_status}\',\n          item_homeaddress=\'#{home_address}\',item_householdtype=\'#{household_type}\',item_emergencycontact=\'#{emergency_contact}\',item_emergencyphone=\'#{emergency_phone}\',\n          item_licenselevel=\'#{license_level}\',item_isveteran=\'#{is_veteran}\',item_workyears=\'#{work_years}\',item_diseasehistory=\'#{disease_history}\',item_idfacephoto=\'#{id_face_photo}\',\n          item_idnationphoto=\'#{id_nation_photo}\',\n          item_idvalidations=\'#{id_validation_s}\',item_idvalidatione=\'#{id_validation_e}\',item_idaddress=\'#{id_address}\',item_headphoto=\'#{id_header_photo}\',\n          item_registerpoliceidindex=(select ITEM_registerPoliceIDIndex from tlk_setsupervise e where ITEM_DOMAIN_ID=\'#{domain_id}\' limit 1)', NULL, '', '保安员信息', '2022-08-31 15:15:34');