select * from ecology_biz_log
where [description] like '%考勤组%' and operateType >= '2024-07-08' and year(operateDate) = 2024
ORDER BY operateDate DESC
字段:
operateType(操作类型):ADD(新增)、UPDATE(修改)、DELETE(删除)
oldValues(旧值,删除操作时才会有值):
{"jobtitlelevelvalue":"","seclevelto":"","typevalue":"118","groupid":"2","jobtitlelevel":"","id":"87","isdelete":"","type":"1","alllevel":"","seclevel":""}
typevalue:代表被操作的人员ID
newValues(新值,新增或修改时才会有值):
{"jobtitlelevelvalue":"","seclevelto":"","typevalue":"118","groupid":"2","jobtitlelevel":"","id":"1028","isdelete":"","type":"1","alllevel":"","seclevel":""}