com.ibm.tivoli.maximo.skd.objservice.amcrew

Class CrewActivityDataManager

java.lang.Object

com.ibm.tivoli.maximo.skd.service.AbstractDataManager

com.ibm.tivoli.maximo.skd.service.AbstractActivityDataManager

com.ibm.tivoli.maximo.skd.objservice.amcrew.CrewActivityDataManager

All Implemented Interfaces:

ActivityDataManager, DataManager

public class CrewActivityDataManager
extends AbstractActivityDataManager

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	CACHEKEY_ASSIGNMENTACTIVITYMAP

Constructor Summary

Constructors

Constructor and Description
CrewActivityDataManager()

Method Summary

Methods

Modifier and Type	Method and Description
int	activityRecordCount(java.util.HashMap<java.lang.String,java.util.ArrayList<java.lang.String>> queryMap) Count activities records before adding it to skdactivity table.
void	applyActivityChange(MboRemote activityMboRemote, MXTransaction txn) Update crew related information during commit
void	applyAssignmentChanges(ilog.views.gantt.model.general.IlvGeneralActivity activity, MXTransaction txn) Save assignment with activity changes
void	createAMCrewLabor(java.lang.String position, java.lang.String laborCode, java.lang.String craft, java.lang.String skillLevel, java.lang.String vendor, java.lang.String contractNum, java.lang.String orgId, MboRemote amCrew, java.util.Date fromDateTime, java.util.Date toDateTime, MboSetRemote AssignSet) Add temporarily labor
void	createAMCrewTool(java.lang.String amcrew, java.lang.String toolSeq, java.lang.String assetNum, java.lang.String siteid, java.lang.String itemNum, java.lang.String setid, MboRemote amCrew, java.util.Date fromDateTime, java.util.Date toDateTime, MboSetRemote AssignSet) Add temporarily tool
java.lang.String	getAmcrewAssetExcludeQuery(int dbType) get Org query string
java.lang.String	getAmcrewAssetRestrictQuery(int dbType) get amcrew date restrict query string
java.lang.String	getAmcrewLaborExcludeQuery(int dbType) get Org query string
java.lang.String	getAmcrewLaborRestrictQuery(int dbType) get amcrew date restrict query string
java.lang.String	getCompleteQueryWhere(java.lang.String objectName, java.util.HashMap<java.lang.String,java.util.ArrayList<java.lang.String>> queryMap) Get the sql where clause for the list in querymap
java.lang.String[]	getDateDBSqlString(int dbType) get db datetime string
java.lang.String[]	getDateOnlyDBSqlString(int dbType) get db date string
java.lang.String	getDefaultRestriction(java.lang.String objectName) Get the default restriction for the object
java.lang.String	getOrgQuery() getOrg query string
java.lang.String	getSelectDateDBSqlString(int dbType) get db select datetime string
void	initializeActivity(MXActivity activity, java.lang.String objectName, MboRemote mboObject, MXGanttModel model) Initialize activity and populate information needed during initialization
java.util.List<ilog.views.gantt.IlvActivity>	linkChildDummyNode(MXActivity activity, MXGanttModel model, SKDAppService.ActivityData activityData) Add dummy child node for an activity node.
void	loadActivity(MXActivity activity, java.lang.String objectName, MboRemote mboObject) Load the activity data
void	loadActivity(MXActivity activity, java.lang.String objectName, MXGanttModel model) Load activity
void	loadAdditionalActivities(MXGanttModel model, SKDAppService.ActivityData activityData) Load additional activities
void	loadWorkAndNonWorkActivities(MXGanttModel model, SKDAppService.ActivityData activityData) Load working and non working hours
void	populateActivities(java.util.HashMap<java.lang.String,java.util.ArrayList<java.lang.String>> queryMap) Populate scheduler intermediate table with pm data.
void	populateActivityPropertyDetails() Update activity properties.
void	populateCrewActivities(java.util.HashMap<java.lang.String,java.util.ArrayList<java.lang.String>> queryMap) Populate scheduler intermediate table with pm data.
void	populateCrewLabActivities(java.util.HashMap<java.lang.String,java.util.ArrayList<java.lang.String>> queryMap) Populate skdactivity with crew assigned labor amcrewlabor table data.
void	populateCrewLabposActivities(java.util.HashMap<java.lang.String,java.util.ArrayList<java.lang.String>> queryMap) Populate scheduler intermediate table with pm data.
void	populateCrewToolActivities(java.util.HashMap<java.lang.String,java.util.ArrayList<java.lang.String>> queryMap) Populate skdactivity with crew assigned labor amcrewtool table data.
void	populateCrewToolSqActivities(java.util.HashMap<java.lang.String,java.util.ArrayList<java.lang.String>> queryMap) Populate scheduler intermediate table with amcremtoolsq data.
void	removeAMCrewLabor(java.lang.String laborCode, java.lang.String craft, java.lang.String skillLevel, java.lang.String vendor, java.lang.String contractNum, java.lang.String orgId, MboRemote amCrew, java.util.Date endDateTime, java.util.Date returnDateTime, MboSetRemote AssignSet) Remove temporarily labor
void	removeAMCrewTool(java.lang.String amcrew, java.lang.String toolSeq, java.lang.String assetNum, java.lang.String siteid, java.lang.String itemNum, java.lang.String setid, MboRemote amCrew, java.util.Date origEndDateTime, java.util.Date returnDateTime, MboSetRemote AssignSet) Remove temporarily tool
void	replaceAMCrewLabor(java.lang.String position, java.lang.String laborCode, java.lang.String toLaborCode, java.lang.String craft, java.lang.String skillLevel, java.lang.String vendor, java.lang.String contractNum, java.lang.String orgId, MboRemote amCrew, java.util.Date fromDateTime, java.util.Date toDateTime, MboSetRemote AssignSet) Replace temporarily labor
void	replaceAMCrewTool(java.lang.String amcrew, java.lang.String toolSeq, java.lang.String assetNum, java.lang.String toAssetNum, java.lang.String siteid, java.lang.String itemNum, java.lang.String setid, MboRemote amCrew, java.util.Date fromDateTime, java.util.Date toDateTime, MboSetRemote AssignSet) Replace temporarily tool
void	saveActivities(ilog.views.gantt.model.general.IlvGeneralActivity activity, MXTransaction txn) Save activities

Methods inherited from class com.ibm.tivoli.maximo.skd.service.AbstractActivityDataManager

applyActivityChange, applyScenarioChange, applyScenarioChange, deleteProjectData, duplicateProjectData, getAsyncCount, getModifiedActivityChildren, initializeActivity, initializeActivityChildren, saveActivities, sortActivityChildren

Methods inherited from class com.ibm.tivoli.maximo.skd.service.AbstractDataManager

getDataManagerContext, getLogger, getObjectName, getProjectMbo, getSqlLogger, getUserInfo, setDataManagerContext

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.ibm.tivoli.maximo.skd.service.DataManager

setDataManagerContext

Field Detail

CACHEKEY_ASSIGNMENTACTIVITYMAP

public static final java.lang.String CACHEKEY_ASSIGNMENTACTIVITYMAP

See Also:

Constant Field Values

Constructor Detail

CrewActivityDataManager

public CrewActivityDataManager()

Method Detail

initializeActivity

public void initializeActivity(MXActivity activity,
                      java.lang.String objectName,
                      MboRemote mboObject,
                      MXGanttModel model)
                        throws SchedulerException

Initialize activity and populate information needed during initialization

Specified by:

initializeActivity in interface ActivityDataManager

Overrides:

initializeActivity in class AbstractActivityDataManager

Parameters:

reservation -

objectName -

mboObject -

Throws:

SchedulerException

populateActivities

public void populateActivities(java.util.HashMap<java.lang.String,java.util.ArrayList<java.lang.String>> queryMap)
                        throws SchedulerException

Populate scheduler intermediate table with pm data.

Specified by:

populateActivities in interface ActivityDataManager

Overrides:

populateActivities in class AbstractActivityDataManager

Parameters:

- -

Throws:

SchedulerException

populateCrewActivities

public void populateCrewActivities(java.util.HashMap<java.lang.String,java.util.ArrayList<java.lang.String>> queryMap)
                            throws SchedulerException

Populate scheduler intermediate table with pm data.

Parameters:

- -

Throws:

SchedulerException

getAmcrewLaborExcludeQuery

public java.lang.String getAmcrewLaborExcludeQuery(int dbType)
                                            throws SchedulerException

get Org query string

Throws:

SchedulerException

getAmcrewLaborRestrictQuery

public java.lang.String getAmcrewLaborRestrictQuery(int dbType)
                                             throws SchedulerException

get amcrew date restrict query string

Throws:

SchedulerException

getAmcrewAssetExcludeQuery

public java.lang.String getAmcrewAssetExcludeQuery(int dbType)
                                            throws SchedulerException

get Org query string

Throws:

SchedulerException

getAmcrewAssetRestrictQuery

public java.lang.String getAmcrewAssetRestrictQuery(int dbType)
                                             throws SchedulerException

get amcrew date restrict query string

Throws:

SchedulerException

populateCrewLabActivities

public void populateCrewLabActivities(java.util.HashMap<java.lang.String,java.util.ArrayList<java.lang.String>> queryMap)
                               throws SchedulerException

Populate skdactivity with crew assigned labor amcrewlabor table data.

Parameters:

- -

Throws:

SchedulerException

getOrgQuery

public java.lang.String getOrgQuery()
                             throws SchedulerException

getOrg query string

Throws:

SchedulerException

getDateOnlyDBSqlString

public java.lang.String[] getDateOnlyDBSqlString(int dbType)
                                          throws SchedulerException

get db date string

Throws:

SchedulerException

getSelectDateDBSqlString

public java.lang.String getSelectDateDBSqlString(int dbType)
                                          throws SchedulerException

get db select datetime string

Throws:

SchedulerException

getDateDBSqlString

public java.lang.String[] getDateDBSqlString(int dbType)
                                      throws SchedulerException

get db datetime string

Throws:

SchedulerException

populateCrewLabposActivities

public void populateCrewLabposActivities(java.util.HashMap<java.lang.String,java.util.ArrayList<java.lang.String>> queryMap)
                                  throws SchedulerException

Populate scheduler intermediate table with pm data.

Parameters:

- -

Throws:

SchedulerException

populateActivityPropertyDetails

public void populateActivityPropertyDetails()
                                     throws SchedulerException

Update activity properties.

Specified by:

populateActivityPropertyDetails in interface ActivityDataManager

Overrides:

populateActivityPropertyDetails in class AbstractActivityDataManager

Throws:

SchedulerException

getCompleteQueryWhere

public java.lang.String getCompleteQueryWhere(java.lang.String objectName,
                                     java.util.HashMap<java.lang.String,java.util.ArrayList<java.lang.String>> queryMap)
                                       throws MXException,
                                              java.rmi.RemoteException

Get the sql where clause for the list in querymap

Parameters:

objectName -

queryMap -

Returns:

sql where clause

Throws:

MXException

java.rmi.RemoteException

getDefaultRestriction

public java.lang.String getDefaultRestriction(java.lang.String objectName)
                                       throws SchedulerException

Get the default restriction for the object

Parameters:

objectName -

Returns:

restriction clause

Throws:

SchedulerException

linkChildDummyNode

public java.util.List<ilog.views.gantt.IlvActivity> linkChildDummyNode(MXActivity activity,
                                                              MXGanttModel model,
                                                              SKDAppService.ActivityData activityData)
                                                                throws SchedulerException

Add dummy child node for an activity node.

Specified by:

linkChildDummyNode in interface ActivityDataManager

Overrides:

linkChildDummyNode in class AbstractActivityDataManager

Parameters:

activity -

mxganttmodel -

activityData -

Returns:

activity list to remove

Throws:

SchedulerException

loadActivity

public void loadActivity(MXActivity activity,
                java.lang.String objectName,
                MboRemote mboObject)
                  throws SchedulerException

Load the activity data

Specified by:

loadActivity in interface ActivityDataManager

Overrides:

loadActivity in class AbstractActivityDataManager

Parameters:

- - Activity row

- - object name

- - PM object

Throws:

SchedulerException

loadActivity

public void loadActivity(MXActivity activity,
                java.lang.String objectName,
                MXGanttModel model)
                  throws SchedulerException

Load activity

Specified by:

loadActivity in interface ActivityDataManager

Overrides:

loadActivity in class AbstractActivityDataManager

Parameters:

MXActivity - activity

object - name

model -

Throws:

SchedulerException

activityRecordCount

public int activityRecordCount(java.util.HashMap<java.lang.String,java.util.ArrayList<java.lang.String>> queryMap)
                        throws SchedulerException

Count activities records before adding it to skdactivity table.

Specified by:

activityRecordCount in interface ActivityDataManager

Overrides:

activityRecordCount in class AbstractActivityDataManager

Parameters:

- - HashMap> queryMap -