Package com.groiss.reporting.data.impl

Class DateReportingData

java.lang.Object

com.groiss.reporting.export.AbstractReportingExportable

com.groiss.reporting.data.impl.DefaultReportingData

com.groiss.reporting.data.impl.DateReportingData

All Implemented Interfaces:

NumericValue, ReportingData, ReportingExportable, Cloneable, Comparable<ReportingExportable>

public class DateReportingData
extends DefaultReportingData

Reporting data type for date values

Field Summary

Fields

Modifier and Type	Field	Description
static final List<Pair<String,String>>	CONDUNITS
protected String	dateformat
protected boolean	expandForDrilldown
protected ArrayList<Pair<String,String>>	myCondUnits
protected String	weekval

Fields inherited from class com.groiss.reporting.data.impl.DefaultReportingData

a, alias, attributeHasUserdefType, dontUseMappedString, e, value

Constructor Summary

Constructors

Constructor	Description
DateReportingData()
DateReportingData(Entity e, Attribute a)
DateReportingData(Date d, String df)
DateReportingData(Date d, String df, boolean expand)

Method Summary

Modifier and Type	Method	Description
void	addClientConditionWidgetOptions(JSONObject json, boolean paramAtExec, Element condition)	add clientcondition attributes to attribute store
void	addConditionToQuery(Query q, Element c)	Adds the XMLAttribute as a conditon to the query.
int	compareTo(ReportingExportable o)
Collection<ReportingExportable>	completeSeries(Set<ReportingExportable> series, Query q)	invoked for matrix-style reports to be able to add missing entries in the given series
static Collection<ReportingExportable>	completeSeries(Set<ReportingExportable> series, String dateformat, Date min, Date max, boolean expand)
static Pair<Timestamp,Timestamp>	getBeginAndEnd(Date val, String df)
protected static Timestamp	getDate(int offset, String unit, boolean exact)
protected static Timestamp	getDate(Date startDate, int offset, String unit, boolean exact)	calculate timestamp of implicit condition
static JSONPage	getDateDisplayString(HttpServletRequest req)
String	getDateformat()
static Date	getDateObject(String date, boolean enddate)
static Date	getDateObject(String date, boolean enddate, TimeZone tz)
static JSONPage	getExampleDate(HttpServletRequest req)
static String	getIsoDateString(Date d)
static String	getIsoDateString(Date d, TimeZone tz)
protected static Pair<Date,Date>	getMinMax(ReportingData rd, Query q)
static String	getSQLPlaceholder()
TimeZone	getTimeZone()
static void	increment(Calendar cal, String dateformat)
protected void	init()
final boolean	isExpandForDrilldown()
static boolean	isParseEndDateOperator(String operator)
void	setDateformat(String df)
final void	setExpandForDrilldown(boolean expandForDrilldown)
void	setValue(ResultSet rs, Element selectAttribute, Query q)	Sets the value of this object.
String	toText()	Used for CSV/EXCEL/XML export...

Methods inherited from class com.groiss.reporting.data.impl.DefaultReportingData

add, addIgnoreCaseComponents, addSelectAttributeToQuery, avg, checkTempJoin, compare2, getAlias, getAttribute, getBaseType, getColumnRenderer, getDBData, getEntity, getMappedValue, getMappedValues, getOperatorList, getValue, hasAttributeUserdefinedType, hasMappedValues, pairList, pairList, pairList, pairList, setAlias, setAttribute, setAttributeHasUserdefinedType, setEntity, setMappedValue, setValue, splitValueAttribute, toHtml, toJson, toString

Methods inherited from class com.groiss.reporting.export.AbstractReportingExportable

getSortText

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.groiss.reporting.export.ReportingExportable

getSortText

Field Details

CONDUNITS

public static final List<Pair<String,String>> CONDUNITS

myCondUnits

protected ArrayList<Pair<String,String>> myCondUnits

weekval

protected String weekval

dateformat

protected String dateformat

expandForDrilldown

protected boolean expandForDrilldown

Constructor Details

DateReportingData

public DateReportingData(Entity e,
 Attribute a)

DateReportingData

public DateReportingData()

DateReportingData

public DateReportingData(Date d,
 String df)

DateReportingData

public DateReportingData(Date d,
 String df,
 boolean expand)

Method Details

init

protected void init()

addClientConditionWidgetOptions

public void addClientConditionWidgetOptions(JSONObject json,
 boolean paramAtExec,
 Element condition)

Description copied from interface: ReportingData

add clientcondition attributes to attribute store

Specified by:

addClientConditionWidgetOptions in interface ReportingData

Overrides:

addClientConditionWidgetOptions in class DefaultReportingData

Parameters:

json - the json object of this attribute

paramAtExec - indicates if method is called in normal condition or param-at-execution mode

condition - the optional <condition> element. Can be used to mimic special behavior for parameter-at-execution scenarios

setValue

public void setValue(ResultSet rs,
 Element selectAttribute,
 Query q)

Description copied from interface: ReportingData

Sets the value of this object. Value is gained from resultset.

Specified by:

setValue in interface ReportingData

Overrides:

setValue in class DefaultReportingData

Parameters:

rs - - the result set of the query

selectAttribute - - the xml-element attribute of the query

q - - the query object

See Also:

• Query.getSelectIndexOfAttribs(Element)

setExpandForDrilldown

public final void setExpandForDrilldown(boolean expandForDrilldown)

isExpandForDrilldown

public final boolean isExpandForDrilldown()

toText

public String toText()

Description copied from interface: ReportingExportable

Used for CSV/EXCEL/XML export...

Specified by:

toText in interface ReportingExportable

Overrides:

toText in class DefaultReportingData

Returns:

the String representation of this Object

getTimeZone

public TimeZone getTimeZone()

Returns:

always returns ThreadContext.getThreadTimeZone()

compareTo

public int compareTo(ReportingExportable o)

Specified by:

compareTo in interface Comparable<ReportingExportable>

Specified by:

compareTo in interface ReportingExportable

Overrides:

compareTo in class DefaultReportingData

getSQLPlaceholder

public static String getSQLPlaceholder()

addConditionToQuery

public void addConditionToQuery(Query q,
 Element c)

Description copied from interface: ReportingData

Adds the XMLAttribute as a conditon to the query. Has to call Query.addCondition(String, String, String, String, List)

Specified by:

addConditionToQuery in interface ReportingData

Overrides:

addConditionToQuery in class DefaultReportingData

Parameters:

q - - the query Object, where condtion has to be added

c - - the xml element of type condition

getBeginAndEnd

public static Pair<Timestamp,Timestamp> getBeginAndEnd(Date val,
 String df)

getDate

protected static Timestamp getDate(int offset,
 String unit,
 boolean exact)

getDate

protected static Timestamp getDate(Date startDate,
 int offset,
 String unit,
 boolean exact)

calculate timestamp of implicit condition

Parameters:

startDate - mostly today

offset - the offset to add

unit - the unit of the offset

exact - true if it should be calculated exactly

Returns:

the calculated timestamp

getDateformat

public String getDateformat()

setDateformat

public void setDateformat(String df)

getIsoDateString

public static String getIsoDateString(Date d)

getIsoDateString

public static String getIsoDateString(Date d,
 TimeZone tz)

getDateObject

public static Date getDateObject(String date,
 boolean enddate)

getDateObject

public static Date getDateObject(String date,
 boolean enddate,
 TimeZone tz)

getDateDisplayString

public static JSONPage getDateDisplayString(HttpServletRequest req)

isParseEndDateOperator

public static boolean isParseEndDateOperator(String operator)

Parameters:

operator -

Returns:

getExampleDate

public static JSONPage getExampleDate(HttpServletRequest req)

completeSeries

public static Collection<ReportingExportable> completeSeries(Set<ReportingExportable> series,
 String dateformat,
 Date min,
 Date max,
 boolean expand)

increment

public static void increment(Calendar cal,
 String dateformat)

getMinMax

protected static Pair<Date,Date> getMinMax(ReportingData rd,
 Query q)

completeSeries

public Collection<ReportingExportable> completeSeries(Set<ReportingExportable> series,
 Query q)

Description copied from interface: ReportingData

invoked for matrix-style reports to be able to add missing entries in the given series

Specified by:

completeSeries in interface ReportingData

Overrides:

completeSeries in class DefaultReportingData

Parameters:

series - the current values from the DB

q - the query

Returns:

the full series (e.g. for dates all dates from t1-t2, for persistents all elements of a certain type etc.)