天翎MyApps技术社区 - 低代码平台 | 流程管理系统 | BPM软件

 找回密码
 注册成为天翎用户
查看: 660|回复: 0

[常见问题] 流程节点Id如何通过查看流程源码获取

[复制链接]
lingling17 发表于 2020-12-24 17:02:03 | 显示全部楼层 |阅读模式
【myApps/OBPM版本号】:4.4stable sp21
【浏览器类型】:Chrome
【技术QQ群】:182378297
【问题描述】:获取提交时填写的意见显示在表单中
STARTNODEID 流程节点Id可以通过查看流程源码获取

【解决方法】:
  1. (function(){
  2.     var sql = "";
  3.     var doc = getCurrentDocument();
  4.     var state = doc.getStateLabel();
  5.     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 ";
  6.     var count = countBySQL(sql);
  7.     if (count == 0) {
  8.         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 ";
  9.     }
  10.     var str = "";
  11.     var datas = queryBySQL(sql);
  12.     if (datas != null && datas.size() > 0) {
  13.         for (var iter = datas.iterator(); iter.hasNext(); ) {
  14.             var data = iter.next();
  15.             var name = data.getItemValueAsString("NAME");
  16.             var processtime = data.getItemValueAsString("PROCESSTIME");
  17.             var attitude = data.getItemValueAsString("ATTITUDE");
  18.             var signature = data.getItemValueAsString("SIGNATURE");
  19.             if (!isNotNull(attitude)) {
  20.                 attitude = "已阅。"
  21.             }
  22.             str += "<div>" + name + "于" + processtime + "填写意见:" + attitude;
  23.             if (isNotNull(signature)) {
  24.                 var jsonObject = Packages.net.sf.json.JSONObject.fromObject(signature);
  25.                 var imgBase64Code = jsonObject.get("data");
  26.                 str += ",手签意见:<img src='data:image/jpg;base64," + imgBase64Code + "' style='height: 70px;'/>";
  27.             }
  28.             str += "</div>"
  29.         }
  30.     }
  31.     return str;
  32. })();
复制代码

本版积分规则

QQ|手机版|天翎MyApps技术社区 ( 粤ICP备11093750号 )

GMT+8, 2026-8-12 08:38

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表