设施装备
__WuYlaui56D7zhPn8OUs
__DOoeSJp26wVqbyYYf50
设施装备
true
30
true
false
false
false
2023-05-21T20:57:44.000+08:00
true
relatedForm
month
normal
false
0
__NjP2zju2MAc3lHehuut
true
__0Ow94lY3ya8iaE6wiki
public
" + institutionalCode);
var sql = "select id,";
if(isSuperviseInstitution(institutionalCode)){
sql += "domainid,";
}else{
sql += "item_domain_id as domainid,";
}
sql += "formid,applicationid,id as item_id,"+
"item_domain_id,"+ //企业id
"item_record_id,"+ // 原v5id
"item_equip_type,"+ //设备类型
"item_equip_no,"+//设备编号
"item_equip_name,"+ // 设备名称
"item_equip_total,"+ //设备总数据量
"item_first_storage_time,"+ //首次入库日期
"item_domain_name,"+ //所属企业
"item_company_police,"+//监管名称
"item_company_police_code "+//监管编号
" from tlk_device "+
" where 1=1 "
var equip_type = getItemValueAsString("equip_type");
var equip_no = getItemValueAsString("equip_no");
var equip_name = getItemValueAsString("equip_name");
var domain_name = getItemValueAsString("domain_name");
var first_storage_start = getItemValueAsDate("first_storage_start");
var first_storage_end = getItemValueAsDate("first_storage_end");
var superviseOfficeId = getItemValueAsString("s_superviseOfficeId");
if(isNotNull(superviseOfficeId)){
var childrenArr = "";
childrenArr = getSubordinateRegulatorId(superviseOfficeId,getDepartmentDs());
if(isNotNull(childrenArr)){
sql += " and item_company_police_code in " + childrenArr;
}
}
//else {
// sql += " and 1=2 ";
//}
if(isNotNull(equip_type)){
sql += "AND item_equip_type = '"+equip_type+"'";
}
if(isNotNull(equip_no)){
sql += "AND item_equip_no like '%"+equip_no+"%'";
}
if(isNotNull(equip_name)){
sql += "AND item_equip_name like '%"+equip_name+"%'";
}
if(isNotNull(domain_name)){
sql += "AND item_domain_name like '%"+domain_name+"%'";
}
if(isNotNull(first_storage_start)){
sql += "and item_first_storage_time >= '"+format(first_storage_start,"yyyy-MM-dd")+"' ";
}
if(isNotNull(first_storage_end)){
sql += "and item_first_storage_time <= '"+format(first_storage_end,"yyyy-MM-dd")+"' ";
}
// sql+=" order by item_created desc "
println(sql)
return sql;
})()]]>
[]
293
02
0
0