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.PayTempKalkulasiDaoImpl.java

@Override
public List<SalaryJournalModel> getByParamForSalaryJournalKredit(String searchParameter) {
    final StringBuilder query = new StringBuilder("SELECT d.code as costCenterCodeKredit ,");
    query.append("d.name AS costCenterNameKredit ,");
    query.append("SUM(a.nominal) as jumlahKredit");
    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=1");
    if (searchParameter != null) {
        query.append(" AND d.name like '%" + searchParameter + "%'");
        query.append(" OR d.code like '%" + searchParameter + "%'");
    }//from  w  w w .j  a v  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();
}

---

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

@Override
public List<PayTempKalkulasiEmpPajakModel> getByParam() {
    final StringBuilder query = new StringBuilder(
            "select B.id as taxId, B.name as taxName, sum(A.nominal) as nominal from PayTempKalkulasiEmpPajak A");
    query.append(" inner join A.taxComponent B");
    query.append(" group by B.name");
    query.append(" order by B.id");
    return getCurrentSession().createQuery(query.toString())
            .setResultTransformer(Transformers.aliasToBean(PayTempKalkulasiEmpPajakModel.class)).list();

}

---

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

@Override
public List<RecruitmentScheduleSettingViewModel> getByParamForRecruitmentScheduleSetting(
        RecruitmentScheduleSettingSearchParameter searchParameter, int firstResult, int maxResults,
        Order orderable) {/*from  w w  w .  ja v a  2 s . c  o  m*/
    final StringBuilder query = new StringBuilder("SELECT  recruitHireApply.id AS id,");
    query.append(" jabatan.id AS jabatanId,");
    query.append(" jabatan.name AS jabatanName,");
    query.append(" recruitMppPeriod.id AS mppPeriodId,");
    query.append(" COUNT(recruitSelectionApplicantInitial.id) AS totalApplicant,");
    query.append(" recruitHireApply.candidateCountRequest AS candidateCountRequest,");
    query.append(" recruitMppPeriod.periodeStart AS startMppPeriodDate,");
    query.append(" recruitMppPeriod.periodeEnd as endMppPeriodDate");
    query.append(" FROM RecruitSelectionApplicantInitial recruitSelectionApplicantInitial");
    query.append(" INNER JOIN recruitSelectionApplicantInitial.recruitApplicant recruitApplicant");
    query.append(" INNER JOIN recruitSelectionApplicantInitial.recruitHireApply recruitHireApply");
    query.append(" INNER JOIN recruitHireApply.jabatan jabatan");
    query.append(" INNER JOIN recruitHireApply.recruitMppPeriod recruitMppPeriod");
    query.append(this.setWhereQueryRecruitmentScheduleSettingByParam(searchParameter));
    query.append(" GROUP BY recruitHireApply.id ");
    query.append(" ORDER BY " + orderable);

    Query hbm = getCurrentSession().createQuery(query.toString());
    hbm = this.setValueQueryRecruitmentScheduleSettingByParam(hbm, searchParameter);

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

}

---

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

@Override
public List<TempAttendanceRealizationViewModel> getListTempAttendanceRealizationViewModelByWtPeriodId(
        WtAttendanceCalculationSearchParameter searchParameter, Long wtPeriodId, int firstResult,
        int maxResults, Order orderable) {

    final StringBuilder query = new StringBuilder("SELECT tempAttendanceRealization.id as id,");
    query.append(" wtPeriod.id AS wtPeriodId,");
    query.append(" wtGroupWorking.id AS wtGroupWorkingId,");
    query.append(" wtGroupWorking.name AS wtGroupWorkingName,");
    query.append(" empData.id AS empId,");
    query.append(" empData.nik AS nik,");
    query.append(" CONCAT(bioData.firstName, ' ', bioData.lastName)  AS empName,");
    query.append(" tempAttendanceRealization.attendanceDaysSchedule AS attendanceDaysSchedule,");
    query.append(" tempAttendanceRealization.attendanceDaysPresent AS attendanceDaysPresent,");
    query.append(" tempAttendanceRealization.leave AS leaves,");
    query.append(" tempAttendanceRealization.overtime AS overTime,");
    query.append(" tempAttendanceRealization.permit AS permit,");
    query.append(" tempAttendanceRealization.sick AS sick,");
    query.append(" tempAttendanceRealization.duty AS duty,");
    query.append(" wtPeriod.absen AS absenStatus");
    query.append(" FROM TempAttendanceRealization tempAttendanceRealization");
    query.append(" INNER JOIN tempAttendanceRealization.empData empData");
    query.append(" INNER JOIN empData.bioData bioData");
    query.append(" INNER JOIN tempAttendanceRealization.wtGroupWorking wtGroupWorking");
    query.append(" INNER JOIN tempAttendanceRealization.wtPeriod wtPeriod");
    query.append(" WHERE wtPeriod.id = :wtPeriodId ");

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

    Query hbm = getCurrentSession().createQuery(query.toString()).setParameter("wtPeriodId", wtPeriodId);
    hbm = this.setValueQueryWtAttendanceCalculationByParam(hbm, searchParameter);
    return hbm.setMaxResults(maxResults).setFirstResult(firstResult)
            .setResultTransformer(Transformers.aliasToBean(TempAttendanceRealizationViewModel.class)).list();

}

---

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

@Override
public List<TempAttendanceRealizationMonthEndViewModel> getAllDataMonthEndByPeriodId(Long wtPeriodId) {
    StringBuffer selectQuery = new StringBuffer("SELECT department.id as departmentId, "
            + "department.departmentName as departmentName, " + "SUM(1) AS totalEmployee, "
            + "SUM(tempAttendanceRealization.attendanceDaysPresent) AS attendanceDaysPresent, "
            + "SUM(tempAttendanceRealization.attendanceDaysSchedule) AS attendanceDaysSchedule, "
            + "SUM(tempAttendanceRealization.overtime) AS overtime "
            + "FROM TempAttendanceRealization tempAttendanceRealization "
            + "LEFT JOIN tempAttendanceRealization.empData AS empData "
            + "LEFT JOIN empData.jabatanByJabatanId AS jabatan " + "LEFT JOIN jabatan.department AS department "
            + "WHERE tempAttendanceRealization.wtPeriod.id = :wtPeriodId ");
    selectQuery.append("GROUP BY department ");
    selectQuery.append("ORDER BY departmentName DESC ");

    Query hbm = getCurrentSession().createQuery(selectQuery.toString())
            .setResultTransformer(Transformers.aliasToBean(TempAttendanceRealizationMonthEndViewModel.class));
    hbm.setParameter("wtPeriodId", wtPeriodId);

    return hbm.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 {//from  w  w  w. j a  v a 2s  .  com
        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:com.inkubator.hrm.dao.impl.WtPeriodeDaoImpl.java

@Override
public List<WtPeriodEmpViewModel> getListWtPeriodEmpByParam(WtPeriodeEmpSearchParameter searchParameter,
        int firstResult, int maxResults, Order order) {
    final StringBuilder fromQuery = new StringBuilder();
    fromQuery.append("select wtPeriode.id AS wtPeriodId, ");
    fromQuery.append("wtPeriode.from_periode AS fromPeriode,");
    fromQuery.append("wtPeriode.until_periode AS untilPeriode,");
    fromQuery.append(/* w  w w.j av a  2  s  . c om*/
            "SUM(CASE WHEN tempAttendanceRealization.id IS NOT NULL THEN 1 ELSE 0 END) AS totalEmpDataFromTemporary, ");
    fromQuery.append(
            "SUM(CASE WHEN logWtAttendanceRealization.id IS NOT NULL THEN 1 ELSE 0 END) AS totalEmpDataFromLogMonthEnd, ");
    fromQuery.append(
            "COUNT(DISTINCT (tempAttendanceRealization.wt_group_working_id)) AS totalWorkingGroupFromTemporary, ");
    fromQuery.append(
            "COUNT(DISTINCT (logWtAttendanceRealization.wt_group_working_id)) AS totalWorkingGroupFromLogMonthEnd, ");
    fromQuery.append("wtPeriode.absen as status ");
    fromQuery.append("FROM wt_periode wtPeriode ");
    fromQuery.append(
            "LEFT JOIN log_wt_attendance_realization logWtAttendanceRealization ON logWtAttendanceRealization.wt_periode_id=wtPeriode.id ");
    fromQuery.append(
            "LEFT JOIN temp_attendance_realization tempAttendanceRealization ON tempAttendanceRealization.wt_period_id=wtPeriode.id ");
    //filter by search param
    fromQuery.append(doSearchWtPeriodEmpByParam(searchParameter));
    fromQuery.append("GROUP BY  wtPeriode.id ");

    final StringBuilder query = new StringBuilder();
    query.append("select wtPeriodId, ");
    query.append("fromPeriode, ");
    query.append("untilPeriode, ");
    query.append("status, ");
    query.append(
            "CASE WHEN totalEmpDataFromLogMonthEnd > 0 THEN totalEmpDataFromLogMonthEnd ELSE totalEmpDataFromTemporary END AS totalEmpData, ");
    query.append(
            "CASE WHEN totalWorkingGroupFromLogMonthEnd > 0 THEN totalWorkingGroupFromLogMonthEnd ELSE totalWorkingGroupFromTemporary END AS totalWorkingGroup ");
    query.append("FROM (" + fromQuery.toString() + ") AS xx ");
    query.append("ORDER BY  " + order);

    Query hbm = getCurrentSession().createSQLQuery(query.toString()).setFirstResult(firstResult)
            .setMaxResults(maxResults);
    hbm = this.setValueQueryWtPeriodEmpByParam(hbm, searchParameter);

    return hbm.setResultTransformer(Transformers.aliasToBean(WtPeriodEmpViewModel.class)).list();
}

---

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

@Override
public WtPeriodEmpViewModel getWtPeriodEmpByWtPeriodId(Long wtPeriodId) {
    final StringBuilder fromQuery = new StringBuilder();
    fromQuery.append("select wtPeriode.id AS wtPeriodId, ");
    fromQuery.append("wtPeriode.from_periode AS fromPeriode,");
    fromQuery.append("wtPeriode.until_periode AS untilPeriode,");
    fromQuery.append(//from w ww . j a va2s. co  m
            "SUM(CASE WHEN tempAttendanceRealization.id IS NOT NULL THEN 1 ELSE 0 END) AS totalEmpDataFromTemporary, ");
    fromQuery.append(
            "SUM(CASE WHEN logWtAttendanceRealization.id IS NOT NULL THEN 1 ELSE 0 END) AS totalEmpDataFromLogMonthEnd, ");
    fromQuery.append(
            "COUNT(DISTINCT (tempAttendanceRealization.wt_group_working_id)) AS totalWorkingGroupFromTemporary, ");
    fromQuery.append(
            "COUNT(DISTINCT (logWtAttendanceRealization.wt_group_working_id)) AS totalWorkingGroupFromLogMonthEnd, ");
    fromQuery.append("wtPeriode.absen as status ");
    fromQuery.append("FROM wt_periode wtPeriode ");
    fromQuery.append(
            "LEFT JOIN log_wt_attendance_realization logWtAttendanceRealization ON logWtAttendanceRealization.wt_periode_id=wtPeriode.id ");
    fromQuery.append(
            "LEFT JOIN temp_attendance_realization tempAttendanceRealization ON tempAttendanceRealization.wt_period_id=wtPeriode.id ");
    fromQuery.append("WHERE wtPeriode.id = " + wtPeriodId + " ");
    fromQuery.append("GROUP BY  wtPeriode.id ");

    final StringBuilder query = new StringBuilder();
    query.append("select wtPeriodId, ");
    query.append("fromPeriode, ");
    query.append("untilPeriode, ");
    query.append("status, ");
    query.append(
            "CASE WHEN totalEmpDataFromLogMonthEnd > 0 THEN totalEmpDataFromLogMonthEnd ELSE totalEmpDataFromTemporary END AS totalEmpData, ");
    query.append(
            "CASE WHEN totalWorkingGroupFromLogMonthEnd > 0 THEN totalWorkingGroupFromLogMonthEnd ELSE totalWorkingGroupFromTemporary END AS totalWorkingGroup ");
    query.append("FROM (" + fromQuery.toString() + ") AS xx ");

    Query hbm = getCurrentSession().createSQLQuery(query.toString())
            .setResultTransformer(Transformers.aliasToBean(WtPeriodEmpViewModel.class));
    return (WtPeriodEmpViewModel) hbm.uniqueResult();
}

---

From source file:com.itrus.ca.common.persistence.BaseDaoImpl.java

License:Open Source License

/**
 * //from   ww  w . j a v a  2 s.  c o m
 * 
 * @param query
 * @param resultClass
 */
private void setResultTransformer(SQLQuery query, Class<?> resultClass) {
    if (resultClass != null) {
        if (resultClass == Map.class) {
            query.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);
        } else if (resultClass == List.class) {
            query.setResultTransformer(Transformers.TO_LIST);
        } else {
            query.setResultTransformer(Transformers.aliasToBean(resultClass));
            // query.addEntity(resultClass);
        }
    }
}

---

From source file:com.jscompany.ebsystem.entitymanager.TransactionManager.java

@Override
public <T> List<T> getSqlQueryParametros(Class<T> clase, String query, String[] params, Object[] values) {
    List<T> result = null;/*from w  w w  . ja  va 2 s.  co  m*/
    try {
        sess = HiberUtil.getSession();
        q = sess.createSQLQuery(query);
        for (int i = 0; i < params.length; i++) {
            q.setParameter(params[i], values[i]);
        }
        result = q.setResultTransformer(Transformers.aliasToBean(clase)).list();
        Hibernate.initialize(result);
    } catch (Exception e) {
        Logger.getLogger(TransactionManager.class.getName()).log(Level.SEVERE, null, e);
    }
    return result;
}

---

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