|
|
【myApps/OBPM版本号】:4.4stable sp21
【浏览器类型】:Chrome
【技术QQ群】:182378297
【问题描述】:获取提交时填写的意见显示在表单中
STARTNODEID 流程节点Id可以通过查看流程源码获取
【解决方法】:- (function(){
- var sql = "";
- var doc = getCurrentDocument();
- var state = doc.getStateLabel();
- sql = "SELECT DISTINCT '" + getDomainid() + "' AS DOMAINID,NAME AS ITEM_NAME,PROCESSTIME AS ITEM_PROCESSTIME,ATTITUDE AS ITEM_ATTITUDE,SIGNATURE AS ITEM_SIGNATURE FROM T_ACTORHIS T WHERE DOC_ID='" + getId() + "' AND EXISTS( SELECT 1 FROM T_RELATIONHIS WHERE STARTNODEID='1583766936149' AND ID=T.NODEHIS_ID) ORDER BY PROCESSTIME ASC ";
- var count = countBySQL(sql);
- if (count == 0) {
- sql = "SELECT DISTINCT '" + getDomainid() + "' AS DOMAINID,NAME AS ITEM_NAME,PROCESSTIME AS ITEM_PROCESSTIME,ATTITUDE AS ITEM_ATTITUDE,SIGNATURE AS ITEM_SIGNATURE FROM t_flowhistory T WHERE DOC_ID='" + getId() + "' AND STARTNODEID='1583766936149' ORDER BY PROCESSTIME ASC ";
- }
- var str = "";
- var datas = queryBySQL(sql);
- if (datas != null && datas.size() > 0) {
- for (var iter = datas.iterator(); iter.hasNext(); ) {
- var data = iter.next();
- var name = data.getItemValueAsString("NAME");
- var processtime = data.getItemValueAsString("PROCESSTIME");
- var attitude = data.getItemValueAsString("ATTITUDE");
- var signature = data.getItemValueAsString("SIGNATURE");
- if (!isNotNull(attitude)) {
- attitude = "已阅。"
- }
- str += "<div>" + name + "于" + processtime + "填写意见:" + attitude;
- if (isNotNull(signature)) {
- var jsonObject = Packages.net.sf.json.JSONObject.fromObject(signature);
- var imgBase64Code = jsonObject.get("data");
- str += ",手签意见:<img src='data:image/jpg;base64," + imgBase64Code + "' style='height: 70px;'/>";
- }
- str += "</div>"
- }
- }
- return str;
- })();
复制代码 |
|