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.scopix.periscope.securitymanagement.dao.SecurityManagementHibernateDAO.java

License:Open Source License

public List<PeriscopeUserDTO> getUserListMinimalInfo(Integer corporateId) {
    log.info("start");

    List<PeriscopeUserDTO> list = null;
    StringBuilder sql = new StringBuilder();
    sql.append(/*from  w  w w. j a v a  2  s . c  o m*/
            "select ID as userId, NAME as userName, EMAIL as email, FULL_NAME as fullName, JOB_POSITION as jobPosition");
    sql.append(" , MODIFICATION_DATE as modificationDate, START_DATE as startDate, PASSWORD as password");
    sql.append(" , MAIN_CORPORATE_ID as mainCorporateId, USER_STATE as userState");
    sql.append(" from");
    sql.append(" PERISCOPE_USER");
    sql.append(" where");
    sql.append(" MAIN_CORPORATE_ID = ").append(corporateId);
    sql.append(" and DELETED = false");

    list = this.getSession().createSQLQuery(sql.toString()).addScalar("userId").addScalar("userName")
            .addScalar("email").addScalar("fullName").addScalar("jobPosition").addScalar("modificationDate")
            .addScalar("startDate").addScalar("password").addScalar("mainCorporateId").addScalar("userState")
            .setResultTransformer(Transformers.aliasToBean(PeriscopeUserDTO.class)).list();

    log.info("end");
    return list;
}

From source file:com.scopix.periscope.securitymanagement.dao.SecurityManagementHibernateDAO.java

License:Open Source License

public List<StoreDTO> getStoresForCorporate(Integer corporateId, String userName) {
    log.info("start");
    List<StoreDTO> list = null;

    StringBuilder sql = new StringBuilder();
    sql.append("select s.ID as storeId, s.NAME as name, s.DESCRIPTION as description");
    sql.append(" from");
    sql.append(" CORPORATE c");
    sql.append(", STORE s");
    sql.append(", REL_PERISCOPE_USER_STORE rel");
    sql.append(", PERISCOPE_USER pu");
    sql.append(" where");
    sql.append(" c.ID = s.CORPORATE_ID");
    sql.append(" and s.ID = rel.STORE_ID");
    sql.append(" and rel.PERISCOPE_USER_ID = pu.ID");
    if (corporateId > 0) {
        sql.append(" and c.ID = ").append(corporateId);
    }// w ww.j  av  a  2s  .com
    sql.append(" and pu.NAME = '").append(userName).append("'");
    sql.append(" order by 3");
    list = this.getSession().createSQLQuery(sql.toString()).addScalar("storeId").addScalar("name")
            .addScalar("description").setResultTransformer(Transformers.aliasToBean(StoreDTO.class)).list();

    log.info("end");
    return list;
}

From source file:com.scopix.periscope.securitymanagement.dao.SecurityManagementHibernateDAO.java

License:Open Source License

public List<AreaTypeDTO> getAreaTypesForCorporate(Integer corporateId, String userName) {
    log.info("start");
    List<AreaTypeDTO> list = null;

    StringBuilder sql = new StringBuilder();
    sql.append("select at.ID as areaTypeId, at.NAME as name, at.DESCRIPTION as description");
    sql.append(" from");
    sql.append(" CORPORATE c");
    sql.append(", REL_PERISCOPE_USER_CORPORATE rel1");
    sql.append(", PERISCOPE_USER pu");
    sql.append(", REL_PERISCOPE_USER_AREA_TYPE rel2");
    sql.append(", AREA_TYPE at");
    sql.append(" where");
    sql.append(" c.ID = rel1.CORPORATE_ID");
    sql.append(" and rel1.PERISCOPE_USER_ID = pu.ID");
    sql.append(" and pu.ID = rel2.PERISCOPE_USER_ID");
    sql.append(" and rel2.AREA_TYPE_ID = at.ID");
    sql.append(" and c.ID = ").append(corporateId);
    sql.append(" and pu.NAME = '").append(userName).append("'");
    sql.append(" order by 3");

    list = this.getSession().createSQLQuery(sql.toString()).addScalar("areaTypeId").addScalar("name")
            .addScalar("description").setResultTransformer(Transformers.aliasToBean(AreaTypeDTO.class)).list();

    log.info("end");
    return list;//w ww  .  j a  va  2  s. co m
}

From source file:com.scopix.periscope.securitymanagement.dao.SecurityManagementHibernateDAO.java

License:Open Source License

public List<StoreDTO> getStoresForUser(String userName) {
    log.info("start");
    List<StoreDTO> list = null;

    StringBuilder sql = new StringBuilder();
    sql.append("select s.ID as storeId, s.NAME as name, s.DESCRIPTION as description");
    sql.append(" from");
    sql.append(" PERISCOPE_USER pu");
    sql.append(", REL_PERISCOPE_USER_STORE rel");
    sql.append(", STORE s");
    sql.append(" where");
    sql.append(" pu.ID = rel.PERISCOPE_USER_ID");
    sql.append(" and rel.STORE_ID = s.ID");
    sql.append(" and pu.NAME = '").append(userName).append("'");
    sql.append(" order by 3");

    list = this.getSession().createSQLQuery(sql.toString()).addScalar("storeId").addScalar("name")
            .addScalar("description").setResultTransformer(Transformers.aliasToBean(StoreDTO.class)).list();

    log.info("end");
    return list;/*from   w w w  .j av  a2  s.  co  m*/
}

From source file:com.scopix.periscope.securitymanagement.dao.SecurityManagementHibernateDAO.java

License:Open Source License

public List<AreaTypeDTO> getAreaTypesForUser(String userName) {
    log.info("start");
    List<AreaTypeDTO> list = null;

    StringBuilder sql = new StringBuilder();
    sql.append("select at.ID as areaTypeId, at.NAME as name, at.DESCRIPTION as description");
    sql.append(" from");
    sql.append(" PERISCOPE_USER pu");
    sql.append(", REL_PERISCOPE_USER_AREA_TYPE rel");
    sql.append(", AREA_TYPE at");
    sql.append(" where");
    sql.append(" pu.ID = rel.PERISCOPE_USER_ID");
    sql.append(" and rel.AREA_TYPE_ID = at.ID");
    sql.append(" and pu.NAME = '").append(userName).append("'");
    sql.append(" order by 3");

    list = this.getSession().createSQLQuery(sql.toString()).addScalar("areaTypeId").addScalar("name")
            .addScalar("description").setResultTransformer(Transformers.aliasToBean(AreaTypeDTO.class)).list();

    log.info("end");
    return list;/*  www  .  ja v  a 2  s .c  o m*/
}

From source file:com.scopix.periscope.securitymanagement.dao.UserLoginHibernateDAOImpl.java

License:Open Source License

@Override
public List<RolesGroupDTO> getRolesGroupForUser(String userName) {
    log.info("start");
    List<RolesGroupDTO> list = null;

    StringBuilder sql = new StringBuilder();
    sql.append("select rg.ID as rolesGroupId, rg.NAME as name, rg.DESCRIPTION as description");
    sql.append(" from");
    sql.append(" PERISCOPE_USER pu");
    sql.append(", REL_PERISCOPE_USER_ROLES_GROUP rel");
    sql.append(", ROLES_GROUP rg");
    sql.append(" where");
    sql.append(" pu.ID = rel.PERISCOPE_USER_ID");
    sql.append(" and rel.ROLES_GROUP_ID = rg.ID");
    sql.append(" and rg.DELETED = false");
    sql.append(" and pu.NAME = '").append(userName).append("'");
    sql.append(" order by 3");

    list = this.getSession().createSQLQuery(sql.toString()).addScalar("rolesGroupId").addScalar("name")
            .addScalar("description").setResultTransformer(Transformers.aliasToBean(RolesGroupDTO.class))
            .list();/*  www  .j ava 2  s.  c  o m*/

    log.info("end");
    return list;
}

From source file:com.scopix.periscope.subscription.dao.SubscriptionDAOImpl.java

License:Open Source License

@Override
public List<Subscription> getForUserNameSortedByCorporateIdAsc(String userName) {
    log.info("executing getAllByUserNameAndCorporateIdAsc()");
    StringBuilder sql = new StringBuilder();
    sql.append(/* w  w w.  ja va2 s. c o m*/
            "select DISTINCT sub.id as id, sub.operatorsGroupId as operatorsGroupId, sub.operatorQueuePriority as operatorQueuePriority");
    sql.append(" from Subscription sub, OperatorsGroup og join og.users user ");
    sql.append(" where ((sub.userName = '");
    sql.append(userName);
    sql.append("'");
    sql.append(")or ( sub.operatorsGroupId = og.id and user.userName ='");
    sql.append(userName);
    sql.append("'))");
    sql.append(" order by sub.operatorQueuePriority.priority asc");
    Session s = this.getSession();
    log.info("end()");
    Query query = s.createQuery(sql.toString());
    List<Subscription> sub = query.setResultTransformer(Transformers.aliasToBean(Subscription.class)).list();
    return sub;
}

From source file:com.scopix.periscope.subscription.dao.SubscriptionDAOImpl.java

License:Open Source License

@Override
public List<Subscription> getAllByGroupNameAndCorporateIdAsc(String groupName) {
    StringBuilder sql = new StringBuilder();
    sql.append(//from w  w  w .ja v  a2  s  .co m
            "select sub.id as id, sub.operatorsGroupId as operatorsGroupId, sub.operatorQueuePriority as operatorQueuePriority");
    sql.append(" from Subscription sub, OperatorsGroup og ");
    sql.append(" where sub.operatorsGroupId =og.id and og.groupName = '");
    sql.append(groupName);
    sql.append("'");
    sql.append(" order by sub.operatorQueuePriority.priority asc, og.groupName asc");
    Session s = this.getSession();
    log.info("end()");
    Query query = s.createQuery(sql.toString());
    List<Subscription> sub = query.setResultTransformer(Transformers.aliasToBean(Subscription.class)).list();
    return sub;
}

From source file:com.segundo.piso.daos.impl.DAOReportImpl.java

@Override
@Transactional//from w ww. j av  a2s  .  c  om
public List<ReporteAlumno> getStudentsByExpiredMovement(int clasesRestantes) {
    System.out.println(sessionFactory);
    StringBuilder restriction = new StringBuilder();
    restriction.append("date_add(movimiento1_.fecha_inicio, interval 31 day) > curdate() ").append(
            "and date_add(movimiento1_.fecha_inicio, interval 31 day) < date_add(current_date(), interval 10 day)")
            .append("and movimiento1_.id_movimiento = asistencia2_.id_movimiento ");

    return this.sessionFactory.getCurrentSession().createCriteria(Alumno.class, "alumno")
            .createAlias("alumno.movimientoList", "movimiento")
            .createAlias("alumno.asistenciaList", "asistencia").createAlias("movimiento.idEvento", "evento")
            .setProjection(Projections.projectionList().add(Projections.property("alumno.codigo"), "codigo")
                    .add(Projections.property("alumno.nombre"), "nombre")
                    .add(Projections.min("asistencia.diasRestantes"), "clasesRestantes")
                    .add(Projections.max("movimiento.idMovimiento"))
                    .add(Projections.property("alumno.idAlumno"), "idAlumno")
                    .add(Projections.max("movimiento.fechaInicio"), "fecha")
                    .add(Projections.groupProperty("alumno.idAlumno")))
            .add(Restrictions.sqlRestriction(restriction.toString()))
            .add(Restrictions.eq("movimiento.activo", true)).add(Restrictions.gt("evento.diasMes", 1))
            .setResultTransformer(Transformers.aliasToBean(ReporteAlumno.class))
            .addOrder(Order.desc("asistencia.diasRestantes")).list();
}

From source file:com.segundo.piso.daos.impl.DAOReportImpl.java

private ReporteMovimientosAlumno totalMovements(Criteria criteria) {
    ReporteMovimientosAlumno reporte = (ReporteMovimientosAlumno) criteria
            .setProjection(Projections.projectionList().add(Projections.sum("costo"), "totalCosto")
                    .add(Projections.sum("pago"), "total").add(Projections.sum("descuento"), "totalDescuento"))
            .setResultTransformer(Transformers.aliasToBean(ReporteMovimientosAlumno.class)).uniqueResult();

    return reporte;
}