SendSmsToCompany
__3j9RTG8KsJQtpKlCJ1j
__wGomeHJBz6CpLFCCl4y
企业消息通知
true
10
true
true
false
false
false
relatedForm
month
normal
false
0
__KMqZyRvu6z2mLrWosDP
true
__MC1vBmjn27R7OCEt52C
public
s_theme：" + s_theme + ",s_startDate：" + s_startDate + ",s_endDate：" + s_endDate);
var departmentID = getWebUser().getDefaultDepartment();
if (departmentID != null && departmentID != '') {
var departmentSql = "SELECT '" + getDomainid() + "' AS domainid,id,id as item_id,name as item_name,index_tree as item_indexCode FROM " +
sysfunction.DATASOURCE_OBPM + ".tenant_departments WHERE id='" + departmentID + "'";
println("企业通知-视图SendSmsToCompany-获取部门层级SQL ===>" + departmentSql);
var sqlDatas = queryBySQL(departmentSql);
if (sqlDatas != null) {
var iter = sqlDatas.iterator();
if (iter != null && iter.hasNext()) {
var doc = iter.next();
var indexCode = doc.getItemValueAsString("indexCode");
if (indexCode != null && indexCode != '') {
departmentID = indexCode;
}
}
}
}
var sql = "SELECT '" +
getDomainid() + "' as domainid,formid,applicationid, " +
" ITEM_theme," + //标题
" id," + //消息ID
" id as ITEM_ID," + //消息ID
" ITEM_SENDDATE," + //发送时间
" ITEM_FROMMAN," + //发件人
" ITEM_DEPARTMENTNAME," + //发件机构
" ITEM_STATUS " + //发送状态
" FROM " +
" tlk_sendsmstocompany " +
" WHERE 1=1 ";
if (departmentID != null && departmentID != '') {
sql += " and ITEM_DEPARTMENTID like '" + departmentID + "%'";
}
if (s_theme != null && s_theme != "") {
sql += " and ITEM_theme like '%" + s_theme + "%'";
}
if (s_startDate != null && s_startDate != "") {
sql += " and ITEM_SENDDATE >= '" + s_startDate + "'";
}
if (s_endDate != null && s_endDate != "") {
sql += " and ITEM_SENDDATE <= '" + s_endDate + "'";
}
println("企业通知视图sql========>" + sql);
return sql;
})()]]>
=","type":"03","match":"s_startDate","ipField":"","numField":0,"daField":"","sfField":"s_startDate","syField":""},{"field":"sendDate","operator":"<=","type":"03","match":"s_endDate","ipField":"","numField":0,"daField":"","sfField":"s_endDate","syField":""},{"field":"departmentName","operator":"LIKE","type":"03","ipField":"","numField":0,"daField":"","sfField":"departmentName","syField":"","match":"departmentName"},{"field":"fromMan","operator":"LIKE","type":"03","ipField":"","numField":0,"daField":"","sfField":"fromMan","syField":"","match":"fromMan"}]]]>
[{"_authFields":"authorDefaultDept","_authFieldScope":"allSuperior"}]
293
02
0
0