package cn.autoform.util.form;

import cn.autoform.bean.form.CpnType;
import cn.autoform.bean.seache.SeacheConditions;
import cn.autoform.util.tool.ObjectUtil;
import com.alibaba.fastjson.JSON;
import net.sf.json.JSONObject;
import org.apache.commons.lang3.StringUtils;

import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Objects;

/**
 * 自定义条件工具类
 * @author WangYX
 *
 */
@SuppressWarnings("unchecked")
public class AutoConditionUtil {
	
	private static final Map<CpnType, Condition> CONDITION = new HashMap<>();
	
	static{
		// id
		CONDITION.put(CpnType.id, (fildName, valueLeft, valueRight)->{
			if(StringUtils.isNotBlank(Objects.toString(valueLeft, "")) && StringUtils.isNotBlank(Objects.toString(valueRight, ""))){
				return String.format("%s >= %s AND %s <= %s", fildName, escapeSql(valueLeft), fildName, escapeSql(valueRight));
			}
			if(StringUtils.isNoneBlank(Objects.toString(valueLeft, ""))){
				return String.format("%s >= %s", fildName, escapeSql(valueLeft));
			}
			else {
				return String.format("%s <= %s", fildName, escapeSql(valueRight));
			}
		});

		// 单行文本
		CONDITION.put(CpnType.text, (fildName, valueLeft, valueRight)->{
			return String.format("%s LIKE '%%%s%%'", fildName, escapeSql(Objects.toString(valueLeft, "")));
		});
		
		// 生成编号
		CONDITION.put(CpnType.auto, (fildName, valueLeft, valueRight)->{
			return String.format("%s LIKE '%%%s%%'", fildName, escapeSql(Objects.toString(valueLeft, "")));
		});
		
		// 文本域
		CONDITION.put(CpnType.textarea, CONDITION.get(CpnType.text));
		// 金额控件
		CONDITION.put(CpnType.number, (fildName, valueLeft, valueRight)->{
			if(StringUtils.isNotBlank(Objects.toString(valueLeft, "")) && StringUtils.isNotBlank(Objects.toString(valueRight, ""))){
				return String.format("cast(%s as DECIMAL(65,30)) >= cast('%s' as DECIMAL(65,30)) AND cast(%s as DECIMAL(65,30)) <= cast('%s' as DECIMAL(65,30))", fildName, escapeSql(valueLeft), fildName, escapeSql(valueRight));
			}
			if(StringUtils.isNoneBlank(Objects.toString(valueLeft, ""))){
				return String.format("cast(%s as DECIMAL(65,30)) >= cast('%s' as DECIMAL(65,30))", fildName, escapeSql(valueLeft));
			}
			else {
				return String.format("cast(%s as DECIMAL(65,30)) <= cast('%s' as DECIMAL(65,30))", fildName, escapeSql(valueRight));
			}
		});
		// 日期
		CONDITION.put(CpnType.calendar, (fildName, valueLeft, valueRight)->{
			String type = "%Y-%m-%d %H:%i";
			String val = Objects.toString(StringUtils.isNoneBlank(Objects.toString(valueLeft, "")) ? valueLeft : valueRight, "");
			if(val.indexOf('-') >= 1) {
				if (val.length() <= 4) {
					type = "%Y";
				} else if (val.length() <= 7) {
					type = "%Y-%m";
				} else if (val.length() <= 10) {
					type = "%Y-%m-%d";
				}
			}else{
				type = "%H:%i";
			}

			if(StringUtils.isNotBlank(Objects.toString(valueLeft, "")) && StringUtils.isNotBlank(Objects.toString(valueRight, ""))){
				return String.format("str_to_date(%s, '%s') >= str_to_date('%s', '%s') AND  str_to_date(%s, '%s') <= str_to_date('%s', '%s')"
						, fildName, type, escapeSql(valueLeft), type, fildName, type, escapeSql(valueRight), type);
			}
			if(StringUtils.isNoneBlank(Objects.toString(valueLeft, ""))){
				return String.format("str_to_date(%s, '%s') >= str_to_date('%s', '%s')", fildName, type, escapeSql(valueLeft), type);
			}
			else {
				return String.format("str_to_date(%s, '%s') <= str_to_date('%s', '%s')", fildName, type, escapeSql(valueRight), type);
			}
		});
		// 单选按钮
		CONDITION.put(CpnType.radio, (fildName, valueLeft, valueRight)->{
			return String.format("%s = '%%%s%%'", fildName, escapeSql(valueLeft));
		});
		// 复选按钮
		CONDITION.put(CpnType.checkbox, (fildName, valueLeft, valueRight)->{
			if(valueLeft instanceof String){
				return String.format("FIND_IN_SET('%s',%s)", escapeSql(valueLeft), fildName);
			}else if(valueLeft instanceof List){
				StringBuilder sql = new StringBuilder("(");
				((List)valueLeft).stream()
					.forEach(val->{
						sql.append(CONDITION.get(CpnType.checkbox).getSql(fildName, val, null)).append(" OR ");
					});
				sql.delete(sql.length()-" OR ".length(), sql.length());
				return sql.append(')').toString();
			}else{
				return "";
			}
		});
		// 下拉框
		CONDITION.put(CpnType.dropdownlist, CONDITION.get(CpnType.checkbox));
		// 数额控件
		CONDITION.put(CpnType.amount, CONDITION.get(CpnType.number));
		//树控件
        CONDITION.put(CpnType.tree,CONDITION.get(CpnType.checkbox));

	}

	public static String getConditionSql(List<SeacheConditions> conditions){
		if(conditions == null || conditions.size() <= 0)
			return null;
		StringBuilder sql = new StringBuilder();
		conditions.stream().forEach(condition->{

            String where = CONDITION.get(condition.getType()).getCondition(condition);
			if(StringUtils.isBlank(where))
				return;
			sql.append(where).append(" AND ");
		});
		if(sql.length() == 0)
			return null;
		sql.delete(sql.length()-" AND ".length(), sql.length());
		return sql.toString();
	}
	
	public static String escapeSql(Object obj){
		String sql = Objects.toString(obj, "");
		sql = sql.replace("\\", "");
		sql = sql.replace("'", "\\'");
		return sql;
	}
	

	/**
	 * 过滤选项卡。
	 * @param
	 */
	public static void filterOption(JSONObject filedset) {
		String[] tabAndTags = (String[]) filedset.values().stream().filter(AutoConditionUtil::cpnTypeIsTabOrTag).map(val->Objects.toString(((Map)val).get("columnOrderNum"), "")).toArray(String[]::new);
		filedset.entrySet().stream().forEach(val->{
			Map info = ((Map)((Map.Entry)val).getValue());
			String parentsubFormNum = Objects.toString(info.get("parentsubFormNum"));
			if(isContains(tabAndTags, parentsubFormNum)) {
				info.put("parentsubFormNum", 0);
			}
		});
		for(String tabAndTag : tabAndTags) {
			filedset.remove("itemId_"+tabAndTag);
		}
	}
	public static String filterOption(String filedset) {
		com.alibaba.fastjson.JSONObject filedsetObj = JSON.parseObject(filedset);
		String[] tabAndTags = (String[]) filedsetObj.values().stream().filter(AutoConditionUtil::cpnTypeIsTabOrTag).map(val->Objects.toString(((Map)val).get("columnOrderNum"), "")).toArray(String[]::new);
		filedsetObj.entrySet().stream().forEach(val->{
			Map info = ((Map)((Map.Entry)val).getValue());
			String parentsubFormNum = Objects.toString(info.get("parentsubFormNum"));
			if(isContains(tabAndTags, parentsubFormNum)) {
				info.put("parentsubFormNum", 0);
			}
		});
		for(String tabAndTag : tabAndTags) {
			filedsetObj.remove("itemId_"+tabAndTag);
		}
		return filedsetObj.toJSONString();
	}

	public static String toInVal(String val){
		if(ObjectUtil.empty(val)){
			return "''";
		}
		val = escapeSql(val).replace(",", "','");
		return String.format("'%s'", val);
	}

	public static void main(String... args){
		System.out.println(toInVal("a',b"));
	}

	public static boolean isContains(String[] arrays, String str) {
		for(String array : arrays) {
			if(Objects.equals(array, str)) {
				return true;
			}
		}
		return false;
	}
	
	/**
	 * 当前控件是选项卡或者选项卡标签
	 * @param val
	 * @return
	 */
	public static boolean cpnTypeIsTabOrTag(Object val) {
		String type = Objects.toString(((Map)val).get("tag_Type"));
		return Objects.equals(CpnType.tab.toString(), type);
	}
	
	
	@FunctionalInterface
	public static interface Condition{
		
		/**
		 * 获得条件语句
		 * @param
		 * @param
		 * @param
		 * @return
		 */
		default String getCondition(SeacheConditions condition){
			if(StringUtils.isBlank(Objects.toString(condition.getValueLeft(), "")) && StringUtils.isBlank(Objects.toString(condition.getValueRight(), "")))
				return "";
			return getSql(condition.getFieldName(), condition.getValueLeft(), condition.getValueRight());
		}
		
		String getSql(String fildName, Object valueLeft, Object valueRight);
	}
}