org.bibalex.daf.managers.report
Class ReportData

java.lang.Object
  extended by java.awt.Component
      extended by java.awt.Container
          extended by java.awt.Window
              extended by java.awt.Dialog
                  extended by javax.swing.JDialog
                      extended by org.bibalex.daf.managers.report.ReportData
All Implemented Interfaces:
java.awt.image.ImageObserver, java.awt.MenuContainer, java.io.Serializable, javax.accessibility.Accessible, javax.swing.RootPaneContainer, javax.swing.WindowConstants

public class ReportData
extends javax.swing.JDialog

This class gets queries from multiple source and return the result into tabular form

Author:
Mohammed.Abuouda
See Also:
Serialized Form

Nested Class Summary
 
Nested classes/interfaces inherited from class javax.swing.JDialog
javax.swing.JDialog.AccessibleJDialog
 
Nested classes/interfaces inherited from class java.awt.Dialog
java.awt.Dialog.AccessibleAWTDialog
 
Nested classes/interfaces inherited from class java.awt.Window
java.awt.Window.AccessibleAWTWindow
 
Nested classes/interfaces inherited from class java.awt.Container
java.awt.Container.AccessibleAWTContainer
 
Nested classes/interfaces inherited from class java.awt.Component
java.awt.Component.AccessibleAWTComponent, java.awt.Component.BltBufferStrategy, java.awt.Component.FlipBufferStrategy
 
Field Summary
private  java.util.ArrayList arguments
           
private  javax.swing.JButton assignButton
          assignButton assigns a job
private  javax.swing.JButton changeTypeButton
          changeTypeButton changes a job type of a job
private  javax.swing.JButton closeButton
          closeButton disposes all
private  boolean columnsFormatted
           
private  javax.swing.JLabel countLabel
           
private  javax.swing.JButton deleteButton
          deleteButton deletes a job
private  javax.swing.JButton downloadButton
          downloadButton downloads a job
private  javax.swing.JButton exportButton
          exportButton exports reportTable to excel sheet
private  javax.swing.JPopupMenu jobPopupMenu
           
private  javax.swing.JPanel masterPanel
          masterPanel is the panel that carries the basic components which are reportTable, exportButton, closeButton, deleteButton, assignButton downloadButton, uploadButton and changeTypeButton
private  ReportData reportData
           
private  int reportID
          Variables****************************************
private  javax.swing.JLabel reportLabel
           
private  java.lang.String reportName
           
private  javax.swing.JLabel reportNameLabel
           
private  java.lang.String reportQuery
           
private  javax.swing.JScrollPane reportScrollPane
          reportScrollPane is the container Pane for reportTable
private  SortableTable reportTable
          reportTable is the table that shows up the query result
protected  ResourceManager resourceManager
           
private  Job selectedJob
           
private  java.lang.String spName
           
private  javax.swing.JButton uploadButton
          uploadButton uploads a job
 
Fields inherited from class javax.swing.JDialog
accessibleContext, rootPane, rootPaneCheckingEnabled
 
Fields inherited from class java.awt.Component
BOTTOM_ALIGNMENT, CENTER_ALIGNMENT, LEFT_ALIGNMENT, RIGHT_ALIGNMENT, TOP_ALIGNMENT
 
Fields inherited from interface javax.swing.WindowConstants
DISPOSE_ON_CLOSE, DO_NOTHING_ON_CLOSE, EXIT_ON_CLOSE, HIDE_ON_CLOSE
 
Fields inherited from interface java.awt.image.ImageObserver
ABORT, ALLBITS, ERROR, FRAMEBITS, HEIGHT, PROPERTIES, SOMEBITS, WIDTH
 
Constructor Summary
ReportData(int reportID, java.lang.String name)
          Integer constructor using with results of report builder.
ReportData(java.lang.String spName, java.util.ArrayList arguments, boolean columnsFormatted)
          String constructor using with advancedSearch and SimpleSearch SPs names
ReportData(java.lang.String reportQuery, java.lang.String name)
          String constructor using with results of searchGUI
 
Method Summary
private  void checkInJob(int phaseID, int userID, java.lang.String comment)
          Adds the job to the database.
private  void editPageLevelInfo()
          Show a dialog that allows the user to edit the page level info of the job.
private  javax.swing.JButton getAssignButton()
          this method initlize the assign button which carry out the function of assigning the job to selected phase, user
private  javax.swing.JButton getChangeTypeButton()
          This method initializes changeTypeButton which holds the logic of changing job type for a job
private  javax.swing.JButton getCloseButton()
           
private  javax.swing.JLabel getCountLabel()
          Shows resultset count
private  javax.swing.JButton getDeleteButton()
          Deletes Job in cascade mode
private  javax.swing.JButton getDownloadButton()
          This method initializes downloadButton
private  javax.swing.JMenuItem getEditFileInfoMenuItem()
          Initializes the EditFileInfoMenuItem.
private  javax.swing.JButton getExportButton()
          Exprots result table into excel sheet
private  javax.swing.JPopupMenu getJobPopupMenu()
          Initializes the popup menu.
private  javax.swing.JPanel getMasterPanel()
          This method initializes masterPanel
private  javax.swing.JLabel getReportLabel()
           
private  javax.swing.JLabel getReportNameLabel()
           
 javax.swing.JScrollPane getReportScrollPane()
          This method initializes getJobHistoryScrollPane
 javax.swing.JTable getReportTable()
          Executes the query and loads the result table
private  javax.swing.JButton getUploadButton()
          This method initializes uploadButton
private  javax.swing.JMenuItem getViewMetaDataMenuItem()
          Initializes the ViewJobHistoryMenuItem.
private  void initialize()
          This method initializes this
private  void showMsg(java.lang.String msg)
          Show error message
private  void showWarn(java.lang.String msg)
          Show warn message
 
Methods inherited from class javax.swing.JDialog
addImpl, createRootPane, dialogInit, getAccessibleContext, getContentPane, getDefaultCloseOperation, getGlassPane, getJMenuBar, getLayeredPane, getRootPane, isDefaultLookAndFeelDecorated, isRootPaneCheckingEnabled, paramString, processWindowEvent, remove, setContentPane, setDefaultCloseOperation, setDefaultLookAndFeelDecorated, setGlassPane, setJMenuBar, setLayeredPane, setLayout, setRootPane, setRootPaneCheckingEnabled, update
 
Methods inherited from class java.awt.Dialog
addNotify, getTitle, hide, isModal, isResizable, isUndecorated, setModal, setResizable, setTitle, setUndecorated, show
 
Methods inherited from class java.awt.Window
addPropertyChangeListener, addPropertyChangeListener, addWindowFocusListener, addWindowListener, addWindowStateListener, applyResourceBundle, applyResourceBundle, createBufferStrategy, createBufferStrategy, dispose, finalize, getBufferStrategy, getFocusableWindowState, getFocusCycleRootAncestor, getFocusOwner, getFocusTraversalKeys, getGraphicsConfiguration, getInputContext, getListeners, getLocale, getMostRecentFocusOwner, getOwnedWindows, getOwner, getToolkit, getWarningString, getWindowFocusListeners, getWindowListeners, getWindowStateListeners, isActive, isAlwaysOnTop, isFocusableWindow, isFocusCycleRoot, isFocused, isLocationByPlatform, isShowing, pack, postEvent, processEvent, processWindowFocusEvent, processWindowStateEvent, removeWindowFocusListener, removeWindowListener, removeWindowStateListener, setAlwaysOnTop, setBounds, setCursor, setFocusableWindowState, setFocusCycleRoot, setLocationByPlatform, setLocationRelativeTo, toBack, 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, paint, paintComponents, preferredSize, print, printComponents, processContainerEvent, remove, removeAll, removeContainerListener, removeNotify, setComponentZOrder, setFocusTraversalKeys, setFocusTraversalPolicy, setFocusTraversalPolicyProvider, setFont, 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, contains, createImage, createImage, createVolatileImage, createVolatileImage, disable, disableEvents, dispatchEvent, enable, enable, enableEvents, enableInputMethods, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, getBackground, getBounds, getBounds, getColorModel, getComponentListeners, getComponentOrientation, getCursor, getDropTarget, getFocusListeners, getFocusTraversalKeysEnabled, getFont, getFontMetrics, getForeground, getGraphics, getHeight, getHierarchyBoundsListeners, getHierarchyListeners, getIgnoreRepaint, getInputMethodListeners, getInputMethodRequests, getKeyListeners, getLocation, getLocation, getLocationOnScreen, getMouseListeners, getMouseMotionListeners, getMousePosition, getMouseWheelListeners, getName, getParent, getPeer, 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, isOpaque, 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, repaint, requestFocus, requestFocus, requestFocusInWindow, requestFocusInWindow, reshape, resize, resize, setBackground, setBounds, setComponentOrientation, setDropTarget, setEnabled, setFocusable, setFocusTraversalKeysEnabled, setForeground, setIgnoreRepaint, setLocale, setLocation, setLocation, setMaximumSize, setMinimumSize, setName, setPreferredSize, setSize, setSize, setVisible, show, size, toString, transferFocus, transferFocusUpCycle
 
Methods inherited from class java.lang.Object
clone, equals, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Field Detail

masterPanel

private javax.swing.JPanel masterPanel
masterPanel is the panel that carries the basic components which are reportTable, exportButton, closeButton, deleteButton, assignButton downloadButton, uploadButton and changeTypeButton


reportScrollPane

private javax.swing.JScrollPane reportScrollPane
reportScrollPane is the container Pane for reportTable


reportTable

private SortableTable reportTable
reportTable is the table that shows up the query result


exportButton

private javax.swing.JButton exportButton
exportButton exports reportTable to excel sheet


closeButton

private javax.swing.JButton closeButton
closeButton disposes all


deleteButton

private javax.swing.JButton deleteButton
deleteButton deletes a job


assignButton

private javax.swing.JButton assignButton
assignButton assigns a job


downloadButton

private javax.swing.JButton downloadButton
downloadButton downloads a job


uploadButton

private javax.swing.JButton uploadButton
uploadButton uploads a job


changeTypeButton

private javax.swing.JButton changeTypeButton
changeTypeButton changes a job type of a job


jobPopupMenu

private javax.swing.JPopupMenu jobPopupMenu

reportLabel

private javax.swing.JLabel reportLabel

reportNameLabel

private javax.swing.JLabel reportNameLabel

countLabel

private javax.swing.JLabel countLabel

reportID

private int reportID
Variables****************************************


reportData

private ReportData reportData

resourceManager

protected ResourceManager resourceManager

reportQuery

private java.lang.String reportQuery

reportName

private java.lang.String reportName

spName

private java.lang.String spName

columnsFormatted

private boolean columnsFormatted

arguments

private java.util.ArrayList arguments

selectedJob

private Job selectedJob
Constructor Detail

ReportData

public ReportData(int reportID,
                  java.lang.String name)
Integer constructor using with results of report builder.

Parameters:
reportID - The ID of the report.
name - The name of the report.

ReportData

public ReportData(java.lang.String reportQuery,
                  java.lang.String name)
String constructor using with results of searchGUI

Parameters:
reportQuery - The database query.
name - The name of the report.

ReportData

public ReportData(java.lang.String spName,
                  java.util.ArrayList arguments,
                  boolean columnsFormatted)
String constructor using with advancedSearch and SimpleSearch SPs names

Parameters:
spName - The procedure name
arguments - The arguments to be passed to sp.
columnsFormatted - indicates if column header is formatted or not
Method Detail

initialize

private void initialize()
This method initializes this


getMasterPanel

private javax.swing.JPanel getMasterPanel()
This method initializes masterPanel

Returns:
javax.swing.JPanel

getReportScrollPane

public javax.swing.JScrollPane getReportScrollPane()
This method initializes getJobHistoryScrollPane

Returns:
javax.swing.JScrollPane

getCloseButton

private javax.swing.JButton getCloseButton()

getExportButton

private javax.swing.JButton getExportButton()
Exprots result table into excel sheet

Returns:

getDeleteButton

private javax.swing.JButton getDeleteButton()
Deletes Job in cascade mode

Returns:

getDownloadButton

private javax.swing.JButton getDownloadButton()
This method initializes downloadButton

Returns:
javax.swing.JButton

getUploadButton

private javax.swing.JButton getUploadButton()
This method initializes uploadButton

Returns:
javax.swing.JButton

getChangeTypeButton

private javax.swing.JButton getChangeTypeButton()
This method initializes changeTypeButton which holds the logic of changing job type for a job

Returns:
javax.swing.JButton

getAssignButton

private javax.swing.JButton getAssignButton()
this method initlize the assign button which carry out the function of assigning the job to selected phase, user

Returns:
JButton.

getCountLabel

private javax.swing.JLabel getCountLabel()
Shows resultset count

Returns:

getReportLabel

private javax.swing.JLabel getReportLabel()

getReportNameLabel

private javax.swing.JLabel getReportNameLabel()

getReportTable

public javax.swing.JTable getReportTable()
Executes the query and loads the result table

Returns:

showMsg

private void showMsg(java.lang.String msg)
Show error message

Parameters:
msg -

showWarn

private void showWarn(java.lang.String msg)
Show warn message

Parameters:
msg -

checkInJob

private void checkInJob(int phaseID,
                        int userID,
                        java.lang.String comment)
Adds the job to the database.

Parameters:
phaseID - The ID of the phase to which the job will be assigned.
userID - The ID of the user to whom the job will be assigned.
comment - The comment to be included in the assign entry.

getJobPopupMenu

private javax.swing.JPopupMenu getJobPopupMenu()
Initializes the popup menu.

Returns:
javax.swing.JPopupMenu

getViewMetaDataMenuItem

private javax.swing.JMenuItem getViewMetaDataMenuItem()
Initializes the ViewJobHistoryMenuItem.

Returns:
javax.swing.JMenuItem

getEditFileInfoMenuItem

private javax.swing.JMenuItem getEditFileInfoMenuItem()
Initializes the EditFileInfoMenuItem.

Returns:
javax.swing.JMenuItem

editPageLevelInfo

private void editPageLevelInfo()
Show a dialog that allows the user to edit the page level info of the job.