Example usage for org.hibernate.criterion Restrictions le

List of usage examples for org.hibernate.criterion Restrictions le

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. Restrictions
  6. le

Introduction

In this page you can find the example usage for org.hibernate.criterion Restrictions le.

Prototype

public static SimpleExpression le(String propertyName, Object value)

Source Link

Document

Apply a "less than or equal" constraint to the named property

Usage

From source file:com.floreantpos.report.service.ReportService.java

License:Open Source License

private double calculateGiftCertSoldAmount(Session session, Date fromDate, Date toDate) {
    //cash receipt
    Criteria criteria = session.createCriteria(GiftCertificateTransaction.class);
    criteria.add(Restrictions.ge(GiftCertificateTransaction.PROP_TRANSACTION_TIME, fromDate));
    criteria.add(Restrictions.le(GiftCertificateTransaction.PROP_TRANSACTION_TIME, toDate));
    criteria.add(// ww w.j  a  v a2s .c o m
            Restrictions.eq(GiftCertificateTransaction.PROP_TRANSACTION_TYPE, TransactionType.CREDIT.name()));

    criteria.setProjection(Projections.sum(GiftCertificateTransaction.PROP_GIFT_CERT_FACE_VALUE));

    return getDoubleAmount(criteria.uniqueResult());
}

From source file:com.floreantpos.report.service.ReportService.java

License:Open Source License

private double calculateTips(Session session, Date fromDate, Date toDate, User user) {
    //tips//  w  w w.  j  a  va 2  s. c  o m
    Criteria criteria = session.createCriteria(Ticket.class);
    criteria.createAlias(Ticket.PROP_GRATUITY, "g"); //$NON-NLS-1$
    criteria.add(Restrictions.ge(Ticket.PROP_CREATE_DATE, fromDate));
    criteria.add(Restrictions.le(Ticket.PROP_CREATE_DATE, toDate));

    if (user != null) {
        criteria.add(Restrictions.eq(Ticket.PROP_OWNER, user));
    }
    //FIXME: HOW ABOUT TIPS ON VOID OR REFUNDED TICKET?

    //criteria.add(Restrictions.eq(Ticket.PROP_VOIDED, Boolean.FALSE));
    //criteria.add(Restrictions.eq(Ticket.PROP_REFUNDED, Boolean.FALSE));

    criteria.setProjection(Projections.sum("g." + Gratuity.PROP_AMOUNT)); //$NON-NLS-1$

    return getDoubleAmount(criteria.uniqueResult());
}

From source file:com.floreantpos.report.service.ReportService.java

License:Open Source License

private double calculateDiscount(Session session, Date fromDate, Date toDate, User user) {
    //discounts/*  w  ww.  j a v a 2  s  .c om*/
    Criteria criteria = session.createCriteria(Ticket.class);
    criteria.add(Restrictions.ge(Ticket.PROP_CREATE_DATE, fromDate));
    criteria.add(Restrictions.le(Ticket.PROP_CREATE_DATE, toDate));
    criteria.add(Restrictions.eq(Ticket.PROP_VOIDED, Boolean.FALSE));
    criteria.add(Restrictions.eq(Ticket.PROP_REFUNDED, Boolean.FALSE));

    if (user != null) {
        criteria.add(Restrictions.eq(Ticket.PROP_OWNER, user));
    }

    criteria.setProjection(Projections.sum(Ticket.PROP_DISCOUNT_AMOUNT));

    return getDoubleAmount(criteria.uniqueResult());
}

From source file:com.floreantpos.report.service.ReportService.java

License:Open Source License

private double calculateTax(Session session, Date fromDate, Date toDate, User user) {
    //discounts//  w w w  . j  a va 2  s . c  o  m
    Criteria criteria = session.createCriteria(Ticket.class);
    criteria.add(Restrictions.ge(Ticket.PROP_CREATE_DATE, fromDate));
    criteria.add(Restrictions.le(Ticket.PROP_CREATE_DATE, toDate));
    criteria.add(Restrictions.eq(Ticket.PROP_VOIDED, Boolean.FALSE));
    criteria.add(Restrictions.eq(Ticket.PROP_REFUNDED, Boolean.FALSE));

    if (user != null) {
        criteria.add(Restrictions.eq(Ticket.PROP_OWNER, user));
    }

    criteria.setProjection(Projections.sum(Ticket.PROP_TAX_AMOUNT));

    return getDoubleAmount(criteria.uniqueResult());
}

From source file:com.floreantpos.report.service.ReportService.java

License:Open Source License

private double calculateGrossSales(Session session, Date fromDate, Date toDate, User user,
        boolean taxableSales) {
    Criteria criteria = session.createCriteria(Ticket.class);
    criteria.add(Restrictions.ge(Ticket.PROP_CREATE_DATE, fromDate));
    criteria.add(Restrictions.le(Ticket.PROP_CREATE_DATE, toDate));
    criteria.add(Restrictions.eq(Ticket.PROP_VOIDED, Boolean.FALSE));
    criteria.add(Restrictions.eq(Ticket.PROP_REFUNDED, Boolean.FALSE));

    if (user != null) {
        criteria.add(Restrictions.eq(Ticket.PROP_OWNER, user));
    }//from  w w w  . j a  v  a2s  . c om

    criteria.add(Restrictions.eq(Ticket.PROP_TAX_EXEMPT, Boolean.valueOf(!taxableSales)));

    criteria.setProjection(Projections.sum(Ticket.PROP_SUBTOTAL_AMOUNT));

    return getDoubleAmount(criteria.uniqueResult());
}

From source file:com.floreantpos.report.service.ReportService.java

License:Open Source License

public SalesExceptionReport getSalesExceptionReport(Date fromDate, Date toDate) {
    GenericDAO dao = new GenericDAO();
    SalesExceptionReport report = new SalesExceptionReport();
    Session session = null;//w w  w  .  ja v a  2s  .  c o  m

    report.setFromDate(fromDate);
    report.setToDate(toDate);
    report.setReportTime(new Date());
    try {

        session = dao.getSession();

        //gross taxable sales

        //void tickets
        Criteria criteria = session.createCriteria(Ticket.class);
        criteria.add(Restrictions.ge(Ticket.PROP_CREATE_DATE, fromDate));
        criteria.add(Restrictions.le(Ticket.PROP_CREATE_DATE, toDate));
        criteria.add(Restrictions.eq(Ticket.PROP_VOIDED, Boolean.TRUE));

        List list = criteria.list();
        for (Iterator iter = list.iterator(); iter.hasNext();) {
            Ticket ticket = (Ticket) iter.next();
            report.addVoidToVoidData(ticket);
        }

        //discounts
        criteria = session.createCriteria(Ticket.class);
        criteria.add(Restrictions.ge(Ticket.PROP_CREATE_DATE, fromDate));
        criteria.add(Restrictions.le(Ticket.PROP_CREATE_DATE, toDate));
        criteria.add(Restrictions.eq(Ticket.PROP_VOIDED, Boolean.FALSE));
        criteria.add(Restrictions.eq(Ticket.PROP_REFUNDED, Boolean.FALSE));

        list = criteria.list();
        for (Iterator iter = list.iterator(); iter.hasNext();) {
            Ticket ticket = (Ticket) iter.next();
            report.addDiscountData(ticket);
        }

        //find all valid discounts
        DiscountDAO discountDAO = new DiscountDAO();
        List<Discount> availableCoupons = discountDAO.getValidCoupons();
        report.addEmptyDiscounts(availableCoupons);

        return report;
    } finally {
        if (session != null) {
            session.close();
        }
    }
}

From source file:com.floreantpos.report.service.ReportService.java

License:Open Source License

public SalesDetailedReport getSalesDetailedReport(Date fromDate, Date toDate) {
    GenericDAO dao = new GenericDAO();
    SalesDetailedReport report = new SalesDetailedReport();
    Session session = null;/*from   w w w  .  ja v  a 2s  .co m*/

    report.setFromDate(fromDate);
    report.setToDate(toDate);
    report.setReportTime(new Date());
    try {

        session = dao.getSession();

        Criteria criteria = session.createCriteria(DrawerPullReport.class);
        criteria.add(Restrictions.ge(DrawerPullReport.PROP_REPORT_TIME, fromDate));
        criteria.add(Restrictions.le(DrawerPullReport.PROP_REPORT_TIME, toDate));
        List list = criteria.list();
        for (Iterator iter = list.iterator(); iter.hasNext();) {
            DrawerPullReport drawerPullReport = (DrawerPullReport) iter.next();
            DrawerPullData data = new DrawerPullData();
            data.setDrawerPullId(drawerPullReport.getId());
            data.setTicketCount(drawerPullReport.getTicketCount());
            data.setIdealAmount(drawerPullReport.getDrawerAccountable());
            data.setActualAmount(drawerPullReport.getCashToDeposit());
            data.setVarinceAmount(
                    drawerPullReport.getDrawerAccountable() - drawerPullReport.getCashToDeposit());
            report.addDrawerPullData(data);
        }

        criteria = session.createCriteria(CreditCardTransaction.class);
        criteria.add(Restrictions.ge(CreditCardTransaction.PROP_TRANSACTION_TIME, fromDate));
        criteria.add(Restrictions.le(CreditCardTransaction.PROP_TRANSACTION_TIME, toDate));
        list = criteria.list();

        for (Iterator iter = list.iterator(); iter.hasNext();) {
            CreditCardTransaction t = (CreditCardTransaction) iter.next();
            report.addCreditCardData(t);
        }

        criteria = session.createCriteria(DebitCardTransaction.class);
        criteria.add(Restrictions.ge(DebitCardTransaction.PROP_TRANSACTION_TIME, fromDate));
        criteria.add(Restrictions.le(DebitCardTransaction.PROP_TRANSACTION_TIME, toDate));
        list = criteria.list();

        for (Iterator iter = list.iterator(); iter.hasNext();) {
            DebitCardTransaction t = (DebitCardTransaction) iter.next();
            report.addCreditCardData(t);
        }

        criteria = session.createCriteria(GiftCertificateTransaction.class);
        criteria.add(Restrictions.ge(GiftCertificateTransaction.PROP_TRANSACTION_TIME, fromDate));
        criteria.add(Restrictions.le(GiftCertificateTransaction.PROP_TRANSACTION_TIME, toDate));
        ProjectionList projectionList = Projections.projectionList();
        projectionList.add(Projections.rowCount());
        projectionList.add(Projections.sum(GiftCertificateTransaction.PROP_AMOUNT));
        criteria.setProjection(projectionList);
        Object[] object = (Object[]) criteria.uniqueResult();
        if (object != null && object.length > 0 && object[0] instanceof Number) {
            report.setGiftCertReturnCount(((Number) object[0]).intValue());
        }
        if (object != null && object.length > 1 && object[1] instanceof Number) {
            report.setGiftCertReturnAmount(((Number) object[1]).doubleValue());
        }

        criteria = session.createCriteria(GiftCertificateTransaction.class);
        criteria.add(Restrictions.ge(GiftCertificateTransaction.PROP_TRANSACTION_TIME, fromDate));
        criteria.add(Restrictions.le(GiftCertificateTransaction.PROP_TRANSACTION_TIME, toDate));
        criteria.add(
                Restrictions.gt(GiftCertificateTransaction.PROP_GIFT_CERT_CASH_BACK_AMOUNT, Double.valueOf(0)));
        projectionList = Projections.projectionList();
        projectionList.add(Projections.rowCount());
        projectionList.add(Projections.sum(GiftCertificateTransaction.PROP_GIFT_CERT_CASH_BACK_AMOUNT));
        criteria.setProjection(projectionList);
        object = (Object[]) criteria.uniqueResult();
        if (object != null && object.length > 0 && object[0] instanceof Number) {
            report.setGiftCertChangeCount(((Number) object[0]).intValue());
        }
        if (object != null && object.length > 1 && object[1] instanceof Number) {
            report.setGiftCertChangeAmount(((Number) object[1]).doubleValue());
        }

        criteria = session.createCriteria(Ticket.class);
        criteria.createAlias(Ticket.PROP_GRATUITY, "g"); //$NON-NLS-1$
        criteria.add(Restrictions.ge(Ticket.PROP_CREATE_DATE, fromDate));
        criteria.add(Restrictions.le(Ticket.PROP_CREATE_DATE, toDate));
        criteria.add(Restrictions.gt("g." + Gratuity.PROP_AMOUNT, Double.valueOf(0))); //$NON-NLS-1$
        projectionList = Projections.projectionList();
        projectionList.add(Projections.rowCount());
        projectionList.add(Projections.sum("g." + Gratuity.PROP_AMOUNT)); //$NON-NLS-1$
        criteria.setProjection(projectionList);
        object = (Object[]) criteria.uniqueResult();
        if (object != null && object.length > 0 && object[0] instanceof Number) {
            report.setTipsCount(((Number) object[0]).intValue());
        }
        if (object != null && object.length > 1 && object[1] instanceof Number) {
            report.setChargedTips(((Number) object[1]).doubleValue());
        }

        criteria = session.createCriteria(Ticket.class);
        criteria.createAlias(Ticket.PROP_GRATUITY, "g"); //$NON-NLS-1$
        criteria.add(Restrictions.ge(Ticket.PROP_CREATE_DATE, fromDate));
        criteria.add(Restrictions.le(Ticket.PROP_CREATE_DATE, toDate));
        criteria.add(Restrictions.gt("g." + Gratuity.PROP_AMOUNT, Double.valueOf(0))); //$NON-NLS-1$
        criteria.add(Restrictions.gt("g." + Gratuity.PROP_PAID, Boolean.TRUE)); //$NON-NLS-1$
        projectionList = Projections.projectionList();
        projectionList.add(Projections.sum("g." + Gratuity.PROP_AMOUNT)); //$NON-NLS-1$
        criteria.setProjection(projectionList);
        object = (Object[]) criteria.uniqueResult();
        if (object != null && object.length > 0 && object[0] instanceof Number) {
            report.setTipsPaid(((Number) object[0]).doubleValue());
        }

        return report;
    } finally {
        if (session != null) {
            session.close();
        }
    }
}

From source file:com.globalsight.everest.webapp.pagehandler.administration.reports.JobAttributeReportHelper.java

License:Apache License

private void initDate() {
    totalCells = new TreeMap<Integer, List<Integer>>();

    Session session = HibernateUtil.getSession();
    Criteria c = session.createCriteria(JobImpl.class);
    c.add(Restrictions.in("createUserId", submitIds));
    c.add(Restrictions.in("state", status));

    if (startDate != null) {
        c.add(Restrictions.gt("createDate", startDate));
    }/*  www .  java 2  s .  com*/

    if (endDate != null) {
        c.add(Restrictions.le("createDate", endDate));
    }

    jobAttributes = c.list();

    for (int i = jobAttributes.size() - 1; i >= 0; i--) {
        JobImpl job = jobAttributes.get(i);
        long projectId = job.getL10nProfile().getProject().getId();
        if (projectIds.indexOf(projectId) < 0) {
            jobAttributes.remove(i);
            continue;
        }

        boolean found = false;
        for (Workflow w : job.getWorkflows()) {
            String targetLang = Long.toString(w.getTargetLocale().getId());
            if (trgLocaleList.contains(targetLang)) {
                found = true;
                break;
            }
        }
        if (!found) {
            jobAttributes.remove(i);
            continue;
        }
    }

    SortUtil.sort(jobAttributes, getComparator());
}

From source file:com.google.api.ads.adwords.jaxws.extensions.report.model.persistence.sql.SqlReportEntitiesPersister.java

License:Open Source License

/**
 * Gets the entity list for the given report class and with the given date range.
 *///w ww. ja  v a  2 s . c om
@Override
@Transactional(readOnly = true)
@SuppressWarnings("unchecked")
public <T> List<T> get(Class<T> clazz, String key, Object value, String dateKey, Date dateStart, Date dateEnd) {

    Criteria criteria = this.createCriteria(clazz);
    if (key != null) {
        criteria.add(Restrictions.eq(key, value));
    }
    criteria.add(Restrictions.ge(dateKey, dateStart));
    criteria.add(Restrictions.le(dateKey, dateEnd));
    return criteria.list();
}

From source file:com.google.api.ads.adwords.jaxws.extensions.report.model.persistence.sql.SqlReportEntitiesPersister.java

License:Open Source License

/**
 * Gets the entity list for the given report class and key the given range.
 *///from w w  w  . j ava 2  s. c  om
@Override
@Transactional(readOnly = true)
@SuppressWarnings("unchecked")
public <T> List<T> get(Class<T> clazz, String key, Object value, String dateKey, String dateStart,
        String dateEnd) {

    Criteria criteria = this.createCriteria(clazz);
    if (key != null) {
        criteria.add(Restrictions.eq(key, value));
    }
    criteria.add(Restrictions.ge(dateKey, dateStart));
    criteria.add(Restrictions.le(dateKey, dateEnd));
    return criteria.list();
}