Example usage for org.hibernate.criterion Restrictions isNull

Introduction

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

Prototype

public static Criterion isNull(String propertyName) 

Source Link

Document

Apply an "is null" constraint to the named property

Usage

From source file:com.isotrol.impe3.oi.dao.impl.OIDAOImpl.java

License:Open Source License

private Criteria getQaACountCriteria(PageFilter<QaAFilterDTO> filter) {
    Criteria c = newCriteria(QaAEntity.class);
    c.add(Restrictions.eq("deleted", Boolean.FALSE));

    if (filter.getFilter().getId() != null) {
        c.add(Restrictions.eq("interview.id", filter.getFilter().getId()));
    }//from   w ww. j a v  a  2s  . c  o m

    if (filter.getFilter().getMemberId() != null) {
        c.add(Restrictions.eq("member.id", filter.getFilter().getMemberId()));
    }

    if (filter.getFilter().isValid() == null) {
        // nothing to do
    } else if (filter.getFilter().isValid()) {
        c.add(Restrictions.eq("valid", Boolean.TRUE));
    } else {
        c.add(Restrictions.eq("valid", Boolean.FALSE));
    }

    if (filter.getFilter().isAnswered() == null) {
        // nothing to do
    } else if (filter.getFilter().isAnswered()) {
        c.add(Restrictions.isNotNull("answer"));
    } else {
        c.add(Restrictions.isNull("answer"));
    }

    return c;
}

---

From source file:com.isotrol.impe3.web20.dao.impl.DAOImpl.java

License:Open Source License

/**
 * Create a new criteria for member memberships.
 * @param filter Member memberships filter.
 * @return The created criteria./*from   w w w.j  a  va  2 s. c o  m*/
 */
private Criteria getMemberMembershipCriteria(PageFilter<MembershipSelFilterDTO> filter) {
    Criteria c = newCriteria(MembershipEntity.class);
    c.add(Restrictions.eq("member.id", filter.getFilter().getId()));
    if (filter.getFilter().getRole() != null) {
        c.add(Restrictions.eq("role", filter.getFilter().getRole()));
    }

    c.createAlias("community", "c", Criteria.LEFT_JOIN);
    c.add(Restrictions.eq("c.deleted", false));
    if (!filter.getFilter().isGlobal()) {
        c.add(Restrictions.ne("c.id", CommunityManager.GLOBAL_ID));
    }
    c.add(Restrictions.isNull("deletion"));
    if (filter.getFilter().isValidated() == null) {
        // nothing here.
    } else if (filter.getFilter().isValidated().equals(Boolean.FALSE)) {
        c.add(Restrictions.isNull("validation"));
    } else {
        c.add(Restrictions.isNotNull("validation"));
    }
    return c;
}

---

From source file:com.isotrol.impe3.web20.dao.impl.DAOImpl.java

License:Open Source License

/**
 * Create a new criteria for members./*from  w  ww  . ja  v  a 2  s. co  m*/
 * @param filter Member filter.
 * @return The created criteria.
 */
private Criteria getMemberCriteria(PageFilter<MemberFilterDTO> filter) {
    Criteria c = newCriteria(MemberEntity.class);
    c.add(Restrictions.eq("deleted", Boolean.FALSE));
    if (filter.getFilter().getCommunityId() != null) {
        c.createAlias("memberships", "ms", Criteria.LEFT_JOIN);
        c.add(Restrictions.eq("ms.community.id", filter.getFilter().getCommunityId()));
        c.add(Restrictions.isNull("ms.deletion"));
        c.add(Restrictions.isNotNull("ms.validation"));
    }
    FilterSupport.add(c, "memberCode", filter.getFilter().getMemberCode());
    FilterSupport.add(c, "name", filter.getFilter().getName());
    FilterSupport.add(c, "displayName", filter.getFilter().getDisplayName());
    return c;
}

---

From source file:com.isotrol.impe3.web20.dao.impl.DAOImpl.java

License:Open Source License

private Criteria getCommunityMembershipCriteria(PageFilter<CommunityMembersFilterDTO> filter) {
    Criteria c = newCriteria(MembershipEntity.class);
    c.add(Restrictions.eq("community.id", filter.getFilter().getId()));
    c.createAlias("member", "m", Criteria.LEFT_JOIN);
    c.add(Restrictions.eq("m.deleted", false));
    c.add(Restrictions.isNull("deletion"));
    if (filter.getFilter().isValidated() == null) {
        // nothing here.
    } else if (filter.getFilter().isValidated().equals(Boolean.FALSE)) {
        c.add(Restrictions.isNull("validation"));
    } else {/*www  .j  av a 2 s .  co  m*/
        c.add(Restrictions.isNotNull("validation"));
    }
    if (filter.getFilter().getRole() != null) {
        c.add(Restrictions.eq("role", filter.getFilter().getRole()));
    }

    return c;
}

---

From source file:com.isotrol.impe3.web20.dao.impl.DAOImpl.java

License:Open Source License

private Criteria getCommentCriteria(CommentInternalFilterDTO filter) {
    Criteria c = newCriteria(CommentEntity.class);
    c.add(Restrictions.eq("deleted", Boolean.FALSE));

    if (filter.isValid() != null) {
        if (filter.isValid()) {
            c.add(Restrictions.eq("valid", Boolean.TRUE));
        } else {/*w w w. jav  a  2s  . co  m*/
            c.add(Restrictions.eq("valid", Boolean.FALSE));
        }
    }

    if (filter.isModerated() != null) {
        if (filter.isModerated()) {
            c.add(Restrictions.isNotNull("lastModeration"));
        } else {
            c.add(Restrictions.isNull("lastModeration"));
        }
    }

    if (filter.getRelationship() != null) {
        c.createAlias("relationship", "rs", Criteria.LEFT_JOIN);
        c.add(Restrictions.eq("rs.id", filter.getRelationship()));
    }

    final Calendar dateInit = Calendar.getInstance();
    final Calendar dateEnd = Calendar.getInstance();

    if (filter.getLowDate() != null && filter.getHighDate() != null) {
        dateInit.setTime(filter.getLowDate());
        dateEnd.setTime(filter.getHighDate());
        c.add(Restrictions.between("date", dateInit, dateEnd));
    } else if (filter.getLowDate() != null) {
        dateInit.setTime(filter.getLowDate());
        c.add(Restrictions.ge("date", dateInit));
    } else if (filter.getHighDate() != null) {
        dateEnd.setTime(filter.getHighDate());
        c.add(Restrictions.le("date", dateEnd));
    }

    return c;
}

---

From source file:com.isotrol.impe3.web20.dao.impl.DAOImpl.java

License:Open Source License

/**
 * Create a new criteria for community notices
 * @param filter Community notices filter.
 * @return The created criteria.// w  w  w  .  j  a v  a 2  s.c  o  m
 */
private Criteria getNoticeCriteria(NoticeFilterDTO filter) {
    Criteria c = newCriteria(NoticeEntity.class);
    c.add(Restrictions.eq("community.id", filter.getCommunityId()));
    c.add(Restrictions.eq("deleted", false));

    if (filter.getTitle() != null && filter.getDescription() != null) {
        c.add(Restrictions.or(FilterSupport.criterion("title", filter.getTitle()),
                FilterSupport.criterion("description", filter.getDescription())));
    } else if (filter.getTitle() != null || filter.getDescription() != null) {
        FilterSupport.add(c, "title", filter.getTitle());
        FilterSupport.add(c, "description", filter.getDescription());
    }

    if (filter.isActive() == null) {
        // nothing, return all.
    } else if (filter.isActive()) {
        // true released and not expired
        c.add(Restrictions.or(Restrictions.isNull("expiration"),
                Restrictions.gt("expiration", Calendar.getInstance())));
        c.add(Restrictions.le("release", Calendar.getInstance()));
    } else {
        // false not released or expired
        c.add(Restrictions.or(
                Restrictions.or(Restrictions.isNull("release"),
                        Restrictions.gt("release", Calendar.getInstance())),
                Restrictions.le("expiration", Calendar.getInstance())));
    }
    return c;
}

---

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

License:Open Source License

protected RepoRole getRepoRole(String roleName, String tenantId) {
    RepoTenant tenant = getPersistentTenant(tenantId, false);
    if (tenant == null && !isNullTenant(tenantId)) {
        //if the requested tenant was not found, return null
        if (log.isDebugEnabled()) {
            log.debug("Tenant " + tenantId + " not found, returning null role");
        }//  w  w w  .  j a v a 2s .  c  om
        return null;
    }

    DetachedCriteria criteria = DetachedCriteria.forClass(getPersistentRoleClass());
    if (tenant == null) {
        criteria.add(Restrictions.isNull("tenant")).add(Restrictions.eq("roleName", roleName));
    } else {
        criteria.add(Restrictions.naturalId().set("tenant", tenant).set("roleName", roleName));
    }
    List roleList = getHibernateTemplate().findByCriteria(criteria);
    RepoRole role = null;
    if (roleList.isEmpty()) {
        if (log.isDebugEnabled()) {
            log.debug("Role not found with role name \"" + roleName + "\""
                    + (tenantId == null ? "" : (", tenant \"" + tenantId + "\"")));
        }
    } else {
        role = (RepoRole) roleList.get(0);
    }
    return role;
}

---

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

License:Open Source License

@Override
public void applyRestrictions(String type, ExecutionContext context, SearchCriteria criteria) {
    RepositorySearchCriteria searchCriteria = getTypedAttribute(context, RepositorySearchCriteria.class);

    if (searchCriteria == null || !searchCriteria.isShowHidden()) {
        String p = criteria.getAlias("parent", "p");
        criteria.add(Restrictions.eq(p + ".hidden", Boolean.FALSE));

        if (Folder.class.getName().equals(type)) {
            criteria.add(Restrictions.eq("hidden", Boolean.FALSE));
        }/*from w  w  w  . jav  a 2s.  c  o m*/

        if (ResourceLookup.class.getName().equals(type)) {
            criteria.add(
                    Restrictions.or(Restrictions.isNull("hidden"), Restrictions.eq("hidden", Boolean.FALSE)));
        }
    }
}

---

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

License:Open Source License

public void applyRestrictions(String type, ExecutionContext context, SearchCriteria criteria) {
    SearchAttributes searchAttributes = getSearchAttributes(context);

    if (searchAttributes != null && searchAttributes.getState() != null) {
        String resourceTypeFilterOption = searchAttributes.getState().getCustomFiltersMap()
                .get("resourceTypeFilter");

        List<String> resourceTypes = null;
        if (resourceTypeFilterOption != null) {
            resourceTypes = filterOptionToResourceTypes.get(resourceTypeFilterOption);
        }/*from w ww.  j  a  v  a 2s .c o m*/

        if (resourceTypes != null) {
            criteria.add(Restrictions.in("resourceType", resourceTypes));
        }
    } else {
        final RepositorySearchCriteria repositorySearchCriteria = getTypedAttribute(context,
                RepositorySearchCriteria.class);
        if (repositorySearchCriteria != null) {
            if (repositorySearchCriteria.getResourceTypes() != null
                    && !repositorySearchCriteria.getResourceTypes().isEmpty()) {
                List<String> types = new ArrayList<String>(repositorySearchCriteria.getResourceTypes());
                boolean addFolders = types.remove(Folder.class.getName());
                Criterion criterion = Restrictions.in("resourceType", types);

                if (addFolders && ResourceLookup.class.getName().equals(type)) {
                    Criterion folderCriterion = Restrictions.isNull("resourceType");
                    criteria.add(
                            types.isEmpty() ? folderCriterion : Restrictions.or(folderCriterion, criterion));
                } else {
                    criteria.add(criterion);
                }
            }
        } else {
            throw new RuntimeException("Resource type filter not found in the custom filters map.");
        }
    }
}

---

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  w w w . jav  a2  s.  c  o  m
    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"));
        }
    }
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »