@Override
protected final KeyFormat<Key> keyFormat() {
return store.keyFormat();
}
@Override
protected final Headers headers() {
return store.headers();
}
@Override
protected final int storedEntryCount() {
return store.storedEntryCount();
}
public ProcessInstance[] getProcessInstances(
String peasId, User user, String role, String[] userRoles, String[] userGroupIds)
throws WorkflowException {
SilverTrace.info(
"worflowEngine",
"ProcessInstanceManagerImpl.getProcessInstances()",
"root.MSG_GEN_ENTER_METHOD",
"peasId = " + peasId + ", user = "******", role = " + role);
Connection con = null;
PreparedStatement prepStmt = null;
ResultSet rs = null;
StringBuffer selectQuery = new StringBuffer();
Vector<ProcessInstanceImpl> instances = new Vector<ProcessInstanceImpl>();
try {
// Need first to make a SQL query to find all concerned instances ids
// Due to the operator EXISTS that is not yet supported by Castor OQL->SQL
// translator
con = this.getConnection();
if (role.equals("supervisor")) {
selectQuery.append("select * from SB_Workflow_ProcessInstance instance where modelId = ?");
prepStmt = con.prepareStatement(selectQuery.toString());
prepStmt.setString(1, peasId);
} else {
selectQuery
.append("select ")
.append(COLUMNS)
.append(" from SB_Workflow_ProcessInstance I ");
selectQuery.append("where I.modelId = ? ");
selectQuery.append("and exists (");
selectQuery.append(
"select instanceId from SB_Workflow_InterestedUser intUser where I.instanceId = intUser.instanceId and (");
selectQuery.append("intUser.userId = ? ");
if ((userRoles != null) && (userRoles.length > 0)) {
selectQuery.append(" or intUser.usersRole in (");
selectQuery.append(getSQLClauseIn(userRoles));
selectQuery.append(")");
}
if (userGroupIds != null && userGroupIds.length > 0) {
selectQuery.append(" or (intUser.groupId is not null");
selectQuery.append(" and intUser.groupId in (");
selectQuery.append(getSQLClauseIn(userGroupIds));
selectQuery.append("))");
}
selectQuery.append(") and intUser.role = ? ");
selectQuery.append("union ");
selectQuery.append(
"select instanceId from SB_Workflow_WorkingUser wkUser where I.instanceId = wkUser.instanceId and (");
selectQuery.append("wkUser.userId = ? ");
if ((userRoles != null) && (userRoles.length > 0)) {
selectQuery.append(" or wkUser.usersRole in (");
selectQuery.append(getSQLClauseIn(userRoles));
selectQuery.append(")");
}
if (userGroupIds != null && userGroupIds.length > 0) {
selectQuery.append(" or (wkUser.groupId is not null");
selectQuery.append(" and wkUser.groupId in (");
selectQuery.append(getSQLClauseIn(userGroupIds));
selectQuery.append("))");
}
selectQuery.append(") and ");
// role can be multiple (e.g: "role1,role2,...,roleN")
selectQuery.append("( wkUser.role = ? ");
selectQuery.append(" or wkUser.role like ? ");
selectQuery.append(" or wkUser.role like ? ");
selectQuery.append(" or wkUser.role like ? ");
selectQuery.append(")");
selectQuery.append(")");
selectQuery.append("order by I.instanceId desc");
SilverTrace.info(
"worflowEngine",
"ProcessInstanceManagerImpl.getProcessInstances()",
"root.MSG_GEN_PARAM_VALUE",
"SQL query = " + selectQuery.toString());
prepStmt = con.prepareStatement(selectQuery.toString());
prepStmt.setString(1, peasId);
prepStmt.setString(2, user.getUserId());
prepStmt.setString(3, role);
prepStmt.setString(4, user.getUserId());
prepStmt.setString(5, role);
prepStmt.setString(6, "%," + role);
prepStmt.setString(7, role + ",%");
prepStmt.setString(8, "%," + role + ",%");
}
rs = prepStmt.executeQuery();
ProcessInstanceImpl instance = null;
while (rs.next()) {
instance = new ProcessInstanceImpl();
instance.setInstanceId(rs.getString(1));
instance.setModelId(rs.getString(2));
instance.setLockedByAdmin(rs.getBoolean(3));
instance.setErrorStatus(rs.getBoolean(4));
instance.setTimeoutStatus(rs.getBoolean(5));
instances.add(instance);
}
// getHistory
prepStmt =
con.prepareStatement(
"select * from SB_Workflow_HistoryStep where instanceId = ? order by id asc");
for (int i = 0; i < instances.size(); i++) {
instance = instances.get(i);
prepStmt.setInt(1, Integer.parseInt(instance.getInstanceId()));
rs = prepStmt.executeQuery();
HistoryStepImpl historyStep = null;
while (rs.next()) {
historyStep = new HistoryStepImpl();
historyStep.setId(String.valueOf(rs.getInt(2)));
historyStep.setUserId(rs.getString(3));
historyStep.setUserRoleName(rs.getString(4));
historyStep.setAction(rs.getString(5));
historyStep.setActionDate(rs.getDate(6));
historyStep.setResolvedState(rs.getString(7));
historyStep.setResultingState(rs.getString(8));
historyStep.setActionStatus(rs.getInt(9));
historyStep.setProcessInstance(instance);
instance.addHistoryStep(historyStep);
}
}
// getActiveStates
Vector<ActiveState> states = null;
prepStmt =
con.prepareStatement(
"select * from SB_Workflow_ActiveState where instanceId = ? order by id asc");
for (int i = 0; i < instances.size(); i++) {
instance = (ProcessInstanceImpl) instances.get(i);
prepStmt.setInt(1, Integer.parseInt(instance.getInstanceId()));
rs = prepStmt.executeQuery();
ActiveState state = null;
states = new Vector<ActiveState>();
while (rs.next()) {
state = new ActiveState();
state.setId(String.valueOf(rs.getInt(1)));
state.setState(rs.getString(3));
state.setBackStatus(rs.getBoolean(4));
state.setTimeoutStatus(rs.getInt(5));
state.setProcessInstance(instance);
states.add(state);
}
instance.castor_setActiveStates(states);
}
SilverTrace.info(
"workflowEngine",
"ProcessInstanceManagerImpl",
"root.MSG_GEN_PARAM_VALUE",
" nb instances : " + instances.size());
return (ProcessInstance[]) instances.toArray(new ProcessInstance[0]);
} catch (SQLException se) {
throw new WorkflowException(
"ProcessInstanceManagerImpl.getProcessInstances",
"EX_ERR_CASTOR_GET_INSTANCES",
"sql query : " + selectQuery,
se);
} finally {
try {
DBUtil.close(rs, prepStmt);
if (con != null) con.close();
} catch (SQLException se) {
SilverTrace.error(
"workflowEngine",
"ProcessInstanceManagerImpl.getProcessInstances",
"root.EX_RESOURCE_CLOSE_FAILED",
se);
}
}
}
