Application: gvSIG desktop

package org.gvsig.fmap.dal.store.mdb.expressionbuilderformatter;

import java.text.ParseException;

import java.text.SimpleDateFormat;

import java.util.Date;

import java.util.logging.Level;

import java.util.logging.Logger;

import org.apache.commons.lang3.StringUtils;

import org.gvsig.expressionevaluator.ExpressionBuilder;

import org.gvsig.expressionevaluator.ExpressionBuilder.Function;

import org.gvsig.expressionevaluator.ExpressionBuilder.Value;

import org.gvsig.expressionevaluator.Formatter;

import static org.gvsig.fmap.dal.DataManager.FUNCTION_EXISTS;

import org.gvsig.fmap.dal.SQLBuilder;

/**

 *

 * @author jjdelcerro

 */

public class TimeFunction implements Formatter<Value> {

    private final SQLBuilder sqlbuilder;

    private final Formatter<Value> formatter;

    public TimeFunction(SQLBuilder sqlbuilder, Formatter<Value> formatter) {

        this.sqlbuilder = sqlbuilder;

        this.formatter = formatter;

    }

    @Override

    public boolean canApply(ExpressionBuilder.Value value) {

        if (value instanceof ExpressionBuilder.Function) {

            return StringUtils.equalsIgnoreCase(ExpressionBuilder.FUNCTION_TIME, ((Function) value).name());

        }

        return false;

    }

    @Override

    public String format(Value function0) {

        Function function = (Function) function0;

        Value exp = function.parameters().get(0);

        if (exp instanceof ExpressionBuilder.Constant) {

            ExpressionBuilder.Constant x = (ExpressionBuilder.Constant) exp;

            Object value = x.value();

            if (value instanceof String) {

                String strValue = (String) value;

                String[] splits = StringUtils.split(strValue, " ");

                if (splits.length > 0 && splits.length<3) {

                    try {

                        Date spm = new SimpleDateFormat("H:m:s").parse(strValue);

                        return "#"+value+"#";

                    } catch (ParseException ex) {

                    }

                }

            }

        }

        return "CDATE('1899-12-30 '|| FORMAT(CDATE(" + exp.toString(formatter) + "),'Long Time'))";

    }

}