Example usage for org.hibernate.transform Transformers aliasToBean

List of usage examples for org.hibernate.transform Transformers aliasToBean

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.transform.*
  5. Transformers
  6. 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.penggajian.service.master.MasterServiceImplementasi.java

@Override
public JasperPrint getLaporanPenggajianPegawaiBulanan(Date date) {
    //InputStream is = null;
    //JasperDesign jasdes ;
    try {//  ww  w.  ja  v a  2 s.  co m
        List<LaporanGajiBulanan> list = sessionFactory.getCurrentSession()
                .createQuery("select s.mp.nama as nama, " + "s.mp.statusSipil as sipil,\n"
                        + "s.mp.statusKepegawaian as kepeg,\n" + "s.mp.golongan as gol,\n"
                        + "s.mp.subGolongan as subGol,\n" + "s.gapok as gapok,\n"
                        + " s.tunjanganKeluarga AS tunjanganKeluarga,\n"
                        + " s.tunjanganJabatan AS tunjanganJabatan,\n"
                        + " s.tunjanganFungsional AS tunjanganFungsional,\n"
                        + " s.tunjanganPangan AS tunjanganPangan,\n" + " s.tunjanganHonor AS tunjanganHonor,\n"
                        + " s.jumlahTunjangan AS jumlahTunjangan,\n"
                        + " s.penghasilanBruto AS penghasilanBruto,\n"
                        + " s.penguranganSiswa AS penguranganSiswa,\n"
                        + " s.penguranganJabatan AS penguranganJabatan,\n"
                        + " s.jumlahPengurangan AS jumlahPengurangan,\n"
                        + " s.penghasilanNeto AS penghasilanNeto,\n" + " s.PTKP AS PTKP,\n" + " s.PKP AS PKP,\n"
                        + " s.PPhPsl21 AS PPhPsl21,\n" + " s.jumlahPotongan AS jumlahPotongan,\n"
                        + " s.terima AS terima FROM TransaksiPenggajianPegawai s \n" +
                        //" masterpegawai masterpegawai INNER JOIN transaksipenggajianpegawai transaksipenggajianpegawai ON masterpegawai.id = transaksipenggajianpegawai.id\n" +
                        "where day(s.bulan) = day(:date)\n")
                .setParameter("date", date)
                .setResultTransformer(Transformers.aliasToBean(LaporanGajiBulanan.class)).list();
        //String is = "/report/LapGajiBulanan.jasper";
        //String is = "src/main/java/com/penggajian/report/LapGajiBulanan.jasper";
        //InputStream is = this.getClass().getClass().getResourceAsStream("/report/LapGajiBulanan.jasper");
        Map<String, Object> parameters = new HashMap<>();
        parameters.put("date", date);
        parameters.put(JRParameter.REPORT_LOCALE, new Locale("in", "ID"));
        //return JasperFillManager.fillReport(is, parameters, new JRBeanCollectionDataSource(list));*/
        //String reportSource = "report/LapGajiBulanan.jrxml";
        //It will look for this file on your location so you need to copy your file on /report/ this location
        JasperReport jasperReport = (JasperReport) JRLoader
                .loadObject(new File("./report/LapGajiBulanan.jasper"));
        //File reportSource = new File("/report/LapGajiBulanan.jrxml");
        //jasdes = JRXmlLoader.load(reportSource);
        //is = getClass().getResourceAsStream(jasdes);
        //is = ClassLoader.getSystemResourceAsStream("LapGajiBulanan.jrxml");
        //JasperReport jasperReport = (JasperReport)JasperCompileManager.compileReport(jasdes);
        //JasperReport jasperReport = (JasperReport)JRLoader.loadObject(is);
        //JasperViewer.viewReport(JasperFillManager.fillReport(jasperReport, parameters, new JRBeanCollectionDataSource(list)), false);
        return JasperFillManager.fillReport(jasperReport, parameters, new JRBeanCollectionDataSource(list));
    } catch (JRException e) {
        //log("error generate DailySalesReport", e);
        //System.out.println("EROR : "+e);
        Logger.getLogger(this.getClass().getName()).log(Level.SEVERE, null, e);
        JOptionPane.showMessageDialog(null, e);
    }
    return null;
}

From source file:com.penggajian.service.master.MasterServiceImplementasi.java

@Override
public JasperPrint getLaporanRincianHonorBulanan(Date date) {
    //InputStream is = null;
    //JasperDesign jasdes ;
    try {/*  ww w  .j a v a2  s .  com*/
        List<LaporanRincianHonor> list = sessionFactory.getCurrentSession()
                .createQuery("select s.tpp.mp.nama as nama, " + "s.tpp.mp.statusSipil as kepeg,\n"
                        + "s.pokokHonor as pokokHonor,\n" + "s.tunjanganKepalaBidang as tunjanganKaBid,\n"
                        + "s.tunjanganStaf as tunjanganStaf,\n" + "s.tunjanganSatpam as tunjanganSatpam,\n"
                        + "s.tunjanganPegawaiKebersihan as tunjanganPegKebersihan,\n"
                        + "s.tunjanganTransport as tunjanganTransport,\n"
                        + "s.jumlahHonor as jumlahHonor FROM DetailPerincianHonor s \n"
                        + "where day(s.tpp.bulan) = day(:date)\n")
                .setParameter("date", date)
                .setResultTransformer(Transformers.aliasToBean(LaporanRincianHonor.class)).list();
        //String is = "/report/LapGajiBulanan.jasper";
        //String is = "src/main/java/com/penggajian/report/LapGajiBulanan.jasper";
        //InputStream is = this.getClass().getClass().getResourceAsStream("/report/LapGajiBulanan.jasper");
        Map<String, Object> parameters = new HashMap<>();
        parameters.put("date", date);
        parameters.put(JRParameter.REPORT_LOCALE, new Locale("in", "ID"));
        //return JasperFillManager.fillReport(is, parameters, new JRBeanCollectionDataSource(list));*/
        //String reportSource = "report/LapGajiBulanan.jrxml";
        //It will look for this file on your location so you need to copy your file on /report/ this location
        JasperReport jasperReport = (JasperReport) JRLoader
                .loadObject(new File("./report/LapRincianHonor.jasper"));
        //File reportSource = new File("/report/LapGajiBulanan.jrxml");
        //jasdes = JRXmlLoader.load(reportSource);
        //is = getClass().getResourceAsStream(jasdes);
        //is = ClassLoader.getSystemResourceAsStream("LapGajiBulanan.jrxml");
        //JasperReport jasperReport = (JasperReport)JasperCompileManager.compileReport(jasdes);
        //JasperReport jasperReport = (JasperReport)JRLoader.loadObject(is);
        //JasperViewer.viewReport(JasperFillManager.fillReport(jasperReport, parameters, new JRBeanCollectionDataSource(list)), false);
        return JasperFillManager.fillReport(jasperReport, parameters, new JRBeanCollectionDataSource(list));
    } catch (JRException e) {
        //log("error generate DailySalesReport", e);
        //System.out.println("EROR : "+e);
        Logger.getLogger(this.getClass().getName()).log(Level.SEVERE, null, e);
        JOptionPane.showMessageDialog(null, e);
    }
    return null;
}

From source file:com.proper.uip.common.core.dao.HibernateDao.java

License:Apache License

@SuppressWarnings("unchecked")
public <K> Page<K> findPage(PageConfig pageConfig, SqlEso eso, Class<K> clazz) {
    Page<K> page = new Page<K>(pageConfig);
    Query q = createQuery(eso.getSql(), eso.getParam());
    long totalCount = countHqlResult(eso.getSql(), eso.getParam());
    page.setTotal(totalCount);/*w  w  w .  j a  v a 2s  . co  m*/
    setPageParameterToQuery(q, page);
    q.setResultTransformer(Transformers.aliasToBean(clazz));
    List result = q.list();
    page.setRows(result);
    return page;
}

From source file:com.proper.uip.common.core.dao.SimpleHibernateDao.java

License:Apache License

/**
 * HQL.//w w  w . j a  va 2 s. c o m
 * @param <X>
 * @param hql 
 * @param clazz ?
 * @param values
 * @return
 */
@SuppressWarnings("unchecked")
public <X> List<X> find(final String hql, Class<X> clazz, final Object... values) {
    return createQuery(hql, values).setResultTransformer(Transformers.aliasToBean(clazz)).list();
}

From source file:com.registryKit.client.clientDAO.java

/**
 * The 'getClientFields' function will return a list of client fields associated to the passed in programId.
 * /*from  ww  w .  j a v a  2  s.c  o m*/
 * @param programId The id of the program the user is logged into
 * 
 * @return This function will return a list of fields for the section
 * @throws Exception 
 */
public List<programClientFields> getClientFields(Integer programId, Integer clientId) throws Exception {

    Query query = sessionFactory.getCurrentSession().createSQLQuery(
            "SELECT a.*, b.saveToTableName, b.saveToTableCol, b.answerType as fieldType FROM program_patientFields a inner join dataElements b on b.id = a.fieldId where a.programId = :programId order by a.dspPos asc")
            .setParameter("programId", programId);

    query.setResultTransformer(Transformers.aliasToBean(programClientFields.class));

    List<programClientFields> fields = query.list();

    if (!query.list().isEmpty()) {

        for (programClientFields field : fields) {

            /* Get the actual data */
            field.setFieldValue(getTableData(field.getSaveToTableName(), field.getSaveToTableCol(), clientId));
            field.setModified(isFieldModified(field.getFieldId(), clientId));
        }

    }

    return fields;

}

From source file:com.registryKit.client.engagementDAO.java

/**
 * The 'getEngagements' function will return the list of engagements for the passed in client and programId.
 * /*from  w w  w.  ja v  a2  s  .  co m*/
 * @param clientId  The id of the selected client
 * @param programId The id of the program the logged in user is associated to
 * 
 * @return This function will return a list of client engagements.
 */
public List<engagements> getEngagements(Integer clientId, Integer programId) throws Exception {

    String sql = "select e.id, e.programPatientId, e.programId, e.systemUserId, e.dateCreated, CONCAT(u.firstName,' ', u.lastName) as enteredBy "
            + "from patientEngagements e inner join users u on u.id = e.systemUserId " + "where e.programId = "
            + programId + " and e.programpatientId = " + clientId;

    /* Get a list of client engagements */
    Query q1 = sessionFactory.getCurrentSession().createSQLQuery(sql);
    q1.setResultTransformer(Transformers.aliasToBean(engagements.class));

    return q1.list();
}

From source file:com.registryKit.client.engagementDAO.java

/**
 * The 'getEngagementDetails' function will return the details of the selected engagement
 * //from   w  w w  .j  a va 2 s.c  o  m
 * @param engagementId The id of the selected engagement
 * @return
 * @throws Exception 
 */
public engagements getEngagementDetails(Integer engagementId) throws Exception {
    String sql = "select e.id, e.programPatientId, e.programId, e.systemUserId, e.dateCreated, CONCAT(u.firstName,' ', u.lastName) as enteredBy "
            + "from patientEngagements e inner join users u on u.id = e.systemUserId " + "where e.id = "
            + engagementId;

    /* Get a list of client engagements */
    Query q1 = sessionFactory.getCurrentSession().createSQLQuery(sql);
    q1.setResultTransformer(Transformers.aliasToBean(engagements.class));

    return (engagements) q1.uniqueResult();
}

From source file:com.registryKit.client.engagementDAO.java

/**
 * The 'getEngagementFields' function will return a list of engagement fields associated to the passed in programId.
 * /*from  www . j a v a  2  s. c  om*/
 * @param programId The id of the program the user is logged into
 * 
 * @return This function will return a list of fields for the section
 * @throws Exception 
 */
public List<programEngagementFields> getEngagementFields(Integer programId, Integer engagementId,
        Integer clientId) throws Exception {

    Query query = sessionFactory.getCurrentSession().createSQLQuery(
            "SELECT a.*, b.saveToTableName, b.saveToTableCol, b.answerType as fieldType FROM program_engagementFields a inner join dataElements b on b.id = a.fieldId where a.programId = :programId order by a.dspPos asc")
            .setParameter("programId", programId);

    query.setResultTransformer(Transformers.aliasToBean(programEngagementFields.class));

    List<programEngagementFields> fields = query.list();

    if (!query.list().isEmpty()) {

        for (programEngagementFields field : fields) {

            /* Get the actual data */
            field.setFieldValue(getTableData(field.getSaveToTableName(), field.getSaveToTableCol(),
                    engagementId, clientId));
            field.setModified(isFieldModified(field.getFieldId(), engagementId));
        }
    }

    return fields;

}

From source file:com.registryKit.hierarchy.hierarchyDAO.java

/**
 * The 'getUserProgramHierarchy' function will return a list of authorized hierarchy for the selected user and 
 * program./*from   w w  w  .  ja va  2 s .c om*/
 * 
 * @param programId The id of the selected program
 * @param userId    The id of the selected user
 * @return  This function will return a list of userProgramHierarchy objects
 * @throws Exception 
 */
public List<userProgramHierarchy> getUserProgramHierarchy(Integer programId, Integer userId) throws Exception {

    String sqlQuery = "select a.id, a.systemUserId, a.programId, a.programHierarchyId, a.orgHierarchyDetailId, a.dateCreated, b.name as hierarchyName from user_authorizedOrgHierarchy a inner join programOrgHierarchy_details b on b.id = a.orgHierarchyDetailId where a.programId = "
            + programId + " and a.systemUserId = " + userId;

    Query query = sessionFactory.getCurrentSession().createSQLQuery(sqlQuery)
            .setResultTransformer(Transformers.aliasToBean(userProgramHierarchy.class));

    return query.list();
}

From source file:com.registryKit.hierarchy.serviceDAO.java

/**
 * The 'getProgramServiceCategories' function will return a list of services for the passed in programId.
 * //from   w  w w .j a va2s .com
 * @param programId The selected program id.
 * @return
 * @throws Exception 
 */
public List<programServices> getProgramServices(Integer programId, Integer providerId) throws Exception {

    String sql = "select id, programId, status, serviceName, dateCreated from program_services where programId = "
            + programId
            + " and status = 1 and id not in (select serviceId from providerServices where programId = "
            + programId + " and providerId = " + providerId + ") order by serviceName asc";

    Query query = sessionFactory.getCurrentSession().createSQLQuery(sql)
            .setResultTransformer(Transformers.aliasToBean(programServices.class));

    List<programServices> serviceList = query.list();

    return serviceList;

}