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:au.org.theark.report.model.dao.ReportDao.java

License:Open Source License

public List<BiospecimenSummaryDataRow> getBiospecimenSummaryData(
        BiospecimenSummaryReportVO biospecimenSummaryReportVO) {
    List<BiospecimenSummaryDataRow> results = new ArrayList<BiospecimenSummaryDataRow>();

    Criteria criteria = getSession().createCriteria(BioTransaction.class, "bt");

    criteria.createAlias("status", "bts", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("biospecimen", "bs", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("bs.study", "st", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("bs.linkSubjectStudy", "lss", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("bs.sampleType", "sat", JoinType.LEFT_OUTER_JOIN);

    criteria.add(Restrictions.eq("st.id", biospecimenSummaryReportVO.getStudy().getId()));
    if (biospecimenSummaryReportVO.getSubjectUID() != null) {
        criteria.add(Restrictions.eq("lss.subjectUID", biospecimenSummaryReportVO.getSubjectUID()));
    }/*from  w ww.j  a  v a2 s .  c o  m*/

    ProjectionList projectionList = Projections.projectionList();
    projectionList.add(Projections.min("bt.id"));
    projectionList.add(Projections.groupProperty("bs.id"));

    projectionList.add(Projections.property("st.name"), "studyName");
    projectionList.add(Projections.property("lss.subjectUID"), "subjectUId");
    projectionList.add(Projections.property("bs.id"), "biospecimenId");
    projectionList.add(Projections.property("bs.biospecimenUid"), "biospecimenUid");
    projectionList.add(Projections.property("bs.parentUid"), "parentId");
    projectionList.add(Projections.property("sat.name"), "sampleType");
    projectionList.add(Projections.property("bs.quantity"), "quantity");
    projectionList.add(Projections.property("bts.name"), "initialStatus");

    criteria.setProjection(projectionList);
    criteria.setResultTransformer(Transformers.aliasToBean(BiospecimenSummaryDataRow.class));
    criteria.addOrder(Order.asc("lss.subjectUID"));
    criteria.addOrder(Order.asc("bs.biospecimenUid"));
    results = criteria.list();

    return results;
}

From source file:au.org.theark.report.model.dao.ReportDao.java

License:Open Source License

public List<BiospecimenDetailsDataRow> getBiospecimenDetailsData(
        BiospecimenDetailsReportVO biospecimenDetailReportVO) {
    List<BiospecimenDetailsDataRow> results = new ArrayList<BiospecimenDetailsDataRow>();

    Criteria criteria = getSession().createCriteria(BioTransaction.class, "bt");

    criteria.createAlias("status", "bts", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("biospecimen", "bs", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("bs.study", "st", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("bs.bioCollection", "bc", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("bs.linkSubjectStudy", "lss", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("bs.sampleType", "sat", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("bs.invCell", "inc", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("inc.invBox", "inb", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("inb.invRack", "inr", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("inr.invFreezer", "inf", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("inf.invSite", "ins", JoinType.LEFT_OUTER_JOIN);

    criteria.add(Restrictions.eq("st.id", biospecimenDetailReportVO.getStudy().getId()));
    if (biospecimenDetailReportVO.getSubjectUID() != null) {
        criteria.add(Restrictions.eq("lss.subjectUID", biospecimenDetailReportVO.getSubjectUID()));
    }// w  w w .  jav  a 2 s .com

    ProjectionList projectionList = Projections.projectionList();
    projectionList.add(Projections.min("bt.id"));
    projectionList.add(Projections.groupProperty("bs.id"));

    projectionList.add(Projections.property("st.name"), "studyName");
    projectionList.add(Projections.property("lss.subjectUID"), "subjectUId");
    projectionList.add(Projections.property("bs.id"), "biospecimenId");
    projectionList.add(Projections.property("bc.biocollectionUid"), "biocollectionUid");
    projectionList.add(Projections.property("bs.sampleDate"), "sampleDate");
    projectionList.add(Projections.property("bs.biospecimenUid"), "biospecimenUid");
    projectionList.add(Projections.property("bs.parentUid"), "parentId");
    projectionList.add(Projections.property("sat.name"), "sampleType");
    projectionList.add(Projections.property("bs.quantity"), "quantity");
    projectionList.add(Projections.property("bts.name"), "initialStatus");

    projectionList.add(Projections.property("inb.name"), "box");
    projectionList.add(Projections.property("inr.name"), "rack");
    projectionList.add(Projections.property("inf.name"), "freezer");
    projectionList.add(Projections.property("ins.name"), "site");

    criteria.setProjection(projectionList);
    criteria.setResultTransformer(Transformers.aliasToBean(BiospecimenDetailsDataRow.class));
    criteria.addOrder(Order.asc("lss.subjectUID"));
    criteria.addOrder(Order.asc("bs.biospecimenUid"));
    results = criteria.list();

    return results;
}

From source file:au.org.theark.study.model.dao.StudyDao.java

License:Open Source License

public RelationshipVo getSubjectRelative(final String subjectUID, final Long studyId) {
    List<RelationshipVo> relatives = new ArrayList<RelationshipVo>();
    Criteria criteria = getSession().createCriteria(LinkSubjectStudy.class, "sub");
    criteria.createAlias("sub.study", "substudy", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("sub.person", "subPerson", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("subPerson.genderType", "subGender", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("subPerson.vitalStatus", "subVitStatus", JoinType.LEFT_OUTER_JOIN);

    criteria.createAlias("substudy.pedigreeConfiguration", "spc", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("spc.customField", "cf", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("cf.customFieldDisplay", "cfd", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("sub.subjectCustomFieldDataSet", "scfd", JoinType.LEFT_OUTER_JOIN,
            Restrictions.eqProperty("cfd.id", "scfd.customFieldDisplay.id"));

    criteria.add(Restrictions.eq("sub.subjectUID", subjectUID));
    criteria.add(Restrictions.eq("substudy.id", studyId));

    criteria.setFetchMode("subject", FetchMode.JOIN);
    criteria.setFetchMode("relative", FetchMode.JOIN);

    ProjectionList projectionList = Projections.projectionList();
    projectionList.add(Projections.property("sub.subjectUID"), "individualId");
    projectionList.add(Projections.property("subGender.name"), "gender");
    projectionList.add(Projections.property("subPerson.dateOfBirth"), "dob");
    projectionList.add(Projections.property("subPerson.dateOfDeath"), "dod");
    projectionList.add(Projections.property("subVitStatus.name"), "deceased");

    projectionList.add(Projections.property("scfd.textDataValue"), "affectedStatus");

    criteria.setProjection(projectionList);
    criteria.setResultTransformer(Transformers.aliasToBean(RelationshipVo.class));

    relatives = criteria.list();/*from  www . ja  v a  2 s. com*/

    return relatives.size() > 0 ? relatives.get(0) : null;
}

From source file:au.org.theark.study.model.dao.StudyDao.java

License:Open Source License

public List<RelationshipVo> getSubjectParentRelatives(final String subjectUID, final Long studyId) {
    List<RelationshipVo> relatives = new ArrayList<RelationshipVo>();
    Criteria criteria = getSession().createCriteria(LinkSubjectPedigree.class, "lsp");
    criteria.createAlias("subject", "sub", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("sub.study", "substudy", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("relative", "rel", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("rel.study", "relstudy", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("relationship", "type", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("rel.person", "relPerson", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("relPerson.genderType", "relGender", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("relPerson.vitalStatus", "relVitStatus", JoinType.LEFT_OUTER_JOIN);

    criteria.createAlias("relstudy.pedigreeConfiguration", "spc", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("spc.customField", "cf", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("cf.customFieldDisplay", "cfd", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("rel.subjectCustomFieldDataSet", "scfd", JoinType.LEFT_OUTER_JOIN,
            Restrictions.eqProperty("cfd.id", "scfd.customFieldDisplay.id"));

    criteria.add(Restrictions.eq("sub.subjectUID", subjectUID));
    criteria.add(Restrictions.eq("substudy.id", studyId));
    criteria.add(Restrictions.eq("relstudy.id", studyId));

    criteria.setFetchMode("subject", FetchMode.JOIN);
    criteria.setFetchMode("relative", FetchMode.JOIN);

    ProjectionList projectionList = Projections.projectionList();
    projectionList.add(Projections.property("lsp.id"), "id");
    projectionList.add(Projections.property("rel.subjectUID"), "individualId");
    projectionList.add(Projections.property("relGender.name"), "gender");
    projectionList.add(Projections.property("relPerson.dateOfBirth"), "dob");
    projectionList.add(Projections.property("relPerson.dateOfDeath"), "dod");
    projectionList.add(Projections.property("relPerson.firstName"), "firstName");
    projectionList.add(Projections.property("relPerson.lastName"), "lastName");
    projectionList.add(Projections.property("relVitStatus.name"), "deceased");

    projectionList.add(Projections.property("scfd.textDataValue"), "affectedStatus");

    criteria.setProjection(projectionList);
    criteria.setResultTransformer(Transformers.aliasToBean(RelationshipVo.class));

    relatives = criteria.list();/*from w  w w.j  a  v a 2  s.c  om*/
    return relatives;
}

From source file:au.org.theark.study.model.dao.StudyDao.java

License:Open Source License

public List<RelationshipVo> getSubjectChildRelatives(final String subjectUID, final Long studyId) {
    List<RelationshipVo> relatives = new ArrayList<RelationshipVo>();
    Criteria criteria = getSession().createCriteria(LinkSubjectPedigree.class, "lsp");
    criteria.createAlias("subject", "sub", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("sub.study", "substudy", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("relative", "rel", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("rel.study", "relstudy", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("relationship", "type", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("sub.person", "subPerson", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("subPerson.genderType", "subGender", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("subPerson.vitalStatus", "subVitStatus", JoinType.LEFT_OUTER_JOIN);

    criteria.createAlias("substudy.pedigreeConfiguration", "spc", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("spc.customField", "cf", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("cf.customFieldDisplay", "cfd", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("sub.subjectCustomFieldDataSet", "scfd", JoinType.LEFT_OUTER_JOIN,
            Restrictions.eqProperty("cfd.id", "scfd.customFieldDisplay.id"));

    criteria.add(Restrictions.eq("rel.subjectUID", subjectUID));
    criteria.add(Restrictions.eq("substudy.id", studyId));
    criteria.add(Restrictions.eq("relstudy.id", studyId));

    criteria.setFetchMode("subject", FetchMode.JOIN);
    criteria.setFetchMode("relative", FetchMode.JOIN);

    ProjectionList projectionList = Projections.projectionList();
    projectionList.add(Projections.property("lsp.id"), "id");
    projectionList.add(Projections.property("sub.subjectUID"), "individualId");
    projectionList.add(Projections.property("subGender.name"), "gender");
    projectionList.add(Projections.property("subPerson.dateOfBirth"), "dob");
    projectionList.add(Projections.property("subPerson.dateOfDeath"), "dod");
    projectionList.add(Projections.property("subPerson.firstName"), "firstName");
    projectionList.add(Projections.property("subPerson.lastName"), "lastName");
    projectionList.add(Projections.property("subVitStatus.name"), "deceased");

    projectionList.add(Projections.property("scfd.textDataValue"), "affectedStatus");

    criteria.setProjection(projectionList);
    criteria.setResultTransformer(Transformers.aliasToBean(RelationshipVo.class));

    relatives = criteria.list();/* ww w. j av a  2s.  c  o  m*/
    return relatives;
}

From source file:au.org.theark.study.model.dao.StudyDao.java

License:Open Source License

public List<RelationshipVo> getSubjectTwins(final String subjectUid, final Set<String> subjectUids,
        final Long studyId) {
    // StringBuffer sb = new
    // StringBuffer("select lss.subject_uid as individualId, p.FIRST_NAME as firstName,p.LAST_NAME as lastName,p.DATE_OF_BIRTH as dob,slt.id as id , IFNULL(tw.name,'NT') as twin ");
    StringBuffer sb = new StringBuffer(
            "select lss.subject_uid as individualId, p.FIRST_NAME as firstName,p.LAST_NAME as lastName,p.DATE_OF_BIRTH as dob,slt.id as id , tw.name as twin ");
    sb.append(" From study.link_subject_study lss ");
    sb.append("    inner join study.study st on st.id=lss.study_id ");
    sb.append("    inner join study.person p on p.id=lss.person_id ");
    sb.append(/*  w  w w  .j  av  a 2s .  c  o m*/
            "    left outer join study.link_subject_twin slt on (slt.first_subject = lss.id and slt.second_Subject = (select a.id ");
    sb.append("       From study.link_subject_study a ");
    sb.append("          inner join study.study st on st.id=a.study_id ");
    sb.append("       where a.SUBJECT_UID in (:asubjectuid) ");
    sb.append(
            "          and st.id= :astudyid )) or (slt.second_subject = lss.id and slt.first_Subject = (select b.id ");
    sb.append("             From study.link_subject_study b ");
    sb.append("                inner join study.study st on st.id=b.study_id ");
    sb.append("             where b.SUBJECT_UID in ( :bsubjectuid ) ");
    sb.append("             and st.id= :bstudyid )) ");
    sb.append("    left outer join study.twin_type tw on tw.id = slt.twin_type_id ");
    sb.append(" where lss.SUBJECT_UID in ( :subjectUids ) ");
    sb.append("    and st.id= :studyId ");

    List<RelationshipVo> twins = getSession().createSQLQuery(sb.toString()).addScalar("individualId")
            .addScalar("id").addScalar("firstName").addScalar("lastName").addScalar("dob").addScalar("twin")
            .setParameter("asubjectuid", subjectUid).setParameter("astudyid", studyId)
            .setParameter("bsubjectuid", subjectUid).setParameter("bstudyid", studyId)
            .setParameterList("subjectUids", subjectUids != null ? subjectUids : new HashSet<String>())
            .setParameter("studyId", studyId)
            .setResultTransformer(Transformers.aliasToBean(RelationshipVo.class)).list();

    return twins;

}

From source file:bgroup.oracle.dao.ContractDaoImpl.java

@Override
public Contract getContract(int PATIENT_ID) {
    logger.debug("Start getDog");

    Session session = getSession();// w ww.  j  a  v  a2s  . c o m
    logger.debug("session:" + session.toString());
    Query query = session.createSQLQuery("SELECT  p.KeyID as keyId"
            + ",(SELECT text FROM lu WHERE keyid = 93114) AS \"doverennost\""
            + ",(SELECT text FROM lu WHERE keyid = 93114) AS \"doverennost2\""
            + ",(SELECT text FROM lu WHERE keyid = 93114) AS \"doverennost3\""
            + ",(SELECT text FROM lu WHERE keyid = 93114) AS \"doverennost4\""
            + ",(SELECT text FROM lu WHERE keyid = 93116) AS \"license\""
            + ",(SELECT text FROM lu WHERE keyid = 93116) AS \"license2\""
            + ",(SELECT text FROM lu WHERE keyid = 93116) AS \"license3\""
            + ",(SELECT text FROM lu WHERE keyid = 93116) AS \"license4\""
            + ",fn_pat_name_by_id (p.KeyID) AS \"fio\"" + ",fn_pat_name_by_id (p.KeyID) AS \"fio2\""
            + ",fn_pat_name_by_id (p.KeyID) AS \"fio3\"" + ",fn_pat_name_by_id (p.KeyID) AS \"fio4\""
            + ",fn_pat_name_by_id (p.KeyID) AS \"fio5\"" + ",fn_pat_name_by_id (p.KeyID) AS \"fio6\""
            + ",p.num AS patnum" + ",p.num AS patnum2" + ",pkg_kladr.get_address(P.KeyID,1) AS \"region1\""
            + ",pkg_kladr.get_address(P.KeyID,1) AS \"address\""
            + ",pkg_kladr.get_address(P.KeyID,1) AS \"address2\""
            + ",pkg_kladr.get_address(P.KeyID,1) AS \"address3\""
            + ",pkg_kladr.get_address(P.KeyID,1) AS \"address4\"" + ",fn_pat_phone_by_id(p.keyid) AS phone"
            + ",fn_pat_phone_by_id(p.keyid) AS phone2" + ",decode (p.sex, 1, '.','.') AS sex_name"
            + ",fn_man_by_id (gsp_get_user_id()) AS registrator"
            + ",fn_man_by_id (gsp_get_user_id()) AS registrator2"
            + ",fn_man_by_id (gsp_get_user_id()) AS registrator3"
            + ",fn_man_by_id (gsp_get_user_id()) AS registrator4"
            + ",fn_man_by_id (gsp_get_user_id()) AS registrator5"
            + ",TO_CHAR (p.birthdate, 'dd-mm-yyyy') AS birth_date"
            + ", NVL ((SELECT c.text FROM company c,agr a WHERE a.keyid = p.agrid AND c.keyid = a.companyid),'') AS company"
            + ", NVL ((SELECT MAX('? ' || l.ser || ' N ' || l.code) FROM police l,agr a WHERE a.keyid = p.agrid "
            + "AND l.patientid = p.keyid AND l.agrid = a.keyid AND NVL (l.status,0) <> 1),'') AS police"
            + ", '' AS privils\n" + ",P.CELLULAR\n" + "FROM PATIENT p WHERE p.keyid = :PATIENT_ID")
            .setResultTransformer(Transformers.aliasToBean(Contract.class))
    //.addEntity(Contract.class)
    ;
    query.setParameter("PATIENT_ID", PATIENT_ID);
    //List<Object[]> result = null;
    List<Contract> result = null;
    try {
        result = query.list();
    } catch (Exception e) {
        logger.error(e.toString());
    }
    Contract contract = null;
    if (result != null && result.size() == 1) {
        logger.info("- ");
        return result.get(0);
        //for (Object[] row : result) {
        //  for (Contract row : result) {
        //contract = new Contract();
        //    try {
        //   contract = (Contract) row[0];
        // for (Object obj : row) {
        //   System.out.print(obj + "::");
        // }

        /*         int i = 0;
                
            contract.setKeyId(Integer.parseInt(row[i++].toString()));
            contract.setDoverennost(getRowValue(row[i++]));
            contract.setDoverennost2(getRowValue(row[i++]));
            contract.setDoverennost3(getRowValue(row[i++]));
            contract.setDoverennost4(getRowValue(row[i++]));
            contract.setLicense(getRowValue(row[i++]));
            contract.setLicense2(getRowValue(row[i++]));
            contract.setLicense3(getRowValue(row[i++]));
            contract.setLicense4(getRowValue(row[i++]));
            contract.setFio(getRowValue(row[i++]));
            contract.setFio2(getRowValue(row[i++]));
            contract.setFio3(getRowValue(row[i++]));
            contract.setFio4(getRowValue(row[i++]));
            contract.setFio5(getRowValue(row[i++]));
            contract.setFio6(getRowValue(row[i++]));
            contract.setPatnum(getRowValue(row[i++]));
            contract.setPatnum2(getRowValue(row[i++]));
            contract.setRegion1(getRowValue(row[i++]));
            contract.setAddress(getRowValue(row[i++]));
            contract.setAddress2(getRowValue(row[i++]));
            contract.setAddress3(getRowValue(row[i++]));
            contract.setAddress4(getRowValue(row[i++]));
            contract.setPhone(getRowValue(row[i++]));
            contract.setPhone2(getRowValue(row[i++]));
            contract.setSEX_NAME(getRowValue(row[i++]));
            contract.setRegistrator(getRowValue(row[i++]));
            contract.setREGISTRATOR2(getRowValue(row[i++]));
            contract.setREGISTRATOR3(getRowValue(row[i++]));
            contract.setREGISTRATOR4(getRowValue(row[i++]));
            contract.setREGISTRATOR5(getRowValue(row[i++]));
            contract.setBIRTH_DATE(getRowValue(row[i++]));
            contract.setCOMPANY(getRowValue(row[i++]));
            contract.setPOLICE(getRowValue(row[i++]));
            contract.setPRIVILS(getRowValue(row[i++]));
            contract.setCELLULAR(getRowValue(row[i++]));
            //System.out.println("\n");
            */
        //    } catch (Exception e) {
        //      logger.error(e.toString());
        //}

        // }
    } else {
        logger.info("  ");
    }
    return null;
}

From source file:bgroup.oracle.dao.HelpFioDaoImpl.java

@Override
public HelpFio getHelpFio(int PATIENT_ID) {
    Session session = getSession();/*w  w  w .  j a va  2  s .c om*/
    Query query = session.createSQLQuery("SELECT \n" + "       fn_pat_name_by_id(keyid) AS fio, \n"
            + "       fn_pat_name_by_id(keyid) AS fio2, \n" + "       fn_pat_name_by_id(keyid) AS fio3, \n"
            + "       fn_pat_name_by_id(keyid) AS fio5, \n"
            + "(SELECT text FROM lu WHERE keyid = 93116) AS \"license\",\n"
            + "       fn_pat_name_by_id(keyid) AS fio4,\n"
            + "\t/*fn_man_by_id (gsp_get_user_id()) AS registrator,*/\n" + "\tSex as pol,\n"
            + "\tNVL(snils, NULL ) AS snils,\n" + "\tNVL(snils, NULL ) AS snils1,\n"
            + "\ts_spravka_num.nextval AS N,\n" + "\ts_spravka_num.nextval AS N2,\n" + "       num AS PATNUM,\n"
            + "       TO_CHAR(SYSDATE,'dd.mm.yyyy') AS GIVEDATE,\n"
            + "       TO_CHAR(SYSDATE,'dd.mm.yyyy') AS GIVEDATE2\n"
            + "FROM patient WHERE keyid = :PATIENT_ID\n")
            .setResultTransformer(Transformers.aliasToBean(HelpFio.class));
    query.setParameter("PATIENT_ID", PATIENT_ID);
    //List<Object[]> result = null;
    List<HelpFio> result = null;
    try {
        result = query.list();
    } catch (Exception e) {
        logger.error(e.toString());
    }
    Contract contract = null;
    if (result != null && result.size() == 1) {
        return result.get(0);
    } else {
        logger.info("  ");
    }
    return null;
}

From source file:br.com.gerenciapessoal.repository.Lancamentos.java

@SuppressWarnings("UnusedAssignment")
public Map<Date, BigDecimal> valoresTotaisPorData(Integer numeroDeDias, Conta conta) {
    Session session = manager.unwrap(Session.class);

    Calendar dataInicial = Calendar.getInstance();
    dataInicial = DateUtils.truncate(dataInicial, Calendar.DAY_OF_MONTH);
    dataInicial.add(Calendar.DAY_OF_MONTH, numeroDeDias * -1);

    Map<Date, BigDecimal> resultado = criarMapaVazio(numeroDeDias, dataInicial);

    Criteria criteria = session.createCriteria(Lancamento.class).createAlias("conta", "c");

    criteria.setProjection(Projections.projectionList()
            .add(Projections.sqlGroupProjection("date(data_emissao) as data", "date(data_emissao)",
                    new String[] { "data" }, new Type[] { StandardBasicTypes.DATE }))
            .add(Projections.sum("valorLanca").as("valor")))
            .add(Restrictions.ge("dataEmissao", dataInicial.getTime()));

    if (conta != null) {
        criteria.add(Restrictions.eq("c.id", conta.getId()));
    }//from ww w  . jav a2 s . c om
    List<DataValor> valoresPorData = criteria.setResultTransformer(Transformers.aliasToBean(DataValor.class))
            .list();

    for (DataValor dataValor : valoresPorData) {
        resultado.put(dataValor.getData(), dataValor.getValor());
    }

    return resultado;
}

From source file:br.com.muranodesign.dao.impl.AlunoDAOImpl.java

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<Aluno> ListarNomeId() {
    Criteria criteria = getSession().createCriteria(Aluno.class);
    ProjectionList projList = Projections.projectionList();
    projList.add(Projections.property("idAluno"), "idAluno");
    projList.add(Projections.property("nome"), "nome");

    criteria.setProjection(projList);// w  w  w .  ja  v a2  s.  co  m

    criteria.setResultTransformer(Transformers.aliasToBean(Aluno.class));
    List<Aluno> results = criteria.list();

    return results;
}