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.ut.healthelink.dao.impl.transactionInDAOImpl.java

@Override
@Transactional/*from  w  w  w .  java2 s.  c om*/
@SuppressWarnings("unchecked")
public List<TransactionInError> getErrorList(Integer batchId) {

    try {
        String sql = ("select * from transactionInErrors where batchUploadId = :batchId order by configId");
        Query query = sessionFactory.getCurrentSession().createSQLQuery(sql)
                .setResultTransformer(Transformers.aliasToBean(TransactionInError.class));
        query.setParameter("batchId", batchId);

        List<TransactionInError> errorList = query.list();
        return errorList;

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

}

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

@SuppressWarnings("unchecked")
@Override//from w  ww  .j ava  2 s .  c  om
@Transactional
public List<TransErrorDetail> getTransErrorDetailsForNoRptFields(Integer batchId, List<Integer> errorCodes) {
    try {
        String sql = "select " + "'N/A' as transactionStatusValue, 'N/A' as errorFieldLabel, "
                + " transactionInErrors.id, errorId as errorCode, displayText as errorDisplayText, stackTrace as errorData  "
                + " from transactionInErrors, lu_errorCodes where  transactionInErrors.errorId = lu_errorCodes.id "
                + " and transactionInErrors.errorId  in ( :errorCodes ) and batchuploadid = :batchId order by errorId, id;";

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

        query.setParameter("batchId", batchId);
        query.setParameterList("errorCodes", errorCodes);
        return query.list();
    } catch (Exception ex) {
        System.err.println("getTransErrorDetailsForNoRptFields " + ex.getCause());
        ex.printStackTrace();
    }
    return null;
}

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

@SuppressWarnings("unchecked")
@Override/*from  w ww .  j  a  v a2s  .c o  m*/
@Transactional
public List<TransErrorDetail> getTransErrorDetailsForInvConfig(Integer batchId) {
    try {
        String sql = "select transactionIn.statusId as transactionStatus, lu_processstatus.displayCode as transactionStatusValue, "
                + " transactionIn.id as transactionInId, 'N/A' as errorFieldLabel, 'N/A' as errorData,"
                + " F1 as rptField1Value, F2 as rptField2Value, F3 as rptField3Value, F4 as rptField4Value,"
                + " 'Field 1' as rptField1Label, 'Field 2' as rptField2Label, 'Field 3' as rptField3Label, 'Field 4' as rptField4Label,"
                + " errorId as errorCode, lu_errorcodes.displayText as errorDisplayText "
                + " from transactionInErrors, transactionInRecords, lu_errorcodes, transactionIn, lu_processstatus "
                + " where batchuploadId = :batchId and errorId = :errorId and lu_errorcodes.id = transactionInErrors.errorId"
                + " and transactionIn.id = transactionInRecords.transactionInId "
                + " and transactionIn.statusId = lu_processstatus.id "
                + " and transactionInErrors.transactionInId = transactionInRecords.transactionInId  "
                + " order  by transactionInRecords.transactionInId;";
        Query query = sessionFactory.getCurrentSession().createSQLQuery(sql)
                .setResultTransformer(Transformers.aliasToBean(TransErrorDetail.class));

        query.setParameter("batchId", batchId);
        query.setParameter("errorId", 6);
        return query.list();

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

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

@Override
@Transactional//from  ww w  .j a  v a  2  s.  c  om
@SuppressWarnings("unchecked")
public List<ConfigErrorInfo> getErrorConfigForBatch(Integer batchId) {
    try {
        String sql = "select configId, rptField1, rptField2, rptField3, rptField4, configName, name as messageTypeName "
                + " from configurationmessagespecs, configurations, messagetypes"
                + " where configurationmessagespecs.configId = configurations.Id and configurations.messageTypeId = messageTypes.id "
                + " and configId in (select distinct configId from transactionInErrors where batchUploadId = :batchId) "
                + " order by configId;";

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

        query.setParameter("batchId", batchId);

        List<ConfigErrorInfo> cei = query.list();
        return cei;

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

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

@Override
@Transactional/*from   www  .ja  va2 s.c  o m*/
@SuppressWarnings("unchecked")
public List<TransErrorDetail> getTransErrorDetails(batchUploads batchInfo, ConfigErrorInfo configErrorInfo) {

    String sql = "select transactionInErrors.id, transactionInErrors.configId, transactionInId, errorId as errorCode, lu_errorCodes.displayText as errorDisplayText, "
            + "fieldNo as errorFieldNo, cwId, macroId, validationTypeId , "
            + "transactionIn.statusId as transactionStatus, "
            + "lu_processstatus.displayCode as transactionStatusValue "
            + "from transactionInErrors, lu_errorCodes, transactionIn , lu_processstatus "
            + "where lu_processstatus.id = transactionIn.statusId and "
            + "errorId = lu_errorCodes.id and transactionInErrors.transactionInId = transactionIn.Id "
            + "and transactionInErrors.configId = :configId and batchuploadid = :batchId order by transactionInId, errorCode, transactionInErrors.id;";

    try {
        Query query = sessionFactory.getCurrentSession().createSQLQuery(sql)
                .setResultTransformer(Transformers.aliasToBean(TransErrorDetail.class));

        query.setParameter("configId", configErrorInfo.getConfigId());
        query.setParameter("batchId", batchInfo.getId());

        List<TransErrorDetail> teds = query.list();
        return teds;
    } catch (Exception ex) {
        System.err.println("getTransErrorDetails " + ex.getCause());
        ex.printStackTrace();
        return null;
    }
}

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

@Override
@Transactional/*w  w w.ja v  a2s .co  m*/
@SuppressWarnings("unchecked")
public TransErrorDetail getTransErrorData(TransErrorDetail ted, String sqlStmt) {

    String sql = "select  " + sqlStmt + " from transactionInRecords where transactionInId =  :transactionInId";

    try {
        Query query = sessionFactory.getCurrentSession().createSQLQuery(sql)
                .setResultTransformer(Transformers.aliasToBean(TransErrorDetail.class));

        query.setParameter("transactionInId", ted.getTransactionInId());

        List<TransErrorDetail> newTed = query.list();
        ted.setRptField1Value(newTed.get(0).getRptField1Value());
        ted.setRptField2Value(newTed.get(0).getRptField2Value());
        ted.setRptField3Value(newTed.get(0).getRptField3Value());
        ted.setRptField4Value(newTed.get(0).getRptField4Value());
        ted.setErrorData(newTed.get(0).getErrorData());

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

}

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

@Override
@Transactional//from   w  w  w  .  j  av a  2s.co  m
public batchUploads getBatchDetailsByTInId(Integer transactionInId) {
    try {
        String sql = "select * from batchUploads where id in (select batchId from transactionIn where"
                + " id = :transactionInId);";
        Query query = sessionFactory.getCurrentSession().createSQLQuery(sql)
                .setResultTransformer(Transformers.aliasToBean(batchUploads.class));
        query.setParameter("transactionInId", transactionInId);
        if (query.list().size() > 0) {
            return (batchUploads) query.list().get(0);
        } else {
            // no permission or id doesn't exist
            return null;
        }

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

}

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

@Override
@Transactional// w w  w. j av  a 2 s  .c  o m
public List<TransErrorDetail> getTransactionErrorsByFieldNo(int transactionInId, int fieldNo) throws Exception {

    String sql = "select err.displayText as errorDisplayText, v.validationType as errorInfo "
            + "from transactionInErrors inner join lu_errorCodes err on err.id = transactionInErrors.errorId "
            + "left outer join ref_validationTypes v on v.id = transactionInErrors.validationTypeId "
            + "where transactionInErrors.transactionInId = :transactionInId and transactionInErrors.fieldNo = :fieldNo ";

    try {
        Query query = sessionFactory.getCurrentSession().createSQLQuery(sql)
                .setResultTransformer(Transformers.aliasToBean(TransErrorDetail.class));

        query.setParameter("transactionInId", transactionInId);
        query.setParameter("fieldNo", fieldNo);

        List<TransErrorDetail> teds = query.list();
        return teds;

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

}

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

@Override
@Transactional// w  w  w .j ava 2 s . c  o m
@SuppressWarnings("unchecked")
public List<UserActivity> getBatchUserActivities(batchUploads batchInfo, boolean foroutboundProcessing) {
    String batchColName = "batchUploadId";
    if (foroutboundProcessing) {
        batchColName = "batchDownloadId";
    }

    String sql = " select  users.firstName as userFirstName, organizations.orgname as orgName, "
            + " organizations.id as orgId, users.lastName as userLastName, userActivity.* "
            + " from useractivity left join users on users.id = userActivity.userId left join organizations on"
            + " users.orgId = organizations.id where " + batchColName
            + "= :batchId order by dateCreated desc, userId";

    try {
        Query query = sessionFactory.getCurrentSession().createSQLQuery(sql)
                .setResultTransformer(Transformers.aliasToBean(UserActivity.class));

        query.setParameter("batchId", batchInfo.getId());

        List<UserActivity> uas = query.list();

        return uas;

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

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

@Override
@Transactional//from  w w w .j  av a  2s  .  c o m
@SuppressWarnings("unchecked")
public List<transactionRecords> getFieldColAndValueByTransactionId(configurationFormFields cff,
        Integer transactionId) {
    try {
        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 = :id");

        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("id", transactionId);

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

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