数据看板分类
__ekbsagrjF60f5gJnBQQ
__ekbsagrjF60f5gJnBQQ
published
__jLHEtB6BFlMJFn00kUn
UTF-8
post
/getdataboardcategory
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 from obpm2_security.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("organizationAuth",sbczy);
var field15 = jg.iterator().next().get("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 item_datasource = obj[i].item_datasource;
while (sc.indexOf('(') != -1 || sc.indexOf(')') != -1) {
sc = sc.replace('(', '(');
sc = sc.replace(')', ')');
}
println("显示规则 flag ===============>" + sc);
var flag = eval("" + sc + "");
println("flag ===============>" + flag);
if (!flag) {
obj.splice(i,1);
i--;
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 order by item_sort"
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;
})()]]>