Example usage for org.hibernate.transform Transformers aliasToBean

Introduction

In this page you can find the example usage for org.hibernate.transform Transformers aliasToBean.

Prototype

public static ResultTransformer aliasToBean(Class target) 

Source Link

Document

Creates a resulttransformer that will inject aliased values into instances of Class via property methods or fields.

Usage

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

@Override
public List<LoanNewCancelationBoxViewModel> getByParam(LoanNewCancelationBoxSearchParameter parameter,
        int firstResult, int maxResults, Order orderable) {
    StringBuffer selectQuery = new StringBuffer("SELECT DISTINCT (cancellation.id) AS cancelationId, "
            + "cancellation.loan_cancellation_number AS cancelationCode, "
            + "application.nomor AS applicationCode," + "loanNewType.loan_type_name AS loanNewTypeName, "
            + "application.nominal_principal AS nominal, "
            + "cancellation.cancelation_date AS cancelationDate, "
            + "application.application_date AS applicationDate, " + "cancellation.reason AS reason, "
            + "CONCAT(bioData.first_name,' ',bioData.last_name) AS employeeName "
            + "FROM loan_new_cancelation cancellation "
            + "LEFT JOIN loan_new_application AS application ON application.id = cancellation.loan_id "
            + "LEFT JOIN loan_new_type AS loanNewType ON loanNewType.id = application.loan_new_type "
            + "LEFT JOIN log_approver_history AS approverHistory ON approverHistory.activity_number = application.approval_activity_number \n"
            + "LEFT JOIN hrm_user AS approver ON approver.id = approverHistory.approver_id "
            + "LEFT JOIN hrm_user AS user ON user.emp_data_id = application.emp_id "
            + "LEFT JOIN emp_data AS empData ON empData.id = user.emp_data_id "
            + "LEFT JOIN bio_data AS bioData ON empData.bio_data_id = bioData.id ");

    selectQuery.append(this.setWhereQueryByParam(parameter));
    selectQuery.append("ORDER BY " + orderable);

    Query hbm = getCurrentSession().createSQLQuery(selectQuery.toString()).setMaxResults(maxResults)
            .setFirstResult(firstResult)
            .setResultTransformer(Transformers.aliasToBean(LoanNewCancelationBoxViewModel.class));
    hbm = this.setValueQueryByParam(hbm, parameter);

    return hbm.list();
}

---

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

@Override
public List<LoanNewSchemaListOfEmpViewModel> getByParam(LoanNewSchemaListOfEmpSearchParameter parameter,
        int firstResult, int maxResults, Order orderable) {
    final StringBuilder query = new StringBuilder(
            "SELECT emp.id as idEmp, bio.first_name as firstName, bio.last_name as lastName, emp.nik as nik, goljab.code as code, listEmp.nomor_sk as noSk, newSchema.loan_schema_code as schemaCode FROM emp_data emp");
    //        query.append(" FROM unreg_salary A");
    query.append(" LEFT JOIN loan_new_schema_list_of_emp listEmp ON listEmp.emp_id = emp.id");
    query.append(" LEFT JOIN bio_data bio ON bio.id = emp.bio_data_id");
    query.append(" LEFT JOIN golongan_jabatan goljab ON goljab.id = emp.gol_jab_id");
    query.append(" LEFT JOIN loan_new_schema newSchema ON newSchema.id = listEmp.loan_new_schema_id");
    if (parameter.getName() != null) {
        query.append(" WHERE bio.first_name like '%" + parameter.getName() + "%'");
        query.append(" OR bio.last_name like '%" + parameter.getName() + "%'");
    } else if (parameter.getCode() != null) {
        query.append(" WHERE goljab.code like '%" + parameter.getCode() + "%'");
    } else if (parameter.getNoSk() != null) {
        query.append(" WHERE listEmp.nomor_sk like '%" + parameter.getNoSk() + "%'");
    }//from   ww w  .j av a 2  s. com
    query.append(" LIMIT " + firstResult + ", " + maxResults);
    System.out.println(" Querynya " + query.toString());
    return getCurrentSession().createSQLQuery(query.toString())
            .setResultTransformer(Transformers.aliasToBean(LoanNewSchemaListOfEmpViewModel.class)).list();
}

---

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

@Override
public List<LoanNewSchemaListOfEmpViewModel> getByParamHQL(LoanNewSchemaListOfEmpSearchParameter parameter,
        int firstResult, int maxResults, Order orderable) {
    StringBuffer selectQuery = new StringBuffer(
            "SELECT bio.firstName as firstName " + " FROM empData emp" + " LEFT JOIN emp.bioData bio");
    Query hbm = getCurrentSession().createQuery(selectQuery.toString()).setMaxResults(maxResults)
            .setFirstResult(firstResult)
            .setResultTransformer(Transformers.aliasToBean(LoanNewSchemaListOfEmpViewModel.class));

    return hbm.list();
}

---

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

@Override
public List<LoanUsageHistoryViewModel> getListLoanUsageHistoryByLoanNewSchemaWhereStatusActive(
        Long loanNewSchemaId) {/* ww w  . jav  a  2s .  co  m*/
    final StringBuilder query = new StringBuilder("SELECT loanNewType.id AS loanNewTypeId,");
    query.append(" loanNewType.loanTypeName AS loanNewTypeName,");
    query.append(" loanNewSchemaListOfType.maximumAllocation AS maximumAllocation ");
    query.append(" FROM LoanNewSchemaListOfType loanNewSchemaListOfType ");
    query.append(" INNER JOIN loanNewSchemaListOfType.loanNewSchema loanNewSchema ");
    query.append(" INNER JOIN loanNewSchemaListOfType.loanNewType loanNewType ");
    query.append(" WHERE loanNewSchema.id = :loanNewSchemaId ");

    Query hbm = getCurrentSession().createQuery(query.toString())
            .setParameter("loanNewSchemaId", loanNewSchemaId)
            .setResultTransformer(Transformers.aliasToBean(LoanUsageHistoryViewModel.class));

    return hbm.list();
}

---

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

@Override
public List<TempAttendanceRealizationViewModel> getListTempAttendanceRealizationViewModelByWtPeriodId(
        WtAttendanceCalculationSearchParameter searchParameter, Long wtPeriodId, int firstResult,
        int maxResults, Order orderable) {
    final StringBuilder query = new StringBuilder("SELECT logAttendanceRealization.id as id,");
    query.append(" logAttendanceRealization.wtPeriodeId AS wtPeriodId,");
    query.append(" logAttendanceRealization.wtGroupWorkingId AS wtGroupWorkingId,");
    query.append(" logAttendanceRealization.wtGroupWorkingName AS wtGroupWorkingName,");
    query.append(" logAttendanceRealization.empDataId AS empId,");
    query.append(" logAttendanceRealization.empNik AS nik,");
    query.append(" logAttendanceRealization.empName AS empName,");
    query.append(" logAttendanceRealization.attendanceDaysSchedule AS attendanceDaysSchedule,");
    query.append(" logAttendanceRealization.attendanceDaysPresent AS attendanceDaysPresent,");
    query.append(" logAttendanceRealization.leaves AS leaves,");
    query.append(" logAttendanceRealization.overtime AS overTime,");
    query.append(" logAttendanceRealization.permit AS permit,");
    query.append(" logAttendanceRealization.sick AS sick,");
    query.append(" logAttendanceRealization.duty AS duty");
    query.append(" FROM LogWtAttendanceRealization logAttendanceRealization");
    query.append(" WHERE logAttendanceRealization.wtPeriodeId = :wtPeriodId ");

    //filter by search param
    query.append(doSearchLogWtAttendanceCalculationByParam(searchParameter));
    query.append("ORDER BY " + orderable);

    Query hbm = getCurrentSession().createQuery(query.toString()).setParameter("wtPeriodId", wtPeriodId);
    hbm = this.setValueQueryLogWtAttendanceCalculationByParam(hbm, searchParameter);

    return hbm.setMaxResults(maxResults).setFirstResult(firstResult)
            .setResultTransformer(Transformers.aliasToBean(TempAttendanceRealizationViewModel.class)).list();
}

---

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

@Override
public List<PayReceiverBankAccountModel> getByParam(PayReceiverBankAccountSearchParameter searchParameter,
        int firstResult, int maxResults, Order order) {
    StringBuilder hqlQuery = new StringBuilder(
            "Select ep.id as empId,bi.firstName as firstName, bi.lastName as lastName, ep.joinDate as joinDate, ep.nik as nik, go.code as golJab, count(ba.id) as totalAccount  FROM EmpData ep  ");
    hqlQuery.append("JOIN ep.bioData bi ");
    hqlQuery.append("JOIN ep.golonganJabatan go ");
    hqlQuery.append("JOIN bi.bioBankAccounts ba ");
    hqlQuery.append("WHERE ep.status != :empCondistion ");
    if (searchParameter.getEmpName() != null) {
        hqlQuery.append("AND (bi.firstName like :firstName OR bi.lastName like :lastName) ");
    }/*from w  ww  .  j  av  a  2  s  .c o m*/

    if (searchParameter.getGolJab() != null) {
        hqlQuery.append("AND go.code like :code ");
    }

    if (searchParameter.getNik() != null) {
        hqlQuery.append("AND ep.nik like :nik ");
    }

    hqlQuery.append("GROUP BY ep.id ");
    //        hqlQuery.append("ORDER BY ep.nik");
    hqlQuery.append("ORDER BY " + order);

    if (searchParameter.getEmpName() != null) {
        return getCurrentSession().createQuery(hqlQuery.toString())
                .setParameter("empCondistion", HRMConstant.EMP_TERMINATION)
                .setParameter("firstName", '%' + searchParameter.getEmpName() + '%')
                .setParameter("lastName", '%' + searchParameter.getEmpName() + '%').setFirstResult(firstResult)
                .setMaxResults(maxResults)
                .setResultTransformer(Transformers.aliasToBean(PayReceiverBankAccountModel.class)).list();
    }
    if (searchParameter.getGolJab() != null) {
        return getCurrentSession().createQuery(hqlQuery.toString())
                .setParameter("empCondistion", HRMConstant.EMP_TERMINATION)
                .setParameter("code", '%' + searchParameter.getGolJab() + '%').setFirstResult(firstResult)
                .setMaxResults(maxResults)
                .setResultTransformer(Transformers.aliasToBean(PayReceiverBankAccountModel.class)).list();
    }
    if (searchParameter.getNik() != null) {
        return getCurrentSession().createQuery(hqlQuery.toString())
                .setParameter("empCondistion", HRMConstant.EMP_TERMINATION)
                .setParameter("nik", searchParameter.getNik()).setFirstResult(firstResult)
                .setMaxResults(maxResults)
                .setResultTransformer(Transformers.aliasToBean(PayReceiverBankAccountModel.class)).list();
    }

    if (searchParameter.getEmpName() == null || searchParameter.getGolJab() == null
            || searchParameter.getNik() == null) {
        return getCurrentSession().createQuery(hqlQuery.toString())
                .setParameter("empCondistion", HRMConstant.EMP_TERMINATION)
                .setResultTransformer(Transformers.aliasToBean(PayReceiverBankAccountModel.class))
                .setFirstResult(firstResult).setMaxResults(maxResults).list();
    }
    return null;
}

---

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

@Override
public List<PayComponentDataExceptionModelView> getAllDataByParamDataException(
        PayComponentDataExceptionSearchParameter searchParameter, int firstResult, int maxResults,
        Order order) {/*from  ww  w .  ja  v  a 2 s.  c om*/
    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 {
        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) {/* w  w w . j  av  a  2s . c  o m*/
    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");
    }
    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(// www  . ja v  a2s .  co  m
                " 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.PayTempKalkulasiDaoImpl.java

@Override
public List<SalaryJournalModel> getByParamForSalaryJournalDebet(String searchParameter) {
    final StringBuilder query = new StringBuilder("SELECT d.code as costCenterCodeDebet ,");
    query.append("d.name AS costCenterNameDebet ,");
    query.append("SUM(a.nominal) as jumlahDebet");
    query.append(" FROM pay_temp_kalkulasi a");
    query.append(" INNER JOIN pay_salary_component f ON f.id = a.pay_salary_component_id");
    query.append(" INNER JOIN pay_salary_jurnal n ON n.id =  f.paysalary_jurnal_id");
    query.append(" INNER JOIN emp_data b ON a.emp_data_id = b.id");
    query.append(" INNER JOIN jabatan x ON x.id = b.jabatan_id");
    query.append(" INNER JOIN department c ON c.id = x.departement_id");
    query.append(" INNER JOIN cost_center d ON d.id = c.cost_center_id");
    query.append(" where n.type_jurnal=0");
    if (searchParameter != null) {
        query.append(" AND d.name like '%" + searchParameter + "%'");
        query.append(" OR d.code like '%" + searchParameter + "%'");
    }//from  w w w. jav a2 s . c  o m
    query.append(" GROUP BY d.id ORDER BY d.code");
    return getCurrentSession().createSQLQuery(query.toString())
            .setResultTransformer(Transformers.aliasToBean(SalaryJournalModel.class)).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
• »