问题：如何取加班日期所处考勤周期内的加班总时长处理方案：工作流脚本处理操作步骤如下：1、定义流程变量//输入变量：personid是职员id，OverDate加班日期//输出变量：Wlength，Dlength当天加班时长2、输入变量赋值，操作如下图所示3、在提交节点后置脚本，贴入如下脚本//流程变量说明://输入变量：personid是职员id，OverDate加班日期//输出变量：Wlength当月加班时长,Dlength当天加班时长SimpleDateFormatsdf=newjava.text.SimpleDateFormat("yyyy-MM-dd");Stringod=sdf.format(OverDate);java.sql.Connectioncon1=com.kingdee.bos.framework.ejb.EJBFactory.getConnection(__bosContext);java.sql.Statementst=con1.createStatement();java.sql.ResultSetrs=null;tsql="selectsum(FApplyOTTime)fwapllh,sum(casewhenFOTDATE={ts'"+od+"'}thenFAPPLYOTTIMEelse0end)fdapllh"+"fromt_hr_ats_overtimebillentrya"+"innerjoint_hr_ats_attendancefilebona.FPERSONID=b.fproposeridanda.FPERSONID='"+personid+"'"+"innerjoint_hr_AtS_attencepolicyconb.FATTENCEPOLICYID=c.fid"+"innerjoint_ats_attencecycledonc.FATTENCECYCLEID=d.fid"+"innerjoint_hr_ats_attendanceperiodeond.fid=e.fgroupidande.fstartdate<={ts'"+od+"'}ande.fenddate>={Ts'"+od+"'}ande.fstartdate<=a.FOTDATEande.fenddate>=a.FOTDATE"+"whereFBILLIDin(selectfidfromt_hr_ats_overtimebillwhereFBILLSTATE=2orFBILLSTATE=3orFBILLSTATE=1)";rs=st.executeQuery(tsql);if(rs.next){Wlength=rs.getDouble("fwapllh");Dlength=rs.getDouble("fdapllh");}com.kingdee.util.db.SQLUtils.cleanup(st,con1);com.kingdee.util.db.SQLUtils.cleanup(con1);截图如下：
