-- 招聘状态预置数据
DELETE FROM t_tsrbd_recrustatnew WHERE FID = 10110;
INSERT INTO t_tsrbd_recrustatnew(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (10110,'1',NULL,'已发放',1360726499186983936,'C','10110_S','已发放',0,{ts'2022-02-21  00:00:00'},'1',13466739,{ts'2022-02-21  00:00:00'},13466739,0);
DELETE FROM t_tsrbd_recrustatnew WHERE FID = 10020;
INSERT INTO t_tsrbd_recrustatnew(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (10020,'1',NULL,'进行中',1360736445324608512,'C','10020_S','进行中',0,{ts'2022-02-21  00:00:00'},'1',13466739,{ts'2022-02-21  00:00:00'},13466739,0);
DELETE FROM t_tsrbd_recrustatnew WHERE FID = 10030;
INSERT INTO t_tsrbd_recrustatnew(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (10030,'1',NULL,'本轮通过',1360736590833402880,'C','10030_S','本轮通过',0,{ts'2022-02-21  00:00:00'},'1',13466739,{ts'2022-02-21  00:00:00'},13466739,0);
DELETE FROM t_tsrbd_recrustatnew WHERE FID = 10120;
INSERT INTO t_tsrbd_recrustatnew(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (10120,'1',NULL,'发放中',1360726655550635008,'C','10120_S','发放中',0,{ts'2022-02-21  00:00:00'},'1',13466739,{ts'2022-02-21  00:00:00'},13466739,0);
DELETE FROM t_tsrbd_recrustatnew WHERE FID = 10010;
INSERT INTO t_tsrbd_recrustatnew(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (10010,'1',NULL,'本轮待定',1360724956782019584,'C','10010_S','本轮待定',0,{ts'2022-02-21  00:00:00'},'1',13466739,{ts'2022-02-21  00:00:00'},13466739,0);
DELETE FROM t_tsrbd_recrustatnew WHERE FID = 10040;
INSERT INTO t_tsrbd_recrustatnew(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (10040,'1',NULL,'本轮淘汰',1360725470055777280,'C','10040_S','本轮淘汰',0,{ts'2022-02-21  00:00:00'},'1',13466739,{ts'2022-02-21  00:00:00'},13466739,0);
DELETE FROM t_tsrbd_recrustatnew WHERE FID = 10090;
INSERT INTO t_tsrbd_recrustatnew(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (10090,'1',NULL,'待发放',1360726351488762880,'C','10090_S','待发放',0,{ts'2022-02-21  00:00:00'},'1',13466739,{ts'2022-02-21  00:00:00'},13466739,0);
DELETE FROM t_tsrbd_recrustatnew WHERE FID = 10130;
INSERT INTO t_tsrbd_recrustatnew(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (10130,'1',NULL,'待入职',1360726922098654208,'C','10130_S','待入职',0,{ts'2022-02-21  00:00:00'},'1',13466739,{ts'2022-02-21  00:00:00'},13466739,0);
DELETE FROM t_tsrbd_recrustatnew WHERE FID = 10140;
INSERT INTO t_tsrbd_recrustatnew(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (10140,'1',NULL,'已入职',1360727210180232192,'C','10140_S','已入职',0,{ts'2022-02-21  00:00:00'},'1',13466739,{ts'2022-02-21  00:00:00'},13466739,0);
DELETE FROM t_tsrbd_recrustatnew WHERE FID = 10150;
INSERT INTO t_tsrbd_recrustatnew(FID,FISSYSPRESET,FDISABLEDATE,FDESCRIPTION,FMASTERID,FSTATUS,FNUMBER,FNAME,FGROUPID,FCREATETIME,FENABLE,FMODIFIERID,FMODIFYTIME,FCREATORID,FDISABLERID) VALUES (10150,'1',NULL,'入职终止',1360727401364997120,'C','10150_S','入职终止',0,{ts'2022-02-21  00:00:00'},'1',13466739,{ts'2022-02-21  00:00:00'},13466739,0);

-- 重复状态名称历史预置数据处理删除(人才供应、JM、ZXW通用)
DELETE FROM t_tsrbd_recrustatnew WHERE FID = 10050;
DELETE FROM t_tsrbd_recrustatnew WHERE FID = 10060;
DELETE FROM t_tsrbd_recrustatnew WHERE FID = 10070;
DELETE FROM t_tsrbd_recrustatnew WHERE FID = 10080;




-- 招聘状态多语言表
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '25OYACXTLW5M';
INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10010,'25OYACXTLW5M','zh_CN','本轮待定','本轮待定');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '25OYACXTLW5N';
--INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10010,'25OYACXTLW5N','zh_TW','本輪待定','本輪待定');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2942RPLIIND1';
INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10020,'2942RPLIIND1','zh_CN','进行中','进行中');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2942RPLIIND2';
--INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10020,'2942RPLIIND2','zh_TW','進行中','進行中');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2942T4VJLGK3';
INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10030,'2942T4VJLGK3','zh_CN','本轮通过','本轮通过');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2942T4VJLGK4';
--INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10030,'2942T4VJLGK4','zh_TW','本輪通過','本輪通過');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2942WPVYFHV5';
INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10110,'2942WPVYFHV5','zh_CN','已发放','已发放');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2942WPVYFHV6';
--INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10110,'2942WPVYFHV6','zh_TW','已發放','已發放');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2942XV=X0CR4';
INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10120,'2942XV=X0CR4','zh_CN','发放中','发放中');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2942XV=X0CR5';
--INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10120,'2942XV=X0CR5','zh_TW','發放中','發放中');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2942P7DJRFUA';
INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10040,'2942P7DJRFUA','zh_CN','本轮淘汰','本轮淘汰');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2942P7DJRFUB';
--INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10040,'2942P7DJRFUB','zh_TW','本輪淘汰','本輪淘汰');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2942VMWU=QXE';
INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10090,'2942VMWU=QXE','zh_CN','待发放','待发放');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2942VMWU=QXF';
--INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10090,'2942VMWU=QXF','zh_TW','待發放','待發放');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '25OX31W67330';
INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10130,'25OX31W67330','zh_CN','待入职','待入职');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '25OX31W67331';
--INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10130,'25OX31W67331','zh_TW','待入職','待入職');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2943/WY4=UYS';
INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10140,'2943/WY4=UYS','zh_CN','已入职','已入职');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2943/WY4=UYT';
--INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10140,'2943/WY4=UYT','zh_TW','已入職','已入職');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '29431=97T+I+';
INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10150,'29431=97T+I+','zh_CN','入职终止','入职终止');
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '29431=97T+I/';
--INSERT INTO t_tsrbd_recrustatnew_L(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (10150,'29431=97T+I/','zh_TW','入職終止','入職終止');

-- 招聘状态多语言，历史预置数据处理删除(人才供应、JM、ZXW通用)
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2942QRLY0HSN';
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2942QRLY0HSO';
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2944R6GZGJG2';
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2944R6GZGJG3';
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2944S8UPLIYG';
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2944S8UPLIYH';
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2942U5W0X2ES';
DELETE FROM t_tsrbd_recrustatnew_L WHERE FPKID = '2942U5W0X2ET';


--招聘状态选择原因分录
DELETE FROM T_TSRBD_RSNSELNEWENTRY WHERE fentryid = 1061414232605618176;
INSERT INTO T_TSRBD_RSNSELNEWENTRY(fid,freasonnumber,fentryid,fseq) VALUES (10040,10010,1061414232605618176,1);
DELETE FROM T_TSRBD_RSNSELNEWENTRY WHERE fentryid = 1061414232605618177;
INSERT INTO T_TSRBD_RSNSELNEWENTRY(fid,freasonnumber,fentryid,fseq) VALUES (10040,10020,1061414232605618177,2);
DELETE FROM T_TSRBD_RSNSELNEWENTRY WHERE fentryid = 1061414232605618178;
INSERT INTO T_TSRBD_RSNSELNEWENTRY(fid,freasonnumber,fentryid,fseq) VALUES (10040,10030,1061414232605618178,3);
DELETE FROM T_TSRBD_RSNSELNEWENTRY WHERE fentryid = 1061414232605618179;
INSERT INTO T_TSRBD_RSNSELNEWENTRY(fid,freasonnumber,fentryid,fseq) VALUES (10040,10040,1061414232605618179,4);
DELETE FROM T_TSRBD_RSNSELNEWENTRY WHERE fentryid = 1061414232605618180;
INSERT INTO T_TSRBD_RSNSELNEWENTRY(fid,freasonnumber,fentryid,fseq) VALUES (10040,10050,1061414232605618180,5);
DELETE FROM T_TSRBD_RSNSELNEWENTRY WHERE fentryid = 1061414232605618181;
INSERT INTO T_TSRBD_RSNSELNEWENTRY(fid,freasonnumber,fentryid,fseq) VALUES (10040,10060,1061414232605618181,6);
DELETE FROM T_TSRBD_RSNSELNEWENTRY WHERE fentryid = 1061414232605618182;
INSERT INTO T_TSRBD_RSNSELNEWENTRY(fid,freasonnumber,fentryid,fseq) VALUES (10040,10080,1061414232605618182,7);
DELETE FROM T_TSRBD_RSNSELNEWENTRY WHERE fentryid = 1061414232605618183;
INSERT INTO T_TSRBD_RSNSELNEWENTRY(fid,freasonnumber,fentryid,fseq) VALUES (10040,10090,1061414232605618183,8);


-- 本轮通过采用1030，历史预置数据处理删除(人才供应、JM、ZXW通用)
DELETE FROM T_TSRBD_RSNSELNEWENTRY WHERE fentryid = 1061420617493936128;
DELETE FROM T_TSRBD_RSNSELNEWENTRY WHERE fentryid = 1061420617493936129;
DELETE FROM T_TSRBD_RSNSELNEWENTRY WHERE fentryid = 1061420617493936130;
DELETE FROM T_TSRBD_RSNSELNEWENTRY WHERE fentryid = 1061420617493936131;
DELETE FROM T_TSRBD_RSNSELNEWENTRY WHERE fentryid = 1061420617493936132;
DELETE FROM T_TSRBD_RSNSELNEWENTRY WHERE fentryid = 1061420617493936133;
DELETE FROM T_TSRBD_RSNSELNEWENTRY WHERE fentryid = 1061420617493936134;
DELETE FROM T_TSRBD_RSNSELNEWENTRY WHERE fentryid = 1061420617493936135;


-- 招聘环节选择招聘状态
DELETE FROM t_tsrbd_statselnewentry WHERE FENTRYID = 10040;
INSERT INTO t_tsrbd_statselnewentry(FID,FSTATID,FENTRYID,FSEQ) VALUES (10010,10010,10040,1);
DELETE FROM t_tsrbd_statselnewentry WHERE FENTRYID = 10020;
INSERT INTO t_tsrbd_statselnewentry(FID,FSTATID,FENTRYID,FSEQ) VALUES (10010,10020,10020,2);
DELETE FROM t_tsrbd_statselnewentry WHERE FENTRYID = 10010;
INSERT INTO t_tsrbd_statselnewentry(FID,FSTATID,FENTRYID,FSEQ) VALUES (10010,10030,10010,3);
DELETE FROM t_tsrbd_statselnewentry WHERE FENTRYID = 10030;
INSERT INTO t_tsrbd_statselnewentry(FID,FSTATID,FENTRYID,FSEQ) VALUES (10010,10040,10030,4);
DELETE FROM t_tsrbd_statselnewentry WHERE FENTRYID = 10100;
INSERT INTO t_tsrbd_statselnewentry(FID,FSTATID,FENTRYID,FSEQ) VALUES (10030,10090,10100,3);
DELETE FROM t_tsrbd_statselnewentry WHERE FENTRYID = 10090;
INSERT INTO t_tsrbd_statselnewentry(FID,FSTATID,FENTRYID,FSEQ) VALUES (10030,10110,10090,2);
DELETE FROM t_tsrbd_statselnewentry WHERE FENTRYID = 10080;
INSERT INTO t_tsrbd_statselnewentry(FID,FSTATID,FENTRYID,FSEQ) VALUES (10030,10120,10080,1);
DELETE FROM t_tsrbd_statselnewentry WHERE FENTRYID = 10110;
INSERT INTO t_tsrbd_statselnewentry(FID,FSTATID,FENTRYID,FSEQ) VALUES (10040,10130,10110,1);
DELETE FROM t_tsrbd_statselnewentry WHERE FENTRYID = 10120;
INSERT INTO t_tsrbd_statselnewentry(FID,FSTATID,FENTRYID,FSEQ) VALUES (10040,10140,10120,2);
DELETE FROM t_tsrbd_statselnewentry WHERE FENTRYID = 10130;
INSERT INTO t_tsrbd_statselnewentry(FID,FSTATID,FENTRYID,FSEQ) VALUES (10040,10150,10130,3);

-- 历史预置数据处理，删除已废弃状态引用，复用状态(人才供应、JM、ZXW通用)
DELETE FROM t_tsrbd_statselnewentry WHERE FENTRYID = 10060;
INSERT INTO t_tsrbd_statselnewentry(FID,FSTATID,FENTRYID,FSEQ) VALUES (10020,10010,10060,1);
DELETE FROM t_tsrbd_statselnewentry WHERE FENTRYID = 10070;
INSERT INTO t_tsrbd_statselnewentry(FID,FSTATID,FENTRYID,FSEQ) VALUES (10020,10020,10070,2);
DELETE FROM t_tsrbd_statselnewentry WHERE FENTRYID = 10050;
INSERT INTO t_tsrbd_statselnewentry(FID,FSTATID,FENTRYID,FSEQ) VALUES (10020,10030,10050,3);
DELETE FROM t_tsrbd_statselnewentry WHERE FENTRYID = 10140;
INSERT INTO t_tsrbd_statselnewentry(FID,FSTATID,FENTRYID,FSEQ) VALUES (10020,10040,10140,4);
