Sourcecode in SysMgr/objectFunctions.js:
1: function searchSyslog(show, order, keywords) {
2: // construct the sql-clause for manual subnodeRelation
3: var sql = "";
4: if (show == "1")
5: sql += "WHERE SYSLOG_TYPE = 'site' ";
6: else if (show == "2")
7: sql += "WHERE SYSLOG_TYPE = 'user' ";
8: else if (show == "3")
9: sql += "WHERE SYSLOG_TYPE = 'system' ";
10: if (keywords) {
11: // additional keywords are given, so we're using them
12: var kArray = stripTags(keywords).split(" ");
13: for (var i in kArray) {
14: var k = kArray[i];
15: sql += sql.length > 0 ? "AND " : "WHERE ";
16: sql += "(SYSLOG_OBJECT LIKE '%" + k + "%' OR SYSLOG_ENTRY LIKE '%" + k + "%') ";
17: }
18: }
19: if (!order || order == "0")
20: sql += "ORDER BY SYSLOG_CREATETIME desc, SYSLOG_ID desc ";
21: else if (order == "1")
22: sql += "ORDER BY SYSLOG_CREATETIME asc, SYSLOG_ID asc ";
23:
24: // now do the actual search with a manual subnodeRelation
25: this.syslogs.subnodeRelation = sql;
26: return;
27: }
|