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.iluwatar.cqrs.queries.QueryServiceImpl.java

License:Open Source License

@Override
public Book getBook(String title) {
    Book bookDTo = null;/*from  www  .ja va2s.  com*/
    try (Session session = sessionFactory.openSession()) {
        SQLQuery sqlQuery = session.createSQLQuery(
                "SELECT b.title as \"title\", b.price as \"price\"" + " FROM Book b where b.title=:title");
        sqlQuery.setParameter("title", title);
        bookDTo = (Book) sqlQuery.setResultTransformer(Transformers.aliasToBean(Book.class)).uniqueResult();
    }
    return bookDTo;
}

---

From source file:com.iluwatar.cqrs.queries.QueryServiceImpl.java

License:Open Source License

@Override
public List<Book> getAuthorBooks(String username) {
    List<Book> bookDTos = null;
    try (Session session = sessionFactory.openSession()) {
        SQLQuery sqlQuery = session.createSQLQuery("SELECT b.title as \"title\", b.price as \"price\""
                + " FROM Author a , Book b where b.author_id = a.id and a.username=:username");
        sqlQuery.setParameter("username", username);
        bookDTos = sqlQuery.setResultTransformer(Transformers.aliasToBean(Book.class)).list();
    }//from ww  w.j av a 2s .  co  m
    return bookDTos;
}

---

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

@Override
public List<EmpDataMatrixModel> getAllAgeFromBirthDate() {
    final StringBuilder query = new StringBuilder(
            "SELECT DISTINCT DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(date_of_birth)), '%Y')+0 AS ages2");
    query.append(" FROM bio_data GROUP BY ages2 ORDER BY ages2 ASC");
    return getCurrentSession().createSQLQuery(query.toString())
            .setResultTransformer(Transformers.aliasToBean(EmpDataMatrixModel.class)).list();
}

---

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

@Override
public List<EmpDataMatrixModel> getTotalByAgeAndGenderMaleFromBirthDate() {
    final StringBuilder query = new StringBuilder("SELECT COUNT(*) AS banyakDatas,");
    query.append(//w ww  .j a  va 2 s .  c  o  m
            " DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(date_of_birth)), '%Y')+0 AS ages2 FROM bio_data WHERE gender = 1");
    query.append(" GROUP BY ages2 ORDER BY ages2 ASC");
    return getCurrentSession().createSQLQuery(query.toString())
            .setResultTransformer(Transformers.aliasToBean(EmpDataMatrixModel.class)).list();
}

---

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

@Override
public List<EmpDataMatrixModel> getTotalByAgeAndGenderFemaleFromBirthDate() {
    final StringBuilder query = new StringBuilder("SELECT COUNT(*) AS banyakDatas,");
    query.append(//from w  w w.j  av a 2 s.c o m
            " DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(date_of_birth)), '%Y')+0 AS ages2 FROM bio_data WHERE gender = 0");
    query.append(" GROUP BY ages2 ORDER BY ages2 ASC");
    return getCurrentSession().createSQLQuery(query.toString())
            .setResultTransformer(Transformers.aliasToBean(EmpDataMatrixModel.class)).list();
}

---

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

@Override
public List<EmpDataMatrixModel> getAllAgeByGenderFromBirthDate() {
    final StringBuilder query = new StringBuilder("SELECT COUNT(*) AS banyakDatas, gender AS genders,");
    query.append(// w  w w  .  j  a va2  s .c o m
            " DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(date_of_birth)), '%Y')+0 AS ages2 FROM bio_data");
    query.append(" GROUP BY ages2,genders ORDER BY ages2 ASC");
    return getCurrentSession().createSQLQuery(query.toString())
            .setResultTransformer(Transformers.aliasToBean(EmpDataMatrixModel.class)).list();
}

---

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

@Override
public List<CareerTransitionInboxViewModel> getEntityEmpCareerHistoryInboxByParam(
        CareerTransitionInboxSearchParameter searchParameter, int firstResult, int maxResults, Order order) {
    StringBuffer selectQuery = new StringBuffer("SELECT approvalActivity.id AS approvalActivityId, "
            + "empData.nik AS empNik," + "CONCAT(bioData.first_name,' ',bioData.last_name) AS empName, "
            + "approvalActivity.approval_status AS approvalStatus, "
            + "approvalActivity.pending_data AS jsonData, " + "approvalActivity.request_time AS requestTime, "
            + "approvalActivity.activity_number AS activityNumber " + "FROM approval_activity approvalActivity "
            + "LEFT JOIN approval_definition AS approvalDefinition ON approvalDefinition.id = approvalActivity.approval_def_id "
            + "LEFT JOIN hrm_user AS approver ON approver.user_id = approvalActivity.approved_by "
            + "LEFT JOIN hrm_user AS requester ON requester.user_id = approvalActivity.request_by "
            + "LEFT JOIN emp_data AS empData ON requester.emp_data_id = empData.id "
            + "INNER JOIN jabatan AS jabatan ON empData.jabatan_id = jabatan.id  "
            + "INNER JOIN department AS department ON jabatan.departement_id = department.id  "
            + "INNER JOIN company AS company ON department.company_id = company.id  "
            + "LEFT JOIN bio_data AS bioData ON empData.bio_data_id = bioData.id "
            + "WHERE (approvalActivity.activity_number,approvalActivity.sequence) IN (SELECT app.activity_number,max(app.sequence) FROM approval_activity app GROUP BY app.activity_number) "
            + "AND approvalDefinition.name = :appDefinitionName ");
    selectQuery.append(this.setWhereQueryCareerTransitionInboxActivityByParam(searchParameter));
    selectQuery.append("GROUP BY approvalActivity.activity_number ");
    selectQuery.append("ORDER BY " + order);

    Query hbm = getCurrentSession().createSQLQuery(selectQuery.toString()).setMaxResults(maxResults)
            .setFirstResult(firstResult)
            .setResultTransformer(Transformers.aliasToBean(CareerTransitionInboxViewModel.class));
    hbm = this.setValueQueryCareerTransitionInboxActivityByParam(hbm, searchParameter);

    return hbm.list();
}

---

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

@Override
public List<EmpEliminationViewModel> getListEmpEliminationViewModelByParam(
        EmpEliminationSearchParameter searchParameter, int firstResult, int maxResults, Order order) {

    final StringBuilder query = new StringBuilder("SELECT empCareerHistory.id AS empCareerHistoryId,");
    query.append(" bioData.id AS bioDataId,");
    query.append(" careerTransition.id AS careerTransitionId,");
    query.append(" jabatan.id AS lastJabatanId,");
    query.append(" empCareerHistory.nik as nik,");
    query.append(" jabatan.name AS jabatanName,");
    query.append(" empCareerHistory.status AS empCareerHistoryStatus,");
    query.append(" empCareerHistory.tglPenganngkatan AS terminationDate");
    query.append(" FROM EmpCareerHistory empCareerHistory");
    query.append(" INNER JOIN empCareerHistory.bioData bioData");
    query.append(" INNER JOIN empCareerHistory.careerTransition careerTransition");
    query.append(" INNER JOIN empCareerHistory.jabatan jabatan");
    query.append(" INNER JOIN careerTransition.systemCareerConst systemCareerConst");
    query.append(" WHERE systemCareerConst.isWork = 0 ");

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

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

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

---

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

@Override
public BioDataModel getEmpNameWithNearestBirthDate() {
    final StringBuilder query = new StringBuilder(
            "SELECT bioData.first_name AS firstName, bioData.last_name AS lastName, bioData.date_of_birth AS dateOfBirth,");
    query.append(/*from w w  w  . j a  va2  s.  c o m*/
            "DATE_ADD(bioData.date_of_birth, INTERVAL IF (DAYOFYEAR(bioData.date_of_birth) >= DAYOFYEAR(CURDATE()), YEAR(CURDATE())-YEAR(bioData.date_of_birth), YEAR(CURDATE())-YEAR(bioData.date_of_birth)+1) YEAR) AS nextBirthday ");
    query.append("FROM emp_data empData ");
    query.append("INNER JOIN bio_data bioData ON bioData.id = empData.bio_data_id ");
    query.append("INNER JOIN jabatan jabatan ON jabatan.id = empData.jabatan_id ");
    query.append("INNER JOIN department department ON department.id = jabatan.departement_id ");
    query.append("INNER JOIN company company ON company.id = department.company_id ");
    query.append("WHERE company.id = " + HrmUserInfoUtil.getCompanyId() + " ");
    query.append("AND empData.status != '" + HRMConstant.EMP_TERMINATION + "' ");
    query.append("AND bioData.date_of_birth  IS NOT NULL HAVING nextBirthday ");
    query.append("BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 30 DAY) ORDER BY nextBirthDay LIMIT 1");

    return (BioDataModel) getCurrentSession().createSQLQuery(query.toString())
            .setResultTransformer(Transformers.aliasToBean(BioDataModel.class)).uniqueResult();
}

---

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  www  .  ja v  a 2 s . co 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();
    }
}

---

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