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

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

[已解决] 如何获取提交时填写的意见显示在表单中?

[复制链接]
T33 发表于 2020-12-14 16:21:34 | 显示全部楼层 |阅读模式

【系统版本】:4.4stable sp21
【浏览器类型】:Chrome
问题描述:如何获取提交时填写的意见显示在表单中?
解决方法: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;
})();

本版积分规则

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

GMT+8, 2026-8-12 06:34

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

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