-- 终止调动原因数据升级
update t_hdm_transfertermreason set foriname='操作失误',forinumber ='1010_S' where fid =1010;
update t_hdm_transfertermreason_l set foriname='操作失误' where fid =1010 and flocaleid = 'zh_CN';
update t_hdm_transfertermreason set foriname='部门要求',forinumber ='1020_S' where fid =1020;
update t_hdm_transfertermreason_l set foriname='部门要求' where fid =1020 and flocaleid = 'zh_CN';
update t_hdm_transfertermreason set foriname='员工主动要求终止',forinumber ='1030_S' where fid =1030;
update t_hdm_transfertermreason_l set foriname='员工主动要求终止' where fid =1030 and flocaleid = 'zh_CN';
update t_hdm_transfertermreason set foriname='合同到期',forinumber ='1040_S' where fid =1040;
update t_hdm_transfertermreason_l set foriname='合同到期' where fid =1040 and flocaleid = 'zh_CN';
update t_hdm_transfertermreason set foriname='调动协作未完成',forinumber ='1050_S' where fid =1050;
update t_hdm_transfertermreason_l set foriname='调动协作未完成' where fid =1050 and flocaleid = 'zh_CN';
update t_hdm_transfertermreason set foriname='其他',forinumber ='1060_S' where fid =1060;
update t_hdm_transfertermreason_l set foriname='其他' where fid =1060 and flocaleid = 'zh_CN';
update t_hdm_transfertermreason set foriname='员工已离职',forinumber ='1070_S' where fid =1070;
update t_hdm_transfertermreason_l set foriname='员工已离职' where fid =1070 and flocaleid = 'zh_CN';

update t_hdm_transfertermreason set foristatus = '1' where fissyspreset = '1' and (fnumber != forinumber or fname != foriname or fdescription != '预置数据');

-- 调动原因数据升级
update t_hdm_transferreason set foriname='战略调配',forinumber ='1010_S' where fid =1294784715617906688;
update t_hdm_transferreason_l set foriname='战略调配' where fid =1294784715617906688 and flocaleid = 'zh_CN';
update t_hdm_transferreason set foriname='组织架构调整',forinumber ='1020_S' where fid =1294784848778670080;
update t_hdm_transferreason_l set foriname='组织架构调整' where fid =1294784848778670080 and flocaleid = 'zh_CN';
update t_hdm_transferreason set foriname='业务发展需要',forinumber ='1030_S' where fid =1294785003649148928;
update t_hdm_transferreason_l set foriname='业务发展需要' where fid =1294785003649148928 and flocaleid = 'zh_CN';
update t_hdm_transferreason set foriname='转正调岗',forinumber ='1040_S' where fid =1294785137069959168;
update t_hdm_transferreason_l set foriname='转正调岗' where fid =1294785137069959168 and flocaleid = 'zh_CN';
update t_hdm_transferreason set foriname='员工个人发展意愿',forinumber ='1050_S' where fid =1294785328657379328;
update t_hdm_transferreason_l set foriname='员工个人发展意愿' where fid =1294785328657379328 and flocaleid = 'zh_CN';
update t_hdm_transferreason set foriname='其他',forinumber ='1060_S' where fid =1294785506126768128;
update t_hdm_transferreason_l set foriname='其他' where fid =1294785506126768128 and flocaleid = 'zh_CN';
update t_hdm_transferreason set foriname='内部招聘调动',forinumber ='1070_S' where fid =1070;
update t_hdm_transferreason_l set foriname='内部招聘调动' where fid =1070 and flocaleid = 'zh_CN';

update t_hdm_transferreason set foristatus = '1' where fissyspreset = '1' and (fnumber != forinumber or fname != foriname or fdescription != '预置数据');

-- 撤销调动原因数据升级
update t_hdm_transrevokereason set foriname='操作失误',forinumber ='1010_S' where fid =1294786221901522944;
update t_hdm_transrevokereason_l set foriname='操作失误' where fid =1294786221901522944 and flocaleid = 'zh_CN';
update t_hdm_transrevokereason set foriname='部门要求',forinumber ='1020_S' where fid =1294786375471769600;
update t_hdm_transrevokereason_l set foriname='部门要求' where fid =1294786375471769600 and flocaleid = 'zh_CN';
update t_hdm_transrevokereason set foriname='其他',forinumber ='1050_S' where fid =1294786568955015168;
update t_hdm_transrevokereason_l set foriname='其他' where fid =1294786568955015168 and flocaleid = 'zh_CN';

update t_hdm_transrevokereason set foristatus = '1' where fissyspreset = '1' and (fnumber != forinumber or fname != foriname or fdescription != '预置数据');

-- 调动类别数据升级
update t_hdm_transferclassify set foriname='平调',forinumber ='1010_S' where fid =1550592371547192320;
update t_hdm_transferclassify_l set foriname='平调' where fid =1550592371547192320 and flocaleid = 'zh_CN';
update t_hdm_transferclassify set foriname='晋升',forinumber ='1020_S' where fid =1550592567748343808;
update t_hdm_transferclassify_l set foriname='晋升' where fid =1550592567748343808 and flocaleid = 'zh_CN';
update t_hdm_transferclassify set foriname='降职',forinumber ='1030_S' where fid =1550592792479153152;
update t_hdm_transferclassify_l set foriname='降职' where fid =1550592792479153152 and flocaleid = 'zh_CN';

update t_hdm_transferclassify set foristatus = '1' where fissyspreset = '1' and (fnumber != forinumber or fname != foriname or fdescription != '预置数据');

-- 调返原因数据升级
update t_hdm_secdbackreason set foriname='到期调返',forinumber ='1010_S' where fid =1010;
update t_hdm_secdbackreason_l set foriname='到期调返' where fid =1010 and flocaleid = 'zh_CN';
update t_hdm_secdbackreason set foriname='提前终止借调',forinumber ='1020_S' where fid =1020;
update t_hdm_secdbackreason_l set foriname='提前终止借调' where fid =1020 and flocaleid = 'zh_CN';
update t_hdm_secdbackreason set foriname='离职调返',forinumber ='1030_S' where fid =1030;
update t_hdm_secdbackreason_l set foriname='离职调返' where fid =1030 and flocaleid = 'zh_CN';

update t_hdm_secdbackreason set foristatus = '1' where fissyspreset = '1' and (fnumber != forinumber or fname != foriname or fdescription != ' ');


-- 借调原因数据升级
update t_hdm_secdreason set foriname='组织架构调整',forinumber ='1010_S' where fid =1010;
update t_hdm_secdreason_l set foriname='组织架构调整' where fid =1010 and flocaleid = 'zh_CN';
update t_hdm_secdreason set foriname='业务发展需要',forinumber ='1020_S' where fid =1020;
update t_hdm_secdreason_l set foriname='业务发展需要' where fid =1020 and flocaleid = 'zh_CN';
update t_hdm_secdreason set foriname='员工个人发展意愿',forinumber ='1030_S' where fid =1030;
update t_hdm_secdreason_l set foriname='员工个人发展意愿' where fid =1030 and flocaleid = 'zh_CN';
update t_hdm_secdreason set foriname='其他原因',forinumber ='1040_S' where fid =1040;
update t_hdm_secdreason_l set foriname='其他原因' where fid =1040 and flocaleid = 'zh_CN';

update t_hdm_secdreason set foristatus = '1' where fissyspreset = '1' and (fnumber != forinumber or fname != foriname or fdescription != ' ');
