psdi.app.item

Class ItemSpecSet

java.lang.Object

psdi.mbo.MboSet

psdi.app.assetcatalog.SpecificationMboSet

psdi.app.item.ItemSpecSet

All Implemented Interfaces:

java.rmi.Remote, SpecificationMboSetRemote, ItemSpecSetRemote, MboAccessInterface, MboConstants, MboSetRemote, MaxRemoteProxy, Transactable, FixedLoggerNames, FixedLoggers

public class ItemSpecSet
extends SpecificationMboSet
implements ItemSpecSetRemote

Represents the set of ItemSpecs.

Field Summary

Fields inherited from class psdi.app.assetcatalog.SpecificationMboSet

currentClassSpecUseWithMbo, dbUpper, mboSetAttributeSearch

Fields inherited from class psdi.mbo.MboSet

fetchStopLimitEnabled, LOOKUPMAXROW, maxSorterSize, mboCountCleanuplist, perfStats, strNoBaseLangValueEntered

Fields inherited from interface psdi.app.item.ItemSpecSetRemote

ASSETATTRIBUTE, CLASSSPEC, CLASSSTRUCTURE, ITEM, MEASUREUNIT, ROTATINGASSETSPEC, ROTATINGLOCATIONSPEC

Fields inherited from interface psdi.mbo.MboSetRemote

INSERTONLY, INSERTORUPDATE, UPDATEONLY

Fields inherited from interface psdi.mbo.MboConstants

ALLROWS, CHANGEDBY_USER, COUNT_ADDITIONS, COUNT_AFTERSAVE, COUNT_DATABASE, COUNT_DELETED, COUNT_EXISTING, DBCONFIG, DELAYVALIDATION, DELAYVALIDATIONONLY, DISCARDABLE, GOTCOMPLETEWHERE, HIDDEN, NO_RELATEDMBOS_OF_OWNERSCHILDREN_FETCH, NOACCESSCHECK, NOACTION, NOADD, NOCOMMIT, NODELETE, NONE, NOOVERWRITE, NOSAVE, NOSETVALUE, NOUPDATE, NOVALIDATION, NOVALIDATION_AND_NOACTION, NOVALIDATION_AND_NOACTION_ALLOWCROSSOVER, READONLY, REBUILD, REQUIRED, SAMEVALUEVALIDATION, SETBYPARENT, USER

Fields inherited from interface psdi.util.logging.FixedLoggers

APPLOGGER, CRONTASKLOGGER, CRONTASKMGRLOGGER, CRONTASKMGRSQLLOGGER, DBCONNECTIONLOGGER, DDLOGGER, DMLOGGER, EVENTLOGGER, EXCEPTIONLOGGER, MAILLOGGER, MAXIMOLOGGER, MTLOGGER, NULLMBOPOINTER, SECURITY, SENDFAILEDLOGGER, SERVICELOGGER, SQLLOGGER

Fields inherited from interface psdi.util.logging.FixedLoggerNames

appenderPrefix, LOGGERNAME_APP, LOGGERNAME_CRONTASK, LOGGERNAME_CRONTASKMGR, LOGGERNAME_DBCONNECTION, LOGGERNAME_DD, LOGGERNAME_DM, LOGGERNAME_DMPREVIEW, LOGGERNAME_EVENT, LOGGERNAME_EXCEPTION, LOGGERNAME_MAIL, LOGGERNAME_MAXIMO, LOGGERNAME_MT, LOGGERNAME_NULLMBOPOINTER, LOGGERNAME_SECURITY, LOGGERNAME_SENDFAILED, LOGGERNAME_SERVICE, LOGGERNAME_SQL, LOGGERNAME_SQL_CRONTASKMGR, LOGGERNAME_TXN, loggerPrefix

Constructor Summary

Constructors

Constructor and Description
ItemSpecSet(MboServerInterface ms) Construct the set

Method Summary

Modifier and Type	Method and Description
void	prepareDeleteAssetSpec(boolean isPreprocess) 08-23855
void	prepareUpdateAssetSpecHist(boolean isPreprocess) 08-23855
void	prepareUpdateClassStructureID() 08-23855
void	preProcessPreparedStatements() 08-23855: if classstructure is changed from one(not null) to a new one.
void	processPreparedStatements() 08-23855
void	processPreparedStatementsForUpdate() 10-14955: processes the update statement-when itemspec is updated in alnvalue,numvalue, or tablevalue, update corresponding assetspec records it includes update assetspec and insert into assetspechist
void	saveTransaction(MXTransaction txn) 08-23855 Call super, then set value for refreshCache.
void	storeSpecInsertStatement(java.lang.String preparedInsert) 08-23855
void	storeSpecUpdateStatement(java.lang.String preparedUpdate) 10-14955: when rotating itemspec is updated, update assetspec records
java.lang.String	whereClauseOnAttrAndValues(java.lang.String[][] attrAndValues) This method overloads the abstract method whereClauseOnAttrAndValues(String[][] attrAndValues,String classstructureid) defined in psdi.app.assetcatalog.SpecificationSet This method returns a String to the caller.
java.lang.String	whereClauseOnAttrAndValues(java.lang.String[][] attrAndValues, java.lang.String classstructureid) This method implements the abstract method on psdi.app.assetcatalog.SpecificationSet This method returns a String to the caller.

Methods inherited from class psdi.app.assetcatalog.SpecificationMboSet

canAdd, checkCommonSpecDuplicates, checkValueExists, getAttributesSearchMboSet, getCurrentClassSpecUseWithMbo, getGeneratedDesc, getGeneratedDescWithQbe, isLinear, setAttributesSearchMboSet, setCurrentClassSpecUseWithMbo, setDescGenerated, sortThisSetByDisplaySeq, toCheckClassSpecUseWith, toCreateNewSpecRecordsInMainObject, wasDescGenerated

Methods inherited from class psdi.mbo.MboSet

abortSql, add, add, addAtEnd, addAtEnd, addAtIndex, addAtIndex, addFakeAtEnd, addFederatedMboToSorter, addSubQbe, addSubQbe, addSubQbe, addSubQbe, addToEndOfSelectStatement, addWarning, addWarnings, appendToWhere, applyRowSecurity, avg, cancelAndClose, checkMethodAccess, checkMethodAccess, cleanup, clear, clearBatchedPreparedStmt, clearBatchedPreparedStmts, clearESigTransactionIdThread, clearESigTransIDForAdmin, clearIgnoredAutokeyAttrs, clearLongOpPipe, clearToBeSaved, clearTransactionReference, clearWarnings, close, commit, commitTransaction, copy, copy, copy, copyForDM, count, count, deleteAll, deleteAll, deleteAndRemove, deleteAndRemove, deleteAndRemove, deleteAndRemove, deleteAndRemove, deleteAndRemoveAll, deleteAndRemoveAll, determineRequiredFieldsFromERM, dump, earliestDate, enableMethod, executeBatch, fetchNext, findAllNullRequiredFields, findByIntegrationKey, findKey, fireEventsAfterDB, fireEventsAfterDBCommit, fireEventsBeforeDB, forceDBSort, getAllowQualifiedRestriction, getAlwaysFlags, getAlwaysFlags, getApp, getAppAlwaysFieldFlags, getAppWhere, getAttrRestrictions, getBoolean, getByte, getBytes, getClientLocale, getClientTimeZone, getCompleteWhere, getCurrentPosition, getDate, getDBFetchMaxRows, getDefaultValue, getDefaultValueHash, getDouble, getERMEntity, getESigTransactionId, getExcludeMeFromPropagation, getFlags, getFloat, getIgnoredAutokeyAttrs, getInsertCompanySet, getInsertItemSet, getInsertOrg, getInsertSite, getInt, getJspDefaultValueHash, getKeyAttributes, getList, getList, getLong, getMaxAppsWhere, getMaxMessage, getMbo, getMbo, getMboForUniqueId, getMboLogger, getMboServer, getMboSetData, getMboSetData, getMboSetInfo, getMboSetRetainMboPositionData, getMboSetRetainMboPositionInfo, getMboSetValueData, getMboSetValueData, getMboValueData, getMboValueData, getMboValueData, getMboValueInfoStatic, getMboValueInfoStatic, getMessage, getMessage, getMessage, getMessage, getMLFromClause, getMultiSiteWhere, getMXTransaction, getName, getOrderBy, getOwner, getParentApp, getPreparedStmt, getProfile, getProxy, getQbe, getQbe, getQbe, getQbeSiteAuthorization, getQbeWhere, getQualifiedWhere, getQueryTimeout, getRelationName, getRelationship, getRowRestrictions, getSecurityLogger, getSelection, getSelectionWhere, getSetOrderByForUI, getSharedMboSet, getSize, getSkipFirstNRows, getSqlLogger, getSQLOptions, getString, getTxnPropertyMap, getUserAndQbeWhere, getUserInfo, getUserName, getUserPrefWhere, getUserWhere, getUserWhere, getWarnings, getWhere, getZombie, handleMLMbo, handleMLMbo, hasMLQbe, hasQbe, hasWarnings, ignoreAutokeyAttr, ignoreAutokeyAttr, ignoreQbeExactMatchSet, incrementDeletedCount, init, init, initDataDictionary, isBasedOn, isClosed, isDeltaStorage, isDMDeploySet, isDMSkipFieldValidation, isEAuditFieldModified, isEmpty, isESigFieldModified, isESigNeeded, isFlagSet, isIgnoreQbeExactMatchSet, isLookup, isNull, isQbeCaseSensitive, isQbeExactMatch, isRetainMboPosition, isTableDomainLookup, latestDate, locateMbo, logESigVerification, logRowUpdatedException, max, min, moveFirst, moveLast, moveNext, movePrev, moveTo, moveToKey, newMboIndex, notExist, positionState, processML, remove, remove, remove, reset, resetForRefreshOnSave, resetQbe, resetWithSelection, rollback, rollbackToCheckpoint, rollbackToCheckpoint, rollbackTransaction, save, save, save, save, saveMbos, select, select, select, selectAll, setAllowQualifiedRestriction, setApp, setAppAlwaysFieldFlag, setAppWhere, setAutoKeyFlag, setDBFetchMaxRows, setDefaultOrderBy, setDefaultValue, setDefaultValue, setDefaultValues, setDefaultValues, setDMDeploySet, setDMSkipFieldValidation, setEAuditFieldModified, setERMEntity, setESigFieldModified, setExcludeMeFromPropagation, setFederatedResources, setFlag, setFlag, setFlags, setInsertCompanySet, setInsertItemSet, setInsertOrg, setInsertSite, setLastESigTransId, setLogLargFetchResultDisabled, setMboSetInfo, setMXTransaction, setNoNeedtoFetchFromDB, setOrderBy, setOrderByNVL, setOwner, setPreserveOrderByCase, setProxy, setQbe, setQbe, setQbe, setQbe, setQbe, setQbeCaseSensitive, setQbeCaseSensitive, setQbeExactMatch, setQbeExactMatch, setQbeOperatorOr, setQueryBySiteQbe, setQueryTimeout, setRelationName, setRelationship, setRequiedFlagsFromERM, setRetainMboPosition, setSetOrderByForUI, setSkipFirstNRows, setSQLOptions, setTableDomainLookup, setTxnPropertyMap, setupLongOpPipe, setUserWhere, setUserWhereAfterParse, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValueNull, setValueNull, setWhere, setWhereQbe, smartFill, smartFill, smartFind, smartFind, smartFind, smartFind, sort, splitOrderBy, startCheckpoint, startCheckpoint, sum, toBeSaved, undeleteAll, undoTransaction, unselect, unselect, unselect, unselectAll, useStoredQuery, validate, validateTransaction, verifyESig

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface psdi.app.assetcatalog.SpecificationMboSetRemote

checkCommonSpecDuplicates, checkValueExists, getGeneratedDesc

Methods inherited from interface psdi.mbo.MboSetRemote

abortSql, add, add, addAtEnd, addAtEnd, addAtIndex, addAtIndex, addFakeAtEnd, addSubQbe, addSubQbe, addSubQbe, addSubQbe, addWarning, addWarnings, checkMethodAccess, cleanup, clear, clearLongOpPipe, close, commit, copy, copy, copyForDM, count, count, deleteAll, deleteAll, deleteAndRemove, deleteAndRemove, deleteAndRemove, deleteAndRemove, deleteAndRemove, deleteAndRemoveAll, deleteAndRemoveAll, determineRequiredFieldsFromERM, earliestDate, fetchNext, findAllNullRequiredFields, findByIntegrationKey, findKey, getApp, getAppAlwaysFieldFlags, getAppWhere, getCompleteWhere, getCurrentPosition, getDBFetchMaxRows, getDefaultValue, getERMEntity, getESigTransactionId, getExcludeMeFromPropagation, getFlags, getKeyAttributes, getList, getList, getMaxMessage, getMbo, getMbo, getMboForUniqueId, getMboSetData, getMboSetData, getMboSetInfo, getMboSetRetainMboPositionData, getMboSetRetainMboPositionInfo, getMboSetValueData, getMboValueData, getMboValueData, getMboValueData, getMboValueInfoStatic, getMboValueInfoStatic, getMessage, getMessage, getMessage, getMessage, getMLFromClause, getMXTransaction, getName, getOrderBy, getOwner, getParentApp, getProfile, getQbe, getQbe, getQbe, getQbeWhere, getQueryTimeout, getRelationName, getRelationship, getSelection, getSelectionWhere, getSetOrderByForUI, getSize, getSQLOptions, getTxnPropertyMap, getUserAndQbeWhere, getUserInfo, getUserName, getUserWhere, getWarnings, getWhere, getZombie, hasMLQbe, hasQbe, hasWarnings, ignoreQbeExactMatchSet, incrementDeletedCount, init, isBasedOn, isDMDeploySet, isDMSkipFieldValidation, isEmpty, isESigNeeded, isFlagSet, isQbeCaseSensitive, isQbeExactMatch, isRetainMboPosition, latestDate, locateMbo, logESigVerification, max, min, moveFirst, moveLast, moveNext, movePrev, moveTo, newMboIndex, notExist, positionState, processML, remove, remove, remove, reset, resetQbe, resetWithSelection, rollback, rollbackToCheckpoint, rollbackToCheckpoint, save, save, select, select, select, selectAll, setAllowQualifiedRestriction, setApp, setAppAlwaysFieldFlag, setAppWhere, setAutoKeyFlag, setDBFetchMaxRows, setDefaultOrderBy, setDefaultValue, setDefaultValue, setDefaultValues, setDMDeploySet, setDMSkipFieldValidation, setERMEntity, setESigFieldModified, setExcludeMeFromPropagation, setFlag, setFlag, setFlags, setInsertCompanySet, setInsertItemSet, setInsertOrg, setInsertSite, setLastESigTransId, setLogLargFetchResultDisabled, setMboSetInfo, setMXTransaction, setNoNeedtoFetchFromDB, setOrderBy, setOwner, setQbe, setQbe, setQbe, setQbe, setQbe, setQbeCaseSensitive, setQbeCaseSensitive, setQbeExactMatch, setQbeExactMatch, setQbeOperatorOr, setQueryBySiteQbe, setQueryTimeout, setRelationName, setRelationship, setRequiedFlagsFromERM, setRetainMboPosition, setSetOrderByForUI, setSQLOptions, setTableDomainLookup, setTxnPropertyMap, setupLongOpPipe, setUserWhere, setUserWhereAfterParse, setWhere, setWhereQbe, smartFill, smartFill, smartFind, smartFind, startCheckpoint, startCheckpoint, sum, toBeSaved, undeleteAll, unselect, unselect, unselect, unselectAll, useStoredQuery, validate, verifyESig

Methods inherited from interface psdi.mbo.MboAccessInterface

getBoolean, getByte, getBytes, getDate, getDouble, getFloat, getInt, getLong, getString, isNull, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValueNull, setValueNull

Methods inherited from interface psdi.txn.Transactable

commitTransaction, fireEventsAfterDB, fireEventsAfterDBCommit, fireEventsBeforeDB, rollbackTransaction, undoTransaction, validateTransaction

Constructor Detail

ItemSpecSet

public ItemSpecSet(MboServerInterface ms)
            throws MXException,
                   java.rmi.RemoteException

Construct the set

Throws:

MXException

java.rmi.RemoteException

Method Detail

whereClauseOnAttrAndValues

public java.lang.String whereClauseOnAttrAndValues(java.lang.String[][] attrAndValues,
                                                   java.lang.String classstructureid)
                                            throws MXException,
                                                   java.rmi.RemoteException

This method implements the abstract method on psdi.app.assetcatalog.SpecificationSet This method returns a String to the caller. It loops thru the passed two dimensional array and produces a where clause in view of Item/ItemSpec to the caller. Since ItemSpec does not have to use the classstructureid, it calls the overloaded function whereClauseOnAttrAndValues(String[][] attrAndValues)

Specified by:

whereClauseOnAttrAndValues in interface SpecificationMboSetRemote

Overrides:

whereClauseOnAttrAndValues in class SpecificationMboSet

Parameters:

attrAndValues - The two dimensional array holds the assetattrids and and their values in appropriate measureunitids. Its contents look like the following: [0][0] = "assetattrid='SIZE'", [0][1]=" numvalue > 1.5"; [0][2] = "measureunitid like 'RPM%" IV81743: added section, so example if section is populated [0][4] = "section like '%SEC%'

classstructureid - The classstructureid to be searched upon.

Returns:

String - resulting where clause

Throws:

MXException

java.rmi.RemoteException

See Also:

SpecificationMboSet.whereClauseOnAttrAndValues(String[][], String)

whereClauseOnAttrAndValues

public java.lang.String whereClauseOnAttrAndValues(java.lang.String[][] attrAndValues)
                                            throws MXException,
                                                   java.rmi.RemoteException

This method overloads the abstract method whereClauseOnAttrAndValues(String[][] attrAndValues,String classstructureid) defined in psdi.app.assetcatalog.SpecificationSet This method returns a String to the caller. It loops thru the passed two dimensional array and produces a where clause in view of Item/ItemSpec to the caller. The two dimensional array holds the assetattrids and and their values. Its contents look like the following: [0][0] = "assetattrid='SIZE'", [0][1]=" numvalue > 1.5"; [0][2] = "measureunitid = 'RPM'", or "measureunitid like 'RPM%'";

Overrides:

whereClauseOnAttrAndValues in class SpecificationMboSet

Throws:

MXException

java.rmi.RemoteException

saveTransaction

public void saveTransaction(MXTransaction txn)
                     throws MXException,
                            java.rmi.RemoteException

08-23855 Call super, then set value for refreshCache.

Specified by:

saveTransaction in interface Transactable

Overrides:

saveTransaction in class MboSet

Parameters:

txn - Transaction that cuased the save

Throws:

MXException - Error while saving

java.rmi.RemoteException - Network error

See Also:

Mbo.checkSiteOrgAccessForSave()

processPreparedStatements

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

08-23855

Throws:

MXException

java.rmi.RemoteException

storeSpecInsertStatement

public void storeSpecInsertStatement(java.lang.String preparedInsert)
                              throws MXException,
                                     java.rmi.RemoteException

08-23855

Throws:

MXException

java.rmi.RemoteException

prepareUpdateClassStructureID

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

08-23855

Throws:

MXException

java.rmi.RemoteException

prepareDeleteAssetSpec

public void prepareDeleteAssetSpec(boolean isPreprocess)
                            throws MXException,
                                   java.rmi.RemoteException

08-23855

Throws:

MXException

java.rmi.RemoteException

prepareUpdateAssetSpecHist

public void prepareUpdateAssetSpecHist(boolean isPreprocess)
                                throws MXException,
                                       java.rmi.RemoteException

08-23855

Throws:

MXException

java.rmi.RemoteException

preProcessPreparedStatements

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

08-23855: if classstructure is changed from one(not null) to a new one.

Throws:

MXException

java.rmi.RemoteException

storeSpecUpdateStatement

public void storeSpecUpdateStatement(java.lang.String preparedUpdate)
                              throws MXException,
                                     java.rmi.RemoteException

10-14955: when rotating itemspec is updated, update assetspec records

Parameters:

preparedUpdate -

Throws:

MXException

java.rmi.RemoteException

processPreparedStatementsForUpdate

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

10-14955: processes the update statement-when itemspec is updated in alnvalue,numvalue, or tablevalue, update corresponding assetspec records it includes update assetspec and insert into assetspechist

Throws:

MXException

java.rmi.RemoteException