Example usage for org.hibernate Query setDate

Introduction

In this page you can find the example usage for org.hibernate Query setDate.

Prototype

@Deprecated
@SuppressWarnings("unchecked")
default Query<R> setDate(String name, Date val)

Source Link

Document

Bind the val (time is truncated) of a given Date object to a named query parameter.

Usage

From source file:org.projectforge.framework.persistence.api.BaseDao.java

License:Open Source License

/**
 * Only generic check access will be done. The matching entries will not be checked!
 *
 * @param property Property of the data base entity.
 * @param searchString String the user has typed in.
 * @return All matching entries (like search) for the given property modified or updated in the last 2 years.
 *//*from   w  ww.  j  a va2s  .  c  om*/
@Override
@SuppressWarnings("unchecked")
public List<String> getAutocompletion(final String property, final String searchString) {
    checkLoggedInUserSelectAccess();
    if (StringUtils.isBlank(searchString) == true) {
        return null;
    }
    final String hql = "select distinct " + property + " from " + clazz.getSimpleName()
            + " t where deleted=false and lastUpdate > ? and lower(t." + property + ") like ?) order by t."
            + property;
    final Query query = getSession().createQuery(hql);
    final DateHolder dh = new DateHolder();
    dh.add(Calendar.YEAR, -2); // Search only for entries of the last 2 years.
    query.setDate(0, dh.getDate());
    query.setString(1, "%" + StringUtils.lowerCase(searchString) + "%");
    final List<String> list = query.list();
    return list;
}

From source file:org.projectforge.timesheet.TimesheetDao.java

License:Open Source License

/**
 * Get all locations of the user's time sheet (not deleted ones) with modification date within last year.
 * @param searchString//from  w w  w.j av  a 2  s.  co  m
 */
@SuppressWarnings("unchecked")
public List<String> getLocationAutocompletion(final String searchString) {
    checkLoggedInUserSelectAccess();
    if (StringUtils.isBlank(searchString) == true) {
        return null;
    }
    final String s = "select distinct location from " + clazz.getSimpleName()
            + " t where deleted=false and t.user.id = ? and lastUpdate > ? and lower(t.location) like ?) order by t.location";
    final Query query = getSession().createQuery(s);
    query.setInteger(0, PFUserContext.getUser().getId());
    final DateHolder dh = new DateHolder();
    dh.add(Calendar.YEAR, -1);
    query.setDate(1, dh.getDate());
    query.setString(2, "%" + StringUtils.lowerCase(searchString) + "%");
    final List<String> list = query.list();
    return list;
}

From source file:org.projectforge.timesheet.TimesheetDao.java

License:Open Source License

/**
 * Get all locations of the user's time sheet (not deleted ones) with modification date within last year.
 * @param maxResults Limit the result to the recent locations.
 * @return result as Json object./* ww  w . ja v  a  2 s.  co m*/
 */
@SuppressWarnings("unchecked")
public Collection<String> getRecentLocation(final int maxResults) {
    checkLoggedInUserSelectAccess();
    log.info("Get recent locations from the database.");
    final String s = "select location from " + (clazz.getSimpleName()
            + " t where deleted=false and t.user.id = ? and lastUpdate > ? and t.location != null and t.location != '' order by t.lastUpdate desc");
    final Query query = getSession().createQuery(s);
    query.setInteger(0, PFUserContext.getUser().getId());
    final DateHolder dh = new DateHolder();
    dh.add(Calendar.YEAR, -1);
    query.setDate(1, dh.getDate());
    final List<Object> list = query.list();
    int counter = 0;
    final List<String> res = new ArrayList<String>();
    for (final Object loc : list) {
        if (res.contains(loc) == true) {
            continue;
        }
        res.add((String) loc);
        if (++counter >= maxResults) {
            break;
        }
    }
    return res;
}

From source file:org.sakaiproject.evaluation.dao.EvaluationDaoImpl.java