예제 #1
0
 public IStage getStage(DbCnt cnt, int stagePcdId) throws ISPACException {
   String sql = "WHERE ID_EXP = " + getInt(IDKEY) + " AND ID_FASE = " + stagePcdId;
   CollectionDAO objlist = new CollectionDAO(TXFaseDAO.class);
   objlist.query(cnt, sql);
   if (objlist.next()) return (IStage) objlist.value();
   return null;
 }
예제 #2
0
  public CollectionDAO getSyncnodes(DbCnt cnt) throws ISPACException {
    String sql = "WHERE ID_EXP = " + getInt(IDKEY);
    CollectionDAO objlist = new CollectionDAO(TXSincNodoDAO.class);

    objlist.query(cnt, sql);
    return objlist;
  }
예제 #3
0
  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();
  }
예제 #4
0
  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();
  }
예제 #5
0
  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();
  }
예제 #6
0
  public static CollectionDAO getOutdatedProcess(DbCnt cnt) throws ISPACException {
    String sql =
        new StringBuffer("WHERE ESTADO=")
            .append(IProcess.OPEN)
            .append(" AND FECHA_LIMITE <= ")
            .append(DBUtil.getToDateByBD(cnt, new Date()))
            .append(" ORDER BY ID ASC ")
            .toString();

    CollectionDAO objlist = new CollectionDAO(TXProcesoDAO.class);
    objlist.query(cnt, sql);
    return objlist;
  }
예제 #7
0
  public CollectionDAO getSubprocess(DbCnt cnt, String numexp) throws ISPACException {
    try {

      String sql =
          "WHERE NUMEXP = '"
              + DBUtil.replaceQuotes(numexp)
              + "' AND TIPO="
              + IProcess.SUBPROCESS_TYPE;
      ;
      CollectionDAO objlist = new CollectionDAO(TXProcesoDAO.class);
      objlist.query(cnt, sql);
      return objlist;
    } catch (ISPACException e) {
      throw new ISPACException("Error en TXProcesoDAO:getSubprocess()", e);
    }
  }
예제 #8
0
  /* (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);
    }
  }
예제 #9
0
 public CollectionDAO getTasks(DbCnt cnt, int nIdStage) throws ISPACException {
   String sql = "WHERE ID_EXP = " + getInt(IDKEY) + " AND ID_FASE_EXP = " + nIdStage;
   CollectionDAO objlist = new CollectionDAO(TXTramiteDAO.class);
   objlist.query(cnt, sql);
   return objlist;
 }
예제 #10
0
 public CollectionDAO getOpenedStages(DbCnt cnt) throws ISPACException {
   String sql = "WHERE ID_EXP = " + getInt(IDKEY) + " AND ESTADO = 1";
   CollectionDAO objlist = new CollectionDAO(TXFaseDAO.class);
   objlist.query(cnt, sql);
   return objlist;
 }