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.SCI.centraltoko.implement.LaporanImp.java

@Override
public JasperPrint getMounthReportPenjualan(Date date) {

    try {//from  w ww  .  ja  v a2  s  .c o  m
        List<MonthPembelianReport> pembelianReports = sessionFactory.getCurrentSession()
                .createQuery("select s.produk.nama as namaProduk,"
                        + " sum(s.jumlah) as quantity, sum(s.subTotal) as subTotal from PembelianDetail s "
                        + " where month(s.pembelian.tgl_beli)=month(:date)"
                        + "group by s.produk.nama order by s.produk.nama ")
                .setParameter("date", date)
                .setResultTransformer(Transformers.aliasToBean(MonthPembelianReport.class)).list();
        InputStream is = LaporanImp.class.getResourceAsStream("/reports/monthPembelianReport.jasper");
        @SuppressWarnings("Convert2Diamond")
        Map<String, Object> parameter = new HashMap<String, Object>();
        parameter.put("date", date);

        return JasperFillManager.fillReport(is, parameter, new JRBeanCollectionDataSource(pembelianReports));
    } catch (JRException exception) {
        log.error("Error generated monthPembelianReport", exception);
    }
    return null;
}

From source file:com.scopix.periscope.businesswarehouse.transfer.dao.TransferHibernateDAO.java

License:Open Source License

public List<Proof> getProofList(Set<Integer> proofIds) {
    log.info("start");
    List<Proof> proofs = null;
    String proofsIdsStr = StringUtils.join(proofIds, ",");

    StringBuilder hql = new StringBuilder();

    hql.append("select");
    hql.append(" p.id as id,");
    hql.append(" p.pathWithMarks as pathWithMarks,");
    hql.append(" p.pathWithoutMarks as pathWithoutMarks,");
    hql.append(" p.proofDate as proofDate,");
    hql.append(" p.sentToMIS as sentToMIS,");
    hql.append(" p.sentToMISData as sentToMISData");
    hql.append(" from Proof p");
    hql.append(" where");
    hql.append(" p.id in (").append(proofsIdsStr).append(")");

    proofs = this.getSession().createQuery(hql.toString())
            .setResultTransformer(Transformers.aliasToBean(Proof.class)).list();

    log.debug("proofs size: " + proofs.size());
    log.info("end");
    return proofs;
}

From source file:com.scopix.periscope.converter.dao.VideoConverterHibernateDAOImpl.java

License:Open Source License

/**
 * Consulta registros de los videos pendientes de conversin
 * //from w  w  w  .  j a v  a2  s  .c o m
 * @author carlos polo
 * @date 21-ago-2013
 * @return List<Video> lista de videos pendientes de conversin (en caso de existir)
 * @throws ScopixException excepcin durante la consulta de registros
 */
@Override
@SuppressWarnings("unchecked")
public List<Video> getPendingVideos() throws ScopixException {
    log.info("start");
    List<Video> videoList = null;

    try {
        StringBuilder sql = new StringBuilder();
        sql.append("SELECT id as id, path_original as pathOriginal, "
                + "path_convertido as pathConvertido, estado as estado, fecha_solicitud as fechaSolicitud, "
                + "fecha_conversion as fechaConversion, url_notificacion as urlNotificacion, evidence_file_id as evidenceFileId ");
        sql.append("FROM video ");
        sql.append("WHERE estado = 'P'");

        videoList = this.getSession().createSQLQuery(sql.toString()).addScalar("id").addScalar("pathOriginal")
                .addScalar("pathConvertido").addScalar("estado").addScalar("fechaSolicitud")
                .addScalar("fechaConversion").addScalar("urlNotificacion").addScalar("evidenceFileId")
                .setResultTransformer(Transformers.aliasToBean(Video.class)).list();

    } catch (HibernateException hibernateException) {
        throw new ScopixException(hibernateException.getMessage(), hibernateException);
    }

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

From source file:com.scopix.periscope.corporatestructuremanagement.dao.CorporateStructureManagementHibernateDAOImpl.java

License:Open Source License

@Override
public List<EvidenceExtractionServicesServerDTO> getEvidenceExtractionServicesServerListForStores(
        List<String> stores) {
    log.info("start");
    List<EvidenceExtractionServicesServerDTO> list = null;
    StringBuilder sql = new StringBuilder();
    sql.append("select eess.id as idAtBusinessServices, eess.name as name, eess.ssh_address as sshAddress, ");
    sql.append(" eess.ssh_local_tunnel_port as sshLocalTunnelPort, eess.ssh_password as sshPassword,");
    sql.append(" eess.ssh_port as sshPort, eess.ssh_remote_tunnel_port as sshRemoteTunnelPort, ");
    sql.append(" eess.ssh_user as sshUser, eess.url as url, eess.evidence_services_server_id as serverId,");
    sql.append(" eess.use_tunnel as useTunnel");
    sql.append(" from evidence_extraction_services_server eess, place p");
    sql.append(" where p.evidence_extraction_services_server_id = eess.id and p.name in ('");
    sql.append(StringUtils.join(stores, "','")).append("')");

    Session session = this.getSession();
    list = session.createSQLQuery(sql.toString()).addScalar("idAtBusinessServices").addScalar("name")
            .addScalar("sshAddress").addScalar("sshLocalTunnelPort").addScalar("sshPassword")
            .addScalar("sshPort").addScalar("sshRemoteTunnelPort").addScalar("sshUser").addScalar("url")
            .addScalar("serverId").addScalar("useTunnel")
            .setResultTransformer(Transformers.aliasToBean(EvidenceExtractionServicesServerDTO.class)).list();

    log.info("end");
    return list;/*from  w  w  w. j  av a 2s  . c  o  m*/
}

From source file:com.scopix.periscope.corporatestructuremanagement.dao.CorporateStructureManagementHibernateDAOImpl.java

License:Open Source License

/**
 * Obtain all actives evidence request for a particular store
 *
 * @param storeId//www .j  a  va 2  s .  c  o  m
 * @return
 */
@Override
public List<? extends EvidenceRequest> getActiveEvidenceRequests(Integer storeId) {
    List<? extends EvidenceRequest> evidenceRequests = null;
    StringBuilder sbHql = new StringBuilder();
    sbHql.append("select ");
    sbHql.append("   er.id as id, ");
    sbHql.append("   er.evidenceTime as evidenceTime, ");
    sbHql.append("   er.duration as duration, ");
    sbHql.append("   er.type as type, ");
    sbHql.append("   er.evidenceProvider as evidenceProvider, ");
    sbHql.append("   er.day as day, ");
    sbHql.append("   er.evidenceRequestType as evidenceRequestType, ");
    sbHql.append("   er.priorization ");
    sbHql.append(" from ");
    sbHql.append("   EvidenceRequest er, ");
    sbHql.append("   ExtractionPlanCustomizing epc, ");
    sbHql.append("   ExtractionPlanRange epr, ");
    sbHql.append("   ExtractionPlanRangeDetail eprd, ");
    sbHql.append("   SituationTemplate st ");
    sbHql.append("where ");
    sbHql.append("   epc.store.id = ").append(storeId).append(" and ");
    sbHql.append("   epc.active = true and ");
    sbHql.append("   epr.extractionPlanCustomizing.id = epc.id and ");
    sbHql.append("   eprd.extractionPlanRange.id = epr.id and ");
    sbHql.append("   er.extractionPlanRangeDetail.id = eprd.id and ");
    sbHql.append("   epc.situationTemplate.id = st.id and  ");
    sbHql.append("   st.active = true");
    evidenceRequests = this.getSession().createQuery(sbHql.toString())
            .setResultTransformer(Transformers.aliasToBean(EvidenceRequest.class)).list();

    return evidenceRequests;
}

From source file:com.scopix.periscope.corporatestructuremanagement.dao.CorporateStructureManagementHibernateDAOImpl.java

License:Open Source License

@Override
public List<EvidenceRequestDTO> getActiveEvidenceRequestDTOs(Integer storeId) throws ScopixException {
    List<EvidenceRequestDTO> evidenceRequestDTOs = new ArrayList<EvidenceRequestDTO>();
    StringBuilder sbHql = new StringBuilder();
    sbHql.append("select ");
    sbHql.append("   er.id as businessServicesRequestId, ");
    sbHql.append("   er.evidenceProvider.id as deviceId, ");
    sbHql.append("   er.evidenceTime as requestedTime, ");
    sbHql.append("   er.day as dayOfWeek, ");
    sbHql.append("   '{v}' as requestType, ");
    sbHql.append("   er.duration as duration,");
    sbHql.append("   er.priorization as priorization,");
    sbHql.append("   st.live as live");
    sbHql.append(" from ");
    sbHql.append("   EvidenceRequest er,");
    sbHql.append("   ExtractionPlanCustomizing epc, ");
    sbHql.append("   ExtractionPlanRange epr, ");
    sbHql.append("   ExtractionPlanRangeDetail eprd , ");
    sbHql.append("   SituationTemplate st ");
    sbHql.append("where ");
    sbHql.append("   epc.store.id = ").append(storeId).append(" and ");
    sbHql.append("   epc.active = true and ");
    sbHql.append("   epr.extractionPlanCustomizing.id = epc.id and ");
    sbHql.append("   eprd.extractionPlanRange.id = epr.id and ");
    sbHql.append("   er.extractionPlanRangeDetail.id = eprd.id and ");
    sbHql.append("   epc.situationTemplate.id = st.id and  ");
    sbHql.append("   st.active = true and ");
    sbHql.append("   er.type = :type1 ");

    for (EvidenceType type : EvidenceType.values()) {
        String classTextConvert = getClassConvert(type);
        String s = StringUtils.replace(sbHql.toString(), "{v}", classTextConvert);
        Query q = this.getSession().createQuery(s);
        q.setParameter("type1", type);
        evidenceRequestDTOs/*from  w  ww . j  a  v  a  2s. c  o m*/
                .addAll(q.setResultTransformer(Transformers.aliasToBean(EvidenceRequestDTO.class)).list());
    }

    // evidenceRequestDTOs = this.getSession().createQuery(sbHql.toString()).
    // setResultTransformer(Transformers.aliasToBean(EvidenceRequestDTO.class)).list();
    return evidenceRequestDTOs;
}

From source file:com.scopix.periscope.extractionplanmanagement.dao.ExtractionPlanCustomizingDAOImpl.java

License:Open Source License

@Override
public List<ExtractionPlanRange> getExtractionPlanRanges(ExtractionPlanCustomizing extractionPlanCustomizing)
        throws ScopixException {
    if (extractionPlanCustomizing == null) {
        throw new ScopixException("PENDING revisar mensaje");
    }/* w  w  w . j av a2 s  .  c  om*/
    Session session = this.getSession();
    List<ExtractionPlanRange> planRanges = null;
    try {
        StringBuilder hql = new StringBuilder();
        hql.append("select epr.id as id, ");
        hql.append(" epr.initialTime as initialTime, epr.endTime as endTime, epr.samples as samples, ");
        hql.append(" epr.frecuency as frecuency, ");
        hql.append(" epr.duration as duration, epr.dayOfWeek as dayOfWeek, ");
        hql.append(" epr.extractionPlanRangeType as extractionPlanRangeType ");
        hql.append(" from ExtractionPlanRange epr ");
        hql.append(" where epr.extractionPlanCustomizing.id = ").append(extractionPlanCustomizing.getId());
        hql.append(" order by epr.dayOfWeek desc, epr.initialTime desc");
        planRanges = session.createQuery(hql.toString())
                .setResultTransformer(Transformers.aliasToBean(ExtractionPlanRange.class)).list();

        //        Criteria criteria = this.getSession().createCriteria(ExtractionPlanRange.class);
        //        criteria.addOrder(Order.asc("dayOfWeek"));
        //        criteria.addOrder(Order.asc("initialTime"));
        //        criteria.add(Restrictions.eq("extractionPlanCustomizing.id", extractionPlanCustomizing.getId()));
        //        planRanges = criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY).list();
    } catch (HibernateException e) {
        log.error(e, e);
    } finally {
        this.releaseSession(session);
    }
    return planRanges;
}

From source file:com.scopix.periscope.extractionplanmanagement.dao.ExtractionPlanCustomizingDAOImpl.java

License:Open Source License

@Override
public List<ExtractionPlanRangeDetail> getExtractionPlanRangeDetails(ExtractionPlanRange extractionPlanRange)
        throws ScopixException {
    if (extractionPlanRange == null) {
        throw new ScopixException("PENDING revisar mensaje");
    }//from  ww w .j  a va2 s  . c om
    Session session = this.getSession();
    List<ExtractionPlanRangeDetail> details = null;
    try {
        StringBuilder hql = new StringBuilder();
        hql.append(
                "select eprd.id as id, eprd.timeSample as timeSample, eprd.extractionPlanRange as extractionPlanRange");
        hql.append(" from ExtractionPlanRangeDetail eprd ");
        hql.append(" where eprd.extractionPlanRange.id = ").append(extractionPlanRange.getId());
        hql.append(" order by eprd.timeSample");
        details = session.createQuery(hql.toString())
                .setResultTransformer(Transformers.aliasToBean(ExtractionPlanRangeDetail.class)).list();
        //        Criteria criteria = this.getSession().createCriteria(ExtractionPlanRangeDetail.class);
        //        criteria.addOrder(Order.asc("timeSample"));
        //        criteria.add(Restrictions.eq("extractionPlanRange.id", extractionPlanRange.getId()));
        //        details = criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY).list();
    } catch (HibernateException e) {
        log.error(e, e);
    } finally {
        this.releaseSession(session);
    }
    return details;
}

From source file:com.scopix.periscope.qualitycontrol.dao.QualityControlHibernateDAOImpl.java

License:Open Source License

@Override
public List<ProofDTO> getProofPerEvidenceEvaluation(int evidenceEvaluationId) throws ScopixException {
    log.debug("start");
    List<ProofDTO> proofDTOs = null;
    try {/*w  w  w. j ava 2 s.co  m*/
        StringBuilder hql = new StringBuilder();
        hql.append("SELECT DISTINCT ");
        hql.append("p.pathWithMarks AS pathWithMarks, ");
        hql.append("p.pathWithoutMarks AS pathWithoutMarks, ");
        hql.append("p.proofOrder AS order ");
        hql.append("FROM ");
        hql.append("Proof p ");
        hql.append("WHERE ");
        hql.append("p.evidenceEvaluation.id = ");
        hql.append(evidenceEvaluationId);
        proofDTOs = this.getSession().createQuery(hql.toString())
                .setResultTransformer(Transformers.aliasToBean(ProofDTO.class)).list();
    } catch (Exception e) {
        log.error("error = " + e, e);
        //"periscopeexception.list.error", new String[]{
        throw new ScopixException("label.proofPerEvidence", e);
    }
    log.debug("end, result = " + proofDTOs);
    return proofDTOs;
}

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

License:Open Source License

public List<CorporateDTO> getCorporatesForUser(String userName) throws ScopixException {
    log.info("start");
    List<CorporateDTO> list = null;

    StringBuilder sql = new StringBuilder();
    sql.append("select c.id as corporateId, c.NAME as name, c.DESCRIPTION as description");
    sql.append(" from");
    sql.append(" PERISCOPE_USER pu");
    sql.append(", REL_PERISCOPE_USER_CORPORATE rel");
    sql.append(", CORPORATE c");
    sql.append(" where");
    sql.append(" pu.ID = rel.PERISCOPE_USER_ID");
    sql.append(" and rel.CORPORATE_ID = c.ID");
    sql.append(" and pu.NAME = '").append(userName).append("'");
    sql.append(" and c.ACTIVE = TRUE");

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

    log.info("end");
    return list;//  www.  j a v  a2s  . co  m
}