insert into  #{dynamic_securityFlow}.tlk_securityman (
          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,
          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
          )VALUES(
          '#{id}','__qFCcCnozYNwzoG3O6Ms','#{created_time}','#{LASTMODIFIED}','#{dynamic_domain_id}','#{one_inch_color_white_photo}','#{leave_date}','#{depart_id}','#{telephone}',
          '#{job_type}','#{depart_name}','#{tenant_user_id}','#{name}',ifnull('#{is_in_mycompany}',0),'#{company_name}','#{is_certified}','#{last_auth_time}','#{credential_type}',
          '#{credential_number}',ifnull('#{hired_date}','1990-01-01'),'#{domain_id}',
          IFNULL('#{insure}','0'),'#{birth_date}','#{sex}','#{nationality}','#{education}','#{stature}','无','#{nation}','#{politics_status}','#{marital_status}','#{home_address}',
          '#{household_type}','#{emergency_contact}','#{emergency_phone}','#{license_level}','#{is_veteran}','#{work_years}','#{disease_history}',
          '#{id_face_photo}','#{id_nation_photo}','#{id_validation_s}','#{id_validation_e}','#{id_address}','#{id_header_photo}','#{shi_ming}',NULL,

          (select ITEM_registerPoliceIDIndex from tlk_setsupervise e where ITEM_DOMAIN_ID='#{domain_id}' limit 1)
          )ON DUPLICATE KEY UPDATE item_pirture='#{one_inch_color_white_photo}',item_leavedate='#{leave_date}',item_deptid='#{depart_id}',item_phone='#{telephone}',
          item_jobtype='#{job_type}',item_deptname='#{depart_name}',item_userid='#{tenant_user_id}',item_securityname='#{name}',item_isinmycompany=ifnull('#{is_in_mycompany}',0),
          item_companyname='#{company_name}',item_iscertified='#{is_certified}',item_lastauthtime='#{last_auth_time}',item_documenttype='#{credential_type}',item_documentid='#{credential_number}',
          item_entrydate=ifnull('#{hired_date}','1990-01-01'),item_domain_id='#{domain_id}',item_insure=IFNULL('#{insure}','0'),item_birthdate='#{birth_date}',item_sex='#{sex}',item_nationality='#{nationality}',
          item_education='#{education}',item_height='#{stature}',item_bloodtype='无',item_nation='#{nation}',item_politicaloutlook='#{politics_status}',item_maritalstatus='#{marital_status}',
          item_homeaddress='#{home_address}',item_householdtype='#{household_type}',item_emergencycontact='#{emergency_contact}',item_emergencyphone='#{emergency_phone}',
          item_licenselevel='#{license_level}',item_isveteran='#{is_veteran}',item_workyears='#{work_years}',item_diseasehistory='#{disease_history}',item_idfacephoto='#{id_face_photo}',
          item_idnationphoto='#{id_nation_photo}',
          item_idvalidations='#{id_validation_s}',item_idvalidatione='#{id_validation_e}',item_idaddress='#{id_address}',item_headphoto='#{id_header_photo}',
          item_registerpoliceidindex=(select ITEM_registerPoliceIDIndex from tlk_setsupervise e where ITEM_DOMAIN_ID='#{domain_id}' limit 1);
		  UPDATE tlk_securityman set ITEM_shiming='#{shi_ming}' WHERE ID='#{id}' and ITEM_shiming !='已认证';