Example usage for org.hibernate.criterion Restrictions le

Introduction

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

Prototype

public static SimpleExpression le(String propertyName, Object value)

Source Link

Document

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

Usage

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

License:Open Source License

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

    if (filter instanceof ActivationFilter) {
        ActivationFilter av = (ActivationFilter) filter;
        if (av.getUser() != null) {
            criteria.add(Restrictions.eq("user", av.getUser()));
        }
        if (av.getKey() != null) {
            criteria.add(Restrictions.eq("activationKey", av.getKey()));
        }
        if (av.getDateBefore() != null) {
            criteria.add(Restrictions.le("registered", av.getDateBefore()));
        }
    }

    return criteria;
}

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

License:Open Source License

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

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

        if (f.getStartAfter() != null) {
            criteria.add(Restrictions.ge("start", f.getStartAfter()));
        }/*from w ww.j  a va2s . c o m*/
        if (f.getStartBefore() != null) {
            criteria.add(Restrictions.le("start", f.getStartBefore()));
        }
        if (f.getWinner() != null) {
            criteria.add(Restrictions.eq("winner", f.getWinner()));
        } else if (f.isNoWinner()) {
            criteria.add(Restrictions.isNull("winner"));
        }
    }

    return criteria;
}

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()));
        }/*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(/*  ww  w.j a v a 2  s  . co m*/
                    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.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   www  .  ja  v a2  s .co m*/
        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.InactivityNotificationDAOImpl.java

License:Open Source License

private Criterion getRegularMemberInactivityCriterion() {
    Conjunction c = Restrictions.conjunction();

    c.add(Restrictions.eq("retired", false));
    c.add(Restrictions.eq("vacation", false));
    c.add(Restrictions.in("rank", MemberUtil.getNonTrialRanks()));
    c.add(Restrictions.le("lastAction", DateUtil.daysAgo(12)));

    return c;/*from   ww w  .jav  a 2s .  com*/
}

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

License:Open Source License

private Criterion getRetiredMemberInactivityCriterion() {
    Conjunction c = Restrictions.conjunction();

    c.add(Restrictions.eq("retired", true));
    c.add(Restrictions.in("rank", MemberUtil.getNonTrialRanks()));
    c.add(Restrictions.le("lastAction", DateUtil.monthsAgo(11)));

    return c;//from  w w w  . j av a 2  s  . c o  m
}

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

License:Open Source License

private Criterion getVacationMemberInactivityCriterion() {
    Conjunction c = Restrictions.conjunction();

    c.add(Restrictions.eq("retired", false));
    c.add(Restrictions.eq("vacation", true));
    c.add(Restrictions.in("rank", MemberUtil.getNonTrialRanks()));
    c.add(Restrictions.le("lastAction", DateUtil.daysAgo(55)));

    return c;/*  ww w. ja v a2s  .c o m*/
}

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

License:Open Source License

private Criterion getTrialMemberInactivityCriterion() {
    Conjunction c = Restrictions.conjunction();

    c.add(Restrictions.eq("rank", Rank.TRIAL));
    c.add(Restrictions.le("lastAction", DateUtil.daysAgo(5)));

    return c;/* w  w  w.j a va2 s  .  co  m*/
}

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//from  ww w  . j  a  va2s .c o  m
        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;
}