【系统版本】: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;
})();
|