package foundation.io.define;

import foundation.translator.ValueType;

public enum CellType {
	
	BOOL, ERROR, FORMULA, INLINESTR, SSTINDEX, NUMBER, DATE, NULL;

    public static CellType toExcelCellType(String type) {
    	if (type == null) {
            return null;
        }

        type = type.toLowerCase();

        if ("boolean".equals(type)) {
            return CellType.BOOL;
        }
        else if ("int".equals(type)) {
            return CellType.NUMBER;
        }
        else if ("decimal".equals(type)) {
            return CellType.NUMBER;
        }
        else if ("percent".equals(type)) {
            return CellType.NUMBER;
        }
        else if ("date".equals(type)) {
            return CellType.DATE;
        }
        else if ("datetime".equals(type)) {
            return CellType.ERROR;
        }
        else if ("String".equals(type)) {
            return CellType.SSTINDEX;
        }
        else {
        	return CellType.SSTINDEX;
        }
    }
    
    public static CellType toExcelCellType(ValueType type) {
    	if (type == null || ValueType.Void.equals(type)) {
            return null;
        }

        if (ValueType.Boolean.equals(type)) {
            return CellType.BOOL;
        }
        else if (ValueType.Decimal.equals(type)) {
            return CellType.NUMBER;
        }
        else if (ValueType.Date.equals(type)) {
            return CellType.DATE;
        }
        else if (ValueType.Date.equals(type)) {
            return CellType.DATE;
        }
        else if (ValueType.String.equals(type)) {
            return CellType.SSTINDEX;
        }

        return CellType.SSTINDEX;
    }
}