警情管理
__Y9NJedGm7mb2fIznfzU
__xDl55yOVZI8fuZnYzig
true
30
true
false
false
false
true
relatedForm
month
normal
false
0
__5et0kwRmjNvFp25DQ12
true
public
= '" + p_date + " 00:00:00' and created_time <='" + p_date + " 23:59:59' ";
}
var s_emp_name = getItemValueAsString("s_emp_name");
var s_startDate = getItemValueAsString("s_startDate");
var s_endDate = getItemValueAsString("s_endDate");
var s_source = getItemValueAsString("s_source");
var s_category = getItemValueAsString("s_category");
var s_region = getItemValueAsString("s_region");
if(isNotNull(s_emp_name)){
sql += " and emp_name like '%" + s_emp_name + "%' ";
}
if(isNotNull(s_startDate)){
//created_time有索引
sql += " and created_time >= '" + s_startDate + " 00:00:00' ";
}
if(isNotNull(s_endDate)){
sql += " and created_time <= '" + s_endDate + " 23:59:59' ";
}
if(isNotNull(s_source) && '后台录入'.equals(s_source)){
sql += " and 1=2 ";
}
if(isNotNull(s_category)){
sql += " and category = '" + s_category + "' ";
}
if(isNotNull(s_region)){
sql += " and address like '%" + s_region + "%' ";
}
println("警情管理sql==" + sql);
return sql;
})()]]>
[]
1
02
0
0