Example usage for org.hibernate.criterion DetachedCriteria addOrder

List of usage examples for org.hibernate.criterion DetachedCriteria addOrder

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. DetachedCriteria
  6. addOrder

Introduction

In this page you can find the example usage for org.hibernate.criterion DetachedCriteria addOrder.

Prototype

public DetachedCriteria addOrder(Order order)

Source Link

Document

Adds an ordering

Usage

From source file:com.itrus.ca.modules.sys.utils.UserUtils.java

License:Open Source License

public static List<Office> getOfficeList() {
    @SuppressWarnings("unchecked")
    List<Office> officeList = null;
    if (officeList == null) {
        User user = getUser();//from  w w w  .  j a  v  a 2  s .com
        DetachedCriteria dc = officeDao.createDetachedCriteria();
        dc.add(dataScopeFilter(user, dc.getAlias(), ""));
        dc.add(Restrictions.eq("delFlag", Office.DEL_FLAG_NORMAL));
        dc.addOrder(Order.asc("code"));
        officeList = officeDao.find(dc);
        putCache(CACHE_OFFICE_LIST, officeList);
    }
    return officeList;
}

From source file:com.itrus.ca.modules.sys.utils.UserUtils.java

License:Open Source License

public static List<Office> getOfficeList(Integer type) {
    @SuppressWarnings("unchecked")
    List<Office> officeList = null;
    DetachedCriteria dc = officeDao.createDetachedCriteria();
    dc.add(Restrictions.eq("delFlag", Office.DEL_FLAG_NORMAL));
    dc.add(Restrictions.eq("type", type.toString()));
    dc.addOrder(Order.asc("code"));
    officeList = officeDao.find(dc);/*from   w  ww.  jav  a2s . c  o m*/
    putCache(CACHE_OFFICE_LIST, officeList);
    return officeList;
}

From source file:com.jaspersoft.jasperserver.api.engine.common.service.impl.HibernateLoggingService.java

License:Open Source License

@Transactional(propagation = Propagation.REQUIRED)
public List getUserEvents(ExecutionContext context) {
    List<RepoLogEvent> events;
    RepoUser user = userHandler.getPersistentUserFromContext();
    if (user != null) {
        DetachedCriteria criteria = DetachedCriteria.forClass(RepoLogEvent.class);
        criteria.add(Restrictions.eq("user", user));
        criteria.addOrder(Order.desc("occurrenceDate"));

        //noinspection unchecked
        events = getHibernateTemplate().findByCriteria(criteria);
    } else {// w  w w .  j  a  va 2 s .c  om
        events = Collections.emptyList();
    }

    return getClientEvents(events);
}

From source file:com.jaspersoft.jasperserver.api.engine.common.service.impl.HibernateLoggingService.java

License:Open Source License

@Transactional(propagation = Propagation.REQUIRED)
public List<LogEvent> getUnreadEvents(ExecutionContext context) {
    List<RepoLogEvent> events;
    RepoUser user = userHandler.getPersistentUserFromContext();
    if (user != null) {
        DetachedCriteria criteria = DetachedCriteria.forClass(RepoLogEvent.class);
        criteria.add(Restrictions.eq("state", LogEvent.STATE_UNREAD));
        criteria.add(Restrictions.eq("user", user));
        criteria.addOrder(Order.desc("occurrenceDate"));

        //noinspection unchecked
        events = getHibernateTemplate().findByCriteria(criteria);
    } else {/*from   w w  w  . j a va 2s. c o  m*/
        events = Collections.emptyList();
    }

    return getClientEvents(events);
}

From source file:com.jaspersoft.jasperserver.api.logging.access.service.impl.AccessServiceImpl.java

License:Open Source License

public List<AccessEvent> getAllEvents(int firstResult, int maxResults) {
    DetachedCriteria criteria = DetachedCriteria
            .forClass(persistentClassFactory.getImplementationClass(AccessEvent.class));
    criteria.addOrder(Order.asc("eventDate"));

    List results = getHibernateTemplate().findByCriteria(criteria, firstResult, maxResults);

    if (results != null && !results.isEmpty()) {
        List<AccessEvent> clientEventsList = new ArrayList<AccessEvent>(results.size());
        Log logger = LogFactory.getLog(COMMAND_OUT_LOGGER);
        for (Object event : results) {
            try {
                AccessEvent accessEvent = (AccessEvent) ((IdedObject) event).toClient(clientClassFactory);
                clientEventsList.add(accessEvent);
            } catch (AccessEventImpl.TranslateException aex) {
                logger.debug(/*from  w  w  w.ja  va 2 s. c  o  m*/
                        "Unable to translate access event:  resource = " + aex.getResource().getClass()
                                + ", factory = " + aex.getResourceFactory().getClass(),
                        aex.getOriginalException());
            } catch (Exception ex) {
                logger.debug("Unable to translate access event", ex);
            }
        }
        return clientEventsList;
    } else {
        return Collections.emptyList();
    }
}

From source file:com.jaspersoft.jasperserver.api.metadata.user.service.impl.UserAuthorityServiceImpl.java

License:Open Source License

protected DetachedCriteria createTenantVisibleRolesCriteria(Set tenantIds, String name, boolean order) {
    DetachedCriteria criteria = DetachedCriteria.forClass(getPersistentRoleClass());
    String roleNameField = "roleName";

    addVisibleTenantCriteria(criteria, tenantIds);

    if (name != null) {
        name = databaseCharactersEscapeResolver.getEscapedText(name.trim());

        if (name.length() > 0) {
            //                Criterion roleNameCriterion = Restrictions.ilike(roleNameField, "%"
            //                        + name.trim() + "%");
            //                criteria.add(roleNameCriterion);
            criteria.add(new IlikeEscapeAwareExpression(roleNameField, name, MatchMode.ANYWHERE));
        }/*  w w  w . j a v  a 2  s. c om*/
    }

    if (order) {
        criteria.addOrder(Order.asc(roleNameField));
    }

    return criteria;
}

From source file:com.jaspersoft.jasperserver.api.metadata.user.service.impl.UserAuthorityServiceImpl.java

License:Open Source License

protected DetachedCriteria createAvailableRolesCriteria(String roleName, Set userRoles, String userName,
        boolean order) {

    DetachedCriteria criteria = DetachedCriteria.forClass(getPersistentRoleClass());
    String roleNameField = "roleName";
    String externallyDefinedField = "externallyDefined";

    if (userRoles != null && userRoles.size() > 0) {

        List userRoleIdList = getRoleIdList(userRoles);
        criteria.add(Restrictions.not(Restrictions.in("id", userRoleIdList)));
    }/*from   ww w  .j ava  2s  . co m*/

    Criterion roleNameCriterion = Restrictions.ilike(roleNameField, "%" + roleName.trim() + "%");
    criteria.add(roleNameCriterion);

    criteria.add(Restrictions.eq(externallyDefinedField, Boolean.FALSE));

    if (order) {
        criteria.addOrder(Order.asc(roleNameField));
    }

    return criteria;
}

From source file:com.jaspersoft.jasperserver.api.metadata.user.service.impl.UserAuthorityServiceImpl.java

License:Open Source License

protected DetachedCriteria createAvailableRolesCriteria(ExecutionContext context, String userName, String text,
        boolean order) {
    final String roleNameField = "roleName";
    final String externallyDefinedField = "externallyDefined";

    RepoUser user = getRepoUser(context, userName);

    DetachedCriteria criteria = DetachedCriteria.forClass(getPersistentRoleClass());

    List<Long> assignedRolesIds = getUserRolesIds(user);
    if (assignedRolesIds != null && assignedRolesIds.size() > 0) {
        criteria.add(Restrictions.not(Restrictions.in("id", assignedRolesIds)));
    }/*from w w  w  . j  a  v  a 2  s.  c  om*/

    final String roleNameLikeValue = text == null ? "" : text;
    Criterion roleNameCriterion = Restrictions.ilike(roleNameField, "%" + roleNameLikeValue + "%");
    criteria.add(roleNameCriterion);

    criteria.add(Restrictions.eq(externallyDefinedField, Boolean.FALSE));

    if (order) {
        criteria.addOrder(Order.asc(roleNameField));
    }

    return criteria;
}

From source file:com.jaspersoft.jasperserver.api.metadata.user.service.impl.UserAuthorityServiceImpl.java

License:Open Source License

private DetachedCriteria createAssignedRolesCriteria(ExecutionContext context, RepoUser user, String text,
        boolean order) {
    final String roleNameField = "roleName";
    final String externallyDefinedField = "externallyDefined";

    DetachedCriteria criteria = DetachedCriteria.forClass(getPersistentRoleClass());

    DetachedCriteria usersCriteria = criteria.createCriteria("users");
    usersCriteria.add(Restrictions.idEq(user.getId()));

    final String roleNameLikeValue = text == null ? "" : text;
    Criterion roleNameCriterion = Restrictions.ilike(roleNameField, "%" + roleNameLikeValue + "%");
    criteria.add(roleNameCriterion);//from   w  w w.j  a v a2  s .  co  m

    criteria.add(Restrictions.eq(externallyDefinedField, Boolean.FALSE));

    if (order) {
        criteria.addOrder(Order.asc(roleNameField));
    }

    return criteria;
}

From source file:com.jaspersoft.jasperserver.api.metadata.user.service.impl.UserAuthorityServiceImpl.java

License:Open Source License

protected DetachedCriteria createUsersWithoutRoleCriteria(String roleName, String userName, boolean order) {

    DetachedCriteria criteria = DetachedCriteria.forClass(getPersistentUserClass());

    DetachedCriteria usersWithRoleCriteria = createUsersWithRoleCriteria(roleName, "");
    usersWithRoleCriteria.setProjection(Projections.id());

    List usersWithRole = getHibernateTemplate().findByCriteria(usersWithRoleCriteria);

    String userNameField = "username";

    //        addTenantCriteria(criteria, tenantIds);
    createSearchByUserNameCriteria(criteria, userName);

    if (usersWithRole != null && usersWithRole.size() > 0) {
        criteria.add(Restrictions.not(Restrictions.in("id", usersWithRole)));
    }//  w  ww .  j  a  v  a2 s  .co  m

    if (order) {
        criteria.addOrder(Order.asc(userNameField));
    }

    return criteria;
}