问题：考勤周期与薪资周期不一致

问题：后台计算数据错误

处理：

--先查询员工内码

select fid, * from t_BD_PERSON  where fname_l2 = '姓名'--FNzUobWiSiaB98u4Fgj6q4Dvfe0=

select fid, * from t_BD_PERSON  where fname_l2 = '姓名'--wY0ySY+mThia1ch9aAkCTIDvfe0=

--再查询考勤结果汇总 考勤周期内码：fattendanceperiodid 行内码:fid

select  * from T_HR_ATS_AttendanceResultSum where fproposerid='FNzUobWiSiaB98u4Fgj6q4Dvfe0='  order by fsalaryperiod desc-- u5QAAAKGBIv1RH7k  FGLZT1A2W0+c8VGCi345V0n+hkY=

select  * from T_HR_ATS_AttendanceResultSum where fproposerid='wY0ySY+mThia1ch9aAkCTIDvfe0='  order by fsalaryperiod desc-- u5QAAAKGBIv1RH7k  cL1lli+TsUCGh5POoA4GR0n+hkY=

--通过uuid查表名

select * from T_HR_ATS_AttendancePeriod where fid ='u5QAAAKGBIv1RH7k' --考勤周期是第五期

--查询正确的考勤周期内码,记录fid

select * from T_HR_ATS_AttendancePeriod where fname_l2 = '202304'--u5QAAAKGBIr1RH7k

--更新考勤结果汇总表的考勤周期

select  * from T_HR_ATS_AttendanceResultSum where fid = 'FGLZT1A2W0+c8VGCi345V0n+hkY=' or fid = 'cL1lli+TsUCGh5POoA4GR0n+hkY=' 

--update  T_HR_ATS_AttendanceResultSum set fattendanceperiodid = 'u5QAAAKGBIr1RH7k'  where fid = 'FGLZT1A2W0+c8VGCi345V0n+hkY=' or fid = 'cL1lli+TsUCGh5POoA4GR0n+hkY='