com.ontimize.gui.field

Class PivotTable

java.lang.Object

java.awt.Component

java.awt.Container

javax.swing.JComponent

com.ontimize.gui.field.AbstractFormComponent

com.ontimize.gui.field.IdentifiedAbstractFormComponent

com.ontimize.gui.field.PivotTable

All Implemented Interfaces:

AccessForm, DataComponent, FormComponent, IdentifiedElement, Internationalization, SecureElement, ImageObserver, MenuContainer, Serializable

public class PivotTable
extends IdentifiedAbstractFormComponent
implements DataComponent

See Also:

Serialized Form

Nested Class Summary

Nested classes/interfaces inherited from class javax.swing.JComponent

JComponent.AccessibleJComponent

Nested classes/interfaces inherited from class java.awt.Container

Container.AccessibleAWTContainer

Nested classes/interfaces inherited from class java.awt.Component

Component.AccessibleAWTComponent, Component.BaselineResizeBehavior, Component.BltBufferStrategy, Component.FlipBufferStrategy

Field Summary

Fields

Modifier and Type	Field and Description
static String	AVG_OPERATION_VALUE
protected ResourceBundle	bundle
protected Object	cacheValue
protected String	column
static String	COLUMN_PARAMETER
static String	COMPARATOR
protected Hashtable	comparators
static String	COUNT_OPERATION_VALUE
protected int	date_group
static String	DATE_GROUP_PARAMETER
protected EJDialog	dDetailPivot
static int	DEFAULT_DATE_GROUP
static int	DEFAULT_OPERATION
static String	DMY_DATE_GROUP_VALUE
protected String	entity
static String	ENTITY_PARAMETER
protected Vector	keys
static String	KEYS_PARAMETER
static String	M_DATE_GROUP_VALUE
static String	MAX_OPERATION_VALUE
static String	MIN_OPERATION_VALUE
static String	MY_DATE_GROUP_VALUE
protected int	operation
static String	OPERATION_PAREMETER
protected Hashtable	parameters
protected Vector	parentkeys
static String	PARENTKEYS_PARAMETER
protected boolean	percentage
static String	PERCENTAGE_PARAMETER
static String	Q_DATE_GROUP_VALUE
protected int	queryRowNumber
static String	QY_DATE_GROUP_VALUE
static String	ROW_PARAMETER
protected Vector	rows
static String	SUM_OPERATION_VALUE
protected JTable	table
protected String	value
static String	VALUE_PARAMETER
static String	Y_DATE_GROUP_VALUE

Fields inherited from class com.ontimize.gui.field.IdentifiedAbstractFormComponent

attribute, enabledPermission, parentForm, restricted, visiblePermission

Fields inherited from class com.ontimize.gui.field.AbstractFormComponent

defaultBottomMargin, defaultLeftMargin, defaultRightMargin, defaultTopMargin

Fields inherited from class javax.swing.JComponent

accessibleContext, listenerList, TOOL_TIP_TEXT_KEY, ui, UNDEFINED_CONDITION, WHEN_ANCESTOR_OF_FOCUSED_COMPONENT, WHEN_FOCUSED, WHEN_IN_FOCUSED_WINDOW

Fields inherited from class java.awt.Component

BOTTOM_ALIGNMENT, CENTER_ALIGNMENT, LEFT_ALIGNMENT, RIGHT_ALIGNMENT, TOP_ALIGNMENT

Fields inherited from interface com.ontimize.gui.field.DataComponent

COMP_FOCUS_YELLOW, GREEN_VERY_LIGHT, LIGHT_GRAY_BLUE, LIGHT_GREYISH_BLUE, VERY_LIGHT_BLUE, VERY_LIGHT_GRAY, VERY_LIGHT_PINK, VERY_LIGHT_RED, VERY_LIGHT_SKYBLUE, VERY_LIGHT_YELLOW, VERY_LIGHT_YELLOW_2

Fields inherited from interface com.ontimize.gui.i18n.Internationalization

DEBUG_LANGUAGE

Fields inherited from interface com.ontimize.gui.SecureElement

DESACTIVATE_COMPONENT_BY_PERMISSION_TIP

Fields inherited from interface java.awt.image.ImageObserver

ABORT, ALLBITS, ERROR, FRAMEBITS, HEIGHT, PROPERTIES, SOMEBITS, WIDTH

Constructor Summary

Constructors

Constructor and Description
PivotTable(Hashtable h)

Method Summary

Methods

Modifier and Type	Method and Description
void	deleteData() The method to delete data for component.
Object	getAttribute() Gets the object attribute.
protected Vector	getAttributes()
Object	getConstraints(LayoutManager parentLayout) Description method to return the constraints component to place correctly in parent container.
protected Hashtable	getDetailWindowParameters()
JTable	getJTable()
protected Vector	getKeys()
String	getLabelComponentText() Returns the label text component.
protected Vector	getParentkeys()
int	getSQLDataType() Returns the sql data type according to java.sql.Types
Object	getValue() Gets the value of a component.
void	init(Hashtable parameters) Initializes parameters.
protected void	installDetailMouseListener()
boolean	isEmpty() Checks the data existence in component.
boolean	isHidden() Indicates to check the visibility condition for a component.
boolean	isModifiable() Checks the modifiable condition for a component.
boolean	isModified() This method should be return true when data have been modified.
boolean	isPercentage()
boolean	isRequired() Indicates the required condition for a component.
protected void	jInit()
void	setFont(Font f)
void	setModifiable(boolean modifiable) Establishes the modifiable condition for a component.
void	setPercentage(boolean percentage)
void	setRequired(boolean required) Sets required a component according to condition.
void	setResourceBundle(ResourceBundle res) Sets the language resource bundle.
void	setValue(Object value) Sets the value for component.
protected void	showDetailPivotTableWindow(TableModel model, Hashtable information)

Methods inherited from class com.ontimize.gui.field.IdentifiedAbstractFormComponent

checkEnabledPermission, checkVisiblePermission, getParentForm, initPermissions, isRestricted, setParentForm

Methods inherited from class com.ontimize.gui.field.AbstractFormComponent

getTextsToTranslate, setComponentLocale

Methods inherited from class javax.swing.JComponent

addAncestorListener, addNotify, addVetoableChangeListener, computeVisibleRect, contains, createToolTip, disable, enable, firePropertyChange, firePropertyChange, firePropertyChange, fireVetoableChange, getAccessibleContext, getActionForKeyStroke, getActionMap, getAlignmentX, getAlignmentY, getAncestorListeners, getAutoscrolls, getBaseline, getBaselineResizeBehavior, getBorder, getBounds, getClientProperty, getComponentGraphics, getComponentPopupMenu, getConditionForKeyStroke, getDebugGraphicsOptions, getDefaultLocale, getFontMetrics, getGraphics, getHeight, getInheritsPopupMenu, getInputMap, getInputMap, getInputVerifier, getInsets, getInsets, getListeners, getLocation, getMaximumSize, getMinimumSize, getNextFocusableComponent, getPopupLocation, getPreferredSize, getRegisteredKeyStrokes, getRootPane, getSize, getToolTipLocation, getToolTipText, getToolTipText, getTopLevelAncestor, getTransferHandler, getUIClassID, getVerifyInputWhenFocusTarget, getVetoableChangeListeners, getVisibleRect, getWidth, getX, getY, grabFocus, isDoubleBuffered, isLightweightComponent, isManagingFocus, isOpaque, isOptimizedDrawingEnabled, isPaintingForPrint, isPaintingOrigin, isPaintingTile, isRequestFocusEnabled, isValidateRoot, paint, paintBorder, paintChildren, paintComponent, paintImmediately, paintImmediately, paramString, print, printAll, printBorder, printChildren, printComponent, processComponentKeyEvent, processKeyBinding, processKeyEvent, processMouseEvent, processMouseMotionEvent, putClientProperty, registerKeyboardAction, registerKeyboardAction, removeAncestorListener, removeNotify, removeVetoableChangeListener, repaint, repaint, requestDefaultFocus, requestFocus, requestFocus, requestFocusInWindow, requestFocusInWindow, resetKeyboardActions, reshape, revalidate, scrollRectToVisible, setActionMap, setAlignmentX, setAlignmentY, setAutoscrolls, setBackground, setBorder, setComponentPopupMenu, setDebugGraphicsOptions, setDefaultLocale, setDoubleBuffered, setEnabled, setFocusTraversalKeys, setForeground, setInheritsPopupMenu, setInputMap, setInputVerifier, setMaximumSize, setMinimumSize, setNextFocusableComponent, setOpaque, setPreferredSize, setRequestFocusEnabled, setToolTipText, setTransferHandler, setUI, setVerifyInputWhenFocusTarget, setVisible, unregisterKeyboardAction, update, updateUI

Methods inherited from class java.awt.Container

add, add, add, add, add, addContainerListener, addImpl, addPropertyChangeListener, addPropertyChangeListener, applyComponentOrientation, areFocusTraversalKeysSet, countComponents, deliverEvent, doLayout, findComponentAt, findComponentAt, getComponent, getComponentAt, getComponentAt, getComponentCount, getComponents, getComponentZOrder, getContainerListeners, getFocusTraversalKeys, getFocusTraversalPolicy, getLayout, getMousePosition, insets, invalidate, isAncestorOf, isFocusCycleRoot, isFocusCycleRoot, isFocusTraversalPolicyProvider, isFocusTraversalPolicySet, layout, list, list, locate, minimumSize, paintComponents, preferredSize, printComponents, processContainerEvent, processEvent, remove, remove, removeAll, removeContainerListener, setComponentZOrder, setFocusCycleRoot, setFocusTraversalPolicy, setFocusTraversalPolicyProvider, setLayout, transferFocusDownCycle, validate, validateTree

Methods inherited from class java.awt.Component

action, add, addComponentListener, addFocusListener, addHierarchyBoundsListener, addHierarchyListener, addInputMethodListener, addKeyListener, addMouseListener, addMouseMotionListener, addMouseWheelListener, bounds, checkImage, checkImage, coalesceEvents, contains, createImage, createImage, createVolatileImage, createVolatileImage, disableEvents, dispatchEvent, enable, enableEvents, enableInputMethods, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, getBackground, getBounds, getColorModel, getComponentListeners, getComponentOrientation, getCursor, getDropTarget, getFocusCycleRootAncestor, getFocusListeners, getFocusTraversalKeysEnabled, getFont, getForeground, getGraphicsConfiguration, getHierarchyBoundsListeners, getHierarchyListeners, getIgnoreRepaint, getInputContext, getInputMethodListeners, getInputMethodRequests, getKeyListeners, getLocale, getLocation, getLocationOnScreen, getMouseListeners, getMouseMotionListeners, getMousePosition, getMouseWheelListeners, getName, getParent, getPeer, getPropertyChangeListeners, getPropertyChangeListeners, getSize, getToolkit, getTreeLock, gotFocus, handleEvent, hasFocus, hide, imageUpdate, inside, isBackgroundSet, isCursorSet, isDisplayable, isEnabled, isFocusable, isFocusOwner, isFocusTraversable, isFontSet, isForegroundSet, isLightweight, isMaximumSizeSet, isMinimumSizeSet, isPreferredSizeSet, isShowing, isValid, isVisible, keyDown, keyUp, list, list, list, location, lostFocus, mouseDown, mouseDrag, mouseEnter, mouseExit, mouseMove, mouseUp, move, nextFocus, paintAll, postEvent, prepareImage, prepareImage, processComponentEvent, processFocusEvent, processHierarchyBoundsEvent, processHierarchyEvent, processInputMethodEvent, processMouseWheelEvent, remove, removeComponentListener, removeFocusListener, removeHierarchyBoundsListener, removeHierarchyListener, removeInputMethodListener, removeKeyListener, removeMouseListener, removeMouseMotionListener, removeMouseWheelListener, removePropertyChangeListener, removePropertyChangeListener, repaint, repaint, repaint, resize, resize, setBounds, setBounds, setComponentOrientation, setCursor, setDropTarget, setFocusable, setFocusTraversalKeysEnabled, setIgnoreRepaint, setLocale, setLocation, setLocation, setName, setSize, setSize, show, show, size, toString, transferFocus, transferFocusBackward, transferFocusUpCycle

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.ontimize.gui.field.FormComponent

isEnabled, setEnabled, setVisible

Methods inherited from interface com.ontimize.gui.i18n.Internationalization

getTextsToTranslate, setComponentLocale

Methods inherited from interface com.ontimize.gui.SecureElement

initPermissions, isRestricted

Field Detail

ENTITY_PARAMETER

public static final String ENTITY_PARAMETER

See Also:

Constant Field Values

ROW_PARAMETER

public static final String ROW_PARAMETER

See Also:

Constant Field Values

COLUMN_PARAMETER

public static final String COLUMN_PARAMETER

See Also:

Constant Field Values

VALUE_PARAMETER

public static final String VALUE_PARAMETER

See Also:

Constant Field Values

KEYS_PARAMETER

public static final String KEYS_PARAMETER

See Also:

Constant Field Values

PARENTKEYS_PARAMETER

public static final String PARENTKEYS_PARAMETER

See Also:

Constant Field Values

OPERATION_PAREMETER

public static final String OPERATION_PAREMETER

See Also:

Constant Field Values

AVG_OPERATION_VALUE

public static final String AVG_OPERATION_VALUE

See Also:

Constant Field Values

SUM_OPERATION_VALUE

public static final String SUM_OPERATION_VALUE

See Also:

Constant Field Values

MAX_OPERATION_VALUE

public static final String MAX_OPERATION_VALUE

See Also:

Constant Field Values

MIN_OPERATION_VALUE

public static final String MIN_OPERATION_VALUE

See Also:

Constant Field Values

COUNT_OPERATION_VALUE

public static final String COUNT_OPERATION_VALUE

See Also:

Constant Field Values

DATE_GROUP_PARAMETER

public static final String DATE_GROUP_PARAMETER

See Also:

Constant Field Values

DMY_DATE_GROUP_VALUE

public static final String DMY_DATE_GROUP_VALUE

See Also:

Constant Field Values

MY_DATE_GROUP_VALUE

public static final String MY_DATE_GROUP_VALUE

See Also:

Constant Field Values

QY_DATE_GROUP_VALUE

public static final String QY_DATE_GROUP_VALUE

See Also:

Constant Field Values

M_DATE_GROUP_VALUE

public static final String M_DATE_GROUP_VALUE

See Also:

Constant Field Values

Q_DATE_GROUP_VALUE

public static final String Q_DATE_GROUP_VALUE

See Also:

Constant Field Values

Y_DATE_GROUP_VALUE

public static final String Y_DATE_GROUP_VALUE

See Also:

Constant Field Values

COMPARATOR

public static final String COMPARATOR

See Also:

Constant Field Values

PERCENTAGE_PARAMETER

public static final String PERCENTAGE_PARAMETER

See Also:

Constant Field Values

DEFAULT_OPERATION

public static int DEFAULT_OPERATION

DEFAULT_DATE_GROUP

public static int DEFAULT_DATE_GROUP

table

protected JTable table

entity

protected String entity

rows

protected Vector rows

column

protected String column

value

protected String value

keys

protected Vector keys

parentkeys

protected Vector parentkeys

bundle

protected ResourceBundle bundle

cacheValue

protected Object cacheValue

queryRowNumber

protected int queryRowNumber

operation

protected int operation

date_group

protected int date_group

comparators

protected Hashtable comparators

percentage

protected boolean percentage

parameters

protected Hashtable parameters

dDetailPivot

protected EJDialog dDetailPivot

Constructor Detail

PivotTable

public PivotTable(Hashtable h)
           throws Exception

Throws:

Exception

Method Detail

getJTable

public JTable getJTable()

init

public void init(Hashtable parameters)

Initializes parameters.

Specified by:

init in interface FormComponent

Overrides:

init in class IdentifiedAbstractFormComponent

Parameters:

parameters - the hashtable with parameters

attribute	values	default	required	meaning
entity			yes	Name of the entity to execute the query. This is the component attribute too.
rows	colum1;column2;...;columnN		yes	Name of the Y axis columns to groyp by
column			yes	Name of the x axis column. This is the pivot column.
value			yes
keys			yes	Entity keys
parentkeys			no	Foreign key column names
operation	avg/sum/max/min/count	avg	no	Operation to execute with the data in the column specified in the 'value' parameter
date_group	dmy,my,qy,m,q,y	dmy	no	Groupping type to apply in date columns (d-day,m-month,y-year,q-quarter)
comparator	column1;comparatorNameClass;column2;comparatorNameClass		no	Class to assign to the different columns or rows to set the appropriate order

jInit

protected void jInit()

installDetailMouseListener

protected void installDetailMouseListener()

showDetailPivotTableWindow

protected void showDetailPivotTableWindow(TableModel model,
                              Hashtable information)

getDetailWindowParameters

protected Hashtable getDetailWindowParameters()

getAttributes

protected Vector getAttributes()

getKeys

protected Vector getKeys()

getParentkeys

protected Vector getParentkeys()

getAttribute

public Object getAttribute()

Description copied from interface: IdentifiedElement

Gets the object attribute. This attribute allows to identify the object

Specified by:

getAttribute in interface IdentifiedElement

Overrides:

getAttribute in class IdentifiedAbstractFormComponent

deleteData

public void deleteData()

Description copied from interface: DataComponent

The method to delete data for component.

Specified by:

deleteData in interface DataComponent

getLabelComponentText

public String getLabelComponentText()

Description copied from interface: DataComponent

Returns the label text component. This label will change according to the Locale.

Specified by:

getLabelComponentText in interface DataComponent

Returns:

the label text

getSQLDataType

public int getSQLDataType()

Description copied from interface: DataComponent

Returns the sql data type according to java.sql.Types

Specified by:

getSQLDataType in interface DataComponent

Returns:

the Integer type

isEmpty

public boolean isEmpty()

Description copied from interface: DataComponent

Checks the data existence in component.

Specified by:

isEmpty in interface DataComponent

Returns:

true when component is empty

isHidden

public boolean isHidden()

Description copied from interface: DataComponent

Indicates to check the visibility condition for a component.

Specified by:

isHidden in interface DataComponent

Returns:

the visibility condition

isModifiable

public boolean isModifiable()

Description copied from interface: DataComponent

Checks the modifiable condition for a component. It is useful when it is not desired form deletes a component value.

Specified by:

isModifiable in interface DataComponent

Returns:

true when component is modifiable

isModified

public boolean isModified()

Description copied from interface: DataComponent

This method should be return true when data have been modified. The method setValue() should be change this condition.

Specified by:

isModified in interface DataComponent

Returns:

the modified condition

isRequired

public boolean isRequired()

Description copied from interface: DataComponent

Indicates the required condition for a component.

Specified by:

isRequired in interface DataComponent

Returns:

the required condition

setModifiable

public void setModifiable(boolean modifiable)

Description copied from interface: DataComponent

Establishes the modifiable condition for a component. When component is not modifiable, data will not be deleted automatically in DeleteFields call.

Specified by:

setModifiable in interface DataComponent

Parameters:

modifiable - the boolean condition

setRequired

public void setRequired(boolean required)

Description copied from interface: DataComponent

Sets required a component according to condition.

Specified by:

setRequired in interface DataComponent

Parameters:

required - the required condition

getValue

public Object getValue()

Description copied from interface: DataComponent

Gets the value of a component.

Specified by:

getValue in interface DataComponent

Returns:

the object with value.

setValue

public void setValue(Object value)

Description copied from interface: DataComponent

Sets the value for component.

Specified by:

setValue in interface DataComponent

Parameters:

value - the object with value to set

setResourceBundle

public void setResourceBundle(ResourceBundle res)

Description copied from interface: Internationalization

Sets the language resource bundle. When the application changes the configured language, for all the objects that implement this interface this method must be called with the new file.
The method must translate all the elements that have texts in the GUI

Specified by:

setResourceBundle in interface Internationalization

Overrides:

setResourceBundle in class AbstractFormComponent

Parameters:

res - the new language bundle.

getConstraints

public Object getConstraints(LayoutManager parentLayout)

Description copied from interface: FormComponent

Description method to return the constraints component to place correctly in parent container.

Specified by:

getConstraints in interface FormComponent

Overrides:

getConstraints in class AbstractFormComponent

Parameters:

parentLayout - the parent container reference

Returns:

the constraints for the component

setFont

public void setFont(Font f)

Overrides:

setFont in class JComponent

isPercentage

public boolean isPercentage()

setPercentage

public void setPercentage(boolean percentage)