public class CrewActivityDataManager extends AbstractActivityDataManager
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
CACHEKEY_ASSIGNMENTACTIVITYMAP |
Constructor and Description |
---|
CrewActivityDataManager() |
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
|
applyActivityChange, applyScenarioChange, applyScenarioChange, deleteProjectData, duplicateProjectData, getAsyncCount, getModifiedActivityChildren, initializeActivity, initializeActivityChildren, saveActivities, sortActivityChildren
getDataManagerContext, getLogger, getObjectName, getProjectMbo, getSKDDD, getSqlLogger, getUserInfo, setDataManagerContext
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
setDataManagerContext
public static final java.lang.String CACHEKEY_ASSIGNMENTACTIVITYMAP
public void initializeActivity(MXActivity activity, java.lang.String objectName, MboRemote mboObject, MXGanttModel model) throws SchedulerException
initializeActivity
in interface ActivityDataManager
initializeActivity
in class AbstractActivityDataManager
reservation
- objectName
- mboObject
- SchedulerException
public void populateActivities(java.util.HashMap<java.lang.String,java.util.ArrayList<java.lang.String>> queryMap) throws SchedulerException
populateActivities
in interface ActivityDataManager
populateActivities
in class AbstractActivityDataManager
-
- SchedulerException
public void populateCrewActivities(java.util.HashMap<java.lang.String,java.util.ArrayList<java.lang.String>> queryMap) throws SchedulerException
-
- SchedulerException
public java.lang.String getAmcrewLaborExcludeQuery(int dbType) throws SchedulerException
SchedulerException
public java.lang.String getAmcrewLaborRestrictQuery(int dbType) throws SchedulerException
SchedulerException
public java.lang.String getAmcrewAssetExcludeQuery(int dbType) throws SchedulerException
SchedulerException
public java.lang.String getAmcrewAssetRestrictQuery(int dbType) throws SchedulerException
SchedulerException
public void populateCrewLabActivities(java.util.HashMap<java.lang.String,java.util.ArrayList<java.lang.String>> queryMap) throws SchedulerException
-
- SchedulerException
public java.lang.String getOrgQuery() throws SchedulerException
SchedulerException
public java.lang.String[] getDateOnlyDBSqlString(int dbType) throws SchedulerException
SchedulerException
public java.lang.String getSelectDateDBSqlString(int dbType) throws SchedulerException
SchedulerException
public java.lang.String[] getDateDBSqlString(int dbType) throws SchedulerException
SchedulerException
public void populateCrewLabposActivities(java.util.HashMap<java.lang.String,java.util.ArrayList<java.lang.String>> queryMap) throws SchedulerException
-
- SchedulerException
public void populateActivityPropertyDetails() throws SchedulerException
populateActivityPropertyDetails
in interface ActivityDataManager
populateActivityPropertyDetails
in class AbstractActivityDataManager
SchedulerException
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
objectName
- queryMap
- MXException
java.rmi.RemoteException
public java.lang.String getDefaultRestriction(java.lang.String objectName) throws SchedulerException
objectName
- SchedulerException
public java.util.List<ilog.views.gantt.IlvActivity> linkChildDummyNode(MXActivity activity, MXGanttModel model, SKDAppService.ActivityData activityData) throws SchedulerException
linkChildDummyNode
in interface ActivityDataManager
linkChildDummyNode
in class AbstractActivityDataManager
activity
- mxganttmodel
- activityData
- SchedulerException
public void loadActivity(MXActivity activity, java.lang.String objectName, MboRemote mboObject) throws SchedulerException
loadActivity
in interface ActivityDataManager
loadActivity
in class AbstractActivityDataManager
-
- Activity row-
- object name-
- PM objectSchedulerException
public void loadActivity(MXActivity activity, java.lang.String objectName, MXGanttModel model) throws SchedulerException
loadActivity
in interface ActivityDataManager
loadActivity
in class AbstractActivityDataManager
MXActivity
- activityobject
- namemodel
- SchedulerException
public int activityRecordCount(java.util.HashMap<java.lang.String,java.util.ArrayList<java.lang.String>> queryMap) throws SchedulerException
activityRecordCount
in interface ActivityDataManager
activityRecordCount
in class AbstractActivityDataManager
-
- HashMap-
- SchedulerExceptionSchedulerException
public void saveActivities(ilog.views.gantt.model.general.IlvGeneralActivity activity, MXTransaction txn) throws SchedulerException
saveActivities
in interface ActivityDataManager
saveActivities
in class AbstractActivityDataManager
activity
- transaction
- SchedulerException
public void applyAssignmentChanges(ilog.views.gantt.model.general.IlvGeneralActivity activity, MXTransaction txn) throws java.lang.Exception
activity
- txn
- map
- to store children activity infojava.lang.Exception
public 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) throws MXException, java.rmi.RemoteException
position
- labor
- codecraft
- skill
- levelvendor
- contract
- numberorganization
- crew
- mbofrom
- dateto
- datejava.lang.Exception
MXException
java.rmi.RemoteException
public 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) throws MXException, java.rmi.RemoteException
position
- labor
- codeto
- labor codecraft
- skill
- levelvendor
- contract
- numberorganization
- crew
- mbofrom
- dateto
- datejava.lang.Exception
MXException
java.rmi.RemoteException
public 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) throws MXException, java.rmi.RemoteException
position
- labor
- codecraft
- skill
- levelvendor
- contract
- numberorganization
- crew
- mboend
- datereturn
- datejava.lang.Exception
MXException
java.rmi.RemoteException
public 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) throws MXException, java.rmi.RemoteException
amcrew
- tool
- seqasset
- organization
- crew
- mbofrom
- dateto
- datejava.lang.Exception
MXException
java.rmi.RemoteException
public 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) throws MXException, java.rmi.RemoteException
amcrew
- tool
- seqasset
- item
- to
- assetorganization
- crew
- mbofrom
- dateto
- datejava.lang.Exception
MXException
java.rmi.RemoteException
public 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) throws MXException, java.rmi.RemoteException
amcrew
- tool
- seqasset
- item
- organization
- crew
- mbooriginal
- end datereturn
- datejava.lang.Exception
MXException
java.rmi.RemoteException
public void applyActivityChange(MboRemote activityMboRemote, MXTransaction txn) throws SchedulerException
applyActivityChange
in interface ActivityDataManager
applyActivityChange
in class AbstractActivityDataManager
-
- skdactivity mbo-
- MXTransaction-
- SchedulerExceptionSchedulerException
public void populateCrewToolSqActivities(java.util.HashMap<java.lang.String,java.util.ArrayList<java.lang.String>> queryMap) throws SchedulerException
-
- SchedulerException
public void populateCrewToolActivities(java.util.HashMap<java.lang.String,java.util.ArrayList<java.lang.String>> queryMap) throws SchedulerException
-
- SchedulerException
public void loadAdditionalActivities(MXGanttModel model, SKDAppService.ActivityData activityData) throws SchedulerException
loadAdditionalActivities
in interface ActivityDataManager
loadAdditionalActivities
in class AbstractActivityDataManager
mode
- activitydata
- SchedulerException
public void loadWorkAndNonWorkActivities(MXGanttModel model, SKDAppService.ActivityData activityData) throws SchedulerException
model
- activityData
- SchedulerException