OA SQL的操作

\\ 通过sql update 修改流程的意见审批时间

select * from workflow_requestlog where requestid=7693 and operator=15

update workflow_requestlog set operatedate=’2018-12-22′,operatetime=’19:08:66′ where logid = 66210

\\ 通过插入sql ，将加班人的未录到请假调休中的时间插入到系统 针对加班流程

field003 是对应人的id

select * from hrm_paid_leave

insert into hrm_paid_leave(delflag,field001,field002,field003,field004,field005,field006,field007,field008,field009,field010,field011)
values(0,9910,26,’2019-10-13′,’9:00′,’2019-10-13′,’18:00′,0,1,8,’2020-10-13′,8);

\\ 通过数据库查询被强制归档的流程

select distinct requestid from workflow_requestlog where logtype=’e’

\\ sql 查询被干预过的流程

select distinct requestid from workflow_requestlog where logtype=’i’

\\ sql 查询加班时长

select isnull(SUM(a.field009),0) – isnull(SUM(b.shic),0)
from hrm_paid_leave a left join formtable_main_30_dt1 b on a.field002 = b.qingjr and b.leib=7
where a.field002 =’人员id’

\\sql 查询被退回过的流程

SELECT * from workflow_currentoperator where isreject=1 and requestid=10574

sql 日志目录 ecology\web-inf\sqllog