com.ibm.tivoli.maximo.skd.app

Class SKDLaborHrsSet

java.lang.Object

psdi.mbo.MboSet

com.ibm.tivoli.maximo.skd.app.SKDLaborHrsSet

All Implemented Interfaces:

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

public class SKDLaborHrsSet
extends MboSet
implements SKDLaborHrsSetRemote

This class is for used to populate planned and available hours in Resource Load and Availability tab.

Field Summary

Fields inherited from class psdi.mbo.MboSet

fetchStopLimitEnabled, LOOKUPMAXROW, maxSorterSize, mboCountCleanuplist, perfStats, strNoBaseLangValueEntered

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
SKDLaborHrsSet(MboServerInterface ms)

Method Summary

Modifier and Type	Method and Description
void	addSKDLaborHrsTemp(long SKDProjectId, java.util.HashMap<java.lang.String,java.util.ArrayList<com.ibm.tivoli.maximo.skd.app.SKDLaborHrsSet.WOActivity>> craftActivityListMap, java.lang.String cond) add to skdlaborhrstemp table.
void	deleteSKDLaborHours() This method deletes the data from skdlaborhrs table.
void	deleteSKDLaborHrs(long SKDProjectId) This method deletes the data from skdlaborhrs table for a given projectid.
void	deleteSKDLaborHrsTemp() This method deletes the data from skdlaborhrstemp table.
void	deleteSKDLaborHrsTemp(long SKDProjectId) This method deletes the data from skdlaborhrstemp table for a given projectid.
void	executeStatement(java.lang.String sqlStatement) This method executes the sql statement.
java.util.HashMap<java.lang.String,java.util.HashMap<java.lang.String,java.lang.Double>>	getCrewAvailData(java.lang.Long projectId, boolean workTime) get resource availability data.
double	getMonthHrs(java.lang.String year, java.lang.String actTimePeriod, java.util.HashMap<java.lang.String,java.util.HashMap<java.lang.String,java.lang.Double>> crafHoursMap, java.lang.String craft, java.util.Date minActDate, java.util.Date maxActDate)
java.util.HashMap<java.lang.String,java.util.HashMap<java.lang.String,java.lang.Double>>	getResourceAvailData(java.lang.Long projectId, boolean workTime, boolean isResourceDataPersistedInScheduler) Get resource availability data.
double	getWeekHrs(java.util.Date actStartWeekDate, java.util.HashMap<java.lang.String,java.util.HashMap<java.lang.String,java.lang.Double>> crafHoursMap, java.lang.String craft, java.util.Date minActDate, java.util.Date maxActDate)
boolean	isOverlaping(com.ibm.tivoli.maximo.skd.app.SKDLaborHrsSet.WOActivity activity, com.ibm.tivoli.maximo.skd.app.SKDLaborHrsSet.Shift shift) checks if activity is in shift.
boolean	isSKDTempEmpty() This method checks in the Skd temp table is empty.
boolean	isSKDTempEmpty(long SKDProjectId) This method checks in the Skd temp table is empty for a given skdprojectid.
void	loadShiftData(java.lang.Long SKDProjectId) Load shift data
void	populate(boolean isResourceDataPersistedInScheduler) This method is called from the bean when user clicks on calculate labor hours button.
void	populate(java.lang.String startWeekDay, long SKDProjectId, boolean isResourceDataPersistedInScheduler) This method populates skdlaborhrs table.
void	populateAvblCrewHrsDaily(long SKDProjectId, java.lang.String yearDate, java.lang.String monthDate, java.lang.String monthDateP, java.lang.String weekDate, java.lang.String dayDate, java.lang.String startWeekDate, java.lang.String actDate, java.lang.String workDate) This method populates the available crew hours.
void	populateAvblHrsWeeklyMonthly(long SKDProjectId, java.lang.String yearDate, java.lang.String monthDate, java.lang.String monthDateP, java.lang.String weekDate, java.lang.String dayDate, java.lang.String startWeekDate, java.lang.String actDate, java.lang.String workDate) This method calculates the weekly and monthly labor and crew available hours.
void	populateAvblLaborHrsDaily(long SKDProjectId, java.lang.String yearDate, java.lang.String monthDate, java.lang.String monthDateP, java.lang.String weekDate, java.lang.String dayDate, java.lang.String startWeekDate, java.lang.String actDate, java.lang.String workDate) This method populates the available labor hours.
void	populateLaborHrs() Populate LaborHrs
void	populatePlannedAvblHrs(java.lang.String startWeekDay, long SKDProjectId, boolean isResourceDataPersistedInScheduler) Creates the sql based on database and populate Labor Hrs.
void	populatePlannedCrewHrsDaily(long SKDProjectId, java.lang.String yearDate, java.lang.String monthDate, java.lang.String monthDateP, java.lang.String weekDate, java.lang.String dayDate, java.lang.String startWeekDate, java.lang.String workDate, boolean isResourceDataPersisted) Calculate Planned crew hours.
void	populatePlannedHrsWeeklyMonthy(long SKDProjectId, java.lang.String yearDate, java.lang.String monthDate, java.lang.String monthDateP, java.lang.String weekDate, java.lang.String dayDate, java.lang.String startWeekDate, java.lang.String workDate) This method calculates the weekly and monthly labor and crew planned hours.
void	populatePlannedLaborHrsDaily(long SKDProjectId, java.lang.String yearDate, java.lang.String monthDate, java.lang.String monthDateP, java.lang.String weekDate, java.lang.String dayDate, java.lang.String startWeekDate, java.lang.String workDate, boolean isResourceDataPersistedInScheduler) Calculate planned labor hours.
void	populatePMAvblCrewHrsDaily(long SKDProjectId, java.lang.String yearDate, java.lang.String monthDate, java.lang.String monthDateP, java.lang.String weekDate, java.lang.String dayDate, java.lang.String startWeekDate, java.lang.String actDate, java.lang.String workDate, java.lang.String newdatesql) This method populates the PM available crew hours.
void	populatePMAvblLaborHrsDaily(long SKDProjectId, java.lang.String yearDate, java.lang.String monthDate, java.lang.String monthDateP, java.lang.String weekDate, java.lang.String dayDate, java.lang.String startWeekDate, java.lang.String actDate, java.lang.String workDate, java.lang.String newdatesql) This method populates the PM available labor hours.
void	populatePMPlannedCrewHrsDaily(long SKDProjectId, java.lang.String yearDate, java.lang.String monthDate, java.lang.String monthDateP, java.lang.String weekDate, java.lang.String dayDate, java.lang.String startWeekDate, java.lang.String workDate, java.lang.String newdatesql) Calculate PM Planned crew hours.
void	populatePMPlannedLaborHrsDaily(long SKDProjectId, java.lang.String yearDate, java.lang.String monthDate, java.lang.String monthDateP, java.lang.String weekDate, java.lang.String dayDate, java.lang.String startWeekDate, java.lang.String workDate, java.lang.String newdatesql) Calculate PM planned labor hours.
void	populateSKDLaborHrs() This method calculates
void	populateSKDLaborHrs(long SKDProjectId) This method populates the skdlaborhrs table based on grouping data by daily, weekly and monthly
void	recalculateSKDLaborHrsTemp(long SKDProjectId, java.util.HashMap<java.lang.String,java.util.HashMap<java.lang.String,java.lang.Double>> craftWorkHoursMap, java.util.HashMap<java.lang.String,java.util.HashMap<java.lang.String,java.lang.Double>> craftNonWorkHoursMap)
void	updateSKDTemp() This method updates the labor and crew available and planned hours to zero if the value is null.
void	updateSKDTemp(long SKDProjectId) This method updates the labor and crew available and planned hours to zero if the value is null for a given project.
void	updateTimePeriod() This method updates the timeperid in skdlaborhrs based on timeperiod domain.
void	updateTimePeriod(long SKDProjectId) This method updates the timeperid in skdlaborhrs based on timeperiod domain for a skdprojectid.

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, canAdd, 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, saveTransaction, 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.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, saveTransaction, undoTransaction, validateTransaction

Constructor Detail

SKDLaborHrsSet

public SKDLaborHrsSet(MboServerInterface ms)
               throws java.rmi.RemoteException

Throws:

java.rmi.RemoteException

Method Detail

populate

public void populate(boolean isResourceDataPersistedInScheduler)
              throws MXException,
                     java.rmi.RemoteException

This method is called from the bean when user clicks on calculate labor hours button.

Parameters:

isResourceDataPersistedInScheduler - - This flag is used to indicate whether the Resource and Reservations data is persisted on Scheduler tables: SKDRESOURCE and SKDRESERVATION. If this is true, SQL queries should match data with those tables for calculations, otherwise they should consider Maximo standard tables: CRAFT, AMCREWT and ASSIGNMENT.

Throws:

MXException

java.rmi.RemoteException

populate

public void populate(java.lang.String startWeekDay,
                     long SKDProjectId,
                     boolean isResourceDataPersistedInScheduler)
              throws java.lang.Exception,
                     java.rmi.RemoteException

This method populates skdlaborhrs table.

Parameters:

isResourceDataPersistedInScheduler - - This flag is used to indicate whether the Resource and Reservations data is persisted on Scheduler tables: SKDRESOURCE and SKDRESERVATION. If this is true, SQL queries should match data with those tables for calculations, otherwise they should consider Maximo standard tables: CRAFT, AMCREWT and ASSIGNMENT.

startWeekDay -

SKDProjectId -

Throws:

MXException

java.rmi.RemoteException

java.lang.Exception

recalculateSKDLaborHrsTemp

public void recalculateSKDLaborHrsTemp(long SKDProjectId,
                                       java.util.HashMap<java.lang.String,java.util.HashMap<java.lang.String,java.lang.Double>> craftWorkHoursMap,
                                       java.util.HashMap<java.lang.String,java.util.HashMap<java.lang.String,java.lang.Double>> craftNonWorkHoursMap)
                                throws java.lang.Exception,
                                       java.rmi.RemoteException

Throws:

java.lang.Exception

java.rmi.RemoteException

getWeekHrs

public double getWeekHrs(java.util.Date actStartWeekDate,
                         java.util.HashMap<java.lang.String,java.util.HashMap<java.lang.String,java.lang.Double>> crafHoursMap,
                         java.lang.String craft,
                         java.util.Date minActDate,
                         java.util.Date maxActDate)
                  throws SchedulerException,
                         java.rmi.RemoteException,
                         java.text.ParseException

Throws:

SchedulerException

java.rmi.RemoteException

java.text.ParseException

getMonthHrs

public double getMonthHrs(java.lang.String year,
                          java.lang.String actTimePeriod,
                          java.util.HashMap<java.lang.String,java.util.HashMap<java.lang.String,java.lang.Double>> crafHoursMap,
                          java.lang.String craft,
                          java.util.Date minActDate,
                          java.util.Date maxActDate)
                   throws SchedulerException,
                          java.rmi.RemoteException,
                          java.text.ParseException

Throws:

SchedulerException

java.rmi.RemoteException

java.text.ParseException

getResourceAvailData

public java.util.HashMap<java.lang.String,java.util.HashMap<java.lang.String,java.lang.Double>> getResourceAvailData(java.lang.Long projectId,
                                                                                                                     boolean workTime,
                                                                                                                     boolean isResourceDataPersistedInScheduler)
                                                                                                              throws SchedulerException,
                                                                                                                     java.rmi.RemoteException

Get resource availability data.

Parameters:

objectName -

projectId -

isResourceDataPersistedInScheduler - - This flag is used to indicate whether the Resource and Reservations data is persisted on Scheduler tables: SKDRESOURCE and SKDRESERVATION. If this is true, SQL queries should match data with those tables for calculations, otherwise they should consider Maximo standard tables: CRAFT, AMCREWT and ASSIGNMENT.

Throws:

SchedulerException

java.rmi.RemoteException

getCrewAvailData

public java.util.HashMap<java.lang.String,java.util.HashMap<java.lang.String,java.lang.Double>> getCrewAvailData(java.lang.Long projectId,
                                                                                                                 boolean workTime)
                                                                                                          throws SchedulerException,
                                                                                                                 java.rmi.RemoteException

get resource availability data.

Parameters:

objectName -

projectId -

Throws:

SchedulerException

java.rmi.RemoteException

deleteSKDLaborHours

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

This method deletes the data from skdlaborhrs table.

Throws:

MXException

java.rmi.RemoteException

deleteSKDLaborHrs

public void deleteSKDLaborHrs(long SKDProjectId)
                       throws MXException,
                              java.rmi.RemoteException

This method deletes the data from skdlaborhrs table for a given projectid.

Parameters:

SKDProjectId -

Throws:

MXException

java.rmi.RemoteException

deleteSKDLaborHrsTemp

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

This method deletes the data from skdlaborhrstemp table.

Throws:

MXException

java.rmi.RemoteException

deleteSKDLaborHrsTemp

public void deleteSKDLaborHrsTemp(long SKDProjectId)
                           throws MXException,
                                  java.rmi.RemoteException

This method deletes the data from skdlaborhrstemp table for a given projectid.

Parameters:

SKDProjectId -

Throws:

MXException

java.rmi.RemoteException

populateLaborHrs

public void populateLaborHrs()
                      throws java.lang.Exception,
                             java.rmi.RemoteException

Populate LaborHrs

Throws:

java.lang.Exception

java.rmi.RemoteException

populatePlannedAvblHrs

public void populatePlannedAvblHrs(java.lang.String startWeekDay,
                                   long SKDProjectId,
                                   boolean isResourceDataPersistedInScheduler)
                            throws java.lang.Exception,
                                   java.rmi.RemoteException

Creates the sql based on database and populate Labor Hrs.

Parameters:

startWeekDay -

SKDProjectId -

Throws:

MXException

RemoteExceptio

java.lang.Exception

java.rmi.RemoteException

populatePlannedLaborHrsDaily

public void populatePlannedLaborHrsDaily(long SKDProjectId,
                                         java.lang.String yearDate,
                                         java.lang.String monthDate,
                                         java.lang.String monthDateP,
                                         java.lang.String weekDate,
                                         java.lang.String dayDate,
                                         java.lang.String startWeekDate,
                                         java.lang.String workDate,
                                         boolean isResourceDataPersistedInScheduler)
                                  throws MXException,
                                         java.rmi.RemoteException

Calculate planned labor hours.

Parameters:

SKDProjectId -

yearDate, -

monthDate -

monthDateP -

weekDate -

dayDate -

startWeekDate -

dailyDate -

Throws:

MXException

java.rmi.RemoteException

addSKDLaborHrsTemp

public void addSKDLaborHrsTemp(long SKDProjectId,
                               java.util.HashMap<java.lang.String,java.util.ArrayList<com.ibm.tivoli.maximo.skd.app.SKDLaborHrsSet.WOActivity>> craftActivityListMap,
                               java.lang.String cond)
                        throws MXException,
                               java.rmi.RemoteException

add to skdlaborhrstemp table.

Throws:

MXException

java.rmi.RemoteException

populatePMPlannedLaborHrsDaily

public void populatePMPlannedLaborHrsDaily(long SKDProjectId,
                                           java.lang.String yearDate,
                                           java.lang.String monthDate,
                                           java.lang.String monthDateP,
                                           java.lang.String weekDate,
                                           java.lang.String dayDate,
                                           java.lang.String startWeekDate,
                                           java.lang.String workDate,
                                           java.lang.String newdatesql)
                                    throws MXException,
                                           java.rmi.RemoteException

Calculate PM planned labor hours.

Parameters:

SKDProjectId -

yearDate, -

monthDate -

monthDateP -

weekDate -

dayDate -

startWeekDate -

dailyDate -

newdatesql -

Throws:

MXException

java.rmi.RemoteException

populatePlannedCrewHrsDaily

public void populatePlannedCrewHrsDaily(long SKDProjectId,
                                        java.lang.String yearDate,
                                        java.lang.String monthDate,
                                        java.lang.String monthDateP,
                                        java.lang.String weekDate,
                                        java.lang.String dayDate,
                                        java.lang.String startWeekDate,
                                        java.lang.String workDate,
                                        boolean isResourceDataPersisted)
                                 throws MXException,
                                        java.rmi.RemoteException

Calculate Planned crew hours.

Parameters:

SKDProjectId -

yearDate -

monthDate -

monthDateP -

weekDate -

dayDate -

startWeekDate -

dailyDate -

Throws:

MXException

java.rmi.RemoteException

populatePMPlannedCrewHrsDaily

public void populatePMPlannedCrewHrsDaily(long SKDProjectId,
                                          java.lang.String yearDate,
                                          java.lang.String monthDate,
                                          java.lang.String monthDateP,
                                          java.lang.String weekDate,
                                          java.lang.String dayDate,
                                          java.lang.String startWeekDate,
                                          java.lang.String workDate,
                                          java.lang.String newdatesql)
                                   throws MXException,
                                          java.rmi.RemoteException

Calculate PM Planned crew hours.

Parameters:

SKDProjectId -

yearDate -

monthDate -

monthDateP -

weekDate -

dayDate -

startWeekDate -

dailyDate -

newdatesql -

Throws:

MXException

java.rmi.RemoteException

populatePlannedHrsWeeklyMonthy

public void populatePlannedHrsWeeklyMonthy(long SKDProjectId,
                                           java.lang.String yearDate,
                                           java.lang.String monthDate,
                                           java.lang.String monthDateP,
                                           java.lang.String weekDate,
                                           java.lang.String dayDate,
                                           java.lang.String startWeekDate,
                                           java.lang.String workDate)
                                    throws MXException,
                                           java.rmi.RemoteException

This method calculates the weekly and monthly labor and crew planned hours.

Parameters:

SKDProjectId -

yearDate -

monthDate -

monthDateP -

weekDate -

dayDate -

startWeekDate -

workDate -

Throws:

MXException

java.rmi.RemoteException

populateAvblLaborHrsDaily

public void populateAvblLaborHrsDaily(long SKDProjectId,
                                      java.lang.String yearDate,
                                      java.lang.String monthDate,
                                      java.lang.String monthDateP,
                                      java.lang.String weekDate,
                                      java.lang.String dayDate,
                                      java.lang.String startWeekDate,
                                      java.lang.String actDate,
                                      java.lang.String workDate)
                               throws java.lang.Exception,
                                      java.rmi.RemoteException

This method populates the available labor hours.

Parameters:

SKDProjectId -

yearDate -

monthDate -

monthDateP -

weekDate -

dayDate -

startWeekDate -

actDate -

workDate -

Throws:

MXException

java.rmi.RemoteException

java.lang.Exception

populatePMAvblLaborHrsDaily

public void populatePMAvblLaborHrsDaily(long SKDProjectId,
                                        java.lang.String yearDate,
                                        java.lang.String monthDate,
                                        java.lang.String monthDateP,
                                        java.lang.String weekDate,
                                        java.lang.String dayDate,
                                        java.lang.String startWeekDate,
                                        java.lang.String actDate,
                                        java.lang.String workDate,
                                        java.lang.String newdatesql)
                                 throws java.lang.Exception,
                                        java.rmi.RemoteException

This method populates the PM available labor hours.

Parameters:

SKDProjectId -

yearDate -

monthDate -

monthDateP -

weekDate -

dayDate -

startWeekDate -

actDate -

workDate -

newdate -

Throws:

MXException

java.rmi.RemoteException

java.lang.Exception

populateAvblCrewHrsDaily

public void populateAvblCrewHrsDaily(long SKDProjectId,
                                     java.lang.String yearDate,
                                     java.lang.String monthDate,
                                     java.lang.String monthDateP,
                                     java.lang.String weekDate,
                                     java.lang.String dayDate,
                                     java.lang.String startWeekDate,
                                     java.lang.String actDate,
                                     java.lang.String workDate)
                              throws java.lang.Exception,
                                     java.rmi.RemoteException

This method populates the available crew hours.

Parameters:

SKDProjectId -

yearDate -

monthDate -

monthDateP -

weekDate -

dayDate -

startWeekDate -

actDate -

workDate -

Throws:

MXException

java.rmi.RemoteException

java.lang.Exception

populatePMAvblCrewHrsDaily

public void populatePMAvblCrewHrsDaily(long SKDProjectId,
                                       java.lang.String yearDate,
                                       java.lang.String monthDate,
                                       java.lang.String monthDateP,
                                       java.lang.String weekDate,
                                       java.lang.String dayDate,
                                       java.lang.String startWeekDate,
                                       java.lang.String actDate,
                                       java.lang.String workDate,
                                       java.lang.String newdatesql)
                                throws java.lang.Exception,
                                       java.rmi.RemoteException

This method populates the PM available crew hours.

Parameters:

SKDProjectId -

yearDate -

monthDate -

monthDateP -

weekDate -

dayDate -

startWeekDate -

actDate -

workDate -

newdate -

Throws:

MXException

java.rmi.RemoteException

java.lang.Exception

populateAvblHrsWeeklyMonthly

public void populateAvblHrsWeeklyMonthly(long SKDProjectId,
                                         java.lang.String yearDate,
                                         java.lang.String monthDate,
                                         java.lang.String monthDateP,
                                         java.lang.String weekDate,
                                         java.lang.String dayDate,
                                         java.lang.String startWeekDate,
                                         java.lang.String actDate,
                                         java.lang.String workDate)
                                  throws java.lang.Exception,
                                         java.rmi.RemoteException

This method calculates the weekly and monthly labor and crew available hours.

Parameters:

SKDProjectId -

yearDate -

monthDate -

monthDateP -

weekDate -

dayDate -

startWeekDate -

actDate -

workDate -

Throws:

java.lang.Exception

java.rmi.RemoteException

updateSKDTemp

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

This method updates the labor and crew available and planned hours to zero if the value is null.

Throws:

MXException

java.rmi.RemoteException

updateSKDTemp

public void updateSKDTemp(long SKDProjectId)
                   throws MXException,
                          java.rmi.RemoteException

This method updates the labor and crew available and planned hours to zero if the value is null for a given project.

Parameters:

SKDProjectId -

Throws:

MXException

java.rmi.RemoteException

isSKDTempEmpty

public boolean isSKDTempEmpty()
                       throws MXException,
                              java.rmi.RemoteException

This method checks in the Skd temp table is empty.

Parameters:

SKDProjectId -

Returns:

Throws:

MXException

java.rmi.RemoteException

isSKDTempEmpty

public boolean isSKDTempEmpty(long SKDProjectId)
                       throws MXException,
                              java.rmi.RemoteException

This method checks in the Skd temp table is empty for a given skdprojectid.

Parameters:

SKDProjectId -

Returns:

Throws:

MXException

java.rmi.RemoteException

populateSKDLaborHrs

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

This method calculates

Throws:

MXException

java.rmi.RemoteException

populateSKDLaborHrs

public void populateSKDLaborHrs(long SKDProjectId)
                         throws MXException,
                                java.rmi.RemoteException

This method populates the skdlaborhrs table based on grouping data by daily, weekly and monthly

Parameters:

SKDProjectId -

Throws:

MXException

java.rmi.RemoteException

updateTimePeriod

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

This method updates the timeperid in skdlaborhrs based on timeperiod domain.

Throws:

MXException

java.rmi.RemoteException

updateTimePeriod

public void updateTimePeriod(long SKDProjectId)
                      throws MXException,
                             java.rmi.RemoteException

This method updates the timeperid in skdlaborhrs based on timeperiod domain for a skdprojectid.

Parameters:

SKDProjectId -

Throws:

MXException

java.rmi.RemoteException

executeStatement

public void executeStatement(java.lang.String sqlStatement)
                      throws MXException,
                             java.rmi.RemoteException

This method executes the sql statement.

Parameters:

sqlStatement -

Throws:

MXException

java.rmi.RemoteException

isOverlaping

public boolean isOverlaping(com.ibm.tivoli.maximo.skd.app.SKDLaborHrsSet.WOActivity activity,
                            com.ibm.tivoli.maximo.skd.app.SKDLaborHrsSet.Shift shift)
                     throws SchedulerException

checks if activity is in shift.

Parameters:

acitivity -

shift -

Returns:

Throws:

SchedulerException

loadShiftData

public void loadShiftData(java.lang.Long SKDProjectId)
                   throws MXException,
                          java.rmi.RemoteException

Load shift data

Throws:

MXException

java.rmi.RemoteException