psdi.webclient.beans.report

Class CreateReportBean

java.lang.Object

psdi.webclient.system.beans.WebClientBean

psdi.webclient.system.beans.DataBean

psdi.webclient.beans.report.CreateReportBean

All Implemented Interfaces:

java.util.EventListener, javax.servlet.http.HttpSessionBindingListener, DataBeanListener

public class CreateReportBean
extends DataBean

Field Summary

Fields inherited from class psdi.webclient.system.beans.DataBean

ALL_BOOKMARKS, ALL_RECORDS, alwaysSelected, app, appDefaultValues, appName, appWhere, ATTR_COLUMN, ATTR_DEFAULT, ATTR_QBE, ATTR_READONLY, ATTR_REFRESH_TABLE, ATTR_REQUIRED, ATTR_RESET, attributes, boundAttributes, boundInputs, closingBean, conditionallyRequired, creatingEvent, currentQuery, currentQueryDescription, currentRecordData, currentRow, defaultDynamicQbe, defaultOrderBy, defaultQbe, defaultUserValues, descAttributeId, designerMboName, dialogReferences, dynamicDefaults, emptyOnClear, ermEntity, esigvalidated, eventrow, fetchData, globalAppTableRetain, hasTableData, hasUnappliedAppDefaults, hasUnappliedQbeDefaults, keyAttribute, keyAttributes, lastEventHandled, lastfetchedindex, listeners, listTableModified, listTableRetain, LOG_CATEGORY, MAX_TABLEROWS, mboName, mbosetfromzombie, mboSetRemote, multiQbe, newRowUnedited, orderBy, parent, parentRelationship, propCache, qbeAttributes, qualrestrict, queryDescBeforeReviseAction, queryNameBeforeReviseAction, refreshList, refreshQbe, removeOnCancel, requiredFields, resetList, resetRemote, returnAttribute, returnComponent, returnComponentlId, ROW_DELETE, ROW_IGNORE, ROW_INSERT, ROW_MODIFY, rowsperpage, saveCount, savedFilterSettings, savedQbeAttributes, screenDesignMode, smartFillValue, startEmpty, startrow, TABLE_ALL_SELECTED, TABLE_AT_FIRST_PAGE, TABLE_AT_FIRST_ROW, TABLE_AT_LAST_PAGE, TABLE_AT_LAST_ROW, TABLE_DETAILS_EXPANDED, TABLE_EXPANDED, TABLE_FILTER_EXPANDED, TABLE_FILTERED, TABLE_REFRESH_ALL_ROWS, TABLE_REFRESH_FILTER, TABLE_REFRESH_ROW, TABLE_REFRESH_TITLE, TABLE_ROW_CHANGED, TABLE_START_EMPTY, TABLE_SUBSELECT_ON, TABLE_USE_SUBSELECT, tableAttributes, tableData, tableDataInvalid, tableStateFlags, userQbeNotCommited, userWhereClause, zombieData

Fields inherited from class psdi.webclient.system.beans.WebClientBean

clientSession, creator, EVENT_CONTINUE, EVENT_HANDLED, EVENT_STOP_ALL, id, sessionContext

Constructor Summary

Constructors

Constructor and Description
CreateReportBean()

Method Summary

Modifier and Type	Method and Description
int	addAll() This event is called from the Add All button on the Create Report dialog.
int	addExpression() Add expression to the expressions table on the calculate tab.
int	addSelectedAttributes()
int	addSelectedAttributesCalc()
int	addSelectedAttributesSum()
int	addSummary() Add expression to the summary table on the summary tab.
int	cancelExpression()
int	cancelSummary() Clears all the text entry fields when cancel button is pressed.
void	clearCalculateTabFields()
void	clearSummaryTabFields() Clears the non-persistent fields.
int	createuserreport() This event is called from the Submit button on the Create Report dialog.
boolean	evaluateExpression(boolean suppressValidate) Evaluates the expression created on the calculate tab.
static java.lang.String	getJdbcTypeName(int jdbcType)
void	initialize() Typically called after the DataBean gets a new MboSetRemote On the MboSetRemote it sets the app, the app defaults, user defaults If the remote is an instanceof NonPersistentMboSetRemote then setup is called on it and sets the current row to 0.
int	mathEvent()
int	previewReport()
int	refresh() This event is called from the Refresh button on the Create Report dialog.
int	refreshCalc() This event is called from the Refresh button on the Create Report dialog on the calulcate tab.
int	removeAll() This event is called from the Remove All button on the Create Report dialog.
int	removeFilterFields() Clear selections in the filter fields and the filter value entry table.
int	removeGroupFields() Clear selections in the group fields.
int	removeSelectedAttributes()
int	removeSortFields() Clear selections in the sort fields.
int	runAndSaveReport()
int	sumEvent() Handler to get the function button values
int	testExpression() Handles the event for clicking the test expression button on the calculate tab.

Methods inherited from class psdi.webclient.system.beans.DataBean

_useAllBookmarksQuery, _useAllRecsQuery, _usequery, addAttribute, addConditionalProperties, addDialogReference, addListener, addQbeAttribute, addrow, addSigOption, afterSetValue, applyValuesToSharedAttributes, applyValuesToSharedAttributes, asyncLocked, bindComponent, boundToTable, buildPortalMsg, callBeanMethod, callBeanMethod, callBeanMethod, callBeanMethod, callMethod, callMethod, callMethod, callMethod, callRemoteMethod, callRemoteMethod, cancelDialog, canCloseBean, canFetchData, changeRequiredField, checkAndDistributeRequiredError, checkESigAuthenticated, checkForAppError, checkMethodAccess, cleanup, clearBean, clearfilter, clearQbeAttributes, clearSavedFilterSettings, clearSavedQbeSettings, close, copytonewrow, count, dataChangedEvent, delete, delete, deleteAndRemove, deleteAndRemove, displaycount, duplicateMbo, execute, fetchRecordData, fetchTableData, fetchTableData, filterrows, findAndCallMethod, fireChildChangedEvent, fireDataChangedEvent, fireDataChangedEvent, fireStructureChangedEvent, fireStructureChangedEvent, getAppWhere, getAttributes, getBoolean, getBoolean, getCacheRowIndex, getColumnDate, getColumnString, getCompleteWhere, getConditionalProperties, getCurrentQueryDescription, getCurrentQueryName, getCurrentRow, getDataAsArray, getDataAsArray, getDataList, getDataList, getDataList, getDataList, getDataListFromMboSetRemote, getDate, getDefaultOrderBy, getDefaultValue, getDescAttributeId, getEndRow, getEventRowIndex, getKeyAttribute, getKeyAttributes, getLastEventHandled, getLastFetchIndex, getList, getList, getList, getLockedByDisplayName, getMbo, getMbo, getMboForUniqueId, getMboName, getMboOrZombie, getMboRowIndex, getMboSet, getMboSetData, getMboSetFromSmartFind, getMboSetFromSmartFind, getMboSetFromSmartFind, getMboSetRemote, getMboValueData, getMboValueData, getMboValueInfo, getMXSession, getNullRequiedFields, getOrderBy, getPageEndRow, getPageRowCount, getPageStartIndex, getParent, getParentRelationship, getQbe, getQbe, getQbeAttributes, getQueryDescBeforeReviseAction, getQueryNameBeforeReviseAction, getRemoteForDownload, getRemoteForLookup, getReturnAttribute, getReturnComponent, getReturnComponentId, getReturnControlId, getRowIndexFromEvent, getSavedFilterSettings, getSelectedDataAsArray, getSelectedDataAsArray, getSelection, getShowDetails, getSmartFillValue, getSortOrder, getString, getString, getTableAttributes, getTableOffset, getTableStateFlags, getTitle, getUIERMEntity, getUniqueIdFromSmartFill, getUniqueIdFromSmartFill, getUniqueIdName, getUniqueIdValue, getUserAndQbeWhere, getUserWhere, getWarnings, getWorkflowDirections, getZombie, getZombieMboValueData, handleRemoteException, handleRequiredFieldException, hasLongDescriptionText, hasLongDescriptionText, hasMboSetRemote, hasPageRows, hasRow, hasSameMboSet, hasSigOptionAccess, hasSigOptionAccess, hierarchicalmove, highlightrow, highlightrow, insert, insert, insertAtEnd, instantdelete, invalidateTableData, isAppTableRetain, isAttribute, isAttributeHidden, isAttributeHidden, isColumnSorted, isEmpty, isListTableModified, isListTableRetain, isLookupMultiSelect, isMboHidden, isMboHidden, isMboSetSame, isModifiedRow, isModifiedRow, isNewRow, isNewRow, isNewRowUnedited, isRowDeleted, isRowLocked, isSelected, isSubSelect, isTableAttribute, isTablePostionMarked, isTableRowSelected, isTableStateFlagSet, listenerChangedEvent, madeRequiredConditionally, markTablePosition, moveTo, moveToMboFromDataBean, needToAuthenticate, next, nextrow, notExist, positionState, preSaveChecks, previous, prevrow, propagateRequired, queryAllBookmarks, queryAllRecs, refreshFieldErrors, refreshTable, registerDynamicControlsWithERM, reloadTable, removeDialogReference, removeListener, removeRowOnCancel, rePosition, reserveOnePair, reset, resetDataBean, resetJSPFlags, resetQbe, resetWithSelection, restoreSavedQbeSettings, retainPosition, returnLookupValue, returnLookupValue, returnLookupValue, returnLookupValue, save, save, saveCurrentQbeSettings, scrollnext, scrollprev, select, select, selectAll, selectrecord, selectRows, sendRefreshTable, setApp, setApp, setAppDefault, setAppDefaults, setApplicationError, setAppWhere, setAsyncLock, setAttributes, setCurrentQueryDescription, setCurrentQueryName, setCurrentRecordData, setCurrentRow, setDate, setDate, setDate, setDefaultOrderBy, setDefaultQbe, setDefaultValue, setDefaultValue, setDescAttributeId, setDynamicAppDefaults, setDynamicDefault, setDynamicQbeDefaults, setEmptyOnClear, setERMOnMboSet, setEsigValidated, setEventRowIndex, setfiltervalue, setLastEventHandled, setListTableModified, setListTableRetain, setMboName, setNewRowUnedited, setOrderBy, setPageRowCount, setParent, setQbe, setQbe, setQbe, setQbe, setQbe, setQbeAttributes, setQbeCaseSensitive, setQbeDefaults, setQbeExactMatch, setQueryBySiteQbe, setQueryDescBeforeReviseAction, setQueryNameBeforeReviseAction, setRemoveOnCancel, setReturnAttribute, setReturnComponent, setReturnComponentId, setReturnControlId, setShowDetails, setSmartFillValue, setTableFlag, setupBean, setupBean, setupNonPersistent, setUserDefaults, setUserWhere, setvalue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValueFromComponent, smartFill, smartFill, sort, sort, sortcolumn, sortcolumn, sqlwhere, structureChangedEvent, toBeSaved, toggledeleterow, toggledetailstate, toggleselectallrows, toggleselectrow, toString, turnEmptyStateOn, unbindComponent, undelete, undelete, unselect, unselect, unselectAll, useAllBookmarksQuery, useAllRecsQuery, useqbe, usequery, useQuery, useStoredQuery, validate, validateChildren, validateClause, validateMbo, validateRow, valueBound, valueUnbound

Methods inherited from class psdi.webclient.system.beans.WebClientBean

getCreator, getId, setCreator, setId

Methods inherited from class java.lang.Object

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

Constructor Detail

CreateReportBean

public CreateReportBean()

Method Detail

initialize

public void initialize()
                throws MXException,
                       java.rmi.RemoteException

Description copied from class: DataBean

Typically called after the DataBean gets a new MboSetRemote On the MboSetRemote it sets the app, the app defaults, user defaults If the remote is an instanceof NonPersistentMboSetRemote then setup is called on it and sets the current row to 0. If the DataBean isn't bound to a table then initialize fetches the first mbo (sets the current row to 0). If this method is overridden under most case you will want to call super.initalize at the end of the the new initialize method.

Overrides:

initialize in class DataBean

Throws:

MXException

java.rmi.RemoteException

addAll

public int addAll()
           throws MXException,
                  java.rmi.RemoteException

This event is called from the Add All button on the Create Report dialog. It adds all of the available attributes meeting the current filter to the selected attributes table.

Throws:

MXException

java.rmi.RemoteException

addSelectedAttributesSum

public int addSelectedAttributesSum()
                             throws java.rmi.RemoteException,
                                    MXException

Throws:

java.rmi.RemoteException

MXException

addSelectedAttributes

public int addSelectedAttributes()
                          throws java.rmi.RemoteException,
                                 MXException

Throws:

java.rmi.RemoteException

MXException

removeSelectedAttributes

public int removeSelectedAttributes()
                             throws java.rmi.RemoteException,
                                    MXException

Throws:

java.rmi.RemoteException

MXException

refresh

public int refresh()
            throws MXException,
                   java.rmi.RemoteException

This event is called from the Refresh button on the Create Report dialog. It reorders the selected attributes table based on the user-entered sequence number.

Throws:

MXException

java.rmi.RemoteException

refreshCalc

public int refreshCalc()
                throws MXException,
                       java.rmi.RemoteException

This event is called from the Refresh button on the Create Report dialog on the calulcate tab. It reorders the selected attributes table based on the user-entered sequence number.

Throws:

MXException

java.rmi.RemoteException

removeAll

public int removeAll()
              throws MXException,
                     java.rmi.RemoteException

This event is called from the Remove All button on the Create Report dialog. It removes all of the selected attributes as well as the group and sort selections.

Throws:

MXException

java.rmi.RemoteException

removeGroupFields

public int removeGroupFields()
                      throws MXException,
                             java.rmi.RemoteException

Clear selections in the group fields.

Throws:

MXException

java.rmi.RemoteException

removeSortFields

public int removeSortFields()
                     throws MXException,
                            java.rmi.RemoteException

Clear selections in the sort fields.

Throws:

MXException

java.rmi.RemoteException

removeFilterFields

public int removeFilterFields()
                       throws MXException,
                              java.rmi.RemoteException

Clear selections in the filter fields and the filter value entry table.

Throws:

MXException

java.rmi.RemoteException

runAndSaveReport

public int runAndSaveReport()
                     throws java.rmi.RemoteException,
                            MXException

Throws:

java.rmi.RemoteException

MXException

previewReport

public int previewReport()
                  throws java.rmi.RemoteException,
                         MXException

Throws:

java.rmi.RemoteException

MXException

createuserreport

public int createuserreport()
                     throws MXException,
                            java.rmi.RemoteException

This event is called from the Submit button on the Create Report dialog.

Throws:

MXException

java.rmi.RemoteException

evaluateExpression

public boolean evaluateExpression(boolean suppressValidate)
                           throws MXException,
                                  java.rmi.RemoteException,
                                  java.text.ParseException

Evaluates the expression created on the calculate tab.

Throws:

MXException

java.rmi.RemoteException

java.text.ParseException

testExpression

public int testExpression()
                   throws MXException,
                          java.rmi.RemoteException,
                          java.text.ParseException

Handles the event for clicking the test expression button on the calculate tab.

Throws:

MXException

java.rmi.RemoteException

java.text.ParseException

mathEvent

public int mathEvent()
              throws MXException,
                     java.rmi.RemoteException

Throws:

MXException

java.rmi.RemoteException

sumEvent

public int sumEvent()
             throws MXException,
                    java.rmi.RemoteException

Handler to get the function button values

Returns:

EVENT_HANDLED

Throws:

MXException

java.rmi.RemoteException

addSelectedAttributesCalc

public int addSelectedAttributesCalc()
                              throws MXException,
                                     java.rmi.RemoteException

Throws:

MXException

java.rmi.RemoteException

addExpression

public int addExpression()
                  throws MXException,
                         java.rmi.RemoteException,
                         java.text.ParseException

Add expression to the expressions table on the calculate tab. Checks to see if the user is currently editing. If so, will overwrite the current expression instead of adding.

Returns:

Throws:

MXException

java.rmi.RemoteException

java.text.ParseException

getJdbcTypeName

public static java.lang.String getJdbcTypeName(int jdbcType)

addSummary

public int addSummary()
               throws MXException,
                      java.rmi.RemoteException,
                      java.text.ParseException

Add expression to the summary table on the summary tab.

Returns:

Throws:

MXException

java.rmi.RemoteException

java.text.ParseException

cancelExpression

public int cancelExpression()
                     throws MXException,
                            java.rmi.RemoteException

Throws:

MXException

java.rmi.RemoteException

cancelSummary

public int cancelSummary()
                  throws MXException,
                         java.rmi.RemoteException

Clears all the text entry fields when cancel button is pressed.

Returns:

Throws:

MXException

java.rmi.RemoteException

clearCalculateTabFields

public void clearCalculateTabFields()
                             throws MXException,
                                    java.rmi.RemoteException

Throws:

MXException

java.rmi.RemoteException

clearSummaryTabFields

public void clearSummaryTabFields()
                           throws MXException,
                                  java.rmi.RemoteException

Clears the non-persistent fields.

Throws:

MXException

java.rmi.RemoteException