package foundation.translator;

import java.sql.Types;
import java.util.HashMap;
import java.util.Map;


public enum ValueType {  

	Void, Int, Long, Double, Decimal, Date, String, Boolean, Entity, EntitySet,
	Float, List, Null;

	public static ValueType parse(int value) {
		ValueType type = sqlTypeValueTypeMap.get(value);
		
		if (type == null) {
			type = String;
		}
		
		return type;
	}

	public static ValueType parse(String value) {
		if (value == null) {
			return String;
		}
		
		value = value.trim().toLowerCase();
		ValueType type = stringValueTypeMap.get(value);
		
		if (type == null) {
			type = String;
		}		
		
		return type;
	}
	
	public String toJavaScriptType() {
		int no = ordinal();

		if (no == 0) {
			return "String";
		}
		else if (no == 1) {
			return "integer";
		}
		else if (no == 2) {
			return "double";
		}
		else if (no == 3) {
			return "date";
		}
		else if (no == 4) {
			return "boolean";
		}

		return "String";
	}

	public Class<?> toJavaClass() {
		Class<?> result = valueTypeJavaClassMap.get(this);
		
		if (result == null) {
			result = String.getClass();
		}
		
		return result;
	}

	public int toSQLType() {
		if (Int == this) {
			return Types.INTEGER;
		}
		else if (Double == this) {
			return Types.NUMERIC;
		}	
		else if (Date == this) {
			return Types.DATE;
		}	
		else if (Boolean == this) {
			return Types.BIT;
		}		
		else {
			return Types.VARCHAR;
		}
	}
	
	public java.lang.String toDBType() {
        return sqlTypeDBStringMap.get(this);
	}

    public boolean isNumber() {
        if (ValueType.Int == this) {
            return true;
        } 
        else if (ValueType.Long == this) {
            return true;
        } 
        else if (ValueType.Double == this) {
            return true;
        } 
        else if (ValueType.Float == this) {
            return true;
        } 
        else {
            return ValueType.Decimal == this;
        }
    }

	public boolean isDate() {
		return this == Date; 
	}
    
    public ValueLength getDefaultLength() {
        ValueLength valueLength = new ValueLength(0);
        switch (this) {
            case String:
                valueLength.setLength(32);
        break;
            case Int:
            case Long:
                valueLength.setLength(11);
                break;
            case Boolean:
                valueLength.setLength(1);
                break;
            case Float:
            case Double:
                valueLength.setLength(8);
                valueLength.setDecimalLength(3);
                break;
            case Decimal:
                valueLength.setLength(20);
                valueLength.setDecimalLength(4);
                break;
            default:
                break;

        }
        return valueLength;
    }
	
    private static Map<ValueType, String> sqlTypeDBStringMap;
    private static Map<String, ValueType> stringValueTypeMap;
    private static Map<Integer, ValueType> sqlTypeValueTypeMap;
    private static Map<ValueType, Class<?>> valueTypeJavaClassMap;
    
    static {
    	//
    	initSQLTypeDBStringMap();
        
        //
        initStringValueTypeMap();
        
        //
        initSQLTypeValueTypeMap();
        
        //
        initValueTypeJavaClassMap();
    }

    private static void initSQLTypeDBStringMap() {
    	sqlTypeDBStringMap = new HashMap<ValueType, String>();
    	
    	sqlTypeDBStringMap.put(Long, "BIGINT");
    	sqlTypeDBStringMap.put(Int, "INTEGER");
    	sqlTypeDBStringMap.put(Float, "FLOAT");
    	sqlTypeDBStringMap.put(Double, "DOUBLE");
    	sqlTypeDBStringMap.put(Decimal, "DECIMAL");
    	sqlTypeDBStringMap.put(Date, "DATE");
    	sqlTypeDBStringMap.put(Boolean, "BOOLEAN");
    	sqlTypeDBStringMap.put(String, "VARCHAR");
    }

    private static void initStringValueTypeMap() {
    	stringValueTypeMap = new HashMap<String, ValueType>();
    	
    	//1. SAP 类型
    	stringValueTypeMap.put("c", String);
    	stringValueTypeMap.put("n", String);
    	stringValueTypeMap.put("t", String);
    	stringValueTypeMap.put("d", String);
    	stringValueTypeMap.put("i", Int);
    	stringValueTypeMap.put("f", Double);
    	stringValueTypeMap.put("p", Double);
    	stringValueTypeMap.put("x", String);
    	
    	//2. 普通类型
    	stringValueTypeMap.put("String", String);
    	stringValueTypeMap.put("char", String);
    	stringValueTypeMap.put("varchar", String);
    	stringValueTypeMap.put("vchar", String);
    	stringValueTypeMap.put("text", String);
    	stringValueTypeMap.put("int", Int);
    	stringValueTypeMap.put("tinyint", Int);
    	stringValueTypeMap.put("smallint", Int);
    	stringValueTypeMap.put("bigint", Int);
    	stringValueTypeMap.put("long", Int);
    	stringValueTypeMap.put("number", Double);
    	stringValueTypeMap.put("decimal", Double);
    	stringValueTypeMap.put("float", Double);
    	stringValueTypeMap.put("double", Double);
    	stringValueTypeMap.put("date", Date);
    	stringValueTypeMap.put("time", Date);
    	stringValueTypeMap.put("datetime", Date);
    	stringValueTypeMap.put("boolean", Boolean);
    	stringValueTypeMap.put("entity", Entity);
    	stringValueTypeMap.put("entityset", EntitySet);
    }
    
	private static void initSQLTypeValueTypeMap() {
    	sqlTypeValueTypeMap = new HashMap<Integer, ValueType>();
    	
    	sqlTypeValueTypeMap.put(Types.INTEGER, Int);
    	sqlTypeValueTypeMap.put(Types.BIGINT, Long);
    	sqlTypeValueTypeMap.put(Types.SMALLINT, Int);
    	sqlTypeValueTypeMap.put(Types.TINYINT, Int);
    	sqlTypeValueTypeMap.put(Types.DECIMAL, Decimal);
    	sqlTypeValueTypeMap.put(Types.NUMERIC, Decimal);
    	sqlTypeValueTypeMap.put(Types.DOUBLE, Double);
    	sqlTypeValueTypeMap.put(Types.FLOAT, Double);
    	sqlTypeValueTypeMap.put(Types.DATE, Date);
    	sqlTypeValueTypeMap.put(Types.TIME, Date);
    	sqlTypeValueTypeMap.put(Types.TIMESTAMP, Date);
    	sqlTypeValueTypeMap.put(Types.BOOLEAN, Boolean);
    	sqlTypeValueTypeMap.put(Types.BIT, Boolean);
    }
    
	private static void initValueTypeJavaClassMap() {
		valueTypeJavaClassMap = new HashMap<ValueType, Class<?>>();
		
		valueTypeJavaClassMap.put(Int, Integer.class);
		valueTypeJavaClassMap.put(Double, Double.class);
		valueTypeJavaClassMap.put(Float, Float.class);
		valueTypeJavaClassMap.put(Decimal, java.util.Date.class);
		valueTypeJavaClassMap.put(List, java.util.List.class);
		valueTypeJavaClassMap.put(Boolean, java.lang.Boolean.class);
		valueTypeJavaClassMap.put(Int, Integer.class);
	}
	
}