package foundation.translator;

import java.math.BigDecimal;
import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;

import foundation.server.config.DBaseType;
import foundation.util.Util;


public class DateTranslator extends ITranslator {

	private static String DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
	private static String DateTimeFormat_Oracle = "yyyy-mm-dd hh24:mi:ss";
	private static String DateFormat = "yyyy-MM-dd";
	private DateFormat dateTimeFormater;
	private DateFormat dateFormater;
	
			
	public DateTranslator() {
		dateTimeFormater = new SimpleDateFormat(DateTimeFormat);
		dateFormater = new SimpleDateFormat(DateFormat);
	}
	
	public String toString(Object value) throws Exception {
		if (value == null || value == ValueType.Null) {
			return null;
		}
		
		Date date = (Date)value;
		return dateFormater.format(date);
	}
	
	public String toSqlString(DBaseType dbaseType, Object value) throws Exception {
		if (value == null || value == ValueType.Null) {
			return "null";
		}
		
		Date date = toDate(value);
		
		if (dbaseType.isMySQL()) {
			return "\"" + dateFormater.format(date) + "\"";
		}
		else if (dbaseType.isSQLServer()) {
			return "'" + dateFormater.format(date) + "'";
		}
		else if (dbaseType.isOracle()) {
			return "to_date(\'" + dateFormater.format(date) + "\', " + Util.quotedStr(DateTimeFormat_Oracle)+ ")";
		}
		else {
			return "\"" + dateFormater.format(date) + "\"";
		}
	}
	
	public String toJSONString(Object value) throws Exception {
		if (value == null || value == ValueType.Null) {
			return "null";
		}
		
		//1. 如果数据本身就是 Date， 按着Date转换
		if (value instanceof Date) {
			Date date = (Date)value;
			return "\"" + dateFormater.format(date) + "\"";
		}
		
		//2. 如果数据是 String， 按着String转
		if (value instanceof String) {
			return "\"" + (String)value + "\"";
		}
		
		//3. 如果数据是其他类型， 认为无法转换
		return "null";
	}
	
	public String toSchemaString(Object value) throws Exception {
		if (value == null || value == ValueType.Null) {
			return "";
		}
		
		Date date = (Date)value;
		return "\"" + dateFormater.format(date) + "\"";
	}

	@Override
	public Integer toInteger(Object object) throws Exception {
		throw new Exception("can not translate date (" + object + ") to Integer");
	}

	@Override
	public Double toDouble(Object object) throws Exception {
		throw new Exception("can not translate date (" + object + ") to Double");
	}

	@Override
	public BigDecimal toBigDecimal(Object object) throws Exception {
		throw new Exception("can not translate date (" + object + ") to BigDecimal");
	}
	
	@Override
	public Boolean toBoolean(Object object) throws Exception {
		throw new Exception("can not translate date (" + object + ") to BigDecimal");
	}

	@Override
	public Date toDate(Object object) throws Exception {
		if(object instanceof Long) {
			return new Date((Long)object);
		}
		else if (object instanceof String) {
			String value = (String) object;
			value = value.trim().replace('\\', '-').replace('/', '-');
			
			Date parsedDate = null;
			
			int length = value.length();
			
			if (length == 10) {
				value = value + " 00:00:00";
			}
			
			if (length == 19 || length == 10) {
				parsedDate = dateTimeFormater.parse(value);
			}
			
			return parsedDate;
		}
		else if (object instanceof Date) {
			return (Date) object;
		}
		else if (object instanceof Double) {
			Long longValue = ((Double)object).longValue();
			
			if (longValue >= 19500101 && longValue <= 21000101) {
				DateFormat dateFormat = new SimpleDateFormat("yyyyMMdd");
				return dateFormat.parse(String.valueOf(longValue));
			}
			else {
				return new Date(longValue);
			}
		}
		else if (object instanceof Integer) {
			Integer value = (Integer)object;
			
			if (value >= 19500101 && value <= 21000101) {
				DateFormat dateFormat = new SimpleDateFormat("yyyyMMdd");
				return dateFormat.parse(String.valueOf(value));
			}
			else {
				return null;
			}
		}
		else {
			return null;
		}
	}

	@Override
	public Object toTranslatorTypeValue(Object value) throws Exception {
		return toDate(value);
	}
	
	@Override
	public Object loadObjectFrom(String value) throws Exception {
		if (Util.isEmpty(value)) {
			return null;
		}
		
		return dateFormater.parse(value);
	}
	
	@Override
	public void setFormat(String format) {
		if (Util.isEmpty(format)) {
			format = DateTimeFormat;
		}
		
		this.format = format;
		dateFormater = new SimpleDateFormat(format);
	}

	@Override
	public Class<?> getDataClass() {
		return Date.class;
	}
	
	public static void main(String[] args) throws ParseException {
		DateFormat dateFormater = new SimpleDateFormat("yyyy-MM-dd");
		Date parsedDate = dateFormater.parse("2021-03-09");
		System.out.println(parsedDate);
	}
}