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.nec.harvest.service.impl.PettyCashServiceImpl.java

License:Open Source License

/** {@inheritDoc} */
@Override/*  w  w  w.  j a  va 2s. com*/
public List<PettyCash> findCurrentUpdateNo(String... recordIds) throws ServiceException {
    if (ArrayUtils.isEmpty(recordIds)) {
        throw new IllegalArgumentException("The list of petty cash's Id must not be null or empty");
    }

    final Session session = HibernateSessionManager.getSession();
    Transaction tx = null;

    List<PettyCash> pettyCashes = new ArrayList<PettyCash>();
    try {
        tx = session.beginTransaction();
        Query query = pettyCashRepository
                .getNamedQuery(session, SqlConstants.SQL_FIND_PETTY_CASH_PRESENT_UPDATE_NO)
                .setParameterList("recordIDs", recordIds)
                .setResultTransformer(Transformers.aliasToBean(PettyCash.class));
        pettyCashes = pettyCashRepository.findByQuery(query);
        tx.commit();
    } catch (HibernateException ex) {
        if (tx != null) {
            tx.rollback();
        }
        throw new ServiceException("Hibernate runtime exception occur when get petty cash update number", ex);
    } finally {
        HibernateSessionManager.closeSession(session);
    }
    return pettyCashes;
}

From source file:com.nec.harvest.service.impl.PurchaseServiceImlp.java

License:Open Source License

/** {@inheritDoc} */
@Override//  w  ww. j a  va  2  s  .  c  o  m
@SuppressWarnings("unchecked")
public List<ActualViewBean> findDataBeansByOrgCodeAndMonthly(String orgCode, String monthly, String bunruiKbn)
        throws ServiceException {
    if (StringUtils.isEmpty(orgCode)) {
        throw new IllegalArgumentException("Orginazation's code must not be null or empty");
    }

    if (StringUtils.isEmpty(monthly)) {
        throw new IllegalArgumentException("Month must not be null or empty");
    }

    if (StringUtils.isEmpty(bunruiKbn)) {
        throw new IllegalArgumentException("bunruiKbn must not be null or empty");
    }

    final Session session = HibernateSessionManager.getSession();
    Transaction tx = null;

    List<ActualViewBean> jisekiBeans = new ArrayList<ActualViewBean>();
    try {
        tx = session.beginTransaction();
        Query query = repository.getQuery(session, " SELECT "
                + " a.pk.category.ctgCode as ctgCode, a.pk.category.ctgNameR as ctgNameR, a.kingaku as kingaku, a.updNo as updNo, a.pk.vendor.srsCode as srsCode, a.pk.vendor.srsNameR as srsNameR "
                + " FROM MonthlyPurchase a "
                + " WHERE a.delKbn = :delKbn AND a.pk.organization.strCode = :strCode AND a.pk.getSudo = :getSudo "
                + " AND a.pk.category.bunruiKbn = :bunruiKbn ");
        query.setParameter("strCode", orgCode);
        query.setParameter("getSudo", monthly);
        query.setParameter("delKbn", Constants.STATUS_ACTIVE);
        query.setParameter("bunruiKbn", bunruiKbn);
        query.setResultTransformer(Transformers.aliasToBean(ActualViewBean.class));

        // 
        jisekiBeans = query.list();
        tx.commit();
    } catch (HibernateException ex) {
        if (tx != null) {
            tx.rollback();
        }
        throw new ServiceException("An error occurred while finding the Purchase Data by organization "
                + orgCode + " and monthly " + monthly);
    } finally {
        HibernateSessionManager.closeSession(session);
    }
    return jisekiBeans;
}

From source file:com.nec.harvest.service.impl.SmallCategoryServiceImpl.java

License:Open Source License

/** {@inheritDoc} */
@Override//  w w w  . ja  v  a  2s  .  c  o  m
public List<SmallCategory> findByClassify(String classifyCategory) throws ServiceException {
    if (StringUtils.isEmpty(classifyCategory)) {
        throw new IllegalArgumentException("The category classify must not be empty");
    }

    final Session session = HibernateSessionManager.getSession();
    Transaction tx = null;

    List<SmallCategory> smallCategories = new ArrayList<SmallCategory>();
    try {
        tx = session.beginTransaction();
        Query query = repository.getNamedQuery(session, SqlConstants.SQL_FIND_SMALL_CATEGORY);
        query.setResultTransformer(Transformers.aliasToBean(SmallCategory.class));
        smallCategories = repository.findByQuery(query);

        // Release transaction
        tx.commit();
    } catch (HibernateException ex) {
        if (tx != null) {
            tx.rollback();
        }
        throw new ServiceException(
                "Hibernate runtime exception occur when get small category with its classify "
                        + classifyCategory,
                ex);
    } finally {
        HibernateSessionManager.closeSession(session);
    }
    return smallCategories;
}

From source file:com.necl.core.daoImpl.TicketHeaderDaoImpl.java

@Override
public List<TicketHeader> findMonthYear(int month, int year, String division) throws Exception {

    String sql = "SELECT  ticketNo, ticketType,  applicationDate, detailHeader, reqTotalAmt,applicationName, approvedName1, approvedStatus1, approvedName2, approvedStatus2, ticketsFinished AS ticketFinished FROM tblTicketsH "
            + "WHERE (YEAR(ApplicationDate) = :paramYear) AND (MONTH(ApplicationDate) = :paramMonth) AND (DivisionCode = :division) AND (TicketsFinished != 'D')"
            + "ORDER BY ApplicationDate DESC ";
    Query query = sessionFactory.getCurrentSession().createSQLQuery(sql)
            .addScalar("ticketNo", StringType.INSTANCE).addScalar("ticketType", StringType.INSTANCE)
            .addScalar("applicationDate", CalendarType.INSTANCE).addScalar("detailHeader", StringType.INSTANCE)
            .addScalar("reqTotalAmt", BigDecimalType.INSTANCE).addScalar("applicationName", StringType.INSTANCE)
            .addScalar("approvedName1", StringType.INSTANCE).addScalar("approvedStatus1", BooleanType.INSTANCE)
            .addScalar("approvedName2", StringType.INSTANCE).addScalar("approvedStatus2", BooleanType.INSTANCE)
            .addScalar("ticketFinished", StringType.INSTANCE)
            .setResultTransformer(Transformers.aliasToBean(TicketHeader.class));
    query.setParameter("paramYear", year);
    query.setParameter("paramMonth", month);
    query.setParameter("division", division);
    List results = query.list();/*from   w  w w  .ja v  a  2s . c  o m*/
    return results;
}

From source file:com.necl.core.daoImpl.TicketHeaderDaoImpl.java

@Override
public List<TicketHeader> findFinish() throws Exception {
    String sql = "SELECT ticketNo, ticketType,  applicationDate, detailHeader, applicationName, approvedName1, approvedName2, payment, paidBy FROM   tblTicketsH  WHERE (TicketsFinished = 'F')\n"
            + "ORDER BY ApplicationDate DESC ";
    Query query = sessionFactory.getCurrentSession().createSQLQuery(sql)
            .addScalar("ticketNo", StringType.INSTANCE).addScalar("ticketType", StringType.INSTANCE)
            .addScalar("applicationDate", CalendarType.INSTANCE).addScalar("detailHeader", StringType.INSTANCE)
            .addScalar("applicationName", StringType.INSTANCE).addScalar("approvedName1", StringType.INSTANCE)
            .addScalar("approvedName2", StringType.INSTANCE).addScalar("payment", StringType.INSTANCE)
            .addScalar("paidBy", StringType.INSTANCE)
            .setResultTransformer(Transformers.aliasToBean(TicketHeader.class));

    List results = query.list();//from w w  w  .j a va2 s  .c o m
    return results;
}

From source file:com.necl.core.daoImpl.TicketHeaderDaoImpl.java

@Override
public List<TicketHeader> findFinish(String area) throws Exception {
    String sql = "SELECT ticketNo, ticketType,  applicationDate, detailHeader, applicationName, approvedName1, approvedName2, payment, paidBy \n"
            + "FROM APP_USER LEFT OUTER JOIN\n"
            + "tblMaster_Branch ON APP_USER.branchId = tblMaster_Branch.BranchID RIGHT OUTER JOIN\n"
            + " tblTicketsH ON APP_USER.SSO_ID = tblTicketsH.ApplicationName\n"
            + "WHERE (tblMaster_Branch.Area = '" + area + "') AND (tblTicketsH.TicketsFinished = 'F')\n"
            + "ORDER BY ApplicationDate DESC ";
    Query query = sessionFactory.getCurrentSession().createSQLQuery(sql)
            .addScalar("ticketNo", StringType.INSTANCE).addScalar("ticketType", StringType.INSTANCE)
            .addScalar("applicationDate", CalendarType.INSTANCE).addScalar("detailHeader", StringType.INSTANCE)
            .addScalar("applicationName", StringType.INSTANCE).addScalar("approvedName1", StringType.INSTANCE)
            .addScalar("approvedName2", StringType.INSTANCE).addScalar("payment", StringType.INSTANCE)
            .addScalar("paidBy", StringType.INSTANCE)
            .setResultTransformer(Transformers.aliasToBean(TicketHeader.class));

    List results = query.list();/*from ww  w . j  a  v a 2s . co m*/

    return results;
}

From source file:com.necl.core.daoImpl.TicketHeaderDaoImpl.java

@Override
public List<TicketHeader> findMonthYearArea(int month, int year, String division, String area)
        throws Exception {
    String sql = "SELECT  ticketNo, ticketType,  applicationDate, detailHeader, reqTotalAmt,applicationName, approvedName1, approvedStatus1, approvedName2, approvedStatus2, ticketsFinished AS ticketFinished, paidByAdmin, adminBy \n"
            + "FROM APP_USER LEFT OUTER JOIN\n"
            + "tblMaster_Branch ON APP_USER.branchId = tblMaster_Branch.BranchID RIGHT OUTER JOIN\n"
            + "tblTicketsH ON APP_USER.SSO_ID = tblTicketsH.ApplicationName\n"
            + "WHERE (tblMaster_Branch.Area = '" + area
            + "') AND (YEAR(tblTicketsH.ApplicationDate) = :paramYear) AND (MONTH(tblTicketsH.ApplicationDate) = :paramMonth) AND (tblTicketsH.DivisionCode = :division) AND (tblTicketsH.TicketsFinished != 'D')\n"
            + "ORDER BY ApplicationDate DESC ";
    Query query = sessionFactory.getCurrentSession().createSQLQuery(sql)
            .addScalar("ticketNo", StringType.INSTANCE).addScalar("ticketType", StringType.INSTANCE)
            .addScalar("applicationDate", CalendarType.INSTANCE).addScalar("detailHeader", StringType.INSTANCE)
            .addScalar("reqTotalAmt", BigDecimalType.INSTANCE).addScalar("applicationName", StringType.INSTANCE)
            .addScalar("approvedName1", StringType.INSTANCE).addScalar("approvedStatus1", BooleanType.INSTANCE)
            .addScalar("approvedName2", StringType.INSTANCE).addScalar("approvedStatus2", BooleanType.INSTANCE)
            .addScalar("ticketFinished", StringType.INSTANCE).addScalar("paidByAdmin", BigDecimalType.INSTANCE)
            .addScalar("adminBy", StringType.INSTANCE)
            .setResultTransformer(Transformers.aliasToBean(TicketHeader.class));
    query.setParameter("paramYear", year);
    query.setParameter("paramMonth", month);
    query.setParameter("division", division);
    List results = query.list();/*  ww  w  . j  ava 2s  .  c  o  m*/
    return results;

}

From source file:com.nkapps.billing.dao.BankStatementDaoImpl.java

@Override
public List<BankStatementListPojo> list(HashMap parameters) throws Exception {
    List<BankStatementListPojo> listPojos;
    Session session = getSession();/*from w w  w  .  j ava2  s .  c o m*/

    String whereStr = "";
    if (parameters.get("searchBy") != null && !"".equals(parameters.get("searchBy"))) {
        whereStr += " AND (bs.tin LIKE :searchBy OR bs.name LIKE :searchBy OR bs.mfo LIKE :searchBy"
                + " OR bs.chet LIKE :searchBy OR bs.paymentNum LIKE :searchBy OR bs.paymentDetails LIKE :searchBy ) ";
    }
    if (parameters.get("searchWithinDate") != null && "true".equals(parameters.get("searchWithinDate"))) {
        whereStr += " AND  bs.paymentDate = :searchByDate";
    }
    if (!"".equals(whereStr)) {
        whereStr = " WHERE " + whereStr.substring(whereStr.indexOf("AND") + 3);
    }

    String q = " SELECT bs.id AS id,bs.tin AS tin,bs.name as name,bs.mfo AS mfo,bs.chet AS chet,"
            + " bs.paymentNum AS paymentNum, bs.paymentDate AS paymentDate, bs.paymentSum AS paymentSum,"
            + " bs.paymentDetails AS paymentDetails," + " bs.transfered AS transfered,"
            + " bs.dateUpdated AS dateUpdated" + " FROM BankStatement bs" + whereStr
            + " ORDER BY bs.paymentDate, bs.paymentSum ";
    Query query = session.createQuery(q);
    query.setResultTransformer(Transformers.aliasToBean(BankStatementListPojo.class));

    if (parameters.get("searchBy") != null && !"".equals(parameters.get("searchBy"))) {
        query.setString("searchBy", ("%" + (String) parameters.get("searchBy") + "%").toUpperCase());
    }
    if (parameters.get("searchWithinDate") != null && "true".equals(parameters.get("searchWithinDate"))) {
        query.setParameter("searchByDate",
                new SimpleDateFormat("dd.MM.yyyy").parse((String) parameters.get("searchByDate")));
    }

    Integer start = "".equals((String) parameters.get("start")) ? 0
            : Integer.parseInt((String) parameters.get("start"));
    Integer length = "".equals((String) parameters.get("length")) ? 0
            : Integer.parseInt((String) parameters.get("length"));
    query.setFirstResult(start).setMaxResults(length);

    listPojos = query.list();
    session.close();
    return listPojos;
}

From source file:com.nkapps.billing.dao.BankStatementDaoImpl.java

@Override
public List<PrintClaimPojo> getPrintClaimList(Date periodStart, Date periodEnd) throws Exception {
    Session session = getSession();//w  ww.jav  a2 s  .  c o  m
    String q = " SELECT bs.tin as tin, bs.mfo as mfo," + " bs.chet as chet, bs.paymentNum as paymentNum,"
            + " bs.paymentDate as paymentDate, p.paymentSum as paymentSum,"
            + " bs.paymentDetails as paymentDetails "
            + " FROM BankStatement bs JOIN bs.bankStatementPayments bsp JOIN bsp.id.payment p"
            + " WHERE p.claim = 1 AND bs.paymentDate BETWEEN :periodStart AND :periodEnd "
            + " ORDER BY bs.paymentDate, bs.paymentSum";
    Query query = session.createQuery(q);
    query.setParameter("periodStart", periodStart);
    query.setParameter("periodEnd", periodEnd);
    query.setResultTransformer(Transformers.aliasToBean(PrintClaimPojo.class));
    List<PrintClaimPojo> listPojo = query.list();
    session.close();

    return listPojo;
}

From source file:com.nkapps.billing.dao.BankStatementDaoImpl.java

@Override
public List<PrintRegisterPojo> getPrintRegisterList(Date periodStart, Date periodEnd) throws Exception {
    Session session = getSession();/*from   w w w. j  av a 2  s. com*/
    String q = " SELECT bs.invoiceNum as invoiceNum,"
            + " bs.paymentNum as paymentNum, bs.paymentDate as paymentDate,"
            + " bs.tin as tin, bs.name as name, bs.paymentSum as paymentSum " + " FROM BankStatement bs"
            + " WHERE bs.paymentDate BETWEEN :periodStart AND :periodEnd"
            + " AND bs.tin <> '201589463' AND bs.invoiceNum < 1000000" + " ORDER BY bs.invoiceNum";
    Query query = session.createQuery(q);
    query.setParameter("periodStart", periodStart);
    query.setParameter("periodEnd", periodEnd);
    query.setResultTransformer(Transformers.aliasToBean(PrintRegisterPojo.class));
    List<PrintRegisterPojo> listPojo = query.list();
    session.close();

    return listPojo;
}