Package org.compiere.apps.search

Class InfoGeneral

java.lang.Object

java.awt.Component

java.awt.Container

java.awt.Window

java.awt.Dialog

javax.swing.JDialog

org.compiere.swing.CDialog

org.compiere.apps.search.Info

org.compiere.apps.search.InfoGeneral

All Implemented Interfaces:

ActionListener, MouseListener, ImageObserver, MenuContainer, Serializable, EventListener, Accessible, ListSelectionListener, RootPaneContainer, WindowConstants

public class InfoGeneral
extends Info

Generic Table Search

Change log:

• 2007-02-14 - teo_sarca - [ 1659737 ] InfoGeneral not working with virtual columns

Version:

$Id: InfoGeneral.java,v 1.3 2006/10/06 00:42:38 jjanke Exp $

Author:

Jorg Janke

See Also:

Serialized Form

Nested Class Summary

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

JDialog.AccessibleJDialog

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

Dialog.AccessibleAWTDialog, Dialog.ModalExclusionType, Dialog.ModalityType

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

Window.AccessibleAWTWindow, Window.Type

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 inherited from class org.compiere.apps.search.Info

addonPanel, confirmPanel, INFO_WIDTH, log, p_keyColumn, p_layout, p_loadedOK, p_multiSelection, p_table, p_tableName, p_whereClause, p_WindowNo, parameterPanel, SCREEN_HEIGHT, statusBar

Fields inherited from class org.compiere.swing.CDialog

ACTION_DISPOSE, s_dialogAction, s_disposeKeyStroke

Fields inherited from class javax.swing.JDialog

accessibleContext, rootPane, rootPaneCheckingEnabled

Fields inherited from class java.awt.Dialog

DEFAULT_MODALITY_TYPE

Fields inherited from class java.awt.Component

BOTTOM_ALIGNMENT, CENTER_ALIGNMENT, LEFT_ALIGNMENT, RIGHT_ALIGNMENT, TOP_ALIGNMENT

Fields inherited from interface java.awt.image.ImageObserver

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

Fields inherited from interface javax.swing.WindowConstants

DISPOSE_ON_CLOSE, DO_NOTHING_ON_CLOSE, EXIT_ON_CLOSE, HIDE_ON_CLOSE

Constructor Summary

Constructors

Constructor	Description
InfoGeneral(Frame frame, boolean modal, int WindowNo, String value, String tableName, String keyColumn, boolean multiSelection, String whereClause)	Detail Protected Constructor.
InfoGeneral(Frame frame, boolean modal, int WindowNo, String value, String tableName, String keyColumn, boolean multiSelection, String whereClause, boolean lookup)	Detail Protected Constructor.

Method Summary

Modifier and Type	Method	Description
protected String	getSQLWhere()	Construct SQL Where Clause and define parameters.
protected void	setParameters(PreparedStatement pstmt, boolean forCount)	Set Parameters for Query.

Methods inherited from class org.compiere.apps.search.Info

actionPerformed, create, customize, dispose, dispose, doReset, enableButtons, executeQuery, getAD_Window_ID, getKeyColumn, getKeyColumnIndex, getSelectedKey, getSelectedKeys, getSelectedRowKey, getSelectedRowKeys, getSelectedSQL, getTableName, hasCustomize, hasHistory, hasReset, hasZoom, isCancelled, isCancelPressed, isDefaultSelected, isDoubleClickTogglesSelection, isLookup, isOkPressed, isResetValue, jbInit, loadedOK, mouseClicked, prepareTable, saveSelection, saveSelectionDetail, setDefaultSelected, setDoubleClickTogglesSelection, setStatusDB, setStatusLine, showAsset, showAssignment, showBPartner, showCashLine, showHistory, showInOut, showInvoice, showOrder, showPayment, showProduct, valueChanged, zoom, zoom

Methods inherited from class org.compiere.swing.CDialog

dialogInit, mouseEntered, mouseExited, mousePressed, mouseReleased, setTitle

Methods inherited from class javax.swing.JDialog

addImpl, createRootPane, getAccessibleContext, getContentPane, getDefaultCloseOperation, getGlassPane, getGraphics, getJMenuBar, getLayeredPane, getRootPane, getTransferHandler, isDefaultLookAndFeelDecorated, isRootPaneCheckingEnabled, paramString, processWindowEvent, remove, repaint, setContentPane, setDefaultCloseOperation, setDefaultLookAndFeelDecorated, setGlassPane, setJMenuBar, setLayeredPane, setLayout, setRootPane, setRootPaneCheckingEnabled, setTransferHandler, update

Methods inherited from class java.awt.Dialog

addNotify, getModalityType, getTitle, hide, isModal, isResizable, isUndecorated, setBackground, setModal, setModalityType, setOpacity, setResizable, setShape, setUndecorated, setVisible, show, toBack

Methods inherited from class java.awt.Window

addPropertyChangeListener, addPropertyChangeListener, addWindowFocusListener, addWindowListener, addWindowStateListener, applyResourceBundle, applyResourceBundle, createBufferStrategy, createBufferStrategy, getBackground, getBufferStrategy, getFocusableWindowState, getFocusCycleRootAncestor, getFocusOwner, getFocusTraversalKeys, getIconImages, getInputContext, getListeners, getLocale, getModalExclusionType, getMostRecentFocusOwner, getOpacity, getOwnedWindows, getOwner, getOwnerlessWindows, getShape, getToolkit, getType, getWarningString, getWindowFocusListeners, getWindowListeners, getWindows, getWindowStateListeners, isActive, isAlwaysOnTop, isAlwaysOnTopSupported, isAutoRequestFocus, isFocusableWindow, isFocusCycleRoot, isFocused, isLocationByPlatform, isOpaque, isShowing, isValidateRoot, pack, paint, postEvent, processEvent, processWindowFocusEvent, processWindowStateEvent, removeNotify, removeWindowFocusListener, removeWindowListener, removeWindowStateListener, reshape, setAlwaysOnTop, setAutoRequestFocus, setBounds, setBounds, setCursor, setFocusableWindowState, setFocusCycleRoot, setIconImage, setIconImages, setLocation, setLocation, setLocationByPlatform, setLocationRelativeTo, setMinimumSize, setModalExclusionType, setSize, setSize, setType, toFront

Methods inherited from class java.awt.Container

add, add, add, add, add, addContainerListener, applyComponentOrientation, areFocusTraversalKeysSet, countComponents, deliverEvent, doLayout, findComponentAt, findComponentAt, getAlignmentX, getAlignmentY, getComponent, getComponentAt, getComponentAt, getComponentCount, getComponents, getComponentZOrder, getContainerListeners, getFocusTraversalPolicy, getInsets, getLayout, getMaximumSize, getMinimumSize, getMousePosition, getPreferredSize, insets, invalidate, isAncestorOf, isFocusCycleRoot, isFocusTraversalPolicyProvider, isFocusTraversalPolicySet, layout, list, list, locate, minimumSize, paintComponents, preferredSize, print, printComponents, processContainerEvent, remove, removeAll, removeContainerListener, setComponentZOrder, setFocusTraversalKeys, setFocusTraversalPolicy, setFocusTraversalPolicyProvider, setFont, 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, contains, createImage, createImage, createVolatileImage, createVolatileImage, disable, disableEvents, dispatchEvent, enable, enable, enableEvents, enableInputMethods, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, getBaseline, getBaselineResizeBehavior, getBounds, getBounds, getColorModel, getComponentListeners, getComponentOrientation, getCursor, getDropTarget, getFocusListeners, getFocusTraversalKeysEnabled, getFont, getFontMetrics, getForeground, getGraphicsConfiguration, getHeight, getHierarchyBoundsListeners, getHierarchyListeners, getIgnoreRepaint, getInputMethodListeners, getInputMethodRequests, getKeyListeners, getLocation, getLocation, getLocationOnScreen, getMouseListeners, getMouseMotionListeners, getMousePosition, getMouseWheelListeners, getName, getParent, getPropertyChangeListeners, getPropertyChangeListeners, getSize, getSize, getTreeLock, getWidth, getX, getY, gotFocus, handleEvent, hasFocus, imageUpdate, inside, isBackgroundSet, isCursorSet, isDisplayable, isDoubleBuffered, isEnabled, isFocusable, isFocusOwner, isFocusTraversable, isFontSet, isForegroundSet, isLightweight, isMaximumSizeSet, isMinimumSizeSet, isPreferredSizeSet, isValid, isVisible, keyDown, keyUp, list, list, list, location, lostFocus, mouseDown, mouseDrag, mouseEnter, mouseExit, mouseMove, mouseUp, move, nextFocus, paintAll, prepareImage, prepareImage, printAll, processComponentEvent, processFocusEvent, processHierarchyBoundsEvent, processHierarchyEvent, processInputMethodEvent, processKeyEvent, processMouseEvent, processMouseMotionEvent, processMouseWheelEvent, remove, removeComponentListener, removeFocusListener, removeHierarchyBoundsListener, removeHierarchyListener, removeInputMethodListener, removeKeyListener, removeMouseListener, removeMouseMotionListener, removeMouseWheelListener, removePropertyChangeListener, removePropertyChangeListener, repaint, repaint, repaint, requestFocus, requestFocus, requestFocus, requestFocus, requestFocusInWindow, requestFocusInWindow, requestFocusInWindow, resize, resize, revalidate, setComponentOrientation, setDropTarget, setEnabled, setFocusable, setFocusTraversalKeysEnabled, setForeground, setIgnoreRepaint, setLocale, setMaximumSize, setMixingCutoutShape, setName, setPreferredSize, show, size, toString, transferFocus, transferFocusBackward, transferFocusUpCycle

Methods inherited from class java.lang.Object

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

Constructor Detail

InfoGeneral

public InfoGeneral(Frame frame,
                   boolean modal,
                   int WindowNo,
                   String value,
                   String tableName,
                   String keyColumn,
                   boolean multiSelection,
                   String whereClause)

Detail Protected Constructor.

Parameters:

frame - parent

modal - modal

WindowNo - window no

value - QueryValue

tableName - table name

keyColumn - key column (ignored)

multiSelection - multiple selections

whereClause - where clause

InfoGeneral

public InfoGeneral(Frame frame,
                   boolean modal,
                   int WindowNo,
                   String value,
                   String tableName,
                   String keyColumn,
                   boolean multiSelection,
                   String whereClause,
                   boolean lookup)

Detail Protected Constructor.

Parameters:

frame - parent

modal - modal

WindowNo - window no

value - QueryValue

tableName - table name

keyColumn - key column (ignored)

multiSelection - multiple selections

whereClause - where clause

lookup -

Method Detail

getSQLWhere

protected String getSQLWhere()

Construct SQL Where Clause and define parameters. (setParameters needs to set parameters) Includes first AND

Specified by:

getSQLWhere in class Info

Returns:

where clause

setParameters

protected void setParameters(PreparedStatement pstmt,
                             boolean forCount)
                      throws SQLException

Set Parameters for Query. (as defined in getSQLWhere)

Specified by:

setParameters in class Info

Parameters:

pstmt - statement

forCount - for counting records

Throws:

SQLException