package com.smtaiserver.smtaiserver.gismap;

import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import java.util.Map;

import org.dom4j.Element;
import org.dom4j.Node;
import org.dom4j.tree.DefaultText;

import com.smtservlet.util.SMTStatic;


public class SMTMapLayerSqlXml 
{
	///////////////////////////////////////////////////////////////////////////////////////
	private static class SQLXMLExecArg
	{
		public List<Object>  		_sqlParams;
		public StringBuilder 		_sbSQLText = new StringBuilder();
		public Map<String, Object> 	_mapArgs;

		
		public SQLXMLExecArg(Map<String, Object> mapArgs, List<Object> sqlParams)
		{
			_mapArgs = mapArgs;
			_sqlParams = sqlParams;
		}
		
		public Object getArgValue(String key) throws Exception
		{
			if(_mapArgs == null)
				throw new Exception("can't find key : " + key);
			
			Object value = _mapArgs.get(key);
			if(value == null)
				throw new Exception("can't find key : " + key);
			
			return value;
		}
	}

	
	///////////////////////////////////////////////////////////////////////////////////////
	private static abstract class SQLXMLNode
	{
		public abstract void execute(SQLXMLExecArg execArg) throws Exception;
	}

	///////////////////////////////////////////////////////////////////////////////////////

	private static class SQLXMLNodePARAM extends SQLXMLNode
	{
		private String	_key;
		
		public SQLXMLNodePARAM(Element xmlRoot) throws Exception
		{
			_key = SMTStatic.getXmlAttr(xmlRoot, "key");
		}
		
		@Override
		public void execute(SQLXMLExecArg execArg) throws Exception 
		{
			execArg._sbSQLText.append("?");
			execArg._sqlParams.add(execArg.getArgValue(_key));
		}
	}
	
	///////////////////////////////////////////////////////////////////////////////////////

	private static class SQLXMLNodeLIKE_PARAM extends SQLXMLNode
	{
		private String	_key;
		
		public SQLXMLNodeLIKE_PARAM(Element xmlRoot) throws Exception
		{
			_key = SMTStatic.getXmlAttr(xmlRoot, "key");
		}
		
		@Override
		public void execute(SQLXMLExecArg execArg) throws Exception 
		{
			execArg._sbSQLText.append("?");
			execArg._sqlParams.add("%" + execArg.getArgValue(_key) + "%");
		}
	}

	///////////////////////////////////////////////////////////////////////////////////////
	private static class SQLXMLNodeSQL extends SQLXMLNode
	{
		private List<Object>	_listChildren = new ArrayList<>();
		
		public SQLXMLNodeSQL(Element xmlRoot) throws Exception
		{
			for (Iterator<Node> iterInner = xmlRoot.nodeIterator(); iterInner.hasNext();)
			{			
				Node nodeInner = iterInner.next();
				if(nodeInner.getNodeType() == Node.TEXT_NODE)
				{
					String text = ((DefaultText)nodeInner).getText();
					int lastPos = _listChildren.size() - 1;
					if(lastPos >= 0 && _listChildren.get(lastPos) instanceof String)
					{
						_listChildren.set(lastPos, (String)_listChildren.get(lastPos) + text);
					}
					else
					{
						_listChildren.add(text);
					}
				}	
				else
				{
					_listChildren.add(createSQLXMLNode((Element)nodeInner));
				}
			}
		}

		@Override
		public void execute(SQLXMLExecArg execArg) throws Exception
		{
			for(Object oxmlNode : _listChildren)
			{
				if(oxmlNode instanceof String)
				{
					execArg._sbSQLText.append(oxmlNode);
				}
				else if(oxmlNode instanceof SQLXMLNode)
				{
					((SQLXMLNode)oxmlNode).execute(execArg);

				}
			}
		}
	}

	
	///////////////////////////////////////////////////////////////////////////////////////
	private SQLXMLNode				_SQLXMLNode;
	
	private static SQLXMLNode createSQLXMLNode(Element xmlRoot) throws Exception
	{
		String name = xmlRoot.getName().toUpperCase();
		if("DRAW_SQL".equals(name))
			return new SQLXMLNodeSQL(xmlRoot);
		if("SEARCH_SQL".equals(name))
			return new SQLXMLNodeSQL(xmlRoot);		
		if("PARAM".equals(name))
			return new SQLXMLNodePARAM(xmlRoot);
		if("LIKE_PARAM".equals(name))
			return new SQLXMLNodeLIKE_PARAM(xmlRoot);		
		else
			throw new Exception("unknow sqlxml type : " + name);
	}
	
	public SMTMapLayerSqlXml(Element rootElement) throws Exception
	{
		_SQLXMLNode = createSQLXMLNode(rootElement);
	}
	
	public void createSQL(Map<String, Object> mapArgs, StringBuilder sbSQL, List<Object> sqlParams) throws Exception
	{
		SQLXMLExecArg execArg = new SQLXMLExecArg(mapArgs, sqlParams);
		_SQLXMLNode.execute(execArg);

		sbSQL.append(execArg._sbSQLText.toString());
	}
}