Example usage for org.hibernate.criterion Restrictions ne

List of usage examples for org.hibernate.criterion Restrictions ne

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. Restrictions
  6. ne

Introduction

In this page you can find the example usage for org.hibernate.criterion Restrictions ne.

Prototype

public static SimpleExpression ne(String propertyName, Object value)

Source Link

Document

Apply a "not equal" constraint to the named property

Usage

From source file:org.openbravo.erpCommon.ad_forms.InstanceManagement.java

License:Open Source License

private void printPageDeactivateProcess(HttpServletResponse response, VariablesSecureApp vars)
        throws IOException, ServletException {
    OBError msg = new OBError();
    OBContext.setAdminMode();/*from w  w  w  .ja va 2s .  c o  m*/
    try {
        // Check for commercial modules installed in the instance
        OBCriteria<Module> qMods = OBDal.getInstance().createCriteria(Module.class);
        qMods.add(Restrictions.eq(Module.PROPERTY_COMMERCIAL, true));
        qMods.add(Restrictions.eq(Module.PROPERTY_ENABLED, true));
        qMods.addOrder(Order.asc(Module.PROPERTY_NAME));

        // core can be commercial, do not take it into account
        qMods.add(Restrictions.ne(Module.PROPERTY_ID, "0"));
        boolean deactivable = true;
        String commercialModules = "";
        for (Module mod : qMods.list()) {
            deactivable = false;
            commercialModules += "<br/>" + mod.getName();
        }
        if (!deactivable) {
            msg.setType("Error");
            msg.setMessage(Utility.messageBD(this, "CannotDeactivateWithCommercialModules", vars.getLanguage())
                    + commercialModules);
        } else {
            // Deactivate instance
            System sys = OBDal.getInstance().get(System.class, "0");
            sys.setActivationKey(null);
            sys.setInstanceKey(null);
            ActivationKey.reload();
            msg.setType("Success");
            msg.setMessage(Utility.messageBD(this, "Success", vars.getLanguage()));

            ActiveInstanceProcess.updateShowProductionFields("N");

            // When deactivating a cloned instance insert a dummy heartbeat log so it is not detected as
            // a cloned instance anymore.
            if (HeartbeatProcess.isClonedInstance()) {
                insertDummyHBLog();
            }
        }
    } catch (Exception e) {
        log4j.error("Error deactivating instance", e);
        msg.setType("Error");
        msg.setMessage(Utility.parseTranslation(this, vars, vars.getLanguage(), e.getMessage()));
    } finally {
        OBContext.restorePreviousMode();
    }
    vars.setMessage("InstanceManagement", msg);
    printPageClosePopUp(response, vars, "");

}

From source file:org.openbravo.erpCommon.businessUtility.InitialSetupUtility.java

License:Open Source License

private static String getModuleDatasetsChechsum(Module module) {
    String checksum = "";
    OBContext.setAdminMode();//  w w w  .  ja  v  a2  s .  c  o m
    try {
        OBCriteria<DataSet> obc = OBDal.getInstance().createCriteria(DataSet.class);
        obc.createAlias(DataSet.PROPERTY_MODULE, "m");
        obc.add(Restrictions.eq(DataSet.PROPERTY_MODULE, module));
        String[] organizationAccessLevel = { "3", "1" };
        String[] systemAccessLevel = { "3", "6" };
        obc.add(Restrictions.or(
                Restrictions.and(Restrictions.ne(DataSet.PROPERTY_ORGANIZATION, getZeroOrg()),
                        Restrictions.in(DataSet.PROPERTY_DATAACCESSLEVEL, organizationAccessLevel)),
                Restrictions.and(Restrictions.eq(DataSet.PROPERTY_ORGANIZATION, getZeroOrg()),
                        Restrictions.in(DataSet.PROPERTY_DATAACCESSLEVEL, systemAccessLevel))));
        obc.addOrder(Order.asc("m." + Module.PROPERTY_ID));
        obc.addOrder(Order.asc(DataSet.PROPERTY_SEQUENCENUMBER));
        obc.addOrder(Order.asc(DataSet.PROPERTY_ID));
        obc.setFilterOnReadableClients(false);
        obc.setFilterOnReadableOrganization(false);
        for (DataSet dataset : obc.list()) {
            if (checksum.length() > 0 && !StringUtils.isEmpty(dataset.getChecksum())) {
                checksum = checksum + ",";
            }
            checksum = checksum + (dataset.getChecksum() == null ? "" : dataset.getChecksum());
        }
    } finally {
        OBContext.restorePreviousMode();
    }
    return checksum;
}

From source file:org.openbravo.erpCommon.obps.ActivationKey.java

License:Open Source License

/**
 * Looks for all active sessions that have not had activity during last
 * {@link ActivationKey#PING_TIMEOUT_SECS} seconds and deactivates them. Activity is tracked by
 * the requests the browser sends to look for alerts (see
 * {@link org.openbravo.erpCommon.utility.VerticalMenu}).
 * <p/>//from www . j a  v a2s. co m
 * PING_TIMEOUT_SECS is hardcoded to 120s, pings are hardcoded in front-end to 50s.
 */
private boolean deactivateTimeOutSessions(String currentSessionId) {
    // Last valid ping time is current time substract timeout seconds
    Calendar cal = Calendar.getInstance();
    cal.add(Calendar.SECOND, (-1) * PING_TIMEOUT_SECS);
    Date lastValidPingTime = new Date(cal.getTimeInMillis());

    OBCriteria<Session> obCriteria = OBDal.getInstance().createCriteria(Session.class);

    // sesion_active='Y' and (lastPing is null or lastPing<lastValidPing)
    obCriteria.add(Restrictions.and(Restrictions.eq(Session.PROPERTY_SESSIONACTIVE, true),
            Restrictions.or(Restrictions.isNull(Session.PROPERTY_LASTPING),
                    Restrictions.lt(Session.PROPERTY_LASTPING, lastValidPingTime))));
    obCriteria.add(Restrictions.in(Session.PROPERTY_LOGINSTATUS, ACTIVE_SESSION_TYPES));
    obCriteria.add(Restrictions.ne(Session.PROPERTY_ID, currentSessionId));

    boolean sessionDeactivated = false;
    for (Session expiredSession : obCriteria.list()) {
        expiredSession.setSessionActive(false);
        sessionDeactivated = true;
        log4j.info("Deactivated session: " + expiredSession.getId() + " beacuse of ping time out. Last ping: "
                + expiredSession.getLastPing() + ". Last valid ping time: " + lastValidPingTime);
    }
    if (sessionDeactivated) {
        OBDal.getInstance().flush();
    } else {
        log4j.debug("No ping timeout sessions");
    }
    return sessionDeactivated;
}

From source file:org.openbravo.erpCommon.obps.ActivationKey.java

License:Open Source License

/**
 * Returns the number of current active sessions
 *///w  w w .  ja va2 s .c om
private int getActiveSessions(String currentSession) {
    OBCriteria<Session> obCriteria = OBDal.getInstance().createCriteria(Session.class);
    obCriteria.add(Restrictions.eq(Session.PROPERTY_SESSIONACTIVE, true));
    obCriteria.add(Restrictions.in(Session.PROPERTY_LOGINSTATUS, ACTIVE_SESSION_TYPES));

    if (currentSession != null && !currentSession.equals("")) {
        obCriteria.add(Restrictions.ne(Session.PROPERTY_ID, currentSession));
    }
    return obCriteria.count();
}

From source file:org.openbravo.erpCommon.obps.ActivationKey.java

License:Open Source License

private int getActiveSessionsForNamedUser(String currentSession, String username) {
    OBCriteria<Session> obCriteria = OBDal.getInstance().createCriteria(Session.class);
    obCriteria.add(Restrictions.eq(Session.PROPERTY_SESSIONACTIVE, true));
    obCriteria.add(Restrictions.eq(Session.PROPERTY_USERNAME, username));
    obCriteria.add(Restrictions.in(Session.PROPERTY_LOGINSTATUS, ACTIVE_SESSION_TYPES));
    if (currentSession != null && !currentSession.equals("")) {
        obCriteria.add(Restrictions.ne(Session.PROPERTY_ID, currentSession));
    }//from www . j a v  a  2s .  c om
    return obCriteria.count();
}

From source file:org.openbravo.erpCommon.obps.ActivationKey.java

License:Open Source License

private void disableOtherSessionsOfUser(String currentSession, String username) {
    OBContext.setAdminMode();/* w w w  .ja va 2  s  .c  o  m*/
    try {
        OBCriteria<Session> obCriteria = OBDal.getInstance().createCriteria(Session.class);
        obCriteria.add(Restrictions.eq(Session.PROPERTY_SESSIONACTIVE, true));
        obCriteria.add(Restrictions.eq(Session.PROPERTY_USERNAME, username));
        if (currentSession != null && !currentSession.equals("")) {
            obCriteria.add(Restrictions.ne(Session.PROPERTY_ID, currentSession));
        }

        for (Session session : obCriteria.list()) {
            session.setSessionActive(false);
            session.setLoginStatus("CNU");
            log.info("Disabled session " + session.getId() + " for user " + username
                    + " becaue of concurrent sessions with same user");
        }
        OBDal.getInstance().flush();
    } catch (Exception e) {
        log.error("Error deactivating concurrent named users sessions", e);
    } finally {
        OBContext.restorePreviousMode();
    }
}

From source file:org.openbravo.erpCommon.utility.AccDefUtility.java

License:Open Source License

public static Period getCurrentPeriod(Date date, Calendar fiscalCalendar) {
    OBCriteria<Period> obc = OBDal.getInstance().createCriteria(Period.class);
    obc.createAlias(Period.PROPERTY_YEAR, "y");
    obc.add(Restrictions.eq("y." + Year.PROPERTY_CALENDAR, fiscalCalendar));
    obc.add(Restrictions.ge(Period.PROPERTY_ENDINGDATE, date));
    obc.add(Restrictions.ne(Period.PROPERTY_PERIODTYPE, "A"));
    obc.add(Restrictions.le(Period.PROPERTY_STARTINGDATE, date));
    obc.addOrderBy(Period.PROPERTY_PERIODNO, false);
    obc.setFilterOnReadableOrganization(false);
    obc.setFilterOnReadableClients(false);
    List<Period> periods = obc.list();
    if (periods.size() == 0) {
        log4j.error("AccDefUtility - No period defined for invoice date");
        return null;
    } else {//from  w w  w.  java2  s .  c  o m
        return periods.get(0);
    }
}

From source file:org.openbravo.erpCommon.utility.AccDefUtility.java

License:Open Source License

public static Period getNextPeriod(Period period) {
    OBCriteria<Period> obc = OBDal.getInstance().createCriteria(Period.class);
    obc.add(Restrictions.eq(Period.PROPERTY_YEAR, period.getYear()));
    obc.add(Restrictions.ne(Period.PROPERTY_PERIODTYPE, "A"));
    obc.addOrderBy(Period.PROPERTY_PERIODNO, false);
    obc.setFilterOnReadableOrganization(false);
    obc.setFilterOnReadableClients(false);
    Period targetPeriod = null;/*from w  ww  .j  a v a 2 s.  c  o  m*/
    if (period.equals(obc.list().get(0))) {
        targetPeriod = getFirstPeriodOfNextYear(period.getYear());
    } else {
        for (Period p : obc.list()) {
            if (p == period) {
                return targetPeriod;
            }
            targetPeriod = p;
        }
    }
    return targetPeriod;
}

From source file:org.openbravo.erpCommon.utility.AccDefUtility.java

License:Open Source License

public static Period getFirstPeriodOfNextYear(Year year) {
    OBCriteria<Period> obc = OBDal.getInstance().createCriteria(Period.class);
    obc.add(Restrictions.eq(Period.PROPERTY_YEAR, getNextYear(year)));
    obc.add(Restrictions.ne(Period.PROPERTY_PERIODTYPE, "A"));
    obc.addOrderBy(Period.PROPERTY_PERIODNO, true);
    obc.setFilterOnReadableOrganization(false);
    obc.setFilterOnReadableClients(false);
    List<Period> periods = obc.list();
    if (periods.size() == 0) {
        throw new OBException("AccDefUtility - Error getting next year period");
    }//from   w  w  w  .  j av  a  2  s .  c o m
    return periods.get(0);
}