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.spring.hibernate.service.impl.ReportServiceImpl.java

@Override
public JasperPrint getDailySalesReport(Date date) {
    try {/*w  w w.j a  va2s . c  o m*/
        List<DailySalesReport> list = sessionFactory.getCurrentSession()
                .createQuery("SELECT s.product.name AS productName, SUM(s.quantity) AS quantity,"
                        + " SUM(s.subtotal) AS subtotal FROM SalesDetail s WHERE DAY(s.sales.salesDate)"
                        + "=DAY(:date) GROUP BY s.product.name ORDER BY s.product.name")
                .setParameter("date", date)
                .setResultTransformer(Transformers.aliasToBean(DailySalesReport.class)).list();
        InputStream is = ReportServiceImpl.class.getResourceAsStream("/reports/DailySalesReport.jasper");
        Map<String, Object> param = new HashMap<>();
        param.put("date", date);
        for (int i = 0; i < list.size(); i++) {
            DailySalesReport d = list.get(i);
            System.out.println("Nama Produk : " + d.getProductName());
            System.out.println("Kuantitas : " + d.getQuantity());
            System.out.println("Subtotal : " + d.getSubtotal());
        }
        return JasperFillManager.fillReport(is, param, new JRBeanCollectionDataSource(list));
    } catch (JRException e) {
        log.error("Error Generate Daily Sales Report ", e);
        return null;
    }
}

From source file:com.stok.ramazan.dao.LisansDao.java

public List<Lisans> getLisansListbyFirmID(Long firmOid) {
    String hql = "select lisans.licenseKey as licenseKey "
            + " lisans.licenseFinishDate as licenseFinishDate , lisans.licenseStartDate as licenseStartDate "
            + " from Lisans as lisans \n" + " inner join lisans.firma as firma  \n"
            + "where lisans.entityState= :state and firma.entityState =:state \n"
            + " and lisans.licenseStartDate> :currentDate \n" + " and lisans.licenseFinishDate< :currentDate \n"
            + " and firma.oid = :firmOid ";
    Query query = currentSession().createQuery(hql);
    query.setParameter("currentDate", new Date());
    query.setParameter("state", EnumUtil.EntityState.ACTIVE);
    query.setParameter("firmOid", firmOid);
    query.setResultTransformer(Transformers.aliasToBean(Lisans.class));
    return query.list();
}

From source file:com.sysware.customize.hd.investment.baseData.vendor.VendorDaoImpl.java

@SuppressWarnings("unchecked")
public List<Vendor> findByMaterialIds(String materialCatalogId, int begin, int max, String type) {
    if (materialCatalogId != null && materialCatalogId.length() > 0) {
        StringBuilder sqlStr = new StringBuilder(
                "select distinct v.VENDORID,v.VENDORNAME,v.VENDORCODE,v.ACCOUNTID,v.ADDRESS,"
                        + "v.BANK,v.BUSINESSSCOPE,v.INITIALEVALUATIONDATE,v.VENDORLEVEL,v.PHONE,"
                        + "v.REVIEWDATE,v.TAXID,v.REPOSAL,v.PROPERTY," +
                        //               "m.MATERIALITEMNAME," +
                        "v.simplename,v.type,v.sector ");
        sqlStr.append(" from t_vendor v, t_vendor_material vm, t_material m ");
        sqlStr.append(" where v.vendorid=vm.vendorid and vm.materialid=m.materialid and ");
        if (type.equals("0")) {
            sqlStr.append(" m.PARENTID in (");
            sqlStr.append(" select mc.materialcatalogid from t_materialcatalog mc ");
            sqlStr.append(" start with mc.materialcatalogid='" + materialCatalogId + "'");
            sqlStr.append(" connect by prior mc.materialcatalogid = mc.parentid) ");
        } else {//from  w  w w .j  av a2s.  co m
            sqlStr.append(" vm.materialid = '" + materialCatalogId + "'");//materialCatalogId ?ID  
        }
        sqlStr.append(" order by v.vendorname ");
        //         System.out.println("?"+sqlStr.toString());
        List<Vendor> results = new ArrayList<Vendor>();
        //         List<Object[]> temps = this.executeNativeQuery(sqlStr.toString(),
        //               null, begin, max);
        //         for (Object[] objects : temps) {
        //            Vendor vendor = new Vendor();
        //            vendor.setVendorID((String) objects[0]);
        //            vendor.setVendorName(objects[1]==null?"":(String) objects[1]);
        //            vendor.setVendorCode(objects[2]==null?"":(String) objects[2]);
        //            vendor.setAccountID(objects[3]==null?"":(String) objects[3]);
        //            vendor.setAddress(objects[4]==null?"":(String) objects[4]);
        //            vendor.setBank(objects[5]==null?"":(String) objects[5]);
        //            vendor.setBusinessScope(objects[6]==null?"":(String) objects[6]);
        //            vendor.setInitialEvaluationDate(objects[7]==null?null:(Date) objects[7]);
        //            vendor.setVendorLevel(objects[8]==null?"":(String) objects[8]);
        //            vendor.setPhone(objects[9]==null?"":(String) objects[9]);
        ////            vendor.setReviewResult(objects[10]==null?"":(String) objects[10]);
        //            vendor.setReviewDate(objects[10]==null?null:(Date) objects[10]);
        //            vendor.setTaxID(objects[11]==null?"":(String) objects[11]);
        //            vendor.setReposal(objects[12]==null?"":(String) objects[12]);
        //            vendor.setProperty(objects[13]==null?"":(String) objects[13]);
        //             vendor.setMaterialItemName(objects[14]==null?"":(String) objects[14]);
        //             vendor.setSimpleName(objects[15]==null?"":(String) objects[15]);
        //             vendor.setType(objects[16]==null?"":(String) objects[16]);
        //             vendor.setSector(objects[17]==null?"":(String) objects[17]);
        //            results.add(vendor);
        //         }
        SQLQuery query = dao.getHibernateSession().createSQLQuery(sqlStr.toString());
        setFindByMaterialIds(query);
        query = (SQLQuery) query.setResultTransformer(Transformers.aliasToBean(Vendor.class));
        results = query.list();
        return results;
    } else {
        return new ArrayList<Vendor>();
    }

}

From source file:com.sysware.customize.hd.investment.baseData.vendor.VendorDaoImpl.java

/**
 * ????//from  w w  w .  ja v  a  2  s . c o  m
 * @param vendorName
 * @return
 */
@SuppressWarnings("unchecked")
public List<Vendor> GetAVendor(String vendorName) {
    String sql = "select t.vendorcode,t.vendorname from t_vendor t where t.vendorname=?";
    SQLQuery query = dao.getHibernateSession().createSQLQuery(sql);
    SetAVendor(query);
    query = (SQLQuery) query.setResultTransformer(Transformers.aliasToBean(Vendor.class));
    query.setParameter(0, vendorName);
    return query.list();
}

From source file:com.ut.healthelink.dao.impl.transactionInDAOImpl.java

@Override
@Transactional/*from   ww  w. j  a va  2  s.  c o m*/
@SuppressWarnings("unchecked")
public List<ConfigForInsert> setConfigForInsert(int configId, int batchUploadId) {
    String sql = ("call setSqlForConfig(:id, :batchUploadId);");
    Query query = sessionFactory.getCurrentSession().createSQLQuery(sql)
            .addScalar("saveToTableName", StandardBasicTypes.STRING)
            .addScalar("saveToTableCol", StandardBasicTypes.STRING)
            .addScalar("batchUploadId", StandardBasicTypes.INTEGER)
            .addScalar("configId", StandardBasicTypes.INTEGER)
            .addScalar("singleValueFields", StandardBasicTypes.STRING)
            .addScalar("splitFields", StandardBasicTypes.STRING)
            .addScalar("checkForDelim", StandardBasicTypes.STRING)
            .setResultTransformer(Transformers.aliasToBean(ConfigForInsert.class)).setParameter("id", configId)
            .setParameter("batchUploadId", batchUploadId);

    List<ConfigForInsert> configListForInsert = query.list();

    return configListForInsert;
}

From source file:com.ut.healthelink.dao.impl.transactionInDAOImpl.java

@Override
@Transactional/*from   ww  w .j  av  a  2  s .  c o  m*/
@SuppressWarnings("unchecked")
public List<transactionRecords> getFieldColAndValues(Integer batchUploadId, configurationFormFields cff) {
    String sql = ("select transactionInId as transactionId, F" + cff.getFieldNo() + "  as fieldValue, "
            + cff.getFieldNo() + " as fieldNo from transactiontranslatedIn " + " where configId = :configId "
            + " and F" + cff.getFieldNo() + " is not null "
            + " and transactionInId in (select id from transactionIn where" + " batchId = :batchUploadId"
            + " and configId = :configId and statusId not in ( :transRELId ) order by transactionInId); ");

    Query query = sessionFactory.getCurrentSession().createSQLQuery(sql)
            .addScalar("transactionId", StandardBasicTypes.INTEGER)
            .addScalar("fieldValue", StandardBasicTypes.STRING).addScalar("fieldNo", StandardBasicTypes.INTEGER)
            .setResultTransformer(Transformers.aliasToBean(transactionRecords.class))
            .setParameter("configId", cff.getconfigId()).setParameter("batchUploadId", batchUploadId)
            .setParameterList("transRELId", transRELId);

    List<transactionRecords> trs = query.list();

    return trs;
}

From source file:com.ut.healthelink.dao.impl.transactionInDAOImpl.java

@Override
@Transactional//w w w  . j  ava2  s  . c  om
@SuppressWarnings("unchecked")
public List<configurationTransport> getHandlingDetailsByBatch(int batchId) throws Exception {
    try {
        String sql = ("select distinct clearRecords, autoRelease, errorHandling "
                + " from configurationtransportdetails where configId in "
                + "(select distinct configId from transactionIn where batchId = :batchId);");
        Query query = sessionFactory.getCurrentSession().createSQLQuery(sql)
                .setResultTransformer(Transformers.aliasToBean(configurationTransport.class))
                .setParameter("batchId", batchId);

        List<configurationTransport> ct = query.list();
        return ct;
    } catch (Exception ex) {
        System.err.println("getHandlingDetailsByBatch " + ex.getCause());
        return null;
    }

}

From source file:com.ut.healthelink.dao.impl.transactionInDAOImpl.java

@Override
@Transactional//from  ww  w  .  j  av  a  2s  .c o m
@SuppressWarnings("unchecked")
public List<configurationConnection> getBatchTargets(Integer batchId, boolean active) {
    try {
        String sql = ("select sourceConfigId, targetConfigId, configurationconnections.id, "
                + " targetOrgCol, orgId as targetOrgId, messageTypeId from configurations, configurationconnections , configurationMessageSpecs  "
                + " where sourceconfigId in (select configId from transactionIn where  batchId = :batchId)"
                + " and sourceConfigId = configurationMessageSpecs.configId"
                + " and targetConfigId = configurations.id ");
        if (active) {
            sql = sql
                    + " and configurations.status = 1 and configurationconnections.status = 1 and messageTypeId in (select id from messageTypes where status = 1)";
        }
        sql = sql + " order by sourceConfigId;";

        Query query = sessionFactory.getCurrentSession().createSQLQuery(sql)
                .setResultTransformer(Transformers.aliasToBean(configurationConnection.class));
        query.setParameter("batchId", batchId);

        List<configurationConnection> cc = query.list();
        return cc;
    } catch (Exception ex) {
        System.err.println("getBatchTargets " + ex.getCause());
        return null;
    }
}

From source file:com.ut.healthelink.dao.impl.transactionInDAOImpl.java

@Override
@Transactional/* w w  w.  j av  a  2 s .com*/
@SuppressWarnings("unchecked")
public List<transactionInRecords> getTransactionInRecordsForBatch(Integer batchId) {
    try {
        String sql = ("select * from transactionInRecords where transactionInId in "
                + " (select id from transactionIn where batchId = :batchId);");
        Query query = sessionFactory.getCurrentSession().createSQLQuery(sql)
                .setResultTransformer(Transformers.aliasToBean(transactionInRecords.class))
                .setParameter("batchId", batchId);

        List<transactionInRecords> transactionInRecords = query.list();

        return transactionInRecords;

    } catch (Exception ex) {
        ex.printStackTrace();
        System.err.println("getTransactionRecordsForBatch " + ex.getCause());
        return null;
    }
}

From source file:com.ut.healthelink.dao.impl.transactionInDAOImpl.java

/**
 * this method gets all getBatchUploadSummary along with the transactionTarget id for a particular transactionInId we start with the second transactionInId
 *///from   w  ww.ja  v  a  2 s.  c  om
@Override
@Transactional
@SuppressWarnings("unchecked")
public List<batchUploadSummary> getBatchUploadSummary(Integer transactionInId) {
    try {
        String sql = ("select transactionTarget.id as transactionTargetId,  batchUploadSummary.* from transactionTarget, batchUploadSummary where  "
                + " transactionTarget.transactionInId = batchUploadSummary.transactionInId and batchUploadSummary.targetConfigId = transactionTarget.configId "
                + " and transactionTarget.transactionInId in (:transactionInId) limit 1, 999999;");
        Query query = sessionFactory.getCurrentSession().createSQLQuery(sql)
                .setResultTransformer(Transformers.aliasToBean(batchUploadSummary.class));
        query.setParameter("transactionInId", transactionInId);

        List<batchUploadSummary> batchUploadSummaries = query.list();

        return batchUploadSummaries;

    } catch (Exception ex) {
        System.err.println("getBatchUploadSummary " + ex.getCause());
        ex.printStackTrace();
        return null;
    }
}