From e70a362606b78a822e93d5117a9013e8f9086faf Mon Sep 17 00:00:00 2001 From: 秦芳睿 <1425609123@qq.com> Date: 星期二, 22 四月 2025 09:38:38 +0800 Subject: [PATCH] 1 --- JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/core/SMTAIServerEncache.java | 37 ++++++++++++++++++++++++++++++++----- 1 files changed, 32 insertions(+), 5 deletions(-) diff --git a/JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/core/SMTAIServerEncache.java b/JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/core/SMTAIServerEncache.java index 022f276..492f638 100644 --- a/JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/core/SMTAIServerEncache.java +++ b/JAVA/SMTAIServer/src/main/java/com/smtaiserver/smtaiserver/core/SMTAIServerEncache.java @@ -11,6 +11,7 @@ import org.springframework.beans.factory.annotation.Value; import org.springframework.cache.annotation.Cacheable; +import com.smtaiserver.smtaiserver.attach.SMTAIAttachMetricDef; import com.smtaiserver.smtaiserver.attach.SMTAIAttachTableDef; import com.smtaiserver.smtaiserver.database.SMTDatabase; import com.smtaiserver.smtaiserver.database.SMTDatabase.DBQueryNotify; @@ -54,7 +55,7 @@ public CoordinateTransform[] getGisTransform() throws Exception { String gisProjParam = (String)SMTAIServerApp.getApp().getGlobalConfig("gis.proj.src", "+proj=longlat +datum=WGS84 +no_defs"); - String mapProjParam = (String)SMTAIServerApp.getApp().getGlobalConfig("gis.proj.tag"); + String mapProjParam = (String)SMTAIServerApp.getApp().getGlobalConfig("gis.proj.tag", "+proj=longlat +datum=WGS84 +no_defs"); CRSFactory crsFactory = new CRSFactory(); CoordinateTransformFactory ctFactory = new CoordinateTransformFactory(); @@ -294,15 +295,16 @@ try { - // 璇诲彇鎵�鏈塧mis鐨刟gent - db.querySQLNotify( + String sql = " SELECT agent_id,agent_type,agent_xml,clz_name,clz_arguments, group_type, agent_title, agent_group, agent_order,inner_call" + " FROM ai_agent_amis A" + " LEFT JOIN ai_scene_group G ON A.agent_group = G.group_id" + " WHERE " + (debugMode ? " agent_order > 0 OR is_debug='Y'" : "agent_order > 0 AND is_debug IS NULL") + " ORDER BY abs(agent_order)" - , null, - new DBQueryNotify() { + ; + + // 璇诲彇鎵�鏈塧mis鐨刟gent + db.querySQLNotify(sql, null, new DBQueryNotify() { @Override public boolean onNextRecord(DBRecord rec) throws Exception { @@ -607,4 +609,29 @@ } return mapResult; } + + @Cacheable(value="getAttachMetricDefMap") + public Map<String, SMTAIAttachMetricDef> getAttachMetricDefMap() throws Exception + { + Map<String, SMTAIAttachMetricDef> mapResult = new HashMap<>(); + SMTDatabase db = SMTAIServerApp.getApp().allocDatabase(); + try + { + DBRecords recs; + + recs = db.querySQL("SELECT * FROM ai_attach_metric", null); + for(DBRecord rec : recs.getRecords()) + { + SMTAIAttachMetricDef attachMetricDef = new SMTAIAttachMetricDef(rec); + mapResult.put(attachMetricDef.getId(), attachMetricDef); + } + + } + finally + { + db.close(); + } + return mapResult; + } + } -- Gitblit v1.9.3