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