Example usage for org.hibernate.criterion Restrictions ge

Introduction

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

Prototype

public static SimpleExpression ge(String propertyName, Object value) 

Source Link

Document

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

Usage

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

License:Open Source License

private double calculateCreditReceipt(Session session, Class transactionClass, Date fromDate, Date toDate,
        User user) {//from  www  .ja v  a2s  . c om
    //cash receipt
    Criteria criteria = session.createCriteria(transactionClass);
    criteria.add(Restrictions.ge(PosTransaction.PROP_TRANSACTION_TIME, fromDate));
    criteria.add(Restrictions.le(PosTransaction.PROP_TRANSACTION_TIME, toDate));
    criteria.add(Restrictions.eq(PosTransaction.PROP_TRANSACTION_TYPE, TransactionType.CREDIT.name()));

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

    criteria.setProjection(Projections.sum(CashTransaction.PROP_AMOUNT));

    return getDoubleAmount(criteria.uniqueResult());
}

---

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

License:Open Source License

private double calculateCashReceipt(Session session, Date fromDate, Date toDate) {
    //cash receipt
    Criteria criteria = session.createCriteria(CashTransaction.class);
    criteria.add(Restrictions.ge(CashTransaction.PROP_TRANSACTION_TIME, fromDate));
    criteria.add(Restrictions.le(CashTransaction.PROP_TRANSACTION_TIME, toDate));
    criteria.add(Restrictions.eq(CashTransaction.PROP_TRANSACTION_TYPE, TransactionType.CREDIT.name()));

    criteria.setProjection(Projections.sum(CashTransaction.PROP_AMOUNT));

    return getDoubleAmount(criteria.uniqueResult());
}

---

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

License:Open Source License

private double calculateCreditCardReceipt(Session session, Date fromDate, Date toDate) {
    //cash receipt
    Criteria criteria = session.createCriteria(CashTransaction.class);
    criteria.add(Restrictions.ge(CreditCardTransaction.PROP_TRANSACTION_TIME, fromDate));
    criteria.add(Restrictions.le(CreditCardTransaction.PROP_TRANSACTION_TIME, toDate));
    criteria.add(Restrictions.eq(CreditCardTransaction.PROP_TRANSACTION_TYPE, TransactionType.CREDIT.name()));

    criteria.setProjection(Projections.sum(CashTransaction.PROP_AMOUNT));

    return getDoubleAmount(criteria.uniqueResult());
}

---

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(/*  w w w  .j  a va2  s .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/*from www. j a  v a 2s  .c  om*/
    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  w w  . j a v  a  2s .  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//from 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 av  a 2s .co  m

    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;//from ww w . jav  a 2 s. com

    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 va2  s  . c  o  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();
        }
    }
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »