package com.smtaiserver.smtaiserver.javaai.duckdb;

import java.util.ArrayList;
import java.util.List;

import com.smtaiserver.smtaiserver.core.SMTAIServerRequest;
import com.smtaiserver.smtaiserver.database.SMTDatabase;
import com.smtaiserver.smtaiserver.database.SMTDatabase.DBRecord;
import com.smtaiserver.smtaiserver.database.SMTDatabase.DBRecords;
import com.smtservlet.util.SMTJsonWriter;
import com.smtservlet.util.SMTStatic;

@SuppressWarnings("unused")
public class DuckMergeGroupSummary extends DuckMergeGroup
{
	public List<DuckCubeRecs>	_listCubeRecs = new ArrayList<>();
	
	
	private String getStartDate()
	{
		for(DuckCubeRecs cubeRecs : _listCubeRecs)
		{
			if(cubeRecs._timeRange != null && cubeRecs._timeRange._startTime != null)
				return SMTStatic.toString(cubeRecs._timeRange._startTime).substring(0, 11);
		}
		
		return "";
	}
	
	@Override
	public void outputGroupToJson(String agentKey, SMTAIServerRequest tranReq) throws Exception
	{
		SMTJsonWriter jsonWrResult = tranReq.getResultJsonWr();
		SMTDatabase dbResult = tranReq.getResultDB();
		
		jsonWrResult.beginMap(null);
		{
			jsonWrResult.addKeyValue("type", "summary");
			jsonWrResult.addKeyValue("agent_key", agentKey);
			jsonWrResult.addKeyValue("title", _title);
			jsonWrResult.beginArray("values");
			{
				for(DuckCubeRecs cubeRecs : _listCubeRecs)
				{
					DBRecords recs = dbResult.querySQL("SELECT * FROM " + cubeRecs._tableName, null);
					
					for(DBRecord rec : recs.getRecords())
					{
						jsonWrResult.beginMap(null);
						{
							jsonWrResult.addKeyValue("title", cubeRecs._title + (cubeRecs._chartUnit == null ? "" : cubeRecs._chartUnit));
							jsonWrResult.addKeyValue("value", rec.getString(0));
						}
						jsonWrResult.endMap();
					}
				}
			}
			jsonWrResult.endArray();
		}
		jsonWrResult.endMap();
	}

}