Java Code Examples for org.eclipse.birt.core.data.DataTypeUtil#toSqlDate()

The following examples show how to use org.eclipse.birt.core.data.DataTypeUtil#toSqlDate() . You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
Source File: TemplateMessageServiceBaseImpl.java    From axelor-open-suite with GNU Affero General Public License v3.0 6 votes vote down vote up 
private Object convertValue(String type, String value) throws BirtException {

    if (DesignChoiceConstants.PARAM_TYPE_BOOLEAN.equals(type)) {
      return DataTypeUtil.toBoolean(value);
    } else if (DesignChoiceConstants.PARAM_TYPE_DATETIME.equals(type)) {
      return DataTypeUtil.toDate(value);
    } else if (DesignChoiceConstants.PARAM_TYPE_DATE.equals(type)) {
      return DataTypeUtil.toSqlDate(value);
    } else if (DesignChoiceConstants.PARAM_TYPE_TIME.equals(type)) {
      return DataTypeUtil.toSqlTime(value);
    } else if (DesignChoiceConstants.PARAM_TYPE_DECIMAL.equals(type)) {
      return DataTypeUtil.toBigDecimal(value);
    } else if (DesignChoiceConstants.PARAM_TYPE_FLOAT.equals(type)) {
      return DataTypeUtil.toDouble(value);
    } else if (DesignChoiceConstants.PARAM_TYPE_STRING.equals(type)) {
      return DataTypeUtil.toLocaleNeutralString(value);
    } else if (DesignChoiceConstants.PARAM_TYPE_INTEGER.equals(type)) {
      return DataTypeUtil.toInteger(value);
    }
    return value;
  }
Example 2
Source File: TimeFunctionManager.java    From birt with Eclipse Public License 1.0 5 votes vote down vote up 
private static String getFormattedDateStringFromTimeMember( TimeMember member, ULocale locale ) throws BirtException
{
	Calendar calendar = Calendar.getInstance( locale );
	calendar.clear( );
	calendar.set( Calendar.YEAR, member.getMemberValue( )[0] );
	calendar.set( Calendar.MONTH, member.getMemberValue( )[1]-1 );
	calendar.set( Calendar.DAY_OF_MONTH, member.getMemberValue( )[2] );
	java.sql.Date date = (java.sql.Date) DataTypeUtil.toSqlDate( calendar.getTime( ) );
	DateFormatter formatter = new DateFormatter(locale);
	
	return formatter.format( date );
}
Example 3
Source File: ReportRunner.java    From birt with Eclipse Public License 1.0 5 votes vote down vote up 
/**
 * @param p
 *            the scalar parameter
 * @param expr
 *            the default value expression
 */
protected Object stringToObject( int type, String value )
		throws BirtException
{
	if ( value == null )
	{
		return null;
	}
	switch ( type )
	{
		case IScalarParameterDefn.TYPE_BOOLEAN :
			return DataTypeUtil.toBoolean( value );

		case IScalarParameterDefn.TYPE_DATE :
			return DataTypeUtil.toSqlDate( value );

		case IScalarParameterDefn.TYPE_TIME :
			return DataTypeUtil.toSqlTime( value );
			
		case IScalarParameterDefn.TYPE_DATE_TIME :
			return DataTypeUtil.toDate( value );
		case IScalarParameterDefn.TYPE_DECIMAL :
			return DataTypeUtil.toBigDecimal( value );

		case IScalarParameterDefn.TYPE_FLOAT :
			return DataTypeUtil.toDouble( value );

		case IScalarParameterDefn.TYPE_STRING :
			return DataTypeUtil.toString( value );
		
		case IScalarParameterDefn.TYPE_INTEGER :
			return DataTypeUtil.toInteger( value );
	}
	return null;

}
Example 4
Source File: ParameterSelectionChoice.java    From birt with Eclipse Public License 1.0 5 votes vote down vote up 
/**
 * set parameter choice value. The string value is in English locale, and needs to be parsed
 * back into object value based on the data type. 
 * 
 * @param value the string value for the object
 * @param type the parameter data type
 */
public void setValue(String value, int type) {
	try {
		switch (type) {
			case IScalarParameterDefn.TYPE_BOOLEAN:
				this.value = DataTypeUtil.toBoolean(value);
				break;
			case IScalarParameterDefn.TYPE_DATE_TIME:
				this.value = DataTypeUtil.toDate(value);
				break;
			case IScalarParameterDefn.TYPE_DECIMAL:
				this.value = DataTypeUtil.toBigDecimal(value);
				break;
			case IScalarParameterDefn.TYPE_FLOAT:
				this.value = DataTypeUtil.toDouble(value);
				break;
			case IScalarParameterDefn.TYPE_INTEGER:
				this.value = DataTypeUtil.toInteger( value );
				break;
			case IScalarParameterDefn.TYPE_DATE:
				this.value = DataTypeUtil.toSqlDate( value );
				break;
			case IScalarParameterDefn.TYPE_TIME:
				this.value = DataTypeUtil.toSqlTime( value );
				break;
			case IScalarParameterDefn.TYPE_STRING:
			default:
				this.value = DataTypeUtil.toString(value);
				break;
		}
	} 
	catch (BirtException e) {
		log.log(Level.SEVERE, e.getLocalizedMessage(), e);
		this.value = null;
	}
}
Example 5
Source File: EngineTask.java    From birt with Eclipse Public License 1.0 5 votes vote down vote up 
public static Object convertParameterType( Object value, String type )
		throws BirtException
{
	if ( DesignChoiceConstants.PARAM_TYPE_BOOLEAN.equals( type ) )
	{
		return DataTypeUtil.toBoolean( value );
	}
	else if ( DesignChoiceConstants.PARAM_TYPE_DATETIME.equals( type ) )
	{
		return DataTypeUtil.toDate( value );
	}
	else if ( DesignChoiceConstants.PARAM_TYPE_DATE.equals( type ) )
	{
		return DataTypeUtil.toSqlDate( value );
	}
	else if ( DesignChoiceConstants.PARAM_TYPE_TIME.equals( type ) )
	{
		return DataTypeUtil.toSqlTime( value );
	}
	else if ( DesignChoiceConstants.PARAM_TYPE_DECIMAL.equals( type ) )
	{
		return DataTypeUtil.toBigDecimal( value );
	}
	else if ( DesignChoiceConstants.PARAM_TYPE_FLOAT.equals( type ) )
	{
		return DataTypeUtil.toDouble( value );
	}
	else if ( DesignChoiceConstants.PARAM_TYPE_STRING.equals( type ) )
	{
		return DataTypeUtil.toLocaleNeutralString( value );
	}
	else if ( DesignChoiceConstants.PARAM_TYPE_INTEGER.equals( type ) )
	{
		return DataTypeUtil.toInteger( value );
	}
	return value;
}
Example 6
Source File: ParameterUtil.java    From birt with Eclipse Public License 1.0 5 votes vote down vote up 
public static Object convert( Object value, String dataType )
		throws BirtException
{
	if ( DesignChoiceConstants.PARAM_TYPE_BOOLEAN.equals( dataType ) )
	{
		return DataTypeUtil.toBoolean( value );
	}
	else if ( DesignChoiceConstants.PARAM_TYPE_DATETIME.equals( dataType ) )
	{
		return DataTypeUtil.toDate( value );
	}
	else if ( DesignChoiceConstants.PARAM_TYPE_DATE.equals( dataType ) )
	{
		return DataTypeUtil.toSqlDate( value );
	}
	else if ( DesignChoiceConstants.PARAM_TYPE_TIME.equals( dataType ) )
	{
		return DataTypeUtil.toSqlTime( value );
	}
	else if ( DesignChoiceConstants.PARAM_TYPE_DECIMAL.equals( dataType ) )
	{
		return DataTypeUtil.toBigDecimal( value );
	}
	else if ( DesignChoiceConstants.PARAM_TYPE_FLOAT.equals( dataType ) )
	{
		return DataTypeUtil.toDouble( value );
	}
	else if ( DesignChoiceConstants.PARAM_TYPE_STRING.equals( dataType ) )
	{
		return DataTypeUtil.toString( value );
	}
	else if ( DesignChoiceConstants.PARAM_TYPE_INTEGER.equals( dataType ) )
	{
		return DataTypeUtil.toInteger( value );
	}
	return value;
}
Example 7
Source File: DataUtil.java    From birt with Eclipse Public License 1.0 5 votes vote down vote up 
/**
 * Try convert an object to given type Types supported:
 * <p>
 * <ul>
 * <li>IScalarParameterDefn.TYPE_INTEGER</li>
 * <li>IScalarParameterDefn.TYPE_DECIMAL</li>
 * <li>IScalarParameterDefn.TYPE_BOOLEAN</li>
 * <li>IScalarParameterDefn.TYPE_DATE_TIME</li>
 * <li>IScalarParameterDefn.TYPE_FLOAT</li>
 * <li>IScalarParameterDefn.TYPE_STRING</li>
 * <li>IScalarParameterDefn.TYPE_DATE</li>
 * <li>IScalarParameterDefn.TYPE_TIME</li>
 * <ul>
 * </p>
 * 
 * @param source
 * @param toType
 * @return
 * @throws BirtException
 */
public static Object convert( Object source, int toType )
		throws BirtException
{
	if ( source == null )
		return null;

	// if any type, return directly.
	if ( toType == IScalarParameterDefn.TYPE_ANY )
		return source;

	switch ( toType )
	{
		case IScalarParameterDefn.TYPE_INTEGER :
			return DataTypeUtil.toInteger( source );
		case IScalarParameterDefn.TYPE_DECIMAL :
			return DataTypeUtil.toBigDecimal( source );
		case IScalarParameterDefn.TYPE_BOOLEAN :
			return DataTypeUtil.toBoolean( source );
		case IScalarParameterDefn.TYPE_DATE_TIME :
			return DataTypeUtil.toDate( source );
		case IScalarParameterDefn.TYPE_FLOAT :
			return DataTypeUtil.toDouble( source );
		case IScalarParameterDefn.TYPE_STRING :
			return DataTypeUtil.toString( source );
		case IScalarParameterDefn.TYPE_DATE :
			return DataTypeUtil.toSqlDate( source );
		case IScalarParameterDefn.TYPE_TIME :
			return DataTypeUtil.toSqlTime( source );
		default :
			throw new CoreException( "Invalid type." ); //$NON-NLS-1$
	}
}
Example 8
Source File: BaseScriptEvalUtil.java    From birt with Eclipse Public License 1.0 4 votes vote down vote up 
private static Object[] populateObArray( Object obj, Object[] obArray )
{
	try
	{
		for ( int i = 0; i < obArray.length; i++ )
		{
			if( obArray[i] instanceof Object[] )
				return obArray;
		}
		if ( obj instanceof Number && !( obj instanceof BigDecimal ) )
		{
			for ( int i = 0; i < obArray.length; i++ )
			{
				obArray[i] = DataTypeUtil.toDouble( obArray[i] );
			}
		}
		else if ( obj instanceof java.sql.Date )
		{
			for ( int i = 0; i < obArray.length; i++ )
			{
				obArray[i] = DataTypeUtil.toSqlDate( obArray[i] );
			}
		}
		else if ( obj instanceof java.sql.Time )
		{
			for ( int i = 0; i < obArray.length; i++ )
			{
				obArray[i] = DataTypeUtil.toSqlTime( obArray[i] );
			}
		}
		else if ( obj instanceof Date )
		{
			for ( int i = 0; i < obArray.length; i++ )
			{
				obArray[i] = DataTypeUtil.toDate( obArray[i] );
			}
		}
	}
	catch ( BirtException e )
	{
		// If failed to convert to same date type for comparation,
		// simply convert them to String.
		try
		{
			makeObjectArrayStringArray( obArray );
		}
		catch ( BirtException e1 )
		{
			//should never reach here.
		}
	}
	// obArray will remain the same if obj is String rather than
	// Date,Number or Boolean
	return obArray;
}
Example 9
Source File: ReportLauncher.java    From birt with Eclipse Public License 1.0 4 votes vote down vote up 
public static Object convert( Object value, String dataType )
		throws BirtException
{
	if (value == null)
	{
		return value;
	}
	if ( DesignChoiceConstants.PARAM_TYPE_BOOLEAN.equals( dataType ) )
	{
		return DataTypeUtil.toBoolean( value );
	}
	else if ( DesignChoiceConstants.PARAM_TYPE_DATETIME.equals( dataType ) )
	{
		return DataTypeUtil.toDate( value );
	}
	else if ( DesignChoiceConstants.PARAM_TYPE_DATE.equals( dataType ) )
	{
		return DataTypeUtil.toSqlDate( value );
	}
	else if ( DesignChoiceConstants.PARAM_TYPE_TIME.equals( dataType ) )
	{
		return DataTypeUtil.toSqlTime( value );
	}
	else if ( DesignChoiceConstants.PARAM_TYPE_DECIMAL.equals( dataType ) )
	{
		return DataTypeUtil.toBigDecimal( value );
	}
	else if ( DesignChoiceConstants.PARAM_TYPE_FLOAT.equals( dataType ) )
	{
		return DataTypeUtil.toDouble( value );
	}
	else if ( DesignChoiceConstants.PARAM_TYPE_STRING.equals( dataType ) )
	{
		return DataTypeUtil.toString( value );
	}
	else if ( DesignChoiceConstants.PARAM_TYPE_INTEGER.equals( dataType ) )
	{
		return DataTypeUtil.toInteger( value );
	}
	return value;
}