Application: gvSIG desktop

package org.gvsig.sqlite.dal.expressionbuilderformatter;

import java.time.LocalDate;

import java.time.LocalDateTime;

import java.time.ZoneId;

import java.time.format.DateTimeFormatter;

import java.time.temporal.ChronoField;

import java.time.temporal.TemporalField;

import java.util.List;

import org.apache.commons.lang3.StringUtils;

import org.gvsig.expressionevaluator.ExpressionBuilder;

import static org.gvsig.expressionevaluator.ExpressionBuilder.FUNCTION_TIME;

import org.gvsig.expressionevaluator.ExpressionBuilder.Function;

import org.gvsig.expressionevaluator.ExpressionBuilder.Value;

import org.gvsig.expressionevaluator.Formatter;

import org.gvsig.fmap.dal.SQLBuilder;

import org.gvsig.fmap.dal.store.jdbc2.spi.expressionbuilder.formatters.$Constant;

import org.gvsig.tools.dataTypes.DataTypeUtils;

/**

 *

 * @author jjdelcerro

 */

public class Date implements Formatter<Value> {

    private final SQLBuilder sqlbuilder;

    private final Formatter<Value> formatter;

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

        this.sqlbuilder = sqlbuilder;

        this.formatter = formatter;

    }

    @Override

    public boolean canApply(ExpressionBuilder.Value value) {

        if (value instanceof ExpressionBuilder.Function) {

            if( StringUtils.equalsIgnoreCase(ExpressionBuilder.FUNCTION_DATE, ((Function) value).name()) ) {

                List<Value> parameters = ((Function) value).parameters();

                if( parameters.size()==1) {

                    Value p1 = parameters.get(0);

                    if( $Constant.isConstant(p1) ) {

                        return true;

                    }

                }

            }

        }

        return false;

    }

    @Override

    public String format(Value function) {

        List<Value> parameters = ((Function) function).parameters();

        Value p1 = parameters.get(0);

        ExpressionBuilder.Constant p1value = $Constant.resolveAsConstant(this.sqlbuilder, this.formatter, p1);

        LocalDateTime localDate = DataTypeUtils.toLocalDateTime(p1value.value());

        DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd");

//        long t = localDate.atZone(ZoneId.systemDefault()).toInstant().toEpochMilli();

        String r = "('"+localDate.format(formatter)+"')";

        return r;

    }

}