Example usage for org.hibernate.criterion DetachedCriteria forClass

List of usage examples for org.hibernate.criterion DetachedCriteria forClass

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. DetachedCriteria
  6. forClass

Introduction

In this page you can find the example usage for org.hibernate.criterion DetachedCriteria forClass.

Prototype

public static DetachedCriteria forClass(Class clazz)

Source Link

Document

Static builder to create a DetachedCriteria for the given entity, by its Class.

Usage

From source file:com.ut.tekir.documents.DocumentBrowseBean.java

License:LGPL

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

    if (filterModel.getFirstDate() != null) {

        crit.add(Restrictions.ge("updateDate", filterModel.getFirstDate()));
    }/*from w  w  w.  j a v  a2 s  . c om*/

    if (filterModel.getSecondDate() != null) {

        crit.add(Restrictions.le("updateDate", filterModel.getSecondDate()));
    }

    if (filterModel.getName() != null && filterModel.getName().length() > 0) {
        crit.add(Restrictions.like("name", filterModel.getName() + "%"));
    }

    if (filterModel.getStatus() != DocumentFilterModel.Status.All) {

        if (filterModel.getStatus() == DocumentFilterModel.Status.Active) {
            crit.add(Restrictions.eq("active", true));
        } else {
            crit.add(Restrictions.eq("active", false));
        }
    }

    if (filterModel.getDocType() == DocumentFilterModel.DocType.Genel) {
        crit.add(Restrictions.eq("docType", DocumentFilterModel.DocType.Genel));
    }

    if (filterModel.getDocType() == DocumentFilterModel.DocType.Genelge) {
        crit.add(Restrictions.eq("docType", DocumentFilterModel.DocType.Genelge));
    }

    if (filterModel.getDocType() == DocumentFilterModel.DocType.Haber) {
        crit.add(Restrictions.eq("docType", DocumentFilterModel.DocType.Haber));
    }

    if (filterModel.getDocType() == DocumentFilterModel.DocType.Sozlesme) {
        crit.add(Restrictions.eq("docType", DocumentFilterModel.DocType.Sozlesme));
    }

    if (filterModel.getDocType() == DocumentFilterModel.DocType.Teblig) {
        crit.add(Restrictions.eq("docType", DocumentFilterModel.DocType.Teblig));
    }

    if (filterModel.getDocType() == DocumentFilterModel.DocType.Basvuru) {
        crit.add(Restrictions.eq("docType", DocumentFilterModel.DocType.Basvuru));
    } else if (filterModel.getDocType() != DocumentFilterModel.DocType.Hepsi) {
        crit.add(Restrictions.ne("docType", DocumentFilterModel.DocType.Basvuru));
    }

    crit.addOrder(Order.desc("updateDate"));

    return crit;
}

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

License:LGPL

@Override
public DetachedCriteria buildCriteria() {

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

    if (isNotEmpty(filterModel.getSerial())) {
        crit.add(Restrictions.ilike("this.serial", filterModel.getSerial(), MatchMode.START));
    }/*ww w  .  ja va  2  s  . c o 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.getAccount() != null) {
        crit.add(Restrictions.le("this.account", filterModel.getAccount()));
    }

    crit.addOrder(Order.desc("serial"));
    crit.addOrder(Order.desc("date"));

    return crit;
}

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

License:LGPL

@Override
public DetachedCriteria buildCriteria() {

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

    if (isNotEmpty(filterModel.getSerial())) {
        crit.add(Restrictions.ilike("serial", filterModel.getSerial(), MatchMode.START));
    }//w w  w. j  a  v  a2 s .c o  m

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

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

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

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

    if (filterModel.getAccount() != null) {
        crit.add(Restrictions.eq("account", filterModel.getAccount()));
    }

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

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

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

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

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

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

License:LGPL

@Override
public DetachedCriteria buildCriteria() {

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

    if (isNotEmpty(filterModel.getSerial())) {
        crit.add(Restrictions.ilike("serial", filterModel.getSerial(), MatchMode.START));
    }/*w w  w  .  j av  a  2 s .c om*/

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

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

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

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

    if (filterModel.getAccount() != null) {
        crit.add(Restrictions.eq("account", filterModel.getAccount()));
    }

    if (filterModel.getBank() != null) {
        crit.add(Restrictions.eq("bank", filterModel.getBank()));
    }

    if (filterModel.getBankBranch() != null) {
        crit.add(Restrictions.eq("bankBranch", filterModel.getBankBranch()));
    }

    if (filterModel.getBankAccount() != null) {
        crit.add(Restrictions.eq("bankAccount", filterModel.getBankAccount()));
    }

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

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

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

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

License:LGPL

@Override
public DetachedCriteria buildCriteria() {

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

    if (isNotEmpty(filterModel.getSerial())) {
        crit.add(Restrictions.ilike("serial", filterModel.getSerial(), MatchMode.START));
    }//from   w  w  w  .ja  v  a  2  s.  c  o m

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

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

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

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

    if (filterModel.getFromBank() != null) {
        crit.add(Restrictions.eq("fromBank", filterModel.getFromBank()));
    }

    if (filterModel.getToBank() != null) {
        crit.add(Restrictions.eq("toBank", filterModel.getToBank()));
    }

    if (filterModel.getFromBankBranch() != null) {
        crit.add(Restrictions.eq("fromBankBranch", filterModel.getFromBankBranch()));
    }

    if (filterModel.getToBankBranch() != null) {
        crit.add(Restrictions.eq("toBankBranch", filterModel.getToBankBranch()));
    }

    if (filterModel.getFromBankAccount() != null) {
        crit.add(Restrictions.eq("fromBankAccount", filterModel.getFromBankAccount()));
    }

    if (filterModel.getToBankAccount() != null) {
        crit.add(Restrictions.eq("toBankAccount", filterModel.getToBankAccount()));
    }

    if (filterModel.getTransferType() != BankTransferType.Unknown) {
        crit.add(Restrictions.eq("transferType", filterModel.getTransferType()));
    }

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

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

    return crit;
}

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

License:LGPL

@Override
public DetachedCriteria buildCriteria() {

    DetachedCriteria crit = DetachedCriteria.forClass(BankToContactTransfer.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("bankAccount"), "bankAccount")
            .add(Projections.property("bankBranch"), "bankBranch").add(Projections.property("bank"), "bank")
            .add(Projections.property("contact.name"), "contactName")
            .add(Projections.property("contact.company"), "company")
            .add(Projections.property("contact.person"), "person")
            .add(Projections.property("contact.code"), "contactCode").add(Projections.property("date"), "date")
            .add(Projections.property("info"), "info")
            .add(Projections.property("this.amount.value"), "amountValue")
            .add(Projections.property("this.amount.currency"), "amountCurrency")
            .add(Projections.property("this.cost.value"), "costValue")
            .add(Projections.property("this.cost.currency"), "costCurrency"))
            .setResultTransformer(Transformers.aliasToBean(BankToContactTransferFilterModel.class));

    if (filterModel.getWorkBunch() != null) {
        crit.add(Restrictions.eq("this.workBunch", filterModel.getWorkBunch()));
    }//from   w  w w . j a  v a  2 s .com

    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.name", filterModel.getContactName(), MatchMode.START));
    }

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

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

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

    if (filterModel.getTransferType() != BankTransferType.Unknown) {
        crit.add(Restrictions.eq("this.transferType", filterModel.getTransferType()));
    }

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

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

    return crit;
}

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

License:LGPL

@Override
public DetachedCriteria buildCriteria() {

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

    if (isNotEmpty(filterModel.getReferenceNo())) {
        crit.add(Restrictions.ilike("referenceNo", filterModel.getReferenceNo(), MatchMode.ANYWHERE));
    }/*w  w  w. j av  a 2  s  .  c o  m*/

    if (isNotEmpty(filterModel.getBankName())) {
        crit.add(Restrictions.ilike("bankName", filterModel.getBankName(), MatchMode.START));
    }

    if (isNotEmpty(filterModel.getBankBranch())) {
        crit.add(Restrictions.ilike("bankBranch", filterModel.getBankBranch(), MatchMode.START));
    }

    if (isNotEmpty(filterModel.getBankAccountName())) {
        crit.add(Restrictions.ilike("accountNo", filterModel.getBankAccountName(), MatchMode.START));
    }

    if (filterModel.getContact() != null) {
        crit.add(Restrictions.eq("contact", filterModel.getContact()));
    }

    if (isNotEmpty(filterModel.getChequeOwner())) {
        crit.add(Restrictions.ilike("chequeOwner", filterModel.getChequeOwner(), MatchMode.START));
    }

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

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

    if (filterModel.getIssueBeginDate() != null) {
        crit.add(Restrictions.ge("issueDate", filterModel.getIssueBeginDate()));
    }

    if (filterModel.getIssueEndDate() != null) {
        crit.add(Restrictions.le("issueDate", filterModel.getIssueEndDate()));
    }

    if (filterModel.getLastStatus() != null) {
        crit.add(Restrictions.eq("lastStatus", filterModel.getLastStatus()));
    }

    if (filterModel.getPreviousStatus() != null) {
        crit.add(Restrictions.eq("previousStatus", filterModel.getPreviousStatus()));
    }

    if (getIsClientCheque() != null) {
        crit.add(Restrictions.eq("clientCheque", getIsClientCheque()));
    }

    crit.addOrder(Order.desc("maturityDate"));
    crit.addOrder(Order.desc("serialNo"));
    crit.addOrder(Order.desc("referenceNo"));

    return crit;
}

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

License:LGPL

@Override
public DetachedCriteria buildCriteria() {

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

    crit.createAlias("this.history", "history");

    if (isNotEmpty(filterModel.getReferenceNo())) {
        crit.add(Restrictions.eq("referenceNo", filterModel.getReferenceNo()));
    }// w w w . j  a v  a 2  s. co  m

    if (isNotEmpty(filterModel.getBankName())) {
        crit.add(Restrictions.like("bankName", filterModel.getBankName() + "%"));
    }

    if (isNotEmpty(filterModel.getBankBranch())) {
        crit.add(Restrictions.like("bankBranch", filterModel.getBankBranch() + "%"));
    }

    if (filterModel.getContact() != null) {
        crit.add(Restrictions.eq("contact", filterModel.getContact()));
    }

    if (isNotEmpty(filterModel.getChequeOwner())) {
        crit.add(Restrictions.like("chequeOwner", filterModel.getChequeOwner() + "%"));
    }

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

    if (filterModel.getLastStatus() != null) {
        crit.add(Restrictions.eq("lastStatus", filterModel.getLastStatus()));
        crit.add(Restrictions.ne("previousStatus", filterModel.getLastStatus()));
    }

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

    if (getIsClientCheque() != null) {
        crit.add(Restrictions.eq("clientCheque", getIsClientCheque()));
    }

    crit.add(Restrictions.eqProperty("history.status", "this.lastStatus"));

    return crit;
}

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

License:LGPL

@Override
public DetachedCriteria buildCriteria() {

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

    /**/*from ww w  .  j av a2 s.  c om*/
     *
     * TODO: contact iin outer join gerektiinden kapatld
     *
     *
            crit.createAlias("this.history", "history");
            crit.createAlias("contact", "contact");
                    
            crit.setProjection(Projections.projectionList()
        .add(Projections.groupProperty("this.id"), "id")
        .add(Projections.groupProperty("this.maturityDate"), "maturityDate")
        .add(Projections.groupProperty("this.referenceNo"), "referenceNo")
        .add(Projections.groupProperty("this.bankName"), "bankName")
        .add(Projections.groupProperty("this.bankBranch"), "bankBranch")
        .add(Projections.groupProperty("this.accountNo"), "accountNo")
        .add(Projections.groupProperty("this.chequeOwner"), "chequeOwner")
        .add(Projections.groupProperty("contact.id"), "contactId")
        .add(Projections.groupProperty("contact.name"), "contactName")
        .add(Projections.groupProperty("contact.code"), "contactCode")
        .add(Projections.groupProperty("this.lastStatus"), "lastStatus")
        .add(Projections.groupProperty("this.previousStatus"), "previousStatus")
        .add(Projections.groupProperty("this.info"), "info")
        .add(Projections.groupProperty("money.currency"), "moneyCurrency")
        .add(Projections.groupProperty("money.value"), "moneyValue")
        .add(Projections.groupProperty("this.serialNo"), "serialNo"));
                       
    crit.setResultTransformer(Transformers.aliasToBean(ChequeSumModelContact.class));
    */

    if (isNotEmpty(filterModel.getReferenceNo())) {
        //cheque number
        crit.add(Restrictions.ilike("this.referenceNo", filterModel.getReferenceNo() + "%"));
    }

    if (isNotEmpty(filterModel.getBankName())) {
        crit.add(Restrictions.ilike("this.bankName", filterModel.getBankName() + "%"));
    }

    if (isNotEmpty(filterModel.getBankBranch())) {
        crit.add(Restrictions.ilike("this.bankBranch", filterModel.getBankBranch() + "%"));
    }

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

    if (isNotEmpty(filterModel.getChequeOwner())) {
        crit.add(Restrictions.ilike("this.chequeOwner", filterModel.getChequeOwner() + "%"));
    }

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

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

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

    if (getIsClientCheque() != null) {
        crit.add(Restrictions.eq("this.clientCheque", getIsClientCheque()));
    }

    return crit;
}

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

License:LGPL

@Override
public DetachedCriteria buildCriteria() {

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

    crit.createAlias("this.bank", "bank");
    crit.createAlias("this.bankBranch", "bankBranch");
    crit.createAlias("this.bankAccount", "bankAccount");

    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("bank.name"), "bankName")
            .add(Projections.property("bankBranch.name"), "bankBranchName")
            .add(Projections.property("bankAccount.name"), "bankAccountName"))
            .setResultTransformer(Transformers.aliasToBean(ChequeCollectionAtBankPayrollFilterModel.class));

    if (isNotEmpty(filterModel.getSerial())) {
        crit.add(Restrictions.ilike("this.serial", filterModel.getSerial(), MatchMode.START));
    }//ww w  .j a  v a2s .c om

    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.getBank() != null) {
        crit.add(Restrictions.eq("this.bank", filterModel.getBank()));
    }
    if (filterModel.getBankBranch() != null) {
        crit.add(Restrictions.eq("this.bankBranch", filterModel.getBankBranch()));
    }
    if (filterModel.getBankAccount() != null) {
        crit.add(Restrictions.eq("this.bankAccount", filterModel.getBankAccount()));
    }

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

    return crit;
}