Example usage for org.hibernate.criterion Restrictions ge

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

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. Restrictions
  6. 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.eucalyptus.reporting.export.Export.java

License:Open Source License

public static ReportingExport export(final Date startDate, final Date endDate,
        final boolean includeDependencies) {
    final ReportingExport export = new ReportingExport();
    final Conjunction criterion = Restrictions.conjunction();
    if (startDate != null) {
        criterion.add(Restrictions.ge(CREATION_TIMESTAMP, startDate));
    }//from   w  w w  . ja va  2  s .  co m
    if (endDate != null) {
        criterion.add(Restrictions.lt(CREATION_TIMESTAMP, endDate));
    }

    final List<ReportingEventSupport> actions = Lists.newArrayList();
    export.addUsage(
            Iterables.filter(
                    Iterables.transform(
                            iterableExporter(criterion, getUsageClasses(),
                                    Collections.<ReportingEventSupport>emptyList(), includeDependencies),
                            ExportUtils.toExportUsage(includeDependencies ? actions : null)),
                    Predicates.notNull()));
    export.addActions(
            Iterables
                    .transform(
                            Iterables.concat(actions,
                                    iterableExporter(criterion, getEventClasses(), actions,
                                            includeDependencies)),
                            Functions.compose(userAccountDecorator(), ExportUtils.toExportAction())));

    return export;
}

From source file:com.eucalyptus.simpleworkflow.SimpleWorkflowService.java

License:Open Source License

private static void buildFilters(final ClosedWorkflowExecutionFilterParameters parameters,
        final Conjunction filter, final Map<String, String> aliases) {
    if (parameters.getCloseStatusFilter() != null) {
        filter.add(Restrictions.eq("closeStatus",
                WorkflowExecution.CloseStatus.fromString(parameters.getCloseStatusFilter().getStatus())));
    }/*from  w  ww  .  ja  v  a 2s.c  o m*/
    if (parameters.getCloseTimeFilter() != null) {
        if (parameters.getCloseTimeFilter().getOldestDate() != null) {
            filter.add(Restrictions.ge("closeTimestamp", parameters.getCloseTimeFilter().getOldestDate()));
        }
        if (parameters.getCloseTimeFilter().getLatestDate() != null) {
            filter.add(Restrictions.le("closeTimestamp", parameters.getCloseTimeFilter().getLatestDate()));
        }
    }
    buildFilters((WorkflowExecutionFilterParameters) parameters, filter, aliases);
}

From source file:com.eucalyptus.simpleworkflow.SimpleWorkflowService.java

License:Open Source License

private static void buildFilters(final WorkflowExecutionFilterParameters parameters, final Conjunction filter,
        final Map<String, String> aliases) {
    if (parameters.getExecutionFilter() != null) {
        filter.add(Restrictions.eq("workflowId", parameters.getExecutionFilter().getWorkflowId()));
    }/*  w  w  w .  j  a v a2 s  .  c o m*/
    if (parameters.getStartTimeFilter() != null) {
        if (parameters.getStartTimeFilter().getOldestDate() != null) {
            filter.add(Restrictions.ge("creationTimestamp", parameters.getStartTimeFilter().getOldestDate()));
        }
        if (parameters.getStartTimeFilter().getLatestDate() != null) {
            filter.add(Restrictions.le("creationTimestamp", parameters.getStartTimeFilter().getLatestDate()));
        }
    }
    if (parameters.getTagFilter() != null) {
        aliases.put("tagList", "tag");
        filter.add(Restrictions.eq("tag.elements", parameters.getTagFilter().getTag()));
    }
    if (parameters.getTypeFilter() != null) {
        if (parameters.getTypeFilter().getName() != null) {
            aliases.put("workflowType", "workflowType");
            filter.add(Restrictions.eq("workflowType.displayName", parameters.getTypeFilter().getName()));
        }
        if (parameters.getTypeFilter().getVersion() != null) {
            aliases.put("workflowType", "workflowType");
            filter.add(
                    Restrictions.eq("workflowType.workflowVersion", parameters.getTypeFilter().getVersion()));
        }
    }
}

From source file:com.evolveum.midpoint.repo.sql.query.matcher.Matcher.java

License:Apache License

protected Criterion basicMatch(ItemRestrictionOperation operation, String propertyName, Object value,
        boolean ignoreCase) throws QueryException {
    Criterion criterion;/*from   ww  w  .j a v  a  2  s  .c om*/
    switch (operation) {
    case EQ:
        if (value == null) {
            criterion = Restrictions.isNull(propertyName);
        } else {
            criterion = Restrictions.eq(propertyName, value);
        }
        break;
    case GT:
        criterion = Restrictions.gt(propertyName, value);
        break;
    case GE:
        criterion = Restrictions.ge(propertyName, value);
        break;
    case LT:
        criterion = Restrictions.lt(propertyName, value);
        break;
    case LE:
        criterion = Restrictions.le(propertyName, value);
        break;
    case NOT_NULL:
        criterion = Restrictions.isNotNull(propertyName);
        break;
    case NULL:
        criterion = Restrictions.isNull(propertyName);
        break;
    case STARTS_WITH:
        criterion = Restrictions.like(propertyName, (String) value, MatchMode.START);
        break;
    case ENDS_WITH:
        criterion = Restrictions.like(propertyName, (String) value, MatchMode.END);
        break;
    case SUBSTRING:
        criterion = Restrictions.like(propertyName, (String) value, MatchMode.ANYWHERE);
        break;
    default:
        throw new QueryException("Unknown operation '" + operation + "'.");
    }

    if (ignoreCase && (value instanceof String) && (criterion instanceof SimpleExpression)) {
        criterion = ((SimpleExpression) criterion).ignoreCase();
    }

    return criterion;
}

From source file:com.floreantpos.model.dao.AttendenceHistoryDAO.java

License:Open Source License

public List<User> findNumberOfClockedInUserAtHour(Date fromDay, Date toDay, int hour, UserType userType,
        Terminal terminal) {//from   www.  jav  a 2  s. co  m
    Session session = null;

    ArrayList<User> users = new ArrayList<User>();

    try {
        session = getSession();
        Criteria criteria = session.createCriteria(getReferenceClass());
        criteria.add(Restrictions.ge(AttendenceHistory.PROP_CLOCK_IN_TIME, fromDay));
        criteria.add(Restrictions.le(AttendenceHistory.PROP_CLOCK_IN_TIME, toDay));
        criteria.add(Restrictions.le(AttendenceHistory.PROP_CLOCK_IN_HOUR, new Short((short) hour)));

        if (userType != null) {
            criteria.createAlias(AttendenceHistory.PROP_USER, "u"); //$NON-NLS-1$
            criteria.add(Restrictions.eq("u.type", userType)); //$NON-NLS-1$
        }
        if (terminal != null) {
            criteria.add(Restrictions.eq(Ticket.PROP_TERMINAL, terminal));
        }

        List list = criteria.list();
        for (Object object : list) {
            AttendenceHistory history = (AttendenceHistory) object;

            if (!history.isClockedOut()) {
                users.add(history.getUser());
            } else if (history.getClockOutHour() >= hour) {
                users.add(history.getUser());
            }
        }
        return users;
    } catch (Exception e) {
        throw new PosException(Messages.getString("AttendenceHistoryDAO.2"), e); //$NON-NLS-1$
    } finally {
        if (session != null) {
            closeSession(session);
        }
    }
}

From source file:com.floreantpos.model.dao.AttendenceHistoryDAO.java

License:Open Source License

public List<User> findNumberOfClockedInUserAtShift(Date fromDay, Date toDay, Shift shift, UserType userType,
        Terminal terminal) {//from   w w w . jav  a  2 s  .c o m
    Session session = null;

    ArrayList<User> users = new ArrayList<User>();

    try {
        session = getSession();
        Criteria criteria = session.createCriteria(getReferenceClass());
        criteria.add(Restrictions.ge(AttendenceHistory.PROP_CLOCK_IN_TIME, fromDay));
        criteria.add(Restrictions.le(AttendenceHistory.PROP_CLOCK_IN_TIME, toDay));
        criteria.add(Restrictions.le(AttendenceHistory.PROP_SHIFT, shift));

        if (userType != null) {
            criteria.createAlias(AttendenceHistory.PROP_USER, "u"); //$NON-NLS-1$
            criteria.add(Restrictions.eq("u.type", userType)); //$NON-NLS-1$
        }
        if (terminal != null) {
            criteria.add(Restrictions.eq(Ticket.PROP_TERMINAL, terminal));
        }

        List list = criteria.list();
        for (Object object : list) {
            AttendenceHistory history = (AttendenceHistory) object;

            //            if (!history.isClockedOut()) {
            //               users.add(history.getUser());
            //            }
            //            else if (history.getClockOutHour() >= hour) {
            //               users.add(history.getUser());
            //            }
            users.add(history.getUser());
        }
        return users;
    } catch (Exception e) {
        throw new PosException(Messages.getString("AttendenceHistoryDAO.5"), e); //$NON-NLS-1$
    } finally {
        if (session != null) {
            closeSession(session);
        }
    }
}

From source file:com.floreantpos.model.dao.AttendenceHistoryDAO.java

License:Open Source License

public List<PayrollReportData> findPayroll(Date from, Date to) {
    Session session = null;//from w  w w  . j  a  va 2  s .  c o  m

    ArrayList<PayrollReportData> list = new ArrayList<PayrollReportData>();

    try {
        session = getSession();
        Criteria criteria = session.createCriteria(AttendenceHistory.class);
        criteria.add(Restrictions.ge(AttendenceHistory.PROP_CLOCK_IN_TIME, from));
        criteria.add(Restrictions.le(AttendenceHistory.PROP_CLOCK_OUT_TIME, to));
        criteria.addOrder(Order.asc(AttendenceHistory.PROP_USER));
        List list2 = criteria.list();

        for (Iterator iterator = list2.iterator(); iterator.hasNext();) {
            AttendenceHistory history = (AttendenceHistory) iterator.next();
            PayrollReportData data = new PayrollReportData();
            data.setFrom(history.getClockInTime());
            data.setTo(history.getClockOutTime());
            data.setDate(history.getClockInTime());
            data.setUser(history.getUser());
            data.calculate();

            list.add(data);
        }

        return list;
    } catch (Exception e) {
        throw new PosException(Messages.getString("AttendenceHistoryDAO.6"), e); //$NON-NLS-1$
    } finally {
        if (session != null) {
            session.close();
        }
    }
}

From source file:com.floreantpos.model.dao.AttendenceHistoryDAO.java

License:Open Source License

public List<AttendanceReportData> findAttendance(Date from, Date to, User user) {
    Session session = null;/*  ww w .j  ava  2  s  .c  o  m*/

    ArrayList<AttendanceReportData> list = new ArrayList<AttendanceReportData>();

    try {
        session = getSession();
        Criteria criteria = session.createCriteria(AttendenceHistory.class);
        criteria.add(Restrictions.ge(AttendenceHistory.PROP_CLOCK_IN_TIME, from));
        criteria.add(Restrictions.le(AttendenceHistory.PROP_CLOCK_OUT_TIME, to));
        criteria.addOrder(Order.asc(AttendenceHistory.PROP_USER));

        if (user != null) {
            criteria.add(Restrictions.eq(AttendenceHistory.PROP_USER, user));
        }

        List list2 = criteria.list();

        for (Iterator iterator = list2.iterator(); iterator.hasNext();) {
            AttendenceHistory history = (AttendenceHistory) iterator.next();
            AttendanceReportData data = new AttendanceReportData();
            data.setClockIn(history.getClockInTime());
            data.setClockOut(history.getClockOutTime());
            data.setUser(history.getUser());
            data.setName(history.getUser().getFirstName());
            data.calculate();

            list.add(data);
        }

        return list;
    } catch (Exception e) {
        throw new PosException("Unable to find Attendance", e); //$NON-NLS-1$
    } finally {
        if (session != null) {
            session.close();
        }
    }
}

From source file:com.floreantpos.model.dao.AttendenceHistoryDAO.java

License:Open Source License

public List<AttendenceHistory> findHistory(Date from, Date to, User user) {
    Session session = null;/*from  w w  w  .  j  a  v a2s  .c o m*/

    try {
        session = getSession();
        Criteria criteria = session.createCriteria(AttendenceHistory.class);
        criteria.add(Restrictions.ge(AttendenceHistory.PROP_CLOCK_IN_TIME, from));
        criteria.add(Restrictions.le(AttendenceHistory.PROP_CLOCK_OUT_TIME, to));
        criteria.addOrder(Order.asc(AttendenceHistory.PROP_ID));
        if (user != null) {
            criteria.add(Restrictions.eq(AttendenceHistory.PROP_USER, user));
        }

        List list2 = criteria.list();

        return list2;
    } catch (Exception e) {
        throw new PosException("Unable to find History", e); //$NON-NLS-1$
    } finally {
        if (session != null) {
            session.close();
        }
    }
}

From source file:com.floreantpos.model.dao.DiscountDAO.java

License:Open Source License

public List<Discount> findAllValidCoupons() {
    Session session = null;/*  w ww  .ja va  2s  . c om*/

    Date currentDate = new Date();

    try {
        session = createNewSession();
        Criteria criteria = session.createCriteria(getReferenceClass());
        criteria.add(Restrictions.eq(Discount.PROP_ENABLED, Boolean.TRUE));
        criteria.add(Restrictions.or(Restrictions.eq(Discount.PROP_NEVER_EXPIRE, Boolean.TRUE),
                Restrictions.ge(Discount.PROP_EXPIRY_DATE, currentDate)));
        return criteria.list();
    } finally {
        closeSession(session);
    }

}