zzdFunction
__ZLuP7RGirprZZ6SCdiX
__ZLuP7RGirprZZ6SCdiX
" + sqlhardwareType);
//var zzd = queryBySQL(sqlhardwareType);
//println("zzd" + zzd)
var datasHardwareType = queryByDSName("baibaodunFlow",sqlhardwareType);
println("datasHardwareType ================>" + datasHardwareType);
if (datasHardwareType.size() > 0) {
for (var iteratordatasHardwareType = datasHardwareType.iterator(); iteratordatasHardwareType.hasNext();) {
var iteratordatasHardwareTypeMap = iteratordatasHardwareType.next();//取值
var t1 = "";
var t2 = "";
var t3 = "";
if ("hardwarePermissions" == name) {
t1 = iteratordatasHardwareTypeMap.get("ITEM_HARDWARETYPE");
t2 = iteratordatasHardwareTypeMap.get("ITEM_HARDWAREAREA");
t3 = iteratordatasHardwareTypeMap.get("ITEM_HARDWAREDOMAINID");
}else if("attendancePermissions" == name) {
t1 = iteratordatasHardwareTypeMap.get("ITEM_ATTENDANCETYPE");
t2 = iteratordatasHardwareTypeMap.get("ITEM_ATTENDANCEAREA");
t3 = iteratordatasHardwareTypeMap.get("ITEM_ATTENDANCEDOMAINID");
}
if (t1 == "指定区域") {
var hardwareSql = 'SELECT t.id,t.ID AS item_ID,t.name as item_name,"' + getDomainid() + '" as domainid FROM obpm2.t_domain as t ,tlk_setsupervise as s WHERE t.ID = s.ITEM_DOMAIN_ID and ('
println('sql =========' + sql);
if (t2.length() <= 0) {
println("进入if");
var res = 'SELECT t.id,t.ID AS item_ID,t.name as item_name,"' + getDomainid() + '" as domainid FROM obpm2.t_domain as t ,tlk_setsupervise as s WHERE 1=2';
return res;
}
var arr = t2.split(";");
var sqlTemp = ''
for (var i = 0; i < arr.length; i++) {
if (i == 0) {
sqlTemp += " s.ITEM_REGISTERADDRESS like '%" + arr[i] + "%' ";
} else {
sqlTemp += " or s.ITEM_REGISTERADDRESS like '%" + arr[i] + "%' ";
}
}
hardwareSql += sqlTemp + ")"
var hardwareSqlDomainIdDatas = queryByDSName(dsName, hardwareSql);
var res = "";
if (hardwareSqlDomainIdDatas != null) {
for (var hardwareSqliterator = hardwareSqlDomainIdDatas.iterator(); hardwareSqliterator.hasNext();) {
var hardwareSqliteratorMap = hardwareSqliterator.next();//取值
var k = hardwareSqliteratorMap.get("id");
res += "'" + k + "',"
}
}
res += "'666'"
return res;
} else {
var res = "";
var t3temp = t3.split(";");
for (var i = 0; i < t3temp.length; i++) {
res += "'" + t3temp[i] + "',"
}
res += "'666'"
return res;
}
}
}
}
]]>
82