防止考勤流程重复提交

防止考勤流程重复提交

逻辑：查询历史提交的考勤流程如加班流程，然后当前提交的流程与历史提交的流程是否存在有交集时间段。如果流程过多，可以限制近两三个月的数据对比。我当前的流程是对比全部历史数据，有交集的时间段不让提交

package com.customcode.action;import com.customcode.util.XmActionLog;
RecordSet;
al.BaseBean;
import weaver.interfaces.workflow.action.Action;
import weaver.quest.RequestInfo;ParseException;
SimpleDateFormat;/*** @author Yuyb* @version 1.0* 类说明：加班* @date 2020/6/10 17:58*/public class HR02_RedifferenTime implements Action {public String execute(RequestInfo request) {XmActionLog alog = new XmActionLog();String actionName="HR02_RedifferenTime";//日志文件夹名称alog.info(actionName,"====================================START=========================================");BaseBean baseBean = new BaseBean();RecordSet rs = new RecordSet();RecordSet rs_00 = new RecordSet();RecordSet rs_hr = new RecordSet();String requestId = Requestid();  //获取请求requestIdString maintable = RequestManager().getBillTableName();String wfid &#Workflowid();alog.info(actionName,"wfid=="+wfid);alog.info(actionName,"requestId=="+requestId);alog.info(actionName,"maintablestar=="+maintable);SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm");String sql="select jbrq,jbsj,jsrq,jssj,Create_By from "+maintable+" where requestid="+ute(sql);alog.info(actionName,"sql=="+sql);()){String jbrq&#String("jbrq");String jbsj&#String("jbsj");String jsrq&#String("jsrq");String jssj&#String("jssj");String Create_By&#String("Create_By");String tjksrq = jbrq+" "+jbsj;String tjjsrq = jsrq+" "+jssj;alog.info(actionName,"tjksrq=="+tjksrq+",tjjsrq=="+tjjsrq);try {Long tjksrq_hm=sdf.parse(tjksrq).getTime();//转为毫秒Long tjjsrq_hm=sdf.parse(tjjsrq).getTime();//转为毫秒String sql_00="select jbrq,jbsj,jsrq,jssj,Create_By from "+maintable+" " +"where Create_By="+Create_By+" and Flow_No is not null and requestid <>"+requestId;ute(sql_00);alog.info(actionName,"sql_00=="+sql_00);while(()){String jbrq_old=String("jbrq");String jbsj_old=String("jbsj");String jbjsrq_old=String("jsrq");String jssj_old=String("jssj");String ksrq_old=jbrq_old+" "+jbsj_old;String jsrq_old=jbjsrq_old+" "+jssj_old;Long ksrq_old_hm=sdf.parse(ksrq_old).getTime();//转为毫秒Long jsrq_old_hm=sdf.parse(jsrq_old).getTime();//转为毫秒alog.info(actionName,"ksrq_old=="+ksrq_old+",jsrq_old=="+jsrq_old);if(tjksrq_hm>=jsrq_old_hm || tjjsrq_hm <= ksrq_old_hm){alog.info(actionName, "true==>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>end" );//return "1";}else{
//                        String sql_hr="select lastname from hrmresource where id="+Create_By;
//                        ute(sql_hr);
//                        String name="";
//                        while (()){
//                            name=String("lastname");
//                        }RequestManager().setMessagecontent("该时间段流程已经提交过，请勿重复提交！");RequestManager().setMessageid("1");alog.info(actionName, "false==>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>end" );return "0";}}} catch (ParseException e) {e.printStackTrace();alog.info(actionName, "ParseException==" + e.getMessage());RequestManager().setMessagecontent("有加班单存在异常，请联系OA管理员！");RequestManager().setMessageid("1");return "0";}}alog.info(actionName,"====================================END=========================================");return "1";}
}