INSERT INTO #{dynamic_securityFlow}.`tlk_attendance_site_base_info`(`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_COMPANYNAME`, `ITEM_ATTENDANCESITENAME`, `ITEM_ATTENDANCESITETYPE`, `ITEM_ATTENDANCESITECONTENT`, `ITEM_ATTENDANCESITEADDRESS`, `ITEM_ATTENDANCESITEFULLADDRESS`, `ITEM_ATTENDANCESITELONGITUDE`, `ITEM_ATTENDANCESITELATITUDE`, `ITEM_PERFORMRANGE`, `ITEM_OFFICEPOLICEADDRESS`, `ITEM_OFFICEPOLICEADDRESSID`, `ITEM_OFFICEPOLICEIDINDEX`, `ITEM_ATTENDANCESTARTDATE`, `ITEM_ATTENDANCEENDDATE`, `ITEM_ATTENDANCESITESTATE`, `ITEM_PRINCIPAL`, `ITEM_PRINCIPALNAME`, `ITEM_PRINCIPALCARDTYPE`, `ITEM_PRINCIPALIDCARDNO`, `ITEM_PRINCIPALPHONENO`, `ITEM_PRINCIPALISCERTIFIED`, `ITEM_SERVEOBJECTNAME`, `ITEM_SERVEOBJECTTYPE`, `ITEM_ISSIGNIFICANCEUNIT`, `ITEM_CONTRACTNAME`, `ITEM_CONTRACTSTATE`, `ITEM_CONTRACTSTARTDATE`, `ITEM_CONTRACTENDDATE`, `ID`, `ITEM_DOMAIN_ID`, `ITEM_CONTRACTFILE`, `ITEM_CONTRACTID`, `ITEM_SAAS_ID`, `ITEM_ISDELETED`, `AUTHORDEPTID`, `AUTHOR_USER_INDEX`, `SUBFORMIDS`, `INITIATOR`) VALUES (NULL, '#{LASTMODIFIED}', '#{FORMNAME}', NULL, NULL, NULL, NULL, NULL, '#{CREATED}', '__FVtTPfYykKzjUnhykwN', 0, 1, '__wGomeHJBz6CpLFCCl4y', 0, '', '', NULL, NULL, '#{dynamic_domain_id}', '{}', '{}', '[{\"nodes\":[{\"nodeId\":\"\",\"stateLabel\":\"\",\"state\":\"\",\"auditors\":[],\"coAuditors\":[]}]}]', NULL, NULL, 
NULL, NULL, NULL, 
'#{ITEM_COMPANYNAME}', '#{ITEM_ATTENDANCESITENAME}', '#{ITEM_ATTENDANCESITETYPE}', '#{ITEM_ATTENDANCESITECONTENT}', '#{ITEM_ATTENDANCESITEADDRESS}', '#{ITEM_ATTENDANCESITEFULLADDRESS}', '#{ITEM_ATTENDANCESITELONGITUDE}', '#{ITEM_ATTENDANCESITELATITUDE}', '#{ITEM_PERFORMRANGE}', '#{ITEM_OFFICEPOLICEADDRESS}', '#{ITEM_OFFICEPOLICEADDRESSID}', '#{ITEM_OFFICEPOLICEIDINDEX}', '#{ITEM_ATTENDANCESTARTDATE}', '#{ITEM_ATTENDANCEENDDATE}', '#{ITEM_ATTENDANCESITESTATE}', '#{ITEM_PRINCIPAL}', '#{ITEM_PRINCIPALNAME}', '#{ITEM_PRINCIPALCARDTYPE}', '#{ITEM_PRINCIPALIDCARDNO}', '#{ITEM_PRINCIPALPHONENO}', '#{ITEM_PRINCIPALISCERTIFIED}', '#{ITEM_SERVEOBJECTNAME}', '#{ITEM_SERVEOBJECTTYPE}', '#{ITEM_ISSIGNIFICANCEUNIT}', '#{ITEM_CONTRACTNAME}', '#{ITEM_CONTRACTSTATE}', '#{ITEM_CONTRACTSTARTDATE}', '#{ITEM_CONTRACTENDDATE}',replace('#{ID}','__W052b1XNoLmPckF6ch1','__FVtTPfYykKzjUnhykwN'), '#{DOMAINID}', '#{ITEM_CONTRACTFILE}', '#{ITEM_CONTRACTID}', '#{ITEM_SAAS_ID}', '#{ITEM_ISDELETED}', '#{AUTHORDEPTID}', '$$$test', NULL, NULL)ON DUPLICATE KEY UPDATE `ITEM_COMPANYNAME`='#{ITEM_COMPANYNAME}', `ITEM_ATTENDANCESITENAME`='#{ITEM_ATTENDANCESITENAME}', `ITEM_ATTENDANCESITETYPE`='#{ITEM_ATTENDANCESITETYPE}', `ITEM_ATTENDANCESITECONTENT`='#{ITEM_ATTENDANCESITECONTENT}', `ITEM_ATTENDANCESITEADDRESS`='#{ITEM_ATTENDANCESITEADDRESS}', `ITEM_ATTENDANCESITEFULLADDRESS`='#{ITEM_ATTENDANCESITEFULLADDRESS}', `ITEM_ATTENDANCESITELONGITUDE`='#{ITEM_ATTENDANCESITELONGITUDE}', `ITEM_ATTENDANCESITELATITUDE`='#{ITEM_ATTENDANCESITELATITUDE}', `ITEM_PERFORMRANGE`='#{ITEM_PERFORMRANGE}', `ITEM_OFFICEPOLICEADDRESS`='#{ITEM_OFFICEPOLICEADDRESS}', `ITEM_OFFICEPOLICEADDRESSID`='#{ITEM_OFFICEPOLICEADDRESSID}', `ITEM_OFFICEPOLICEIDINDEX`='#{ITEM_OFFICEPOLICEIDINDEX}', `ITEM_ATTENDANCESTARTDATE`='#{ITEM_ATTENDANCESTARTDATE}', `ITEM_ATTENDANCEENDDATE`='#{ITEM_ATTENDANCEENDDATE}', `ITEM_ATTENDANCESITESTATE`='#{ITEM_ATTENDANCESITESTATE}', `ITEM_PRINCIPAL`='#{ITEM_PRINCIPAL}', `ITEM_PRINCIPALNAME`='#{ITEM_PRINCIPALNAME}', `ITEM_PRINCIPALCARDTYPE`='#{ITEM_PRINCIPALCARDTYPE}', `ITEM_PRINCIPALIDCARDNO`='#{ITEM_PRINCIPALIDCARDNO}', `ITEM_PRINCIPALPHONENO`='#{ITEM_PRINCIPALPHONENO}', `ITEM_PRINCIPALISCERTIFIED`='#{ITEM_PRINCIPALISCERTIFIED}', `ITEM_SERVEOBJECTNAME`='#{ITEM_SERVEOBJECTNAME}', `ITEM_SERVEOBJECTTYPE`='#{ITEM_SERVEOBJECTTYPE}', `ITEM_ISSIGNIFICANCEUNIT`='#{ITEM_ISSIGNIFICANCEUNIT}', `ITEM_CONTRACTNAME`='#{ITEM_CONTRACTNAME}', `ITEM_CONTRACTSTATE`='#{ITEM_CONTRACTSTATE}', `ITEM_CONTRACTSTARTDATE`='#{ITEM_CONTRACTSTARTDATE}', `ITEM_CONTRACTENDDATE`='#{ITEM_CONTRACTENDDATE}', `ITEM_CONTRACTFILE`='#{ITEM_CONTRACTFILE}', `ITEM_CONTRACTID`='#{ITEM_CONTRACTID}', `ITEM_SAAS_ID`='#{ITEM_SAAS_ID}', `ITEM_ISDELETED`='#{ITEM_ISDELETED}',LASTMODIFIED='#{LASTMODIFIED}';
