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.tysanclan.site.projectewok.entities.dao.hibernate.ExpenseDAOImpl.java

License:Open Source License

@Override
protected Criteria createCriteria(SearchFilter<Expense> filter) {
    Criteria criteria = getSession().createCriteria(Expense.class);

    if (filter instanceof ExpenseFilter) {
        ExpenseFilter eFilter = (ExpenseFilter) filter;
        if (eFilter.getFrom() != null) {
            criteria.add(//from   w  w w  .  j av a  2  s.  com
                    Restrictions.or(Restrictions.ge("end", eFilter.getFrom()), Restrictions.isNull("end")));
        }
        if (eFilter.getTo() != null) {
            criteria.add(
                    Restrictions.or(Restrictions.le("start", eFilter.getTo()), Restrictions.isNull("start")));
        }
    }

    criteria.setResultTransformer(DistinctRootEntityResultTransformer.INSTANCE);

    return criteria;
}

---

From source file:com.tysanclan.site.projectewok.entities.dao.hibernate.ExpenseDAOImpl.java

License:Open Source License

@Override
public List<Expense> getActiveExpenses() {
    Criteria criteria = getSession().createCriteria(Expense.class);

    criteria.add(Restrictions.or(Restrictions.ge("end", new Date()), Restrictions.isNull("end")));

    return listOf(criteria);
}

---

From source file:com.tysanclan.site.projectewok.entities.dao.hibernate.MobileUserAgentDAOImpl.java

License:Open Source License

@Override
protected Criteria createCriteria(SearchFilter<MobileUserAgent> filter) {
    Criteria criteria = getSession().createCriteria(MobileUserAgent.class);

    if (filter instanceof MobileUserAgentFilter) {
        MobileUserAgentFilter cf = (MobileUserAgentFilter) filter;

        if (cf.getMobile() != null) {
            criteria.add(Restrictions.eq("mobile", cf.getMobile()));
        } else if (cf.isSearchUnknownType()) {
            criteria.add(Restrictions.isNull("mobile"));
        }//from   w  ww  .  ja  v  a2  s.  com

        if (cf.getIdentifier() != null) {
            criteria.add(Restrictions.eq("identifier", cf.getIdentifier()));
        }
    }

    return criteria;
}

---

From source file:com.tysanclan.site.projectewok.entities.dao.hibernate.TrialDAOImpl.java

License:Open Source License

@Override
protected Criteria createCriteria(SearchFilter<Trial> filter) {
    Criteria criteria = getSession().createCriteria(Trial.class);

    if (filter instanceof TrialFilter) {
        TrialFilter cf = (TrialFilter) filter;
        if (cf.getStartAfter() != null) {
            criteria.createAlias("trialThread", "thread");
            criteria.add(Restrictions.gt("thread.postTime", cf.getStartAfter()));
        }//from  w ww.  ja v a  2 s .co  m
        if (cf.getRestrained() != null) {
            criteria.add(Restrictions.eq("restrained", cf.getRestrained()));
        }
        if (cf.getAccused() != null) {
            criteria.add(Restrictions.eq("accused", cf.getAccused()));
        }

        if (!cf.isWithTrialThread()) {
            criteria.add(Restrictions.isNull("trialThread"));
        }
    }

    return criteria;
}

---

From source file:com.tysanclan.site.projectewok.entities.dao.hibernate.TruthsayerNominationDAOImpl.java

License:Open Source License

@Override
protected Criteria createCriteria(SearchFilter<TruthsayerNomination> filter) {
    Criteria criteria = getSession().createCriteria(TruthsayerNomination.class);

    if (filter instanceof TruthsayerNominationFilter) {
        TruthsayerNominationFilter cf = (TruthsayerNominationFilter) filter;

        if (cf.getNominee() != null) {
            criteria.add(Restrictions.eq("user", cf.getNominee()));
        }//from   w w w .  j a  v  a2  s.  com
        if (cf.getStartBefore() != null) {
            criteria.add(Restrictions.lt("voteStart", cf.getStartBefore()));
        } else if (cf.isStartNotSet()) {
            criteria.add(Restrictions.isNull("voteStart"));
        } else if (cf.isStartSet()) {
            criteria.add(Restrictions.isNotNull("voteStart"));
        }
    }

    return criteria;
}

---

From source file:com.ut.tekir.invoice.PurchaseInvoiceHomeBean.java

License:LGPL

@SuppressWarnings("unchecked")
public void buildShipmentNotes() {

    log.debug("Sorgu yapcez...");

    //DetachedCriteria crit = DetachedCriteria.forClass( ShipmentNote.class );
    HibernateSessionProxy session = (HibernateSessionProxy) getEntityManager().getDelegate();
    Criteria crit = session.createCriteria(ShipmentNote.class);

    crit.add(Restrictions.eq("action", TradeAction.Purchase));
    crit.add(Restrictions.eq("contact", entity.getContact()));
    crit.add(Restrictions.isNull("invoice"));

    shipmentNotes = crit.list();//from  ww  w  . j a  v a  2  s .com

    log.debug("rsaliyeler #0", shipmentNotes);

    //Hali hazrda faturaya bal olanlar listeden kartlyorlar...
    for (ShipmentNote sn : entity.getShipments()) {
        if (shipmentNotes.contains(sn)) {
            shipmentNotes.remove(sn);
        }
    }

}

---

From source file:com.ut.tekir.invoice.SaleInvoiceHomeBean.java

License:LGPL

@SuppressWarnings("unchecked")
public void buildShipmentNotes() {

    log.debug("Sorgu yapcez...");
    log.debug("Action : #0, Contact : #1 #2", TradeAction.Sale, entity.getContact(),
            entity.getContact() != null ? entity.getContact().getId() : "null");

    // DetachedCriteria crit = DetachedCriteria.forClass( ShipmentNote.class
    // );//from w  w  w. ja v a 2  s  .  c o  m
    HibernateSessionProxy session = (HibernateSessionProxy) getEntityManager().getDelegate();
    Criteria crit = session.createCriteria(ShipmentNote.class);

    crit.add(Restrictions.eq("action", TradeAction.Sale));
    crit.add(Restrictions.eq("contact", entity.getContact()));
    crit.add(Restrictions.isNull("invoice"));

    shipmentNotes = crit.list();

    log.debug("rsaliyeler #0", shipmentNotes);

    // Hali hazrda faturaya bal olanlar listeden kartlyorlar...
    for (ShipmentNote sn : entity.getShipments()) {
        if (shipmentNotes.contains(sn)) {
            shipmentNotes.remove(sn);
        }
    }

}

---

From source file:com.ut.tekir.stock.yeni.PurchaseShipmentBrowseBean.java

License:LGPL

@Override
public DetachedCriteria buildCriteria() {

    DetachedCriteria crit = DetachedCriteria.forClass(TekirShipmentNote.class);

    crit.createAlias("contact", "contact");

    crit.setProjection(Projections.projectionList().add(Projections.property("id"), "id")
            .add(Projections.property("serial"), "serial").add(Projections.property("reference"), "reference")
            .add(Projections.property("code"), "code").add(Projections.property("date"), "date")
            .add(Projections.property("info"), "info").add(Projections.property("info1"), "info1")
            .add(Projections.property("info2"), "info2").add(Projections.property("warehouse"), "warehouse")
            .add(Projections.property("contact.fullname"), "contactName")
            .add(Projections.property("contact.company"), "company")
            .add(Projections.property("contact.person"), "person")
            .add(Projections.property("contact.code"), "contactCode")
            .add(Projections.property("workBunch"), "workBunch"))
            .setResultTransformer(Transformers.aliasToBean(ShipmentFilterModel.class));

    if (isNotEmpty(filterModel.getSerial())) {
        crit.add(Restrictions.ilike("this.serial", filterModel.getSerial(), MatchMode.START));
    }//from w  w w  .  j a v  a 2  s  . com

    if (isNotEmpty(filterModel.getReference())) {
        crit.add(Restrictions.ilike("this.reference", filterModel.getReference(), MatchMode.START));
    }

    if (isNotEmpty(filterModel.getCode())) {
        crit.add(Restrictions.ilike("this.code", filterModel.getCode(), MatchMode.START));
    }

    if (filterModel.getBeginDate() != null) {
        crit.add(Restrictions.ge("this.date", filterModel.getBeginDate()));
    }

    if (filterModel.getEndDate() != null) {
        crit.add(Restrictions.le("this.date", filterModel.getEndDate()));
    }

    if (filterModel.getWarehouse() != null) {
        crit.add(Restrictions.eq("this.warehouse", filterModel.getWarehouse()));
    }

    if (isNotEmpty(filterModel.getContactName())) {
        crit.add(Restrictions.ilike("contact.fullname", filterModel.getContactName(), MatchMode.ANYWHERE));
    }

    if (isNotEmpty(filterModel.getContactCode())) {
        crit.add(Restrictions.ilike("contact.code", filterModel.getContactCode(), MatchMode.START));
    }

    if (filterModel.getInvoiced() != null) {
        if (filterModel.getInvoiced().equals(Boolean.TRUE)) {
            crit.add(Restrictions.isNotNull("this.invoice"));
        } else {
            crit.add(Restrictions.isNull("this.invoice"));
        }
    }

    if (filterModel.getWorkBunch() != null) {
        crit.add(Restrictions.eq("this.workBunch", filterModel.getWorkBunch()));
    }

    crit.add(Restrictions.eq("this.tradeAction", TradeAction.Purchase));
    crit.addOrder(Order.desc("this.date"));
    crit.addOrder(Order.desc("this.serial"));

    return crit;
}

---

From source file:com.ut.tekir.stock.yeni.SaleShipmentBrowseBean.java

License:LGPL

@Override
public DetachedCriteria buildCriteria() {

    DetachedCriteria crit = DetachedCriteria.forClass(TekirShipmentNote.class);

    crit.createAlias("contact", "contact");

    crit.setProjection(Projections.projectionList().add(Projections.property("id"), "id")
            .add(Projections.property("serial"), "serial").add(Projections.property("reference"), "reference")
            .add(Projections.property("code"), "code").add(Projections.property("date"), "date")
            .add(Projections.property("info1"), "info1").add(Projections.property("info2"), "info2")
            .add(Projections.property("warehouse"), "warehouse")
            .add(Projections.property("contact.fullname"), "contactName")
            .add(Projections.property("contact.company"), "company")
            .add(Projections.property("contact.person"), "person")
            .add(Projections.property("contact.code"), "contactCode")
            .add(Projections.property("workBunch"), "workBunch"))
            .setResultTransformer(Transformers.aliasToBean(ShipmentFilterModel.class));

    if (isNotEmpty(filterModel.getSerial())) {
        crit.add(Restrictions.ilike("this.serial", filterModel.getSerial(), MatchMode.START));
    }//from w  w w .j av  a 2  s. co  m

    if (isNotEmpty(filterModel.getReference())) {
        crit.add(Restrictions.ilike("this.reference", filterModel.getReference(), MatchMode.START));
    }

    if (isNotEmpty(filterModel.getCode())) {
        crit.add(Restrictions.ilike("this.code", filterModel.getCode(), MatchMode.START));
    }

    if (filterModel.getBeginDate() != null) {
        crit.add(Restrictions.ge("this.date", filterModel.getBeginDate()));
    }

    if (filterModel.getEndDate() != null) {
        crit.add(Restrictions.le("this.date", filterModel.getEndDate()));
    }

    if (filterModel.getWarehouse() != null) {
        crit.add(Restrictions.eq("this.warehouse", filterModel.getWarehouse()));
    }

    if (isNotEmpty(filterModel.getContactCode())) {
        crit.add(Restrictions.ilike("contact.code", filterModel.getContactCode(), MatchMode.START));
    }

    if (isNotEmpty(filterModel.getContactName())) {
        crit.add(Restrictions.ilike("contact.fullname", filterModel.getContactName(), MatchMode.ANYWHERE));
    }

    if (filterModel.getInvoiced() != null) {
        if (filterModel.getInvoiced().equals(Boolean.TRUE)) {
            crit.add(Restrictions.isNotNull("this.invoice"));
        } else {
            crit.add(Restrictions.isNull("this.invoice"));
        }
    }

    if (filterModel.getWorkBunch() != null) {
        crit.add(Restrictions.eq("this.workBunch", filterModel.getWorkBunch()));
    }

    crit.add(Restrictions.eq("this.tradeAction", TradeAction.Sale));
    crit.addOrder(Order.desc("this.date"));
    crit.addOrder(Order.desc("this.serial"));

    return crit;
}

---

From source file:com.viettel.vsaadmin.database.DAOHibernate.DepartmentDAOHE.java

License:Open Source License

/**
 *
 * @return/*from w  w  w . ja  v a2 s  .  c om*/
 */
public List<Department> getParentDeptForTree(Boolean isCheckStatus) {
    Criterion[] criterion = new Criterion[3];
    criterion[0] = Restrictions.isNull("parentId");
    if (isCheckStatus) {
        criterion[1] = Restrictions.eq("status", 1L);
    } else {
        criterion[1] = Restrictions.isNotNull("deptId");
    }
    criterion[2] = Restrictions
            .sqlRestriction(" 1 = 1 order by nlssort(lower({alias}.DEPT_NAME),'nls_sort = Vietnamese') ");
    return this.findByCriteria(0, -1, criterion);
}

---

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