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