[适用版本]

通用

[解决方案]

问题:请假单提交生效,如果在列表内提交生效,提示Null.点进单据内提交生效,提示操作失败,请联系管理员。

处理方案:

档案重复导致,已后台修复,参考sql:

--备份

select * into attendancefile0307 from T_hr_ats_attendancefile

select * into attendancefilehis0307 from T_hr_ats_attendancefilehis

--查询考勤档案的多条重复数据

select * FROM T_hr_ats_attendancefile m

where exists (

select fproposerid,feffdt,fleffdt,fadminorgunitid,fpositionid from T_hr_ats_attendancefile

where m.fproposerid = fproposerid

group by fproposerid,feffdt,fleffdt,fadminorgunitid,fpositionid having count(*)>1)

and fleffdt = {ts '2099-12-31'}

and fid not in (select min(fid) from T_hr_ats_attendancefile group by fproposerid,feffdt,fleffdt,fadminorgunitid,fpositionid having count(*)>1)

--删除考勤档案的多条重复数据

delete FROM T_hr_ats_attendancefile m

where exists (

select fproposerid,feffdt,fleffdt,fadminorgunitid,fpositionid from T_hr_ats_attendancefile

where m.fproposerid = fproposerid

group by fproposerid,feffdt,fleffdt,fadminorgunitid,fpositionid having count(*)>1)

and fleffdt = {ts '2099-12-31'}

and fid not in (select min(fid) from T_hr_ats_attendancefile group by fproposerid,feffdt,fleffdt,fadminorgunitid,fpositionid having count(*)>1)

--删除考勤档案历史的多条重复数据

delete FROM T_hr_ats_attendancefilehis m

where exists (

select fproposerid,feffdt,fleffdt,fadminorgunitid,fpositionid from T_hr_ats_attendancefilehis

where m.fproposerid = fproposerid and fleffdt={ts '2099-12-31'}

group by fproposerid,feffdt,fleffdt,fadminorgunitid,fpositionid having count(*)>1)

and fleffdt = {ts '2099-12-31'}

and fid not in (select min(fid) from T_hr_ats_attendancefilehis where fleffdt={ts '2099-12-31'} group by fproposerid,feffdt,fleffdt,fadminorgunitid,fpositionid having count(*)>1)

//注意,以上语句请逐条执行