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.segundo.piso.daos.impl.DAOReportImpl.java

@Override
@Transactional//from  w w  w.  ja va2  s. com
public List<ReporteClases> classesReport(Filters filters) {
    Criteria criteria = this.sessionFactory.getCurrentSession().createCriteria(Asistencia.class, "attendence")
            .createAlias("attendence.idClase", "clase").createAlias("attendence.idAlumno", "alumno")
            .setProjection(Projections.projectionList()
                    .add(Projections.distinct(Projections.property("attendence.idAlumno")), "alumno")
                    .add(Projections.property("attendence.idClase"), "clase"))
            .addOrder(Order.asc("clase.nombreClase")).addOrder(Order.asc("alumno.nombre"))
            .setResultTransformer(Transformers.aliasToBean(ReporteClases.class));
    addFilters(filters, criteria);

    return criteria.list();
}

From source file:com.sisrni.dao.BecaDao.java

public List<PojoBeca> getBecas(Integer idBecaSearch) {
    String query = "SELECT bec.ID_BECA idBeca,\n" + "  bec.ANIO_GESTION anioGestion,\n"
            + "  prb.NOMBRE_PROGRAMA as programaBeca,\n" + "  per.NOMBRE_PERSONA nombreBecario,\n"
            + "  per.APELLIDO_PERSONA apellidoBecario,\n" + "  per.EMAIL_PERSONA correoBecario,\n"
            + "  fac.NOMBRE_FACULTAD facultad,\n"
            + "pai.NOMBRE_PAIS paisDestino, org.NOMBRE_ORGANISMO universidadDestino, bec.MONTO_TOTAL montoBeca,IF(bec.OTORGADA = 1, 'SI','NO') as  otorgada\n"
            + "FROM BECA bec\n" + "INNER JOIN PROGRAMA_BECA prb\n"
            + "ON bec.ID_PROGRAMA_BECA = prb.ID_PROGRAMA\n" + "INNER JOIN PERSONA_BECA peb\n"
            + "ON bec.ID_BECA = peb.ID_BECA\n" + "INNER JOIN PERSONA per\n"
            + "ON peb.ID_PERSONA = per.ID_PERSONA\n" + "  INNER JOIN CARRERA ca\n"
            + "  ON per.ID_CARRERA = ca.ID_CARRERA\n" + "  INNER JOIN FACULTAD fac\n"
            + "  ON ca.ID_FACULTAD = fac.ID_FACULTAD\n" + "INNER JOIN ORGANISMO org\n"
            + "  ON bec.ID_UNIVERSIDAD = org.ID_ORGANISMO\n" + "INNER JOIN PAIS pai\n"
            + "ON bec.ID_PAIS_DESTINO = pai.ID_PAIS\n" + "WHERE peb.ID_TIPO_PERSONA=6";
    if (idBecaSearch > 0) {
        query = query + " AND bec.ID_BECA=" + idBecaSearch;
    }/*from w  ww  .jav a 2 s  .  c  om*/
    query += " ORDER BY bec.ID_BECA DESC";
    try {
        Query q = getSessionFactory().getCurrentSession().createSQLQuery(query)
                .addScalar("idBeca", new IntegerType()).addScalar("anioGestion", new IntegerType())
                .addScalar("programaBeca", new StringType()).addScalar("nombreBecario", new StringType())
                .addScalar("apellidoBecario", new StringType()).addScalar("correoBecario", new StringType())
                .addScalar("facultad", new StringType()).addScalar("paisDestino", new StringType())
                .addScalar("universidadDestino", new StringType()).addScalar("montoBeca", new DoubleType())
                .addScalar("otorgada", new StringType())
                .setResultTransformer(Transformers.aliasToBean(PojoBeca.class));

        return q.list();

    } catch (Exception e) {
        e.printStackTrace();
    }
    return null;
}

From source file:com.sisrni.dao.BecaDao.java

public List<BecasGestionadasPojo> getDataBecasGestionadasReportes(Integer desde, Integer hasta) {
    String query = "SELECT b.ANIO_GESTION anio, count(*) gestionadas,\n"
            + "  sum(if(b.OTORGADA=1,1,0)) becasOtorgadas,\n" + "  sum(if(b.OTORGADA=0,1,0)) becasDenegadas,\n"
            + "  sum(if(OTORGADA=1,b.MONTO_TOTAL,0.00)) montoOtorgadas\n"
            + "FROM  BECA b WHERE b.ANIO_GESTION BETWEEN " + desde + " AND " + hasta + " \n"
            + "GROUP BY b.ANIO_GESTION ORDER BY b.ANIO_GESTION asc";
    Query q = getSessionFactory().getCurrentSession().createSQLQuery(query).addScalar("anio", new IntegerType())
            .addScalar("gestionadas", new IntegerType()).addScalar("becasOtorgadas", new IntegerType())
            .addScalar("montoOtorgadas", new DoubleType()).addScalar("becasDenegadas", new IntegerType())
            .setResultTransformer(Transformers.aliasToBean(BecasGestionadasPojo.class));
    return q.list();
}

From source file:com.sisrni.dao.BecaDao.java

public List<BecasGestionadasPojo> getDataBecasGestionadasGroupPaisDestino(Integer desde, Integer hasta) {
    String query = "select p.NOMBRE_PAIS nombrePais,count(b.ID_BECA) gestionadas,\n"
            + "(SELECT COUNT(i.ID_BECA) FROM beca i WHERE i.OTORGADA=1 and i.ID_PAIS_DESTINO=b.ID_PAIS_DESTINO) becasOtorgadas,\n"
            + "(SELECT SUM(a.MONTO_TOTAL) FROM beca a WHERE a.OTORGADA=1 and a.ID_PAIS_DESTINO=b.ID_PAIS_DESTINO) montoOtorgadas,\n"
            + "(SELECT COUNT(c.ID_BECA) FROM beca c WHERE c.OTORGADA=0 and c.ID_PAIS_DESTINO=b.ID_PAIS_DESTINO) becasDenegadas,\n"
            + "(SELECT SUM(r.MONTO_TOTAL) FROM beca r WHERE r.OTORGADA=0 and r.ID_PAIS_DESTINO=b.ID_PAIS_DESTINO) montoDenegadas\n"
            + "from BECA b INNER JOIN PAIS p ON b.ID_PAIS_DESTINO=p.ID_PAIS\n" + "WHERE b.ANIO_GESTION BETWEEN "
            + desde + " and " + hasta + "\n" + "GROUP BY b.ID_PAIS_DESTINO ORDER BY b.ID_PAIS_DESTINO asc";

    Query q = getSessionFactory().getCurrentSession().createSQLQuery(query)
            .addScalar("nombrePais", new StringType()).addScalar("gestionadas", new IntegerType())
            .addScalar("becasOtorgadas", new IntegerType()).addScalar("montoOtorgadas", new DoubleType())
            .addScalar("becasDenegadas", new IntegerType()).addScalar("montoDenegadas", new DoubleType())
            .setResultTransformer(Transformers.aliasToBean(BecasGestionadasPojo.class));
    return q.list();
}

From source file:com.sisrni.dao.BecaDao.java

public List<BecasGestionadasPojo> getDataBecasGestionadasGroupFacultad(Integer desde, Integer hasta) {
    String query = "SELECT f.NOMBRE_FACULTAD nombreFacultad, count(*) gestionadas,\n"
            + "SUM(if(b.OTORGADA=0,1,0)) becasDenegadas,\n"
            + "       SUM(if(b.OTORGADA=1,1,0)) becasOtorgadas,\n"
            + "       SUM(if(b.OTORGADA=1,b.MONTO_TOTAL,0)) montoOtorgadas\n" + "from BECA b\n"
            + "INNER JOIN PERSONA_BECA pb ON b.ID_BECA = pb.ID_BECA\n"
            + "INNER JOIN PERSONA p ON pb.ID_PERSONA = p.ID_PERSONA\n"
            + "INNER JOIN CARRERA c ON p.ID_CARRERA = c.ID_CARRERA\n"
            + "INNER JOIN FACULTAD f ON c.ID_FACULTAD = f.ID_FACULTAD\n" + "WHERE b.ANIO_GESTION BETWEEN "
            + desde + " AND " + hasta + "\n" + "GROUP BY f.ID_FACULTAD ORDER BY f.NOMBRE_FACULTAD ASC";

    Query q = getSessionFactory().getCurrentSession().createSQLQuery(query)
            .addScalar("nombreFacultad", new StringType()).addScalar("gestionadas", new IntegerType())
            .addScalar("becasOtorgadas", new IntegerType()).addScalar("montoOtorgadas", new DoubleType())
            .addScalar("becasDenegadas", new IntegerType())
            .setResultTransformer(Transformers.aliasToBean(BecasGestionadasPojo.class));
    return q.list();
}

From source file:com.sisrni.dao.BecaDao.java

public List<RptDetalleBecasPojo> getDetalleBecas(Integer desde, Integer hasta) {
    String query = "SELECT  p.NOMBRE_PERSONA nombre, p.APELLIDO_PERSONA apellido, f.NOMBRE_FACULTAD facultad,pro.NOMBRE_PROGRAMA programaBeca,b.ANIO_GESTION anio, x.NOMBRE_PAIS paisDestino,\n"
            + "org.NOMBRE_ORGANISMO universidadDestino,b.MONTO_TOTAL montoBeca\n"
            + "from BECA b INNER JOIN PERSONA_BECA pb ON b.ID_BECA = pb.ID_BECA\n"
            + "INNER JOIN PERSONA p ON pb.ID_PERSONA = p.ID_PERSONA\n"
            + "INNER JOIN CARRERA c ON p.ID_CARRERA = c.ID_CARRERA\n"
            + "INNER JOIN FACULTAD f ON c.ID_FACULTAD = f.ID_FACULTAD\n"
            + "INNER JOIN PROGRAMA_BECA pro ON b.ID_PROGRAMA_BECA = pro.ID_PROGRAMA\n"
            + "INNER JOIN ORGANISMO org ON b.ID_UNIVERSIDAD = org.ID_ORGANISMO\n"
            + "INNER JOIN PAIS x ON org.ID_PAIS= x.ID_PAIS\n"
            + "WHERE pb.ID_TIPO_PERSONA = 6 AND b.OTORGADA=1\n" + "AND b.ANIO_GESTION BETWEEN " + desde
            + " AND " + hasta + "\n" + "ORDER BY p.NOMBRE_PERSONA,p.APELLIDO_PERSONA, b.ANIO_GESTION desc";

    Query q = getSessionFactory().getCurrentSession().createSQLQuery(query)
            .addScalar("nombre", new StringType()).addScalar("apellido", new StringType())
            .addScalar("facultad", new StringType()).addScalar("programaBeca", new StringType())
            .addScalar("anio", new IntegerType()).addScalar("paisDestino", new StringType())
            .addScalar("universidadDestino", new StringType()).addScalar("montoBeca", new DoubleType())
            .setResultTransformer(Transformers.aliasToBean(RptDetalleBecasPojo.class));
    return q.list();
}

From source file:com.sisrni.dao.BecaDao.java

public List<BecasGestionadasPojo> getDataBecasGestionadasGroupOrganismos(Integer desde, Integer hasta) {
    String query = "SELECT o.NOMBRE_ORGANISMO organismo, count(*) gestionadas,\n"
            + "  SUM(if(b.OTORGADA=1,1,0)) becasOtorgadas,\n" + "  SUM(if(b.OTORGADA=0,1,0)) becasDenegadas,\n"
            + "    SUM(if(b.OTORGADA=1,b.MONTO_TOTAL,0)) montoOtorgadas\n"
            + "FROM BECA b INNER JOIN ORGANISMO o\n" + "ON b.ID_ORGANISMO_COOPERANTE = o.ID_ORGANISMO\n"
            + "WHERE\n" + " b.ANIO_GESTION BETWEEN " + desde + " AND " + hasta + "\n"
            + " GROUP BY b.ID_ORGANISMO_COOPERANTE";

    Query q = getSessionFactory().getCurrentSession().createSQLQuery(query)
            .addScalar("organismo", new StringType()).addScalar("gestionadas", new IntegerType())
            .addScalar("becasOtorgadas", new IntegerType()).addScalar("montoOtorgadas", new DoubleType())
            .addScalar("becasDenegadas", new IntegerType())
            .setResultTransformer(Transformers.aliasToBean(BecasGestionadasPojo.class));
    return q.list();

}

From source file:com.sisrni.dao.BecaDao.java

public List<PojoMapaInteractivoBecas> getBecastListToCharts(List<String> paisSelected,
        List<String> tipoBecaSelected, String desde, String hasta) {
    String wherePais = "";
    String whereTipoBeca = "";
    String groupBy = " GROUP BY b.ID_PAIS_DESTINO";
    String limite = "";
    List<String> paisesFinales = new ArrayList<String>();

    if (paisSelected.size() > 0) {
        wherePais = wherePais + " AND pa.ID_PAIS IN (" + String.join(",", paisSelected) + ")";
    } else {//from w w w  . j av  a  2  s .  c  om
        limite += " LIMIT 5";
    }

    if (tipoBecaSelected.size() > 0) {
        whereTipoBeca += " AND b.ID_TIPO_BECA IN (" + String.join(",", tipoBecaSelected) + ")";
    }

    String query = "SELECT pa.ID_PAIS idPais,\n" + "  pa.CODIGO_PAIS codigoPais,\n"
            + "  pa.NOMBRE_PAIS nombrePais,\n" + "  COUNT(b.ID_BECA) cantidadBecas,\n"
            + "  SUM(b.MONTO_TOTAL) montoCooperacion\n"
            + "FROM BECA b INNER  JOIN PAIS pa   ON b.ID_PAIS_DESTINO= pa.ID_PAIS\n"
            + "WHERE b.OTORGADA=1 AND b.ANIO_GESTION BETWEEN " + Integer.parseInt(desde) + " AND "
            + Integer.parseInt(hasta) + "\n" + wherePais + whereTipoBeca + groupBy;//
    try {
        Query q = getSessionFactory().getCurrentSession().createSQLQuery(query)
                .addScalar("idPais", new IntegerType()).addScalar("codigoPais", new StringType())
                .addScalar("nombrePais", new StringType()).addScalar("montoCooperacion", new DoubleType())
                .addScalar("cantidadBecas", new IntegerType())
                .setResultTransformer(Transformers.aliasToBean(PojoMapaInteractivoBecas.class));

        List<PojoMapaInteractivoBecas> listPojos = q.list();

        if (listPojos.size() > 0) {
            for (PojoMapaInteractivoBecas pj : listPojos) {
                paisesFinales.add(pj.getIdPais() + "");
            }
            String qt = "SELECT  tb.ID_TIPO_BECA idTipoBeca,\n" + "  tb.NOMBRE_TIPO_BECA nombreTipoBeca,\n"
                    + "  count(b.ID_BECA) cantidad\n" + "from BECA b INNER JOIN TIPO_BECA tb\n"
                    + "ON b.ID_TIPO_BECA = tb.ID_TIPO_BECA\n" + "WHERE b.ANIO_GESTION BETWEEN "
                    + Integer.parseInt(desde) + " AND " + Integer.parseInt(hasta) + "\n"
                    + "  AND b.ID_PAIS_DESTINO IN (" + String.join(",", paisesFinales) + ")\n"
                    + "AND b.ID_TIPO_BECA IN (" + String.join(",", tipoBecaSelected) + ")\n"
                    + "      AND b.OTORGADA=1\n" + "GROUP BY b.ID_TIPO_BECA";
            Query rtp = getSessionFactory().getCurrentSession().createSQLQuery(qt)
                    .addScalar("idTipoBeca", new IntegerType()).addScalar("nombreTipoBeca", new StringType())
                    .addScalar("cantidad", new IntegerType())
                    .setResultTransformer(Transformers.aliasToBean(PojoBecasByTipo.class));
            List<PojoBecasByTipo> listTipos = rtp.list();

            for (PojoMapaInteractivoBecas pj : listPojos) {
                String qp = "SELECT * FROM BECA pr \n" + " WHERE pr.ANIO_GESTION BETWEEN "
                        + Integer.parseInt(desde) + " AND " + Integer.parseInt(hasta) + "\n"
                        + "AND pr.OTORGADA=1 AND pr.ID_PAIS_DESTINO=" + pj.getIdPais();

                //String qp = "from Proyect pr Where pr.idPaisCooperante='" + pj.getCodigoPais() + "' and pr.idTipoProyecto in (" + String.join(",", tipoProyectoSelected) + ") and pr.anioGestion between " + Integer.parseInt(desde) + " AND " + Integer.parseInt(hasta);
                Query r = getSessionFactory().getCurrentSession().createSQLQuery(qp).addEntity(Beca.class);
                pj.setBecastList(r.list());
                pj.setSeries(listTipos);
            }
        }
        return listPojos;
    } catch (Exception e) {
        e.printStackTrace();
    }
    return null;
}

From source file:com.sisrni.dao.MovilidadDao.java

public List<PojoMovilidadAdm> getMovilidadAdm(Integer idMovSearch) {
    String query = "SELECT mv.ID_MOVILIDAD idMovilidad, pm.NOMBRE_PROGRAMA_MOVILIDAD nombrePrograma,per.NOMBRE_PERSONA nombrePersona,per.APELLIDO_PERSONA apellidoPersona,tpmv.NOMBRE_TIPO_MOVILIDAD nombreTipoMovilidad,pa.NOMBRE_PAIS paisOrigen, pai.NOMBRE_PAIS paisDestino,mv.FECHA_INICIO fechaEntrada,mv.FECHA_FIN fechaSalida ,etm.NOMBRE_ETAPA nombreEtapa  \n"
            + "FROM MOVILIDAD mv INNER JOIN PROGRAMA_MOVILIDAD pm ON mv.ID_PROGRAMA_MOVILIDAD = pm.ID_PROGRAMA_MOVILIDAD\n"
            + "INNER JOIN PERSONA_MOVILIDAD prmov  ON mv.ID_MOVILIDAD =prmov.ID_MOVILIDAD\n"
            + "INNER JOIN PERSONA per  ON prmov.ID_PERSONA = per.ID_PERSONA\n"
            + "INNER JOIN TIPO_MOVILIDAD tpmv ON mv.ID_TIPO_MOVILIDAD = tpmv.ID_TIPO_MOVILIDAD\n"
            + "INNER JOIN PAIS pa ON mv.ID_PAIS_ORIGEN = pa.ID_PAIS\n"
            + "INNER JOIN PAIS pai ON mv.ID_PAIS_DESTINO = pai.ID_PAIS "
            + "INNER JOIN ETAPA_MOVILIDAD etm ON mv.ID_ETAPA_MOVILIDAD = etm.ID_ETAPA   \n"
            + "WHERE prmov.ID_TIPO_PERSONA = 10  ";
    if (idMovSearch > 0) {
        query = query + " AND mv.ID_MOVILIDAD =" + idMovSearch;
    }/*from w  w w.  j  av a 2 s .  c o m*/
    //query = query + " ORDER BY mv.FECHA_INGRESO DESC";
    query = query + "ORDER BY mv.ID_MOVILIDAD DESC";
    try {
        Query q = getSessionFactory().getCurrentSession().createSQLQuery(query)
                .addScalar("idMovilidad", new IntegerType()).addScalar("nombrePrograma", new StringType())
                .addScalar("nombrePersona", new StringType()).addScalar("apellidoPersona", new StringType())
                .addScalar("nombreTipoMovilidad", new StringType()).addScalar("paisOrigen", new StringType())
                .addScalar("paisDestino", new StringType()).addScalar("fechaEntrada", new DateType())
                .addScalar("fechaSalida", new DateType()).addScalar("nombreEtapa", new StringType())
                .setResultTransformer(Transformers.aliasToBean(PojoMovilidadAdm.class));

        return q.list();
    } catch (Exception e) {
        e.printStackTrace();
    }
    return null;
}

From source file:com.sisrni.dao.MovilidadDao.java

public List<RptMovilidadesSegunEtapaPojo> getCantidadMovilidadesSegunEtapa(Integer anio) {
    String query = "SELECT tm.NOMBRE_TIPO_MOVILIDAD nombreMovilidad, COUNT(mv.ID_MOVILIDAD) cantidad  \n"
            + "FROM MOVILIDAD mv INNER JOIN TIPO_MOVILIDAD tm ON mv.ID_TIPO_MOVILIDAD = tm.ID_TIPO_MOVILIDAD   \n"
            + "WHERE mv.ID_ETAPA_MOVILIDAD =3 AND YEAR(mv.FECHA_INICIO)= " + anio
            + " GROUP BY tm.NOMBRE_TIPO_MOVILIDAD \n" + "UNION \n"
            + "SELECT eta.NOMBRE_ETAPA , COUNT(mov.ID_MOVILIDAD) \n"
            + "FROM MOVILIDAD mov INNER JOIN ETAPA_MOVILIDAD eta ON mov.ID_ETAPA_MOVILIDAD = eta.ID_ETAPA \n"
            + "WHERE (mov.ID_ETAPA_MOVILIDAD =3 OR mov.ID_ETAPA_MOVILIDAD =4)  AND  YEAR(mov.FECHA_INICIO)= "
            + anio + " \n" + "GROUP BY eta.NOMBRE_ETAPA ";

    try {/*from   ww  w  .j  a v a2  s  .  co  m*/
        Query q = getSessionFactory().getCurrentSession().createSQLQuery(query)
                .addScalar("nombreMovilidad", new StringType()).addScalar("cantidad", new IntegerType())
                .setResultTransformer(Transformers.aliasToBean(RptMovilidadesSegunEtapaPojo.class));

        return q.list();
    } catch (Exception e) {
        e.printStackTrace();
    }
    return null;
}