package com.product.org.admin.util;

import java.util.LinkedList;
import java.util.List;
import java.util.Map;

public class Parser {

	/**
	 * SQL条件写法: a.bb>=bc,and b.cc<=b,and b.cc=b,and b.cc<>b, or ee like be,and yy=?
	 * @param select
	 * @param where
	 * @param srcParam
	 * @return SqlParam      
	 * @throws
	 */
	public static SqlParam sqlAndParamParser(String select,String where,String lastWhere,Map<Object,Object> srcParam){
		long startTime = System.currentTimeMillis();
		StringBuffer sqlSelect = new StringBuffer(select);
		List<Object> paramList = new LinkedList<>();
		sqlAndParamParser(where, srcParam, sqlSelect, paramList);
		String sql = deleteAndOr(sqlSelect);
		System.out.println("useTime="+(System.currentTimeMillis()-startTime)+"ms");
		return new SqlParam(sql+(lastWhere!=null?lastWhere:""),paramList.toArray());
	}

	/**
	 * SQL条件写法: a.bb>=bc,and b.cc<=b,and b.cc=b,and b.cc<>b, or ee like be,and yy=?
	 * @param select
	 * @param where
	 * @param srcParam
	 * @return SqlParam      
	 * @throws
	 */
	public static SqlParam sqlAndParamParser(String select,String where,Map<Object,Object> srcParam){
		long startTime = System.currentTimeMillis();
		StringBuffer sqlSelect = new StringBuffer(select);
		List<Object> paramList = new LinkedList<>();
		sqlAndParamParser(where, srcParam, sqlSelect, paramList);
		String sql = deleteAndOr(sqlSelect);
		System.out.println("useTime="+(System.currentTimeMillis()-startTime)+"ms");
		return new SqlParam(sql,paramList.toArray());
	}
	
	private static void sqlAndParamParser(String where,Map<Object, Object> srcParam, StringBuffer sqlSelect,List<Object> paramList) {
		String[] whereList = where.split(",");
		for (String str : whereList) {
			if(str.contains("=")){
				equals(srcParam, paramList, sqlSelect, str);
			}else if(str.contains("<=")){
				minAndEquals(srcParam, paramList, sqlSelect, str);
			}else if(str.contains("<>")||str.contains("!=")){
				notEquals(srcParam, paramList, sqlSelect, str);
			}else if(str.contains(">=")){
				maxAndEquals(srcParam, paramList, sqlSelect, str);
			}else if(str.contains(">")){
				max(srcParam, paramList, sqlSelect, str);
			}else if(str.contains("<")){
				min(srcParam, paramList, sqlSelect, str);
			}else if(str.contains("like")){
				like(srcParam, paramList, sqlSelect, str);
			}
		}
	}


	private static String deleteAndOr(StringBuffer sqlSelect) {
		String sql = sqlSelect.toString();
		if(sql.startsWith("or"))sql = sql.replace("or", "");
		if(sql.startsWith("and"))sql = sql.replace("and", "");
		return sql;
	}
	
	private static void equals(Map<Object, Object> srcParam,List<Object> paramList, StringBuffer sqlSelect, String str) {
		String[] eps = str.split("=");
		String key = findParamKey(eps);
		if(!isEmpty(srcParam.get(key))){
			sqlSelect.append(eps[0]+"= ? ");
			paramList.add(srcParam.get(key));
		}
	}


	private static String findParamKey(String[] eps) {
		if(eps[1].contains("?")){
			String aa = eps[0].replace("and","").replace("or", "");
			String[] ss = aa.split("\\.");
			return ss.length>1?ss[1].trim():ss[0].trim();
		}else{
			return eps[1].trim();
		}
	}
	
	private static void like(Map<Object, Object> srcParam,List<Object> paramList, StringBuffer sqlSelect, String str) {
		String[] eps = str.split("like");
		String key = findParamKey(eps);
		if(!isEmpty(srcParam.get(key))){
			sqlSelect.append(eps[0]+"like ? ");
			paramList.add("%"+srcParam.get(key)+"%");
		}
	}

	private static void min(Map<Object, Object> srcParam, List<Object> paramList, StringBuffer sqlSelect, String str) {
		String[] eps = str.split("<");
		String key = findParamKey(eps);
		if(!isEmpty(srcParam.get(key))){
			sqlSelect.append(eps[0]+"<? ");
			paramList.add(srcParam.get(key));
		}
	}

	private static void max(Map<Object, Object> srcParam, List<Object> paramList, StringBuffer sqlSelect, String str) {
		String[] eps = str.split(">");
		String key = findParamKey(eps);
		if(!isEmpty(srcParam.get(key))){
			sqlSelect.append(eps[0]+">? ");
			paramList.add(srcParam.get(key));
		}
	}

	private static void notEquals(Map<Object, Object> srcParam, List<Object> paramList, StringBuffer sqlSelect, String str) {
		String[] eps = str.split("<>");
		String key = findParamKey(eps);
		if(!isEmpty(srcParam.get(key))){
			sqlSelect.append(eps[0]+"<>? ");
			paramList.add(srcParam.get(key));
		}
	}

	private static void minAndEquals(Map<Object, Object> srcParam, List<Object> paramList, StringBuffer sqlSelect, String str) {
		String[] eps = str.split("<=");
		String key = findParamKey(eps);
		if(!isEmpty(srcParam.get(key))){
			sqlSelect.append(eps[0]+"<=? ");
			paramList.add(srcParam.get(key));
		}
	}

	private static void maxAndEquals(Map<Object, Object> srcParam, List<Object> paramList, StringBuffer sqlSelect, String str) {
		String[] eps = str.split(">=");
		String key = findParamKey(eps);
		if(!isEmpty(srcParam.get(key))){
			sqlSelect.append(eps[0]+">=? ");
			paramList.add(srcParam.get(key));
		}
	}

	@SuppressWarnings("rawtypes")
	public static boolean isEmpty(Object obj){
		if(obj==null){
			return true;
		}
		if(obj instanceof String){
			return "".equals(obj.toString());
		}
		if(obj instanceof List){
			return ((List)obj).isEmpty();
		}
		if(obj instanceof Map){
			return ((Map)obj).isEmpty();
		}
		return false;
	}
}