Package com.hybris.backoffice.excel.util

Class DefaultExcelDateUtils

java.lang.Object

com.hybris.backoffice.excel.util.DefaultExcelDateUtils

All Implemented Interfaces:

ExcelDateUtils

public class DefaultExcelDateUtils
extends java.lang.Object
implements ExcelDateUtils

Constructor Summary

Constructors

Constructor	Description
DefaultExcelDateUtils()

Method Summary

Modifier and Type	Method	Description
java.util.Date	convertToImportedDate(java.lang.String date)	Converts given date in excel date timezone into system date in system timezone.
java.lang.String	exportDate(java.util.Date date)	Exports given date in excel date timezone using ExcelDateUtils.getDateTimeFormat()
java.lang.String	exportDateRange(java.util.Date start, java.util.Date end)	Exports date range
org.apache.commons.lang3.tuple.Pair<java.lang.String,java.lang.String>	extractDateRange(java.lang.String cellValue)	Extracts from given value start and end date.
java.lang.String	getDateRangeParamKey()	Returns date range param key which will be ExcelDateUtils.getDateRangePattern() without [ and ] around the range.
java.lang.String	getDateRangePattern()	Returns date range patter used in excel column header e.g.
java.lang.String	getDateTimeFormat()	Return date and time format e.g.
java.lang.String	getExportTimeZone()	Timezone in which dates are exported into excel e.g.
java.lang.String	importDate(java.lang.String date)	Converts date in excel date timezone into system date zone date string.
void	setDateTimeFormat(java.lang.String dateTimeFormat)
void	setExportTimeZone(java.lang.String exportTimeZone)
void	setI18NService(I18NService i18NService)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DefaultExcelDateUtils

public DefaultExcelDateUtils()

Method Detail

extractDateRange

public org.apache.commons.lang3.tuple.Pair<java.lang.String,java.lang.String> extractDateRange(java.lang.String cellValue)

Description copied from interface: ExcelDateUtils

Extracts from given value start and end date. Expected format is "start to end"

Specified by:

extractDateRange in interface ExcelDateUtils

Parameters:

cellValue - value from which date range will be extracted.

Returns:

pair of start and end date.

getDateRangePattern

public java.lang.String getDateRangePattern()

Description copied from interface: ExcelDateUtils

Returns date range patter used in excel column header e.g. [dd.MM.yyyy HH:mm:ss to dd.MM.yyyy HH:mm:ss]

Specified by:

getDateRangePattern in interface ExcelDateUtils

Returns:

string with date range pattern.

getDateRangeParamKey

public java.lang.String getDateRangeParamKey()

Description copied from interface: ExcelDateUtils

Returns date range param key which will be ExcelDateUtils.getDateRangePattern() without [ and ] around the range.

Specified by:

getDateRangeParamKey in interface ExcelDateUtils

Returns:

date range param key.

exportDateRange

public java.lang.String exportDateRange(java.util.Date start,
                                        java.util.Date end)

Description copied from interface: ExcelDateUtils

Exports date range

Specified by:

exportDateRange in interface ExcelDateUtils

Parameters:

start - start date

end - end date

Returns:

string representation of date range which follows pattern from ExcelDateUtils.getDateRangePattern()

getDateTimeFormat

public java.lang.String getDateTimeFormat()

Description copied from interface: ExcelDateUtils

Return date and time format e.g. dd.MM.yyyy HH:mm:ss.

Specified by:

getDateTimeFormat in interface ExcelDateUtils

Returns:

dateTime format.

exportDate

public java.lang.String exportDate(java.util.Date date)

Description copied from interface: ExcelDateUtils

Exports given date in excel date timezone using ExcelDateUtils.getDateTimeFormat()

Specified by:

exportDate in interface ExcelDateUtils

Parameters:

date - date to be exported

Returns:

date string representation in excel date timezone ExcelDateUtils.getExportTimeZone().

importDate

public java.lang.String importDate(java.lang.String date)

Description copied from interface: ExcelDateUtils

Converts date in excel date timezone into system date zone date string.

Specified by:

importDate in interface ExcelDateUtils

Parameters:

date - date in excel date timezone ExcelDateUtils.getExportTimeZone()

Returns:

date string in system timezone.

convertToImportedDate

public java.util.Date convertToImportedDate(java.lang.String date)

Description copied from interface: ExcelDateUtils

Converts given date in excel date timezone into system date in system timezone.

Specified by:

convertToImportedDate in interface ExcelDateUtils

Parameters:

date - date in excel date timezone ExcelDateUtils.getExportTimeZone()

Returns:

date in system timezone.

getExportTimeZone

public java.lang.String getExportTimeZone()

Description copied from interface: ExcelDateUtils

Timezone in which dates are exported into excel e.g. UTC

Specified by:

getExportTimeZone in interface ExcelDateUtils

Returns:

excel timezone

setExportTimeZone

public void setExportTimeZone(java.lang.String exportTimeZone)

setDateTimeFormat

public void setDateTimeFormat(java.lang.String dateTimeFormat)

setI18NService

public void setI18NService(I18NService i18NService)