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.registryKit.hierarchy.serviceDAO.java

/**
 * The 'getProviderServices' function will return a list of services associated to the provider.
 * //from  w w w.j  a  v  a2 s  .  co m
 * @param programId The selected program id.
 * @return
 * @throws Exception 
 */
public List<programServices> getProviderServices(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 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;

}

From source file:com.registryKit.importTool.importDAO.java

/**
 * The 'getUploadTypes' function will return a list of upload types set up for the program.
 * //www.  j  a v a2  s.  c  o m
 * @return The function will return a list of upload types in the system
 */
public List<programImportTypes> getImportTypes(Integer programId) throws Exception {

    String sqlQuery = "select a.id, a.programId, a.name, a.dateCreated, a.status, a.useMCI, count(b.id) as totalFields from programUploadTypes a inner join programUploadType_formFields b on a.id = b.programUploadTypeId where "
            + "a.programId = " + programId + " and a.status = 1 group by b.programUploadTypeId";

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

    return query.list();
}

From source file:com.registryKit.survey.surveyDAO.java

/**
 * The 'getSurveyPages' function will return all pages associated with the survey.
 * /*from ww w  .  j a v a  2 s .  c o  m*/
 * @param surveyId  The id of the passed in survey.
 * @param getQuestions  Boolean value to decide to pull questions for each page
 * @return
 * @throws Exception 
 */
@SuppressWarnings("unchecked")
public List<SurveyPages> getSurveyPages(Integer surveyId, boolean getQuestions, Integer clientId,
        Integer engagementId, Integer completedSurveyId) throws Exception {

    List<SurveyPages> surveyPagesList;

    if (completedSurveyId > 0) {
        Query query = sessionFactory.getCurrentSession().createSQLQuery(
                "SELECT * from survey_Pages where surveyId = :surveyId and survey_Pages.id in (select surveyPageId from patient_completedSurveyAnswers where completedSurveyid = :completedSurveyId)")
                .setParameter("surveyId", surveyId).setParameter("completedSurveyId", completedSurveyId);

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

        surveyPagesList = query.list();

    } else {
        Criteria criteria = sessionFactory.getCurrentSession().createCriteria(SurveyPages.class);
        criteria.add(Restrictions.eq("surveyId", surveyId));
        criteria.addOrder(Order.asc("pageNum"));

        surveyPagesList = criteria.list();

    }

    List<SurveyPages> surveyPagesListForReturn = new ArrayList<SurveyPages>();

    if (getQuestions) {
        //we populate the survey questions here 
        for (SurveyPages sp : surveyPagesList) {
            List<SurveyQuestions> sqs = getSurveyQuestions(sp.getId(), 0, completedSurveyId);

            for (SurveyQuestions question : sqs) {
                if (question.getAnswerTypeId() == 1 || question.getAnswerTypeId() == 2) {
                    question.setquestionChoices(
                            getQuestionChoices(question.getId(), question.isAlphabeticallySort()));
                }

                if (completedSurveyId > 0) {
                    Query qAns = sessionFactory.getCurrentSession().createQuery(
                            "from patientCompletedSurveyAnswers where completedSurveyId = :completedSurveyId and questionId = :questionId");
                    qAns.setParameter("completedSurveyId", completedSurveyId);
                    qAns.setParameter("questionId", question.getId());

                    patientCompletedSurveyAnswers surveyAnswer = (patientCompletedSurveyAnswers) qAns
                            .uniqueResult();

                    if (surveyAnswer != null) {
                        if (surveyAnswer.getAnswerId() > 0) {
                            question.setQuestionValue(String.valueOf(surveyAnswer.getAnswerId()));
                        } else {
                            question.setQuestionValue(surveyAnswer.getAnswerText());
                        }
                    }
                } else {
                    if (question.isAutoPopulateFromField() == true) {
                        dataElements field = clientDAO.getFieldDetails(question.getSaveToFieldId());
                        question.setQuestionValue(engagementDAO.getTableData(field.getSaveToTableName(),
                                field.getSaveToTableCol(), engagementId, clientId));
                    }
                }
            }

            sp.setSurveyQuestions(sqs);
            surveyPagesListForReturn.add(sp);
        }
    } else {
        surveyPagesListForReturn = surveyPagesList;
    }

    return surveyPagesListForReturn;
}

From source file:com.registryKit.survey.surveyDAO.java

/**
 * The 'getSurveyQuestions' function will return the questions associated with the survey
 * // ww w  . j ava  2s .  c  om
 * @param surveyPageId  The id for the current page
 * @return
 * @throws Exception 
 */
@SuppressWarnings("unchecked")
public List<SurveyQuestions> getSurveyQuestions(Integer surveyPageId, Integer goToQuestion,
        Integer completedSurveyId) throws Exception {

    List<SurveyQuestions> surveyQuestions = null;

    if (completedSurveyId > 0) {
        Query query = sessionFactory.getCurrentSession().createSQLQuery(
                "SELECT * from survey_questions where surveyPageId = :surveyPageId and survey_questions.id in (select questionId from patient_completedSurveyAnswers where completedSurveyid = :completedSurveyId) order by questionNum")
                .setParameter("surveyPageId", surveyPageId)
                .setParameter("completedSurveyId", completedSurveyId);

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

        surveyQuestions = query.list();

    } else {
        Criteria criteria = sessionFactory.getCurrentSession().createCriteria(SurveyQuestions.class);
        criteria.add(Restrictions.eq("surveyPageId", surveyPageId));
        criteria.add(Restrictions.eq("deleted", false));
        criteria.add(Restrictions.eq("hide", false));

        if (goToQuestion > 0) {
            Criteria goToQuestioncriteria = sessionFactory.getCurrentSession()
                    .createCriteria(SurveyQuestions.class);
            goToQuestioncriteria.add(Restrictions.eq("id", goToQuestion));

            SurveyQuestions goToQuestionDetails = (SurveyQuestions) goToQuestioncriteria.uniqueResult();

            criteria.add(Restrictions.ge("questionNum", goToQuestionDetails.getQuestionNum()));
        }

        criteria.addOrder(Order.asc("questionNum"));
        surveyQuestions = criteria.list();
    }

    for (SurveyQuestions question : surveyQuestions) {
        if (question.getValidationId() > 0) {
            question.setValidation(clientDAO.getValidationType(question.getValidationId()));
        }
    }

    return surveyQuestions;
}

From source file:com.registryKit.survey.surveyDAO.java

/**
 * The 'getPatientSurveysNoEngagement' function will return a list of surveys not associated to any 
 * engagement. /*from   w  ww. j a  v a2s .  c  o m*/
 * 
 * @param clientId
 * @return
 * @throws Exception 
 */
public List<patientCompletedSurveys> getPatientSurveysNoEngagement(Integer clientId, Integer programId)
        throws Exception {

    Query query = sessionFactory.getCurrentSession().createSQLQuery(
            "SELECT a.*, b.title as surveyTitle, CONCAT(c.firstName, ' ', c.lastName) as staffMember FROM patient_completedSurveys a inner join surveys b on b.id = a.surveyId inner join users c on c.id = a.systemUserId where a.programId = :programId and a.programpatientId = :clientId order by a.dateCreated desc")
            .setParameter("programId", programId).setParameter("clientId", clientId);

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

    List<patientCompletedSurveys> surveys = query.list();

    return surveys;
}

From source file:com.registryKit.survey.surveyDAO.java

/**
 * /*from w w  w  . j  a v a2s . c om*/
 * @param clientId
 * @param engagementId
 * @return
 * @throws Exception 
 */
public List<patientCompletedSurveys> getPatientEngagementSurveys(Integer clientId, Integer engagementId)
        throws Exception {

    Query query = sessionFactory.getCurrentSession().createSQLQuery(
            "SELECT a.*, b.title as surveyTitle, CONCAT(c.firstName, ' ', c.lastName) as staffMember FROM patient_completedSurveys a inner join surveys b on b.id = a.surveyId inner join users c on c.id = a.systemUserId where a.engagementId = :engagementId and a.programpatientId = :clientId order by a.dateCreated desc")
            .setParameter("engagementId", engagementId).setParameter("clientId", clientId);

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

    List<patientCompletedSurveys> surveys = query.list();

    return surveys;

}

From source file:com.sapienter.jbilling.server.order.db.UsageDAS.java

License:Open Source License

public Usage findUsageByItem(Integer excludedOrderId, Integer itemId, Integer userId, Date startDate,
        Date endDate) {//from   w w w .  ja  va 2s .c  om
    String sql = excludedOrderId != null ? USAGE_BY_ITEM_ID_SQL + EXCLUDE_ORDER_ID_CLAUSE
            : USAGE_BY_ITEM_ID_SQL;

    Query query = getSession().createSQLQuery(sql).addScalar("amount").addScalar("quantity")
            .setResultTransformer(Transformers.aliasToBean(Usage.class));

    query.setParameter("user_id", userId);
    query.setParameter("item_id", itemId);
    query.setParameter("start_date", startDate);
    query.setParameter("end_date", endDate);

    if (excludedOrderId != null)
        query.setParameter("excluded_order_id", excludedOrderId);

    Usage usage = (Usage) query.uniqueResult();
    usage.setUserId(userId);
    usage.setItemId(itemId);
    usage.setStartDate(startDate);
    usage.setEndDate(endDate);

    return usage;
}

From source file:com.sapienter.jbilling.server.order.db.UsageDAS.java

License:Open Source License

public Usage findSubAccountUsageByItem(Integer excludedOrderId, Integer itemId, Integer userId, Date startDate,
        Date endDate) {/*ww w.  jav a2s .  co  m*/

    String sql = excludedOrderId != null ? SUBACCOUNT_USAGE_BY_ITEM_ID_SQL + EXCLUDE_ORDER_ID_CLAUSE
            : SUBACCOUNT_USAGE_BY_ITEM_ID_SQL;

    Query query = getSession().createSQLQuery(sql).addScalar("amount").addScalar("quantity")
            .setResultTransformer(Transformers.aliasToBean(Usage.class));

    query.setParameter("user_id", userId);
    query.setParameter("item_id", itemId);
    query.setParameter("start_date", startDate);
    query.setParameter("end_date", endDate);

    if (excludedOrderId != null)
        query.setParameter("excluded_order_id", excludedOrderId);

    Usage usage = (Usage) query.uniqueResult();
    usage.setUserId(userId);
    usage.setItemId(itemId);
    usage.setStartDate(startDate);
    usage.setEndDate(endDate);

    return usage;
}

From source file:com.sapienter.jbilling.server.order.db.UsageDAS.java

License:Open Source License

public Usage findUsageByItemType(Integer excludedOrderId, Integer itemTypeId, Integer userId, Date startDate,
        Date endDate) {/*from  w  w  w  .  j a v  a 2s . co m*/

    String sql = excludedOrderId != null ? USAGE_BY_ITEM_TYPE_SQL + EXCLUDE_ORDER_ID_CLAUSE
            : USAGE_BY_ITEM_TYPE_SQL;

    Query query = getSession().createSQLQuery(sql).addScalar("amount").addScalar("quantity")
            .setResultTransformer(Transformers.aliasToBean(Usage.class));

    query.setParameter("user_id", userId);
    query.setParameter("item_type_id", itemTypeId);
    query.setParameter("start_date", startDate);
    query.setParameter("end_date", endDate);

    if (excludedOrderId != null)
        query.setParameter("excluded_order_id", excludedOrderId);

    Usage usage = (Usage) query.uniqueResult();
    usage.setUserId(userId);
    usage.setItemTypeId(itemTypeId);
    usage.setStartDate(startDate);
    usage.setEndDate(endDate);

    return usage;
}

From source file:com.sapienter.jbilling.server.order.db.UsageDAS.java

License:Open Source License

public Usage findSubAccountUsageByItemType(Integer excludedOrderId, Integer itemTypeId, Integer userId,
        Date startDate, Date endDate) {

    String sql = excludedOrderId != null ? SUBACCOUNT_USAGE_BY_ITEM_TYPE_SQL + EXCLUDE_ORDER_ID_CLAUSE
            : SUBACCOUNT_USAGE_BY_ITEM_TYPE_SQL;

    Query query = getSession().createSQLQuery(sql).addScalar("amount").addScalar("quantity")
            .setResultTransformer(Transformers.aliasToBean(Usage.class));

    query.setParameter("user_id", userId);
    query.setParameter("item_type_id", itemTypeId);
    query.setParameter("start_date", startDate);
    query.setParameter("end_date", endDate);

    if (excludedOrderId != null)
        query.setParameter("excluded_order_id", excludedOrderId);

    Usage usage = (Usage) query.uniqueResult();
    usage.setUserId(userId);/*  w  ww  .j  ava2  s.c o m*/
    usage.setItemTypeId(itemTypeId);
    usage.setStartDate(startDate);
    usage.setEndDate(endDate);

    return usage;
}