Example usage for org.hibernate Query setResultTransformer

List of usage examples for org.hibernate Query setResultTransformer

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.*
  5. Query
  6. setResultTransformer

Introduction

In this page you can find the example usage for org.hibernate Query setResultTransformer.

Prototype

@Deprecated
Query<R> setResultTransformer(ResultTransformer transformer);

Source Link

Document

Set a strategy for handling the query results.

Usage

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

@Override
public List<ReportClickListPojo> getPrintClickList(Date periodStart, Date periodEnd) throws Exception {
    List<ReportClickListPojo> listPojos;
    Session session = getSession();//from   ww  w.j  a v  a2 s  .c om

    String q = " SELECT rc.operationDate as operationDate, bs.paymentDate as bsPaymentDate,"
            + " bs.paymentNum as bsPaymentNum, bs.paymentSum as bsPaymentSum,rc.clickPaymentSum as clickPaymentSum,"
            + " COALESCE(bs.paymentSum,0) - COALESCE(rc.clickPaymentSum,0) as diffSum"
            + " FROM ReportClick rc JOIN rc.reportClickBankStatements rcbs JOIN rcbs.id.bankStatement bs"
            + " WHERE rc.operationDate BETWEEN :periodStart AND :periodEnd "
            + " ORDER BY rc.operationDate DESC ";
    Query query = session.createQuery(q);
    query.setResultTransformer(Transformers.aliasToBean(ReportClickListPojo.class));
    query.setParameter("periodStart", periodStart);
    query.setParameter("periodEnd", periodEnd);

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

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

@Override
public List<ReportSmstListPojo> getSmstList(Map parameters) throws Exception {
    List<ReportSmstListPojo> listPojos;
    Session session = getSession();/*from   w w  w  .  j a v  a  2s  . c  om*/

    String whereStr = "";
    if (parameters.get("searchWithinDate") != null && "true".equals(parameters.get("searchWithinDate"))) {
        whereStr += " AND  rs.operationDate = :searchByDate";
    }
    if (!"".equals(whereStr)) {
        whereStr = " WHERE " + whereStr.substring(whereStr.indexOf("AND") + 3);
    }

    String q = " SELECT rs.operationDate as operationDate, "
            + " (SELECT COALESCE(SUM(bs.paymentSum),0) FROM rs.reportSmstBankStatements rsbs JOIN rsbs.id.bankStatement bs) as bsPaymentSum,"
            + " rs.smstPaymentSum as smstPaymentSum,"
            + " (SELECT COALESCE(SUM(bs.paymentSum),0) FROM rs.reportSmstBankStatements rsbs JOIN rsbs.id.bankStatement bs) - COALESCE(rs.smstPaymentSum,0) as diffSum"
            + " FROM ReportSmst rs " + whereStr + " ORDER BY rs.operationDate DESC ";
    Query query = session.createQuery(q);
    query.setResultTransformer(Transformers.aliasToBean(ReportSmstListPojo.class));

    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.ReportDaoImpl.java

@Override
public List<ReportSmstListPojo> getPrintSmstList(Date periodStart, Date periodEnd) throws Exception {
    List<ReportSmstListPojo> listPojos;
    Session session = getSession();//from   ww  w.  ja  va 2 s  .  co m

    String q = " SELECT rs.operationDate as operationDate,"
            + " (SELECT COALESCE(SUM(bs.paymentSum),0) FROM rs.reportSmstBankStatements rsbs JOIN rsbs.id.bankStatement bs) as bsPaymentSum,"
            + " rs.smstPaymentSum as smstPaymentSum,"
            + " (SELECT COALESCE(SUM(bs.paymentSum),0) FROM rs.reportSmstBankStatements rsbs JOIN rsbs.id.bankStatement bs) - COALESCE(rs.smstPaymentSum,0) as diffSum"
            + " FROM ReportSmst rs " + " WHERE rs.operationDate BETWEEN :periodStart AND :periodEnd "
            + " ORDER BY rs.operationDate DESC ";
    Query query = session.createQuery(q);
    query.setResultTransformer(Transformers.aliasToBean(ReportSmstListPojo.class));
    query.setParameter("periodStart", periodStart);
    query.setParameter("periodEnd", periodEnd);

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

From source file:com.ocare.obook.dao.impl.PatientDaoImpl.java

@SuppressWarnings("unchecked")
@Override/*from   w  w w .  j a v a 2  s. c o m*/
public List<FastPatient> getFastPatientList(final String patientInfo) {
    return getHibernateTemplate().execute(new HibernateCallback<List<FastPatient>>() {
        @Override
        public List<FastPatient> doInHibernate(Session sn) throws HibernateException {
            /// creating Query String
            Query query = sn.createQuery(
                    "select p.id as id , p.fName as fName , p.midName as mName , p.lName as lName , p.code as code "
                            + " , p.phoneNumber1 as phoneNumber from Patient p "
                            + " where p.isDeleted = :deleted and ( p.code like :patientCode or p.fName like :patientFName or p.midName like :PatientMidName "
                            + " or p.lName like :PatientLName or p.phoneNumber1 like :patientPhoneNumber1 or p.phoneNumber2 like :patientPhoneNumber2  "
                            + " ) ");
            query.setString("patientCode", "%" + patientInfo + "%");
            query.setString("patientFName", "%" + patientInfo + "%");
            query.setString("PatientMidName", "%" + patientInfo + "%");
            query.setString("PatientLName", "%" + patientInfo + "%");
            query.setString("patientPhoneNumber1", "%" + patientInfo + "%");
            query.setString("patientPhoneNumber2", "%" + patientInfo + "%");
            query.setBoolean("deleted", false);
            // transform the Returned Results
            List<FastPatient> fastPatientList = query
                    .setResultTransformer(Transformers.aliasToBean(FastPatient.class)).list();
            // return Transformed List
            return fastPatientList;
        }
    });
}

From source file:com.ocare.obook.dao.impl.ReservationDaoImpl.java

@Override
public List<ReportReservationStatus> getReservationStatus(final Integer patientId) {
    return getHibernateTemplate().execute(new HibernateCallback<List<ReportReservationStatus>>() {
        @Override/*w  w  w  .  j a  va2  s  .  co  m*/
        public List<ReportReservationStatus> doInHibernate(Session sn) throws HibernateException {
            Query query = sn.createQuery(
                    "select r.status as statusName , count(r.status) as occuranceNumber from Reservation r inner join r.patient p where p.id=:patientId group by r.status");
            query.setInteger("patientId", patientId);
            List<ReportReservationStatus> reportReservationStatuses = query
                    .setResultTransformer(Transformers.aliasToBean(ReportReservationStatus.class)).list();
            // return reportReservationStatus
            return reportReservationStatuses;
        }
    });
}

From source file:com.ocare.obook.dao.impl.ReservationDaoImpl.java

@Override
public List<ReportReservationStatus> getReservationStatusByDates(final Integer patientId, final Date fromDate,
        final Date toDate) {
    return getHibernateTemplate().execute(new HibernateCallback<List<ReportReservationStatus>>() {
        @Override//ww w . j a  v  a 2 s.  c o  m
        public List<ReportReservationStatus> doInHibernate(Session sn) throws HibernateException {
            Query query = sn.createQuery(
                    "select r.status as statusName , count(r.status) as occuranceNumber from Reservation r inner join r.patient p where p.id=:patientId and r.reservationDate BETWEEN :fromDate AND :toDate group by r.status");
            query.setInteger("patientId", patientId);
            query.setDate("fromDate", fromDate);
            query.setDate("toDate", toDate);
            List<ReportReservationStatus> reportReservationStatuses = query
                    .setResultTransformer(Transformers.aliasToBean(ReportReservationStatus.class)).list();
            // return result List
            return reportReservationStatuses;
        }
    });
}

From source file:com.ocare.obook.dao.impl.ReservationDaoImpl.java

@Override
public List<StatisticReportModule> getTodayReservationReport(final Date today) {
    return getHibernateTemplate().execute(new HibernateCallback<List<StatisticReportModule>>() {
        @Override/*from   w w w. j a va2  s  .  c o m*/
        public List<StatisticReportModule> doInHibernate(Session sn) throws HibernateException {
            Query query = sn.createQuery(
                    "select ex.nameEn as moduleName ,count(ex.nameEn) as occuranceNumber , sum(r.paid) as moduleSum from Reservation r inner join r.examineType ex where r.status =:status and r.reservationDate = :today group by ex.nameEn");
            query.setString("status", "CONFIRMED");
            query.setDate("today", today);
            List<StatisticReportModule> reportReservationStatuses = query
                    .setResultTransformer(Transformers.aliasToBean(StatisticReportModule.class)).list();
            // return result List
            return reportReservationStatuses;
        }
    });
}

From source file:com.ocare.obook.dao.impl.ReservationDaoImpl.java

@Override
public List<StatisticReportModule> getTodayInsurranceReport(final Date today) {
    return getHibernateTemplate().execute(new HibernateCallback<List<StatisticReportModule>>() {
        @Override//from   w  ww.j a  v  a  2  s  . c o  m
        public List<StatisticReportModule> doInHibernate(Session sn) throws HibernateException {
            Query query = sn.createQuery(
                    "select i.nameEn as moduleName ,count(i.nameEn) as occuranceNumber , sum(r.paid) as moduleSum from Reservation r inner join r.patient p inner join p.insuranceCompany i where r.status =:status and r.reservationDate = :today group by i.nameEn");
            query.setString("status", "CONFIRMED");
            query.setDate("today", today);
            List<StatisticReportModule> reportReservationStatuses = query
                    .setResultTransformer(Transformers.aliasToBean(StatisticReportModule.class)).list();
            // return result List
            return reportReservationStatuses;
        }
    });
}

From source file:com.ocare.obook.dao.impl.ReservationDaoImpl.java

@Override
public List<StatisticReportModule> getReservationReportWithRange(final Date fromDate, final Date toDate) {
    return getHibernateTemplate().execute(new HibernateCallback<List<StatisticReportModule>>() {
        @Override/*  w  w  w  .  java  2s  . c o  m*/
        public List<StatisticReportModule> doInHibernate(Session sn) throws HibernateException {
            Query query = sn.createQuery(
                    "select ex.nameEn as moduleName ,count(ex.nameEn) as occuranceNumber , sum(r.paid) as moduleSum from Reservation r inner join r.examineType ex where r.status =:status and r.reservationDate BETWEEN :fromDate AND :toDate group by ex.nameEn");
            query.setString("status", "CONFIRMED");
            query.setDate("fromDate", fromDate);
            query.setDate("toDate", toDate);
            List<StatisticReportModule> reportReservationStatuses = query
                    .setResultTransformer(Transformers.aliasToBean(StatisticReportModule.class)).list();
            // return result List
            return reportReservationStatuses;
        }
    });
}

From source file:com.ocare.obook.dao.impl.ReservationDaoImpl.java

@Override
public List<StatisticReportModule> getInsuranceReportWithRange(final Date fromDate, final Date toDate) {
    return getHibernateTemplate().execute(new HibernateCallback<List<StatisticReportModule>>() {
        @Override//from w  w w  .j a  v a 2  s  .c o m
        public List<StatisticReportModule> doInHibernate(Session sn) throws HibernateException {
            Query query = sn.createQuery(
                    "select i.nameEn as moduleName ,count(i.nameEn) as occuranceNumber , sum(r.paid) as moduleSum from Reservation r inner join r.patient p inner join p.insuranceCompany i where r.status =:status and r.reservationDate BETWEEN :fromDate AND :toDate group by i.nameEn");
            query.setString("status", "CONFIRMED");
            query.setDate("fromDate", fromDate);
            query.setDate("toDate", toDate);
            List<StatisticReportModule> reportReservationStatuses = query
                    .setResultTransformer(Transformers.aliasToBean(StatisticReportModule.class)).list();
            // return result List
            return reportReservationStatuses;
        }
    });
}