Example usage for org.hibernate.criterion Restrictions isNotNull

Introduction

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

Prototype

public static Criterion isNotNull(String propertyName) 

Source Link

Document

Apply an "is not null" constraint to the named property

Usage

From source file:com.ipn.escom.ageinnn.usuario.service.AspiranteServceImpl.java

public List<String> findAllFolios(PeriodoAdmision periodo) {
    List<String> folios = new ArrayList<>();
    try {/*w  ww .  j  av  a2  s . c om*/
        session = Service.getSessionFactory().getCurrentSession();
        session.beginTransaction();
        folios = session.createCriteria(MedicoResidente.class).add(Restrictions.isNotNull("folio"))
                .setProjection(Projections.property("folio")).list();
        session.getTransaction().commit();
    } catch (Exception e) {
        session.getTransaction().rollback();
        throw e;
    }
    return folios;
}

---

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

    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./*  www. j  a v  a 2s. 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  w  w .  j  ava 2s .  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 {/*from   w w w .  ja v  a  2  s.  com*/
        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 {//from w  w  w  . j av a 2  s  . c om
            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.itrus.ca.modules.cms.service.ArticleService.java

License:Open Source License

public Page<Article> find(Page<Article> page, Article article, boolean isDataScopeFilter) {
    // ??6??/*from  ww  w  .  j ava  2  s  . c om*/
    Date updateExpiredWeightDate = (Date) CacheUtils.get("updateExpiredWeightDateByArticle");
    if (updateExpiredWeightDate == null
            || (updateExpiredWeightDate != null && updateExpiredWeightDate.getTime() < new Date().getTime())) {
        articleDao.updateExpiredWeight();
        CacheUtils.put("updateExpiredWeightDateByArticle", DateUtils.addHours(new Date(), 6));
    }
    DetachedCriteria dc = articleDao.createDetachedCriteria();
    dc.createAlias("category", "category");
    dc.createAlias("category.site", "category.site");
    if (article.getCategory() != null && article.getCategory().getId() != null
            && !Category.isRoot(article.getCategory().getId())) {
        Category category = categoryDao.findOne(article.getCategory().getId());
        if (category != null) {
            dc.add(Restrictions.or(Restrictions.eq("category.id", category.getId()),
                    Restrictions.like("category.parentIds", "%," + category.getId() + ",%")));
            dc.add(Restrictions.eq("category.site.id", category.getSite().getId()));
            article.setCategory(category);
        } else {
            dc.add(Restrictions.eq("category.site.id", Site.getCurrentSiteId()));
        }
    } else {
        dc.add(Restrictions.eq("category.site.id", Site.getCurrentSiteId()));
    }
    if (StringUtils.isNotEmpty(article.getTitle())) {
        dc.add(Restrictions.like("title", "%" + EscapeUtil.escapeLike(article.getTitle()) + "%"));
    }
    if (StringUtils.isNotEmpty(article.getPosid())) {
        dc.add(Restrictions.like("posid", "%," + article.getPosid() + ",%"));
    }
    if (StringUtils.isNotEmpty(article.getImage()) && Article.YES.equals(article.getImage())) {
        dc.add(Restrictions.and(Restrictions.isNotNull("image"), Restrictions.ne("image", "")));
    }
    if (article.getCreateBy() != null && article.getCreateBy().getId() > 0) {
        dc.add(Restrictions.eq("createBy.id", article.getCreateBy().getId()));
    }
    if (isDataScopeFilter) {
        dc.createAlias("category.office", "categoryOffice").createAlias("createBy", "createBy");
        dc.add(dataScopeFilter(UserUtils.getUser(), "categoryOffice", "createBy"));
    }
    dc.add(Restrictions.eq(Article.DEL_FLAG, article.getDelFlag()));
    if (StringUtils.isBlank(page.getOrderBy())) {
        dc.addOrder(Order.desc("weight"));
        dc.addOrder(Order.desc("updateDate"));
    }
    return articleDao.find(page, dc);
}

---

From source file:com.jeroensteenbeeke.hyperion.data.Nullable.java

License:Open Source License

public static <T extends Serializable> Nullable<T> isNotNull(final String property, Class<T> requiredType) {
    return new Nullable<T>() {
        private static final long serialVersionUID = 1L;

        @Override/*from  w  w  w .  j ava2 s.  c o  m*/
        public void decorateCriteria(Criteria criteria) {
            criteria.add(Restrictions.isNotNull(property));
        }

        @Override
        public boolean retain(Object object) {
            Object res = Reflector.invokeGetter(object, property);

            return res != null;
        }
    };
}

---

From source file:com.jeysan.modules.orm.hibernate.HibernateDao.java

License:Apache License

/**
 * ??Criterion,./*from   w  w w  .  ja  va2s .  com*/
 */
protected Criterion buildCriterion(final String propertyName, final Object propertyValue,
        final MatchType matchType) {
    Assert.hasText(propertyName, "propertyName?");
    Criterion criterion = null;
    //?MatchTypecriterion
    switch (matchType) {
    case EQ:
        criterion = Restrictions.eq(propertyName, propertyValue);
        break;
    case NEQ:
        if (propertyValue == null)
            criterion = Restrictions.isNotNull(propertyName);
        else
            criterion = Restrictions.not(Restrictions.eq(propertyName, propertyValue));
        break;
    case NULL:
        criterion = Restrictions.isNull(propertyName);
        break;
    case LIKE:
        criterion = Restrictions.like(propertyName, (String) propertyValue, MatchMode.ANYWHERE);
        break;

    case LE:
        criterion = Restrictions.le(propertyName, propertyValue);
        break;
    case LT:
        criterion = Restrictions.lt(propertyName, propertyValue);
        break;
    case GE:
        criterion = Restrictions.ge(propertyName, propertyValue);
        break;
    case GT:
        criterion = Restrictions.gt(propertyName, propertyValue);
    }
    return criterion;
}

---

From source file:com.jubination.model.dao.ClientDAOImpl.java

@Transactional(propagation = Propagation.REQUIRED, readOnly = true)
public Object fetchInnerEntities(String param, String type) {
    List<Lead> list = null;
    if (param.equals("Lead")) {
        if (type.equals("NotificationOn")) {
            session = getSessionFactory().getCurrentSession();
            list = (List<Lead>) session.createCriteria(Lead.class).add(Restrictions.isNotNull("followUpDate"))
                    .setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY).list();
        }//from w w  w .  j av a  2s.c  om

        if (type.equals("Pending")) {
            session = getSessionFactory().getCurrentSession();
            list = (List<Lead>) session.createCriteria(Lead.class).add(Restrictions.ge("count", 1))
                    .setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY).list();

        }

    } else if (param.equals("Number")) {
        session = getSessionFactory().getCurrentSession();
        list = (List<Lead>) session.createCriteria(Lead.class).createAlias("client", "c")
                .add(Restrictions.eq("c.phoneNumber", type))
                .setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY).list();

    } else if (param.equals("MissedAppointmentStatusToday")) {
        session = getSessionFactory().getCurrentSession();
        list = (List<Lead>) session.createCriteria(Lead.class)
                .add(Restrictions.and(Restrictions.like("missedAppointmentStatus", type, MatchMode.ANYWHERE),
                        Restrictions.eq("appointmentDate",
                                new SimpleDateFormat("yyyy-MM-dd").format(new Date()))))
                .setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY).list();

    } else if (param.equals("ActiveSourceLeads")) {
        session = getSessionFactory().getCurrentSession();
        list = (List<Lead>) session.createCriteria(Lead.class, "l").createAlias("client", "c")
                .add(Restrictions.and(Restrictions.ge("l.count", 1), Restrictions.eq("c.source", type)))
                .setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY).list();

    }
    if (list != null) {
        for (Lead lead : list) {
            if (lead != null) {
                if (lead.getBeneficiaries() != null) {
                    lead.getBeneficiaries().size();
                }
            }
        }
    }
    System.out.println("READ LEAD WITH A STATUS :::::::::::::::::::::::::::::::::::::::::::::::CHECK");
    return (T) list;
}

---

• «
• 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
• »