From e933aeca811ee130c91f7d20c6a5f17712d2ba51 Mon Sep 17 00:00:00 2001 From: TangCheng <tangchengmail@163.com> Date: 星期四, 06 三月 2025 17:00:19 +0800 Subject: [PATCH] Merge branch 'master' into work_weixin --- JAVA/SMTAIServer/src/main/resources/requestmap/system_manager.json | 20 ++++++++++++++++++++ JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/attach/SMTAttachTableSqlXml.java | 2 +- JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/control/SMTSystemManagerControl.java | 36 ++++++++++++++++++++++++++++++++++++ 3 files changed, 57 insertions(+), 1 deletions(-) diff --git a/JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/attach/SMTAttachTableSqlXml.java b/JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/attach/SMTAttachTableSqlXml.java index e1d4825..3e935b3 100644 --- a/JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/attach/SMTAttachTableSqlXml.java +++ b/JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/attach/SMTAttachTableSqlXml.java @@ -126,7 +126,7 @@ { sbWHERE.append(column + " LIKE '%" + values.get(0).asString().replace("'", "''") + "%'"); } - else if("timerange".equals(filter)) + else if("time_range".equals(filter)) { sbWHERE.append( column + " BETWEEN '" + values.get(0).asString().replace("'", "''") + "'::timestamp AND '" diff --git a/JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/control/SMTSystemManagerControl.java b/JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/control/SMTSystemManagerControl.java index 5dc944b..c229c5f 100644 --- a/JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/control/SMTSystemManagerControl.java +++ b/JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/control/SMTSystemManagerControl.java @@ -15,6 +15,7 @@ import com.smtaiserver.smtaiserver.database.SMTDatabase; import com.smtaiserver.smtaiserver.database.SMTDatabase.DBRecord; import com.smtaiserver.smtaiserver.database.SMTDatabase.DBRecords; +import com.smtservlet.core.SMTApp; import com.smtservlet.util.SMTJsonWriter; import com.smtservlet.util.SMTStatic; @@ -730,4 +731,39 @@ db.close(); } } + + + public ModelAndView clearSystemCache(SMTAIServerRequest tranReq) throws Exception + { + SMTApp.getThis().clearEhCacheManager(); + return tranReq.returnJsonState(true, null, null); + } + + + public ModelAndView getQuestionReplaceList(SMTAIServerRequest tranReq) throws Exception + { + SMTJsonWriter jsonWr = tranReq.newReturnJsonWriter(true, null, null); + try(SMTDatabase db = SMTAIServerApp.getApp().allocDatabase()) + { + DBRecords recs = db.querySQL("SELECT * FROM ai_question_replace", null); + + jsonWr.beginArray("values"); + for(DBRecord rec : recs.getRecords()) + { + jsonWr.beginMap(null); + { + jsonWr.addKeyValue("id", rec.getString("replace_id")); + jsonWr.addKeyValue("question", rec.getString("question_text")); + jsonWr.addKeyValue("replace", rec.getString("replace_text")); + jsonWr.addKeyValue("order", rec.getString("replace_order")); + jsonWr.addKeyValue("state", rec.getString("replace_state")); + jsonWr.addKeyValue("group", rec.getString("group_type")); + jsonWr.addKeyValue("create_time", rec.getString("create_time")); + } + jsonWr.endMap(); + } + jsonWr.endArray(); + } + return tranReq.returnJson(jsonWr); + } } diff --git a/JAVA/SMTAIServer/src/main/resources/requestmap/system_manager.json b/JAVA/SMTAIServer/src/main/resources/requestmap/system_manager.json index 66a4e2a..951f679 100644 --- a/JAVA/SMTAIServer/src/main/resources/requestmap/system_manager.json +++ b/JAVA/SMTAIServer/src/main/resources/requestmap/system_manager.json @@ -197,5 +197,25 @@ ] } ] + }, + + "admin/system/clear_system_cache":{"map":{"class":"#SMTSystemManagerControl", "method":"clearSystemCache"}, + "swaggers":[ + { "tags" : ["绯荤粺绠$悊"], + "title" : "娓呴櫎缂撳瓨", + "parameters" : [ + ] + } + ] + }, + + "admin/system/get_question_replace_list":{"map":{"class":"#SMTSystemManagerControl", "method":"getQuestionReplaceList"}, + "swaggers":[ + { "tags" : ["瀵硅瘽绠$悊"], + "title" : "鏌ョ湅", + "parameters" : [ + ] + } + ] } } \ No newline at end of file -- Gitblit v1.9.3