企业官网建设流程全解析

节点 Action 获取流程信息

StringstrRequestID=request.getRequestid();StringstrTableName=request.getRequestManager().getBillTableName();intstrFormid=request.getRequestManager().getFormid();RecordSetrs=newRecordSet();if(strTableName==null||"".equals(strTableName)){rs.executeQuery("select tablename from workflow_bill where id = "+strFormid);if(rs.next()){strTableName=Util.null2String(rs.getString("tablename"));}log.error("非手动提交,通过formid获取表单id："+strFormid+"表单名称："+strTableName);}

获取流程附件基本信息

RecordSetrsFile=newRecordSet();Stringsql=" SELECT t1.imagefilename,t1.imagefileid "+" FROM ImageFile t1 LEFT JOIN DocImageFile t2 ON t1.imagefileid = t2.imagefileid "+" WHERE t2.docid IN ("+fj+")"+" AND t2.versionId = ( SELECT MAX( t3.versionId ) FROM DocImageFile t3 WHERE t3.id = t2.id )";rsFile.executeQuery(sql);while(rsFile.next()){Stringimagefilename=Util.null2String(rsFile.getString("imagefilename"));if(!"".equals(imagefilename)){String[]split=imagefilename.split("\\.");Stringfilename=split[0];Stringfiletype=split[split.length-1];Stringimagefileid=Util.null2String(rsFile.getString("imagefileid"));if(!imagefileid.equals("")){InputStreamfileStream=getInputStreamById(Integer.parseInt(imagefileid));ByteArrayOutputStreambyteArrayOutputStream=newByteArrayOutputStream();byte[]buffer=newbyte[1024];intlength;while((length=fileStream.read(buffer))!=-1){byteArrayOutputStream.write(buffer,0,length);}byte[]fileBytes=byteArrayOutputStream.toByteArray();Stringbase64String=Base64.getEncoder().encodeToString(fileBytes);JSONObjectfile=newJSONObject();file.put("fileType",filetype);file.put("fileName",filename);file.put("file",base64String);files.add(file);}}}

获取签字意见信息

RecordSetrsqzyj=newRecordSet();rsqzyj.executeQuery(" select t2.nodename, t3.lastname, t3.workcode, t1.operatedate, t1.operatetime, t1.remark "+" from workflow_requestlog t1, workflow_nodebase t2, hrmresource t3 "+" where t1.requestid = ? and t1.nodeid = t2.id and t1.operator = t3.id order by t1.operatedate, t1.operatetime desc",strRequestID);while(rsqzyj.next()){Stringnodename=Util.null2String(rsqzyj.getString("nodename"));Stringworkcode=Util.null2String(rsqzyj.getString("workcode"));Stringlastname=Util.null2String(rsqzyj.getString("lastname"));Stringoperatedate=Util.null2String(rsqzyj.getString("operatedate"));Stringremark=Util.null2String(rsqzyj.getString("remark"));JSONObjecttemp=newJSONObject();temp.put("signName",nodename);temp.put("userid",workcode);temp.put("userName",lastname);temp.put("signDate",operatedate);temp.put("signRemark",remark);signInfo.add(temp);}

获取流程下拉框的显示内容

/** * 获取下拉框的显示内容 * * @param fieldName 字段数据库名 * @param fieldValue 字段值 * @return 显示的内容 */publicstaticStringgetShowName(StringfieldName,StringfieldValue){RecordSetrecordSet=newRecordSet();recordSet.executeQuery("SELECT selectname FROM workflow_selectitem s,workflow_billfield b WHERE b.id = s.fieldid and b.billid = -1470 AND b.fieldname = '"+fieldName+"' AND s.selectvalue = "+fieldValue);recordSet.next();returnUtil.null2String(recordSet.getString(1));}

常用发送请求工具类

packagecom.weavernorth.xxg.utils;importorg.apache.commons.logging.Log;importorg.apache.commons.logging.LogFactory;importorg.apache.http.HttpEntity;importorg.apache.http.HttpResponse;importorg.apache.http.NameValuePair;importorg.apache.http.client.HttpClient;importorg.apache.http.client.entity.UrlEncodedFormEntity;importorg.apache.http.client.methods.HttpGet;importorg.apache.http.client.methods.HttpPost;importorg.apache.http.entity.StringEntity;importorg.apache.http.impl.client.HttpClients;importorg.apache.http.message.BasicNameValuePair;importorg.apache.http.util.EntityUtils;importjava.io.*;importjava.net.HttpURLConnection;importjava.net.URL;importjava.nio.charset.StandardCharsets;importjava.util.ArrayList;importjava.util.List;importjava.util.Map;@SuppressWarnings("all")publicclassHttpRequestUtil{privatefinalstaticLoglog=LogFactory.getLog(HttpRequestUtil.class);// 发送 GET 请求publicstaticStringsendGetRequest(Stringurl)throwsIOException{HttpClienthttpClient=HttpClients.createDefault();HttpGethttpGet=newHttpGet(url);HttpResponseresponse=httpClient.execute(httpGet);HttpEntityentity=response.getEntity();returnEntityUtils.toString(entity);}// 发送 POST 请求，表单数据格式（application/x-www-form-urlencoded）publicstaticStringsendPostFormUrlEncodedRequest(Stringurl,Map<String,String>params)throwsIOException{HttpClienthttpClient=HttpClients.createDefault();HttpPosthttpPost=newHttpPost(url);httpPost.setHeader("Content-Type","application/x-www-form-urlencoded");List<NameValuePair>formParams=newArrayList<>();for(Map.Entry<String,String>entry:params.entrySet()){formParams.add(newBasicNameValuePair(entry.getKey(),entry.getValue()));}httpPost.setEntity(newUrlEncodedFormEntity(formParams));HttpResponseresponse=httpClient.execute(httpPost);HttpEntityentity=response.getEntity();returnEntityUtils.toString(entity);}// 发送 POST 请求，JSON 数据格式publicstaticStringsendPostJsonRequest(Stringurl,StringjsonData)throwsIOException{HttpClienthttpClient=HttpClients.createDefault();HttpPosthttpPost=newHttpPost(url);httpPost.setHeader("Content-Type","application/json");httpPost.setEntity(newStringEntity(jsonData));HttpResponseresponse=httpClient.execute(httpPost);HttpEntityentity=response.getEntity();returnEntityUtils.toString(entity);}}