Example usage for org.hibernate.criterion Restrictions ge

Introduction

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

Prototype

public static SimpleExpression ge(String propertyName, Object value) 

Source Link

Document

Apply a "greater than or equal" constraint to the named property

Usage

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

License:Open Source License

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

    if (filter instanceof DonationFilter) {
        DonationFilter dFilter = (DonationFilter) filter;
        if (dFilter.getFrom() != null) {
            criteria.add(Restrictions.ge("donationTime", dFilter.getFrom()));
        }/*from  ww w  .j a  v  a 2  s . co m*/
        if (dFilter.getTo() != null) {
            criteria.add(Restrictions.le("donationTime", dFilter.getTo()));
        }
        if (dFilter.getDonator() != null) {
            criteria.add(Restrictions.eq("donator", dFilter.getDonator()));
        }
    }

    return criteria;
}

---

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

License:Open Source License

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

    if (filter instanceof ExpenseFilter) {
        ExpenseFilter eFilter = (ExpenseFilter) filter;
        if (eFilter.getFrom() != null) {
            criteria.add(/*from  w  w w .jav a  2  s  .c  om*/
                    Restrictions.or(Restrictions.ge("end", eFilter.getFrom()), Restrictions.isNull("end")));
        }
        if (eFilter.getTo() != null) {
            criteria.add(
                    Restrictions.or(Restrictions.le("start", eFilter.getTo()), Restrictions.isNull("start")));
        }
    }

    criteria.setResultTransformer(DistinctRootEntityResultTransformer.INSTANCE);

    return criteria;
}

---

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

License:Open Source License

@Override
public List<Expense> getActiveExpenses() {
    Criteria criteria = getSession().createCriteria(Expense.class);

    criteria.add(Restrictions.or(Restrictions.ge("end", new Date()), Restrictions.isNull("end")));

    return listOf(criteria);
}

---

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

License:Open Source License

private void checkAfterCriterium(Criteria criteria, ForumPostFilter forumPostFilter) {
    if (forumPostFilter.getPostAfter() != null) {
        criteria.add(Restrictions.ge("time", forumPostFilter.getPostAfter()));
    }/*from   w  w w.  j  a v  a 2  s . c om*/
}

---

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

License:Open Source License

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

    if (filter instanceof GroupLeaderElectionFilter) {
        GroupLeaderElectionFilter f = (GroupLeaderElectionFilter) filter;

        if (f.getStartAfter() != null) {
            criteria.add(Restrictions.ge("start", f.getStartAfter()));
        }/*from ww w .  ja  va  2 s  . c om*/
        if (f.getStartBefore() != null) {
            criteria.add(Restrictions.le("start", f.getStartBefore()));
        }
        if (f.getGroup() != null) {
            criteria.add(Restrictions.eq("group", f.getGroup()));
        }
    }

    return criteria;
}

---

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

License:Open Source License

@Override
public SortedMap<Date, Long> getMutationsByDate(Date start, Date end) {
    Criteria criteria = getSession().createCriteria(MembershipStatusChange.class);

    if (start != null)
        criteria.add(Restrictions.ge("changeTime", start));

    if (end != null)
        criteria.add(Restrictions.le("changeTime", end));

    criteria.setProjection(Projections.projectionList().add(Projections.property("changeTime"))
            .add(Projections.sum("memberSizeMutation")));

    List<Object[]> results = listOf(criteria);

    SortedMap<Date, Long> map = new TreeMap<Date, Long>(new Comparator<Date>() {
        @Override/* www. j  a v  a2  s  .  com*/
        public int compare(Date d1, Date d2) {
            return -d1.compareTo(d2);
        }
    });

    for (Object[] res : results) {
        Date date = (Date) res[0];
        Long sum = (Long) res[1];

        map.put(date, sum);
    }

    return map;
}

---

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

License:Open Source License

@Override
protected Criteria createCriteria(SearchFilter<SenateElection> filter) {
    Criteria criteria = getSession().createCriteria(SenateElection.class);
    if (filter instanceof SenateElectionFilter) {
        SenateElectionFilter f = (SenateElectionFilter) filter;

        if (f.getStartAfter() != null) {
            criteria.add(Restrictions.ge("start", f.getStartAfter()));
        }//from w w  w .  j a  va2s  . c om
        if (f.getStartBefore() != null) {
            criteria.add(Restrictions.le("start", f.getStartBefore()));
        }
    }

    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)
 *//*  w w w . ja  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.ujjwal.maven.dao.IMPL.StudentDAOIMPL.java

@Override
public Student getByStudentId(int studentId) {
    Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Student.class);
    criteria.add(Restrictions.ge("studentId", studentId));
    return (Student) criteria.uniqueResult();
}

---

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
 *//*www. j av  a2s . 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();
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »