/* (non-Javadoc)
* @see ieci.tdw.ispac.api.IWorklistAPI#getTasksPCD(int, InputStream)
*/
public IItemCollection getClosedTasksPCD(int taskPcdId, InputStream tasklistxml)
throws ISPACException {
String resp = getRespString();
DbCnt cnt = context.getConnection();
try {
WLTaskListFactory wlfactory = new WLTaskListFactory();
WLTaskListBuilder wlbuilder = null;
wlbuilder = wlfactory.getClosedTaskListBuilder(tasklistxml);
if (wlbuilder == null)
throw new ISPACException(
"No se ha podido construir WLTaskListBuilder para tramites cerrados");
CollectionDAO coldao =
wlbuilder.getTaskList(
cnt,
ISPACEntities.ENTITY_NULLREGKEYID,
resp,
ISPACEntities.ENTITY_NULLREGKEYID,
taskPcdId);
return coldao.disconnect();
} catch (ISPACException ie) {
throw new ISPACException(
"Error en WLWorklist:getClosedTasksPCD(" + taskPcdId + ", tasklistxml)", ie);
} finally {
context.releaseConnection(cnt);
}
}
private IItemCollection getClosedTasksCTL(
int taskCtlId, InputStream tasklistxml, String resp, int pcdId) throws ISPACException {
DbCnt cnt = context.getConnection();
try {
WLTaskListFactory wlfactory = new WLTaskListFactory();
WLTaskListBuilder wlbuilder = null;
wlbuilder = wlfactory.getClosedTaskListBuilder(tasklistxml);
if (wlbuilder == null)
throw new ISPACException(
"No se ha podido construir WLTaskListBuilder para tramites cerrados");
CollectionDAO coldao = wlbuilder.getTaskList(cnt, taskCtlId, resp, pcdId);
return coldao.disconnect();
} catch (ISPACException ie) {
throw new ISPACException(
"Error en WLWorklist:getClosedTasksCTL("
+ taskCtlId
+ ", tasklistxml, pcdId["
+ pcdId
+ "])",
ie);
} finally {
context.releaseConnection(cnt);
}
}
public IItemCollection getSubProcesses(int pcdId, int idActivityPCD, InputStream istream)
throws ISPACException {
DbCnt cnt = null;
try {
cnt = context.getConnection();
WLWorklistFactory wlfactory = new WLWorklistFactory();
WLProcessListBuilder wlbuilder = wlfactory.getProcessListBuilder(istream);
if (wlbuilder == null) {
throw new ISPACException("No se ha podido construir WLProcessListBuilder");
}
CollectionDAO coldao =
wlbuilder.getWorklist(
cnt, pcdId, idActivityPCD, getRespStringSubProceso(idActivityPCD, 0));
return coldao.disconnect();
} catch (ISPACException ie) {
logger.error("Error al obtener los subprocesos", ie);
throw new ISPACException("Error en WorklistAPI:getSubProcesses(" + idActivityPCD + ")", ie);
} finally {
context.releaseConnection(cnt);
}
}
public IItemCollection getSubstitutesHistorics(String sustitutoUID) throws ISPACException {
CollectionDAO collDAO =
SustitucionDAO.getSustitutosHistorics(
mDbCnt,
sustitutoUID,
DBUtil.getToDateByBD(mDbCnt, new Date(System.currentTimeMillis())));
return collDAO.disconnect();
}
public static IItemCollection getProcessBPM(DbCnt cnt, String idProcessBPM, ClientContext ctx)
throws ISPACException {
Object[] argsarr = new Object[1];
argsarr[0] = ctx;
String sql = "WHERE ID_PROCESO_BPM = '" + idProcessBPM + "'";
CollectionDAO objlist = new CollectionDAO(TXProcesoDAO.class, argsarr);
objlist.query(cnt, sql);
return objlist.disconnect();
}
private static IItemCollection getProcesses(
DbCnt cnt, int idProcedimiento, ClientContext ctx, int type) throws ISPACException {
Object[] argsarr = new Object[1];
argsarr[0] = ctx;
String sql = "WHERE ID_PCD = " + idProcedimiento + " AND TIPO = " + type;
CollectionDAO objlist = new CollectionDAO(TXProcesoDAO.class, argsarr);
objlist.query(cnt, sql);
return objlist.disconnect();
}
private static IItemCollection getProcess(DbCnt cnt, String numexp, ClientContext ctx, int type)
throws ISPACException {
Object[] argsarr = new Object[1];
argsarr[0] = ctx;
String sql = "WHERE NUMEXP = '" + DBUtil.replaceQuotes(numexp) + "' AND TIPO = " + type;
CollectionDAO objlist = new CollectionDAO(TXProcesoDAO.class, argsarr);
objlist.query(cnt, sql);
return objlist.disconnect();
}
public IItemCollection getProcesses(String[] numexps) throws ISPACException {
DbCnt cnt = context.getConnection();
try {
WLProcessDAO process = new WLProcessDAO(cnt);
CollectionDAO colDao = process.loadProcessByNumExps(cnt, numexps);
return colDao.disconnect();
} catch (ISPACException ie) {
throw new ISPACException("Error en WLWorklist:getProcesses(" + numexps.toString() + ")", ie);
} finally {
context.releaseConnection(cnt);
}
}
/* (non-Javadoc)
* @see ieci.tdw.ispac.api.IWorklistAPI#getProcesses(int)
*/
public IItemCollection getProcesses(int idStagePCD, String path) throws ISPACException {
String resp = getRespString();
DbCnt cnt = context.getConnection();
try {
WLWorklistFactory wlfactory = new WLWorklistFactory();
WLProcessListBuilder wlbuilder = null;
wlbuilder = wlfactory.getProcessListBuilder(path);
if (wlbuilder == null)
throw new ISPACException("No se ha podido construir WLProcessListBuilder");
CollectionDAO coldao = wlbuilder.getWorklist(cnt, idStagePCD, resp);
return coldao.disconnect();
} catch (ISPACException ie) {
throw new ISPACException("Error en WLWorklist:getProcesses(" + idStagePCD + ")", ie);
} finally {
context.releaseConnection(cnt);
}
}
public String getDeadlineXML(DbCnt cnt) throws ISPACException {
// obtener el id del proceso
int idProcedure = getIdProcedure();
CollectionDAO collDAO =
PPlazoDAO.getDeadline(cnt, PRelPlazoDAO.DEADLINE_OBJ_PROCEDURE, idProcedure);
// con el id del proceso obtener el plazo
if (collDAO != null) {
IItemCollection coll = collDAO.disconnect();
if (coll != null) {
List collList = coll.toList();
for (Iterator iter = collList.iterator(); iter.hasNext(); ) {
IItem element = (IItem) iter.next();
String plazo = element.getString("PLAZO");
return plazo;
}
}
}
return null;
}
/* (non-Javadoc)
* @see ieci.tdw.ispac.api.IWorklistAPI#getCreateProcedures()
*/
public IItemCollection getCreateProcedures() throws ISPACException {
// Si es supervisor podra crear todos, sino le corresponderan los suyos y y los que pueden crear
// los que sustituye
String resp = null;
DbCnt cnt = context.getConnection();
try {
Responsible user = context.getUser();
SecurityMgr securityMgr = new SecurityMgr(cnt);
// Comprobar si el usuario tiene asignada la función de Supervisor Total
if (securityMgr.isSupervisorTotal(user.getUID())) {
resp = Responsible.SUPERVISOR;
} else {
// los que sustituye
resp = getSubstitutesRespString();
}
CollectionDAO pcdset = new CollectionDAO(PProcedimientoDAO.class);
/* Procedimientos en vigor */
String sqlquery =
"WHERE ESTADO="
+ IProcedure.PCD_STATE_CURRENT
+ " AND TIPO="
+ IProcedure.PROCEDURE_TYPE
+ " AND ID IN"
+ " (SELECT ID_PCD FROM SPAC_SS_PERMISOS WHERE PERMISO="
+ ISecurityAPI.ISPAC_RIGHTS_CREATEEXP
+ DBUtil.addAndInResponsibleCondition("UID_USR", resp)
+ ") ORDER BY NOMBRE";
pcdset.query(cnt, sqlquery);
return pcdset.disconnect();
} catch (ISPACException ie) {
throw new ISPACException("Error en WLWorklist:getProcs()", ie);
} finally {
context.releaseConnection(cnt);
}
}
public IItemCollection getPermissionsResp(int typeObject, int idObject, String uid)
throws ISPACException {
CollectionDAO coldao = PermissionDAO.getPermissions(mDbCnt, typeObject, idObject, uid);
return coldao.disconnect();
}
public IItemCollection getSubstitutes(int idFechSustitucion) throws ISPACException {
CollectionDAO collDAO = SustitucionDAO.getSubstitutes(mDbCnt, idFechSustitucion);
return collDAO.disconnect();
}
public IItemCollection getSubstitutes(String sustitutoUID) throws ISPACException {
CollectionDAO collDAO = SustitucionDAO.getSubstitutes(mDbCnt, sustitutoUID);
return collDAO.disconnect();
}
public IItemCollection getSustitutos(String uidSustituido) throws ISPACException {
CollectionDAO collDAO = SustitucionDAO.getSustitutos(mDbCnt, uidSustituido);
return collDAO.disconnect();
}