Example usage for org.hibernate.criterion Restrictions lt

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

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

Introduction

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

Prototype

public static SimpleExpression lt(String propertyName, Object value)

Source Link

Document

Apply a "less than" constraint to the named property

Usage

From source file:com.tysanclan.site.projectewok.entities.dao.hibernate.RestTokenDAOImpl.java

License:Open Source License

@Transactional(propagation = Propagation.REQUIRED)
@Override/*w  w w .ja va 2s  . co  m*/
public void cleanExpiredTokens() {
    Criteria criteria = getSession().createCriteria(RestToken.class);
    criteria.add(Restrictions.lt("expires", System.currentTimeMillis()));

    List<RestToken> tokens = listOf(criteria);

    for (RestToken token : tokens) {
        delete(token);
    }
}

From source file:com.tysanclan.site.projectewok.entities.dao.hibernate.RoleTransferDAOImpl.java

License:Open Source License

@Override
protected Criteria createCriteria(SearchFilter<RoleTransfer> filter) {
    Criteria criteria = getSession().createCriteria(RoleTransfer.class);

    if (filter instanceof RoleTransferFilter) {
        RoleTransferFilter f = (RoleTransferFilter) filter;
        if (f.getRoleType() != null) {
            criteria.add(Restrictions.eq("roleType", f.getRoleType()));
        }//from   ww w .  java  2  s  .c  o  m
        if (f.getUser() != null) {
            criteria.add(Restrictions.eq("candidate", f.getUser()));
        }
        if (f.getAccepted() != null) {
            criteria.add(Restrictions.eq("accepted", f.getAccepted()));
        }
        if (f.getStartBefore() != null) {
            criteria.add(Restrictions.lt("start", f.getStartBefore()));
        }
    }

    return criteria;
}

From source file:com.tysanclan.site.projectewok.entities.dao.hibernate.TruthsayerNominationDAOImpl.java

License:Open Source License

@Override
protected Criteria createCriteria(SearchFilter<TruthsayerNomination> filter) {
    Criteria criteria = getSession().createCriteria(TruthsayerNomination.class);

    if (filter instanceof TruthsayerNominationFilter) {
        TruthsayerNominationFilter cf = (TruthsayerNominationFilter) filter;

        if (cf.getNominee() != null) {
            criteria.add(Restrictions.eq("user", cf.getNominee()));
        }/*from  w w w . ja va  2  s. com*/
        if (cf.getStartBefore() != null) {
            criteria.add(Restrictions.lt("voteStart", cf.getStartBefore()));
        } else if (cf.isStartNotSet()) {
            criteria.add(Restrictions.isNull("voteStart"));
        } else if (cf.isStartSet()) {
            criteria.add(Restrictions.isNotNull("voteStart"));
        }
    }

    return criteria;
}

From source file:com.tysanclan.site.projectewok.entities.dao.hibernate.UntenabilityVoteDAOImpl.java

License:Open Source License

@Override
protected Criteria createCriteria(SearchFilter<UntenabilityVote> filter) {
    Criteria criteria = getSession().createCriteria(UntenabilityVote.class);

    if (filter instanceof UntenabilityVoteFilter) {
        UntenabilityVoteFilter cf = (UntenabilityVoteFilter) filter;
        if (cf.getStartBefore() != null) {
            criteria.add(Restrictions.lt("start", cf.getStartBefore()));
        }//  w  w w  .  j ava  2s. c  om
        if (cf.getRegulation() != null) {
            criteria.add(Restrictions.eq("regulation", cf.getRegulation()));
        }
    }

    return criteria;
}

From source file:com.tysanclan.site.projectewok.entities.dao.hibernate.UserDAOImpl.java

License:Open Source License

/**
 * @see com.tysanclan.site.projectewok.dataaccess.EwokHibernateDAO#createCriteria(com.tysanclan.site.projectewok.dataaccess.SearchFilter)
 *///from w  w  w  .j  a v a  2 s  . c  o  m
@Override
protected Criteria createCriteria(SearchFilter<User> filter) {
    Criteria criteria = getSession().createCriteria(User.class);

    if (filter instanceof UserFilter) {
        UserFilter userFilter = (UserFilter) filter;
        if (userFilter.getGroup() != null) {
            criteria.createCriteria("groups").add(Restrictions.eq("group_id", userFilter.getGroup().getId()));
        }
        if (userFilter.getUsername() != null) {
            Criterion eq = Restrictions.eq("username", userFilter.getUsername());
            if (eq instanceof SimpleExpression) {
                eq = ((SimpleExpression) eq).ignoreCase();
            }

            criteria.add(eq);
        }
        if (userFilter.getRanks() != null) {
            criteria.add(Restrictions.in("rank", userFilter.getRanks()));
        }
        if (userFilter.getPassword() != null) {
            criteria.add(Restrictions.eq("password", userFilter.getPassword()));
        }
        if (userFilter.getActiveSince() != null) {
            criteria.add(Restrictions.ge("lastAction", userFilter.getActiveSince()));
        }
        if (userFilter.getActiveBefore() != null) {
            criteria.add(Restrictions.lt("lastAction", userFilter.getActiveBefore()));
        }
        if (userFilter.getEmail() != null) {
            criteria.add(Restrictions.eq("eMail", userFilter.getEmail()));
        }
        if (userFilter.getRetired() != null) {
            criteria.add(Restrictions.eq("retired", userFilter.getRetired()));
        }
        if (userFilter.getVacation() != null) {
            criteria.add(Restrictions.eq("vacation", userFilter.getVacation()));
        }
        if (userFilter.getRealm() != null) {
            Criteria sc = criteria.createCriteria("playedGames");
            sc.add(Restrictions.eq("realm", userFilter.getRealm()));
        }

        if (userFilter.getBugReportMaster() != null) {
            criteria.add(Restrictions.eq("bugReportMaster", userFilter.getBugReportMaster()));
        }

        if (userFilter.getTruthsayerNominated() != null) {
            List<TruthsayerNomination> nominated = truthsayerNominationDAO.findAll();
            Set<Long> userids = new HashSet<Long>();
            for (TruthsayerNomination nomination : nominated) {
                userids.add(nomination.getUser().getId());
            }

            if (userFilter.getTruthsayerNominated()) {
                criteria.add(userids.isEmpty() ? Restrictions.sqlRestriction(" 1 = 2")
                        : Restrictions.in("id", userids));
            } else {
                if (!userids.isEmpty()) {
                    criteria.add(Restrictions.not(Restrictions.in("id", userids)));
                }
            }
        }
    }

    return criteria;
}

From source file:com.uniminuto.ejercicio2.dao.EmployeeDaoImpl.java

public long buscarSalarioMenor(int salario) {
    SessionFactory sf = HibernateUtil.getSessionFactory();
    Session session = sf.openSession();//from w  w  w .  jav a2  s.c o m
    Criteria cr = session.createCriteria(Employee.class);
    cr.add(Restrictions.lt("salario", salario));
    List results = cr.list();
    return results.size();
}

From source file:com.ut.healthelink.dao.impl.transactionInDAOImpl.java

/**
 * The 'getpendingBatches' function will return a list of batches that have a status of "Error" or "Release Pending". The batches returned will only be the ones the current user has access to viewing.
 *
 * @param userId The id of the logged in user trying to view pending batches
 * @param orgId The id of the organization the user belongs to
 *
 * @return The function will return a list of pending batches
 *//*from w ww. j  av  a 2s  . c o  m*/
@Override
@Transactional
@SuppressWarnings("UnusedAssignment")
public List<batchUploads> getpendingBatches(int userId, int orgId, Date fromDate, Date toDate)
        throws Exception {

    int firstResult = 0;

    /* Get a list of connections the user has access to */
    Criteria connections = sessionFactory.getCurrentSession()
            .createCriteria(configurationConnectionSenders.class);
    connections.add(Restrictions.eq("userId", userId));
    List<configurationConnectionSenders> userConnections = connections.list();

    List<Integer> messageTypeList = new ArrayList<Integer>();
    List<Integer> targetOrgList = new ArrayList<Integer>();

    if (userConnections.isEmpty()) {
        messageTypeList.add(0);
        targetOrgList.add(0);
    } else {

        for (configurationConnectionSenders userConnection : userConnections) {
            Criteria connection = sessionFactory.getCurrentSession()
                    .createCriteria(configurationConnection.class);
            connection.add(Restrictions.eq("id", userConnection.getconnectionId()));

            configurationConnection connectionInfo = (configurationConnection) connection.uniqueResult();

            /* Get the message type for the configuration */
            Criteria sourceconfigurationQuery = sessionFactory.getCurrentSession()
                    .createCriteria(configuration.class);
            sourceconfigurationQuery.add(Restrictions.eq("id", connectionInfo.getsourceConfigId()));

            configuration configDetails = (configuration) sourceconfigurationQuery.uniqueResult();

            /* Add the message type to the message type list */
            messageTypeList.add(configDetails.getMessageTypeId());

            /* Get the list of target orgs */
            Criteria targetconfigurationQuery = sessionFactory.getCurrentSession()
                    .createCriteria(configuration.class);
            targetconfigurationQuery.add(Restrictions.eq("id", connectionInfo.gettargetConfigId()));
            configuration targetconfigDetails = (configuration) targetconfigurationQuery.uniqueResult();

            /* Add the target org to the target organization list */
            targetOrgList.add(targetconfigDetails.getorgId());
        }
    }

    /* Get a list of available batches */
    Criteria batchSummaries = sessionFactory.getCurrentSession().createCriteria(batchUploadSummary.class);
    batchSummaries.add(Restrictions.eq("sourceOrgId", orgId));
    batchSummaries.add(Restrictions.in("messageTypeId", messageTypeList));
    batchSummaries.add(Restrictions.in("targetOrgId", targetOrgList));
    List<batchUploadSummary> batchUploadSummaryList = batchSummaries.list();

    List<Integer> batchIdList = new ArrayList<Integer>();

    if (batchUploadSummaryList.isEmpty()) {
        batchIdList.add(0);
    } else {

        for (batchUploadSummary summary : batchUploadSummaryList) {
            batchIdList.add(summary.getbatchId());
        }

    }

    Criteria findBatches = sessionFactory.getCurrentSession().createCriteria(batchUploads.class);
    findBatches.add(Restrictions.in("id", batchIdList));
    findBatches.add(Restrictions.or(Restrictions.eq("statusId", 5), Restrictions.eq("statusId", 6),
            Restrictions.eq("statusId", 7), Restrictions.eq("statusId", 8)));

    if (!"".equals(fromDate) && fromDate != null) {
        findBatches.add(Restrictions.ge("dateSubmitted", fromDate));
    }

    if (!"".equals(toDate) && toDate != null) {
        findBatches.add(Restrictions.lt("dateSubmitted", toDate));
    }

    findBatches.addOrder(Order.desc("dateSubmitted"));

    return findBatches.list();
}

From source file:com.ut.healthelink.dao.impl.transactionInDAOImpl.java

/**
 * The 'findsentBatches' function will return a list of sent batches for the organization passed in.
 *
 * @param orgId The organization Id to find pending transactions for.
 *
 * @return The function will return a list of sent transactions
 *//*  w ww  .java  2  s . c  om*/
@Transactional
public List<batchUploads> findsentBatches(int userId, int orgId, int toOrgId, int messageTypeId, Date fromDate,
        Date toDate) throws Exception {

    /* Get a list of connections the user has access to */
    Criteria connections = sessionFactory.getCurrentSession()
            .createCriteria(configurationConnectionSenders.class);
    connections.add(Restrictions.eq("userId", userId));
    List<configurationConnectionSenders> userConnections = connections.list();

    List<Integer> messageTypeList = new ArrayList<Integer>();
    List<Integer> targetOrgList = new ArrayList<Integer>();

    if (userConnections.isEmpty()) {
        messageTypeList.add(0);
        targetOrgList.add(0);
    } else {

        for (configurationConnectionSenders userConnection : userConnections) {
            Criteria connection = sessionFactory.getCurrentSession()
                    .createCriteria(configurationConnection.class);
            connection.add(Restrictions.eq("id", userConnection.getconnectionId()));

            configurationConnection connectionInfo = (configurationConnection) connection.uniqueResult();

            /* Get the message type for the configuration */
            Criteria sourceconfigurationQuery = sessionFactory.getCurrentSession()
                    .createCriteria(configuration.class);
            sourceconfigurationQuery.add(Restrictions.eq("id", connectionInfo.getsourceConfigId()));

            configuration configDetails = (configuration) sourceconfigurationQuery.uniqueResult();

            /* Add the message type to the message type list */
            if (messageTypeId == 0) {
                messageTypeList.add(configDetails.getMessageTypeId());
            } else {
                if (messageTypeId == configDetails.getMessageTypeId()) {
                    messageTypeList.add(configDetails.getMessageTypeId());
                }
            }

            /* Get the list of target orgs */
            Criteria targetconfigurationQuery = sessionFactory.getCurrentSession()
                    .createCriteria(configuration.class);
            targetconfigurationQuery.add(Restrictions.eq("id", connectionInfo.gettargetConfigId()));
            configuration targetconfigDetails = (configuration) targetconfigurationQuery.uniqueResult();

            /* Add the target org to the target organization list */
            if (toOrgId == 0) {
                targetOrgList.add(targetconfigDetails.getorgId());
            } else {
                if (toOrgId == targetconfigDetails.getorgId()) {
                    targetOrgList.add(targetconfigDetails.getorgId());
                }
            }
        }
    }

    /* Get a list of available batches */
    Criteria batchSummaries = sessionFactory.getCurrentSession().createCriteria(batchUploadSummary.class);
    batchSummaries.add(Restrictions.eq("sourceOrgId", orgId));
    batchSummaries.add(Restrictions.in("messageTypeId", messageTypeList));
    batchSummaries.add(Restrictions.in("targetOrgId", targetOrgList));
    List<batchUploadSummary> batchUploadSummaryList = batchSummaries.list();

    List<Integer> batchIdList = new ArrayList<Integer>();

    if (batchUploadSummaryList.isEmpty()) {
        batchIdList.add(0);
    } else {

        for (batchUploadSummary summary : batchUploadSummaryList) {
            batchIdList.add(summary.getbatchId());
        }

    }

    Criteria findBatches = sessionFactory.getCurrentSession().createCriteria(batchUploads.class);
    findBatches.add(Restrictions.in("id", batchIdList));
    findBatches.add(Restrictions.or(Restrictions.eq("statusId", 4), /* Submission Being Processed */
            Restrictions.eq("statusId", 22), /* Submission Delivery Locked */
            Restrictions.eq("statusId", 23), /* Submission Delivery Completed */
            Restrictions.eq("statusId", 24), /* Submission Processing Completed */
            Restrictions.eq("statusId", 25), /* Target Batch Creation in process */
            Restrictions.eq("statusId", 28), /* Target Batch Creation in process */
            Restrictions.eq("statusId", 29), /* Submission Processed Errored */
            Restrictions.eq("statusId", 30), /* Target Creation Errored */
            Restrictions.eq("statusId", 32) /* Submission Cancelled */
    ));

    if (!"".equals(fromDate)) {
        findBatches.add(Restrictions.ge("dateSubmitted", fromDate));
    }

    if (!"".equals(toDate)) {
        findBatches.add(Restrictions.lt("dateSubmitted", toDate));
    }

    findBatches.addOrder(Order.desc("dateSubmitted"));

    return findBatches.list();
}

From source file:com.ut.healthelink.dao.impl.transactionInDAOImpl.java

@SuppressWarnings("unchecked")
@Override/*from w  w  w.  jav a 2  s .  co m*/
@Transactional
public List<batchUploads> getuploadedBatches(int userId, int orgId, Date fromDate, Date toDate,
        List<Integer> excludedStatusIds) throws Exception {

    /* Get a list of connections the user has access to */
    Criteria connections = sessionFactory.getCurrentSession()
            .createCriteria(configurationConnectionSenders.class);
    connections.add(Restrictions.eq("userId", userId));
    List<configurationConnectionSenders> userConnections = connections.list();

    List<Integer> configIdList = new ArrayList<Integer>();

    if (userConnections.isEmpty()) {
        configIdList.add(0);
    } else {

        for (configurationConnectionSenders userConnection : userConnections) {

            Criteria connection = sessionFactory.getCurrentSession()
                    .createCriteria(configurationConnection.class);
            connection.add(Restrictions.eq("id", userConnection.getconnectionId()));

            configurationConnection connectionInfo = (configurationConnection) connection.uniqueResult();

            if (!configIdList.contains(connectionInfo.getsourceConfigId())) {
                configIdList.add(connectionInfo.getsourceConfigId());
            }
        }
    }
    // multiconfig is 0 so we need to add
    configIdList.add(0);
    Criteria findBatches = sessionFactory.getCurrentSession().createCriteria(batchUploads.class);
    findBatches.add(Restrictions.eq("orgId", orgId));
    findBatches.add(Restrictions.not(Restrictions.in("statusId", excludedStatusIds)));
    findBatches.add(Restrictions.in("configId", configIdList));
    findBatches.add(Restrictions.ne("transportMethodId", 2));

    if (!"".equals(fromDate)) {
        findBatches.add(Restrictions.ge("dateSubmitted", fromDate));
    }

    if (!"".equals(toDate)) {
        findBatches.add(Restrictions.lt("dateSubmitted", toDate));
    }

    findBatches.addOrder(Order.desc("dateSubmitted"));

    return findBatches.list();

}

From source file:com.ut.healthelink.dao.impl.transactionInDAOImpl.java

/**
 * The 'getAllUploadedBatches' function will return a list of batches for the admin in the processing activities section.
 *
 * @param fromDate/*ww w  .j  av  a2  s . co m*/
 * @param toDate
 * @return This function will return a list of batch uploads
 * @throws Exception
 */
@Override
@Transactional
public List<batchUploads> getAllUploadedBatches(Date fromDate, Date toDate, Integer fetchSize)
        throws Exception {

    int firstResult = 0;

    Criteria findBatches = sessionFactory.getCurrentSession().createCriteria(batchUploads.class);

    if (!"".equals(fromDate)) {
        findBatches.add(Restrictions.ge("dateSubmitted", fromDate));
    }

    if (!"".equals(toDate)) {
        findBatches.add(Restrictions.lt("dateSubmitted", toDate));
    }

    findBatches.addOrder(Order.desc("dateSubmitted"));

    if (fetchSize > 0) {
        findBatches.setMaxResults(fetchSize);
    }
    return findBatches.list();
}