TangCheng
2025-03-06 e933aeca811ee130c91f7d20c6a5f17712d2ba51
Merge branch 'master' into work_weixin
已修改3个文件
58 ■■■■■ 文件已修改
JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/attach/SMTAttachTableSqlXml.java 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/control/SMTSystemManagerControl.java 36 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
JAVA/SMTAIServer/src/main/resources/requestmap/system_manager.json 20 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
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 '" 
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);
    }
}
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" : [
                ]
            }
        ]
    }
}