OA 考勤组操作日志查询（ecology_biz_log(操作日志表)）

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":""}