Example usage for org.hibernate.criterion CriteriaSpecification LEFT_JOIN

Introduction

In this page you can find the example usage for org.hibernate.criterion CriteriaSpecification LEFT_JOIN.

Prototype

int LEFT_JOIN

To view the source code for org.hibernate.criterion CriteriaSpecification LEFT_JOIN.

Click Source Link

Document

Specifies joining to an entity based on a left outer join.

Usage

From source file:com.sapienter.jbilling.server.metafields.db.MetaFieldDAS.java

License:Open Source License

public MetaField getFieldByNameTypeAndGroup(Integer entityId, EntityType[] entityType, String name,
        Integer groupId) {//from  w ww .  j  a v  a  2 s  .  c  om
    DetachedCriteria query = DetachedCriteria.forClass(MetaField.class);
    query.add(Restrictions.eq("entityId", entityId));
    query.add(Restrictions.in("entityType", entityType));
    query.add(Restrictions.eq("name", name));
    query.createAlias("metaFieldGroups", "groups", CriteriaSpecification.LEFT_JOIN);
    query.add(Restrictions.eq("groups.id", groupId));
    query.add(Restrictions.eq("groups.entityType", EntityType.ACCOUNT_TYPE));
    query.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);

    List<MetaField> fields = (List<MetaField>) getHibernateTemplate().findByCriteria(query);
    return !fields.isEmpty() ? fields.get(0) : null;
}

---

From source file:com.sapienter.jbilling.server.metafields.db.MetaFieldDAS.java

License:Open Source License

public MetaField getFieldByNameAndGroup(Integer entityId, String name, Integer groupId) {
    DetachedCriteria query = DetachedCriteria.forClass(MetaField.class);
    query.add(Restrictions.eq("entityId", entityId));
    query.add(Restrictions.eq("name", name));
    query.createAlias("metaFieldGroups", "groups", CriteriaSpecification.LEFT_JOIN);
    query.add(Restrictions.eq("groups.id", groupId));
    query.add(Restrictions.eq("groups.entityType", EntityType.ACCOUNT_TYPE));
    query.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);

    List<MetaField> fields = (List<MetaField>) getHibernateTemplate().findByCriteria(query);
    return !fields.isEmpty() ? fields.get(0) : null;
}

---

From source file:com.square.core.dao.implementations.ActionDaoImplementation.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override// w w  w .ja  va  2s . co m
public List<Action> rechercherActionsSources(CritereActionSyntheseDto critereActionSyntheseDto) {
    final Criteria criteria = createCriteria(Action.class);

    // Critere de la personne
    criteria.createAlias("actionAffectation", "actionAffectationAlias");
    criteria.add(
            Restrictions.eq("actionAffectationAlias.personne.id", critereActionSyntheseDto.getIdPersonne()));
    // Critere action source : l'action source doit etre null ou rattache  une autre personne
    // (pb des actions sur personnes morales dont la source est une action sur personne physique)
    criteria.createAlias("actionSource", "actionSourceAlias", CriteriaSpecification.LEFT_JOIN);
    criteria.createAlias("actionSourceAlias.actionAffectation", "actionSourceAffectationAlias",
            CriteriaSpecification.LEFT_JOIN);
    final Junction disjunction = Restrictions.disjunction();
    disjunction.add(Restrictions.isNull("actionSource"));
    disjunction.add(Restrictions.not(Restrictions.eqProperty("actionSourceAffectationAlias.personne.id",
            "actionAffectationAlias.personne.id")));
    criteria.add(disjunction);
    // Critere sur les opportunits
    if (critereActionSyntheseDto.getIdOpportunite() != null) {
        criteria.add(Restrictions.eq("actionAffectationAlias.opportunite.id",
                critereActionSyntheseDto.getIdOpportunite()));
    }
    // Critre sur la date d'effet
    if (critereActionSyntheseDto.getFiltrerDateCreation() != null
            && critereActionSyntheseDto.getFiltrerDateCreation()) {
        criteria.add(Restrictions.le("dateCreation", Calendar.getInstance()));
    }
    criteria.add(Restrictions.eq("supprime", false));
    // Ordre
    criteria.addOrder(Order.desc(CHAMP_DATE));

    return criteria.list();
}

---

From source file:com.ut.tekir.finance.CollectionBrowseBean.java

License:LGPL

@Override
public DetachedCriteria buildCriteria() {

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

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

    ProjectionList pl = Projections.projectionList();
    pl.add(Projections.property("this.id"), "id").add(Projections.property("this.serial"), "serial")
            .add(Projections.property("this.reference"), "reference")
            .add(Projections.property("this.code"), "code").add(Projections.property("this.date"), "date")
            .add(Projections.property("this.info"), "info")
            .add(Projections.property("contact.code"), "contactCode")
            .add(Projections.property("contact.fullname"), "contactName")
            .add(Projections.property("contact.company"), "company")
            .add(Projections.property("contact.person"), "person")
            .add(Projections.property("account.code"), "accountCode")
            .add(Projections.property("this.totalAmount.currency"), "totalAmountCurrency")
            .add(Projections.property("this.totalAmount.value"), "totalAmountValue");

    if (filterModel.getWorkBunch() != null) {
        crit.createAlias("this.items", "it", CriteriaSpecification.LEFT_JOIN);
        pl.add(Projections.property("it.workBunch"), "workBunch");
        pl.add(Projections.property("it.amount.value"), "itemAmountValue");
        crit.add(Restrictions.eq("it.workBunch", filterModel.getWorkBunch()));
    }/*from  www. j  a v  a 2 s . co  m*/

    crit.setProjection(pl).setResultTransformer(Transformers.aliasToBean(PaymentFilterModel.class));

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

    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 (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.START));
    }

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

    crit.add(Restrictions.eq("this.action", FinanceAction.Credit));
    crit.addOrder(Order.desc("this.date"));
    crit.addOrder(Order.desc("this.serial"));

    return crit;
}

---

From source file:com.ut.tekir.finance.DebitCreditNoteCollectionBrowseBean.java

License:LGPL

@Override
public DetachedCriteria buildCriteria() {

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

    if (filterModel.getWorkBunch() != null) {
        crit.createAlias("this.items", "it", CriteriaSpecification.LEFT_JOIN);
        crit.add(Restrictions.eq("it.workBunch", filterModel.getWorkBunch()));
    }/*from   w  ww.j  av a2s. c o  m*/

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

    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()));
    }

    crit.add(Restrictions.eq("this.action", FinanceAction.Credit));

    crit.addOrder(Order.desc("this.serial"));
    crit.addOrder(Order.desc("this.date"));
    return crit;
}

---

From source file:com.ut.tekir.finance.DebitCreditNotePaymentBrowseBean.java

License:LGPL

@Override
public DetachedCriteria buildCriteria() {

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

    if (filterModel.getWorkBunch() != null) {
        crit.createAlias("this.items", "it", CriteriaSpecification.LEFT_JOIN);
        crit.add(Restrictions.eq("it.workBunch", filterModel.getWorkBunch()));
    }// ww w  . j a va2  s .c  o m

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

    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()));
    }

    crit.add(Restrictions.eq("this.action", FinanceAction.Debit));
    crit.addOrder(Order.desc("this.date"));
    crit.addOrder(Order.desc("this.serial"));

    return crit;
}

---

From source file:com.ut.tekir.finance.PaymentBrowseBean.java

License:LGPL

@Override
public DetachedCriteria buildCriteria() {
    DetachedCriteria crit = DetachedCriteria.forClass(Payment.class);

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

    ProjectionList pl = Projections.projectionList();
    pl.add(Projections.property("this.id"), "id").add(Projections.property("this.serial"), "serial")
            .add(Projections.property("this.reference"), "reference")
            .add(Projections.property("this.code"), "code").add(Projections.property("this.date"), "date")
            .add(Projections.property("this.info"), "info")
            .add(Projections.property("contact.code"), "contactCode")
            .add(Projections.property("contact.name"), "contactName")
            .add(Projections.property("contact.company"), "company")
            .add(Projections.property("contact.person"), "person")
            .add(Projections.property("account.code"), "accountCode")
            .add(Projections.property("this.totalAmount.currency"), "totalAmountCurrency")
            .add(Projections.property("this.totalAmount.value"), "totalAmountValue");

    if (filterModel.getWorkBunch() != null) {
        crit.createAlias("this.items", "it", CriteriaSpecification.LEFT_JOIN);
        pl.add(Projections.property("it.workBunch"), "workBunch");
        pl.add(Projections.property("it.amount.value"), "itemAmountValue");
        crit.add(Restrictions.eq("it.workBunch", filterModel.getWorkBunch()));
    }//from ww w .j a  va2  s  . c  om

    crit.setProjection(pl).setResultTransformer(Transformers.aliasToBean(PaymentFilterModel.class));

    /*
            crit.setProjection(Projections.projectionList()
    .add(Projections.property("this.id"), "id")
    .add(Projections.property("this.serial"), "serial")
    .add(Projections.property("this.reference"), "reference")
    .add(Projections.property("this.code"), "code")
    .add(Projections.property("this.date"), "date")
    .add(Projections.property("this.info"), "info")
    .add(Projections.property("contact.code"), "contactCode")
    .add(Projections.property("contact.name"), "contactName")
    .add(Projections.property("contact.company"), "company")
    .add(Projections.property("contact.person"),"person")
    .add(Projections.property("account.code"), "accountCode")
    .add(Projections.property("this.totalAmount.currency"), "totalAmountCurrency")
    .add(Projections.property("this.totalAmount.value"), "totalAmountValue")
          )
          .setResultTransformer(Transformers.aliasToBean(PaymentFilterModel.class));
    */
    if (isNotEmpty(filterModel.getSerial())) {
        crit.add(Restrictions.ilike("this.serial", filterModel.getSerial(), MatchMode.START));
    }

    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 (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.START));
    }

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

    crit.add(Restrictions.eq("this.action", FinanceAction.Debit));
    crit.addOrder(Order.desc("this.date"));
    crit.addOrder(Order.desc("serial"));

    return crit;
}

---

From source file:com.ut.tekir.tender.TenderBrowseBean.java

License:LGPL

@Override
@SuppressWarnings("unchecked")
public void search() {
    log.debug("Search Execute");

    HibernateSessionProxy session = (HibernateSessionProxy) getEntityManager().getDelegate();

    Criteria ecrit = buildCriteria().getExecutableCriteria(session);

    ecrit.setMaxResults(100);//from   ww  w  .  ja  va2  s.  c  o m

    ecrit.createAlias("contact", "contact", CriteriaSpecification.LEFT_JOIN);

    setEntityList(ecrit.list());
}

---

From source file:Dao.DaoEgreso.java

@Override
public List<Producto> getAll(Session session) throws Exception {
    Criteria criteria = session.createCriteria(Producto.class)
            .createAlias("grupo", "g", CriteriaSpecification.LEFT_JOIN)
            .createAlias("marca", "m", CriteriaSpecification.LEFT_JOIN)
            .createAlias("tipodescarga", "t", CriteriaSpecification.LEFT_JOIN)
            .setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    //        criteria.add(Restrictions.eq("proEstado", "AC"));
    return criteria.list();
}

---

From source file:Dao.DaoEgreso.java

@Override
public List<Producto> getActives(Session session) throws Exception {
    Criteria criteria = session.createCriteria(Producto.class)
            .createAlias("grupo", "g", CriteriaSpecification.LEFT_JOIN)
            .createAlias("marca", "m", CriteriaSpecification.LEFT_JOIN)
            .createAlias("tipodescarga", "t", CriteriaSpecification.LEFT_JOIN)
            .setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    criteria.add(Restrictions.eq("proEstado", "AC"));
    return criteria.list();
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• »