Example usage for org.hibernate.criterion Restrictions not

Introduction

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

Prototype

public static Criterion not(Criterion expression)

Source Link

Document

Return the negation of an expression

Usage

From source file:com.ipn.escom.ageinnn.documento.service.DocumentoServiceImpl.java

public List<DocumentoRequerido> findAllDocumentosPendientesByUsuario(Aspirante usuario) {
    List<Integer> documentosId = new ArrayList<>();
    documentosId.add(0);//from   ww  w .  j ava2  s.  c om
    for (DocumentoEntregado de : usuario.getDocumentos()) {
        documentosId.add(de.getDocumentoId());
    }
    SimpleExpression nacional;
    if (usuario.getMedico().isNacional()) {
        nacional = Restrictions.eq("nacional", true);
    } else {
        nacional = Restrictions.eq("extranjero", true);
    }

    List<DocumentoRequerido> documentosPendientes = new ArrayList<>();

    try {
        session = Service.getSessionFactory().getCurrentSession();
        session.beginTransaction();
        documentosPendientes = session.createCriteria(DocumentoRequerido.class).add(nacional)
                .add(Restrictions.not(Restrictions.in("id", documentosId))).list();

        session.getTransaction().commit();
    } catch (Exception e) {
        session.getTransaction().rollback();
        throw e;
    }

    return documentosPendientes;

}

From source file:com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateFilter.java

License:Open Source License

public void applyNegatedFilter(FilterElement element) {
    HibernateFilter notFilter = new HibernateFilter(null, referenceResolver);
    element.apply(notFilter);//from  w  w w  .  ja  v  a2s  .  c  o m
    add(Restrictions.not(notFilter.last()));
}

From source file:com.jaspersoft.jasperserver.api.metadata.tenant.service.impl.TenantServiceImpl.java

License:Open Source License

private DetachedCriteria createSubTenantsCriteria(RepoTenant parentTenant, String text, int depth) {
    DetachedCriteria criteria = DetachedCriteria.forClass(persistentTenantClass());
    String value = "/%";

    if ("/".equals(parentTenant.getTenantUri())) {
        /* Excluding root parent from sub list. */
        criteria.add(Restrictions.ne("tenantId", parentTenant.getTenantId()));
    } else {//from   w ww  .  j a v a  2  s. c om
        value = parentTenant.getTenantUri() + value;
    }

    criteria.add(Restrictions.like("tenantUri", value));

    if (depth > 0) {
        StringBuilder boundary = new StringBuilder(value);
        for (; depth > 0; depth--) {
            boundary.append("/%");
        }
        criteria.add(Restrictions.not(Restrictions.like("tenantUri", boundary.toString())));
    }

    if (text != null) {
        text = databaseCharactersEscapeResolver.getEscapedText(text.trim());
        if (text.length() > 0) {
            Disjunction disjunction = Restrictions.disjunction();

            disjunction.add(new IlikeEscapeAwareExpression("tenantId", text, MatchMode.ANYWHERE));
            disjunction.add(new IlikeEscapeAwareExpression("tenantAlias", text, MatchMode.ANYWHERE));
            disjunction.add(new IlikeEscapeAwareExpression("tenantName", text, MatchMode.ANYWHERE));
            disjunction.add(new IlikeEscapeAwareExpression("tenantDesc", text, MatchMode.ANYWHERE));

            criteria.add(disjunction);
        }
    }
    return criteria;
}

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

License:Open Source License

@Transactional(propagation = Propagation.REQUIRED)
public int getUsersCountExceptExcluded(ExecutionContext executionContext, final Set<String> excludedUserNames,
        final boolean excludeDisabledUsers) {
    return (Integer) getHibernateTemplate().execute(new HibernateCallback() {
        public Object doInHibernate(Session session) throws HibernateException, SQLException {
            Criteria criteria = session.createCriteria(getPersistentUserClass());
            if (excludedUserNames != null && excludedUserNames.size() > 0) {
                criteria.add(Restrictions.not(Restrictions.in("username", excludedUserNames)));
            }/*from  www .j  a  v  a 2  s  .  c  om*/
            if (excludeDisabledUsers) {
                criteria.add(Restrictions.eq("enabled", true));
            }
            criteria.setProjection(Projections.count("id"));
            return criteria.uniqueResult();
        }
    });
}

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 w w w .  java 2 s  .c  om

    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)));
    }/*  w w w.j  a  v a 2s.  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

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)));
    }/*from  ww  w  .  j a  v  a  2  s . c om*/

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

    return criteria;
}

From source file:com.jaspersoft.jasperserver.jaxrs.poc.hypermedia.root.ExcludeFolderFilter.java

License:Open Source License

@Override
public void applyRestrictions(String type, ExecutionContext context, SearchCriteria criteria) {

    String alias = criteria.getAlias("parent", "p");

    for (String uri : toListOfUrisToExclude(context, criteria)) {

        // Filter uri
        criteria.add(Restrictions.ne(alias + ".URI", uri));

        // Filter children uris
        String childrenUrlsExp = (uri.endsWith(Folder.SEPARATOR)) ? uri + "%" : uri + Folder.SEPARATOR + "%";
        criteria.add(Restrictions.not(Restrictions.like(alias + ".URI", childrenUrlsExp)));
    }/*w  w w.j a v  a2s  .  co  m*/
}

From source file:com.jaspersoft.jasperserver.search.filter.FolderFilter.java

License:Open Source License

private void addRoleAccessUrlsRestrictions(SearchCriteria criteria) {
    String alias = criteria.getAlias("parent", "p");

    for (UriDescriptor uriDescriptor : roleAccessUrisResolver.getRestrictedUris()) {
        String uri = (uriDescriptor.isAbsolute()) ? uriDescriptor.getUri()
                : roleAccessUrisResolver.getAbsoluteUri(uriDescriptor.getUri());
        // Filter uri
        criteria.add(Restrictions.ne(alias + ".URI", uri));

        // Filter children uris
        String childrenUrlsExp = (uri.endsWith(Folder.SEPARATOR)) ? uri + "%" : uri + Folder.SEPARATOR + "%";
        criteria.add(Restrictions.not(Restrictions.like(alias + ".URI", childrenUrlsExp)));
    }//from  w  w  w .ja va  2s  .c  o  m
}

From source file:com.jaspersoft.jasperserver.search.filter.ScheduleFilter.java

License:Open Source License

private void createCriteria(SearchCriteria criteria, User user, boolean scheduled, boolean scheduledByUser) {
    SearchCriteria uriCriteria = SearchCriteria.forClass(PersistentReportJob.class);
    if (scheduledByUser) {
        addOwnerCriteria(uriCriteria, user);
    }/*from   ww w  .ja  va 2  s  .c  om*/
    uriCriteria.addProjection(Projections.property("source.reportUnitURI"));
    List uriList = getHibernateTemplate().findByCriteria(uriCriteria);

    if (!uriList.isEmpty()) {
        SearchCriteria idCriteria = SearchCriteria.forClass(RepoResource.class);
        Disjunction disjunction = Restrictions.disjunction();
        String alias = idCriteria.getAlias("parent", "p");
        for (Object o : uriList) {
            String uri = (String) o;

            disjunction.add(getResourceCriterion(alias, uri));
        }

        idCriteria.add(disjunction);
        idCriteria.addProjection(Projections.id());

        List idList = getHibernateTemplate().findByCriteria(idCriteria);

        if (!idList.isEmpty()) {
            if (scheduled) {
                criteria.add(Restrictions.in("id", idList));
            } else {
                criteria.add(Restrictions.not(Restrictions.in("id", idList)));
            }
        } else {
            throw new RuntimeException("No resources found for URI list " + uriList);
        }
    } else {
        if (scheduled || scheduledByUser) {
            criteria.add(Restrictions.isNull("id"));
        }
    }
}