如何获取协办和主办的意见、时间、签名

【myApps/OBPM版本号】：v5.X- sp XX
【浏览器类型】：Chrome/其他
【联系方式-QQ】：请留下您的QQ号码
【联系电话】:    请留下您的联系电话，以便技术同事更好解决您的问题
【问题描述】：如何获取流程中添加协办和主办的意见、时间、签名









1、问题描述最好图文并茂，如有视频/脚本可直接放出，这样技术同事在处理该问题时效率更加高效哦~
2、如果该问题已得到解决，请在该帖子下回复\\\\\\\"已解决可结帖\\\\\\\"

可以试试这个
其中：FLOWOPERATION 91是协办，80也是主办的
http://www.teemlink.com/bbs/foru ... 5&fromuid=55283

yaya 发表于 2026-2-25 09:37
可以试试这个
其中：FLOWOPERATION 91是协办，80也是主办的
http://www.teemlink.com/bbs/forum.php?mod= ...

这个是使用计算脚本获取还是文本框获取？
还有 STARTNODEID 流程节点id，是看流程源代码中的<name>设置了协办或者主办名称</name>的STARTNODEID吗？

zxc1 发表于 2026-2-28 08:51
这个是使用计算脚本获取还是文本框获取？
还有 STARTNODEID 流程节点id，是看流程源代码中的设置了协办 ...

用计算脚本获取
sql部分：
sql = "SELECT '" + getDomainid() + "' AS DOMAINID,T.NAME AS ITEM_NAME,T.PROCESSTIME AS ITEM_PROCESSTIME,T.ATTITUDE AS ITEM_ATTITUDE,rehis.flowoperation AS ITEM_FLOWOPERATION,rehis.startnodename item_startnodename FROM T_ACTORHIS T join T_RELATIONHIS rehis on T.NODEHIS_ID = rehis.ID WHERE DOC_ID='" + getId() + "' AND EXISTS( SELECT 1 FROM T_RELATIONHIS WHERE ID=T.NODEHIS_ID) AND FLOWOPERATION in ('80','7','84','91','添加/补签意见') ORDER BY T.PROCESSTIME ASC ";
    var count = countBySQL(sql);       
        //流程结束的sql
    if (count == 0) {
        sql = "SELECT '" + getDomainid() + "' AS DOMAINID,NAME AS ITEM_NAME,PROCESSTIME AS ITEM_PROCESSTIME,ATTITUDE AS ITEM_ATTITUDE,flowoperation as item_flowoperation,STARTNODENAME  item_startnodename FROM t_flowhistory T WHERE DOC_ID='" + getId() + "' AND FLOWOPERATION in ('80','7','84','91','添加/补签意见') ORDER BY PROCESSTIME ASC ";
                println("流程结束t_flowhistory的sql:::"+sql);
    }

yaya 发表于 2026-3-24 13:54
用计算脚本获取
sql部分：
sql = "SELECT '" + getDomainid() + "' AS DOMAINID,T.NAME AS ITEM_NAME,T ...

好谢谢，签名能出来，但是意见和时间这个怎么获取？

zxc1 发表于 2026-3-24 15:23
好谢谢，签名能出来，但是意见和时间这个怎么获取？

(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 ";
         sql = "SELECT DISTINCT '" + getDomainid() + "' AS DOMAINID,T.NAME AS ITEM_NAME,T.PROCESSTIME AS ITEM_PROCESSTIME,T.ATTITUDE AS ITEM_ATTITUDE,rehis.flowoperation AS ITEM_FLOWOPERATION,rehis.startnodename item_startnodename FROM T_ACTORHIS T join T_RELATIONHIS rehis on T.NODEHIS_ID = rehis.ID WHERE DOC_ID='" + getId() + "' AND EXISTS( SELECT 1 FROM T_RELATIONHIS WHERE ID=T.NODEHIS_ID) AND FLOWOPERATION in ('80','7','84','91','添加/补签意见') ORDER BY T.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 ";
                sql = "SELECT DISTINCT '" + getDomainid() + "' AS DOMAINID,NAME AS ITEM_NAME,PROCESSTIME AS ITEM_PROCESSTIME,ATTITUDE AS ITEM_ATTITUDE,flowoperation as item_flowoperation,STARTNODENAME  item_startnodename FROM t_flowhistory T WHERE DOC_ID='" + getId() + "' AND FLOWOPERATION in ('80','7','84','91','添加/补签意见') 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;
})();

var processtime = data.getItemValueAsString("PROCESSTIME");
var attitude = data.getItemValueAsString("ATTITUDE");
var signature = data.getItemValueAsString("SIGNATURE");

yaya 发表于 2026-3-24 15:57
(function(){
    var sql = "";
    var doc = getCurrentDocument();

好的，谢谢，已解决