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, java.awt.image.ImageObserver, Internationalization, java.awt.MenuContainer, SecureElement, java.io.Serializable

public class PivotTable

extends IdentifiedAbstractFormComponent

implements DataComponent

See Also:

Serialized Form

Nested Class Summary

Nested classes inherited from class javax.swing.JComponent

javax.swing.JComponent.AccessibleJComponent

Nested classes inherited from class java.awt.Container

java.awt.Container.AccessibleAWTContainer

Nested classes inherited from class java.awt.Component

java.awt.Component.AccessibleAWTComponent, java.awt.Component.BltBufferStrategy, java.awt.Component.FlipBufferStrategy

Field Summary

static java.lang.String	AVG_OPERATION_VALUE
protected java.util.ResourceBundle	bundle
protected java.lang.Object	cacheValue
protected java.lang.String	column
static java.lang.String	COLUMN_PARAMETER
static java.lang.String	COMPARATOR
protected java.util.Hashtable	comparators
static java.lang.String	COUNT_OPERATION_VALUE
protected int	date_group
static java.lang.String	DATE_GROUP_PARAMETER
protected EJDialog	dDetailPivot
static int	DEFAULT_DATE_GROUP
static int	DEFAULT_OPERATION
static java.lang.String	DMY_DATE_GROUP_VALUE
protected java.lang.String	entity
static java.lang.String	ENTITY_PARAMETER
protected java.util.Vector	keys
static java.lang.String	KEYS_PARAMETER
static java.lang.String	M_DATE_GROUP_VALUE
static java.lang.String	MAX_OPERATION_VALUE
static java.lang.String	MIN_OPERATION_VALUE
static java.lang.String	MY_DATE_GROUP_VALUE
protected int	operation
static java.lang.String	OPERATION_PAREMETER
protected java.util.Hashtable	parameters
protected java.util.Vector	parentkeys
static java.lang.String	PARENTKEYS_PARAMETER
protected boolean	percentage
static java.lang.String	PERCENTAGE_PARAMETER
static java.lang.String	Q_DATE_GROUP_VALUE
protected int	queryRowNumber
static java.lang.String	QY_DATE_GROUP_VALUE
static java.lang.String	ROW_PARAMETER
protected java.util.Vector	rows
static java.lang.String	SUM_OPERATION_VALUE
protected javax.swing.JTable	table
protected java.lang.String	value
static java.lang.String	VALUE_PARAMETER
static java.lang.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.field.FormComponent

DEBUG

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

PivotTable(java.util.Hashtable h)

Method Summary

void	deleteData() The method to delete data for component.
java.lang.Object	getAttribute() Gets the object attribute.
protected java.util.Vector	getAttributes()
java.lang.Object	getConstraints(java.awt.LayoutManager parentLayout) Description method to return the constraints component to place correctly in parent container.
protected java.util.Hashtable	getDetailWindowParameters()
javax.swing.JTable	getJTable()
protected java.util.Vector	getKeys()
java.lang.String	getLabelComponentText() Returns the label text component.
protected java.util.Vector	getParentkeys()
int	getSQLDataType() Returns the sql data type according to java.sql.Types
java.lang.Object	getValue() Gets the value of a component.
void	init(java.util.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(java.awt.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(java.util.ResourceBundle res) Sets the language resource bundle.
void	setValue(java.lang.Object value) Sets the value for component.
protected void	showDetailPivotTableWindow(javax.swing.table.TableModel model, java.util.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, addPropertyChangeListener, addPropertyChangeListener, addVetoableChangeListener, computeVisibleRect, contains, createToolTip, disable, enable, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, fireVetoableChange, getAccessibleContext, getActionForKeyStroke, getActionMap, getAlignmentX, getAlignmentY, getAncestorListeners, getAutoscrolls, getBorder, getBounds, getClientProperty, getComponentGraphics, getConditionForKeyStroke, getDebugGraphicsOptions, getDefaultLocale, getGraphics, getHeight, getInputMap, getInputMap, getInputVerifier, getInsets, getInsets, getListeners, getLocation, getMaximumSize, getMinimumSize, getNextFocusableComponent, getPreferredSize, getPropertyChangeListeners, getPropertyChangeListeners, getRegisteredKeyStrokes, getRootPane, getSize, getToolTipLocation, getToolTipText, getToolTipText, getTopLevelAncestor, getTransferHandler, getUIClassID, getVerifyInputWhenFocusTarget, getVetoableChangeListeners, getVisibleRect, getWidth, getX, getY, grabFocus, isDoubleBuffered, isLightweightComponent, isManagingFocus, isMaximumSizeSet, isMinimumSizeSet, isOpaque, isOptimizedDrawingEnabled, isPaintingTile, isPreferredSizeSet, isRequestFocusEnabled, isValidateRoot, paint, paintBorder, paintChildren, paintComponent, paintImmediately, paintImmediately, paramString, print, printAll, printBorder, printChildren, printComponent, processComponentKeyEvent, processKeyBinding, processKeyEvent, processMouseMotionEvent, putClientProperty, registerKeyboardAction, registerKeyboardAction, removeAncestorListener, removeNotify, removePropertyChangeListener, removePropertyChangeListener, removeVetoableChangeListener, repaint, repaint, requestDefaultFocus, requestFocus, requestFocus, requestFocusInWindow, requestFocusInWindow, resetKeyboardActions, reshape, revalidate, scrollRectToVisible, setActionMap, setAlignmentX, setAlignmentY, setAutoscrolls, setBackground, setBorder, setDebugGraphicsOptions, setDefaultLocale, setDoubleBuffered, setEnabled, setForeground, 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, applyComponentOrientation, areFocusTraversalKeysSet, countComponents, deliverEvent, doLayout, findComponentAt, findComponentAt, getComponent, getComponentAt, getComponentAt, getComponentCount, getComponents, getContainerListeners, getFocusTraversalKeys, getFocusTraversalPolicy, getLayout, insets, invalidate, isAncestorOf, isFocusCycleRoot, isFocusCycleRoot, isFocusTraversalPolicySet, layout, list, list, locate, minimumSize, paintComponents, preferredSize, printComponents, processContainerEvent, processEvent, remove, remove, removeAll, removeContainerListener, setFocusCycleRoot, setFocusTraversalKeys, setFocusTraversalPolicy, setLayout, transferFocusBackward, 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, getBackground, getBounds, getColorModel, getComponentListeners, getComponentOrientation, getCursor, getDropTarget, getFocusCycleRootAncestor, getFocusListeners, getFocusTraversalKeysEnabled, getFont, getFontMetrics, getForeground, getGraphicsConfiguration, getHierarchyBoundsListeners, getHierarchyListeners, getIgnoreRepaint, getInputContext, getInputMethodListeners, getInputMethodRequests, getKeyListeners, getLocale, getLocation, getLocationOnScreen, getMouseListeners, getMouseMotionListeners, getMouseWheelListeners, getName, getParent, getPeer, getSize, getToolkit, getTreeLock, gotFocus, handleEvent, hasFocus, hide, imageUpdate, inside, isBackgroundSet, isCursorSet, isDisplayable, isEnabled, isFocusable, isFocusOwner, isFocusTraversable, isFontSet, isForegroundSet, isLightweight, 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, processMouseEvent, processMouseWheelEvent, remove, removeComponentListener, removeFocusListener, removeHierarchyBoundsListener, removeHierarchyListener, removeInputMethodListener, removeKeyListener, removeMouseListener, removeMouseMotionListener, removeMouseWheelListener, repaint, repaint, repaint, resize, resize, setBounds, setBounds, setComponentOrientation, setCursor, setDropTarget, setFocusable, setFocusTraversalKeysEnabled, setIgnoreRepaint, setLocale, setLocation, setLocation, setName, setSize, setSize, show, show, size, toString, transferFocus, 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 java.lang.String ENTITY_PARAMETER

See Also:

Constant Field Values

ROW_PARAMETER

public static final java.lang.String ROW_PARAMETER

See Also:

Constant Field Values

COLUMN_PARAMETER

public static final java.lang.String COLUMN_PARAMETER

See Also:

Constant Field Values

VALUE_PARAMETER

public static final java.lang.String VALUE_PARAMETER

See Also:

Constant Field Values

KEYS_PARAMETER

public static final java.lang.String KEYS_PARAMETER

See Also:

Constant Field Values

PARENTKEYS_PARAMETER

public static final java.lang.String PARENTKEYS_PARAMETER

See Also:

Constant Field Values

OPERATION_PAREMETER

public static final java.lang.String OPERATION_PAREMETER

See Also:

Constant Field Values

AVG_OPERATION_VALUE

public static final java.lang.String AVG_OPERATION_VALUE

See Also:

Constant Field Values

SUM_OPERATION_VALUE

public static final java.lang.String SUM_OPERATION_VALUE

See Also:

Constant Field Values

MAX_OPERATION_VALUE

public static final java.lang.String MAX_OPERATION_VALUE

See Also:

Constant Field Values

MIN_OPERATION_VALUE

public static final java.lang.String MIN_OPERATION_VALUE

See Also:

Constant Field Values

COUNT_OPERATION_VALUE

public static final java.lang.String COUNT_OPERATION_VALUE

See Also:

Constant Field Values

DATE_GROUP_PARAMETER

public static final java.lang.String DATE_GROUP_PARAMETER

See Also:

Constant Field Values

DMY_DATE_GROUP_VALUE

public static final java.lang.String DMY_DATE_GROUP_VALUE

See Also:

Constant Field Values

MY_DATE_GROUP_VALUE

public static final java.lang.String MY_DATE_GROUP_VALUE

See Also:

Constant Field Values

QY_DATE_GROUP_VALUE

public static final java.lang.String QY_DATE_GROUP_VALUE

See Also:

Constant Field Values

M_DATE_GROUP_VALUE

public static final java.lang.String M_DATE_GROUP_VALUE

See Also:

Constant Field Values

Q_DATE_GROUP_VALUE

public static final java.lang.String Q_DATE_GROUP_VALUE

See Also:

Constant Field Values

Y_DATE_GROUP_VALUE

public static final java.lang.String Y_DATE_GROUP_VALUE

See Also:

Constant Field Values

COMPARATOR

public static final java.lang.String COMPARATOR

See Also:

Constant Field Values

PERCENTAGE_PARAMETER

public static final java.lang.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 javax.swing.JTable table

entity

protected java.lang.String entity

rows

protected java.util.Vector rows

column

protected java.lang.String column

value

protected java.lang.String value

keys

protected java.util.Vector keys

parentkeys

protected java.util.Vector parentkeys

bundle

protected java.util.ResourceBundle bundle

cacheValue

protected java.lang.Object cacheValue

queryRowNumber

protected int queryRowNumber

operation

protected int operation

date_group

protected int date_group

comparators

protected java.util.Hashtable comparators

percentage

protected boolean percentage

parameters

protected java.util.Hashtable parameters

dDetailPivot

protected EJDialog dDetailPivot

Constructor Detail

PivotTable

public PivotTable(java.util.Hashtable h)
           throws java.lang.Exception

Method Detail

getJTable

public javax.swing.JTable getJTable()

init

public void init(java.util.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(javax.swing.table.TableModel model,
                                          java.util.Hashtable information)

getDetailWindowParameters

protected java.util.Hashtable getDetailWindowParameters()

getAttributes

protected java.util.Vector getAttributes()

getKeys

protected java.util.Vector getKeys()

getParentkeys

protected java.util.Vector getParentkeys()

getAttribute

public java.lang.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 java.lang.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 java.lang.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(java.lang.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(java.util.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

getConstraints

public java.lang.Object getConstraints(java.awt.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

setFont

public void setFont(java.awt.Font f)

isPercentage

public boolean isPercentage()

setPercentage

public void setPercentage(boolean percentage)