private static Date monthend( final Date date, final LocalizationContext context ) { final Calendar gc = DateUtil.createCalendar( date, context ); gc.set( Calendar.DAY_OF_MONTH, gc.getActualMaximum( Calendar.DAY_OF_MONTH ) ); return gc.getTime(); }
private static Date monthend(final Date date, final LocalizationContext context) { final Calendar gc = DateUtil.createCalendar(date, context); gc.set(Calendar.DAY_OF_MONTH, gc.getActualMaximum(Calendar.DAY_OF_MONTH)); return gc.getTime(); }
public TypeValuePair evaluate( final FormulaContext context, final ParameterCallback parameters ) throws EvaluationException { if ( parameters.getParameterCount() != 1 ) { throw EvaluationException.getInstance( LibFormulaErrorValue.ERROR_ARGUMENTS_VALUE ); } final TypeRegistry typeRegistry = context.getTypeRegistry(); final Date d = typeRegistry.convertToDate( parameters.getType( 0 ), parameters.getValue( 0 ) ); if ( d == null ) { throw EvaluationException.getInstance( LibFormulaErrorValue.ERROR_INVALID_ARGUMENT_VALUE ); } final Calendar gc = DateUtil.createCalendar( d, context.getLocalizationContext() ); final int month = gc.get( Calendar.MONTH ) + 1; return new TypeValuePair( NumberType.GENERIC_NUMBER, new BigDecimal( month ) ); } }
public TypeValuePair evaluate( final FormulaContext context, final ParameterCallback parameters ) throws EvaluationException { if ( parameters.getParameterCount() != 1 ) { throw EvaluationException.getInstance( LibFormulaErrorValue.ERROR_ARGUMENTS_VALUE ); } final TypeRegistry typeRegistry = context.getTypeRegistry(); final Date d = typeRegistry.convertToDate( parameters.getType( 0 ), parameters.getValue( 0 ) ); if ( d == null ) { throw EvaluationException.getInstance( LibFormulaErrorValue.ERROR_INVALID_ARGUMENT_VALUE ); } final Calendar gc = DateUtil.createCalendar( d, context.getLocalizationContext() ); final int year = gc.get( Calendar.YEAR ); //noinspection UnpredictableBigDecimalConstructorCall return new TypeValuePair( NumberType.GENERIC_NUMBER, new BigDecimal( (double) year ) ); } }
public TypeValuePair evaluate( final FormulaContext context, final ParameterCallback parameters ) throws EvaluationException { if ( parameters.getParameterCount() != 1 ) { throw EvaluationException.getInstance( LibFormulaErrorValue.ERROR_ARGUMENTS_VALUE ); } final TypeRegistry typeRegistry = context.getTypeRegistry(); final Date d = typeRegistry.convertToDate( parameters.getType( 0 ), parameters.getValue( 0 ) ); if ( d == null ) { throw EvaluationException.getInstance( LibFormulaErrorValue.ERROR_INVALID_ARGUMENT_VALUE ); } final Calendar gc = DateUtil.createCalendar( d, context.getLocalizationContext() ); final int dayOfMonth = gc.get( Calendar.DAY_OF_MONTH ); //noinspection UnpredictableBigDecimalConstructorCall return new TypeValuePair( NumberType.GENERIC_NUMBER, new BigDecimal( (double) dayOfMonth ) ); } }
public TypeValuePair evaluate(final FormulaContext context, final ParameterCallback parameters) throws EvaluationException { if (parameters.getParameterCount() != 1) { throw EvaluationException.getInstance(LibFormulaErrorValue.ERROR_ARGUMENTS_VALUE); } final TypeRegistry typeRegistry = context.getTypeRegistry(); final Date d = typeRegistry.convertToDate(parameters.getType(0), parameters.getValue(0)); if (d == null) { throw EvaluationException.getInstance( LibFormulaErrorValue.ERROR_INVALID_ARGUMENT_VALUE); } final Calendar gc = DateUtil.createCalendar(d, context.getLocalizationContext()); final int month = gc.get(Calendar.MONTH) + 1; return new TypeValuePair(NumberType.GENERIC_NUMBER, new BigDecimal(month)); } }
public TypeValuePair evaluate(final FormulaContext context, final ParameterCallback parameters) throws EvaluationException { if (parameters.getParameterCount() != 1) { throw EvaluationException.getInstance(LibFormulaErrorValue.ERROR_ARGUMENTS_VALUE); } final TypeRegistry typeRegistry = context.getTypeRegistry(); final Date d = typeRegistry.convertToDate(parameters.getType(0), parameters.getValue(0)); if (d == null) { throw EvaluationException.getInstance(LibFormulaErrorValue.ERROR_INVALID_ARGUMENT_VALUE); } final Calendar gc = DateUtil.createCalendar(d, context.getLocalizationContext()); final int dayOfMonth = gc.get(Calendar.DAY_OF_MONTH); //noinspection UnpredictableBigDecimalConstructorCall return new TypeValuePair(NumberType.GENERIC_NUMBER, new BigDecimal((double)dayOfMonth)); } }
public TypeValuePair evaluate(final FormulaContext context, final ParameterCallback parameters) throws EvaluationException { if (parameters.getParameterCount() != 1) { throw EvaluationException.getInstance(LibFormulaErrorValue.ERROR_ARGUMENTS_VALUE); } final TypeRegistry typeRegistry = context.getTypeRegistry(); final Date d = typeRegistry.convertToDate(parameters.getType(0), parameters.getValue(0)); if (d == null) { throw EvaluationException.getInstance( LibFormulaErrorValue.ERROR_INVALID_ARGUMENT_VALUE); } final Calendar gc = DateUtil.createCalendar(d, context.getLocalizationContext()); final int year = gc.get(Calendar.YEAR); //noinspection UnpredictableBigDecimalConstructorCall return new TypeValuePair(NumberType.GENERIC_NUMBER, new BigDecimal((double)year)); } }
final Calendar gc = DateUtil.createCalendar(d, context.getLocalizationContext());
public TypeValuePair evaluate( final FormulaContext context, final ParameterCallback parameters ) throws EvaluationException { if ( parameters.getParameterCount() > 2 ) { throw EvaluationException.getInstance( LibFormulaErrorValue.ERROR_ARGUMENTS_VALUE ); } final TypeRegistry typeRegistry = context.getTypeRegistry(); final Date d = typeRegistry.convertToDate( parameters.getType( 0 ), parameters.getValue( 0 ) ); int type = 1; // default is Type 1 if ( parameters.getParameterCount() == 2 ) { final Number n = typeRegistry.convertToNumber( parameters.getType( 1 ), parameters.getValue( 1 ) ); if ( n == null ) { throw EvaluationException.getInstance( LibFormulaErrorValue.ERROR_INVALID_ARGUMENT_VALUE ); } type = n.intValue(); if ( type < 1 || type > 3 ) { throw EvaluationException.getInstance( LibFormulaErrorValue.ERROR_INVALID_ARGUMENT_VALUE ); } } if ( d == null ) { throw EvaluationException.getInstance( LibFormulaErrorValue.ERROR_INVALID_ARGUMENT_VALUE ); } final Calendar gc = DateUtil.createCalendar( d, context.getLocalizationContext() ); final int dayOfWeek = gc.get( Calendar.DAY_OF_WEEK ); // in java Sunday = 1 (= Type 1 of openformula) final int result = convertType( dayOfWeek, type ); //noinspection UnpredictableBigDecimalConstructorCall return new TypeValuePair( NumberType.GENERIC_NUMBER, new BigDecimal( (double) result ) ); }
final Calendar gc = DateUtil.createCalendar(d, context.getLocalizationContext());