DELETE FROM t_hrcs_msgpublisher WHERE FID = 1335553746759046144;
INSERT INTO t_hrcs_msgpublisher(FISSYSPRESET,FSUBSTATUS,FDESCRIPTION,FMASTERID,FPUBLISHBDID,FPUBERID,FCREATETIME,FOFFLINEDATE,FENABLE,FACTIONCLOUD,FISSUBSCRIBE,FPUBLISHDATE,FDISABLERID,FID,FMSGPROBOID,FDISABLEDATE,FSIMPLENAME,FSTATUS,FUSESTATUS,FMSGPUBNO,FNUMBER,FNAME,FINDEX,FACTIONID,FMSGTAG,FMODIFIERID,FMODIFYTIME,FACTIONTYPEID,FACTIONAPP,FCREATORID,FPUBSTATUS) VALUES ('0','1','确认入职消息',1335553746759046144,1010,1270951057564008448,{ts'2022-01-17  00:00:00'},NULL,'1','11FWSEDXBS99','2',{ts'2022-02-21  00:00:00'},0,1335553746759046144,0,NULL,' ','C','A','MP20220117000056','MP20220117000056','确认入职',0,101010,' ',1270951057564008448,{ts'2022-02-21  00:00:00'},101010,'1WXB5G9/BL46',1250694749896102912,'P'); 

DELETE FROM t_hrcs_msgpublisher_l WHERE FPKID = '260HG=MG+LLK';
INSERT INTO t_hrcs_msgpublisher_l(FID,FPKID,FLOCALEID,FMSGTAG,FSIMPLENAME,FDESCRIPTION,FNAME) VALUES (1335553746759046144,'260HG=MG+LLK','zh_CN',' ',' ','确认入职消息','确认入职'); 


DELETE FROM t_hrcs_msgpublishapi WHERE FPUBAPIID = 1341906381959166976;
INSERT INTO t_hrcs_msgpublishapi(FID,FPUBAPIID,FAPIPUBSTATUS,FAPIPUBSERVICE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FOUTPUTPARAM,FNAME,FNUMBER,FAPISOURCEID,FENABLE,FOUTPUTTYPE,FAPIPUBCLOUDID,FAPIPUBAPPID,FSEQ,FAPIPUBMETHOD,FAPIPUBERID,FAPINO,FAPITYPE,FPARAMS) VALUES (1335553746759046144,1341906381959166976,'P','IHRCSMsgService','0',' ',' ',' ','人事事务变动-人员查询','API20220125000051',1341359774121351168,'B',' ','0PEIU203SX4Y','0QO140ANVBBZ',1,'getDataBySub',1270951057564008448,' ','1','{"person":"人员","cmpemp":"所属管理范围","boid":"业务id","employee":"企业人员"}'); 
DELETE FROM t_hrcs_msgpublishapi WHERE FPUBAPIID = 1341906381959166977;
INSERT INTO t_hrcs_msgpublishapi(FID,FPUBAPIID,FAPIPUBSTATUS,FAPIPUBSERVICE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FOUTPUTPARAM,FNAME,FNUMBER,FAPISOURCEID,FENABLE,FOUTPUTTYPE,FAPIPUBCLOUDID,FAPIPUBAPPID,FSEQ,FAPIPUBMETHOD,FAPIPUBERID,FAPINO,FAPITYPE,FPARAMS) VALUES (1335553746759046144,1341906381959166977,'P','IHRPIEmployeeService','0','[{"type":"java.lang.Long","key":"employeeId"},{"type":"java.lang.String","default":"hrpi_trialperiod","key":"attachEntityName"}]',' ','{"data":{"bsled":"java.util.Date","realregulardate":"java.util.Date","bred":"java.util.Date","boid":"java.lang.Long","trialperiodrst_id":"java.lang.Long","startdate":"java.util.Date","probationunit":"java.lang.String","regcategory":"java.lang.String","preregulardate":"java.util.Date","number":"java.lang.String","sourcevid":"java.lang.Long","probation":"java.lang.Integer","changebsed":"java.util.Date","firstbsed":"java.util.Date","entrydate":"java.util.Date","id":"long","bsed":"java.util.Date","examscore":"java.math.BigDecimal","person_id":"java.lang.Long","brfd":"java.util.Date","brled":"java.util.Date","businessstatus":"java.lang.String","sysenddate":"java.util.Date","examstatus":"java.lang.String","datastatus":"java.lang.String","enddate":"java.util.Date","ismodify":"java.lang.String","employee_id":"java.lang.Long","regcomment":"java.lang.String","regstatus":"java.lang.String"},"resultType":"java.util.List"}','人事事务变动-试用信息','API20220126000065',1341892060726262784,'B','java.util.List','0PEIU203SX4Y','0QO140ANVBBZ',2,'listEmployeeAttachs',1270951057564008448,' ','2',' '); 
DELETE FROM t_hrcs_msgpublishapi WHERE FPUBAPIID = 1353615310569227267;
/* 开发页面那里生成的SQL有问题，缺少字段-出参结构的内容
INSERT INTO t_hrcs_msgpublishapi(FID,FPUBAPIID,FAPIPUBSTATUS,FAPIPUBSERVICE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FOUTPUTPARAM,FNAME,FNUMBER,FAPISOURCEID,FENABLE,FOUTPUTTYPE,FAPIPUBCLOUDID,FAPIPUBAPPID,FSEQ,FAPIPUBMETHOD,FAPIPUBERID,FAPINO,FAPITYPE,FPARAMS) VALUES (1335553746759046144,1353615310569227267,'P','IHRPIPersonService','0','[{"type":"java.lang.Long","key":"personId"},{"type":"java.lang.String","default":"hrpi_pernontsprop","key":"attachEntityName"}]',' ',' ','人事事务变动-非时序属性','API20220210000074',1352938855451472896,'B','java.util.List','0PEIU203SX4Y','0QO140ANVBBZ',6,'listPersonAttachs',1150721201652407296,' ','2',' '); 
*/
INSERT INTO t_hrcs_msgpublishapi(fid, fpubapiid, fseq, fissyspreset, fenable, fapipubstatus, fapipuberid, fapino, fapisourceid, fname, fdescription, fapipubservice, fapipubmethod, fapitype, fnumber, fapipubcloudid, fapipubappid, fparams, foutputtype, foutputparam, finputparam)
VALUES(1335553746759046144, 1353615310569227267, 6, '0', 'A', 'P', 1270951057564008448, ' ', 1352938855451472896, '人事事务变动-非时序属性', ' ', 'IHRPIPersonService', 'listPersonAttachs', '2', 'API20220210000074', '0PEIU203SX4Y', '0QO140ANVBBZ', ' ', 'java.util.List', '{"data":{"birthday":"java.util.Date","boid":"java.lang.Long","nationality_id":"java.lang.Long","nativelngname":"java.lang.String","nameen":"java.lang.String","deathdate":"java.util.Date","title":"java.lang.String","sourcevid":"java.lang.Long","bloodtype":"java.lang.String","lunarcalendarbirthday":"java.util.Date","beginservicedate":"java.util.Date","id":"long","headsculpture":"java.lang.String","julianbirthday":"java.util.Date","height":"java.lang.Integer","person_id":"java.lang.Long","symbolicanimals_id":"java.lang.Long","birthdaytype":"java.lang.String","datastatus":"java.lang.String","gender_id":"java.lang.Long","marriageregistdate":"java.util.Date","constellation_id":"java.lang.Long","enname":"java.lang.String","entservicelen":"java.math.BigDecimal","servicelen":"java.math.BigDecimal","nativename":"java.lang.String","formername":"java.lang.String","ismodify":"java.lang.String","displayname":"java.lang.String","name":"java.lang.String","folk_id":"java.lang.Long","age":"java.lang.Integer"},"resultType":"java.util.List"}', '[{"type":"java.lang.Long","key":"personId"},{"type":"java.lang.String","default":"hrpi_pernontsprop","key":"attachEntityName"}]');

DELETE FROM t_hrcs_msgpublishapi WHERE FPUBAPIID = 1353615310569227268;
INSERT INTO t_hrcs_msgpublishapi(FID,FPUBAPIID,FAPIPUBSTATUS,FAPIPUBSERVICE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FOUTPUTPARAM,FNAME,FNUMBER,FAPISOURCEID,FENABLE,FOUTPUTTYPE,FAPIPUBCLOUDID,FAPIPUBAPPID,FSEQ,FAPIPUBMETHOD,FAPIPUBERID,FAPINO,FAPITYPE,FPARAMS) VALUES (1335553746759046144,1353615310569227268,'P','IHRPIPersonService','0','[{"type":"java.lang.Long","key":"personId"},{"type":"java.lang.String","default":"hrpi_pertsprop","key":"attachEntityName"}]',' ','{"data":{"brfd":"java.util.Date","bsled":"java.util.Date","brled":"java.util.Date","bred":"java.util.Date","healthstatus_id":"java.lang.Long","boid":"java.lang.Long","marriagestatus_id":"java.lang.Long","procreatstatus_id":"java.lang.Long","datastatus":"java.lang.String","sourcevid":"java.lang.Long","changebsed":"java.util.Date","firstbsed":"java.util.Date","childrennumber":"java.lang.Integer","ismodify":"java.lang.String","id":"long","bsed":"java.util.Date","person_id":"java.lang.Long"},"resultType":"java.util.List"}','人事事务变动-时序属性','API20220210000075',1352940460947158016,'B','java.util.List','0PEIU203SX4Y','0QO140ANVBBZ',7,'listPersonAttachs',1150721201652407296,' ','2',' '); 
DELETE FROM t_hrcs_msgpublishapi WHERE FPUBAPIID = 1353615310569227266;
INSERT INTO t_hrcs_msgpublishapi(FID,FPUBAPIID,FAPIPUBSTATUS,FAPIPUBSERVICE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FOUTPUTPARAM,FNAME,FNUMBER,FAPISOURCEID,FENABLE,FOUTPUTTYPE,FAPIPUBCLOUDID,FAPIPUBAPPID,FSEQ,FAPIPUBMETHOD,FAPIPUBERID,FAPINO,FAPITYPE,FPARAMS) VALUES (1335553746759046144,1353615310569227266,'P','IHRPIPersonService','0','[{"type":"java.lang.Long","key":"personId"},{"type":"java.lang.String","default":"hrpi_perprotitle","key":"attachEntityName"}]',' ','{"data":{"firsttime":"java.util.Date","prolevel_id":"java.lang.Long","certiicateid":"java.lang.String","boid":"java.lang.Long","approvnum":"java.lang.String","office":"java.lang.String","datastatus":"java.lang.String","iscompany":"java.lang.Boolean","professional_id":"java.lang.Long","sourcevid":"java.lang.Long","unit":"java.lang.String","secondtime":"java.util.Date","ismodify":"java.lang.String","details":"java.lang.String","id":"long","awardtime":"java.util.Date","ishigh":"java.lang.Boolean","person_id":"java.lang.Long"},"resultType":"java.util.List"}','人事事务变动-职称信息','API20220210000073',1352935241186161664,'B','java.util.List','0PEIU203SX4Y','0QO140ANVBBZ',5,'listPersonAttachs',1150721201652407296,' ','2',' '); 
DELETE FROM t_hrcs_msgpublishapi WHERE FPUBAPIID = 1353615310569227265;
INSERT INTO t_hrcs_msgpublishapi(FID,FPUBAPIID,FAPIPUBSTATUS,FAPIPUBSERVICE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FOUTPUTPARAM,FNAME,FNUMBER,FAPISOURCEID,FENABLE,FOUTPUTTYPE,FAPIPUBCLOUDID,FAPIPUBAPPID,FSEQ,FAPIPUBMETHOD,FAPIPUBERID,FAPINO,FAPITYPE,FPARAMS) VALUES (1335553746759046144,1353615310569227265,'P','IHRPIEmployeeService','0','[{"type":"java.lang.Long","key":"employeeId"},{"type":"java.lang.String","default":"hrpi_perserlen","key":"attachEntityName"}]',' ','{"data":{"brfd":"java.util.Date","bsled":"java.util.Date","brled":"java.util.Date","bred":"java.util.Date","businessstatus":"java.lang.String","adjustworktime":"java.math.BigDecimal","adjustcomtime":"java.math.BigDecimal","boid":"java.lang.Long","comsercount":"java.math.BigDecimal","socialworkage":"java.math.BigDecimal","joinworktime":"java.util.Date","workyear":"java.math.BigDecimal","datastatus":"java.lang.String","firstjoincomdate":"java.util.Date","sourcevid":"java.lang.Long","changebsed":"java.util.Date","firstbsed":"java.util.Date","ismodify":"java.lang.String","employee_id":"java.lang.Long","joincomdate":"java.util.Date","id":"long","bsed":"java.util.Date","person_id":"java.lang.Long"},"resultType":"java.util.List"}','人事事务变动-服务年限','API20220210000072',1352921235960390656,'B','java.util.List','0PEIU203SX4Y','0QO140ANVBBZ',4,'listEmployeeAttachs',1150721201652407296,' ','2',' '); 
DELETE FROM t_hrcs_msgpublishapi WHERE FPUBAPIID = 1355884770483127301;
INSERT INTO t_hrcs_msgpublishapi(FID,FPUBAPIID,FAPIPUBSTATUS,FAPIPUBSERVICE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FOUTPUTPARAM,FNAME,FNUMBER,FAPISOURCEID,FENABLE,FOUTPUTTYPE,FAPIPUBCLOUDID,FAPIPUBAPPID,FSEQ,FAPIPUBMETHOD,FAPIPUBERID,FAPINO,FAPITYPE,FPARAMS) VALUES (1335553746759046144,1355884770483127301,'P','IHRPIEmployeeService','0','[{"type":"java.lang.Long","key":"employeeId"}]',' ','{"data":{"brfd":"java.util.Date","bsled":"java.util.Date","brled":"java.util.Date","bred":"java.util.Date","lastworkdate":"java.util.Date","businessstatus":"java.lang.String","laborrelstatus_id":"java.lang.Long","empnumber":"java.lang.String","sysenddate":"java.util.Date","boid":"java.lang.Long","mid":"java.lang.Long","datastatus":"java.lang.String","startdate":"java.util.Date","enterprise_id":"java.lang.Long","laborreltype_id":"java.lang.Long","candidate_id":"java.lang.Long","sourcevid":"java.lang.Long","enddate":"java.util.Date","changebsed":"java.util.Date","firstbsed":"java.util.Date","ismodify":"java.lang.String","id":"java.lang.Long","bsed":"java.util.Date","person_id":"java.lang.Long"},"resultType":"java.util.Map"}','人事事务变动-企业人','API20220214000077',1355777059179385856,'B','java.util.Map','0PEIU203SX4Y','0QO140ANVBBZ',13,'getEmployee',13466739,' ','2',' '); 
DELETE FROM t_hrcs_msgpublishapi WHERE FPUBAPIID = 1353615310569227264;
INSERT INTO t_hrcs_msgpublishapi(FID,FPUBAPIID,FAPIPUBSTATUS,FAPIPUBSERVICE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FOUTPUTPARAM,FNAME,FNUMBER,FAPISOURCEID,FENABLE,FOUTPUTTYPE,FAPIPUBCLOUDID,FAPIPUBAPPID,FSEQ,FAPIPUBMETHOD,FAPIPUBERID,FAPINO,FAPITYPE,FPARAMS) VALUES (1335553746759046144,1353615310569227264,'P','IHRPIEmployeeService','0','[{"type":"java.lang.Long","key":"employeeId"},{"type":"java.lang.String","default":"hrpi_empjobrel","key":"attachEntityName"}]',' ','{"data":{"bsled":"java.util.Date","bred":"java.util.Date","adminorg_id":"java.lang.Long","jobscm_id":"java.lang.Long","boid":"java.lang.Long","variationtype_id":"java.lang.Long","joblength":"java.lang.Integer","startdate":"java.util.Date","hrbu_id":"java.lang.Long","sourcevid":"java.lang.Long","jobgrade_id":"java.lang.Long","changebsed":"java.util.Date","firstbsed":"java.util.Date","id":"long","joblevel_id":"java.lang.Long","bsed":"java.util.Date","person_id":"java.lang.Long","brfd":"java.util.Date","brled":"java.util.Date","businessstatus":"java.lang.String","jobseq_id":"java.lang.Long","company_id":"java.lang.Long","sysenddate":"java.util.Date","datastatus":"java.lang.String","jobfamily_id":"java.lang.Long","enddate":"java.util.Date","job_id":"java.lang.Long","ismodify":"java.lang.String","employee_id":"java.lang.Long","jobclass_id":"java.lang.Long","position_id":"java.lang.Long"},"resultType":"java.util.List"}','人事事务变动-职级职等','API20220210000071',1352894602364871680,'B','java.util.List','0PEIU203SX4Y','0QO140ANVBBZ',3,'listEmployeeAttachs',1150721201652407296,' ','2',' '); 
DELETE FROM t_hrcs_msgpublishapi WHERE FPUBAPIID = 1355884770483127299;
INSERT INTO t_hrcs_msgpublishapi(FID,FPUBAPIID,FAPIPUBSTATUS,FAPIPUBSERVICE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FOUTPUTPARAM,FNAME,FNUMBER,FAPISOURCEID,FENABLE,FOUTPUTTYPE,FAPIPUBCLOUDID,FAPIPUBAPPID,FSEQ,FAPIPUBMETHOD,FAPIPUBERID,FAPINO,FAPITYPE,FPARAMS) VALUES (1335553746759046144,1355884770483127299,'P','IHRPICmpempService','0','[{"type":"java.lang.Long","key":"cmpempId"}]',' ','{"data":{"brfd":"java.util.Date","bsled":"java.util.Date","isprimaryscope":"java.lang.Boolean","brled":"java.util.Date","bred":"java.util.Date","lastworkdate":"java.util.Date","businessstatus":"java.lang.String","sysenddate":"java.util.Date","company_id":"java.lang.Long","boid":"java.lang.Long","managingscope_id":"java.lang.Long","datastatus":"java.lang.String","startdate":"java.util.Date","sourcevid":"java.lang.Long","enddate":"java.util.Date","changebsed":"java.util.Date","firstbsed":"java.util.Date","ismodify":"java.lang.String","employee_id":"java.lang.Long","id":"java.lang.Long","bsed":"java.util.Date","person_id":"java.lang.Long"},"resultType":"java.util.Map"}','人事事务变动-所属管理范围','API20220214000079',1355822002220487680,'B','java.util.Map','0PEIU203SX4Y','0QO140ANVBBZ',11,'getCmpemp',13466739,' ','2',' '); 
DELETE FROM t_hrcs_msgpublishapi WHERE FPUBAPIID = 1355884770483127300;
INSERT INTO t_hrcs_msgpublishapi(FID,FPUBAPIID,FAPIPUBSTATUS,FAPIPUBSERVICE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FOUTPUTPARAM,FNAME,FNUMBER,FAPISOURCEID,FENABLE,FOUTPUTTYPE,FAPIPUBCLOUDID,FAPIPUBAPPID,FSEQ,FAPIPUBMETHOD,FAPIPUBERID,FAPINO,FAPITYPE,FPARAMS) VALUES (1335553746759046144,1355884770483127300,'P','IHRPIDepempService','0','[{"type":"java.lang.Long","key":"depempId"}]',' ','{"data":{"brfd":"java.util.Date","bsled":"java.util.Date","brled":"java.util.Date","bred":"java.util.Date","lastworkdate":"java.util.Date","adminorg_id":"java.lang.Long","businessstatus":"java.lang.String","sysenddate":"java.util.Date","boid":"java.lang.Long","cmpemp_id":"java.lang.Long","datastatus":"java.lang.String","startdate":"java.util.Date","isprimary":"java.lang.Boolean","sourcevid":"java.lang.Long","enddate":"java.util.Date","changebsed":"java.util.Date","firstbsed":"java.util.Date","ismodify":"java.lang.String","postype_id":"java.lang.Long","employee_id":"java.lang.Long","id":"java.lang.Long","bsed":"java.util.Date","position_id":"java.lang.Long","person_id":"java.lang.Long"},"resultType":"java.util.Map"}','人事事务变动-组织人','API20220214000078',1355810811012109312,'B','java.util.Map','0PEIU203SX4Y','0QO140ANVBBZ',12,'getDepemp',13466739,' ','2',' '); 
DELETE FROM t_hrcs_msgpublishapi WHERE FPUBAPIID = 1355884770483127298;
INSERT INTO t_hrcs_msgpublishapi(FID,FPUBAPIID,FAPIPUBSTATUS,FAPIPUBSERVICE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FOUTPUTPARAM,FNAME,FNUMBER,FAPISOURCEID,FENABLE,FOUTPUTTYPE,FAPIPUBCLOUDID,FAPIPUBAPPID,FSEQ,FAPIPUBMETHOD,FAPIPUBERID,FAPINO,FAPITYPE,FPARAMS) VALUES (1335553746759046144,1355884770483127298,'P','IHRPICmpempService','0','[{"type":"java.lang.Long","key":"cmpempId"}]',' ','{"data":{"bsled":"java.util.Date","isprimaryscope":"java.lang.Boolean","bred":"java.util.Date","boid":"java.lang.Long","variationtype_id":"java.lang.Long","managingscope_id":"java.lang.Long","startdate":"java.util.Date","sourcevid":"java.lang.Long","changebsed":"java.util.Date","firstbsed":"java.util.Date","id":"java.lang.Long","bsed":"java.util.Date","person_id":"java.lang.Long","brfd":"java.util.Date","brled":"java.util.Date","lastworkdate":"java.util.Date","businessstatus":"java.lang.String","sysenddate":"java.util.Date","cmpemp_id":"java.lang.Long","datastatus":"java.lang.String","issingle":"java.lang.Boolean","enddate":"java.util.Date","islatestrecord":"java.lang.Boolean","ismodify":"java.lang.String","employee_id":"java.lang.Long","workplace_id":"java.lang.Long"},"resultType":"java.util.Map"}','人事事务变动-管理范围记录','API20220214000080',1355825638925219840,'B','java.util.Map','0PEIU203SX4Y','0QO140ANVBBZ',10,'getManagingScope',13466739,' ','2',' '); 
DELETE FROM t_hrcs_msgpublishapi WHERE FPUBAPIID = 1355884770483127302;
INSERT INTO t_hrcs_msgpublishapi(FID,FPUBAPIID,FAPIPUBSTATUS,FAPIPUBSERVICE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FOUTPUTPARAM,FNAME,FNUMBER,FAPISOURCEID,FENABLE,FOUTPUTTYPE,FAPIPUBCLOUDID,FAPIPUBAPPID,FSEQ,FAPIPUBMETHOD,FAPIPUBERID,FAPINO,FAPITYPE,FPARAMS) VALUES (1335553746759046144,1355884770483127302,'P','IHRPIPersonService','0','[{"type":"java.lang.Long","key":"personId"}]','获取自然人基本信息','{"data":{"number":"java.lang.String","personindexid":"java.lang.Long","name":"java.lang.String","id":"java.lang.Long","headsculpture":"java.lang.String","age":"java.lang.Integer"},"resultType":"java.util.Map"}','人事事务变动-自然人基本信息','API20220214000076',1355771386509054976,'B','java.util.Map','0PEIU203SX4Y','0QO140ANVBBZ',14,'getPersonBaseInfo',13466739,' ','2',' '); 
DELETE FROM t_hrcs_msgpublishapi WHERE FPUBAPIID = 1355884770483127296;
/* 开发页面那里生成的SQL有问题，缺少字段-出参结构的内容
INSERT INTO t_hrcs_msgpublishapi(FID,FPUBAPIID,FAPIPUBSTATUS,FAPIPUBSERVICE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FOUTPUTPARAM,FNAME,FNUMBER,FAPISOURCEID,FENABLE,FOUTPUTTYPE,FAPIPUBCLOUDID,FAPIPUBAPPID,FSEQ,FAPIPUBMETHOD,FAPIPUBERID,FAPINO,FAPITYPE,FPARAMS) VALUES (1335553746759046144,1355884770483127296,'P','IHRPIEmployeeService','0','[{"type":"java.lang.Long","key":"employeeId"}]',' ',' ','人事事务变动-职业信息','API20220214000082',1355843782897226752,'B','java.util.Map','0PEIU203SX4Y','0QO140ANVBBZ',8,'getEmpentrel',13466739,' ','2',' '); 
*/
INSERT INTO t_hrcs_msgpublishapi(fid, fpubapiid, fseq, fissyspreset, fenable, fapipubstatus, fapipuberid, fapino, fapisourceid, fname, fdescription, fapipubservice, fapipubmethod, fapitype, fnumber, fapipubcloudid, fapipubappid, fparams, foutputtype, foutputparam, finputparam)
VALUES(1335553746759046144, 1355884770483127296, 8, '0', 'A', 'P', 1270951057564008448, ' ', 1355843782897226752, '人事事务变动-职业信息', ' ', 'IHRPIEmployeeService', 'getEmpentrel', '2', 'API20220214000082', '0PEIU203SX4Y', '0QO140ANVBBZ', ' ', 'java.util.Map', '{"data":{"bsled":"java.util.Date","bred":"java.util.Date","laborsubcate_id":"java.lang.Long","boid":"java.lang.Long","isprobation":"java.lang.Boolean","startdate":"java.util.Date","laborreltype_id":"java.lang.Long","number":"java.lang.String","sourcevid":"java.lang.Long","changebsed":"java.util.Date","firstbsed":"java.util.Date","id":"java.lang.Long","labrelstatusprd_id":"java.lang.Long","bsed":"java.util.Date","person_id":"java.lang.Long","brfd":"java.util.Date","brled":"java.util.Date","lastworkdate":"java.util.Date","businessstatus":"java.lang.String","onboardsource_id":"java.lang.Long","laborrelstatus_id":"java.lang.Long","empnumber":"java.lang.String","sysenddate":"java.util.Date","adjustlength":"java.math.BigDecimal","datastatus":"java.lang.String","enterprise_id":"java.lang.Long","oldempnumber":"java.lang.String","issingle":"java.lang.Boolean","enddate":"java.util.Date","servicelength":"java.math.BigDecimal","ismodify":"java.lang.String","firststartdate":"java.util.Date","employee_id":"java.lang.Long","preemployee_id":"java.lang.Long"},"resultType":"java.util.Map"}', '[{"type":"java.lang.Long","key":"employeeId"}]');

DELETE FROM t_hrcs_msgpublishapi WHERE FPUBAPIID = 1355884770483127297;
/* 开发页面那里生成的SQL有问题，缺少字段-出参结构的内容
INSERT INTO t_hrcs_msgpublishapi(FID,FPUBAPIID,FAPIPUBSTATUS,FAPIPUBSERVICE,FISSYSPRESET,FINPUTPARAM,FDESCRIPTION,FOUTPUTPARAM,FNAME,FNUMBER,FAPISOURCEID,FENABLE,FOUTPUTTYPE,FAPIPUBCLOUDID,FAPIPUBAPPID,FSEQ,FAPIPUBMETHOD,FAPIPUBERID,FAPINO,FAPITYPE,FPARAMS) VALUES (1335553746759046144,1355884770483127297,'P','IHRPIDepempService','0','[{"type":"java.lang.Long","key":"depempId"}]',' ',' ','人事事务变动-任职经历','API20220214000081',1355835341138900992,'B','java.util.Map','0PEIU203SX4Y','0QO140ANVBBZ',9,'getEmpOrgrel',13466739,' ','2',' '); 
*/
INSERT INTO t_hrcs_msgpublishapi(fid, fpubapiid, fseq, fissyspreset, fenable, fapipubstatus, fapipuberid, fapino, fapisourceid, fname, fdescription, fapipubservice, fapipubmethod, fapitype, fnumber, fapipubcloudid, fapipubappid, fparams, foutputtype, foutputparam, finputparam)
VALUES(1335553746759046144, 1355884770483127297, 9, '0', 'A', 'P', 1270951057564008448, ' ', 1355835341138900992, '人事事务变动-任职经历', ' ', 'IHRPIDepempService', 'getEmpOrgrel', '2', 'API20220214000081', '0PEIU203SX4Y', '0QO140ANVBBZ', ' ', 'java.util.Map', '{"data":{"bsled":"java.util.Date","bred":"java.util.Date","adminorg_id":"java.lang.Long","boid":"java.lang.Long","variationtype_id":"java.lang.Long","startdate":"java.util.Date","posstatus_id":"java.lang.Long","isexistprobation":"java.lang.Boolean","number":"java.lang.String","sourcevid":"java.lang.Long","changebsed":"java.util.Date","firstbsed":"java.util.Date","endprobation":"java.util.Date","depemp_id":"java.lang.Long","id":"java.lang.Long","bsed":"java.util.Date","person_id":"java.lang.Long","startprobation":"java.util.Date","brfd":"java.util.Date","brled":"java.util.Date","lastworkdate":"java.util.Date","businessstatus":"java.lang.String","company_id":"java.lang.Long","sysenddate":"java.util.Date","cmpemp_id":"java.lang.Long","datastatus":"java.lang.String","isprimary":"java.lang.String","enddate":"java.util.Date","islatestrecord":"java.lang.Boolean","job_id":"java.lang.Long","servicelength":"java.lang.Integer","ismodify":"java.lang.String","employee_id":"java.lang.Long","postype_id":"java.lang.Long","isinsystem":"java.lang.Boolean","workplace_id":"java.lang.Long","position_id":"java.lang.Long"},"resultType":"java.util.Map"}', '[{"type":"java.lang.Long","key":"depempId"}]');


DELETE FROM t_hrcs_msgpublishapi_l WHERE FPKID = '26TYEUUSOO7V';
INSERT INTO t_hrcs_msgpublishapi_l(FPUBAPIID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1341906381959166976,'26TYEUUSOO7V','zh_CN',' ','人事事务变动-人员查询'); 
DELETE FROM t_hrcs_msgpublishapi_l WHERE FPKID = '26TYEUUSOO7W';
INSERT INTO t_hrcs_msgpublishapi_l(FPUBAPIID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1341906381959166977,'26TYEUUSOO7W','zh_CN',' ','人事事务变动-试用信息'); 
DELETE FROM t_hrcs_msgpublishapi_l WHERE FPKID = '28906LKO6UH8';
INSERT INTO t_hrcs_msgpublishapi_l(FPUBAPIID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1353615310569227264,'28906LKO6UH8','zh_CN',' ','人事事务变动-职级职等'); 
DELETE FROM t_hrcs_msgpublishapi_l WHERE FPKID = '28906LKO6UH9';
INSERT INTO t_hrcs_msgpublishapi_l(FPUBAPIID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1353615310569227265,'28906LKO6UH9','zh_CN',' ','人事事务变动-服务年限'); 
DELETE FROM t_hrcs_msgpublishapi_l WHERE FPKID = '28906LKO6UH=';
INSERT INTO t_hrcs_msgpublishapi_l(FPUBAPIID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1353615310569227266,'28906LKO6UH=','zh_CN',' ','人事事务变动-职称信息'); 
DELETE FROM t_hrcs_msgpublishapi_l WHERE FPKID = '28906LKO6UHA';
INSERT INTO t_hrcs_msgpublishapi_l(FPUBAPIID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1353615310569227267,'28906LKO6UHA','zh_CN',' ','人事事务变动-非时序属性'); 
DELETE FROM t_hrcs_msgpublishapi_l WHERE FPKID = '28906LKO6UHB';
INSERT INTO t_hrcs_msgpublishapi_l(FPUBAPIID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1353615310569227268,'28906LKO6UHB','zh_CN',' ','人事事务变动-时序属性'); 
DELETE FROM t_hrcs_msgpublishapi_l WHERE FPKID = '28IX83OX4G3K';
INSERT INTO t_hrcs_msgpublishapi_l(FPUBAPIID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1355884770483127296,'28IX83OX4G3K','zh_CN',' ','人事事务变动-职业信息'); 
DELETE FROM t_hrcs_msgpublishapi_l WHERE FPKID = '28IX83OX4G3L';
INSERT INTO t_hrcs_msgpublishapi_l(FPUBAPIID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1355884770483127297,'28IX83OX4G3L','zh_CN',' ','人事事务变动-任职经历'); 
DELETE FROM t_hrcs_msgpublishapi_l WHERE FPKID = '28IX83OX4G3M';
INSERT INTO t_hrcs_msgpublishapi_l(FPUBAPIID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1355884770483127298,'28IX83OX4G3M','zh_CN',' ','人事事务变动-管理范围记录'); 
DELETE FROM t_hrcs_msgpublishapi_l WHERE FPKID = '28IX83OX4G3N';
INSERT INTO t_hrcs_msgpublishapi_l(FPUBAPIID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1355884770483127299,'28IX83OX4G3N','zh_CN',' ','人事事务变动-所属管理范围'); 
DELETE FROM t_hrcs_msgpublishapi_l WHERE FPKID = '28IX83OX4G3O';
INSERT INTO t_hrcs_msgpublishapi_l(FPUBAPIID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1355884770483127300,'28IX83OX4G3O','zh_CN',' ','人事事务变动-组织人'); 
DELETE FROM t_hrcs_msgpublishapi_l WHERE FPKID = '28IX83OX4G3P';
INSERT INTO t_hrcs_msgpublishapi_l(FPUBAPIID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1355884770483127301,'28IX83OX4G3P','zh_CN',' ','人事事务变动-企业人'); 
DELETE FROM t_hrcs_msgpublishapi_l WHERE FPKID = '28IX83OX4G3Q';
INSERT INTO t_hrcs_msgpublishapi_l(FPUBAPIID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1355884770483127302,'28IX83OX4G3Q','zh_CN','获取自然人基本信息','人事事务变动-自然人基本信息'); 
