获取工作台3.0数据
__ekbsagrjF60f5gJnBQQ
__ekbsagrjF60f5gJnBQQ
published
__PrYyityiTHktsWHhsU0
UTF-8
get
/getWorkbench3
json
" + field15)
//数据仓数据看板
var sql3 = "SELECT * from tlk_data_board_v3_config where item_datatype = '1' and item_boardName = '" + query + "' and FIND_IN_SET( '" + field15 + "',REPLACE(item_visible, ';', ',') )>0 and ITEM_BOARDID in ( select id from tlk_data_board_v3 where FIND_IN_SET( '" + field15 + "', REPLACE ( item_visible, ';', ',' ) )>0)";
println("sql3 ===============>" + sql3);
var datas1 = queryByDSName("organizationAuth", sql3);
var datas1 = jsonUtils.collection2Json(datas1);
var datas1Sjon = JSON.parse(datas1);
println("datas1 ==================>" + datas1);
for (var i = 0; i " + item_dataSource);
println("item_dataScript ==================>" + item_dataScript);
item_dataScript = item_dataScript.replace('（', '(');
item_dataScript = item_dataScript.replace('）', ')');
//替换条件
if (item_dataScript.indexOf('#') != -1) {
//获取当前组织
var sqlDomainData = "select * from obpm2.tenant_organizations where id ='" + getDomainid() + "'";
println("sqlDomainData ========================== " + sqlDomainData);
var datasDomain = queryByDSName("organizationAuth", sqlDomainData);
var datasDomainStr = jsonUtils.collection2Json(datasDomain);
var datasDomainJSON = JSON.parse(datasDomainStr);
for (var k in datasDomainJSON[0]) {
item_dataScript = item_dataScript.replace("#{" + k + "}", "'" + datasDomainJSON[0]["" + k + ""] + "'");
}
}
println("item_showrule ===========>" + item_showRule);
//显示条件是否有参数 拼接参数后再判断
if (item_showRule.indexOf('#{result}') != -1) {
var ddata = queryByDSName(item_dataSource+"", item_dataScript);
var result = ddata;
println("result ===========>" + result);
var result = jsonUtils.collection2Json(result)
var sc = item_showRule.replace('#{result}', result);
var flag = eval("" + sc + "");
if (!flag) {
continue;
}
}
// 直接判断
var sc = item_showRule;
var flag = eval("" + sc + "");
println("flag ===============>" + flag);
if (!flag) {
continue;
}
//执行查询
var ddata = queryByDSName(item_dataSource, item_dataScript);
println("ddata ==================>" + ddata);
var datamap = new Packages.java.util.HashMap();
//添加数据标题
datamap.put("title", item_title);
//添加数据
datamap.put("data", ddata);
//添加结果到数组中
res.add(datamap);
println("执行" + i + "次");
}
var result = new Packages.java.util.HashMap();
/*
println("res ==================>" + res);
var res = JSON.stringify(res);
var res = jsonUtils.toCollection(res);
*/
result.put('code', 0)
result.put('data', res)
return result;
})()]]>