/****** HR Management Report SQL ******/
DELETE FROM T_HRPTMC_REPORTMANAGE WHERE FID = 1950196891450887168;
INSERT INTO T_HRPTMC_REPORTMANAGE(FID,FISSYSPRESET,FPUBLISHSTATUS,FANOBJID,FCREATEORGID,FDISABLEDATE,FDESCRIPTION,FSTATUS,FNAME,FNUMBER,FCLOUDID,FCREATETIME,FENABLE,FMODIFIERID,FROW,FDATAFILTER,FMODIFYTIME,FCOLUMN,FCREATORID,FDISABLERID) VALUES (1950196891450887168,'1','B',1945039541882619904,100000,NULL,' ','C','部门编制明细表(年度)','kdhr_staff_orgreport_year','0MUWQ6HSY5JA',{ts'2024-06-11  00:00:00'},'1',13466739,' ',' ',{ts'2024-06-14  00:00:00'},'[]',13466739,0); 

DELETE FROM T_HRPTMC_REPORTMANAGE_L WHERE FPKID = '43J6XD3NVL0W';
INSERT INTO T_HRPTMC_REPORTMANAGE_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1950196891450887168,'43J6XD3NVL0W','zh_CN',' ','部门编制明细表(年度)'); 

DELETE FROM T_HRPTMC_WORKREPORT WHERE FRPTMANAGEID IN (1950196891450887168);
DELETE FROM T_HRPTMC_WORKREPORT WHERE FID = 1950193014068723712;
INSERT INTO T_HRPTMC_WORKREPORT(FID,FINDEX,FROW,FCOLUMN,FKEY,FRPTMANAGEID) VALUES (1950193014068723712,0,' ','[]',1,1950196891450887168); 

DELETE FROM T_HRPTMC_REPORTCONFIG WHERE FID = 1950196892273197056;
INSERT INTO T_HRPTMC_REPORTCONFIG(FID,FTYPE,FCATEGORYUNIT,FLEGEND,FVALUENAME,FSUBTOTAL,FCOLADVANCESORT,FTOTAL,FROWCOLTRANSPOSITION,FFREE,FCATEGORYNAME,FPAGE,FSHOWSEQ,FRPTMANAGEID,FWORKRPTID,FROWADVANCESORT,FSUBTOTALNAME,FHEADSTYLE,FVALUEUNIT,FTOTALNAME,FMERGECELL,FSHOWDATALABEL,FDRILLINGDRL,FHEADERMERGE) VALUES (1950196892273197056,'0',' ',' ',' ','0',' ','0',' ',-1,' ','0','0',1950196891450887168,1950193014068723712,' ',' ',' ',' ','总计','0','0',' ',' '); 

DELETE FROM T_HRPTMC_REPORTCONFIG_L WHERE FPKID = '43J6XDB3UCKJ';
INSERT INTO T_HRPTMC_REPORTCONFIG_L(FID,FCATEGORYUNIT,FVALUENAME,FPKID,FLOCALEID,FSUBTOTALNAME,FVALUEUNIT,FTOTALNAME,FCATEGORYNAME) VALUES (1950196892273197056,' ',' ','43J6XDB3UCKJ','zh_CN',' ',' ','总计',' '); 

DELETE FROM T_HRPTMC_PUBLISHMENU WHERE FREPORTMANAGEID IN (1950196891450887168);




DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972531805492074499;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972531805492074499,'1','asc','月份',1945039542302156801,1950196891450887168,0,0,3,1950193014068723712,0,'curdate',' ','1','month!fn_month','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972531805491827715;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972531805491827715,'2',' ','直属编制人数',1945039542302156808,1950196891450887168,0,1972531805492074499,3,1950193014068723712,0,'curdate','sum',' ','staffcount','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972531805491827714;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972531805491827714,'2',' ','含下级编制人数',1945039542302156809,1950196891450887168,0,1972531805492074499,3,1950193014068723712,0,'curdate','sum',' ','staffcountwithsub','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972531805492074496;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972531805492074496,'1','asc','行政组织名称',1945039542302156804,1950196891450887168,0,0,0,1950193014068723712,0,'curdate',' ',' ','adminorg.name','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972531805492074497;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972531805492074497,'1','asc','行政组织编码',1945039542302156803,1950196891450887168,0,0,1,1950193014068723712,0,'curdate',' ',' ','adminorg.number','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972531805492074498;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972531805492074498,'1','asc','所属公司',1945039542302156807,1950196891450887168,0,0,2,1950193014068723712,0,'curdate',' ',' ','adminorg.company.name','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972531805491827713;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972531805491827713,'2',' ','直属占编人数',0,1950196891450887168,1949225294393000960,1972531805492074499,3,1950193014068723712,0,'curdate','avg',' ','kdhr_staff_presetindex_hold','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972531805491827712;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972531805491827712,'2',' ','直属空余编制',0,1950196891450887168,1949227869183951872,1972531805492074499,3,1950193014068723712,0,'curdate','avg',' ','kdhr_staff_presetindex_remain','0','tile'); 

DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=72IFX83AV';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972531805492074499,'46=72IFX83AV','zh_CN','月份'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=72IFX83AY';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972531805491827715,'46=72IFX83AY','zh_CN','直属编制人数'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=72IFX83B/';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972531805491827714,'46=72IFX83B/','zh_CN','含下级编制人数'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=72IFX83AN';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972531805492074496,'46=72IFX83AN','zh_CN','行政组织名称'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=72IFX83AQ';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972531805492074497,'46=72IFX83AQ','zh_CN','行政组织编码'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=72IFX83AT';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972531805492074498,'46=72IFX83AT','zh_CN','所属公司'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=72IFX83B1';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972531805491827713,'46=72IFX83B1','zh_CN','直属占编人数'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=72IFX83B3';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972531805491827712,'46=72IFX83B3','zh_CN','直属空余编制'); 




DELETE FROM T_HRPTMC_DATAFORMAT WHERE FID IN (SELECT FID FROM T_HRPTMC_ROWFIELD WHERE FRPTMANAGEID IN (1950196891450887168));

DELETE FROM T_HRPTMC_FILTER WHERE FRPTMANAGEID IN (1950196891450887168);
DELETE FROM T_HRPTMC_FILTER WHERE FID = 1972531806507096064;
INSERT INTO T_HRPTMC_FILTER(FISMUST,FISSYSPRESET,FTEXTDEFAULTVALUE,FGROUPDATE,FSUBORG,FANOBJFIELDID,FBDDEFAULTVALUE,FHISDATE,FHISSCOPE,FORGLEVEL,FISGROUPFIELD,FCREATETIME,FENABLE,FFILTERTYPE,FTEXTFILTERRANGE,FDATEFILTERTEXT,FFILTERENDDATE,FFILTERSTARTDATE,FID,FDATEFILTERTYPE,FDATETYPE,FDATESCOPE,FRPTMANAGEID,FBASEDATAISMUL,FGROUPFIELDID,FOPT,FNAME,FQUICKSCOPE,FINDEX,FBEGINDATE,FMODIFIERID,FBDFILTERRANGE,FMODIFYTIME,FENDDATE,FCREATORID,FSPLITDATEID) VALUES ('1','0',' ','0','1',1945039542302156801,' ','0','1','0','0',{ts'2024-06-14  00:00:00'},'1','date',' ',' ',NULL,NULL,1972531806507096064,' ','0',',year,',1950196891450887168,'1',0,'==','查询期间',' ',0,0,13466739,' ',{ts'2024-06-14  00:00:00'},0,0,0); 
DELETE FROM T_HRPTMC_FILTER WHERE FID = 1972531806507096065;
INSERT INTO T_HRPTMC_FILTER(FISMUST,FISSYSPRESET,FTEXTDEFAULTVALUE,FGROUPDATE,FSUBORG,FANOBJFIELDID,FBDDEFAULTVALUE,FHISDATE,FHISSCOPE,FORGLEVEL,FISGROUPFIELD,FCREATETIME,FENABLE,FFILTERTYPE,FTEXTFILTERRANGE,FDATEFILTERTEXT,FFILTERENDDATE,FFILTERSTARTDATE,FID,FDATEFILTERTYPE,FDATETYPE,FDATESCOPE,FRPTMANAGEID,FBASEDATAISMUL,FGROUPFIELDID,FOPT,FNAME,FQUICKSCOPE,FINDEX,FBEGINDATE,FMODIFIERID,FBDFILTERRANGE,FMODIFYTIME,FENDDATE,FCREATORID,FSPLITDATEID) VALUES ('1','0',' ','0','1',1945039542302156804,' ','0','1','0','0',{ts'2024-06-14  00:00:00'},'1','adminorg',' ',' ',NULL,NULL,1972531806507096065,' ','1',',,',1950196891450887168,'1',0,'==','行政组织',' ',1,0,13466739,' ',{ts'2024-06-14  00:00:00'},0,0,0); 

DELETE FROM T_HRPTMC_FILTER_L  WHERE FID IN (SELECT FID FROM T_HRPTMC_FILTER WHERE FRPTMANAGEID IN (1950196891450887168)) AND FLOCALEID='zh_CN';
DELETE FROM T_HRPTMC_FILTER_L WHERE FPKID = '46=72IQSCILV';
INSERT INTO T_HRPTMC_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1972531806507096064,'46=72IQSCILV','zh_CN','查询期间'); 
DELETE FROM T_HRPTMC_FILTER_L WHERE FPKID = '46=72IQSCILY';
INSERT INTO T_HRPTMC_FILTER_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1972531806507096065,'46=72IQSCILY','zh_CN','行政组织'); 




DELETE FROM T_HRPTMC_REPORTMARK WHERE FID = 1972531806750118912;
INSERT INTO T_HRPTMC_REPORTMARK(FID,FSHOW,FRPTMANAGEID) VALUES (1972531806750118912,'1',1950196891450887168); 

DELETE FROM T_HRPTMC_RPTMARKCONTENT WHERE FID = 1972531806859417600;
INSERT INTO T_HRPTMC_RPTMARKCONTENT(FID,FRPTMARKID,FLOCALE,FMARKCONTENT) VALUES (1972531806859417600,1972531806750118912,'zh_CN',' '); 





DELETE FROM T_HRPTMC_RPTLASTSTYLE WHERE FID IN (SELECT FID FROM T_HRPTMC_REPORTCONFIG WHERE FRPTMANAGEID IN (1950196891450887168));
DELETE FROM T_HRPTMC_RPTLASTSTYLE WHERE FENTRYID = 1972540385049711616;
INSERT INTO T_HRPTMC_RPTLASTSTYLE(FID,FTYPE,FLASTSTYLE,FTIME,FENTRYID,FSEQ) VALUES (1950196892273197056,'0','[]',NULL,1972540385049711616,0); 
DELETE FROM T_HRPTMC_RPTLASTSTYLE WHERE FENTRYID = 1972540385049711617;
INSERT INTO T_HRPTMC_RPTLASTSTYLE(FID,FTYPE,FLASTSTYLE,FTIME,FENTRYID,FSEQ) VALUES (1950196892273197056,'1','[]',NULL,1972540385049711617,0); 
DELETE FROM T_HRPTMC_RPTLASTSTYLE WHERE FENTRYID = 1972540385049711618;
INSERT INTO T_HRPTMC_RPTLASTSTYLE(FID,FTYPE,FLASTSTYLE,FTIME,FENTRYID,FSEQ) VALUES (1950196892273197056,'2','["rgba(251, 35, 35, 1)"]',NULL,1972540385049711618,0); 
DELETE FROM T_HRPTMC_RPTLASTSTYLE WHERE FENTRYID = 1972540385049711619;
INSERT INTO T_HRPTMC_RPTLASTSTYLE(FID,FTYPE,FLASTSTYLE,FTIME,FENTRYID,FSEQ) VALUES (1950196892273197056,'3','["rgba(255, 255, 255, 1)"]',NULL,1972540385049711619,0); 



DELETE FROM T_HRPTMC_ALGORITHMCOL WHERE FRPTCONFIGID IN (SELECT FID FROM T_HRPTMC_REPORTCONFIG WHERE FRPTMANAGEID IN (1950196891450887168));

DELETE FROM T_HRPTMC_ALGORITHMCOL_L WHERE FID IN (SELECT FID FROM T_HRPTMC_ALGORITHMCOL WHERE FRPTCONFIGID IN (SELECT FID FROM T_HRPTMC_REPORTCONFIG WHERE FRPTMANAGEID IN (1950196891450887168))) AND FLOCALEID='zh_CN';

DELETE FROM T_HRPTMC_COLALGORITHMTYPE WHERE FID IN (SELECT FID FROM T_HRPTMC_ALGORITHMCOL WHERE FRPTCONFIGID IN (SELECT FID FROM T_HRPTMC_REPORTCONFIG WHERE FRPTMANAGEID IN (1950196891450887168)));

DELETE FROM T_HRPTMC_ROWALGORITHM WHERE FID IN (SELECT FID FROM T_HRPTMC_REPORTCONFIG WHERE FRPTMANAGEID IN (1950196891450887168));

DELETE FROM T_HRPTMC_SPLITDATE WHERE FID = 1950196891694156800;
INSERT INTO T_HRPTMC_SPLITDATE(FID,FANOBJFIELDID,FRPTMANAGEID,FNUMBER) VALUES (1950196891694156800,1945039542302156801,1950196891450887168,'fn_month'); 

DELETE FROM T_HRPTMC_RPTQUERYCONFIG WHERE FID = 1965897856074238976;
INSERT INTO T_HRPTMC_RPTQUERYCONFIG(FSCHEDULESTATUS,FORIGINALFIELDSORT,FCYCLE,FKSQLDETAILOPTIMIZE,FCREATETIME,FENABLECACHE,FDAY,FJOBID,FID,FDEFSORTTYPE,FCACHETIMEOUT,FQUERYSCHEME,FENABLEENTITYJOINOPTIMIZE,FENABLESCHEME,FNEWTABLE,FNEWENTITYNUM,FALGOXOPTIMIZEDIMCOUNT,FSCHEDULETIME,FCACHEBATCH,FENABLEEXTRACT,FSUMBATCHCOUNT,FKSQLCOUNTBATCH,FPAGEBYDIM,FKSQLSUMBATCH,FKSQLSUMTHRESHOLD,FMODIFIERID,FMODIFYTIME,FALGOXOPTIMIZEDATACOUNT,FWEEK,FEXECUTEWITHSAVE,FREPORTID,FCREATORID,FDETAILBATCHCOUNT) VALUES ('3','0','3','0',{ts'2024-06-11  00:00:00'},'1',',1,','1971045477122073600',1965897856074238976,'0',180000,'0','0','1','t_hrom_re_gz625alq','hrom_re_gz625alq',50,'8',5,'1',500,20000,'0',50000,20000,1,{ts'2024-06-14  00:00:00'},10000,' ','1',1950196891450887168,1632488365473410048,500); 

DELETE FROM T_HRPTMC_CONFIGSCHEDULE WHERE FPKID = 1971045477918974976;
INSERT INTO T_HRPTMC_CONFIGSCHEDULE(FID,FBASEDATAID,FPKID) VALUES (1965897856074238976,'1971045477407269888',1971045477918974976); 



DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972531805492074499;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972531805492074499,'1','asc','月份',1945039542302156801,1950196891450887168,0,0,3,1950193014068723712,0,'curdate',' ','1','month!fn_month','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972531805491827715;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972531805491827715,'2',' ','直属编制人数',1945039542302156808,1950196891450887168,0,1972531805492074499,3,1950193014068723712,0,'curdate','sum',' ','staffcount','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972531805491827714;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972531805491827714,'2',' ','含下级编制人数',1945039542302156809,1950196891450887168,0,1972531805492074499,3,1950193014068723712,0,'curdate','sum',' ','staffcountwithsub','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972531805492074496;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972531805492074496,'1','asc','行政组织名称',1945039542302156804,1950196891450887168,0,0,0,1950193014068723712,0,'curdate',' ',' ','adminorg.name','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972531805492074497;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972531805492074497,'1','asc','行政组织编码',1945039542302156803,1950196891450887168,0,0,1,1950193014068723712,0,'curdate',' ',' ','adminorg.number','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972531805492074498;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972531805492074498,'1','asc','所属公司',1945039542302156807,1950196891450887168,0,0,2,1950193014068723712,0,'curdate',' ',' ','adminorg.company.name','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972531805491827713;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972531805491827713,'2',' ','直属占编人数',0,1950196891450887168,1949225294393000960,1972531805492074499,3,1950193014068723712,0,'curdate','avg',' ','kdhr_staff_presetindex_hold','0','tile'); 
DELETE FROM T_HRPTMC_ROWFIELD WHERE FID = 1972531805491827712;
INSERT INTO T_HRPTMC_ROWFIELD(FID,FTYPE,FSORT,FDISPLAYNAME,FANOBJFIELDID,FRPTMANAGEID,FPREIDXFIELDID,FPARENTID,FBIZINDEX,FWORKRPTID,FCALCIDXFIELDID,FORGVERSIONDATE,FALGORITHM,FMERGETYPE,FNUMBERALIAS,FSHOWEMPTYCOL,FDISPLAYMODE) VALUES (1972531805491827712,'2',' ','直属空余编制',0,1950196891450887168,1949227869183951872,1972531805492074499,3,1950193014068723712,0,'curdate','avg',' ','kdhr_staff_presetindex_remain','0','tile'); 

DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=72IFX83AV';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972531805492074499,'46=72IFX83AV','zh_CN','月份'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=72IFX83AY';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972531805491827715,'46=72IFX83AY','zh_CN','直属编制人数'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=72IFX83B/';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972531805491827714,'46=72IFX83B/','zh_CN','含下级编制人数'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=72IFX83AN';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972531805492074496,'46=72IFX83AN','zh_CN','行政组织名称'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=72IFX83AQ';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972531805492074497,'46=72IFX83AQ','zh_CN','行政组织编码'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=72IFX83AT';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972531805492074498,'46=72IFX83AT','zh_CN','所属公司'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=72IFX83B1';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972531805491827713,'46=72IFX83B1','zh_CN','直属占编人数'); 
DELETE FROM T_HRPTMC_ROWFIELD_L WHERE FPKID = '46=72IFX83B3';
INSERT INTO T_HRPTMC_ROWFIELD_L(FID,FPKID,FLOCALEID,FDISPLAYNAME) VALUES (1972531805491827712,'46=72IFX83B3','zh_CN','直属空余编制'); 




DELETE FROM T_HRPTMC_DIMMAP WHERE FREPORTID IN (1950196891450887168);
DELETE FROM T_HRPTMC_DIMMAP WHERE FID = 1972540384873797632;
INSERT INTO T_HRPTMC_DIMMAP(FID,FPREINDEXNUMBER,FPREINDEXID,FREPORTID,FWORKRPTID) VALUES (1972540384873797632,'kdhr_staff_presetindex_hold',1949225294393000960,1950196891450887168,1950193014068723712); 
DELETE FROM T_HRPTMC_DIMMAP WHERE FID = 1972540384873797633;
INSERT INTO T_HRPTMC_DIMMAP(FID,FPREINDEXNUMBER,FPREINDEXID,FREPORTID,FWORKRPTID) VALUES (1972540384873797633,'kdhr_staff_presetindex_remain',1949227869183951872,1950196891450887168,1950193014068723712); 

DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FID IN (SELECT FID FROM T_HRPTMC_DIMMAP WHERE FREPORTID IN (1950196891450887168));
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972540384873550848;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972540384873797632,'行政组织名称','-','adminorgname','10',1972540384873550848,0,'adminorg.name','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972540384873550849;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972540384873797632,'行政组织编码','-','adminorgnumber','10',1972540384873550849,0,'adminorg.number','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972540384873550850;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972540384873797632,'所属公司','-','company','10',1972540384873550850,0,'adminorg.company.name','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972540384873550851;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972540384873797632,'月份','-','month','10',1972540384873550851,0,'month!fn_month','10','string'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972540384873550852;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972540384873797632,'查询期间','20','querydate','20',1972540384873550852,0,'month','30','datetime'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972540384873550853;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972540384873797633,'行政组织名称','-','adminorgname','10',1972540384873550853,0,'adminorg.name','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972540384873550854;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972540384873797633,'行政组织编码','-','adminorgnumber','10',1972540384873550854,0,'adminorg.number','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972540384873550855;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972540384873797633,'所属公司','-','company','10',1972540384873550855,0,'adminorg.company.name','10','adminorg'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972540384873550856;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972540384873797633,'月份','-','month','10',1972540384873550856,0,'month!fn_month','10','string'); 
DELETE FROM T_HRPTMC_DIMMAPENTRY WHERE FENTRYID = 1972540384873550857;
INSERT INTO T_HRPTMC_DIMMAPENTRY(FID,FDIM,FPARAMRULE,FPREINDEXPARAM,FDIMFROM,FENTRYID,FSEQ,FDIMNUMBER,FDIMREALFROM,FDIMTYPE) VALUES (1972540384873797633,'查询期间','20','querydate','20',1972540384873550857,0,'month','30','datetime'); 

DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FENTRYID IN (SELECT FENTRYID FROM T_HRPTMC_DIMMAPENTRY WHERE FID IN (SELECT FID FROM T_HRPTMC_DIMMAP WHERE FREPORTID IN (1950196891450887168)));
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8P0MR2+4W';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('月份','46=8P0MR2+4W','zh_CN',1972540384873550851); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8P0MR2+4R';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织编码','46=8P0MR2+4R','zh_CN',1972540384873550849); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8P0MR2+5+';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织名称','46=8P0MR2+5+','zh_CN',1972540384873550853); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8P0MR2+51';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织编码','46=8P0MR2+51','zh_CN',1972540384873550854); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8P0MR2+4X';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('查询期间','46=8P0MR2+4X','zh_CN',1972540384873550852); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8P0MR2+54';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('所属公司','46=8P0MR2+54','zh_CN',1972540384873550855); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8P0MR2+56';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('月份','46=8P0MR2+56','zh_CN',1972540384873550856); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8P0MR2+4U';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('所属公司','46=8P0MR2+4U','zh_CN',1972540384873550850); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8P0MR2+4O';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('行政组织名称','46=8P0MR2+4O','zh_CN',1972540384873550848); 
DELETE FROM T_HRPTMC_DIMMAPENTRY_L WHERE FPKID = '46=8P0MR2+57';
INSERT INTO T_HRPTMC_DIMMAPENTRY_L(FDIM,FPKID,FLOCALEID,FENTRYID) VALUES ('查询期间','46=8P0MR2+57','zh_CN',1972540384873550857); 

DELETE FROM T_HRPTMC_REPORTPREINDEX WHERE FREPORTID IN (1950196891450887168);
DELETE FROM T_HRPTMC_REPORTPREINDEX WHERE FID = 1972540385469388800;
INSERT INTO T_HRPTMC_REPORTPREINDEX(FID,FPREINDEXID,FREPORTID) VALUES (1972540385469388800,1949225294393000960,1950196891450887168); 
DELETE FROM T_HRPTMC_REPORTPREINDEX WHERE FID = 1972540385469388801;
INSERT INTO T_HRPTMC_REPORTPREINDEX(FID,FPREINDEXID,FREPORTID) VALUES (1972540385469388801,1949227869183951872,1950196891450887168); 
DELETE FROM T_HRPTMC_REPORTPREINDEX WHERE FID = 1972540385469388802;
INSERT INTO T_HRPTMC_REPORTPREINDEX(FID,FPREINDEXID,FREPORTID) VALUES (1972540385469388802,1949229801550136320,1950196891450887168); 
DELETE FROM T_HRPTMC_REPORTPREINDEX WHERE FID = 1972540385469388803;
INSERT INTO T_HRPTMC_REPORTPREINDEX(FID,FPREINDEXID,FREPORTID) VALUES (1972540385469388803,1949228689136829440,1950196891450887168); 
DELETE FROM T_HRPTMC_REPORTPREINDEX WHERE FID = 1972540385469388804;
INSERT INTO T_HRPTMC_REPORTPREINDEX(FID,FPREINDEXID,FREPORTID) VALUES (1972540385469388804,1949230042588398592,1950196891450887168); 
DELETE FROM T_HRPTMC_REPORTPREINDEX WHERE FID = 1972540385469388805;
INSERT INTO T_HRPTMC_REPORTPREINDEX(FID,FPREINDEXID,FREPORTID) VALUES (1972540385469388805,1949230285438600192,1950196891450887168); 



