获取数据看板
__ekbsagrjF60f5gJnBQQ
__ekbsagrjF60f5gJnBQQ
published
__jLHEtB6BFlMJFn00kUn
UTF-8
post
/getDataBoard
json
" + context);
var type = obj["type"];
if (!isNotNull(type)) {
var result = new Packages.java.util.HashMap(); //创建指定类对象
result.put("code", "-1");
result.put("msg", "必须传参数");
return result;
}
//当前的组织类型
var sbczy = "select '" + getDomainid() + "' as domainid,field15 as item_field15 from obpm2.t_domain where id = '" + getDomainid() + "'"
println("sbczy =========>" + sbczy);
var res = new Packages.java.util.ArrayList();
var jsonUtil = new Packages.cn.myapps.util.json.JsonUtil();
var jg = queryByDSName("obpm2",sbczy);
var field15 = jg.iterator().next().get("item_field15");
println("field15 =======>" + field15)
//数据仓数据看板
var sql3 = "SELECT * from tlk_data_board_v3 where item_isOpen = 1 and item_datatype = '" + type + "' and FIND_IN_SET( '" + field15 + "',REPLACE(item_visible, ';', ',') ) <> 0";
println("sql3 ===============>" + sql3);
var datas1 = queryByDSName("organizationAuth", sql3);
var jsondata = jsonUtil.collection2Json(datas1);
println("jsondata ===============>" + jsondata);
var obj = JSON.parse(jsondata);
for (var i = 0; i < obj.length; i++) {
var sc = obj[i].item_showRule;
var flag = eval("" + sc + "");
println("flag ===============>" + flag);
if (!flag) {
continue;
}
var sql4 = "select * from tlk_data_board_v3_config where item_boardId = '" + obj[i]["id"] + "' and FIND_IN_SET( '" + field15 + "',REPLACE(item_visible, ';', ',') ) <> 0"
var datas4 = queryByDSName("organizationAuth", sql4);
if (datas4.size() > 0) {
var datas4json = jsonUtil.collection2Json(datas4);
var datas4obj = JSON.parse(datas4json);
for (var j = 0; j < datas4obj.length; j++) {
datas4obj[j].item_datascript = "";
}
obj[i].children = datas4obj;
}
}
var r = JSON.stringify(obj);
var re = jsonUtil.toCollection(r);
result.put("code", "0");
result.put("data", re);
return result;
})()]]>