Example usage for org.hibernate.criterion Order toString

Introduction

In this page you can find the example usage for org.hibernate.criterion Order toString.

Prototype

@Override
    public String toString() 

Source Link

Usage

From source file:com.inkubator.hrm.dao.impl.EmpDataDaoImpl.java

@Override
public List<ReportEmployeeEducationViewModel> getAllDataByDepartementAndEducationWithHql(
        List<Long> departementId, List<Long> educationId, int firstResult, int maxResults, Order order) {
    final StringBuilder query = new StringBuilder("select department.departmentName as department,");
    query.append(" emp.id as id,");
    query.append(" emp.nik as nik,");
    query.append(" bio.firstName as firstName,");
    query.append(" bio.lastName as lastName,");
    query.append(" jabatanByJabatanId.name as jabatan,");
    query.append(" educationLevel.code as graduated,");
    query.append(" institutionEducation.institutionEducationName as from,");
    query.append(" eduHistory.yearOut as graduatedYear");
    query.append(" FROM EmpData emp");
    query.append(" INNER JOIN emp.bioData bio");
    query.append(" INNER JOIN bio.educationHistories eduHistory");
    query.append(" INNER JOIN eduHistory.educationLevel educationLevel");
    query.append(" INNER JOIN eduHistory.institutionEducation institutionEducation");
    query.append(" INNER JOIN emp.jabatanByJabatanId jabatanByJabatanId");
    query.append(" INNER JOIN jabatanByJabatanId.department department");
    query.append(" INNER JOIN department.company company");
    if (departementId.isEmpty() != Boolean.TRUE && educationId.isEmpty() != Boolean.TRUE) {
        query.append(" WHERE department.id IN :idDept AND educationLevel.id IN :idEdu");
        query.append(" AND company.id = " + HrmUserInfoUtil.getCompanyId());
    } else if (departementId.isEmpty() != Boolean.TRUE && educationId.isEmpty() == Boolean.TRUE) {
        query.append(" WHERE department.id IN :idDept");
        query.append(" AND company.id = " + HrmUserInfoUtil.getCompanyId());
    } else if (departementId.isEmpty() == Boolean.TRUE && educationId.isEmpty() != Boolean.TRUE) {
        query.append(" WHERE educationLevel.id IN :idEdu");
        query.append(" AND company.id = " + HrmUserInfoUtil.getCompanyId());
    } else {//from   w ww  .j  ava 2  s  . c o m
        query.append(" WHERE company.id = " + HrmUserInfoUtil.getCompanyId());
    }
    if (order.toString().contains("firstName") || order.toString().contains("department")
            || order.toString().contains("jabatan") || order.toString().contains("graduated")
            || order.toString().contains("graduatedYear")) {
        query.append(" order by " + order);
    } else {
        query.append(" order by bio.firstName");
    }
    if (departementId.isEmpty() != Boolean.TRUE && educationId.isEmpty() != Boolean.TRUE) {
        return getCurrentSession().createQuery(query.toString()).setParameterList("idDept", departementId)
                .setParameterList("idEdu", educationId).setMaxResults(maxResults).setFirstResult(firstResult)
                .setResultTransformer(Transformers.aliasToBean(ReportEmployeeEducationViewModel.class)).list();
    } else if (departementId.isEmpty() != Boolean.TRUE && educationId.isEmpty() == Boolean.TRUE) {
        return getCurrentSession().createQuery(query.toString()).setParameterList("idDept", departementId)
                .setMaxResults(maxResults).setFirstResult(firstResult)
                .setResultTransformer(Transformers.aliasToBean(ReportEmployeeEducationViewModel.class)).list();
    } else if (departementId.isEmpty() == Boolean.TRUE && educationId.isEmpty() != Boolean.TRUE) {
        return getCurrentSession().createQuery(query.toString()).setParameterList("idEdu", educationId)
                .setMaxResults(maxResults).setFirstResult(firstResult)
                .setResultTransformer(Transformers.aliasToBean(ReportEmployeeEducationViewModel.class)).list();
    } else {
        return getCurrentSession().createQuery(query.toString()).setMaxResults(maxResults)
                .setFirstResult(firstResult)
                .setResultTransformer(Transformers.aliasToBean(ReportEmployeeEducationViewModel.class)).list();
    }
}

---

From source file:com.inkubator.hrm.dao.impl.PaySalaryComponentDaoImpl.java

@Override
public List<PayComponentDataExceptionModelView> getAllDataByParamDataException(
        PayComponentDataExceptionSearchParameter searchParameter, int firstResult, int maxResults,
        Order order) {
    final StringBuilder query = new StringBuilder(
            "SELECT B.id AS paySalaryComponentId, B.name AS name, B.code AS code, count(A.emp_id) AS jumlahKaryawan, sum(A.nominal) AS jumlahNominal");
    query.append(" FROM pay_salary_component B");
    query.append(" JOIN model_component C ON B.model_component_id = C.id");
    query.append(" LEFT JOIN pay_component_data_exception A ON A.pay_component_id = B.id");
    if (searchParameter.getCode() != null) {
        query.append(" WHERE B.code like '%" + searchParameter.getCode() + "%'");
        query.append(" AND C.has_exception = 1");
    } else if (searchParameter.getName() != null) {
        query.append(" WHERE B.name like '%" + searchParameter.getName() + "%'");
        query.append(" AND C.has_exception = 1");
    } else {/*from www .j a va2  s. c  om*/
        query.append(" WHERE C.has_exception = 1");
    }

    query.append(" GROUP BY B.name");
    if (order.toString().contains("code") || order.toString().contains("name")
            || order.toString().contains("jumlahKaryawan") || order.toString().contains("jumlahNominal")) {
        query.append(" order by " + order);
    } else {
        query.append(" order by B." + order);
    }

    query.append(" LIMIT " + firstResult + ", " + maxResults);

    return getCurrentSession().createSQLQuery(query.toString())
            .setResultTransformer(Transformers.aliasToBean(PayComponentDataExceptionModelView.class)).list();

}

---

From source file:com.inkubator.hrm.dao.impl.PayTempKalkulasiDaoImpl.java

@Override
public List<PayTempKalkulasiModel> getByParam(String searchParameter, int firstResult, int maxResults,
        Order order) {
    final StringBuilder query = new StringBuilder(
            "select B.id as paySalaryComponentId, A.id as id, B.code as code, B.name as name, count(A.empData) as jumlahKaryawan, sum(A.nominal) as nominal from PayTempKalkulasi A");
    query.append(" inner join A.paySalaryComponent B");
    if (searchParameter != null) {
        query.append(" WHERE name like :name");
    }/*from  w w  w.jav  a  2 s . com*/
    query.append(" group by B.name");
    if (order.toString().contains("jumlahKaryawan") || order.toString().contains("nominal")) {
        query.append(" order by " + order);
    } else {
        query.append(" order by B." + order);
    }
    if (searchParameter != null) {
        return getCurrentSession().createQuery(query.toString())
                .setParameter("name", '%' + searchParameter + '%').setMaxResults(maxResults)
                .setFirstResult(firstResult)
                .setResultTransformer(Transformers.aliasToBean(PayTempKalkulasiModel.class)).list();
    } else {
        return getCurrentSession().createQuery(query.toString()).setMaxResults(maxResults)
                .setFirstResult(firstResult)
                .setResultTransformer(Transformers.aliasToBean(PayTempKalkulasiModel.class)).list();
    }
}

---

From source file:com.inkubator.hrm.dao.impl.PayTempKalkulasiDaoImpl.java

@Override
public List<SalaryJournalModel> getByParamForSalaryJournal(String searchParameter, int firstResult,
        int maxResults, Order order) {

    BigDecimal zero = new BigDecimal(0.0);
    final StringBuilder query = new StringBuilder("select D.code as costCenterCode,");
    query.append("D.name AS costCenterName,");
    query.append("D.id AS costCenterId,");
    query.append("N.code AS jurnalCode,");
    query.append("N.name AS jurnalName,");
    query.append("N.id AS jurnalId,");
    //        query.append("case when N.typeJurnal=0 then sum(A.nominal) else 0 end AS debet,");
    //        query.append("case when N.typeJurnal=0 then 0 else sum(A.nominal) end AS kredit");
    query.append("sum(case when N.typeJurnal=0 then A.nominal else 0 end) AS debet2,");
    query.append("sum(case when N.typeJurnal=0 then 0.0 else A.nominal end) AS kredit");
    query.append(" FROM PayTempKalkulasi A");
    query.append(" INNER JOIN A.paySalaryComponent F");
    query.append(" INNER JOIN F.paySalaryJurnal N");
    query.append(" INNER JOIN A.empData B");
    query.append(" INNER JOIN B.jabatanByJabatanId X ");
    query.append(" INNER JOIN B.bioData bio ");
    query.append(" INNER JOIN X.department C");
    query.append(" INNER JOIN C.costCenterDept D ");
    if (searchParameter != null) {
        query.append(//from ww w.j  a va2s  .  com
                " WHERE D.name like :name OR N.name like :name OR N.code like :name OR D.code like :name ");
    }
    query.append(" GROUP BY D.id, F.paySalaryJurnal");
    if (order.toString().contains("costCenterCode") || order.toString().contains("costCenterName")
            || order.toString().contains("jurnalName") || order.toString().contains("debet2")
            || order.toString().contains("kredit")) {
        query.append(" order by " + order);
    } else {
        query.append(" order by B." + order);
    }

    if (searchParameter != null) {
        return getCurrentSession().createQuery(query.toString())
                .setParameter("name", '%' + searchParameter + '%').setMaxResults(maxResults)
                .setFirstResult(firstResult)
                .setResultTransformer(Transformers.aliasToBean(SalaryJournalModel.class)).list();
    } else {
        return getCurrentSession().createQuery(query.toString()).setMaxResults(maxResults)
                .setFirstResult(firstResult)
                .setResultTransformer(Transformers.aliasToBean(SalaryJournalModel.class)).list();
    }
}

---

From source file:com.inkubator.hrm.dao.impl.UnregSalaryDaoImpl.java

@Override
public List<UnregSalaryViewModel> getByParamWithViewModel(UnregSalarySearchParameter searchParameter,
        int firstResult, int maxResults, Order order) {

    final StringBuilder query = new StringBuilder(
            "SELECT A.id AS unregSalaryId, A.code AS code, A.name AS name, A.salary_date AS salaryDate, C.bulan AS bulan, C.tahun AS year, count(B.unreg_id) AS total");
    query.append(" FROM unreg_salary A");
    query.append(" LEFT JOIN unreg_pay_components B ON A.id = B.unreg_id");
    query.append(" INNER JOIN wt_periode C WHERE A.based_period_id = C.id");
    doSearchByParam(searchParameter, query);
    query.append(" GROUP BY A.code");
    if (order.toString().contains("code") || order.toString().contains("name")
            || order.toString().contains("total") || order.toString().contains("salaryDate")) {
        query.append(" order by " + order);
    } else {/*  ww w. j  av a2s . c  o m*/
        query.append(" order by A." + order);
    }
    query.append(" LIMIT " + firstResult + ", " + maxResults);

    return getCurrentSession().createSQLQuery(query.toString())
            .setResultTransformer(Transformers.aliasToBean(UnregSalaryViewModel.class)).list();
}

---

From source file:edu.monash.merc.common.sql.SqlCondition.java

License:Open Source License

public static void main(String[] args) {
    OrderCondition orderCon = SqlCondition.orderCon().add(OrderBy.asc("simon")).add(OrderBy.desc("age"));
    OrderBy[] orders = orderCon.orderBy();
    for (OrderBy orderBy : orders) {
        Order o = orderBy.getOrder();
        System.out.println(" order: " + o.toString());
    }/*from  w w  w .  j  a  va  2  s  .  c  o m*/
}

---

From source file:pe.com.bbva.pic.dominio.Busqueda.java

License:Open Source License

public String toString() {
    StringBuilder texto = new StringBuilder(this.comentario + "\n");
    texto.append("Busqueda = { " + criteria.toString() + " } ");
    for (Order o : orders) {
        texto.append(" [" + o.toString() + "]");
    }/*from  w  ww .j  a v a  2  s. c  om*/
    return texto.toString().replace("pe.com.bbva.pic.dominio.", "#");
}

---